Once you’ve built your extraction model in ReportMiner to extract desired data from unstructured sources such as printed or spool documents, you need to send it somewhere so that it becomes meaningful and useful to your business. With ReportMiner, you can map and export data to almost any destination you want, including databases like SQL Server, Access, MySQL, PostgreSQL, and any ODBC-compatible database, as well as formats such as fixed length, delimited, Excel, and XML.
In this blog we’ll show you how to quickly export your data to an Excel file, where you’ll be able to analyze it, add it to your database, and if it is important over the long term, to your data warehouse.
After you’ve prepared your extraction model, you need to make sure everything is set up correctly for exporting. You do this by selecting the Preview icon and checking in the preview window to make sure everything is the way you’d like it to look.
When you are sure your setup is correct, choose the Excel icon: Create New Export Setting and Run (to Excel).
The pop up window will enable you to specify where you want to save the file.
Once you’ve saved the file, there are options available, including First Row Contains Header, specifying the worksheet if you have multiple worksheets in your Excel file, or appending to a file that already exists.
After selecting your options, a new popup will allow you to change the layout of your file. For example, you might want to make changes to the column header such as spacing, change the order of the fields, or change formats such as date format.
After exporting, you can check to make sure all your records were exported in the progress window on the left side. On the right side, there is a link to open the file in Excel.
There you can see all of your exported data in spreadsheet format and check to make sure all your changes to headers, field position, etc. are reflected in the exported data.
That’s it! You’re done!