Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Record Format section builds on the Record Format Flag from mentioned above. On the previous screen, we identified the location of Record Format Flag. In this section, we use that location to identify each unique record type. For Example, if we said the Record Format Flag started in 1 and was 1 position long, we can now say that calls in this file are Flag Value “C”, Taxes are “T”, etc. Each one of these unique record types is defined here. Therefore, in the Record Format Field, you select the type of data in the record type you are identifying. In the example above, this is 'Calls'. Users can enter a Flag Value. In our example, it was the letter “C” but it can be any value that the system generating the data chooses. Note: If the type of data in this record type is ‘Usage’, you must also select the Usage Type and Service Type.

Calls and Usage Import 

To get to the Usage Record Type:

Admin > Imports/Exports > Import Files > Import File Formats 

Click on the 'Add' button and in the Add New Import File Format Form, click on the Record Type Field and select the 'Usage' Record Type.Image Removed


In the 'Record Formats' Tab click on the 'Add'button to get to the 'Add New Import File 'Record Format' Form.

...

You can change the name of a Usage Type as well as add new Usage types by going to Admin > System Tables > List Values

Image Removed


Note: The PCR-360 default values for Usage Type are Data Storage and Bandwidth. However, you can add as many new values as you like.

...

To add entries into the Column Mapping table, simply select the Add button in the Grid. The data entry form looks like this:

Image RemovedImage Modified

The Map To field is required and the list of values is displayed is linked to the type of data that you will be importing in this record type. In our example, because we selected the “Call” Map Type, the Map To fields are all related to Call data. Note: Your import file may not have all of the columns in the Map To field. This is OK.

...