The database on this page was imported using these steps:
- Log into Omni
- Document search
- Under ‘CLASSIFICATION OF DOCUMENT’ choose Folder ‘TOH-ANATOMICAL PATHOLOGY’
- Click Search, then Excel Export
- Open in Excel, open a blank sheet and reference the columns “Doc#”, “Description”, “Subfolder”, “Document Hyperlink”
- Add a custom column with the formula:
="[<https://eorla.omni-assistant.net/lab/Document/DocumentDownloader.aspx?Df_Guid=>](<https://eorla.omni-assistant.net/lab/Document/DocumentDownloader.aspx?Df_Guid=>)"&
and reference a cell in the Document Hyperlink column, then autofill the whole column
- Select all columns, copy, then paste as values in a new workbook with a single sheet
- Delete the extra column (Document Hyperlink) and then save as .csv file
Omni assistant import