Fill blank columns in a report with custom information(constants) - CSV
I was wondering if someone can help me. I've just been asked to make another report, a CSV file, containing account information such as sort code, account number etc. This is going to be used to set up direct debits with our bank.
The csv file needs to have roughly 30 columns per person, but only 4 or 5 of these are pieces of information from SIMS, the rest are constants that will not change. I can create the report and add in blank columns which will then allow me to export to excel and fill in the information but I was wondering if there is any way to do this within SIMS by setting a value for each blank column so that the accounts department can just upload the file without any manipulation of the data?
Thanks in advance.