Home » Categories » Solutions by Business Process » Utilities

Data Interchange-Wildcards in Input Filename

Datafile Software

Data Interchange – Wildcards in Input Filename

This change to the ASCII input procedure in the Data Interchange options, for both ProFiler and Report Generator, allows the ability to specify the input filename using wildcards – i.e. C:\IMPORT\*.CSV. Any files that match the entered pattern will be imported. In addition, the processed files will be moved into a nominated folder for later reference.

Against the prompt for the External File Pathname you can now use the wildcard characters * and ? within the filename (but not within the pathname or suffix). You can therefore set the pathname such as ‘C:\IMPORT\S*.CSV’, ‘C:\IMPORT\SALES??.CSV’ or ‘C:\IMPORT\*.CSV’.

If using wildcards in the import filename you also need to set the option to Move to History Foldernominating a location to copy the file to once it has been imported. This option can also optionally be used if specify an explicit pathname.

Notes

If set to ‘Create New File’ but not ‘If Create, Append Records’ then any existing records will be cleared at the start of the import process and then all the files matching the import will be added to the database.

Similarly, if merging the import files into existing data and set to ‘Warn errors if merge’ and to ‘Print Warnings’ then one report will be created to cover errors in any of the import files.

Finally the totals display for records imported will include the count from all import files.

Custom Fields
  • Release ID: 5.6
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Input File Structure - Job Costing Batch Update
Viewed 1715 times since Thu, Jul 5, 2012
Apply Default Nominal Code to Payment Transactions
Viewed 2050 times since Fri, Oct 26, 2012
ProFiler Options
Viewed 1764 times since Thu, Jul 5, 2012
Input File Pathname - Job Costing Batch Update
Viewed 1703 times since Thu, Jul 5, 2012
Data Interchange Omit First Row from Import
Viewed 2099 times since Fri, May 27, 2016
Custom Features - Stock Batch Update
Viewed 1796 times since Thu, Jul 5, 2012
Confirm Printer - Job Costing Batch Update
Viewed 1765 times since Thu, Jul 5, 2012
User Defined Reports - Set ‘From’ Address on Email Reports
Viewed 229 times since Thu, Jan 9, 2025
Disputed Transactions on Allocation Import
Viewed 1751 times since Tue, Jun 12, 2012
End of Batch Update - Job Costing Batch Update
Viewed 1796 times since Thu, Jul 5, 2012