Populate MySQL table with Excel Data
Posted: Tue Nov 13, 2007 5:51 pm
by Edmontonabguy
I have an existing website with CMS and am trying to add pages to the site directly through MySQL. I have a long list of Data in Excel (450). I would like to know the numbering structure I should use before i try to import all the data.
I did have some success with this, just some of the links in the menu are mixed up.
Cheers
Art
Re: Populate MySQL table with Excel Data
Posted: Tue Nov 13, 2007 6:03 pm
by cyberman
Why do you want to import excel data to mysql?
It's IMHO a lot easier to export data as csv and show it via plugin ...
Re: Populate MySQL table with Excel Data
Posted: Tue Nov 13, 2007 6:30 pm
by Edmontonabguy
I agree, the data I have only uses 1 field and I need to add the directory structure ( I think)????
Re: Populate MySQL table with Excel Data
Posted: Tue Nov 13, 2007 6:39 pm
by cyberman
Not sure, what you mean - can you tell us something more?
Re: Populate MySQL table with Excel Data
Posted: Tue Nov 13, 2007 6:48 pm
by Edmontonabguy
Here are a few lines from the CSV file I exported;
"81,SERVICE AREAS,content,1,-1,16,8,8,0,CITIES,service-areas,1,NULL,html,1,1,81.00,service-areas,content_en\,Sidebar,NULL,NULL,NULL,1,10/13/2007 14:54,10/15/2007 11:50
82,ACME,content,1,81,20,2,8.00002,0,ACME WEDDING DJ,acme-wedding-dj,1,NULL,html,1,1,81.82,service-areas/acme-wedding-dj,"content_en,Sidebar",NULL,NULL,NULL,NULL,1,10/16/2007 22:37,10/16/2007 22:37
83,AIRDRIE,content,1,81,20,3,8.00003,0,AIRDRIE WEDDING DJ,airdrie-wedding-dj,1,NULL,html,1,1,81.83,service-areas/airdrie-wedding-dj,"content_en,Sidebar",NULL,NULL,NULL,NULL,1,10/16/2007 22:37,10/16/2007 22:37"
Under the service area heading I am trying to add multiple cities, I have a template that is populated with the name of the city. I was thinking I could add all the cities into this file, import it and be done.