Ron,
Here is an sample of the data. I don't know if the ACCOUNT entity has the
SIC CODE field or not but I am hoping able to create it it is not exist.
Thank you. Tom
CUST# OR PartyID CUST NAME SIC CODE DESCRIPTION EMAIL ADDRESS PHONE
NUMBER City Country Assign To
100012 FOUR SEASONS HOTEL 13 Miscellaneous [email protected] 254 555-4534
USE USA Leslie
A. Smith 100041 ABC ELECTRIC 02D Electrical Contracto [email protected] 506
445-4433 RES CA Leslie A. Smith 100143 ABC INDUSTRIES 5 Steel/Metal
Working/ [email protected] 254 555-4534 USE USA Leslie A. Smith 100144 COMPUGAS
USA 13 Miscellaneous [email protected] 506 445-4433 USE CA Leslie A. Smith
100151 ABJ
EQUIPFIX 13 Miscellaneous [email protected] 254 555-4534 USE USA Leslie A. Smith
100157 COMPONENTS SOLUTIONS 13 Miscellaneous [email protected] 506 445-4433
USE CA Leslie
A. Smith 100298 COUNTY FOODS 6 Food/Brewing/or anyb [email protected] 254
555-4534 USE USA Leslie A. Smith 100309 ZON LED LLC 9 Electrical OEM/Contr
[email protected] 506 445-4433 RES CA Leslie A. Smith 100349 AIR FILTER
INTERNATIONAL IN 10 NON-Electrical OEM [email protected] 254 555-4534 RES USA
Leslie
A. Smith 100465 BROTHERS MEAT PACKING CO 13 Miscellaneous [email protected] 506
445-4433 USE CA Leslie A. Smith 100577 QUANTUM GRAPHICS 3
Printing/Paper/Publi [email protected] 254 555-4534 USE USA Leslie A. Smith
100593 WIRE WORLDGROUP 5 Steel/Metal Working/ [email protected] 506 445-4433 USE
CA Leslie A. Smith 100651 AIR CONDITIONING SERVICE INC 13 Miscellaneous
[email protected] 254 555-4534 RES USA Leslie A. Smith 100674 SAFE INDUSTRIAL
SUPPLY INC 13 Miscellaneous [email protected] 506 445-4433 USE CA Leslie A. Smith
On Mon, Jan 12, 2015 at 11:15 AM, Ron Wheeler <
[email protected]> wrote:
> I am just putting together an example of how to use ADTransform to prepare
> product data to go into OFBiz.
>
> If you would could send me some sample data in Excell, I would prepare the
> ADTransform configuration to create the XML import file required to load
> Party data.
> You could then use ADTransform to prepare the real data for import.
>
> Ron
>
>
>
> On 12/01/2015 3:34 AM, Jacques Le Roux wrote:
>
>> Nothing specific, but here are few ways:
>> https://cwiki.apache.org/confluence/display/OFBIZ/
>> Handling+of+External+data
>> https://cwiki.apache.org/confluence/display/OFBIZ/
>> Import+Data+Using+Apache+POI+api
>> https://cwiki.apache.org/confluence/display/OFBENDUSER/
>> OFBiz%27s+Data+File+Tools
>>
>> Jacques
>>
>>
>> Le 12/01/2015 05:17, Tom Running a écrit :
>>
>>> Mass Account Data Import:
>>>
>>> I am trying out version 13.7.01
>>> Under SFA Manager, Accounts User Interface.
>>>
>>> I have lot of account records from an excel spreadsheet that I want
>>> to import to the Accounts table (not sure if it call account table or
>>> something else).
>>> These are the fields within the Accounts UI that I want to import.
>>>
>>> PARTY ID
>>> EMAIL ADDRESS
>>> PHONE NUMBER
>>> CITY
>>> COUNTRY
>>> ASSIGN TO
>>>
>>>
>>> Would you provide some guidance on how to accomplish this.
>>> Perhaps, what table is handling the Accounts information?
>>> How to go about import the data?
>>>
>>> Is there an import template (batch job) available some where?
>>>
>>> Thank you.
>>> Tom
>>>
>>>
>>
>
> --
> Ron Wheeler
> President
> Artifact Software Inc
> email: [email protected]
> skype: ronaldmwheeler
> phone: 866-970-2435, ext 102
>
>
