<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Is list of valid values case sensitive in custom resource , hence fails to update valid values in a column? in Adobe Campaign Standard Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/is-list-of-valid-values-case-sensitive-in-custom-resource-hence/m-p/460311#M15036</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17539147"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Yes the value in the Enumeration is case sensitive and "Personal" is not the same as "personal"...&lt;/P&gt;&lt;P&gt;The best practice of data loading (and it's not Adobe specific) is to lower all String values that are used as a reference to other resources or enumeration..You also should lower the email addresses too by the way.&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;For enumeration, i would not expect the update to fail but you would have an error on the UI level. But things might have channed. What update error message have you got?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Hope this helps,&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Denis&lt;/P&gt;</description>
    <pubDate>Mon, 11 Jul 2022 08:33:46 GMT</pubDate>
    <dc:creator>Denis_Bozonnet</dc:creator>
    <dc:date>2022-07-11T08:33:46Z</dc:date>
    <item>
      <title>Is list of valid values case sensitive in custom resource , hence fails to update valid values in a column?</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/is-list-of-valid-values-case-sensitive-in-custom-resource-hence/m-p/460308#M15035</link>
      <description>&lt;P&gt;Hi All,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have configured a field name CUSTOMER_TYPE with valid values "PERSON" and "LEGAL" in custom resource (linked to profile table) and imported the column values via an import workflow. Imported file contains CUSTOMER_TYPE valid values as "Person" and "Legal". Update activity is configured correctly.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Although this workflow does not error out, It fails to update CUSTOMER_TYPE column values "Person" &amp;amp; "Legal" from imported file in profile table.&lt;/P&gt;&lt;P&gt;Is it because :&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Custom resource values and file value should be an exact match considering case sensitivity?&amp;nbsp;&lt;/LI&gt;&lt;LI&gt;Are valid values case sensitive and hence fails to update profile table ?&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Rutuja Kelkar&lt;/P&gt;&lt;P&gt;&lt;A href="https://www.linkedin.com/in/rutuja-kelkar/" target="_blank" rel="nofollow noopener noreferrer"&gt;https://www.linkedin.com/in/rutuja-kelkar/&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://twitter.com/therutujakelkar" target="_blank" rel="nofollow noopener noreferrer"&gt;https://twitter.com/therutujakelkar&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 11 Jul 2022 08:37:23 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/is-list-of-valid-values-case-sensitive-in-custom-resource-hence/m-p/460308#M15035</guid>
      <dc:creator>Rut7</dc:creator>
      <dc:date>2022-07-11T08:37:23Z</dc:date>
    </item>
    <item>
      <title>Re: Is list of valid values case sensitive in custom resource , hence fails to update valid values in a column?</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/is-list-of-valid-values-case-sensitive-in-custom-resource-hence/m-p/460311#M15036</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17539147"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Yes the value in the Enumeration is case sensitive and "Personal" is not the same as "personal"...&lt;/P&gt;&lt;P&gt;The best practice of data loading (and it's not Adobe specific) is to lower all String values that are used as a reference to other resources or enumeration..You also should lower the email addresses too by the way.&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;For enumeration, i would not expect the update to fail but you would have an error on the UI level. But things might have channed. What update error message have you got?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Hope this helps,&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Denis&lt;/P&gt;</description>
      <pubDate>Mon, 11 Jul 2022 08:33:46 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/is-list-of-valid-values-case-sensitive-in-custom-resource-hence/m-p/460311#M15036</guid>
      <dc:creator>Denis_Bozonnet</dc:creator>
      <dc:date>2022-07-11T08:33:46Z</dc:date>
    </item>
    <item>
      <title>Re: Is list of valid values case sensitive in custom resource , hence fails to update valid values in a column?</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/is-list-of-valid-values-case-sensitive-in-custom-resource-hence/m-p/460320#M15038</link>
      <description>&lt;P&gt;&lt;LI-USER uid="15740006"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Hi Denis,&lt;/P&gt;&lt;P&gt;Thank you for your help, Great solution &lt;img class="lia-deferred-image lia-image-emoji" src="https://experienceleaguecommunities.adobe.com/html/@31B4D6D7B3510763F3CBB2AAB7997408/emoticons/1f642.png" alt=":slightly_smiling_face:" title=":slightly_smiling_face:" /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;There is no update activity error, logs showed : all rows processed and updated successfully, although values were not updating in table + query fetch showed zero records for CUSTOMER_TYPE.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I re-configured the customer resource to set values "Person" and "Legal" (considering case sensitivity) and ran the import workflow.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Values are reflecting in profile table, also fetching in query now with correct number of records as expected &lt;img class="lia-deferred-image lia-image-emoji" src="https://experienceleaguecommunities.adobe.com/html/@31B4D6D7B3510763F3CBB2AAB7997408/emoticons/1f642.png" alt=":slightly_smiling_face:" title=":slightly_smiling_face:" /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 11 Jul 2022 09:50:15 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/is-list-of-valid-values-case-sensitive-in-custom-resource-hence/m-p/460320#M15038</guid>
      <dc:creator>Rut7</dc:creator>
      <dc:date>2022-07-11T09:50:15Z</dc:date>
    </item>
  </channel>
</rss>

