PDA

View Full Version : Post Updates Question

cactuscarl
03-09-2009, 03:02 PM
Assume you created your directory from an initial data load consisting of several hundred rows of data. Sometime later, you want to "refresh" the directory with new and updated information. When you upload the data, how does the system know which records are updates and which ones are new entries? Or will it just append the new import to the bottom of the list?
ryan
03-09-2009, 05:24 PM
Currently, future imports are just appended to the system. So updating previously imported data is not supported. We will be investigating a solution to this for a future update but it would require that the source CSV has some sort of unique identity column.
cactuscarl
03-09-2009, 10:04 PM
Currently, future imports are just appended to the system. So updating previously imported data is not supported. We will be investigating a solution to this for a future update but it would require that the source CSV has some sort of unique identity column.

Hmmm...I had a feeling that was the case. Perhaps a compound key like NAME+ADDRESS or NAME+PHONE would work. It wouldn't be 100% perfect but it would at least stop a bunch of duplicates.:rolleyes:
ryan
03-10-2009, 03:22 PM
We'll try to support both but in my mind, a unique column being added to the CSV file in Excel would be much more reliable than a composite.

Thanks for the suggestion.
cactuscarl
03-11-2009, 01:24 PM
We'll try to support both but in my mind, a unique column being added to the CSV file in Excel would be much more reliable than a composite.

Thanks for the suggestion.

I look forward to this enhancement :D
cactuscarl
04-24-2009, 12:09 PM
Currently, future imports are just appended to the system. So updating previously imported data is not supported. We will be investigating a solution to this for a future update but it would require that the source CSV has some sort of unique identity column.

Is this different now that you can delete a batch of data and reload a fresh one?
ryan
04-24-2009, 12:56 PM
You could undo the previous import (which was available in v1) but you'd lose any comments and ratings you had on those posts.

Updating an import or refreshing the data is still not supported at this time.
cactuscarl
04-24-2009, 12:59 PM
You could undo the previous import (which was available in v1) but you'd lose any comments and ratings you had on those posts.

Updating an import or refreshing the data is still not supported at this time.

OK thanks.