Tostino / soperadi-smooks

Automatically exported from code.google.com/p/soperadi-smooks
0 stars 0 forks source link

test_001 sample job : order_id, total_amount, product_id are null #3

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Run test_001 sample job

What is the expected output? What do you see instead?
Some columns (order_id, total_amount, product_id) are null. See bellow my 
output :

.--------+------------.
|      tLogRow_1      |
|=-------+-----------=|
|order_id|total_amount|
|=-------+-----------=|
|null    |null        |
'--------+------------'

.--------+---------+--------.
|         tLogRow_2         |
|=-------+---------+-------=|
|username|firstname|lastname|
|=-------+---------+-------=|
|user1   |Harry    |Fletcher|
'--------+---------+--------'

.--------+----------+--------+---------------------------+------.
|                           tLogRow_3                           |
|=-------+----------+--------+---------------------------+-----=|
|position|product_id|quantity|title                      |price |
|=-------+----------+--------+---------------------------+-----=|
|1       |null      |1       |The 40-Year-Old Virgin     |29.98 |
|2       |null      |1       |Pulp Fiction               |29.99 |
|3       |null      |20      |Robinson Crusoe            |480.0 |
|4       |null      |10      |From Russia with Love      |252.5 |
|5       |null      |25      |You Only Live Twice        |631.25|
|6       |null      |1       |The Man with the Golden Gun|25.25 |
|7       |null      |7       |A View to a Kill           |176.75|
'--------+----------+--------+---------------------------+------'

.--------+----------+--------+---------------------------+------.
|                           tLogRow_4                           |
|=-------+----------+--------+---------------------------+-----=|
|position|product_id|quantity|title                      |price |
|=-------+----------+--------+---------------------------+-----=|
|1       |null      |1       |The 40-Year-Old Virgin     |29.98 |
|2       |null      |1       |Pulp Fiction               |29.99 |
|3       |null      |20      |Robinson Crusoe            |480.0 |
|4       |null      |10      |From Russia with Love      |252.5 |
|5       |null      |25      |You Only Live Twice        |631.25|
|6       |null      |1       |The Man with the Golden Gun|25.25 |
|7       |null      |7       |A View to a Kill           |176.75|
'--------+----------+--------+---------------------------+------'

What version of the product are you using? On what operating system?
TOS 3.2.0 + http://soperadi-
smooks.googlecode.com/files/tSmooksInput_002.zip

Please provide any additional information below.
I have the same issue (product_id null) with job tests_002 and tests_003.

Original issue reported on code.google.com by nicoap...@gmail.com on 11 Oct 2009 at 7:11

GoogleCodeExporter commented 9 years ago
Hello nicoapres,

Are you sure that EDI mapping file elements have exactly the same names as 
Talen schemas?

Renat

Original comment by renat.zubairov on 11 Oct 2009 at 8:53

GoogleCodeExporter commented 9 years ago
By default, in the test smooks example we have "order-id", "total-amount",
"product-id" columns. These names need to change accordingly:
from "order-id" to "order_id",
from "total-amount" to "total_amount",
from "product-id" to "product_id"

For example, for segment ORD:

<medi:segment segcode="ORD" xmltag="order-item" maxOccurs="-1">
        <medi:field xmltag="position" />
        <medi:field xmltag="quantity" />
        <medi:field xmltag="product_id" />
        <medi:field xmltag="title" />
        <medi:field xmltag="price" />
</medi:segment>

Original comment by RnMi...@gmail.com on 12 Oct 2009 at 7:36

GoogleCodeExporter commented 9 years ago
Thanks, I updated the xml file and all is OK now!

Original comment by nicoap...@gmail.com on 12 Oct 2009 at 10:33