Menu

Lumen help

Using the Switched batch formatter for a large quantity file

The Switched batch formatter supports approximately 1000 rows of data, when entering data directly into the web browser. If you need to create a larger quantity file, you can build on a smaller one. You can use Switched batch formatter for large quantity files to create approximately 10,000 rows of data.

 

Before you start, review Switched Batch Step by Step Summary and Using Switched Batch Formatter.

To use the Switched batch formatter for a large quantity file:

  1. Click Orders, click Manage Orders, then click Batch.
Batch Order
  1. In the Ordering Type field, select the Switched radio button.
Batch Order (showing Switched selected)
  1. Use the Switched Batch Formatter tool to validate a single or few rows of data.
  1. Save the file to get the GBUS formatting (header/trailer records, see GBUS File Format).
  1. Open saved text file in Excel.
  1. Change All Excel Files to All Files, or Text Files.
  1. Then find and open the saved text file from Web-Based Switched Batch Formatter Tool.
Switched Batch Template Excel All Files
  1. Click Next through this Text Import Wizard – Step 1 of 3.
Text Inport Wizard - Step 1 of 3
  1. Click Next through this Text Import Wizard – Step 2 of 3.
Text Inport Wizard - Step 2 of 3
  1. Click Next through this Text Import Wizard – Step 3 of 3.
Text Inport Wizard - Step 3 of 3
  1. Your data loads into Excel; you can insert additional rows and data.
  1. Change the trailer record “TTTTT REC_CNT=1” to the new number of rows. Here it has been changed to “TTTTT REC_CNT=3”.
Switched Batch Excel Trailer
  1. Finished adding your data; save the file as a .txt file.

    Your file is ready to upload for processing.
  1. Upload the file; in Orders > Manage Orders > Batch > Switched > browse to upload file.
  1. Review your results: go to Orders > Order Status > Preliminary Order Status and locate batch file to review results.