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 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