Converting Gridview into CSV
Is this possible to take delimeter other than comma for converting into CSV file....because in my scenario my gridview cell contains data with commas. ...
csv
Asp.net export to csv and culture
I'm exporting data to a csv file using Asp.net and I need to know from the System.Globalization.CultureInfo.CurrentCulture if I should use "," or ";" as a value separator. For example US needs "," and Europe needs ";". How can I find out which one to use from the CurrentCulture? Thanks! ...
Import CSV within SQL Server 2008 Management console
I'm trying to import a CSV file within the SQL Server Management console. The CSV is comma delimited. I have some columns that has a comma within double quotes, it seems that SQL Server splits the value in 2 columns. How can I solve this? I hope you can understand what I mean. Thanks in advance. ...
Parsing a CSV File In JSP
I am creating a webApp that will download some data from Yahoo Finance into a CSV file and then (hopefully) be able to then read the created CSV data into a HTML table. I have successfully got the program to connect to the Yahoo feed and then download that data into a CSV file and would not like to use the data from the file into a tabl...
Filebased data service in Java
I've found numerous posts about reading CSV with Java and the APIs they were pointing at all had a line-oriented approach when it came to reading a CSV file. Something like "while you get a line, get the values of every column". Are there better ways to do that? Thanks for any suggestions! ...
Export more than 2000 values with displaytag's export function
Does displaytag have a max export value set somewhere. I'm using displaytag with spring 2.5 and ibatis. There are some pages that come back with more than 2000 results but when I click export only 1999 values show up in the csv. What am I missing? ...
Pytables vs. CSV for files that are not very large
Hello All, I recently came across Pytables and find it to be very cool. It is clear that they are superior to a csv format for very large data sets. I am running some simulations using python. The output is not so large, say 200 columns and 2000 rows. If someone has experience with both, can you suggest which format would be more conv...
Most efficient way of bulk loading unnormalized dataset into PostgreSQL?
I have loaded a huge CSV dataset -- Eclipse's Filtered Usage Data using PostgreSQL's COPY, and it's taking a huge amount of space because it's not normalized: three of the TEXT columns is much more efficiently refactored into separate tables, to be referenced from the main table with foreign key columns. My question is: is it faster to ...
Creating carriage returns in csv cell via php
I'm trying to dynamically generate a csv file with some cells that will contain multiple lines, the address field for example will need to be grouped into a single "address" cell instead of address,city,state etc. All is going well and but for the last two days i've tried to insert \r, \r\n, \n, chr(10),chr(13), as well as a carriage ret...
Iterating over a List of Strings In Java?
I am using OpenCSV to read data from a CSV file and am using some of the sample code from the homepage: CSVReader reader = new CSVReader(new FileReader("stockInfo.csv")); List myEntries = reader.readAll(); And i am now trying to loop through this list and print out each entry. But i cannot seem to figure out the code to perform this. ...
Import Uni-code formated text in CSV file using php
I want to import some data to a .CSV file. Some of the field contents are uni-code formated. But when I save .CSV file, it doesn't put them in orginal format. it keeps them using some special character. For what when I import the same .CSV file to database it can't read the uni-code formated data. Anyone can help me, if have a right a...
Where in my application belong the DTO's that are used to export and import in structured format?
Our users need to be able to export data in CSV format, edit some of the records, and upload the data again. The data does not map to entities, you could say that the object graph is flattened to fit in the Excel-based workflow. Right now this happens in the controllers because I thought these DTO classes were view models. It smells but...
Use Google Datasource to import Google Spreadsheets
I am trying to integrate a google spreadsheet into a google visualization using google datasource. The code that I am trying to execute is below. I am not getting an error alert or anything to output from this script. <script type='text/javascript'> google.load("visualization", "1", {packages:["corechart"]}); google.setOnLoadC...
Import txt file from web form to sqlserver database using vbscript
Hi, I have been asked to build a web application to report on information stored in another system. The other system is locked down but will allow me to export data as a csv file. I'd like to use an html form on my application so that people (the night shift!) can import data from the other system to my web application. To allow oth...
Convert XML to CSV using XSLT
How to convert XML to CSV (to be shown in Excel file) using XSLT? Provided XML value itself contains comma, e.g. <name>The,Bad Boy</name> My logic considers "The" & "Bad boy" as separate values as it goes in different columns after opening in Excel file. ...
Getting Entity data from Autocad
This is a two part question. 1) Is there any way to get a csv file of all the entity data, including xdata, for an autocad dwg, either using autocad or some other method? 2) Is there an easy way to parse a autocad dxf file to get the entity data into a csv file? ...
XSL: translate() with html in replacing string
Hi, I have an xml document that looks like this. <?xml version="1.0"?> <services> <service sn="1" family="2 Week Wait"> <service_name>2 Week Wait Dermatology</service_name> <speciality>2 Week Wait</speciality> <clinic_types>2 Week Wait Skin</clinic_types> <tag>Malignant neoplasm of skin , Pigmented skin lesion </tag...
Open file in universal-newline mode when using pkg_resources?
Hi - I am processing a CSV file and have the following working code: reader = csv.reader(open(filename, 'rU'), dialect='excel') header = reader.next() However, to be compatible with elsewhere in the codebase, I need to use a file object using pkg_resources.resource_stream, as follows: fileobj = pkg_resources.resource_stream('foo', 't...
Has anyone developed a dynamic database file extract system?
We create a lot of console apps, ssis packages to extract data from our database to be used in downstream applications. Some are excel files, some are CSV files. What i'm looking to do is build a dynamic, configurable extract engine that I can customize what elements the group wants and have those files extracted. Has anyone solved th...
CSV only taking first record
I have been working on my CSV upload for a little while now, and I finally got it working (sort of haha) As it stands right now, my code will only pull the first record from the CSV file, and I have been looking at it too long, and Im sure I am missing something. Here is my views.py @login_required def importClient(request): print "i...