TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Import/update csv not change modification dates and user.
Sometimes exporting a table fixing a column in a spreadsheet, then uploading it is the best way to work..
Your import tool is superb! I love how it updates, with one tiny-ity bitty issue.

When I import the table it changes all the date modified and modified by columns to the account that is doing the upload and the date..

Technically. Yes I have changed every record.
In real practicality , it is a major major problem.

Suddenly we have NO idea of the true age of the record nor who realistically made the last change. A patient calls in, our recep looks in the database to see the last person who worked with them and ITS ME!

I look in the csv and the date modified and modified by fields are exported.

In the past this has only been a major annoyance.
But in the near future I will need to do some modification to our main patient table. Having the modification column change will be a disaster.

the database should at least have the option to import them back if we choose to.
ID
866
Category
TeamDesk
Author

cooper collier
Date Created
5/11/2015 10:21:49 AM
Date Updated
8/8/2025 6:55:02 PM
Status
New Idea
Score
20
Promoted By
José de Alencar Pereira Netocooper collier
Comments
L. C. Parker 8/8/2025 6:55:02 PM
I know this is old, but I will still just say that this could be a huge data integrity issue from an audit standpoint.

Anyone still looking for a solution which allows this kind of behavior should setup a separate timestamp field, and a trigger to update it upon manual update but not load.

have not tested it, but if trigger on update doesn’t work, then a hash of key fields only changed by user in UI might work. Spitballing
Feedback
 
Back to Search Results