Currently I am doing a Scheduled export where I export the file in the MID server, but I want to modify the file by adding extra columns and value into the file which is not happening, I tried with pre and post import script but the file columns were not modified. Let me give an scenario so that understanding can be much better
1) In the Export set I have selected the 5 columns which is present in the incident table
2) I have also configured when and where to run fields to run the scheduled job.
3) I have selected the export set and then when I schedule it the file gets exported.
4)Now I need to add 4 more columns and some hardcoded data into the file where it is sent and stored into the server.
5) Also i need to change the file name which sets the attribute when the export started and when it got ended.
Can anyone please share detailed steps what modification is done and also if any scripting is required to add add the columns to the file ,please provide it(it can also be powershell script in mid server) .
