Return-Path: Delivered-To: apmail-ofbiz-user-archive@www.apache.org Received: (qmail 65018 invoked from network); 3 Mar 2007 10:29:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 3 Mar 2007 10:29:38 -0000 Received: (qmail 28583 invoked by uid 500); 3 Mar 2007 10:29:45 -0000 Delivered-To: apmail-ofbiz-user-archive@ofbiz.apache.org Received: (qmail 28564 invoked by uid 500); 3 Mar 2007 10:29:45 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 28555 invoked by uid 99); 3 Mar 2007 10:29:45 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 03 Mar 2007 02:29:45 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [63.246.23.145] (HELO mail.hotwaxmedia.com) (63.246.23.145) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 03 Mar 2007 02:29:34 -0800 Received: (qmail 9952 invoked by uid 89); 3 Mar 2007 10:29:13 -0000 Received: from unknown (HELO ?192.168.1.9?) (jonesde@hotwaxmedia.com@unknown) by unknown with ESMTPA; 3 Mar 2007 10:29:13 -0000 Mime-Version: 1.0 (Apple Message framework v752.3) In-Reply-To: <20070303093856.0C3B910FB00A@herse.apache.org> References: <20070303093856.0C3B910FB00A@herse.apache.org> Content-Type: multipart/signed; micalg=sha1; boundary=Apple-Mail-10--810466680; protocol="application/pkcs7-signature" Message-Id: From: "David E. Jones" Subject: Re: WG: seed data database field name mapping Date: Sat, 3 Mar 2007 03:29:05 -0700 To: user@ofbiz.apache.org X-Mailer: Apple Mail (2.752.3) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-10--810466680 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed There are various ways to address this. One is to use an external tool to map your XML structure to OFBiz entity structures, like XSLT. Another option is to create a FTL file that does the mapping and then point to that file in the entity XML file and the import tool will run the transformation. -David On Mar 3, 2007, at 2:38 AM, Robert wrote: > > > Dear, > > we are about to import some data in ofbiz regularly from other > resources. > (Product/Catalog/Party) > > But these xml-files do not match the ofbiz-entity field names. Is > there any > chance to import this external data using the existing reader ? > So, is there any way to implement logical mapping for external vs. > ofbiz > data structure without extending the reader? > > Thanks > Robert > --Apple-Mail-10--810466680 Content-Transfer-Encoding: base64 Content-Type: application/pkcs7-signature; name=smime.p7s Content-Disposition: attachment; filename=smime.p7s MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGLzCCAugw ggJRoAMCAQICEGjfG2ElL0pFqiWRJ4fdW7owDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA3MDExMjIzMDAzNFoXDTA4MDExMjIzMDAz NFowSTEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEmMCQGCSqGSIb3DQEJARYXam9u ZXNkZUBob3R3YXhtZWRpYS5jb20wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDq3+Ub 9dxMqOJLcR7kzVBY5bNJ0d1Q6Sw4xoEkOpGiewv7WmKCGVcTJuX6hGmrxt7hbNzJ6eNjGwnyTH+X 4kLYEneXog0vgjWkN7L34ovnAi6q+Nv7gMyD23bsELFsZ+QYeppJyfqp3vmuHPw0L4BdnDSr/mWI +tyuS1boiwdlrfjWG0vBvY6bD6olKKtZNFXKJSuFcr3ygoym4QSMNlByzkjIq/6a301snXOO5yQx YYDLYap8AxE6XKDVx7ChSnMFO31vomqO44euAmfNX5PnCmMi+p6wyO9qLpuUuw1g9Zp3LSB5CeVS 1iNaDqWSw4s+V6D7/6BKjYEWt9B9P6htAgMBAAGjNDAyMCIGA1UdEQQbMBmBF2pvbmVzZGVAaG90 d2F4bWVkaWEuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEFBQADgYEAwIqcHWXoAueSEqFY PgrJjco1KJlYidM2AdteuFlNyowKESNDQz9I8P9GgJsOS8Kpt8olcBY28oIOxqJ28xxhS7DoqchF oHDVftJtPpIGSay6ZRnyR91tQD+//9xxlU1Zon884FllRb75NyxcsXnkXtCGK5brtKEItkiLQZZ2 NHswggM/MIICqKADAgECAgENMA0GCSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UE CBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25z dWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQD ExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZy ZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYD VQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMj VGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0A MIGJAoGBAMSmPFVzVftOucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJj WiyJFXCO3cnwK4Vaqj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHF KlSFD0gEf6e20TxhBEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNV HR8EPDA6MDigNqA0hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFp bENBLmNybDALBgNVHQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJl bDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2 H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V 2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZNd4ksdMdRv9dX2VPMYIDEDCCAwwCAQEwdjBiMQsw CQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UE AxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEGjfG2ElL0pFqiWRJ4fdW7ow CQYFKw4DAhoFAKCCAW8wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcN MDcwMzAzMTAyOTA1WjAjBgkqhkiG9w0BCQQxFgQUUCepcubUkHaC3ORAOrikEmGmfqEwgYUGCSsG AQQBgjcQBDF4MHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQ dHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhBo 3xthJS9KRaolkSeH3Vu6MIGHBgsqhkiG9w0BCRACCzF4oHYwYjELMAkGA1UEBhMCWkExJTAjBgNV BAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25h bCBGcmVlbWFpbCBJc3N1aW5nIENBAhBo3xthJS9KRaolkSeH3Vu6MA0GCSqGSIb3DQEBAQUABIIB AKbbg3nSnEYossm0H5hLmq/Wa7eHQNrzpnjev6YNAeBXIaeExmGBv+z5yS19EWLXOuu4IDqpiLVn vnsTOW/+PbyxzxOJHSMQgg17CqABZRTaTD7Y16bVro6KMUnHc734CHZEUM970ToBqlpXncFX+uQC yZfkt7X19iHTWlp+9dsL1OjheF3chZqjSCmCKOPoQ18sgph59rJVsygGP56q+ymGS0siv5EscRCu f/jM1ohjFUZECA9VtwGj3wp/Qef3X7NrokfsAgBHhDoq+Hp1EnMS9OiJNHQNaMLDjH5XzOVBdKXu dOm27SgMfDd/CjKkqqKFzbTVw+mURSUbdRy4t7IAAAAAAAA= --Apple-Mail-10--810466680--