Import XML job automatically - Intergraph Smart Reference Data - Help - Hexagon

Prerequisites

• The CMS_BROWSER_DEFAULT_URL DBA setting must specify the CMS web browser home page URL.

• The CMS_FILE_UPLOAD_DEST DBA setting must specify the destination directory for CMS file upload.

• Assign a default commodity code to project default ZX_DFPIMCC. This commodity code is used as the default CMS commodity code. For the sake of clarity, it is recommended to create a commodity group CMS, with a commodity part CMS, and a commodity code CMS.

  

• Commodity codes of type Other for CMS classes that were imported are created in the commodity group of the default commodity code.

• Assign a value to project default ZX_CMS_ITY. This value is the default item type when creating commodity codes of type Other in CMS.

  

• Make sure that the item rules SOT and SWT have Default checked on Item Types tab (Administration > Global Setup > Materials Setup - Item Types tab) in Smart Materials application.

• The ZX_UNITSYS project default must specify the project unit system.

• The NLS/language notation must be assigned on the Languages screen (Administration > Languages) in Smart Materials application as described in Manage mapping configurations.

• If you want to map the data into the Smart 3D screens along with importing data into CMS, the following information must be provided in M_PCK_CMS_XML_CUSTOM:

  • You must provide at least one definition attribute in the procedure POPULATE_SP3D_OCURNCE_ATTR_TAB to create the definition attributes and map them to CMS class dependent properties.

  • You must provide the definition attribute whose value corresponds to a sheet name in the procedure POP_SP3DOCURNCEATTRSHTNAME_TAB. This will create a Smart 3D data table that is mapped to a CMS class.

• For the item mapping to be created on the Smart 3D Data Table Mappings screen, the template needs to be set on project defaults ZI_SP3D_TP and ZI_SP3D_CT.

  

  

CMS Internet Browser

You can access a browser window from within CMS. This feature allows you to automatically import components from a third-party system such as Thomas.Net.

CMS > XC30 CMS XML Import > XC3030 CMS Internet Browser

When you click this command, a browser is opened as shown below.

The options available are similar to other browsers such as Internet Explorer.

• Home : You can navigate to the home page by clicking this button. The default page or the home page is set by the administrator on the DBA Settings screen (Administration > Global Settings > DBA Settings) in Smart Materials application:

  For example, if “google.com” is to be selected as the home page, the administrator needs to select the corresponding value as Active as shown below:

  

• Back : To navigate a page back.

• Forward : To navigate a page forward.

• Add to Favorites : You can add any frequently visited pages to your Favorites list by clicking this button

• Go : You can type any web URL in the address bar and click the Go button to navigate to it (or just press ENTER).

• Manage Favorites : Click this button to view, rename, or delete favorites. The Rename and Delete commands are available by right-clicking one of the addresses.

  

Import from Third Party

1. Click CMS > XC30 CMS XML Import > XC3030 CMS Internet Browser.

   When you click this command, the software checks to see if the following mapping configurations exist. If they do not exist, the software creates them.

   INGR_TIN_ART_CONFIG: CMS XML mapping configuration for 'ARTICLE' with revision ‘0’ with the Standard check box checked for automatic import from the web page provided by Thomas.Net.

   INGR_TIN_STR_CONFIG: CMS XML mapping configuration for 'STRUCTURE' with revision ‘0’ with the Standard check box for automatic import from the web page provided by Thomas.Net.

   For the standard mapping configurations, with the Standard indicator selected, the highest revision available is used to start the import process.

2. Open the web page from Thomas.Net to start the import process.

3. Select any component that needs to be imported and click the download link. A pop-up window is displayed as shown below:

   

4. Click Yes to start the automatic CMS XML import process.

   When you click Yes, the following steps are performed:

   1. The folder is downloaded to a temporary location.

      Assumption: The folder contains the following files:

      XML File

      SP3D Image

      SP3D DLL

      URL File

      Smart 3D Data Table

   2. The files in the folder are unzipped to the application server.

      The physical path for the destination directory to which the files are unzipped must be specified for the CMS_FILE_UPLOAD_DEST setting in the Application Server DBA Settings tab of the DBA Settings screen in Smart Materials application.

      

   3. The import process is performed.

      Two jobs are created for parsing and importing the structure part of the file and the article part of the file. The job codes for these jobs are taken from the current system date.

   4. The files are attached to classes that have idents.

      The maximum length of the file name depends on the operating system.

      The progress of the import process can be viewed and tracked in the CMS Internet XML Import Log window as shown below. Once the documents are also attached to the classes, you can open the CMS Component Manager and view the data that was imported.

      

With the automatic import process, the following data is created or updated in CMS automatically.

• A class system is created. If the class system already exists, the data corresponding to the class system is updated.

• CMS classes are created. If the classes already exist, the data corresponding to the classes is updated.

• Documents are attached to the classes that have idents.

  

• Type mapping is created for the classes. The Smart 3D Data Table is mapped to the class that consists of class dependent properties.

  

• CMS class properties are created.

  

• If the xml file consists of class dependent properties, class dependent properties are created.

  If class dependent properties exist for a class, the following mapping is created:

  • A Smart 3D Data Table is created and mapped with the class.

  • Smart 3D attributes are created and mapped with class properties and class dependent properties.

    

    

  • Item mappings are created on the on the Smart 3D Data Table Mappings screen, and the sheet configurations are created on the Smart 3D Data Table Configurations screen.

• Idents are created.

  

• The following data is created on the Smart 3D Data Tables.

  Item mapping is created on the Smart 3D Data Table Mappings screen.

  

  On the Data Table Mappings tab, the Smart 3D Data Table, commodity group, part, and code corresponding to the CMS class are mapped.

  On the Smart 3D Data Table Configurations screen, the Data Table Configuration is created. The Configuration Name in the tree view displays the combination of the class system code and class system ID, which is the same as the Data Table Mappings.

  The Data Tables, Smart 3D attributes, and definition attributes are mapped to the Data Table Configuration on this screen.