A link from the FAQ under "Production Tips" will be enough
Thanks
Jacques
From: "BJ Freeman" <[email protected]>
http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data
will eventually get all pages that relate to external data under this
then can move it up on the FAQ's
BJ Freeman sent the following on 3/20/2009 2:46 AM:
Thanks and yup plan to
:D
Jacques Le Roux sent the following on 3/20/2009 1:08 AM:
Hi BJ,
Very complete and concise. I'd suggest a WIki tip entry ;o)
Eventually modifying, regrouping existing ?
Jacques
From: "BJ Freeman" <[email protected]>
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
iD8DBQFJw9s2rP3NbaWWqE4RAoJ6AJ4oZYNRsRU3uhimC6KWDkPQx64towCfYwNP
jK5JQShCWxGDJptCylHG00M=
=nCWw
-----END PGP SIGNATURE-----
