1. 

   jasmondluk, Member

   Is it able to get the file name when importing excel? Thanks
2. 

   myDBR Team, Key Master

   You can use the import finish report, which supports automatic parameter inImportFilename.

   If you update to the latest build you will also get inImportTotalRows for total rows imported and inImportErrors for the error count.

   To see how to use them, see the documentation.

   --
   myDBR Team
3. 

   jasmondluk, Member

   Thanks. What is the best way to check if the imported file, says excel file is the one with pre-defined format? Am thinking to include a version number "somewhere" in the excel file and then check it after import. Please kindly advise
4. 

   myDBR Team, Key Master

   If the import file does not match the pre-defined format, the import will simply fail.

   --
   myDBR Team
5. 

   jasmondluk, Member

   Am I able to read the header row content, says the content in first column of row 1?
6. 

   myDBR Team, Key Master

   There is no additional logic for checking the file before the import . You can check the data while it is being imported. If the data does not match the expected data, myDBR will reject the data.

   —
   myDBR Team
7. 

   jasmondluk, Member

   How myDBR can tell if the import file match the expected data? Or how to configure in myDBR what should be the expected format?
8. 

   myDBR Team, Key Master

   When you define the import report, you will define the columns, column count and datatypes. You will also define if the skip headers and footers. If the Excel file does not match the definition, the import will fail.

   --
   myDBR Team
9. 

   jasmondluk, Member

   How can I define the column count in myDBR?
10. 

    myDBR Team, Key Master

    The import report parameters should match the Excel columns. The number of parameters in the import report should be equal to Excel columns plus any additional data columns you have optionally defined in import settings. If you have no additional settings and you have data in five Excek colunms, you should have five parameters in the import report.

    See the documentation.

    --
    myDBR Team

Reply

You must log in to post.