84.4.5.40 STANDARD > TSS > SALES CONTRACT

Import Scope
The standard import TSS Sales Contract permits to read from a .TXT file the scheduling of a certain period, it will import all the commercial contracts (and its contractual) as well as the blocks on which they will be placed, this, according to the specified date and time interval. Summarizing, this method allows to import into Etere already-done commercial schedules.
Importing parameters
This import module requires the following parameters to be set in order to be correctly used:

Import_standard_tss_contract

•Order's files: Browse for the file to be imported, it doesn't must have a special format, it only needs to be a text (.txt) file.
•File of personal data correspondences between TSS and Etere: Optionally, indicates the delimited text file (.csv) that contains the correspondences between the personal data contained in the text file selected above and the personal data present on the Etere's database. 
Launch the import
Once the import has been configured, it can be started just by pressing the <Import> button, once the import has finished, it will be possible to display the schedule of the related day to verify and/or approve the import operation.
Sample file to import
The file to be imported using this method will have to the following structure in order to be correctly imported:
        1         2         3         4         5         6         7         8         9         0         1         2
123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
Client Name : ABSOLUTE MEDIA & MARKETING                                                            Date Range : 01/10/10 - 30/06/11
Chargecode  : AS1100                             Rep : KATE WEAVER                                      Time Range : 0600 - 3000
Agent Name  : ABSOLUTE MEDIA & MARKETING               Alice Springs and Regional combined          Station/Market : ASP
Date     Day Time Booking       Spot Stn  Day     Time   Product             Key No.         Dur'n           Cost Placement
                                        Range   Range                                                            Range Errors
 
01/10/10 Fri 1425 SF7163:14.3    STD ASP WE-FR 0630-1700 GENERIC SPORTS 2010 IMP10249           30         $20.00 ""
01/10/10 Fri 1615 SF7163:15.1    NON ASP WE-FR 0600-1700 VISITING THE REGION IMP10251           30          $0.00 ""
02/10/10 Sat 1935 SF7163:17.1    NON ASP WE-SA 1730-2330 GENERIC SPORTS 2010 IMP10249           30          $0.00 ""
01/10/10 Fri 1125 SF7163:18.2    NON ASP WE-SA 0600-2400 SPEEDWAY & GUN CLUB IMP10250           30          $0.00 ""
02/10/10 Sat 1915 SF7163:18.3    NON ASP WE-SA 0600-2400 SPEEDWAY & GUN CLUB IMP10250           30          $0.00 ""
                                                                                         =======================
                                                                  Client Total :      5       150         $20.00  ($4.00 /30sec)
                                                                                          GST              $2.00
                                                                                        Total             $22.00