Micronet Adaptor (2.0-2.9) Adaptor Routine: Text File Order Import

Please make sure you have read through the Get Started/Overview and the Connector Adaptor Micronet (version 2.0-2.9) documents before reading further on.

The Text File Order Import routine looks for files in a specified filesystem location. It opens files in the directory that match the specified allowed extensions set for the routine.

It tries to read and parse the file data that's been made up of orders and products. Each row in the file consists of one order and one product. If multiple rows contain the same order ID then a single order will be created in the connector, containing multiple products from the given rows.

The routine's file parser works by first putting all the order data into a table form, based on character(s) that denote each column of the file data as well as each row.
Once a file's data has successfully been parsed into a table, then the routine will then try to match the data of each column name in the first row of the file, containing the same name configured in the connector routine's Data Fields settings. 

If the fields match up correctly then the routine will extract out each row of data into orders for the Connector (excluding the first row, since it has the column names). To do this each row must set the Order ID for the order, as well as the product Item ID.

If the Accounting Connector orders have been successfully created, they will be then saved to the connector. Optionally checks can be performed to check that the products in the order exist in the adaptor's defined Micronet, as well as optionally check if any pricing matches in Micronet.

If product and pricing checks succeed, or are not required, and the adaptor is automatically set to import orders into Micronet once they have been created in the connector, then the routine will try to generate the order files for Micronet's DataConnect application. DataConnect can then import the order file into Micronet, based on the adaptor's settings.

After all files in the directory have been read through, the routine can optionally send out an Email notification (in HTML form) containing a report of all the order files that were attempted to be imported.

Routine Process Diagram

The diagram shows the process of importing text files into the connector with the Micronet adaptor routine.

Steps of the Routine Process:

1. Find and parse the order files from a specified directory.
2. Insert the orders from each file into the Accounting Connector.
3. Move each text file into the success directory once all orders in it have been successfully saved to the connector. Put the datetime in its filename when placed (this limits files from being copied over).
4. Optionally query Micronet via ODBC to check that the order products exists, and optionally have the correct pricing.
5. Optionally create order files for Micronet's DataConnect service to read in. Mark orders in the connector as being imported.
6. Optionally email out a report with details of the routine that just ran.
7. Micronet's DataConnect grabs any order files in its directory and imports them into Micronet as picking slips.

Example Text File.txt

Example text file containing multiple orders and products for each.

1. Open up the Accounting Connector application.
2. In the Adaptors and Message tab, Under the Accounting System Adaptors section, click on the Settings button against a listed Micronet version 2.0-2.9 adaptors.
3. Click on the Accounting Routines tab.
4. In the Routine Type drop down, select the Text File Order Import option, then click the Create Routine button.
5. In the Routine Code text box enter a name for the routine, then press the Save Routine button.

Once the routine has been created, each of the data fields in the text file need to be defined against the routine, based on the column names from the first line of the text file. You will be mapping the text file fields as "source fields" to the Accounting Connector's "destination fields" for orders.

1. In the Data Fields tab, click on the Add Data Field button. A new data field row will get created.
2. For the new row, set the Source Field to have a value the same as one of the header fields in the text file.
3. In the Source Field Label set a meaning value that describes the source field.
4. In the Destination Field, choose an ordering field for the data to be placed into from the source field of the text file.
5. Continue steps 1 to 4 until all relevant columns from the text file have been listed.

Notes:

• Ensure that the orderID, orderProductItemID, orderProductQuantity destination fields have been mapped to source fields. These fields are mandatory to create orders in Micronet.
• The orderAccountID destination field must be assigned to a source field, but only if the routine's Order Account ID setting has a blank value. This ensures that an account ID is assigned against an order, otherwise the order won't import into Micronet.

1. Click on the Settings tab of the routines.
2. For each row in the settings table, click on the Setting Value field.
3. Enter a setting value, then click to the next row. The setting will automatically save once the cursor exits the field.

Notes:

• In the Routine Settings section below describes what each of the settings does. Use this to configure the routine.
• If a red icon appears in the Setting Value cell, then the cell does not accept the given input. You will need to change the value in the cell to be valid.

Below are the settings that can be configured for the routine.

Text file Settings Explanation

Listed below are each of the destination data fields that you can map the source fields of the text file to.

Listed below are a majority of the messages that are generated by the routine, either through the connector logs, or in the sent email notification.