It’s an internal application that manages aspects of our billing system enterprise-wide - specifically address and serviceability information. It does not contain any client or billing information - just addresses.
The file being produced from TDA is a listing of accounts that need to have certain flags changed based on customer information in the billing system. I’ve set up my format to be the same as that needed by the other system - so it should be a simple extract, then upload and done.
I don’t know why it was determining it was binary - it just gave me a message that the file was in binary format. When I opened the file - Excel recognized as CSV - and re-saved it over itself, the system took it just fine.
The only type of file it accepts is a comma delimited text file.
The automation is set to run again at 5am tomorrow morning - I’ll see what happens then as well.