Date Range - Intergraph Smart Instrumentation - Help - Intergraph Process, Power & Marine Documentation

Intergraph Smart Instrumentation SAP Export Utility

PPMProductFamily
Engineering and Schematics
PPMProduct
Intergraph Smart Instrumentation
PPMCategory
Help
Version_SPI_custom
2018 (12.0)

Click one of the following options for filtering the data:

  • All — Exports data for the entire plant.  For this option, the software does not export deleted data

  • Filtered by date — Filters the data for the date range specified in the From and To date boxes.  The software uses the format mm/dd/yy hh:mm:ss.  You can use the spin box in each field to increment the month, day, and year, and hours, minutes, and seconds independently.

  • From last retrieve — Filters the data that has changed since the last time that you retrieved data from the Smart Instrumentation database using the current profile.  The indicated time is the time of completion of the export process.  The software specifies the last retrieve date per profile.  Regardless of the data range option you choose, the software stores the last retrieve date in the INT-SAP.ini file under the [<Profile name>] section using the parameter LastRetrieveDate.  You can change the value manually in the file if you want to, for example:
    LASTRETRIEVEDATE = 31/07/01 19:48:05

To enable the utility to work when you select the From last retrieve option, the SAP Export Utility (SAPSyn) must be installed, even if you are running the SAP export from within Smart Instrumentation.

From (mm/dd/yy hh:mm:ss) — The start date and time in the range when you click Filtered by date or From last retrieve.

To (mm/dd/yy hh:mm:ss) — The end date and time in the range when you click Filtered by date or From last retrieve.

All values in the From date and To date fields refer to the dates and times on the database server.  This is important if the server is in a different time zone from the client machine on which you are working.  To synchronize data retrieval correctly, it is recommended that you set the clock on the client to the date and time on the server while running the SAP Export Wizard.

Include

These options are only available when you click Filtered by date or From last retrieve. Select the check boxes as required to specify the type of data to include in the export. You must select at least one of the check boxes and your EDE View must include the Movementflag column. The value in the Movementflag column determines how SAP handles the data (delete, insert, or update). This column can appear in the select list in any position other than the last position.

Deleted data — Include deleted data for export.

Inserted data — Include inserted data for export.

Updated data — Include updated data for export.