AT&T CalNet Vendor Upload Process

The ATT CalNet portal is at https://calnet.att.com/

These are the accounts and files that need to be download for recharge:

MechSum (9391017673) - Done for April: 
    (all files … MRCs, NRCs, USGs, PRCs, Tax, Adj)
MechOth (9391020280) - MRC and TAX had charges
    (all files … MRCs, NRCs, USGs, Tax, Adj)
Main (Centrex) (9391046630)
    (USG only)
PBX (Avaya) (9391017668)
    (USG only)
LongDist (9391017663)
    (USG only)
SecureB (9391022422)
    (no charges usually, but monitor in any case)
TollFree (9391022423)
    (usually Tax and USG, but check MRC, NRC, and Adj)
VMTrunks (9391017667)
    (usually MRC and Tax, but check NRC, Adj and USG)

When downloading the files (original file name example: Detail_MRC_3_20260622181403_dclarke.xlsx), rename them by replacing the timestamp and your username with the account number:

     Examples:

     Detail_ADJ_9391017673.xlsx

     Detail_MRC_9391017667.xlsx

After the files have been downloaded, they need to be converted to CSV for upload.  William has a tool for this.  The tool will need to be tweaked each month to point to the correct directory. *UPDATE* There is a Story to convert the Source Data Definition to use the xlsx format.  When this happens, we will no longer have to convert the files.

Darin likes to navigate the command line by typing a command (like cd) and then using the tab key to cycle through the file names.  Also, typing the first letter of the file name and tabbing helps speed the process.

Now you are ready to use the Source Data Definitions to upload the files.  The How to Perform a Vendor Upload Knowledge Base article walks through the upload process. 

To note when processing through the Source Data Definitions (SDD):  The NRC and PRC files are processed with the CalNet OCC SDD.