Catching import errors from using transfertext

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I've created a button in a form that calls the transfertext function to
import a file when it's clicked. Currently the user is not informed when
there are import errors. e.g., type conversion errors in fields - the row is
still imported, and the errors logged in a new table, but unless the user
checks the tables, he wouldn't know there was an error during importing.

is there a way to catch all these errors and prompt the user? And is there
a way to show the user the rows affected (i.e. open the table) by clicking
another button?

Thanks!
 
Hi,
what you can do:
before transfertext you delete at import errors table you have, then run
transfertext, after it you check for import errors table - once one is
exists - you can give a warning to user and then show data.
 
Hi Alex, thanks for the suggestion. How would I be able to identify which
table contains the import errors? Will the table name always be the same,
allowing me to hard code the table name in the code?
 
Hi,
i do not remember naming convention for import errors table, but once you
get it- you will know. just make you you delete any of it before
import -then once you have it after import - thn error(s) occure
 
Back
Top