Lumen help

Using the Dedicated 8XX batch formatter

Dedicated 8XX batch formatter File menu

Option

Function

New

Create a new order file

Open/Import

Load and edit existing order files

Save

Save the file

Save As

Save the file with a different name, extension, etc.

Save As ZIP

Save the file as a .zip file

Close

Close the active file

Close All

Close all open files

Quit

Exit the application

Dedicated 8XX batch formatter Tools menu

Option

Function

Add Row

Insert a new row

Delete Row

Delete the selected row. (The Delete key on your keyboard deletes the contents of the selected field.)

Copy Row

Copy the selected row

Paste Row

Paste a copied row

Validate

Check for format issues

Find/Replace

Find and replace an existing value with a new value

Creating a Dedicated 8XX batch file

You can create a batch by doing any of the following:

  • Type data directly into the batch formatter
  • Type data into the Dedicated 8XX batch ordering template
  • Copy header and data record from a spreadsheet and paste it into the batch formatter

 Dedicated 8XX batch formatter (new file)
 Dedicated 8XX batch formatter (showing Header Record section highlighted)
 Dedicated 8XX batch formatter (showing Data Record section highlighted)

You can find the Dedicated 8XX Batch Ordering Template in Control Center: Manage Orders > Batch > Dedicated.

The template is a spreadsheet used to arrange the data to be loaded into the Batch Formatter application,  via the CenturyLink Protected Internet Delivery [QPID] utility for scripted uploads to the Control Center folders, or in Control Center via Manage Orders > Batch > Dedicated. It is divided into three sections – Header Record, Data Record and Trailer Record. Each field must be populated with the required information for the order to be provisioned successfully.

Header & Trailer Records

  • The file must be tab-delimited
  • A tab must come before and after fields in the header and trailer
  • The Header Record must be the first line of the file and be followed by a carriage return
  • The Trailer Record must be the last line of the file

Data Records

  • A tab must follow each data field between the first and last field of each record. If a field is null, a tab should be inserted before and after the null value, e.g. if there are three fields and the second field is a null value, the format would be: Field 1{tab}{tab}Field3 where Field1 and Field3 represent the field contents
  • 84 tabs should exist for each Data Record (85 data fields)
  • When viewing the file, field spacing may be different for each record due to the tab-delimited format (e.g. the Comment_Remarks field may only be 20 characters for one record and 75 for another)
  • Do not enter a tab after the last field; use a carriage return instead
  1. Open a copy of the Dedicated 8XX Batch Ordering Template available at Control Center > Manage Orders > Batch > Dedicated:
Batch Order (with Dedicated selected)
  1. Fill in each field with the provisioning data. Insert a space in the last field (Product Transfer Indicator) by pressing the space bar followed by the Enter key (to help ensure the proper tab lengths are saved). If the file includes multiple 8XXs or rows, you can copy this last cell for each row down to the last 8XX on the order.
 Dedicated 8XX batch ordering template in Excel
  1. Delete all rows except the header, data records, and trailer.
 Dedicated 8XX batch ordering template in Excel (showing deleted header)
  1. Click File > Save As, type a new filename using the guidelines below (e.g., 06212021CTLTA.txt), select Text (Tab delimited) as the format type, then click Save.

    • use a unique file name
    • use .txt as the file extension (tab delimited format)
    • the file name must contain at least 13 characters
    • include the month, day, and year in MMDDYYYY format (e.g., 06212021)
    • include your three-digit customer code (e.g., CTL) (Control Center validates the customer code when you submit the file.)
    • include a T to indicate the file is tab-delimited
    • add a letter to indicate the number of files you've submitted today (e.g., use A for the first file, B for the second file, etc.)
  1. If prompted with a ‘multiple sheets’ decision box, click OK.
  1. When prompted with Tab-delimited decision box, click Yes.
  1. Open the file using a text application such as Notepad or Text pad (Text pad is recommended because hidden characters such as tabs, spaces, etc. can be viewed). If using Text pad, select the Visible icon to view hidden characters in the file.
  1. Remove extra spaces or tabs after the requested_due_date data field in the header row of the file.
  1. Remove extra spaces or tabs after the trailer_identifier data field found in the trailer row of the file.
  1. Click Save.

You can copy information from cells on an Excel spreadsheet into a field in the batch formatter.

  1. In the Dedicated 8XX batch formatter, open a new file. (Click File > New.)
  1. Copy the header information from the original spreadsheet, then paste it in the Header Record section of the batch formatter.
Dedicated 8XX batch formatter (showing Header Record section highlighted)
  1. Copy data information from the original spreadsheet, then paste it in the Data Record section of the batch formatter.
Dedicated 8XX batch formatter (showing Data Record section highlighted)