Discussions

Expand all | Collapse all

REFRESH KEY ISSUE

  • 1.  REFRESH KEY ISSUE

    Posted 07-23-2018 17:59
    I have a table in which I need to add the scarp data everyday. So, I connected the data to my dropbox account so that I don't have to do the task manually everyday. Now, the problem is that none of the field in the table has unique values and thus I am not able to set the refresh key. The data fails to upload as any field that I set as the refresh key has duplicate values. Also, I cannot keep the refresh key to blank as QuicBase doesn't allow me to do that.


  • 2.  RE: REFRESH KEY ISSUE

    Top
    Contributor
    Posted 07-23-2018 22:24
    It sounds like you've built a Sync table that syncs with a CSV file in your Dropbox - is that correct? Also, are you pulling in brand new data every day or is this data that would need to be updated?


  • 3.  RE: REFRESH KEY ISSUE

    Posted 07-24-2018 18:28
    yes that is correct and I am pulling in new data everyday but none of the field has unique values.


  • 4.  RE: REFRESH KEY ISSUE

    Posted 07-24-2018 19:24
    I have came in to this problem a lot of times.  What I did to get around it is to create a unique key on the CSV end via a concatenation of numerous fields.  One of my tables even has a concatenation key of 8 different fields resulting in a 76 character field!  It was the only way to get a unique key though.  Once it is done on the CSV side, create a new field (via connection) and point it to your server.  Set it as the Unique Key (click OK as it will warn you) and you should be good to go.