rename-files-date-prefix

Rename Files with Date Prefix

Rename all files in a SharePoint document library to prefix them with their created date in yyMMdd format (e.g., 251203-Status Report.pdf).

Steps

1. Identify the Target Library

• Use the current document library if the user doesn't specify one.
• Call get_current_list_or_library to get the library ID.

2. Get the Library Schema

• Call get_list_schema to confirm the library has Created and FileLeafRef fields and to understand the structure.

3. Retrieve All Files (Including Subfolders)

• Call get_list_item_metadata with fetchAll: true to retrieve all items.
• Use a CAML query that filters to files only (FSObjType = 0):

  <Query><Where><Eq><FieldRef Name='FSObjType'/><Value Type='Integer'>0</Value></Eq></Where><OrderBy><FieldRef Name='FileLeafRef' Ascending='TRUE'/></OrderBy></Query>
  

4. Build the Preview

For each file returned:

1. Extract the Created date and format it as yyMMdd (2-digit year, 2-digit month, 2-digit day).
2. Get the current filename from FileLeafRef.
3. Determine the folder path from FileRef (strip the filename to get the folder).
4. Skip check: If the filename already matches the pattern ^\d{6}- (six digits followed by a hyphen), mark it as skipped with reason "Already has date prefix".
5. Build the new filename: yyMMdd-OriginalFilename.

5. Show the Preview Table

Always show the preview before making any changes. Present a markdown table:

#	Current Name	New Name	Folder	Status
1	Status Report.pdf	251203-Status Report.pdf	/sites/Team/Docs	Will rename
2	251203-Budget.xlsx	251203-Budget.xlsx	/sites/Team/Docs/Finance	Skipped (already prefixed)

Include a summary:

• Total files found: X
• To be renamed: Y
• Skipped: Z

Then ask: "Ready to rename Y files? Confirm to proceed."

6. Rename on Confirmation

Once the user confirms:

• For each file to be renamed, call update_list_items with:
  • itemId: the file's list item ID
  • fieldInternalNames: ["FileLeafRef"]
  • newValues: ["yyMMdd-OriginalFilename"]
• Process files one at a time to handle errors gracefully.
• If a rename fails, log the error and continue with the remaining files.