194 Topics
|
|
Hi, i am inserting data from CSV file in mysql. I am trying to skip ist row of CSV file as it contains headings. need suggestions?? |
|
How to write in CSV file using PHP script? Actually I was also searching for that too. It is kind of easy task with PHP. fputs(handler, content) - this function works efficiently for me. First you need to open the file in which you need to write content using fopen($CSVFileName, … |
|
I'am trying to undestand how I can use the csv module in python to open a csv file in the same folder as the python script - and then create a .shp (shape file) using the shapefile module pyshp. The csv file looks like this, but can have a couple … |
|
I could reallly use some help. I am a complete newbie in python. What I would like to do is import a csv file (originally an excel file). Have the user pick a beginning month and an ending month and add the columns of the months between. For example I … |
|
Hi, I need to search a particular string in a CSV file ("STPSTR01.134") the line that contains this string. I need to divide the 13th column by the 14th column. Any help would be very much appreciated. I'm using ActivePerl for windows /csv file allAssociationUtilizationData;V16SG;2012/07/27;10:45:00;STPSTR01.134;900;FALSE;SCANNER;10;3471;6288;11093;10419;588480;631296;0;254004;316732;0 allAssociationUtilizationData;V16SG;2012/07/27;10:45:00;STPSTR01.58;900;FALSE;SCANNER;10;20652;23514;39497;29404;4690132;3929776;0;3471992;2947904;0 allAssociationUtilizationData;V16SG;2012/07/27;10:45:00;STPSTR01.60;900;FALSE;SCANNER;10;20593;19351;36274;26039;4350820;3462084;0;3234956;2593056;0 allAssociationUtilizationData;V16SG;2012/07/27;10:45:00;STPSTR01.62;900;FALSE;SCANNER;10;24237;21229;40003;28678;5122408;3703840;0;3875508;2746088;0 allAssociationUtilizationData;V16SG;2012/07/27;10:45:00;STPSTR01.26;900;FALSE;SCANNER;10;18538;20644;35833;26421;4075280;3588768;0;2979124;2707892;0 |
|
i have write a code for making a string that is being read from CSV file. i want to make a string from particular location of each and every line. i have attached a code what i have done.but i want it as it for any number of location. In … |
|
I have problem with writing csv file using **fputcsv**. Its putting the page html also into the csv file. Whats wrong with my code ? //Excel header header("Content-Disposition: attachment; filename=\"Delivery_Reports.csv\";" ); header("Content-type: application/vnd.ms-excel"); $out = fopen("php://output", 'w'); $flag = false; // $result = mysql_query("SELECT * FROM senderids ") or die('Query … |
|
Hi, I have a problem with my code. When I fill the PHP form and submit on the page, I encounter with 2 problems; 1- It writes all 6 input coming from 6 textareas to next line in csv file as I want. But it writes all of them into … |
|
Hello friend, I have a registration form and a admin panel for that, In admin panel we can see the list of registered users. I can filter user details by search but i cannot export searched results to .xls or .csv format. kindly help me...!!! Thank you. |
|
Hi, I have been trying to import the data from a CSV file (10,000 rows) into a database using SQL and PHP <body> <div id="container"> <div id="form"> <?php $user="root"; $database="test"; mysql_connect("localhost",$user); @mysql_select_db($database) or die( "Unable to select database"); //Upload File if (isset($_POST['submit'])) { if (is_uploaded_file($_FILES['filename']['tmp_name'])) { echo "<h1>" . "File … |
|
Trying to figure out the best way to do create a CSV export file from my source files and need some input. I'm trying to build a CSV export file for import to an Accounting System where there are 3 different tables mapped to a single field in the main … |
|
Hi With the code snippet given in the following post http://www.daniweb.com/web-development/php/threads/126361/csv-file-uploading-into-a-mysql-database I am able to import csv data into phpmyadmin. However, I am getting an error if csv data contains a text with apostrophe (‘) symbol (e.g. my book’s name is abc). Appriciate any suggestions to resolve this error. Thank … |
|
I am working with CSVfile program. I have already calculate something from it. Name,Age,Sex,Pincode,Disease 1. aaa,4,M,35265,flu 2. bbb,4,M,35652,Gastric 3. eee,6,F,35265,Brain 4. sss,7,M,32564,flu I have made program for calculating no. of age,sex and pincode as attached in the code. In this i have calculated that age=4 comes how many times and … |
|
I have a csv file i am submitting to database directly. I have tried many means but still not able to bulk copy into the database table. I have suggestions from people. All suggestions are welcome. |
|
I have a tab delimited text file with text like this: Wed Jun 13 01:00:19 2012 | error | client xx.xxx.xxx.x | rdy 784 bsy 16 The pipe | signifies that the tab delimiter. I need to convert this into a CSV file using Java. I also need to split … |
|
Situation: need to read a CSV (txt) file that has no header and has 4 fields (all numeric), the number of lines will vary. Sample data: 160827,00003,000000075,0000025 84144,00001,000000050,0000050 161060,00002,000000050,0000025 40015,00002,000000100,0000050 61955,00002,000000100,0000050 etc etc I want to read this file into a DataGridView for proofing and later insert all these lines … |
|
Hello there! I've been trying to import data from csv file to remote postgre database with no luck. Locally i can do it with simple COPY query, but that only works because i'm superuser. \COPY command also works when i run it in psql. So the question is: how can … |
|
I'd like to say "hello" to everyone as it is my first post. I looked for the solution to my problem on the internet for over 2 hours and I didn't find anything relevant. I hope you are able to help me. I have a bunch of invoices written in … |
|
Hi guys, I have some fundamental holes in my understanding of programming, so help would be appreciated, I’ve always had a problem getting my head around it. I don't have a very strong mental model of how the code flows. My main problem is i think i understand the syntax, … |
|
Hello all, nice to know this helpfull forum, I'm a totally newbie and I need advice, I want to import a CSV to a table in sql, but the problem is the CSV has very strange format. ================================== Telephone,=,'88213839 Name,=,John Doe Currency,=,USD Date,Information,Source,Total,,Balance '30/04,ATM 28/04 ,'0000,000000000500000.00,DB,1.171892966E7 '30/04,DEBIT 28/04 LAWSON,'0000,000000000092100.00,DB,1.162682966E7 '30/04,DEBIT … |
|
I have a csv file with the following data: DATA1-1 DATA1-2 DATA1-3 DATA2-1 DATA2-2 DATA2-3 DATA3-1 DATA3-2 DATA3-3 I need to append more data to the file so it will look like this: DATA1-1 DATA1-2 DATA1-3 DATA1-4 DATA1-5 DATA2-1 DATA2-2 DATA2-3 AAAAAAA BBBBBBB DATA3-1 DATA3-2 DATA3-3 AAAAAAA BBBBBBB I have … |
|
Hello friends, I am working an a section of application which needs to Parse CSV Logs generated by PostgreSql server. - The Logs are stored C:\Program Files\PostgreSQL\9.0\data\pg_log - The Server version in 9.0.4 - The application is developed in C Sharp * The basic utility after Parse the Log is … |
|
So I have a number of CSV files with 6 columns of numbers in each file. I would like to perform a few operations (multiplication, division etc.) on each column in each of the CSV files using Python and instead of opening each file manually, I want to add the … |
|
So, I'm doing a test of strtok and my csv reader to fill an array of structs. Each line in the csv has a bunch of country information, and I'm only pulling the 2nd, 3rd, 8th, and 9th fields in each line to make the structs. My biggest problem at … |
|
I have written a small query. I want to create link on my php site which on click will run this script automatically and export results to an excel file. I dont want to create a page to view the results. Any help to this new bie will be very … |
|
[CODE]string[] lines = System.IO.File.ReadAllLines(@"C:\Users\Admin\Desktop\ID.csv"); string sPattern = idBox.Text; foreach (string s in lines) { if (System.Text.RegularExpressions.Regex.IsMatch(s, sPattern, System.Text.RegularExpressions.RegexOptions.IgnoreCase)) { nameLabel.Text = "test success"; } else { nameLabel.Text = "test failure"; } }[/CODE] This is basically what I have so far. I am using Visual C#, which is probably obvious, but … |
|
I am working on a project that requires a CSV file to be read into a multidimensional array. I loop through the array, and set multidimensionalarray[x][n] to the corresponding data in the CSV file, but I keep getting IndexError: list index out of range. I can't figure out why, and … |
|
I am starting to try and manipulate some CSV file data. My first problem is the empty values (empty cells in a spread sheet). My boss sends me these files and when I open the in csv format Python gives me: "Denison, P14, , , , , $1600" I can't … |
|
Hi, Basically I am working on a uni project but I am pretty new to Java. I've been trying to figure out how to do this for days now but just can't get it right. Really need to get it done as the deadline is approaching! I have 3 (large) … |
|
[B]Read a CSV file into a DataGridView[/B] [CODE]'12/4/2011 'Code to read CSV file with headers using 'ACE.OLEDB.12.0 Connection 'The following is a Sampling of <EXTENSION.csv> 'The CSV file contains all the Extension on my Desktop Computer 'The full file has 923 Rows with Headers: 'EXTENSION,DESCRIPTION,EXECUTABLE_PATH '.mde,Microsoft Office Access MDE Database,C:\Program … |
The End.