Apache OFBiz Blog - March 2019 Update

[Aditya Sharma]

Hi Everyone

A brief summary of our project news for March month can be found in our
monthly blog update at the link below:
https://s.apache.org/lI4M

Thanks to Sharan Foga, Swapnil M Mane, Suraj Khurana, Deepak Dixit, Michael
Brohl, Jacques Le Roux and Pranay Pandey for their continued support.

--
Thanks & Regards
Aditya Sharma

Re: Legacy Data

[Paul Mandeltort]

Using Excel XML features: 
-In Web tools:
-Export the entity you want to work with, one at a time
- open it in Excel Windows 
- Last I checked, Mac excel XML support sucks. But Mac Excel 
sucks in general.  
- Excel will figure out the schema and embed it so you can save it as 
XML from there. 

I’m going off of memory here as I haven’t done it in a while but I’ve found at 
the time it was the easiest way to directly load/update data in the entity 
engine outside of directly writing data. 

It’s possible, but not sure if it’s advisable, to directly load data into the 
underlying database via an ETL tool like Pentaho BI. Anyone know the risks of 
doing this? I haven’t had time to research the implications. 

—P


> On May 2, 2019, at 10:12 AM, Michael Brohl  wrote:
> 
> You can also easily generate load data by Excel itself:
> 
> - create a new sheet and insert a formula concatenating the static parts with 
> the dynamic parts/cells of the data sheet (see example).
> 
> - apply the formula to each row by dragging the lower right corner of the 
> cell containing the formula for the number of rows containing data
> 
> - copy the first column and paste into the load data xml file.
> 
> Example:
> 
> =CONCATENATE(
> " externalId='";sheet1!C65;"' statusId='";sheet1!D65;"' />"
> )
> 
> Regards,
> 
> Michael Brohl
> 
> ecomify GmbH - www.ecomify.de
> 
> 
> Am 01.05.19 um 18:22 schrieb ja...@productive1.com:
>> We are trying to upload legacy customers into ofbiz using the data
>> import tool.  Is there a spreadsheet template to utilize?  I uploaded my
>> file but the "not processed" field still shows 0.  Can someone send me
>> the excel template for uploading?
>> 
>> Thanks,
>> 
>> James
> 

Re: Legacy Data

[Michael Brohl]

You can also easily generate load data by Excel itself:

- create a new sheet and insert a formula concatenating the static parts 
with the dynamic parts/cells of the data sheet (see example).


- apply the formula to each row by dragging the lower right corner of 
the cell containing the formula for the number of rows containing data


- copy the first column and paste into the load data xml file.

Example:

=CONCATENATE(
"externalId='";sheet1!C65;"' statusId='";sheet1!D65;"' />"

)

Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de


Am 01.05.19 um 18:22 schrieb ja...@productive1.com:

We are trying to upload legacy customers into ofbiz using the data
import tool.  Is there a spreadsheet template to utilize?  I uploaded my
file but the "not processed" field still shows 0.  Can someone send me
the excel template for uploading?

Thanks,

James




smime.p7s
Description: S/MIME Cryptographic Signature

Re: Legacy Data

[Pierre Smits]

Hi James,

How much legacy data are you talking about importing? It might be more
prudent to use an ETL solution to do that.

Best regards,

Pierre Smits

*Apache Trafodion , Vice President*
*Apache Directory , PMC Member*
Apache Incubator , committer
*Apache OFBiz , contributor (without privileges)
since 2008*
Apache Steve , committer


On Wed, May 1, 2019 at 6:22 PM  wrote:

> We are trying to upload legacy customers into ofbiz using the data
> import tool.  Is there a spreadsheet template to utilize?  I uploaded my
> file but the "not processed" field still shows 0.  Can someone send me
> the excel template for uploading?
>
> Thanks,
>
> James
>

Re: Legacy Data

[Jacques Le Roux]

Hi James,

Never used that but we have

https://cwiki.apache.org/confluence/display/OFBIZ/Import+Data+Using+Apache+POI+api

https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data

Look for Excel at 
https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo

Jacques

Le 01/05/2019 à 18:22, ja...@productive1.com a écrit :

We are trying to upload legacy customers into ofbiz using the data
import tool.  Is there a spreadsheet template to utilize?  I uploaded my
file but the "not processed" field still shows 0.  Can someone send me
the excel template for uploading?

Thanks,

James