Posted on: 10/18/06 06:30pm
By: Anon
You may have covered this elsewhere but I couldn't find it.
I had spreadsheets set up in Excel that I wanted to use as the basis for content in the Contacts plug in. After hours messing about getting the data into the right format (all columns identical to the table headings) I then found that it would not let me import the CSV file into my database.
I searched for ages to find something to import CSV into MySQL, then stumbled across
here[*1] - it picks up your csv file off your computer and quickly translates it into MySQL (save as a .txt file) so that you can then run the MySQL command into your database.
This may be of use to someone.
Anon
Re: Useful tool - CSV to MySQL
Posted on: 10/16/07 02:07am
By: Anonymous (Turadg)
Thanks for that! Saved me a bunch of work.
Re: Useful tool - CSV to MySQL
Posted on: 08/21/08 01:34am
By: Anonymous (Philip)
Thank you for your time and trouble .
Should have looked for this earlier. I have been trying to import a CSV for the last 6 hrs :banghead:
Re: Useful tool - CSV to MySQL
Posted on: 09/11/08 06:19am
By: Anonymous (blue)
Great! Thanks :chestslam:
Good topic name, easy to found on google
Regards!
Re: Useful tool - CSV to MySQL
Posted on: 05/27/09 09:24am
By: Anonymous (Alexrus)
DUUUUDE :banana:
THANKS A LOT>.. can;t belive how usefull this was.
Congrats for the post... i'll ship you a 6pack of beer
Re: Useful tool - CSV to MySQL
Posted on: 05/28/09 09:15am
By: Anonymous (ANON)
Thank you so much! Awesome find, saved me a ton of time!
Re: Useful tool - CSV to MySQL
Posted on: 11/06/09 07:47am
By: Anonymous (Pranjal)
Hi,
Thanks a lot.
It rescued me from long sleepless nights.
thanks a lot for sharing.
Re: Useful tool - CSV to MySQL
Posted on: 11/10/09 02:02pm
By: Anonymous (irelandsnexttopmodel)
any other "csv2mysql" or "xls2mysql" freeware-tool that you know of?
my file is larger than 2MB
thx
Re: Useful tool - CSV to MySQL
Posted on: 11/21/09 05:09pm
By: MoneyTopList
I use for such cases software called BK ReplaceEM. It can replace some part of the text by another parts. Sure, if you found something special which converts CSV to MySQL it is better, however, many people often need similar changes and it may be easier to do it with such software than spending a lot of time by searching for something special.
Re: Useful tool - CSV to MySQL
Posted on: 12/08/09 01:35pm
By: Anonymous (Tom)
Holy crap that is awesome. saved me soooo much time.
BTW captcha on this site SUCKS. makes some better images.
Re: Useful tool - CSV to MySQL
Posted on: 01/29/10 05:07am
By: Anonymous (Compi)
Thanks mate :-)
You're post came right on top off google :-)
Re: Useful tool - CSV to MySQL
Posted on: 04/10/10 02:05pm
By: Anonymous (Ganesh)
very very thanks.
Anon.
You done a great thing.
Re: Useful tool - CSV to MySQL
Posted on: 04/25/10 11:39am
By: Anonymous (Andreas Herz)
Dear
another good tool for Excel7CSV import is http://www.dbTube.org
You can draw your import definition online with an workflow
editor. The generated improt definition can be used for your further
imports.
greetings
Andreas
Re: Useful tool - CSV to MySQL
Posted on: 07/01/10 04:56am
By: Anonymous (kedar)
http://kedar.nitty-witty.com/blog/load-delimited-data-csv-excel-into-mysql-server/
Re: Useful tool - CSV to MySQL
Posted on: 08/30/10 12:54am
By: Anonymous (Giant Dork)
Nice! Couple more methods: http://giantdorks.org/alain/export-mysql-data-into-csv-or-psv-files/
Re: Useful tool - CSV to MySQL
Posted on: 08/30/10 12:59am
By: Anonymous (alain)
Re: Useful tool - CSV to MySQL
Posted on: 09/22/10 03:14am
By: Anonymous (Moses)
Please send me the correct link for your post so that I can use it.
I have also the same problem. Thanx
Re: Useful tool - CSV to MySQL
Posted on: 11/30/10 02:20am
By: Anonymous (Kris)
mysql dbu is closed.
Any other alternative ?
Re: Useful tool - CSV to MySQL
Posted on: 12/02/10 05:32pm
By: Anonymous (Jim)
You might try this link. There are a number of links to real software to suit this conversion requirement.
http://mysql-import-multiple-text-files-softwar.software.informer.com/
Often these sites are dynamic in nature so there's no guarantee as to how long the link will work.
CSV storage engine
Posted on: 12/03/10 07:05am
By: Anonymous (joel box)
If you have access to the data folder a simple alternative is to make a table of type CSV. (normally you have isam or innodb). Instantly you have the csv file in the folder. Just copy your data into it and its available in mysql or insert data into it using mysql and you have it in csv formt.
hope this helps,
Re: Useful tool - CSV to MySQL
Posted on: 12/16/10 07:15pm
By: Anonymous (droc)
http://csv2sql.com/
Re: Useful tool - CSV to MySQL
Posted on: 12/22/10 08:03am
By: Anonymous (Agilefuse Consulting)
http://www.agilefuseconsulting.co.cc/development/csvtomysql/
this is my tool. i developed the tool using html5 and file api. please take note that this only works on firefox and google chrome browser(latest version). also large data to import requires large time to complete, and also may cause memory limit error. so please use the tool with care. thanks.
Re: Useful tool - CSV to MySQL
Posted on: 01/08/11 05:24pm
By: Anonymous (alexpran)
seems most online tools have been taken down or dont work, but found I found this basic (and free) site
convertcsvtomysql.com[*3]
seems limited but was enough for my needs, i think its still in dvelopment too
Re: Useful tool - CSV to MySQL
Posted on: 02/15/11 07:49am
By: Anonymous (thiyagi)
thanks man..
Re: Useful tool - CSV to MySQL
Posted on: 05/09/11 08:37am
By: Anonymous (Erel Segal Halevi)
Here is a PHP function that does the trick:
Text Formatted Code
function csv_file_to_mysql_table($source_file, $target_table, $max_line_length=10000) {
if (($handle = fopen("$source_file", "r")) !== FALSE) {
$columns = fgetcsv($handle, $max_line_length, ",");
foreach ($columns as &$column) {
$column = str_replace(".","",$column);
}
$insert_query_prefix = "INSERT INTO $target_table (".join(",",$columns).")\nVALUES";
while (($data = fgetcsv($handle, $max_line_length, ",")) !== FALSE) {
while (count($data)<count($columns))
array_push($data, NULL);
$query = "$insert_query_prefix (".join(",",quote_all_array($data)).");";
mysql_query($query);
}
fclose($handle);
}
}
Re: Useful tool - CSV to MySQL
Posted on: 08/04/11 04:00pm
By: Anonymous (sewerewes)
This function won't work unless you've got your own function for quote_all_array() - that isn't a built-in PHP function. This works pretty well:
Text Formatted Code
function quote_all_array($arr)
{
foreach ($arr as $k=>$v)
{
$returnArr[$k] = ($v) ? '"'.str_replace('"','\"',$v).'"' : "NULL" ;
}
return $returnArr;
}
Re: Useful tool - CSV to MySQL
Posted on: 08/23/11 03:10am
By: MyJuliet
Please give me the correct link to your article, so I can use it. I have the same problem.
Re: Useful tool - CSV to MySQL
Posted on: 09/01/11 01:30am
By: Anonymous (Andreas Herz)
Hi,
maybe the phpBlocks lib can solve the export/inport of CSV files in a more
smart way like Googles AppInventor. You can change the export format in an
Click&Point manner. Like Google AppInventor or the programming IDE Scratch
from the MIT.
phpBlocks is GPL and can be downloaded from the WebSite. Worth a look for dyn.
PHP formular and exports.
Common Demos: http://www.freegroup.de/software/phpBlocks/demo.html
Link to example: http://www.freegroup.de/test/editor/editor.php?xml=demo_sql.xml
Greetings
Andreas
Re: Useful tool - CSV to MySQL
Posted on: 05/18/12 01:52pm
By: Anonymous (Anonymous Geek)
Re: Useful tool - CSV to MySQL
Posted on: 08/08/12 04:12am
By: Anonymous (Richard)