<?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: Import data via CSV into custom table in Adobe Campaign Classic Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/import-data-via-csv-into-custom-table/m-p/460725#M15677</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17495855"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can achieve the fixed list at the Load Activity level.&lt;/P&gt;&lt;P&gt;Edit the format&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Denis_Bozonnet_0-1657699308924.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/43017iAF0B1BD0721B6B58/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Denis_Bozonnet_0-1657699308924.png" alt="Denis_Bozonnet_0-1657699308924.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Select the field you want to format and click on the Detail magnifying icon&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Denis_Bozonnet_1-1657699374094.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/43018iA9C79B584C4232FF/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Denis_Bozonnet_1-1657699374094.png" alt="Denis_Bozonnet_1-1657699374094.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In the Details, use the Remapping section to fill in the expected values from the value in the file to the expected value in the data schema&lt;/P&gt;&lt;P&gt;You would have to set error to use a default value in case of error&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Denis_Bozonnet_3-1657699541522.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/43020i79F2C86E74A97308/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Denis_Bozonnet_3-1657699541522.png" alt="Denis_Bozonnet_3-1657699541522.png" /&gt;&lt;/span&gt;&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>Wed, 13 Jul 2022 08:06:06 GMT</pubDate>
    <dc:creator>Denis_Bozonnet</dc:creator>
    <dc:date>2022-07-13T08:06:06Z</dc:date>
    <item>
      <title>Import data via CSV into custom table</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/import-data-via-csv-into-custom-table/m-p/460686#M15672</link>
      <description>&lt;P&gt;Hi All,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have a use case where I am importing some data into custom table and in that table I am creating a attribute name as CompanyType as string enum using userEnum="" .I have fixed values to be entered into this column lets say A,B and C&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Now I want when user upload a csv file and when map column with this enum column all rows where it's not matching with pre fixed enums value in our database should get rejected.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;So if in csv file I have one row where companyType is D it should get rejected and also if this have small a then also it should get rejected. Only allowed values are A,B and C.&amp;nbsp;&lt;/P&gt;&lt;P&gt;Can someone please help me out how to resolve this ? As i have created userEnum as closed type still it's not working and user able to enter any values via CSV into this table.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Wed, 13 Jul 2022 04:13:46 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/import-data-via-csv-into-custom-table/m-p/460686#M15672</guid>
      <dc:creator>AC_Dev</dc:creator>
      <dc:date>2022-07-13T04:13:46Z</dc:date>
    </item>
    <item>
      <title>Re: Import data via CSV into custom table</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/import-data-via-csv-into-custom-table/m-p/460699#M15674</link>
      <description>&lt;P&gt;Hello&amp;nbsp;&lt;LI-USER uid="17495855"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can add a split before your update data activity and only accept where the value is A.B and C.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Or&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can add a condition in the "Taken into account if" section of the update data activity to only update records when A,B or C is coming in the data.&lt;/P&gt;</description>
      <pubDate>Wed, 13 Jul 2022 06:03:16 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/import-data-via-csv-into-custom-table/m-p/460699#M15674</guid>
      <dc:creator>Manoj_Kumar_</dc:creator>
      <dc:date>2022-07-13T06:03:16Z</dc:date>
    </item>
    <item>
      <title>Re: Import data via CSV into custom table</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/import-data-via-csv-into-custom-table/m-p/460703#M15675</link>
      <description>&lt;P&gt;Thanks Manoj for the alternatives but that include extra check at workflow level , since we are creating Enums as closed Type so expectation was even if we try to insert value to this field system should restrict it and give some errors.&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 13 Jul 2022 06:30:52 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/import-data-via-csv-into-custom-table/m-p/460703#M15675</guid>
      <dc:creator>AC_Dev</dc:creator>
      <dc:date>2022-07-13T06:30:52Z</dc:date>
    </item>
    <item>
      <title>Re: Import data via CSV into custom table</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/import-data-via-csv-into-custom-table/m-p/460725#M15677</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17495855"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can achieve the fixed list at the Load Activity level.&lt;/P&gt;&lt;P&gt;Edit the format&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Denis_Bozonnet_0-1657699308924.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/43017iAF0B1BD0721B6B58/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Denis_Bozonnet_0-1657699308924.png" alt="Denis_Bozonnet_0-1657699308924.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Select the field you want to format and click on the Detail magnifying icon&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Denis_Bozonnet_1-1657699374094.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/43018iA9C79B584C4232FF/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Denis_Bozonnet_1-1657699374094.png" alt="Denis_Bozonnet_1-1657699374094.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In the Details, use the Remapping section to fill in the expected values from the value in the file to the expected value in the data schema&lt;/P&gt;&lt;P&gt;You would have to set error to use a default value in case of error&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Denis_Bozonnet_3-1657699541522.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/43020i79F2C86E74A97308/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Denis_Bozonnet_3-1657699541522.png" alt="Denis_Bozonnet_3-1657699541522.png" /&gt;&lt;/span&gt;&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>Wed, 13 Jul 2022 08:06:06 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/import-data-via-csv-into-custom-table/m-p/460725#M15677</guid>
      <dc:creator>Denis_Bozonnet</dc:creator>
      <dc:date>2022-07-13T08:06:06Z</dc:date>
    </item>
  </channel>
</rss>

