Importing product data from an external csv file

Tuesday 14 September 2004 4:38:33 am

Hi there,

There have been a multitude of posts on importing external data in Ez, such as:

http://ez.no/community/forum/developer/content_import_questions

http://www.ez.no/ez_publish/documentation/development/importing_attribute_data

http://ez.no/community/forum/setup_design/import_product_data_from_xl_spreadsheet_customisation_of_administration_interface

..with none resulting in an 'easy to do' implementation - and there are the contributions found at:

http://www.ez.no/community/contributions/import_export

which don't hold much for simple data importation.

I want to import data from an xl or csv file - preferably using a web interface that has a 'browse to source file' form on it - that when uploaded updates, creates and deletes the products belonging to a particular class.

The name would (could) be the unique identifier, and the imported file would list the other attributes to be imported into each named product.

There has been a lot of work done by Alex, Paul(s) and others to create import scripts, but I havent seen an easy to use result as yet.

I would have thought a contribution that specifically imported product data from external files would be a really useful function. Is there anyone out there who would consider helping create this sort of contribution or has some working scripts to get the ball rolling?

Regards, Steve.

http://www.oneworldmarket.co.uk

Tuesday 14 September 2004 6:36:34 am

Steve,

You will probably hate me for saying but i think there is something do this in 3.5. At least i seem to remember something going in... Will take a look.

However, the hardest part about importing is matching to your object/class structure. Reading the data is very simple, and most of the examples you listed will do this.

paul

Tuesday 14 September 2004 7:05:32 am

3.5 details are here:

http://ez.no/community/news/ez_publish_3_5_release_plan

Though it was announced last week the alpha has slipped a week. Not sure if they other dates have.

I think this functionality is more integrated. Datatypes are much easier to pull out :)

If you want we could discuss the object/class structure offline to determine what kind of import it will be.

paul