Load data from Xml into data base Mysql

[hiba1]

Hi,

i want to insert data into data base Mysql.

this is my job my job

why i can't load data from txmlMap to tDBOutoutBulkExec

what can i do !

Any help pealse !

[manodwhb]

What are you doing txmlmap?

[hiba1]

Hi,

txmlMap

[manodwhb]

Can you print till the textractxmlfileds component? And also share how are you extracting in textractxmlfileds?

[hiba1]

the xml look like this:

<?xml version="1.0" encoding="UTF-8"?>

-<root>

-<row>

<statusCode>200</statusCode>

<body/>

<string><?xml version="1.0" encoding="UTF-8"?> <properties xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xlink="http://www.w3.org/1999/xlink" xsi:schemaLocation="https://multicodes.giatamedia.com/xsd/1.0/properties.xsd" country="FK" lastUpdate="2020-03-03"><property giataId="619052" lastUpdate="2020-03-02T02:10:22+01:00" xlink:href="https://multicodes.giatamedia.com/webservice/rest/1.0/properties/619052"/><property giataId="877771" lastUpdate="2020-03-01T02:08:53+01:00" xlink:href="https://multicodes.giatamedia.com/webservice/rest/1.0/properties/877771"/><property giataId="936204" lastUpdate="2020-03-03T02:27:43+01:00" xlink:href="https://multicodes.giatamedia.com/webservice/rest/1.0/properties/936204"/></properties></string>

</row>

</root>

[manodwhb]

you have not configured textractxmlfields.

Check the below link
https://help.talend.com/reader/l8lekPu4A7phHaa0JC_lKQ/Wb7ZEutv1JEi8ErhQR1qlQ