https://community.qlik.com/t5/Talend-Studio/Load-data-from-Xml-into-data-base-Mysql/m-p/2280686#M55462 you have not configured textractxmlfields.<BR /><BR />Check the below link <BR /><A href="https://help.talend.com/reader/l8lekPu4A7phHaa0JC_lKQ/Wb7ZEutv1JEi8ErhQR1qlQ" target="_blank" rel="nofollow noopener noreferrer">https://help.talend.com/reader/l8lekPu4A7phHaa0JC_lKQ/Wb7ZEutv1JEi8ErhQR1qlQ</A> Sun, 05 Apr 2020 02:40:17 GMT manodwhb 2020-04-05T02:40:17Z https://community.qlik.com/t5/Talend-Studio/Load-data-from-Xml-into-data-base-Mysql/m-p/2280681#M55457 <P>Hi,</P> <P>i want to insert data into data base Mysql.</P> <P>this is my job&nbsp;<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="my job" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9eH.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/158216i250A89A0917643CE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9eH.png" alt="0683p000009M9eH.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">my job</SPAN></SPAN></P> <P>why i can't load data from txmlMap to tDBOutoutBulkExec</P> <P>what can i do !</P> <P>Any help pealse !</P> Sat, 16 Nov 2024 02:48:29 GMT https://community.qlik.com/t5/Talend-Studio/Load-data-from-Xml-into-data-base-Mysql/m-p/2280681#M55457 hiba1 2024-11-16T02:48:29Z https://community.qlik.com/t5/Talend-Studio/Load-data-from-Xml-into-data-base-Mysql/m-p/2280682#M55458 What are you doing txmlmap? Fri, 03 Apr 2020 01:51:47 GMT https://community.qlik.com/t5/Talend-Studio/Load-data-from-Xml-into-data-base-Mysql/m-p/2280682#M55458 manodwhb 2020-04-03T01:51:47Z https://community.qlik.com/t5/Talend-Studio/Load-data-from-Xml-into-data-base-Mysql/m-p/2280683#M55459 <P>Hi,</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="txmlMap" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9eg.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130127i2E7920EA36B9A27A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9eg.png" alt="0683p000009M9eg.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">txmlMap</SPAN></SPAN></P> Fri, 03 Apr 2020 11:57:03 GMT https://community.qlik.com/t5/Talend-Studio/Load-data-from-Xml-into-data-base-Mysql/m-p/2280683#M55459 hiba1 2020-04-03T11:57:03Z https://community.qlik.com/t5/Talend-Studio/Load-data-from-Xml-into-data-base-Mysql/m-p/2280684#M55460 Can you print till the textractxmlfileds component? And also share how are you extracting in textractxmlfileds? Sat, 04 Apr 2020 01:48:52 GMT https://community.qlik.com/t5/Talend-Studio/Load-data-from-Xml-into-data-base-Mysql/m-p/2280684#M55460 manodwhb 2020-04-04T01:48:52Z https://community.qlik.com/t5/Talend-Studio/Load-data-from-Xml-into-data-base-Mysql/m-p/2280685#M55461 <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rep.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9eq.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/127879iB61BE0899A9F9024/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9eq.png" alt="0683p000009M9eq.png" /></span></SPAN></P> <P>&nbsp;</P> <P>the xml look like this:</P> <P>&lt;?xml version="1.0" encoding="UTF-8"?&gt;</P> <P>-&lt;root&gt;</P> <P><BR />-&lt;row&gt;</P> <P>&lt;statusCode&gt;200&lt;/statusCode&gt;</P> <P>&lt;body/&gt;</P> <P>&lt;string&gt;&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;properties xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>" xmlns:xlink="<A href="http://www.w3.org/1999/xlink" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/1999/xlink</A>" xsi:schemaLocation="<A href="https://multicodes.giatamedia.com/xsd/1.0/properties.xsd" target="_blank" rel="nofollow noopener noreferrer">https://multicodes.giatamedia.com/xsd/1.0/properties.xsd</A>" country="FK" lastUpdate="2020-03-03"&gt;&lt;property giataId="619052" lastUpdate="2020-03-02T02:10:22+01:00" xlink:href="<A href="https://community.talend.com/" target="_blank" rel="nofollow noopener noreferrer">https://multicodes.giatamedia.com/webservice/rest/1.0/properties/619052"/&gt;&lt;property</A> giataId="877771" lastUpdate="2020-03-01T02:08:53+01:00" xlink:href="<A href="https://community.talend.com/" target="_blank" rel="nofollow noopener noreferrer">https://multicodes.giatamedia.com/webservice/rest/1.0/properties/877771"/&gt;&lt;property</A> giataId="936204" lastUpdate="2020-03-03T02:27:43+01:00" xlink:href="<A href="https://community.talend.com/" target="_blank" rel="nofollow noopener noreferrer">https://multicodes.giatamedia.com/webservice/rest/1.0/properties/936204"/&gt;&lt;/properties&gt;&lt;/string</A>&gt;</P> <P>&lt;/row&gt;</P> <P>&lt;/root&gt;</P> Sat, 04 Apr 2020 17:48:34 GMT https://community.qlik.com/t5/Talend-Studio/Load-data-from-Xml-into-data-base-Mysql/m-p/2280685#M55461 hiba1 2020-04-04T17:48:34Z https://community.qlik.com/t5/Talend-Studio/Load-data-from-Xml-into-data-base-Mysql/m-p/2280686#M55462 you have not configured textractxmlfields.<BR /><BR />Check the below link <BR /><A href="https://help.talend.com/reader/l8lekPu4A7phHaa0JC_lKQ/Wb7ZEutv1JEi8ErhQR1qlQ" target="_blank" rel="nofollow noopener noreferrer">https://help.talend.com/reader/l8lekPu4A7phHaa0JC_lKQ/Wb7ZEutv1JEi8ErhQR1qlQ</A> Sun, 05 Apr 2020 02:40:17 GMT https://community.qlik.com/t5/Talend-Studio/Load-data-from-Xml-into-data-base-Mysql/m-p/2280686#M55462 manodwhb 2020-04-05T02:40:17Z