Importing product data from an external csv file

Author Message

steve walker

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

steve walker

Tuesday 14 September 2004 4:58:20 am

One thought on this - could the erp plugin contrib be used with a soap exportation from excel to bring the data in?

Steve

http://www.oneworldmarket.co.uk

Paul Forsyth

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

steve walker

Tuesday 14 September 2004 6:54:48 am

Paul,

Thanks for your reply. 3.5... on the one hand ¡damn!, on the other hand it sounds like there is some good new functionality coming up in 3.5.

Is there a release date for 3.5 as yet? Or is it possible to extract the import function as an extension ala the multioption?

If I knew for sured that 3.5 would be able to do this and it was going to be released in the not too distant future I could in theory carry on dev'ing the rest of the site and the data imprtation function toward the end of the build.

Normally you kind of want to get these fundamentals working early on in the build...

Regards, Steve.

http://www.oneworldmarket.co.uk

Paul Forsyth

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

Frederik Holljen

Tuesday 14 September 2004 7:50:38 am

We will try to keep the release dates for the beta and final even though it may become a bit tight. Any further updates will be posted.

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.