Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
GoogleCodeExporter opened this issue Aug 20, 2015 · 3 comments

Comments

@GoogleCodeExporter
Copy link

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
Copy link
Author

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
Copy link
Author

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
Copy link
Author

Thanks, I updated the xml file and all is OK now!

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant