I can't find the document but I exported the layout that I've used. It's in a CSV format. Copy and import it into Access or Excel so you can see all of the columns.
You'll notice there are fields that you expect to populate but are not included in the layout. You'll have to populate them after importing. One is the state field. The 53 field CSV file can't be modified to add more fields but if you were to do it in XML, you could populate all of the fields you wanted to. I found this to be a quicker approach since I didn't know XML.
Remember, it will write to cicmpy, addresses and cicntp. Know what you've imported because if it's during testing, you're going to want to delete them out and you've got to delete them out of all 3 tables before you try to import them again.
The XML import function will validate the data in the CSV file, so if you left the country blank or put in an invalid entry, it will give you an error message and not import that customer.
I won't be at Engage. Too much is going to be happening then to be able to do it.
--------------------------------------------------------
No,Field name,Description,Type,Remarks,Form,
1,debnr,Debtor,Numstr,,A6,
2,naam,Name,Text,,A30,
3,adres1,Address line 1,Text,,A30,
4,adres2,Address line 2,Text,,A30,
5,postcode,Postcode,Text,,A8,
6,woonpl,City,Text,,A30,
7,landcode,Country,Text,,A3,
8,debzk,Search code,Text,Obsolete,A6,
9,valcode,Currency,Text,,A3,
10,telnr,Telephone number,Text,,A15,
11,faxnr,Telefax,Text,,A15,
12,cntpers1,Contact,Text,,A30,
13,mv1,Man/Woman/Unknown.,Text,,A1,
14,prdcode1,Title code,Text,,A4,
15,vrlttrs1,Initials,Text,,A10,
16,functie1,Job specification.,Text,,A15
17,telnrcp1,Telephone number,Text,,A15
18,banknr1,Bank account number,Elfpr,,A10
19,banknaam,Bank name,Text,Obsolete,A20
20,Empty,-,-,,A10
21,postbanknrd,Postbank account debtor,Numstr,Not supported,A10
22,betwijze,Payment method,Text,,A1
23,tegreknr,offset account,Numstr,,A9
24,dagbknr,Journal,Numstr,,A2
25,aandacht,Attention field,Y/N,,A1
26,categorie,Classification,Text,,A2
27,fakdebnr,Invoice debtor,Numstr,,A6
28,kredlimiet,Credit line,Number,,"N8,2"
29,bether,Reminder.,Y/N,,A1
30,betcond,Payment condition.,Text,,A2
31,blokkeer,Block,N/Y,,A1
32,verteg,Representative,Text,Not supported,A3
33,prijslijst,Price list,Text,,A3
34,ex_artcode,Extra item code,Text,,A2
35,levwijze,Delivery method,Text,,A3
36,korting,Discount percentage,Number,,"N3,2"
37,datlaanm,Date last reminder,Date,,A8
38,layoutcode,Layout code,Text,,A1
39,taalcode,Language code,Text,,A3
40,debsaldolj,Debit balance current financial year,Number,Obsolete,"N8,2"
41,crdsaldolj,Credit balance current financial year,Number,Obsolete,"N8,2"
42,debsaldosj,Debit balance secondary financial year,Number,Obsolete,"N8,2"
43,crdsaldosj,Credit balance secondary financial year,Number,Obsolete,"N8,2"
44,saldontvwd,debit balance to be posted.,Number,Obsolete,"N8,2"
45,saldontwvc,credit balance to be posted,Number,Obsolete,"N8,2"
46,omz_ex_lj,Revenue excluding VAT current financial year,Number,Obsolete,"N8,2"
47,omz_in_lj,Revenue including VAT current financial year,Number,Obsolete,"N8,2"
48,omz-ex_vj,Revenue excluding VAT previous financial year,Number,Obsolete,"N8,2"
49,omz_in_vj,Revenue including VAT previous financial year,Number,Obsolete,"N8,2"
50,bedrorder,Amount on order,Number,,"N8,2"
51,faktoring,Factoring,N/Y,,A1
52,btw_nummer,VAT number,Text,,A20
53,Datectrl,Check date,Date,,A6
--------------------------------------------------------
Kevin Scheeler
