Data in the XML file is imported and stored in a table. Then, Smart Materials processes the data. Error and log files that contain statistics and error messages for both steps are created.
With OSCI, you can insert and update several data for companies and suppliers according to what the Smart Materials screens allow.
You can insert or update translated descriptions for company types, companies, and qualifications.
For each of these objects [company types, company type description, companies, company descriptions, company contacts, communication links (contacts), assign company types, company addresses, communication links (address), qualifications, qualification description, supplier, supplier qualifications, supplier material groups, supplier manufacturers], the file must contain the information about why it can be found in the file. Use the following tags for this information:
A tag can be set to I, U, or N for processing:
I means that the object is to be inserted.
U means that an update is to be performed.
N means that the object is not processed, that is, neither inserted nor modified. However, the object information is needed to show the path for underlying objects. For example, if you have already created a company contact person and now you want to add another communication link, Smart Materials needs to know which company contact the communication link belongs to.
For some data, the values of project defaults are taken if no value is provided in the XML file.
If the file does not contain the tag <SUPPLIER_CURRENCY>, the value of the project default ZX_CURCY is used instead.
Each record that has been processed successfully is committed to the database. Records that are not valid are not imported. Modify the import file data and start OSCI again to import the remaining items.
OSCI creates company types, company type descriptions, companies, company descriptions, company contacts, communication links for contacts, company addresses, communication links for addresses, qualifications, qualification descriptions, suppliers, supplier qualifications, supplier material groups, supplier manufacturers, supplier attributes, and assign company types. It does not create records in referenced tables; these records must already exist. For example, in an XML file, you can only include a supplier material group that is already known in Smart Materials. If the material group cannot be found in Smart Materials, it will not be created automatically and the import will fail.