Forums / Developer / Funding work for Data Import Extension - CSV

Funding work for Data Import Extension - CSV

Author Message

Felipe Jaramillo

Monday 31 July 2006 10:11:17 am

Hello all,

If you share the need for mode solid data import, we are looking into cooperative funding to update and improve the CSV import extension. (There have been threads about this, please see http://ez.no/community/forum/developer/fantastic_csv_import_extension_who_owns_it/re_fantastic_csv_import_extension_who_owns_it__9 )

We have been looking into the alternatives for data import available in eZ publish and find all of them lacking in some way or another.

Most projects involve migrating data from previous information systems, ranging from open source apps, various databases and the ubiquitous excel spreadsheet.

The CSV import extension (http://zev.ez.no/svn/extensions/ ) allows importing comma separated values in flat files. It is available on the SVN repository. It looks good but has no support for 3.6+. It was developed by eZ systems staff.

Kristian Hola from eZ systems has kindly given an estimate to get the CSV extension to get the following:

Modify import to work with last eZ release (ref 1)
Update image import (ref 3)
Support import of enhanced object relation (ref 5)
Updating import of ezxmldatatype

The estimate is 5 hours of work.

Basically this will allow large imports to work on the CLI in the current eZ publish versions.

We can fund some of the work, but we need everyone's cooperation to get going.

If you are interested, please contact me: fjaramillo (in) aplyca.com

Regards,
Felipe

Felipe Jaramillo
eZ Certified Extension Developer
http://www.aplyca.com | Bogotá, Colombia

Xavier Dutoit

Tuesday 01 August 2006 12:23:18 am

Hi Felipe,

I wasn't aware of this extension, going to give it a shot and let you know.

I'm wondering if the csv is the best option, especially as you mention ezxmldatatype, that are likely to contain \n. If you mention importing big things, the xml format might be more appropriate ?

Thinking loud...

http://www.sydesy.com

steve walker

Tuesday 01 August 2006 1:25:40 am

Could this be tied in with an export function too - would mean its a pretty complete package then?

Steve

http://www.oneworldmarket.co.uk

Xavier Dutoit

Tuesday 01 August 2006 5:44:22 am

Hi,

Have a look at gabriel's contribution (csv export). It works great. They are other contribs too.

X+

http://www.sydesy.com

kracker (the)

Thursday 03 August 2006 7:59:18 pm

<b>Gabriel Ambuehl's CVSExport Extension</b>
<i>http://ez.no/community/contribs/import_export/csvexport
http://pubsvn.ez.no/community/trunk/extension/csvexport</i>

//kracker
GPLv3 Audio: <i>http://fsfeurope.org/projects/gplv3/fsfe-gplv3-eben-moglen.vorbis.ogg.torrent</i>

Member since: 2001.07.13 || http://ezpedia.se7enx.com/

Felipe Jaramillo

Wednesday 16 August 2006 4:36:32 pm

Hello everyone,

We have had recent success with Xavier's modifications on the importXMLData extension, managing to do thousands of imports (only on Windows for now). I guess we will put the funding of this extension on hold for now.

Regarding export CSV, I believe this is pretty simple to accomplish using template code, whereas importing is another matter altogether.

Where I see possibilities of merging is in the CSV, XML and other import utilities, where the parsing of the data is unique, but the importing and attribute value assignment are exactly the same.

I will keep you all posted as we make progress.

Regards,

Felipe

Felipe Jaramillo
eZ Certified Extension Developer
http://www.aplyca.com | Bogotá, Colombia