URL_fix configuration sheet to update permalinks
Creation date: 7/1/2025 10:41 AM
Updated: 7/10/2025 11:48 AM
Instructions on how to operate the_URL fix configuration sheet:
- To enable automatic permalink updates, log in to Smartsheet and search for the sheet titled “URL_fix”, or click the following link: (41) URL_fix - Smartsheet.com
- For the script to successfully update permalinks, the following fields in the configuration sheet must be completed:
In a new row, enter:
The Sheet ID where you want to update the permalinks.
The Sheet Name.
Column name of the permalink source sheet ID id_source.
The name of the target column to insert permalink url_target_column.
- Check the Enable checkbox to activate the row. Only enabled rows will be processed by the script. If unchecked, the script will skip that row during execution.
- The Status column will be updated by the script after each run. Status messages include:
- Done – All rows got processed and all permalinks were updated.
- Done; No permalink found for 'N' rows – All rows got processed, but no updated permalink was found in the database for that particular sheet.
- Error Processing – No rows were updated due to an error during processing.
- The Status Timestamp and Last Dest Modified columns are used to track when the row was last processed and when the destination sheet was last modified. These timestamps help determine whether permalink updates are needed.
- If the script cannot find both the In Link and Out Link for a row, it will automatically uncheck the Enable box for that row. This prevents unnecessary processing in future runs and improves script efficiency.
Code:
Location: P:\Alex_Argumedo\jlee\ss_scripts
Python: url_fix_main_v2.py
Frequency: 1hr
Automated Execution: Windows Task Scheduler
Attached: current version of the script running in production
Logs:
Warning and info level only, adds the logs to a file in the same directory, P:\Alex_Argumedo\jlee\ss_scripts and there are some historic files.
DataImage15.png