What is a URP file?

A URP file is a plain text file that lists the data fields that should be exported in the upload file. Using a URP file enables customization of the output data that will be in your export file. This way, you get only the information you want while excluding all other unnecessary data.


Similar to a comma-separated values (CSV) file, a URP file has a specific formatting structure that must be adhered to. A specific header line, with the data fields listed below it. Each data field parameter is separated by a comma with no spaces. List each field in the order in which you want the data produced, and they will be passed to your ERP/WMS/OMS in this order.

 

Creating a URP file

To create a URP file, open a new, blank text file in your editor of choice, such as Notepad++

 

The layout of the URP file is the following:

[Detail Section]
SFSEQ=
SFNAME=
SFADDRESS=
SFCITY=
RFARV_TIME=
RFDEPT_TIME=

 

Sample URP File in Notepad++

 

A few notes:

  1. FIELD NAMES MUST BE CAPITALIZED and on their own row.
  2. The first entry will always be a 1.
  3. The second entry reflects the starting column and position of the data in question.
  4. The third entry is the number of characters used for data in the field.
  5. The fourth position is for text justification within the cell (L = Left, R = Right).
  6. The last entry number is the number of decimals places allowed to follow any given number in the field.

 

If laid out as a table, the information above would present as the following:


URP Field 

Column #

Position #

# of characters

Left/Right justified

# of decimals

SFSEQ=

1

1

4

L

0

SFNAME=

1

5

30

L

0

SFADDRESS=

1

35

30

L

0

SFCITY=

1

65

20

L

0

RFARV_TIME=

1

85

5

L

0

RFDEPT_TIME=

1

90

5

L

0

 

For additional information on URP fields, see the URP Field Names Table.

 

When you are done, save the file with a .urp extension. To ensure this is saved properly, type the file name (with extension) in with quotation marks:


 

Be sure to save this file to the DirectRoute data folder (usually C:\Program Files (x86)\TMW Systems Inc\Appian\Direct Route\Data), then update the Upload Format File (*.urp) field in File > Preferences > File Names/Paths and File > Preferences > Upload.