Hello,
Every time, I run export by scenario, I got a fixed file name.
Can I make the file name generated with date as suffix?
Best answer by Irina
View originalHello,
Every time, I run export by scenario, I got a fixed file name.
Can I make the file name generated with date as suffix?
Best answer by Irina
View originalHi
I don’t think this feature is available in Acumatica now (generates file name dynamically) while uploading. But still, we need to get confirmation from Acumatica officials on this.
in my scenario, no report designer be involved. The file is from GI.
Hi
The option to configure export file name is available on Reports designer. Its not available on Generic inquiries.
Hope this helps,
Regards,
Now this requirement actually comes from another vendor, still, they are requiring for report on weekly basis. Just some difference with the previous vendor, the detail is as below:
Example File Name: MEM203112 ‐ File Extension is optional (.txt, .csv, .etc)
Delimiter Settings: File Should use either a pipe delimiter, comma, or fixed width. ( Ex: data|data OR data,data )
File Name: Starts with 3 letter member desiginator code provided by Frosty Acres followed by date code. (EX: MEMyymmdd.txt)
Field Qualifier: Data should be encapsulated with double quotes ( Ex: "data" )
Headers: File does not contain Headers
Taking all their requirements into consideration, I am thinking of an export scenario which export data into a csv file which encapsulate all data with double quotes will meet their need.
However, if the file name with date like “MEMyymmdd” can not be generated automatically weekly,
Can you suggest anyway to fulfil it?
Report design with schedule template and email sending looks like a way to go, but it seems the data can not be encapsulated with double quotes in that way.
There is an option when you have synchronization turned on where set up the export file naming format, for example, if you select date, each time you export the file the date will be included in the file's name but that's the only option available.
Can you say more about using synchronization to create a dynamically named export file? I have the same requirements as the other folks. Looking through the documentation I see plentiful info about Salesforce sync & HubSpot sync but I’m not getting results for export scenario sync.
Also I am pleased that it looks like I can only export records that the export scenario has not processed before, assuming I am understanding this selection list correctly.
Hi
Is this still the case on newer versions? I am trying to have my ACH export follow a certain format:
ACH _YYYYMMDD_HHMM.txt
The export scenario seems to be locked in no matter what.
I do not know if this only applies to the ACH export, but I have updated this for ACH files:
Jim
I do not know if this only applies to the ACH export, but I have updated this for ACH files:
Jim
I have tried to change this line … maybe my export scenario is bugged. I think I’ll try it on a different instance of Acumatica and see..
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.