Ok I tried to find any information in internet about data which rentrak import inside itself…

Nothing related to the texts I see in the message.

In details

contains 7 columns sorted by 3rd column

1. date of day, sorted after third column
2. not sure what it, in the example mostly the same 99742 or around
3. probably number of the film, the records are sorted by this column
4. always zero
5. small integer value, though may be number of sold tickets, attendance in our case
6. may be price of the ticket
7. the same as third column

So the table is sorted by 3rd column, then by 1st one

example

09/05/21;99742;547;0;17;250.00;547
08/05/21;99742;549;0;4;250.00;549
08/05/21;99742;549;0;2;250.00;549

So after we will discuss each column – I think I will add that file.

Need to know how to schedule it. Use studio's emails same as for dgbos reports or add another pool of emails.

If the rentrak has some api – we may configure our program to send reports directly into it without of email.

This is a text file with I think hard-formatted data.

Looks like studio has known encoding, may be somewhere exists special codes for studios, cinemas, which we should use in this file, so the rentrak software then will able to use this data.

May be we will need to expand our configuration forms to fill such data for each cinema, studio – if it in use in this file.

We need completed specification with all details, also may be some testing site where we may upload such file and remote parser will give answer about ok or not.

May be somebody uses FDM reports to create such files by hands – this may give us faster development where we may sure about our program generate all details correct.

So after all details will be known – I will start to program that.

Thanks for attention

Happy day