Hi all,
I'm new to ofbiz and was wondering if i can upload catalog data in bulk rather than go through the individual item setup. The data is in excel. Any help is greatly appreciated. Kind Regards, Irene. |
there is an spreadsheet import of products.
look at \applications\product\src\org\ofbiz\product\spreadsheetimport your excel has to be in the column format of the code or you have to modify it. you have to place the file you want imported in a certain folder. this is as of 9.04. I also provide a service to code for manual or remote automatied importing from suppliers Irene Kiragu sent the following on 6/21/2010 7:15 AM: ========================= BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52> Specialtymarket.com <http://www.specialtymarket.com/> Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro> > Hi all, > > I'm new to ofbiz and was wondering if i can upload catalog data in bulk > rather than go through the individual item setup. The data is in excel. Any > help is greatly appreciated. > > Kind Regards, > Irene. > |
In reply to this post by Irene Kiragu
you can also use framework/data file
https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data Irene Kiragu sent the following on 6/21/2010 7:15 AM: > Hi all, > > I'm new to ofbiz and was wondering if i can upload catalog data in bulk > rather than go through the individual item setup. The data is in excel. Any > help is greatly appreciated. > > Kind Regards, > Irene. > |
In reply to this post by BJ Freeman
if you look at ImportProductServices.java it will show you the columns
it expects from the excel. look at line 133 to see how the prepareInventoryItem() is used the prepare methods adds data that is default in each entity. if you wish to add those columns to your excel so you can define them then you would need to change the ImportProductServices.java to read those columns and change the prepare methods to pass that data in and assign it to each field. ========================= BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52> Specialtymarket.com <http://www.specialtymarket.com/> Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro> mike isaacs sent the following on 6/23/2010 2:59 AM: > Hi all, > > Thanks for your insight. > Viewing the the code (ImportProductHelper.java) I see two maps ( in the > prepareProduct( ) and prepareInventoryItem( ) methods). > Looks like the excel then has to have all the fields in the two methods, > with some default values as shown, correct? > > Kind Regards, > > Mike > > On 22 June 2010 10:34, Irene Kiragu<[hidden email]> wrote: > >> >> >> ---------- Forwarded message ---------- >> From: BJ Freeman<[hidden email]> >> Date: Mon, Jun 21, 2010 at 8:32 PM >> Subject: Re: Question - Bulk upload of catalog >> To: [hidden email] >> >> >> there is an spreadsheet import of products. >> look at \applications\product\src\org\ofbiz\product\spreadsheetimport >> your excel has to be in the column format of the code or you have to modify >> it. >> you have to place the file you want imported in a certain folder. >> this is as of 9.04. >> I also provide a service to code for manual or remote automatied importing >> from suppliers >> >> Irene Kiragu sent the following on 6/21/2010 7:15 AM: >> >> >> ========================= >> BJ Freeman >> http://bjfreeman.elance.com >> Strategic Power Office with Supplier Automation< >> http://www.businessesnetwork.com/automation/viewforum.php?f=52> >> Specialtymarket.com<http://www.specialtymarket.com/> >> >> Systems Integrator-- Glad to Assist >> >> Chat Y! messenger: bjfr33man >> Linkedin< >> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro >>> >> >> >> Hi all, >>> >>> I'm new to ofbiz and was wondering if i can upload catalog data in bulk >>> rather than go through the individual item setup. The data is in excel. >>> Any >>> help is greatly appreciated. >>> >>> Kind Regards, >>> Irene. >>> >>> >> > |
Free forum by Nabble | Edit this page |