csv import issues - good solution found

2009-10-06 Thread Patrice Olivier-Wilson
A week or so ago, I was seeking a solution for breaking lines for 
importing csv to phpmyadmin interface


Found a slick solution:


http://csv2sql.evandavey.com/

create table in database, upload the csv file to above page, copy/paste 
the resulting code into SQL field for the database (not the table) -- 
viola!

:-)
Just thought I'd share in case anyone else might need it...

--
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: CSV import

2007-05-31 Thread Mogens Melander
Import your CSV-data into a temporary table, using mysqlimport,
and throw a bit of SQL at it might do the trick, but then again,
not knowing the layout of your table, nor the data you want
to import, i'm only guessing.

On Mon, May 28, 2007 16:57, Sharique uddin Ahmed Farooqui wrote:
 Both PhpMyAdmin and SQLYOG doesn't support customised mapping.
 My cvs data structure is diff from mysql table. I just want to import
 values
 for one field only.
 Previously I was using Mysql Front but it crashes. Also this s/w very old
 and discontinued.
 Why mysql doesn't  implement it in MysqlAdmin?
 --
 Sharique uddin Ahmed Farooqui
 (C++/C# Developer, IT Consultant)
 A revolution is about to begin.
 A world is about to change.
 And you and me are the initiator.

 On 5/28/07, Geoffroy Cogniaux [EMAIL PROTECTED] wrote:

 Hi,
 It can be done easily with PhpMyAdmin, but it is not in .net

 2007/5/28, Sharique uddin Ahmed Farooqui [EMAIL PROTECTED]:
 
  I want to import data from a CSV file in a  table. MySql admin doesn't
  support import from CSV files.
  Format of data is different from structure of table.
 
  Is there any app/snippet   written for this task in .net , which I can
  modify according to my need.
 
  --
  Sharique uddin Ahmed Farooqui
  (C++/C# Developer, IT Consultant)
  A revolution is about to begin.
  A world is about to change.
  And you and me are the initiator.
 


 --
 This message has been scanned for viruses and
 dangerous content by OpenProtect(http://www.openprotect.com), and is
 believed to be clean.




-- 
Later

Mogens Melander
+45 40 85 71 38
+66 870 133 224



-- 
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



CSV import

2007-05-28 Thread Sharique uddin Ahmed Farooqui

I want to import data from a CSV file in a  table. MySql admin doesn't
support import from CSV files.
Format of data is different from structure of table.

Is there any app/snippet   written for this task in .net , which I can
modify according to my need.

--
Sharique uddin Ahmed Farooqui
(C++/C# Developer, IT Consultant)
A revolution is about to begin.
A world is about to change.
And you and me are the initiator.


RE: CSV import

2007-05-28 Thread Sandesh Nair
Try SQLYOG software 


Thanks  Regards,
Sandesh Nair

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sharique
uddin Ahmed Farooqui
Sent: Monday, May 28, 2007 11:56 AM
To: mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: CSV import

I want to import data from a CSV file in a  table. MySql admin doesn't
support import from CSV files.
Format of data is different from structure of table.

Is there any app/snippet   written for this task in .net , which I can
modify according to my need.

--
Sharique uddin Ahmed Farooqui
(C++/C# Developer, IT Consultant)
A revolution is about to begin.
A world is about to change.
And you and me are the initiator.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: CSV import

2007-05-28 Thread Geoffroy Cogniaux

Hi,
It can be done easily with PhpMyAdmin, but it is not in .net

2007/5/28, Sharique uddin Ahmed Farooqui [EMAIL PROTECTED]:


I want to import data from a CSV file in a  table. MySql admin doesn't
support import from CSV files.
Format of data is different from structure of table.

Is there any app/snippet   written for this task in .net , which I can
modify according to my need.

--
Sharique uddin Ahmed Farooqui
(C++/C# Developer, IT Consultant)
A revolution is about to begin.
A world is about to change.
And you and me are the initiator.



Re: CSV import

2007-05-28 Thread Sharique uddin Ahmed Farooqui

Both PhpMyAdmin and SQLYOG doesn't support customised mapping.
My cvs data structure is diff from mysql table. I just want to import values
for one field only.
Previously I was using Mysql Front but it crashes. Also this s/w very old
and discontinued.
Why mysql doesn't  implement it in MysqlAdmin?
--
Sharique uddin Ahmed Farooqui
(C++/C# Developer, IT Consultant)
A revolution is about to begin.
A world is about to change.
And you and me are the initiator.

On 5/28/07, Geoffroy Cogniaux [EMAIL PROTECTED] wrote:


Hi,
It can be done easily with PhpMyAdmin, but it is not in .net

2007/5/28, Sharique uddin Ahmed Farooqui [EMAIL PROTECTED]:

 I want to import data from a CSV file in a  table. MySql admin doesn't
 support import from CSV files.
 Format of data is different from structure of table.

 Is there any app/snippet   written for this task in .net , which I can
 modify according to my need.

 --
 Sharique uddin Ahmed Farooqui
 (C++/C# Developer, IT Consultant)
 A revolution is about to begin.
 A world is about to change.
 And you and me are the initiator.




Re: CSV import

2007-05-28 Thread Baron Schwartz

Sharique uddin Ahmed Farooqui wrote:

Both PhpMyAdmin and SQLYOG doesn't support customised mapping.
My cvs data structure is diff from mysql table. I just want to import 
values

for one field only.
Previously I was using Mysql Front but it crashes. Also this s/w very old
and discontinued.
Why mysql doesn't  implement it in MysqlAdmin?


Perhaps you can use LOAD DATA INFILE?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: CSV import

2007-05-28 Thread Martijn Tonies



 Both PhpMyAdmin and SQLYOG doesn't support customised mapping.
 My cvs data structure is diff from mysql table. I just want to import
values
 for one field only.

Database Workbench does, see www.upscene.com

 Previously I was using Mysql Front but it crashes. Also this s/w very old
 and discontinued.



Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle 
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: sql CSV import

2003-02-01 Thread Sherzod Ruzmetov
I normally do not use PHPMyAdmin. But when I had to do that once
on a client's sites (he didn't have shell access to a shared server ),
i had a similar problem. I couldn't import its own dump.

I believe it was a bug, and should've been resolved in later versions of
PHPMyAdmin. Try to update.

Sherzod

: -Original Message-
: From: Dobromir Velev [mailto:[EMAIL PROTECTED]]
:
: You van use the LOAD DATA INFILE statement
:
: Check this
: http://www.mysql.com/doc/en/LOAD_DATA.html
:
: for more information
:
: HTH
: Dobromir Velev
: [EMAIL PROTECTED]
: www.websitepulse.com
:
:
: - Original Message -
: From: Andrew [EMAIL PROTECTED]
: To: [EMAIL PROTECTED]
: Sent: Thursday, January 30, 2003 12:48
: Subject: RE: sql CSV import
:
:
: 
:  Hi all I am trying to import a csv file from MySQL and keep
: getting an
: error on
:  line one.
:  Is there an alternative way to import a csv file other than using
: phpmyadmin?
: 
:  I exported the file from MySQL but can't import it back in,
: any ideas?
: 
:  Andrew
: 
: 
: 
: 
: 
: 
: -
:  Before posting, please check:
: http://www.mysql.com/manual.php   (the manual)
: http://lists.mysql.com/   (the list archive)
: 
:  To request this thread, e-mail [EMAIL PROTECTED]
:  To unsubscribe, e-mail
: [EMAIL PROTECTED]
:  Trouble unsubscribing? Try:
: http://lists.mysql.com/php/unsubscribe.php
: 
: 
:
:
: -
: Before posting, please check:
:http://www.mysql.com/manual.php   (the manual)
:http://lists.mysql.com/   (the list archive)
:
: To request this thread, e-mail [EMAIL PROTECTED]
: To unsubscribe, e-mail
: [EMAIL PROTECTED]
: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
:
:
:
:



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: sql CSV import

2003-01-31 Thread Dobromir Velev
You van use the LOAD DATA INFILE statement

Check this
http://www.mysql.com/doc/en/LOAD_DATA.html

for more information

HTH
Dobromir Velev
[EMAIL PROTECTED]
www.websitepulse.com


- Original Message -
From: Andrew [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 30, 2003 12:48
Subject: RE: sql CSV import



 Hi all I am trying to import a csv file from MySQL and keep getting an
error on
 line one.
 Is there an alternative way to import a csv file other than using
phpmyadmin?

 I exported the file from MySQL but can't import it back in, any ideas?

 Andrew





 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: sql CSV import

2003-01-30 Thread Andrew

Hi all I am trying to import a csv file from MySQL and keep getting an error on
line one.
Is there an alternative way to import a csv file other than using phpmyadmin?

I exported the file from MySQL but can't import it back in, any ideas?

Andrew





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php