Content: Multi Page and Dataset Model Table - Export CSV Enhancements (Additional Columns and Updates)

[zcolah]

Intro

We will be introducing new columns, refining existing ones, and updating the file naming convention for the Export CSV feature. These updates aim to enhance the clarity and usability of exported CSV files, ensuring they provide more actionable data.

Enhancements

File Naming Convention

Update the CSV file naming convention to:
[Model Name] - [ZUID] - [Date Time Downloaded].csv

• Example: BlogPosts - 12345-ZUID - 2025-01-25T14:00:00.csv

New Columns to Add

1. Created At (Date Time)

   • Display the date and time as stored in the database, including timezone information.
   • Example: 2023-12-25T10:30:00-05:00

2. Last Version Created

   • Include version number of the most recent version

3. Last Updated At (Date Time)

   • Display the date and time as stored in the database, including timezone information.

4. Last Version Published

   • Include version number of the most recent published version (only if the item has a version that is published)

5. Item Status

   • Show one of the following statuses:
     • Saved and Unpublished
     • Saved and Published
     • Saved and Scheduled to Publish
     • Published and Scheduled to Be Unpublished

6. Last Version Published At (Date Time)

   • Display the date and time of the last published version, including timezone information.

7. Created By

   • Include the name or identifier of the user who created the content item.

Column Enhancements

1. Media Column
   • Update the column to display the File URL instead of the File ZUID.

Notes

Please ensure these changes are tested for datasets with large volumes of data.