Re: importing data
Locked
 
|
-----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:image002.jpg@01C9A8A2.A2DE3650] > > > ________________________________ > 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. > Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJws6krP3NbaWWqE4RAr1pAJ9mvh5IxrZMw/PwbmfxYzV5cVPMZgCfV7pe H725NIfG0dMZ0Ff9uyq779E= =Fo5N -----END PGP SIGNATURE----- |
Administrator
|
Hi BJ,
Very complete and concise. I'd suggest a WIki tip entry ;o) Eventually modifying, regrouping existing ? Jacques From: "BJ Freeman" <[hidden email]> > -----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:image002.jpg@01C9A8A2.A2DE3650] >> >> >> ________________________________ >> 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----- > |
|
|
-----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" <[hidden email]> > 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:image002.jpg@01C9A8A2.A2DE3650] >>>> >>>> >>>> ________________________________ >>>> 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----- |
|
|
-----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" <[hidden email]> >> 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:image002.jpg@01C9A8A2.A2DE3650] >>>>> >>>>> >>>>> ________________________________ >>>>> 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. >>>>> > Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJw9s2rP3NbaWWqE4RAoJ6AJ4oZYNRsRU3uhimC6KWDkPQx64towCfYwNP jK5JQShCWxGDJptCylHG00M= =nCWw -----END PGP SIGNATURE----- |
|
Administrator
|
A link from the FAQ under "Production Tips" will be enough
Thanks Jacques From: "BJ Freeman" <[hidden email]> > 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" <[hidden email]> >>> 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:image002.jpg@01C9A8A2.A2DE3650] >>>>>> >>>>>> >>>>>> ________________________________ >>>>>> 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----- > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |