Retrieving Temporary Variables

You use scripts to assign temporary, stored variables to the fields of a column.

For example, if you are working with the Georgia file, you begin by using the following script to assign the temporary variable PvarTempt1 to the GeorgiaPutCenter function.

--------------------------------------------------------------------
Function GeorgiaPutCenter [strField, strRecord]
‘------------------------------------------------------------------
‘ FDM DataPump Import Script:
‘Created by:	FDM_Admin
‘Date created: 2/28/2006
‘------------------------------------------------------------------
GeorgiaPutCenter = RES.PvarTemp1
End Function
--------------------------------------------------------------------

Then, in the Import Formats screen, you assign the script to the Expression field of the Entity row and, thus, assign the values of the temporary variables to the Entity fields. In this case, entity values are not read from the source file.

The image shows the Import Formats screen. The expression for the Entity row of the Georgia import format contains the GeorgiaPutCenter.uss script.

Because the Georgia file includes subtotal lines that must not be imported, the Skip function is required.

The image shows the contents of the Georgia.glo GL file. The file contains Subtotal rows that must not be imported.

To direct FDM to skip lines without account numbers, you configure the Skip function to recognize blank Account fields (15 blank spaces), and you drag and drop to define the start and length fields for the expression.