How To Work With LBSS Files

We'll show you how to work with LBSS files by showing an example.

First, we will open the LBSS specification library and then import an account download file and export an audit file in the examples below.

The LBSS Import Library

The LBSS import library contains the file layouts, and many other details required to import and export files for LBSS. You must select this library before using the LBSS functions.

To select the library use the File menu, Import/Export sub-menu Select Import Library option.

Check the Help topic LBSS Import Library for details on opening the import library.

Import Account Download

In this step we will import an account download file.

Normally we set up our systems so that we have an In and and Out subfolder under the CV11 folder. The In folder is where we store incoming data, and the Out folder is for outgoing data. The examples below assume these folders exist and the appropriate import files already exist in the In folder.

1. Pull down the File menu and choose Import/Export. The Import Export sub-menu is displayed.

2. Select Import File from the Import/Export sub-menu. The Import form is displayed.

3. Press F2 to select the file format to import. The list of file specifications is displayed. In this case, we are going to import an Account download file, so choose Account Download from the list.

4. Now, enter the name of the file containing the new accounts stored in the In folder. For example, if the file is named ad001000.dl enter in\ad001000.dl and select OK.

5. Select START to start importing. The import will read the file and display the header record, containing the total numbers of the different records in the file.

For more information on this import, check LBSS ACCOUNT DOWNLOAD.

As It Imports

Press the Y key to continue, and examine the next record being imported; press C to cancel, and press A to import all records from the file.

If you choose to view the records one at a time as they are being imported, you will see some records being constructed out of pieces of different parts of the file.

After Importing

At the end of the import process, a form is displayed showing the count of records processed. This is not necessarily the count of records actually imported, but is rather the count of records scanned. The number of records imported can be different than the count of records scanned, due to the conditionals built-into the import specification.

Once you select OK on the file scan summary, the Import form is displayed.

Click Totals to display the Accumulator form; this allows you to review the total count of records scanned in this import.

Click Print and choose the import summary report. If you don't have this report, go to www.collect.org and check the support area.

It is important to review the files you imported. Go to the Client and check the files to ensure the data is stored appropriately.

After importing a number of records, you may want to recalculate Debtors, Clients and daysheets using the Tools menu .

Export Agency Audit

1. Pull down the File menu and choose Import/Export. The Import/Export sub-menu is displayed.

2. Select Export File from the Import/Export sub-menu. The Export form is displayed.

3. Press F2 to select the file format to export. The list of file specifications is displayed. In this case we're going to export an Audit report, so choose Agency Upload Audit from the list.

4. Enter a name for the file.

5. Select Active in the Mode setting.

6. Select START.

You can review the Totals after exporting.