Forums / Developer / import csv and create objects
Darren Mothersele
Tuesday 03 August 2004 6:25:08 am
I have an excel spreadsheet with 3000 lines - all products. I created a class using the admin interface to represent this data.
I want to write a php script that will open the csv, and loop round, saving each entry to the ezpublish database. I was thinking of importing into the database using phpmyadmin - but after searching the docs and forum, the database structure has given me a real headache.
<?php $lines = file('./testdata.csv'); foreach ($lines as $line_num => $line) { $tracks[$line_num] = explode(",", $line); //something here to create the ez object and save it to the database? } ?>
Ekkehard Dörre
Tuesday 03 August 2004 9:59:10 am
Hi,
have a look here: http://ez.no/community/contributions/import_export and here http://ez.no/community/forum/developer/importing_update_entry_if_it_already_exists and herehttp://ez.no/community/forum/developer/import_image_into_existing_class
Greetings, ekke
http://www.coolscreen.de - Over 40 years of certified eZ Publish know-how: http://www.cjw-network.com CJW Newsletter: http://projects.ez.no/cjw_newsletter - http://cjw-network.com/en/ez-publ...w-newsletter-multi-channel-marketing
Tuesday 03 August 2004 10:29:08 am
thanks, i'm inspecting the code now to see if i can finally understand how this thing works!
i think i've finally worked out the database structure... but i'm sure it's a really bad idea to try and add objects manually.
Monday 09 August 2004 10:24:16 am
this is great! I've had some success importing objects using a script i downloaded from one of those links.
I'm stuck on another part, I was hoping someone had an idea how to acheive this...
I am importing an object that has an Object Relation List as one of the attributes. How do I create a new object from some of the import attibutes, and add this to the relation list? I looked at the code for the ezobjectrelationlist type - but i can't work out which method i need to use - and there's no documentation on this.
Thanks,
--Darren
Tuesday 10 August 2004 11:02:49 am
i've come up with a solution - not exactly what i wanted, but i think it will work.
I'm adding the objects as child nodes under the object - rather than using the object relation list.
Siniša Šehović
Friday 27 August 2004 12:59:44 am
Hi Darren,
Can you please email me your script to see what and how did you do it?
Best regards,Sinisa
--- If at first you don't succeed, look in the trash for the instructions.
Script start
Module start 'content'
Module end 'content'
Script end
Time used to render debug report: 0.0002 secs