Hi! Is it possible to have multiple values under the same field in a .CSV file? Lets say I have a "email" field on my webpage, and the user may optionally type in multiple addresses. Then I want my .csv file to be able to handle a unknown number of "email" values. How can i achieve this? The .csv is read by a third party program which ...
We have a number of Scala classes returning Map[String,String] (key,value) results for storage in a NoSQL database. Some of the results are actually Map[String, List] or Map[String, ArrayBuffer], so we are using .toString on those objects to convert. This gives us output that looks like: "ArrayBuffer(1,2,3,4)" or "List(1,2,4)" Rath...
I'm dealing with an application that exports text as as CSV type data. The text is broken up into fields where there was a hard return. I have been trying to use pythons CSV to restore the text. This is an example of the text: {"This is an example", "of what I what I have to deal with. ", "Please pick up th following:", "eggs", "milk...
I'm trying to export matches from preg_match_all to a csv file but am getting the following error: Warning: fputcsv() expects parameter 2 to be array, string given This is the section of code I'm having issues with, how can I modify it so I am able to export the matches to a csv file? preg_match_all($pattern, $pos, $matches); $fp = ...
I've written a script to export product data from a cscart database to a CSV file. It works perfectly, however when opened in MS Excel, it parses things such as "12-14" as dates, which shows "Dec 14". I read http://excel.tips.net/Pages/T003228_Stopping_Date_Parsing_when_Opening_a_CSV_File.html but the client will not be willing to do th...
I intend to build a RESTful service which will return a custom text format. Given my very large volumes of data, XML/JSON is too verbose. I'm looking for a row based text format. CSV is an obvious candidate. I'm however wondering if there isn't something better out there. The only I've found through a bit of research is CTX and Fiel...
Hello, I have a SQL Server 2005 database with two tables: Order, LineItem. Each LineItem has a field called LineItemID and OrderID. I have a query that is getting all of the Order records in my database. With each Order record, I would like to retrieve a comma delimited list of LineItemIDs associated with the Order. Is there a way to d...
I have some VBA code that looks like this and the aim is to query a csv file and bring back some records. However, I want to be able to query the same file (which sits on a network drive) at the same time from two computers. I tried using the readOnly mode but it still doesn't work. Please help? Dim cnt_string As String cnt_strin...
An iPhone app which I am creating generates reports from a Core Data database as a CSV file, which can then be emailed so that the user may use that data elsewhere outside of the app. I would also like to offer the ability to generate the same reports as a PDF file (of course, with nicer formatting) allowing the user to immediately print...
I am attempting to generate a CSV file. Everything is fine except for blank fields, I'm not quite sure have "" instead of actual quotes. I've provided the code I'm using to generate the file and some output. <% headers = ["Username", "Name", "E-mail", "Phone Number"] %> <%= CSV.generate_line headers %> <% @users_before_pagina...
Hello, this has been throwing me off for too long.. Posted below is our Rails 3 controller. When attempting to access with Internet Explorer the first time, the download prompt fails with a "Unable to download" message. When attempting to access the same URL immediately following, the download prompt works successfully. In any instan...
I'm trying to export data from SQL Server into CSV format. I have a bat task to do this that's run at regular intervals. Command is: C:\Program Files\Microsoft SQL Server\[...]\SQLCMD.EXE" -d [db details] -i c:\export.sql -o c:\export.csv -s"," -W The SQL file is just a SELECT * from a view. This works except that some of the rows ...
Hi Could you please guide me or provide me with some sample codes for performing CSV export and import using the PHPExcel library? Excel export and import is fine but I need csv export/import as well. I have other means of CSV export and import but can it be done via phpexcel also? Any kind of help is greatly appreciated. Thanks in ad...
Hello, Python newbie here. I was trying to troubleshoot an issue with writing a csv file in a larger program and decided to go back to basics to try to find the problem. I ran an exact code example from the Python csv reading and writing documention: import csv spamWriter = csv.writer(open('eggs.csv', 'w'), delimiter=' ', quotecha...
Dear friends I have a console application in which i want to first sign in and then I press button which directs me to file upload form .In file upload form I want to upload a csv file and then redirect to next form after clicking submit button then i want to get response of that form . can any one help me to do this from C# console a...
Hello, I would like to convert a csv file to dbf using python (for use in geocoding which is why I need the dbf file) - I can easily do this in stat/transfer or other similar programs but I would like to do as part of my script rather than having to go to an outside program. There appears to be a lot of help questions/answers for conver...
Hi , I have implemented an import functionality which takes data from a csv file in an Asp.Net appication. The file of the size can vary from a few kb's to a max of 10 MB. However when an import occurs and if the file size is > 50000 it takes around 20 MINS . Which is way too much of a time. I need to perform an import for around 30000...
Okay, I'm having some serious issues here. I'm new to this site, and new to dealing with importing CSV data via PHP, but I'm not new to programming. Currently, I'm working on building a Customer Relationship Manager. I need to create a script to import a file that will populate the database with leads. The main issue here is that the Le...
I've set up my app.yaml and data_uploader files as suggested in this document. My CSV file has some null values (the spreadsheet that I exported had some empty cells). When I run the script, I get this error in the log file: [ERROR ] Error in WorkerThread-0: Value should not be empty; received []. My guess is that it is because som...
I need to load in a large CSV file (>1MB) and parse it. Generally this is quite easy to do by splitting first on linebreaks and then commas. The problem is though that some entries contain Strings that include their own commas. When this spreadsheet is converted to CSV, the lines containing commas are wrapped in quotes. I've written a ...