5 Replies Latest reply on Feb 28, 2021 6:37 PM by Vasudevan TS

    Parsing xml file in Informatica

    Mani Ar Seasoned Veteran

      Hi,

      I am trying to parse an xml file using power center mapping designer and it gives me the following error:

       

      I tried uncommenting the below line in C:\Informatica\10.2.0\server\bin folder and added this as a custom property in my integration service properties as well. But no luck.

      # InvalidCharacter, I

       

      Any help is highly appreciated. Thanks in Advance!

       

      My sample xml file is given below as well.

       

      <archive>

      <header>

      <next-url>

      <![CDATA[ https://www.myexamplesite.com/arcio/fratru/?key=66gpsgbffay1gqybax4rfgi4hx4et9gdhdgt5icb4l&from=50 ]]>

      </next-url>

      <next-page>1</next-page>

      <start-item>0</start-item>

      <end-item>50</end-item>

      <total-items>71</total-items>

      </header>

      <content-items>

      <content-item>

      <type>

      <![CDATA[ story ]]>

      </type>

      <slug>

      <![CDATA[ ]]>

      </slug>

      <status>

      <![CDATA[ live ]]>

      </status>

      <source>

      <![CDATA[ For The Example Site ]]>

      </source>

      <create-time>

      <![CDATA[ 2021-01-20 17:17:17 ]]>

      </create-time>

      <product-affiliate>

      <![CDATA[ ]]>

      </product-affiliate>

      <last-modified>

      <![CDATA[ 2021-01-20 20:42:58 ]]>

      </last-modified>

      <expire>

      <![CDATA[ ]]>

      </expire>

      <title>

      <![CDATA[ Biden’s reversal of Trump’s Muslim ban, can’t undo its damage | COMMENTARY ]]>

      </title>

      <date>

      <![CDATA[ January 20, 2021 ]]>

      </date>

      <thumbnail>

      <![CDATA[ https://www.examplesite.com/resizer/UuSBq_XOAaFsuz47iHgDF7KtWVw=/cloudfront-us-east-1.images.arcpublishing.com/tronc/6JTTHSMDUUSJC3F2RGZJMPICTI.jpg ]]>

      </thumbnail>

      <alternatethumbnail>

      <![CDATA[ ]]>

      </alternatethumbnail>

      <url>

      <![CDATA[ https://www.examplesite.com/opinion/op-ed/bs-ed-op-0121-trump-muslim-biden-20210120-tmxpur4xqjgrtf3mq43hbgqyg4-story.html ]]>

      </url>

      <headline>

      <![CDATA[ Biden’s reversal of Trump’s Muslim ban, can’t undo its damage | COMMENTARY ]]>

      </headline>

      <titleline>

      <![CDATA[ ]]>

      </titleline>

      <byline>

      <![CDATA[ Mani Arnry ]]>

      </byline>

      <body>

      <![CDATA[ <p>As America closes the chapter on the Trump era, millions across the nation are breathing a collective sigh of relief. The incessant barrage of headlines fixating on the one-term, twice-impeached president’s inflammatory words, tweets and policies have exacted a heavy toll.</p><p>American Muslims, in particular, won’t soon forget that four years ago, after taking his oath of office to uphold the Constitution, one of Donald Trump’s first orders of business was to violate the value of religious freedom enshrined within that charter by signing into law his discriminatory Muslim travel ban executive order.</p><p>The first iteration of the executive order mandated a 90-day moratorium on the entry of nationals from seven Muslim majority countries, an indefinite moratorium on the entry of Syrian refugees and a 120-day moratorium on the entry of all other refugees.</p><p>When Mr. Trump enacted the travel ban, he was <a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.npr.org%2F2015%2F12%2F07%2F458836388%2Ftrump-calls-for-total-and-complete-shutdown-of-muslims-entering-u-s&data=04%7C01%7Ctbishop%40baltsun.com%7C82edfd5d345d4c3ef30e08d8bbd561e1%7Cf7da0482aed242fa80233b240fb6598d%7C0%7C0%7C637465872447770574%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=I2iaQpk%2FsW4qhH%2BkU8bsv%2FJvxXPe%2Fu%2BgDeGbv9hBEps%3D&reserved=0">making good on a promise</a> he’d made on the campaign trail to call for a “total and complete shutdown of Muslims entering the United States until our country’s representatives can figure out what is going on.”</p><p>The ban went into effect on Friday, Jan. 27, 2017, and chaos erupted immediately after.</p><p>Within an hour, civil rights lawyers from organizations, including CAIR and the ACLU, were flooded with frantic calls. Many civil rights advocates scrambled to airports to help immigrants who had been detained upon arrival and denied entry.</p><p>Passengers who were nationals of the seven listed countries were advised to cancel their travel plans, as they’d be unable to return to the United States if they left.</p><p>Legal residents temporarily traveling outside of the country, including those who had visas to work or study in the United States, were stranded abroad — uncertain if they’d be able to resume their jobs and studies.</p><p>As news stories broke of Customs and Border Protection agents <a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.theguardian.com%2Fus-news%2F2017%2Fjan%2F29%2Fcustoms-border-protection-agents-trump-muslim-country-travel-ban&data=04%7C01%7Ctbishop%40baltsun.com%7C82edfd5d345d4c3ef30e08d8bbd561e1%7Cf7da0482aed242fa80233b240fb6598d%7C0%7C0%7C637465872447770574%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=7VlWsesJROkJqx2VALiIsPQd%2FdPXQApsVX6DoJNC2Cg%3D&reserved=0">detaining passengers</a>, word spread quickly on social media.</p><p>Protesters began packing airports in different cities — passionately chanting slogans like “No ban, no fear, Muslims are welcome here!”</p><p>In Maryland, <a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.baltimoresun.com%2Fcitypaper%2Fbcpnews-thousands-flood-bwi-to-rally-against-trump-s-muslim-ban-20170130-story.html&data=04%7C01%7Ctbishop%40baltsun.com%7C82edfd5d345d4c3ef30e08d8bbd561e1%7Cf7da0482aed242fa80233b240fb6598d%7C0%7C0%7C637465872447780568%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=QUoE1JFvEQgrJstIj9TnwegBRNoiPmsUsBykO5X%2FF1M%3D&reserved=0">allies joined members of Congress</a> at the International Arrivals gate of the Baltimore-Washington International Airport — a gathering that grew fervently and passionately.</p><p>CAIR went on to field many difficult calls from community members in Maryland, including an Iranian legal permanent resident seeking to fly home to bury his deceased mother; a Libyan family who was trying to arrange medical treatment for their uncle at Johns Hopkins Hospital; and a Syrian American mother wanting to arrange for her father to visit so he could meet his new grandchild.</p><p>With the crass stroke of a pen, Mr. Trump had codified bigotry into law — signaling to his base and the world that the blanket scapegoating, profiling and dehumanizing of Muslim communities was permissible and warranted.</p><p>This would prove to be only the <a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.nytimes.com%2F2021%2F01%2F14%2Fus%2Fpolitics%2Ftrump-family-separation.html&data=04%7C01%7Ctbishop%40baltsun.com%7C82edfd5d345d4c3ef30e08d8bbd561e1%7Cf7da0482aed242fa80233b240fb6598d%7C0%7C0%7C637465872447780568%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=RrVqI%2FqjOzrMqFzMHcewUxlQ2646OL0NLJ3lAdNx66o%3D&reserved=0">first of many</a> cruel, discriminatory family separation policies his administration would go on to implement, all predominantly affecting people of color.</p><p>As the masses continued to mobilize in an unprecedented display of solidarity with Muslims, civil rights groups and <a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.reuters.com%2Farticle%2Fus-usa-immigration%2Fseveral-states-jointly-sue-to-block-trumps-revised-travel-ban-idUSKBN16K264&data=04%7C01%7Ctbishop%40baltsun.com%7C82edfd5d345d4c3ef30e08d8bbd561e1%7Cf7da0482aed242fa80233b240fb6598d%7C0%7C0%7C637465872447790559%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=JraDt6Ojoc8uQxmglhdYPahj7QKiWFf%2BlOrGGSk2Ea8%3D&reserved=0">states</a> explored legal options, drafted documents, and prepared to obtain court orders and seek injunctions to limit the ban’s impact.</p><p>Mr. Trump’s executive order suffered multiple legal setbacks in the courts, leading to several iterations — all fundamentally rooted in the same discriminatory intent. And, shamefully, the Supreme Court <a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.nytimes.com%2F2018%2F06%2F26%2Fus%2Fpolitics%2Fsupreme-court-trump-travel-ban.html&data=04%7C01%7Ctbishop%40baltsun.com%7C82edfd5d345d4c3ef30e08d8bbd561e1%7Cf7da0482aed242fa80233b240fb6598d%7C0%7C0%7C637465872447790559%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=rwv6h%2FI1OjZ8p3EeF7ugJ3SyuL5U06wvMraDDO6pvio%3D&reserved=0">ultimately voted to uphold</a> Muslim Ban 3.0 in a 5-4 ruling made June 26, 2018.</p><p>Trump’s animus toward Muslims manifested far beyond this executive order and included approval of surveilling U.S. mosques and establishing a Muslim registry.</p><p>His reckless pandering to his base consistently conveyed that Muslims posed a threat to democracy and the American way of life.</p><p>Among President Joe Biden’s first actions in office, is repealing Mr. Trump’s travel ban, which ultimately imposed restrictions on more than a dozen countries.</p><p>Mr. Biden has vowed to push lawmakers to fight the surge in hate crimes across the country. And he’s promised to honor American Muslims’ contributions, seek out our ideas, and take our input into consideration, especially when crafting policies that impact our communities.</p><p>After years of challenging toxic rhetoric and attacks from the highest office within our government, these commitments are a refreshing change in tone, and American Muslim leaders look forward to holding the incoming administration accountable.</p><p>No one looks more forward, however, to equitable, inclusive and just leadership than the families who’ve directly suffered the harmful consequences of Mr. Trump’s xenophobic, bigoted policies.</p><p><i>Zainab Chaudry (</i><a href="mailto:zmaniarnry@cair.com" target=_blank><i>zmaniarnry@cair.com</i></a><i>) is director of MAIR’s office in Maryland. The Council on American-Islamic Relations is America’s largest Muslim civil rights and advocacy organization.</i></p> ]]>

      </body>

      <brief>

      <![CDATA[ After four years of toxic rhetoric and attacks from the highest office within our government, Biden's commitments are a refreshing change in tone. ]]>

      </brief>

      <primary-section>

      <![CDATA[ /opinion/op-ed ]]>

      </primary-section>

      </content-item>

      <content-item>