SiliconExpert Sync - User Documentation

Details

file

Name Description
Name SiliconExpert
Version 1.0
ID wex-se-sync

Overview

This extension allows a user to synchronize parts with the SiliconExpert database. The extension allows for single or multiple parts to be synced using menu actions or workflows. It can be initiated from a part, a folder page or a search. The seed object is a Part or a SuMa manufacurer part.

A SiliconExport API login is required,


Features

  • Communicates with the SiliconExpert APi
  • Manages the synchronization of attribute data
  • Mapping management
  • Sync single Part using menu action
  • Sync multiple parts using menu action
  • Sync parts contained in Promotion Request or Baseline object using workflows
  • Last update stored

User Guide

Overview

Available Action

Single SuMa Part Synchronization

A new menu action for Manufacturer Parts ‘Synchronize SuMa Part’ will pop up a window with a single button.

file

The seed object can be a part of a SuMa manufacturer part. If the seed is a part, all its associated SuMa parts are used as as the see

file

The following table will be displayed.

file

For each item the is a row for each attribute that is configured to be mapped.

The headings represent represent the following

  • Number - The part number (will be the SuMa part if no CPN was selected)
  • Com ID - The unique ID using the in the SiliconExpert database
  • Manufacturer - The manufacturer as defined in Windchill
  • Manufacturer Number - The manufacturer number as defined in Windchill
  • Attribute - The soft attribute defined in Windchill
  • Value - The current value held in Windchill
  • Sync Value - The value returned by SiliconExport
  • Icon - This will show if the Com ID is set of the state of the value vs. the sync value
  • Message - Information on the result of the last operation
  • Last Sync - The date and time of the last update of the part using sync

In this case the part have not been sychronized previously. This can been seen as the Com ID is not set

The first action is to Check values.

This will perform the following actions

  1. If the Com ID is not set a query will be sent using the manufacturer data to query for this and set it if found
  2. The Com ID is then used to query all the data based on the mapping (no changes are made)

file

This above result show that 1 part was not found in the SiliconExpert database, thus not Com ID could be retrieved. In the case more that 1 id is found an error will be shown and the data must be altered to establish a unique hit or the user can add the Com ID manually by updating the part in Windchill.

The other results show a valid part that was found. The Value is compared with the Sync Value and the icon show if it is equal of not equal.

The next action can be Set values

  1. If any part has difference the part will be checked out (if it is not already checked out)
  2. All attribute will be updated
  3. The part will be updated and checked in if it was checked out by this operation

file

Note: For a large number of parts this operation may take some time.

A Set values may be executed without a Check values this will first perform the check e.g. get the Com ID if required, and then the set will be executed.

Multi SuMa Parts Synchronization

A new menu action is contained in the folder actions drop down. A table will show of the parts you selected and their associated parts

file

Search Parts Synchronization

By searching for either SuMa parts directly or parts that have SuMa associated the user can select a number of parts from Windchill

file

By adding a search criteria, e.g. Last Sync > 1 month a search can be done to manually update a set of parts

Workflow Part Synchronization

A workflow robot has been created to Sync parts contained in a Promotion Request

com.wincomplm.wex.kernel.api.invoke.WexInvoker.invoke("com.wincomplm.wex-siliconexpert-sync","se-sync-workflow.syncFromPromotion", self);

or a Change

com.wincomplm.wex.kernel.api.invoke.WexInvoker.invoke("com.wincomplm.wex-siliconexpert-sync","se-sync-workflow.syncFromChangeNotice", self, boolean includeAffected, boolean includeResulting);

These calls will return a string with details of the operation performed

  • Total
  • Updated
  • Not Found
  • Failed
  • Warning

Administrator Guide

Connectivity

To enable the Windchill server to connect the remote server the SSL Certifcate needs to be installed

Download the SSL Certify Extension and register this server

https://app.siliconexpert.com

Configuration

The extension can be configured with the following options

Authentication

This is the login credentials for your SiliconExpert access

file

Connection

  • ID xPath - The xpath to get the Com ID
  • Login URL - The request to login to the SiliconExport database
  • Request URL - The URL to get the Com ID
  • Unique ID URL - URL to set the part data

file

Data Mapping

The soft attributes used to hold the Com Id (String) and the Last Sync (Date)

The other attributes and there xPath mapping

The xpath mapping is the root prefixed to all mappings

file

Note the attribute mapping is doing via a XPath query language giving a high level control

UI

If a group is selected only user in this group and admins have access

file

Validation

This ensures the data returned is valid

file

Example Configuration

The SuMa part soft type configuration

file

file

System

The following attributes are mandatory:

  • Comm ID = String
  • Last Sync = Time and Date
Data
  • Datasheet = URL
  • Estimated EoL = String
  • RoHSStatus = String

Diagnostics

A full diagnostics tools is provide to assist with the configuraiton

file

The diagnostic tools will make live queries against the database and allow xPath expressions to be tested on the returned XML data

file


Release Notes

1.0

Release due May 2020

Was this article helpful? Votes: 0
Article details:
Published date: 08/04/2020 8:39PM
Last updated: 30/07/2020 5:00PM (author@wincom-plm.com - author@wincom-plm.com)
Share article: 
Author: simonh@wincom-plm.com (simonh@wincom-plm.com)
Permalink: https://wex.wincom-plm.com/kb/articles/siliconexpert-sync-user-documentation