Manual

Login

Manual

5.8.2.1.15. Automation 5.8.2.1.15.14. Import address information
Prev	Next

5.8.2.1.15.14. Import address information

Editing a large number of supplier address data directly in PARTproject is possible, but annoying. Better use the function Import address information.

Preparations

The classification By countries has to be installed.
Provide a CSV file with the desired address data.
- Following columns are supported:
  
  CATALOG; COUNTRY; COMPANY; DESCRIPTION; STREET; DISTRICT; ZIP; LOCATION; PHONE; FAX; EMAIL; URL; NAME
  
  Example for header line and first line:
```
CATALOG;COUNTRY;COMPANY;DESCRIPTION;STREET;DISTRICT;ZIP;LOCATION;PHONE;
 FAX;EMAIL;URL;NAME;

catalogname;DE;COMPANY KG;Hauptsitz;Müllerstraße 2;;72172;Irgendwo;+49 1111 793-0;
 +49 1111 793-33;info@company.com;http://www.compan.de/;Name
```
  Separator can be semicolon, comma or tab.
- Any column sequence may be used.
- All columns except COUNTRY are optional.
- Country codes can be viewed under $CADENAS_DATA/datasetup/classsystem/by_countries/by_countries_default.csv (column 6).

Call the command Import address information in PARTproject, in your catalog on categories.prj.
In the dialog box Choose a separator, choose the adequate separator and confirm with OK.

-> The data is read.
After selection of categories.prj under PARTproject -> tabbed page General -> Classification -> Classification (By Countries) and Attributes (By Countries) you can directly access the data.

Classification (By Countries) and Attributes (By Countries)

Dialog box "Class variables"
Have a look on the address data in PARTdataManager, in the docking window Details.

Prev	Up	Next
5.8.2.1.15.13. Add LOD Variables	Home	5.8.2.1.15.15. Resolve check

Manual

Login

Top Links

Manual

5.8.2.1.15.14. Import address information