OFBIZ- How to add new items in inventory of ofbiz from an excel file ?

[manoj_aggarwal84]

hi all,

Can any one tell me,  How to add new items in inventory of ofbiz from an excel file ?

Thanks,
Manoj

[Ashish Vijaywargiya]

Following commit and the JIRA issue link will be of help for you.
http://svn.apache.org/viewvc?view=rev&revision=663627

&

https://issues.apache.org/jira/browse/OFBIZ-1810

Another option is to convert the excel file into CSV file and use the Data
File Tool.
Help on Data File tool is available on
http://docs.ofbiz.org/display/~jacopoc/OFBiz's+Data+File+Tools

--
Ashish


On Mon, Jun 30, 2008 at 6:28 AM, manoj_aggarwal84 <
[hidden email]> wrote:

>
> hi all,
>
> Can any one tell me,  How to add new items in inventory of ofbiz from an
> excel file ?
>
> Thanks,
> Manoj
> --
> View this message in context:
> http://www.nabble.com/OFBIZ--How-to-add-new-items-in-inventory-of-ofbiz-from-an-excel-file---tp18192704p18192704.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

[Jacques Le Roux]

Many solutions, look in Wiki (documentation) and Nabble

Jacques

From: "manoj_aggarwal84" <[hidden email]>

>
> hi all,
>
> Can any one tell me,  How to add new items in inventory of ofbiz from an
> excel file ?
>
> Thanks,
> Manoj
> --
> View this message in context:
> http://www.nabble.com/OFBIZ--How-to-add-new-items-in-inventory-of-ofbiz-from-an-excel-file---tp18192704p18192704.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[BJ Freeman]

Ashish:
is there any basic code that could be put in the framework/datafile
folder that could be common to any excel import?

Ashish Vijaywargiya sent the following on 6/30/2008 3:57 AM:

> Following commit and the JIRA issue link will be of help for you.
> http://svn.apache.org/viewvc?view=rev&revision=663627
>
> &
>
> https://issues.apache.org/jira/browse/OFBIZ-1810
>
> Another option is to convert the excel file into CSV file and use the Data
> File Tool.
> Help on Data File tool is available on
> http://docs.ofbiz.org/display/~jacopoc/OFBiz's+Data+File+Tools
>
> --
> Ashish
>
>
> On Mon, Jun 30, 2008 at 6:28 AM, manoj_aggarwal84 <
> [hidden email]> wrote:
>
>> hi all,
>>
>> Can any one tell me,  How to add new items in inventory of ofbiz from an
>> excel file ?
>>
>> Thanks,
>> Manoj
>> --
>> View this message in context:
>> http://www.nabble.com/OFBIZ--How-to-add-new-items-in-inventory-of-ofbiz-from-an-excel-file---tp18192704p18192704.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>

[ankurgupta3056]

Hi
I also facing this problem..kindly help



On Mon, Jun 30, 2008 at 5:46 AM, BJ Freeman <[hidden email]> wrote:

> Ashish:
> is there any basic code that could be put in the framework/datafile
> folder that could be common to any excel import?
>
> Ashish Vijaywargiya sent the following on 6/30/2008 3:57 AM:
> > Following commit and the JIRA issue link will be of help for you.
> > http://svn.apache.org/viewvc?view=rev&revision=663627
> >
> > &
> >
> > https://issues.apache.org/jira/browse/OFBIZ-1810
> >
> > Another option is to convert the excel file into CSV file and use the
> Data
> > File Tool.
> > Help on Data File tool is available on
> > http://docs.ofbiz.org/display/~jacopoc/OFBiz's+Data+File+Tools<http://docs.ofbiz.org/display/%7Ejacopoc/OFBiz%27s+Data+File+Tools>
> >
> > --
> > Ashish
> >
> >
> > On Mon, Jun 30, 2008 at 6:28 AM, manoj_aggarwal84 <
> > [hidden email]> wrote:
> >
> >> hi all,
> >>
> >> Can any one tell me,  How to add new items in inventory of ofbiz from an
> >> excel file ?
> >>
> >> Thanks,
> >> Manoj
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/OFBIZ--How-to-add-new-items-in-inventory-of-ofbiz-from-an-excel-file---tp18192704p18192704.html
> >> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>
> >>
> >
>
>

[Ashish Vijaywargiya]

BJ,

We didn't find time to make it generic for all the excel files.
So for now its only for Product and InventoryItem import only.

With the proposal of the changes we can enhance this code.
But at present I can't give you the time line for this work due to bit busy
schedule.

Do you have some thoughts for implementation ?

--
Ashish


On Mon, Jun 30, 2008 at 8:46 AM, BJ Freeman <[hidden email]> wrote:

> Ashish:
> is there any basic code that could be put in the framework/datafile
> folder that could be common to any excel import?
>
> Ashish Vijaywargiya sent the following on 6/30/2008 3:57 AM:
> > Following commit and the JIRA issue link will be of help for you.
> > http://svn.apache.org/viewvc?view=rev&revision=663627
> >
> > &
> >
> > https://issues.apache.org/jira/browse/OFBIZ-1810
> >
> > Another option is to convert the excel file into CSV file and use the
> Data
> > File Tool.
> > Help on Data File tool is available on
> > http://docs.ofbiz.org/display/~jacopoc/OFBiz's+Data+File+Tools<http://docs.ofbiz.org/display/%7Ejacopoc/OFBiz%27s+Data+File+Tools>
> >
> > --
> > Ashish
> >
> >
> > On Mon, Jun 30, 2008 at 6:28 AM, manoj_aggarwal84 <
> > [hidden email]> wrote:
> >
> >> hi all,
> >>
> >> Can any one tell me,  How to add new items in inventory of ofbiz from an
> >> excel file ?
> >>
> >> Thanks,
> >> Manoj
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/OFBIZ--How-to-add-new-items-in-inventory-of-ofbiz-from-an-excel-file---tp18192704p18192704.html
> >> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>
> >>
> >
>
>