f row contain integer value then column name not coming while reading .csv file using ObjOLEDBConnection
f row contain integer value then column name not coming while reading .csv file using ObjOLEDBConnection ...
csv
how to retrive column name alone from db to data table
how to retrive column name alone from db to data table ...
Simple csv reader?
all, I started out with what i thought was going to be a pretty simple task. (convert a csv to "wiki" format) but im hitting a few snags that im having trouble working through I have 3 main problems 1) some of the cells contain \r\n ( so when reading line by line this treats each new line as a new cell 2) some of the rows contain "...
Need to apply double quotes around every value of csv file
I have a csv file that I need EVERY column wrapped in quotes. How do I change that using regex? I am using my text editor to do the find/replace w/ regular expression (textmate) example csv: bear,brown,mean,large ant,black,strong,tiny cat,yellow,moody,small ...
parse a CSV, update a field, then save
I have everything working fine except saving my changes to the field im updating: require 'csv' @parsed_file = CSV::Reader.parse(File.open("#{RAILS_ROOT}/doc/some.csv")) @parsed_file.each_with_index do |row, x| address = row[5] l = Location.address_find(address) if l != nil puts "#{l.name} at #{l.address}" row[14] = l.sto...
help needed with magento product import products wont show up in catalog after import
I asked a similar question a couple days ago and didn't get any answers that solved my problem (http://stackoverflow.com/questions/3543992/after-importing-products-into-magento-they-dont-show-up-catalog) Ive tried everything to get this to work i feel like its something trivial im missing. I have used magento before and never had any...
HSQLDB: weird "unique constraint or index violation" with data read from CSV
Hi, I have a tool which reads a CSV file, selects from it using HSQLDB, and saves the result as another CSV file. More here: http://ondra.zizka.cz/stranky/programovani/java/apps/CsvCruncher-csv-manipulation-sql.texy Now when I used it for some task, I have got: java -jar CsvCruncher-1.0.jar result.csv foo.csv 'SELECT * FROM indata' I...
SQL Server BCP only one row inserted?
I'm using an FMT file to BCP a csv file into a an SQL Server Box - everything is fine, but only the first row of the 5 line file is getting inserted. I think it is the line feed settings for the terminator of the final column - but how do I view and edit the line feeds in the csv file? ...
How do you directly write to a request body in Python
I am currently implementing code to call out to an API where the post request body needs to contain several columns of data in csv format. e.g. Col1, Col2, Col3 1, 2, 3 4, 5, 6 etc, with the content type header is set to 'text/csv' How do I directly write to the request body? I have a coworker who is doing the same thing as I am...
sas: csv file has spaces before the comma but outside the quotes
A csv file I am trying to read with SAS has spaces between fields with double quotes. example: "ok","bad spaces ahead" ,"more data" _______________________^spaces^____________ How do I get SAS to read this correctly? Do I need to have the csv replaced? ...
Import CSV contacts to Public Folders
I am trying to import a CSV file containing many contacts to a public folder in exchange 2007 installed on SBS2008 for use by outlook users. I have this script that I am trying to run through powershell 1.0 (there seems to be no powershell 2.0 installable for SBS2008). I have created a folder in the Public Folder area called pub_contac...
.net using xml for mapping csv to class
I have a Task where I have to read an csv file and write the content into a c# List. Since the csv file can change its layout (caption/order) in the future I want to use a configuration file for mapping the attributes. Now I am wondering if there is an example out there so I don't have to reinvent the weel :D My datasource looks like t...
Removing any (first, middle, last, single) item in a CSV list via PHP's explode / implode
$pieces = explode(",", $userList); $key=array_search($deleteuser, $pieces); if(FALSE !== $key) { unset($pieces[$key]); } else return FALSE; $userList = implode(",", $pieces); I'm looking for inputs into how to rework this code to remove an element from a CSV list. The user should exist in this system and it should work fine e...
how to load a sectioned CSV file to an excel sheet?
CSV file: #3GMACRO,,,,,,,,,,,,,, ,,,,,,,,,,,,,, IMSI,IMEI,Date,Time,UMTS MACRO-UARFCNDL,UMTS MACRO-PrimaryScramblingCode,UMTS MACRO-CPICHTxPower,UMTS MACRO-PLMNCellId,UMTS MACRO- RNCId,UMTS MACRO-MCC,UMTS MACRO-MNC,UMTS MACRO - LAC,UMTS MACRO - RAC,UMTS MACRO - MaxUETxPower,UMTS MACRO - MeasuredRSCP 2.6275E+14,3.57539E+14,20100107,16000...
How to populate a series of checkboxes from a hidden csv field using jQuery
I have a form with a bunch of checkboxes, and a hidden field that contains CSV data. Basically, I need the checkboxes to be ticked based on the value of the hidden field: <form> <input type="checkbox" id="01" name="01" /> <input type="checkbox" id="02" name="02" /> <input type="checkbox" id="03" name="03" /> <input typ...
Outlook CSV to MySQL PHP Class
I was wondering if anyone has come across a solid pre-built class for PHP to work with MS Outlook. To have the ability to TAKE a CSV file and import it into a MySQL Database, and also do the reverse export from the database into a solid CSV file to import into Outlook. If someone has come across something like this, could you possibly s...
php csv - print non ascii characters
Hi! I'm trying to create a CSV file using php. How can I print non ascii charaters? Thanks in advance, Best regards! ...
How to update SQL table with CSV data?
I am trying to update one of my SQL tables with new columns in my source CSV file. These CSV records in this file are already in my SQL table, but they are lacking some of the columns from this CSV file. I already added the new columns to my SQL table. But now I just need to import the data from the new columns. How can I do this b...
reading csv file in php
Hi I want to read a csv file line by line. i have written code but it give output in encrypted manner . my code is $row = 1; $handle = fopen($_FILES['csv']['tmp_name'], "r"); while (($data = fgetcsv($handle, 1000,",")) != FALSE) { $num = count($data); echo "<p> $num fields in line $row: <br /></p>\n"; $row++; ...
Updating a SQL table with CSV data?
I am trying to update one of my SQL tables with new columns in my source CSV file. The CSV records in this file are already in this SQL table, but this SQL table is lacking some of the new columns from this CSV file. I already added the new columns to my SQL table structure via ALTER TABLE. But now I just need to import the data from t...