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.

[shrunyan]

The intent of the existing CSV export was to full fill a need for content export from a model. The concept of "Item Status", "Last Version Published" and "Last Version Published At (Date Time)" are represented by data in the publishings API. This data can be hydrated into this function but we should probably validate a need before we commit to that work.

[zcolah]

@shrunyan
What are your thoughts on making the Media field be file urls?