-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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-----
