Write script to parse tools tracker spreadsheet and generate Product_Resource XML labels

[jordanpadams]

Are you sure this is not a new requirement or bug?

Yes

Task Type

Sub-task

💡 Description

Write a script that reads the PDS Tools Tracker spreadsheet and generates a Product_Resource PDS4 XML label for each tool/service entry.

Acceptance Criteria

• Script accepts either a Google Sheets URL (via the Sheets API or a pre-exported CSV) or a local CSV/TSV file as input
• Script maps spreadsheet columns to the appropriate Product_Resource XML elements (LID, title, abstract/description, URL, resource_type, resource_subtype, associated node(s), etc.)
• Output XML validates against the PDS4 schema and schematron that introduces Product_Resource (see Develop New Product Resource Data Model for Services and Tools pds4-information-model#965 for prototype release)
• LID is auto-derived from the tool name using a consistent slug-style convention matching existing labels in data/pds4/context-ops/service/
• Output files are written to data/pds4/context-ops/service/ (or a staging directory) named <tool_name>_1.0.xml
• Script is runnable from the command line with clear usage instructions (e.g., python generate_resource_labels.py --input tools.csv)
• Rows that are missing required fields (name, URL) are skipped with a logged warning rather than producing invalid XML

Notes

• Existing Product_Service labels in data/pds4/context-ops/service/ serve as the structural reference until the Product_Resource schema is finalized
• The Product_Resource prototype (schema + schematron) is attached to Develop New Product Resource Data Model for Services and Tools pds4-information-model#965
• Prefer Python; use the standard library xml.etree.ElementTree or lxml for XML generation