Hi BJ,
Very complete and concise. I'd suggest a WIki tip entry ;o)
Eventually modifying, regrouping existing ?
Jacques
From: "BJ Freeman" <[email protected]>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
there are a couple of ways.
1) you can pull the Cvs into worksheet and add columns between the data
to add in the xml to make it an entity import.
then export it as a tab delimited file.
use an editor that and search and replace tabs with spaces.
this is only good for static data like first initialization.
2)use the framework/datafile to read you Cvs in. it uses a map to put
the data in the entity fields. this is also good for static data like
adding new products.
2)Load the csv and save it as an xls file. Use the PIO to read the xls
file and you can then search of the product is new or already in and
create or update the product. This one requires coding.
You can add a flt that lets a user find the xls and load it that way, or
add a service that runs as a job to read from a folder say every midnight.
Tom Berchenbriter sent the following on 3/19/2009 2:54 PM:
How can I import my catalog of products into ofbiz? I have a csv file but don't
know what to do with it!
Thanks!
[cid:[email protected]]
________________________________
This communication and any files or attachments transmitted with it may contain information that is copyrighted or confidential
and exempt from disclosure under applicable law. It is intended solely for the use of the individual or the entity to which it is
addressed. If you are not the intended recipient, you are hereby notified that any use, dissemination, or copying of this
communication is strictly prohibited. If you have received this communication in error, please notify us at once so that we may
take the appropriate action and avoid troubling you further. Thank you for your cooperation. Contact information: Pacific Coast
Companies, Inc. 1-916-631-6600 and ask for the e-mail administrator.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJws6krP3NbaWWqE4RAr1pAJ9mvh5IxrZMw/PwbmfxYzV5cVPMZgCfV7pe
H725NIfG0dMZ0Ff9uyq779E=
=Fo5N
-----END PGP SIGNATURE-----
