powered by CADENAS

Manual

Manual

5.8.2.1.15.14.  Manage address data

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

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).

  1. Call the command Manage address data in PARTproject, in your catalog on categories.prj.

    -> A security message is displayed if existing data shall be overwritten.

    After confirmation the data is read in.

  2. 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)

    Classification (By Countries) and Attributes (By Countries)

    Dialog box "Class variables"

    Dialog box "Class variables"

  3. Have a look on the address data in PARTdataManager, in the docking window Details.