Hey all.
I have a complex flow that sends emails to my firm's customers a few days after their statement has been mailed, reminding them of near due payments.
I have this down to really crisp few minutes. See below
After the each for each action, an additional section is appended to a logging array.
After the flow's completion this logging array is then save in a .txt format on a network drive.
Currently the format that my logs are created in are below..... I would like to find a way to convert this into csv format so we can easily do reporting. Has anyone done anything similar.
["first_name,last_name,Note Number,Product Number,email_address,Payment Amount Due,Billed Payment Due Date,Status","Alert,Alert,123456,nan,test@test.com,nan,nan, Skipped_Not_Correct_Date","Fred,Flinstone,666555444,nan,na@email.com,nan,nan, Skipped_Not_Correct_Date","Joan and Mary,Customer,123456,nan,email@gmail.com,nan,nan, Skipped_Not_Correct_Date","John,Smith,888777666,nan,info@email.com,nan,nan, Skipped_Not_Correct_Date","Joe,Customer,123456789,123.4,email@email.com,789.60,2023-10-01, Skipped_Not_Correct_Date","Fred,Flinstone,888777666,nan,email@email.com,nan,nan, Skipped_Not_Correct_Date","Joe and Mary,Customer,234567,nan,email@gmail.com,nan,nan, Skipped_Not_Correct_Date","Jonny,Appleseed,3456789,nan,email@gmail.com,nan,nan, Skipped_Not_Correct_Date","Buggs,Bunny,123456789,nan,email@email.com,nan,nan, Skipped_Not_Correct_Date","Buggs,Bunny,3456789,nan,email@email.com,nan,nan, Skipped_Not_Correct_Date","Donald,Duck,987654321,12345.0,email@gmail.com,123.12,2023-10-01, Skipped_Not_Correct_Date","Barney,Rubble,123456789,123.10,email@email.com,208.24,2023-07-27, Skipped_Not_Correct_Date","Porky,Pigg,456789,nan,piggy@email.com,nan,nan, Skipped_Not_Correct_Date","Porky,Pigg,56789,nan,piggy@email.com,nan,nan, Success_Email_Sent"]
