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.

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Darryl" <(E-Mail Removed)> wrote in message
news:E6B47A27-0B72-41E9-B0B5-(E-Mail Removed)...
> 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 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?


"Alex Dybenko" wrote:

> 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.
>
> --
> Alex Dybenko (MVP)
> http://Alex.Dybenko.com
> http://www.PointLtd.com
>
>
> "Darryl" <(E-Mail Removed)> wrote in message
> news:E6B47A27-0B72-41E9-B0B5-(E-Mail Removed)...
> > 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,
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

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Darryl" <(E-Mail Removed)> wrote in message
news:3979E4B1-E054-4BF3-B97D-(E-Mail Removed)...
> 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?
>
>
> "Alex Dybenko" wrote:
>
>> 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.
>>
>> --
>> Alex Dybenko (MVP)
>> http://Alex.Dybenko.com
>> http://www.PointLtd.com
>>
>>
>> "Darryl" <(E-Mail Removed)> wrote in message
>> news:E6B47A27-0B72-41E9-B0B5-(E-Mail Removed)...
>> > 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!
>>
>>
>>

Alex, I've got it working now... Thanks again...