The Functionize File Viewer tool allows you to upload and view files as a rendered web page inside Architect. This is useful for testing file-based workflows, including encrypted documents, as part of your test cases.
Accessing the File Viewer
- From the main Architect screen, click the plus (+) icon.
- Under Tools in the Advanced Actions sidebar, select File Viewer.
- In the File Viewer details sidebar:
- (Optional) Check Open in a new tab to view in a separate browser tab.
- Click Continue to open the File Viewer.
Uploading Files
- Select a document to upload, or input a raw document directly.
- Encrypted documents are supported.
- Supported File Types:
- Documents: .DOCX, .PDF, .TXT, .RTF, .LOG
- Data Files: .CSV, .XLS, .XLSX, .XLSM
- Structured Formats: .JSON, .XML, .HTML
- Presentations: .PPTX
- Other Formats: .ZIP, .EMN, .DXF, .TIF, .DTL, .MAP, .MTL, .SYM, .TBL, .HL7
- File Size Limit: up to 40MB.
Recording & Execution Behavior
- Architect records actions performed in the File Viewer just like on any other web page.
- Uploaded documents are rendered as HTML within the browser.
- After saving the test case:
- Re-attach the same file you uploaded during recording to the Upload Action.
- This ensures the Upload Action executes properly at runtime.
Simple flow: Open → Upload → View → Save → Re-attach file before execution.
File Viewer Displaying Fewer Columns Than Actual in CSV Upload
When uploading a CSV (Comma Separated Values) file to the File Viewer, users may observe that the displayed number of columns is fewer than what is actually contained within the file. For instance, a CSV that has over 40 columns might only render fewer columns in the File Viewer.
Root Cause: Duplicate Column Names
This discrepancy is caused by the presence of duplicate column names within the CSV file. The File Viewer is currently designed to require unique identifiers for each data column and does not support CSV files containing repeated column headers. This limitation causes any subsequent columns sharing a name with a previously-read column to be hidden or effectively ignored.
Resolution: Ensuring All Columns are Visible
To ensure all data columns are displayed correctly in the File Viewer, implement one of the following methods before uploading:
Convert the File: Convert the CSV file into an Excel Workbook format (.xlsx) before uploading. Excel natively handles duplicate column headers, allowing the File Viewer to process the file correctly.
Rename Duplicates: Modify the original CSV file to rename all duplicate column headers so that every column name is unique (e.g., changing 'ID' to 'ID_1', 'ID_2', etc.).