-
标题
How can I export search results headers to xls format? -
说明
How can I export search results headers to xls format?
-
原因
The option does not appear to be in the Archive Manager website to export the headers of the search results to xls.
-
解决办法
To accomplish exporting search results from Archive Manager into Excel using the Search Exporter tool, follow these step-by-step instructions:
1. Access Archive Manager Website:
- Open a web browser on the machine where you want to work.
- Navigate to the Archive Manager website.
2. Access Administrator Tools:
- Log in to Archive Manager with Administrator privileges.
- Click on "Administrator" at the top right of the page.
3. Download Search Exporter Tool:
- Navigate to the bottom left and click on "Download Tools."
- Download the Search Exporter tool and follow the installation wizard. Do not run the tool directly; it must be invoked from within the Archive Manager website.
4. Perform Search:
- Return to the Archive Manager website.
- Conduct the desired search query.
5. Export Search Results:
- After the search completes, click on the "Export" button located above and to the right of the search results.
- Choose "Open," which will invoke the Search Exporter tool.
6. Specify Export Directory and Format:
- Select a directory to export to and keep the default format, typically HTML.
- Note: This process may consume significant drive space depending on the size of the search results.
7. Complete Export Process:
- Once the export finishes, click "Finish." Note that you may encounter errors regarding messages or attachments that couldn't be processed.
8. Import into Excel:
- Launch Microsoft Excel.
- Navigate to the "Data" menu and select "Import External Data" > "Import Data..."
- Browse to the directory where you exported the messages and open the `Default.html` file.
9. Save as Excel (XLS) Format:
- Once imported into Excel, you can manipulate and analyze the data as needed.
- Save the file in Excel format (XLS) or any other supported format.
-
其他信息
This process will also export all messages and attachments in the search and can take up a large amount of drive space depending on the results of the search. These newly created directories can be removed after this process is complete.