-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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 iD8DBQFJw2YBrP3NbaWWqE4RAk9PAJ9FGvk2h8tryyH6nXQmioBpGTCzdACfWwcj /TjNeo8TLsslaXWaHVMn/4E= =EBQt -----END PGP SIGNATURE-----
