How to append new data in an Imported Data Project? | Experience Community
Skip to main content
JoseS
Administrator
1 year ago

How to append new data in an Imported Data Project?

  • May 6, 2022 4:35 PM UTC
  • 5 replies
  • 819 views
AshleyB
Forum|alt.badge.img+2

The imported data project type is a really helpful tool to be able to report on operational data through CX Dashboards. However, I have several use cases where new data will need to be added to the project. I have tried using the Re-import Data feature by exporting the data set and appending the new data to the export and re-importing the data but have not had success getting the data to successfully upload.

I end up having to scrap the project and build a survey project which guarantees the ability to import operational data while also being able to add new data without having to re-map the dataset in the CX dashboard every time I need to update.

Anyone have success with appending new data to an Imported Data project? Any tips?

    5 replies

    Forum|alt.badge.img

    I encounter the same problem, every time. Very frustrating, and support is basically nonexistent.

    Deepak
    QPN Level 8 ●●●●●●●●
    Forum|alt.badge.img+48
    • Deepak
    • Sep 26, 2022 7:15 PM UTC

    Hello AshleyB
    This can be tedious at times, hence you can use blank survey project and use an API task it can do the work for you easily.
    https://api.qualtrics.com/daed82306b1ea-update-response
    For the Imported data project make sure you have an ID column else Qualtrics will add new rows.
    Hope this helps

    Level 2 ●●
    Forum|alt.badge.img+3
    • romanop
    • Level 2 ●●
    • Apr 24, 2024 1:19 PM UTC

    Same issue here, quite annoying that a basic feature like this is not working correctly.

    Level 1 ●
    Forum|alt.badge.img+1
    • DaniD
    • Level 1 ●
    • Aug 27, 2024 4:03 AM UTC

    Hello AshleyB
    This can be tedious at times, hence you can use blank survey project and use an API task it can do the work for you easily.
    https://api.qualtrics.com/daed82306b1ea-update-response
    For the Imported data project make sure you have an ID column else Qualtrics will add new rows.
    Hope this helps

    Hi @Deepak,

    I tried using the Imported data api to update the imported data with my ID being the user email. But i get an error: Supplied record does not contain uniqueID: EMAIL even though i am using an email that is in my imported data file. does the ID need to be numeric only?

    Nam Nguyen
    QPN Level 8 ●●●●●●●●
    Forum|alt.badge.img+29
    • Nam Nguyen
    • QPN Level 8 ●●●●●●●●
    • Aug 27, 2024 2:44 PM UTC

    Hello AshleyB
    This can be tedious at times, hence you can use blank survey project and use an API task it can do the work for you easily.
    https://api.qualtrics.com/daed82306b1ea-update-response
    For the Imported data project make sure you have an ID column else Qualtrics will add new rows.
    Hope this helps

    Hi @Deepak,

    I tried using the Imported data api to update the imported data with my ID being the user email. But i get an error: Supplied record does not contain uniqueID: EMAIL even though i am using an email that is in my imported data file. does the ID need to be numeric only?

    @DaniD As I know, the ID doesn’t need to be numeric only. Are you using this API, https://api.qualtrics.com/ff082082294c7-update-a-record-in-an-imported-data-project

    “Supplied record does not contain uniqueID: EMAIL” Are you putting “EMAIL” into the API or the actual email value (e.g “abcxyz@gmail.com”)?

    Nam Nguyen - XM Technology Consultant | DXCON Vietnam
    Terms & ConditionsAccessibility statement