Implement the data import tool in ofbiz.

[gopalbi]

Hello friends i need your help,

               I want to implement the data import tool in the ofbiz. Suppose i have one xml or excel file i need to import them through import option. So please tell me what step i will follow and what changes are requied in the code.Please mentation step by step.


Thanks & Regards:
      Gopal

[rajsaini]

There is extensive XML data import and export facility available in
OFBiz. Look at webtools application for details. You will find the link
in the footer. You can look at demo data files in "data" folder of
e-commerce application.

There were recent discussion about excel import. Search for "Product
Upload" thread on Nabble.

Thanks

Raj
gopalbi wrote:

> Hello friends i need your help,
>
>                I want to implement the data import tool in the ofbiz.
> Suppose i have one xml or excel file i need to import them through import
> option. So please tell me what step i will follow and what changes are
> requied in the code.Please mentation step by step.
>
>
> Thanks & Regards:
>       Gopal
>  

[gopalbi]

hello Raj i am very very thankful for your help.I have another question.
          when my pos  is start its throwing exception like this:---
-----------------------------***************-----------------------------------------------------
---- exception report ----------------------------------------------------------
Service [ofbGcPurchase] threw an unexpected exception/error
Exception: org.ofbiz.service.GenericServiceException
Message: Service target threw an unexpected exception (null)
---- stack trace ---------------------------------------------------------------
org.ofbiz.service.GenericServiceException: Service target threw an unexpected exception (null)
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:108)
org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:54)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:149)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:240)
java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
org.ofbiz.accounting.payment.GiftCertificateServices.giftCertificatePurchase(GiftCertificateServices.java:704)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:96)
org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:54)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:149)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:240)
java.lang.Thread.run(Unknown Source)


-----------------------------***************-----------------------------------------------------

Raj Saini wrote

There is extensive XML data import and export facility available in
OFBiz. Look at webtools application for details. You will find the link
in the footer. You can look at demo data files in "data" folder of
e-commerce application.

There were recent discussion about excel import. Search for "Product
Upload" thread on Nabble.

Thanks

Raj
gopalbi wrote:
> Hello friends i need your help,
>
>                I want to implement the data import tool in the ofbiz.
> Suppose i have one xml or excel file i need to import them through import
> option. So please tell me what step i will follow and what changes are
> requied in the code.Please mentation step by step.
>
>
> Thanks & Regards:
>       Gopal
>  

[rajsaini]

I do not have POS configured and can't say much about it. However, it
seems to be a NullPointerException. It is very difficult to tell without
looking at your configuration and code.

Raj

gopalbi wrote:

> hello Raj i am very very thankful for your help.I have another question.
>           when my pos  is start its throwing exception like this:---
> -----------------------------***************-----------------------------------------------------
> ---- exception report
> ----------------------------------------------------------
> Service [ofbGcPurchase] threw an unexpected exception/error
> Exception: org.ofbiz.service.GenericServiceException
> Message: Service target threw an unexpected exception (null)
> ---- stack trace
> ---------------------------------------------------------------
> org.ofbiz.service.GenericServiceException: Service target threw an
> unexpected exception (null)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:108)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:54)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:149)
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:240)
> java.lang.Thread.run(Unknown Source)
> java.lang.NullPointerException
> org.ofbiz.accounting.payment.GiftCertificateServices.giftCertificatePurchase(GiftCertificateServices.java:704)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> java.lang.reflect.Method.invoke(Unknown Source)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:96)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:54)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:149)
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:240)
> java.lang.Thread.run(Unknown Source)
>
>
> -----------------------------***************-----------------------------------------------------
>
>
>
> Raj Saini wrote:
>  
>> There is extensive XML data import and export facility available in
>> OFBiz. Look at webtools application for details. You will find the link
>> in the footer. You can look at demo data files in "data" folder of
>> e-commerce application.
>>
>> There were recent discussion about excel import. Search for "Product
>> Upload" thread on Nabble.
>>
>> Thanks
>>
>> Raj
>> gopalbi wrote:
>>    
>>> Hello friends i need your help,
>>>
>>>                I want to implement the data import tool in the ofbiz.
>>> Suppose i have one xml or excel file i need to import them through import
>>> option. So please tell me what step i will follow and what changes are
>>> requied in the code.Please mentation step by step.
>>>
>>>
>>> Thanks & Regards:
>>>       Gopal
>>>  
>>>      
>>
>>    
>
>  

[gopalbi]

raj, we are using pre-configured code for POS. we did few changes related to ip addresses of machines to sync.This error is related to gift card purchase certificate in accounting services.but now i am totally traped in it.Since you have not configured POS so it is nice reply from your end to this problem.

Raj Saini wrote

I do not have POS configured and can't say much about it. However, it
seems to be a NullPointerException. It is very difficult to tell without
looking at your configuration and code.

Raj

gopalbi wrote:
> hello Raj i am very very thankful for your help.I have another question.
>           when my pos  is start its throwing exception like this:---
> -----------------------------***************-----------------------------------------------------
> ---- exception report
> ----------------------------------------------------------
> Service [ofbGcPurchase] threw an unexpected exception/error
> Exception: org.ofbiz.service.GenericServiceException
> Message: Service target threw an unexpected exception (null)
> ---- stack trace
> ---------------------------------------------------------------
> org.ofbiz.service.GenericServiceException: Service target threw an
> unexpected exception (null)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:108)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:54)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:149)
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:240)
> java.lang.Thread.run(Unknown Source)
> java.lang.NullPointerException
> org.ofbiz.accounting.payment.GiftCertificateServices.giftCertificatePurchase(GiftCertificateServices.java:704)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> java.lang.reflect.Method.invoke(Unknown Source)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:96)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:54)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:149)
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:240)
> java.lang.Thread.run(Unknown Source)
>
>
> -----------------------------***************-----------------------------------------------------
>
>
>
> Raj Saini wrote:
>  
>> There is extensive XML data import and export facility available in
>> OFBiz. Look at webtools application for details. You will find the link
>> in the footer. You can look at demo data files in "data" folder of
>> e-commerce application.
>>
>> There were recent discussion about excel import. Search for "Product
>> Upload" thread on Nabble.
>>
>> Thanks
>>
>> Raj
>> gopalbi wrote:
>>    
>>> Hello friends i need your help,
>>>
>>>                I want to implement the data import tool in the ofbiz.
>>> Suppose i have one xml or excel file i need to import them through import
>>> option. So please tell me what step i will follow and what changes are
>>> requied in the code.Please mentation step by step.
>>>
>>>
>>> Thanks & Regards:
>>>       Gopal
>>>  
>>>      
>>
>>    
>
>  

[Jacques Le Roux]

1. Go in Webtools app. using backoffice (8843 port)
2. Select jobs list option
3. Kill the related jop which is trying to run over and over trying to launch giftCertificatePurchase (you will find its name in the
log I guess). Though IIRW, it should be only some tries and maybe it's already stopped...

Jacques

From: "gopalbi" <[hidden email]>

>
> hello Raj i am very very thankful for your help.I have another question.
>          when my pos  is start its throwing exception like this:---
> -----------------------------***************-----------------------------------------------------
> ---- exception report
> ----------------------------------------------------------
> Service [ofbGcPurchase] threw an unexpected exception/error
> Exception: org.ofbiz.service.GenericServiceException
> Message: Service target threw an unexpected exception (null)
> ---- stack trace
> ---------------------------------------------------------------
> org.ofbiz.service.GenericServiceException: Service target threw an
> unexpected exception (null)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:108)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:54)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:149)
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:240)
> java.lang.Thread.run(Unknown Source)
> java.lang.NullPointerException
> org.ofbiz.accounting.payment.GiftCertificateServices.giftCertificatePurchase(GiftCertificateServices.java:704)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> java.lang.reflect.Method.invoke(Unknown Source)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:96)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:54)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:384)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:149)
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:240)
> java.lang.Thread.run(Unknown Source)
>
>
> -----------------------------***************-----------------------------------------------------
>
>
>
> Raj Saini wrote:
>>
>> There is extensive XML data import and export facility available in
>> OFBiz. Look at webtools application for details. You will find the link
>> in the footer. You can look at demo data files in "data" folder of
>> e-commerce application.
>>
>> There were recent discussion about excel import. Search for "Product
>> Upload" thread on Nabble.
>>
>> Thanks
>>
>> Raj
>> gopalbi wrote:
>>> Hello friends i need your help,
>>>
>>>                I want to implement the data import tool in the ofbiz.
>>> Suppose i have one xml or excel file i need to import them through import
>>> option. So please tell me what step i will follow and what changes are
>>> requied in the code.Please mentation step by step.
>>>
>>>
>>> Thanks & Regards:
>>>       Gopal
>>>
>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/Implement-the-data-import-tool-in-ofbiz.-tp17997889p17998645.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>