XML Import table
The program description is divided up as follows:
- Remarks on Program function
- Remarks on Data fields
- Use Index to find the field description required.
Remarks on program function
The XML import tables can be updated, i.e. created, changed or deleted, with this program. Data which has already been stored can also be displayed.
Please note:
During import of XML files the XML inspector searches the directory "FILE
IMPORT" for files defined in this update program. If a matching XML file
is found in this directory this is moved to directory "XML IMPORT".
If an XSLT file is defined for this XML import file, this is transformed and the
result is then stored in directory "XML IMPORT OSC". The final data
import into the MICROS Retail OSCAR POS database is done from this directory.
If no XSLT file has been defined, it is assumed that the file to be imported matches the data format of the MICROS Retail OSCAR POS database and the file is moved directly to directory "XML IMPORT OSC" for data import.
Click on
the graphic for further help with the XML
Interface.
Remarks on data fields
The following description deals with all available options for update of this basic data.
As with nearly all other programs the following also applies here:
- The entry mask for this program may differ in your MICROS Retail OSCAR POS program. Some data fields may be missing.
- There may be defaults or firmly defined selection options for some data fields. These cannot be updated in the current program.
- Fields with enforced entry defined are to be found in the entry masks as are fields where entry is optional.
- If the data record is updated over several pages of entry masks, the dialog window is reached by clicking on the appropriate button with <Mouse key 1>.
- The same procedure also applies to call up of another update program from this program.
- In some cases you may find so-called "Switches" which are activated or deactivated by the user with <Mouse key 1>, depending on the setting. Activated switches have a dark top, deactivated switches are lighter.
Company
Entry range permitted: numeric 1 - 9999
Enter the number of the company for which the XML import tables are to be processed.
Changes or deletions can be made by calling up the data record with a number entry in the key fields. If the number is not known, the data record can be called up via the Search function.
Branch
Entry range permitted: numeric 1 - 99999
Enter the number of the branch for which the XML import table is to be processed.
Changes or deletions can be made by calling up the data record with a number entry in the key fields. If the number is not known, the data record can be called up via the Search function.
Import No.
Entry range permitted: numeric 1 - 9999
Enter the export no. for which the XML import tables are to be processed. If this number is not known, the data record can be called up via the Search function.
Import table
Entry range permitted: numeric 1 - 9999
Enter the number of the import table which is to be processed.
Table no.
Entry range permitted: alphanumeric max. 32 chars.
Enter the number of the database table for which the XML import is to be processed. If this number is not known, the data record can be called up via the Search function.
This name must be a valid name of a table in the MICROS Retail OSCAR POS database (see Application -> System -> Database -> Database table)
XML filename
Entry range permitted: alphanumeric max. 32 chars.
The name for the XML file to be imported is entered in this field. This must be a valid name of a table in the MICROS Retail OSCAR POS database (see Application -> System -> Database -> Database table). Additional details on the content of the import file must be stated in program Application -> XML -> XML Import table via button XML Attributes.
The file name in the field can be entered with the extension (XML) or as follows:
|
XML file name |
File exported to XML IMPORT OSC |
|
Delivery.xml |
Delivery.xml |
|
Delivery* |
Delivery20060315T103337.XML |
|
Delivery*.xml |
Delivery20060315T103337.xml |
The directory in which this file is stored is defined in program Branch -> Export path with the variable "XML IMPORT OSC".
Please note:
When XML files are imported the XML inspector supervises directory "FILE
IMPORT" and checks files which are defined in this program. If a matching
XML file is found in this directory this will be moved to directory "XML
IMPORT". If a XSLT file is defined for this XML import file it will be
transformed and the result will be stored in directory "XML IMPORT
OSC". Final import into the MICROS Retail OSCAR POS database is done from this
directory.
If no XSLT file is defined it is assumed that the file to be imported matches the data format of the MICROS Retail OSCAR POS database and the XML file is moved directly to directory "XML IMPORT OSC" for data import.
XSL filename
Entry range permitted: alphanumeric max. 32 chars.
The name of the XSLT file is stated in this field. This file is used for transformation of the XML import file.
The directory for the storage location of this file is defined in program Branch -> Export path with the variable "XML STYLESHEET".
Please note:
If no XSLT file is defined it is assumed that the file to be imported matches
the data format of the MICROS Retail OSCAR POS database and the XML file is moved directly to
directory "XML IMPORT OSC" for data import.
Top tag
Entry range permitted: alphanumeric max. 32 chars.
XSD Dateiname
Entry range permitted: alphanumeric max. 32 chars.
The name of the XSD schema file is stated in this field. The schema file will be used to define the elements and attributes of an XML document.
The directory for the storage location of this file is defined in program Branch -> Export path with the variable "XML SCHEMA".
Notes:
In case of a validation failure, the import is always continued.
Manual validation
Button active: The XML
import is copied into directory "XML IMPORT MAN" to allow for manual
validation.
Button deactivated: No manual validation of the XML import file.
The XML import files can be validated manually or modified with the validation program XML import manual prior to final data import.
The directory for storage of this file is defined in program Branch -> Export path with the variable "XML IMPORT MAN".
Index
- Branch
- Company
- Import No.
- Import Table
- Manual validation
- Table no.
- Top Tag
- XML filename
- XSD filename
- XSL filename
Salzufer 8
D-10587 Berlin