Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

pegaz
2008-03-25 16:41:07

Hello,

Someone can help me to solve my problem?

We suppose that we have 2 xml files: file1.xml and file2.xml. Both of files have the same structure.


file1.xml:                                   |           file2.xml:
                                                |
id= 1                                         |          id= 1
first_name= MACKLEY                |           first_name=ROBINSON
last_name= bob                         |           last_name=david
                        |
                        |       id= 2
                        |           first_name=BROWN
                        |           last_name=Jenny

I need to identify the id of the added line in file2.xml and then to show the first_name and last_name.

Something like this:
id =2  | first_name=BROWN | last_name=Jenny



Regards.

pegaz
2008-03-17 14:08:49

the treatment of my job increases exponentially as well as my XML files contain too many rows :s
any solution?

pegaz
2008-03-17 13:33:08

i resolved my problem smile some wrong paramters... i fixed them and it's ok now!

cahsohtoa
2008-03-14 17:00:02

Ok I don't have any problem to have access to the ID fields.
Can you give me a screenshot of the Metadata configuration for your file (step 3)?

cahsohtoa
2008-03-14 16:50:21

ok I will have a look

pegaz
2008-03-14 14:36:59

hi,
I want to test my xml file, but i've a little bit problem. I can't reach the row's id in my xml file. I've no problem to appear for instance the "NAME" in the tLogROW

<NOTE>
    <DATE>03-14-2008</DATE>
    <PROFIL ID="id_1">
        <NAME>barrons</NAME>
    </PROFIL>
    <PROFIL ID="id_2">
        <NAME>james</NAME>
    </PROFIL>
</NOTE>


thank's

cahsohtoa
2008-03-13 18:51:00

all right see you toomorow

pegaz
2008-03-13 18:49:36

I tried it and it seems working. I'll test it again tomorrow, cuz now, i've to go. Hope seeing you tomorrow.
Best regards!

pegaz
2008-03-13 18:18:23

ok

cahsohtoa
2008-03-13 18:17:27

can you put you 2 xml files and I will do it like you?

pegaz
2008-03-13 18:10:51

i have this as an output:

Starting job projet at 18:10 13/03/2008.
NumberFormatException For input string: ""id"
NumberFormatException For input string: ""1"
NumberFormatException For input string: ""id"
NumberFormatException For input string: ""1"
Job projet ended at 18:10 13/03/2008. [exit code=0]

pegaz
2008-03-13 18:09:25

thank's

cahsohtoa
2008-03-13 18:06:50

check the format of your output field it must be a string

pegaz
2008-03-13 18:01:14

i have this error message: cannot convert string to integer  when i put: "issue in line  "+row1.id+" : "+row1.first_name+" different to "+row2.first_name

cahsohtoa
2008-03-13 17:32:42

of course, I use 2 csv files a two output

Board footer

Powered by FluxBB