MTR Export/Import - Intergraph Smart Materials - Version 10.2 - Help - Hexagon

Intergraph Smart Materials Classic Help

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

You can click the Export button to export the selected material transfer report into an Excel file.

Only MTRs of type ‘Regular’ can be exported.

If you click this button, a box opens from which you can start the MTR export.

An exported file can be modified and re-imported again to apply the changes.

To use this export/import feature, Microsoft Excel must be installed on the application server, and the DBA settings MTR_DOWNLOAD_URL and MTR_UPLOAD_DEST must be set. For more information, see DBA Settings.

To export an MTR, select the Export Material option in the Import/Export group.

To re-import a modified Excel file, select the Import Material option. Select the only complete check box, if only complete MTRs will be imported. If this check box is selected, any line rejected due to an error will cause the entire file to be rejected. If this check box is not selected, only incorrect lines are rejected. The MTR can only be re-loaded if it is not posted and if the MTR type is 'Regular.' The import operation will not post the MTR; this task must be done on the screen when the import is completed. An Excel sheet must contain no more than one MTR. The import job creates a log file that shows the Excel line number for rejected, updated, or inserted lines and in case of rejection, the reason why the line was rejected.

To export an MTR for a nested system, select the Export for Nested System option.

Enter the file name in the File field. The default directory as assigned to the DBA setting MTR_UPLOAD_DEST is displayed in the Default Dir field.

If you have selected the Import Material option, click the Upload button to upload the Excel file to the application server.

Click the Start button to launch the export or import job. When the job is completed, you can click the View Import Log button to display the log file, which shows the Excel line number for rejected, updated, or inserted lines and the reason why this line was rejected.

When you export an MTR, a message appears as displayed below.

Click Yes to continue, and then click Open to open the Excel file. A sample of this file is displayed below.

Inserting, deleting, or renaming of columns in the Excel sheet leads to a complete rejection of the sheet and not only of a single line.

All fields in the Excel sheet can be modified. However, during the import operation, certain restrictions will be applied.

  1. The MTR can only be re-loaded if it is not posted and the MTR type is ‘Regular’.

  2. Either single lines will be rejected, or the entire Excel sheet will be rejected if one line was rejected, if you select the only complete check box.

  3. The MTR is only imported as un-posted. You must post the MTR in Smart Materials.

  4. An Excel sheet can only contain one MTR.

Restrictions for updating or inserting records in Excel:

  1. Inserting, deleting, or renaming of columns in the Excel sheet leads to a complete rejection of the sheet and not only of a single line.

  2. For lines with an internal MTR line item reference (value in ITR_ID column) the update is allowed only for the fields:

    • New Warehouse

    • New Location

    • New Status

    • Move Qty

    • Comment

  3. For lines with an internal MTR line item reference (value in ITR_ID column),the update of the following fields leads to a rejection:

    • Ident Code

    • Commodity Code

    • Tag Number

    • Warehouse

    • Location

    • Recv Status

    • Sizes 1 to 4

    • Heat Number

    • Unit

    • Ident Deviation

  4. The update of the following fields will be ignored:

    • On Hand Qty

    • Ident Short Description

  5. For lines with an internal MTR header reference (value in MTR_ID column),the update is allowed only for the fields:

    • Short Desc

    • Description

    • Transferred By

    • ETA Date

    • Shipper Reference

  6. For lines with an internal MTR header reference (value in MTR_ID column), the update of the following fields will be ignored:

    • MTR Number

    • MTR Create Date

    • Posted Date

    • Transfer Date

    • MTR Type

    • MTR Status

    • Reservation Code

    • Run Number

    • Split Result

    • Warehouse

  7. New lines can be inserted. These lines don’t have an internal MTR line item reference (value in ITR_ID column). The insert of such a record will be rejected if:

    • the line cannot be found in the inventory,

    • the line can be found multiple times in the inventory,

    • or not enough on-hand quantity is available.

  8. Lines will be rejected if no new warehouse, new location, and new status was entered, or if the entered new warehouse, new location, or new status does not exist.

A sample of an import log file is displayed below.

==============

Import only complete: N

Excelfile : C:\SMat\download\export.xls

LOG File : D:\oradata\MD2\utl\MTRIMP_141590.log

MTR Number : MTR_0001

4 Records have been rejected

Check and correct the Excel-Sheet at the following lines.

Line Reason

------------------------------------------------------------------

7 No New Warehouse, Location, Status

8 More than one line exists in the inventory

9 Not enough On Hand Qty

10 Multiple internal reference

1 Records has been inserted

Line

------------------------------------------------------------------

11

1 Records has been updated

Line

------------------------------------------------------------------

4

The possible messages displayed in the Reason column of the log file are:

  • No New Warehouse, Location, Status

    At least one of these columns must be filled.

  • Invalid ITR_ID

    It is not allowed to enter an ITR_ID manually. In this case, the ITR_ID does not exist in the MTR.

  • Invalid IVI_ID

    The line having an ITR_ID does not exist in the inventory (table m_inv_items).

  • Invalid IVPR_ID

    The line having an ITR_ID does not exist in the m_inv_pos_res table.

  • Invalid Move Qty

    A string was entered into the Move Qty of the Excel sheet. A number must be entered.

  • Not enough Resv Qty

    In the case of a reservation run, there is not enough resv qty on m_inv_pos_res.

  • Not enough On Hand Qty

    The Move Qty exceeds the on-hand qty of this inventory line item.

  • New status does not exist

  • New location does not exist

  • New Warehouse does not exist

  • Changes on lines with internal reference

    No update of the following columns allowed for lines with an ITR_ID:

    • Ident Code,

    • Commodity Code,

    • Tag Number,

    • Warehouse,

    • Location,

    • Recv Status,

    • Sizes 1 to 4,

    • Heat Number,

    • Unit,

    • Ident Deviation.

    • Empty values are allowed.

  • More than one line exists in the inventory

    The entries for a new line are not unique in the inventory.

  • Line does not exist in the inventory

    This line does not exist in the inventory

  • At least one line already exists with same unique key

    While inserting a new line a unique key violation occurred.

  • Insert not possible

    While inserting a new line a SQL error occurred.

  • Multiple internal references

    This line appears more than once in the Excel sheet with the same ITR_ID.