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 <[email protected]> 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(
> "<Party partyId='";sheet1!A65;"' partyTypeId='";sheet1!B65;"'
> externalId='";sheet1!C65;"' statusId='";sheet1!D65;"' />"
> )
>
> Regards,
>
> Michael Brohl
>
> ecomify GmbH - www.ecomify.de
>
>
> Am 01.05.19 um 18:22 schrieb [email protected]:
>> 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
>
