The files must be located under your project or working folder:Īfter you select the directory your files are stored in you will now have the option of selecting the files. You then click on the Select Files button to first select the directory that your files are stored under. When you start the script you will see the following dialog:įrom this dialog you first choose the format that you want to import, you can only choose one format at a time. So what that means that allow the files have to follow the same parameters of the record definition, so all the text, xml and print reports are in the same format. When importing these types you can only import files that relate to the record definition you have created. The script handles the following formats: dBase, Microsoft Access, Microsoft Excel, Print Report and Adobe PDF, EBCDIC, Text Fixed Length, Text Delimited, XML.įor the Print Report, EBCDIC, Text Fixed Length, Text Delimited and XML you will first have to create a record definition for the files that you import. This script will allow you to import multiple files of the same type at the same time. So all worksheets will be imported.įixed a problem when importing Excel worksheets that have special characters. MaAdditional functionality was added so the script will now import excel files with multiple worksheets. Updated - the script could give an error if you select "Select one" then selecting files to import, this fixes the problem.ĪugAdded the option to have the original fieldname added to the file.ĪugSmall update, there was a possible problem on some computers when adding the filename to the file, thanks to yongest for identifying the error and helping me track it down.įebuary 20 KrisW added routines to read the new version of the MS access format and found a problem when listing excel files and fixed this.
MaUpdated - added an option for delimited files to select the first row as the field names.ĪpUpdated - there was a bug in the select files dialog that would not allow you to move a file from the right panel to the left.ĪpUpdated - added some code so that the script should now work with V8 or V9 without having to edit the code. This script will allow you to select and import multiple files at the same time. Please consider purchasing this application as it helps to support this web site.
This script is now available as a SmartAnalyzer application, it is available through Passport with the Utilities SmartAnalyzer applications.