Hi everyone, (Posting on behalf of Pierre)
I'm working with OpenText Content Server 21.4 in a pre-production environment and need help designing a WebReport that performs the following:
- A CSV file (
deleteme.csv
) is uploaded to a specific folder in Content Server. - The WebReport should read the CSV and extract a list of filenames.
- It should then search for nodes within a target folder (and its subfolders) that match these filenames exactly.
- For each match, the node should be deleted.
- Ideally, the WebReport should display the results in a table or allow exporting them to a CSV.
Has anyone implemented something similar or can suggest the best approach to achieve this?
Input Source
- File name:
deleteme.csv
- Location: Attached/uploaded by the user; existing files are versioned.
- DataID:
456789
- Format:
- Single-column, no header
- Each line represents a filename (e.g.,
abc.txt
, report_2023.docx
, etc.)
Processing Logic
- For every filename listed in
deleteme.csv
, search for a matching node:- Within folder
888888
- Including all nested subfolders
- Match based on the exact filename (node name)
- I want to delete the rows when they are matched.
📊 Output Table (WebReport View)
Displayed in the browser, and / or csv output created (tbd)
Filename | Size (MB) | DataID | Created Date | Delete Date |
---|
abc.txt | 1.2 | 334455 | 2020-11-19 | 2024-11-19 |
Any tips on reading CSV content dynamically and performing deletions via WebReports would be greatly appreciated.
Thanks in advance!
—Pierre Ouimet