5.8.2.1.16.21. Manage address data

Editing a larger number of manufacturer address data directly in PARTproject is possible but tedious, see Classification (By Countries).

It is better to use the Manage address data function.

The function enables both the export of already existing address data and the import.

Preparations

The By countries classification must be installed.
For initial filling, it is best to carry out an export beforehand in order to obtain the table structure. (In the index tree categories.prj selected -> under Automation context menu command Manage address data )

Manage address data -> Export

Provide a CSV file with the desired address data.

Following columns are supported:

CATALOG; COUNTRY; SORTPOS; COMPANY; DESCRIPTION; STREET; ZIP; LOCATION; PHONE; FAX; EMAIL; URL; NAME

Note

SORTPOS: Here you can optionally control the address sequence in output media. Use natural numbers for the entry. The country [Country] with the "1" is displayed in the first position by default when the page is loaded, the others follow accordingly in the list field. Under City, the city assigned to "1" is displayed accordingly, the others follow accordingly in the list field.

If there are no entries under SORTPOS, the display is alphabetically.

Example:

Column "SORTPOS" partly filled

Display in PARTdataManager -> Details

Example header and first line:

(opened in text editor)

"CATALOG"; "COUNTRY"; "SORTPOS"; "COMPANY"; "DESCRIPTION"; "STREET";         "ZIP";
 "LOCATION"; "PHONE";        "FAX";            "EMAIL";           "URL";                    
 "NAME"

"name";    "DE";      "1";        "Company"; "Hauptsitz";  "Müllerstraße 2"; "72172";
 "Irgendwo";"+49 1111 793-0";"+49 1111 793-33";"info@company.com";"http://www.com.de"/;
 "Name"

CSV file opened in spreadsheet program

	Note
	When using spreadsheet programs, make sure that no extra line with a neutral label is inserted in the first row during export and import and that UTF-8-BOM is set as the format so that, for example, umlauts and special characters are displayed correctly.

Separator should be semicolon.

The order of the columns is arbitrary.
All columns except COUNTRY are optional.
The country codes can be taken from $CADENAS_DATA/datasetup/classsystem/by_countries/by_countries_default.csv (column 6).

Procedure

Call up the Manage address data command in PARTproject, in your catalog at categories.prj.

-> The dialog box of the same name with the Export and Import options opens. Click on the Browse button ... you can select the desired file.

After confirming with OK, the data is exported or imported. A confirmation prompt is displayed during the import, as existing data is overwritten.
After selecting categories.prj you have direct access under PARTproject -> tab page General -> Classification -> Classification (By Countries) and Characteristics (By Countries) you have direct access to the data.

Classification (By Countries) and Attributes (By Countries)

Class variables " dialog box
View the address data in PARTdataManager, in the docking window Details.

Prev	Up	Next
5.8.2.1.16.20. Enrich the catalog with accessory information	Home	5.8.2.1.16.22. Move CNSMASSEXACT form CNSGEOMBASE to CNSPHYPROP