Import EDI Affidavits

The Import EDI Affidavits option allows you to import affidavits from specially prepared spreadsheet files into the Broadcast system for performing an EDI affidavit entry/match operation.

In order to use this option, your agency must to subscribe a service that provides station affidavit data in properly formatted spreadsheet files. Contact your MediaBank Account Manager for more information.

If the service uses different network codes than the network codes defined for your agency in Broadcast, you will need to use EDI Network Translation before you can import the edit affidavits.

To import EDI affidavits, select EDI | Import EDI Affidavits.

Import EDI Affidavits

1. Select one of the available file formats:
   
   Excel Spreadsheet
   Fixed Width Text File
   Delimited Text

   If you select the Delimited Text option, you will need to specify the delimiters.

   1. • Select the Common Delimiters option and use the drop down to select one of the available delimiters

      • Select the Custom Delimiter option and type the delimiter character in the text box.

3. Fill in the File Name text box or click the <Browse> button to search for and select the file.

4. If you want to see all the details of the import operation once it is complete, you can select the Show Detail check box. In most cases, you should leave the Show Detail check box blank.

5. Click the Next icon to begin the process.

   If file formatting errors are encountered during the process, you'll see error messages to that effect. You will then need to contact the provider and have them correct the formatting errors before you can successfully use the Import EDI Affidavits option.

6. If you did not select the Show Detail check box, skip to the next step.
   
   If you did select the Show Detail check box, you'll see the Import EDI Affidavits detail screen.

   The Import EDI Affidavits detail screen displays a table showing the rows of data that will be imported into the Broadcast system.

   While you can make changes to the data in this table, it is not recommended. If you see errors in the data, you should contact your provider and have them make the corrections.

   If you want to make changes, please contact Client Services for guidance.

   • You may delete rows that contain invalid comments. Rows containing comments begin with the numbers 24, 25, 32, 33, 42, or 52.

   • To delete one or more rows, select the adjacent Delete check box and click the Save icon.

   • To enter additional affidavits to the detail window click the Import icon .

    

7. Once the process is completed, turnaround reports print to your default outqueue showing which records were imported, which were not and why.

8. Follow the instructions for EDI Affidavit Correction and EDI Affidavit Entry/Match to complete the process of entering these affidavits into the Broadcast system and matching them.

Related Topics

• EDI Network Translation