CSV into MySQL prog or script

dazz williams · December 8th, 2007, 2:30 PM

I need to regularly populate a DB (MySQL) with CSV or delimited text (probably ',' or '\t').

While looking up scripts through Google I came across this program: http://www.dbload.com/
Has anyone had any experience with this software before? If so, were you able to easily connect to your Surpass hosted server?

Basically I'm wondering if this program is worth my time or if I should just make my own?

Thanks!
dazz.

**MarkRH** · December 8th, 2007, 10:05 PM

I've always used SQLyog for that. http://www.webyog.com/en/ It has a CSV import function. They have a free version. All you have to do is make sure you add your PC's IP address to the host access list, which is in the Remote MySQL part of the current cPanel.

More info: http://wiki.surpasshosting.com/index...itle=MySQL_GUI

H · December 8th, 2007, 10:17 PM

If SQLyog doesn't work, give MySQL Administrator a shot. In some ways far more powerful than SQLyog, but in otherwise not as powerful.

I personally use a combination of CocoaMySQL and MySQL Administrator.

dazz williams · December 13th, 2007, 3:05 PM

Are either of those programs able to deal with blank fields in the CSV file? eg:
"","","","","","","Date","Comment"
"","","","","",10/01/2006,"A detailed comment"

Simply Accounting has some... interesting conventions for generating CSV files. :S

I'll also need to deal with a certain field having multiple pieces of information in it since the program doesn't have room for more fields in the report but details about a record are wanted in the DB.
eg: "field one", "field two", "field three, field four, field five", "field six"

Does that make sense to you? It seems like a weird requirement to me so I'm thinking I may be better off writing the script unless the program(s) got that covered.
dazz.

December 8th, 2007, 2:30 PM	#1 (permalink)
dazz williams Registered User Seasoned Poster Joined in May 2006 Lives in Ontario, Canada Hosted on Pass59 53 posts Gave thanks: 2 Thanked 0 times	CSV into MySQL prog or script I need to regularly populate a DB (MySQL) with CSV or delimited text (probably ',' or '\t'). While looking up scripts through Google I came across this program: http://www.dbload.com/ Has anyone had any experience with this software before? If so, were you able to easily connect to your Surpass hosted server? Basically I'm wondering if this program is worth my time or if I should just make my own? Thanks! dazz. __________________ "My ICQ is on invisible, like an internet submarine. I can see them, but they can't see me." - The Holiday Wrecker http://revolutionthis.blogspot.com www.KylerAyim.com Friendly and professional computer solutions for home and business. Freelance website design, hosting, web development, and more.

December 8th, 2007, 10:05 PM	#2 (permalink)
MarkRH Race Surpass Super #1 Joined in Jul 2006 Lives in Oklahoma City, OK Hosted on sh102 1,222 posts Gave thanks: 18 Thanked 86 times	I've always used SQLyog for that. http://www.webyog.com/en/ It has a CSV import function. They have a free version. All you have to do is make sure you add your PC's IP address to the host access list, which is in the Remote MySQL part of the current cPanel. More info: http://wiki.surpasshosting.com/index...itle=MySQL_GUI __________________ SH102 : Mark Headrick - Blog - Gallery Pelicar \| Company of Valor \| Mysstie Wolfestar

December 13th, 2007, 3:05 PM	#4 (permalink)
dazz williams Registered User Seasoned Poster Joined in May 2006 Lives in Ontario, Canada Hosted on Pass59 53 posts Gave thanks: 2 Thanked 0 times	blank fields Are either of those programs able to deal with blank fields in the CSV file? eg: "","","","","","","Date","Comment" "","","","","",10/01/2006,"A detailed comment" Simply Accounting has some... interesting conventions for generating CSV files. :S I'll also need to deal with a certain field having multiple pieces of information in it since the program doesn't have room for more fields in the report but details about a record are wanted in the DB. eg: "field one", "field two", "field three, field four, field five", "field six" Does that make sense to you? It seems like a weird requirement to me so I'm thinking I may be better off writing the script unless the program(s) got that covered. dazz. __________________ "My ICQ is on invisible, like an internet submarine. I can see them, but they can't see me." - The Holiday Wrecker http://revolutionthis.blogspot.com www.KylerAyim.com Friendly and professional computer solutions for home and business. Freelance website design, hosting, web development, and more.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

December 8th, 2007, 10:17 PM	#3 (permalink)
H after g, before i Resident. Joined in Jul 2004 Lives in N,BC,CA 8,087 posts Gave thanks: 48 Thanked 131 times	If SQLyog doesn't work, give MySQL Administrator a shot. In some ways far more powerful than SQLyog, but in otherwise not as powerful. I personally use a combination of CocoaMySQL and MySQL Administrator.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)