| CarolR 2004-02-08, 8:43 am |
| If a code cannot be found, map a very long text such
as "***ERROR*** product code not found for incoming
code .... " to an output field that is very short (example
max length = 1). This will force the mapping to fail with
an error saying that the data is too long for the field.
When you view the document in the suspended queue (right-
click and 'View Document'), you will see the error message
above in the field that you mapped it to and you will know
exactly what is wrong. Using the concat functoid, you can
include the incoming code and other information from the
input record in the ERROR message.
You can use this method to make mapping fail at runtime
for any data-dependent condition, and you can formulate
the error message to give you as much detail as you need.
Hope this helps.
Carol
>-----Original Message-----
>I have set-up BTS 2002 to receive orders (attachments
>from e-mails) and to transform the incoming file into a
>another one (csv)adapted to our SOE system, using a map.
>Everything works fine, the map is alright.
>In my map, it looks up in a DB to convert incoming codes
>into our codes and this works fine. If it cannot find a
>code, it will still output the csv file with a blank.
>Question:
>Is-there a way that during the mapping process, if a code
>cannot be found, it stops the mapping process and do not
>output any csv file? Basically, if an order has got 100
>lines and only one line ahs got a blank code, I want to
>be able to reject the all order instead of processing the
>99 others...
>
>Thank you for your help.
>
>.
>
|