Bulk data upload to existing list as excel does not preserve dates/times in the Modified column? | mohara | 2024-09-23 15:34 |
Status: Active | ||
Hi: I'm not exactly sure where that documentation phrase came from originally, but it's not accurate. It's stating the negative of something that we believe has never have been true in the positive.... For datasets where that phrase was, or lists as you are using, both the "Created/CreatedBy" and "Modified/ModifiedBy" built in fields record actions on the row in LabKey - these are recorded in the audit log and not settable by a user during spreadsheet import. To accomplish what you want, you could use a "Changed" field name instead of Modified. The built in fields would reflect when you imported/edited the rows, but the data would retain when (in your case) the "Parent Dir" was last changed/modified presumably outside the system. These built in fields are also hidden by default in the UI, so you could further ease things for your users by adding a "Label" on the "Changed" field so that it showed as "Modified" to the user. Apologies for the confusion that phrase caused - I've updated to remove it. Hopefully this solution meets your needs. --Molly |
||