Description and Purpose
When working with pages that have grids, sometimes it is easier to export the data to a spreadsheet which allows easy manipulation of the data to get the desired results. When selecting Export All. FINET allows you to either export the columns in the “Gear” Icon list or to export all available columns from the data source. This includes additional columns that are not in the “Gear” Icon this that may be useful. FINET will export up to 2000 records of search results.
Process/Instructions
To use Export, you will need to be on a page that has Grid Actions available. (Most tables have Grid Actions.) To Do an Export (Either option):
1. Open the Table in FINET and enter your search criteria. For example, if you wanted to see all commodities that start with a letter J, you would go to the commodity table and search for J* in the name field.
2. Click on Grid Actions
3. At this point you are presented with two options. They are Viewable Columns and Available Columns.
• Selecting Viewable Columns will allow you to export all columns that can be viewed using the Gear, whether displayed or not.
• Selecting Available Columns will allow you to export the Gear columns and additional columns available from the data source.
4. Select the option you desire by clicking on it. Once clicked, FINET will download the export file to the download folder.
5. You can then open the file like you normally would in Excel.
Related Articles
QRG - Advanced Grid
(A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/116oOJ-4_38GP4BXP2MtlW9X2BqpIjRZb/view ) Introduction The Advanced Grid allows you to change the view of the results from a Transaction Catalog search for more ...
QRG - Inventory Freeze and Inventory History
Description and Purpose To assure accuracy, Inventories are periodically frozen in FINET to allow physical counts of the items in the warehouses. Currently, those with Inventory have selected to freeze entire warehouses to perform the count. However, ...
QRG - Inventory freeze and inventory history
(A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1fISiGBI0u6aDtPd_9fC0sdZ8LcV726_y/view ) Introduction To assure accuracy, inventories are periodically frozen in FINET to allow physical counts of the items in the ...
QRG - Inventory by Location Count and Date
(A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1Em5XDNQeop2_FLiyIzikQkkKWe9A6Vgk/view ) Introduction When dealing with inventory, it is important to know the quantity you have and where it is located. This ...
QRG - Using Excel to query data warehouse
(A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1CzcUic3qykVURnFS1yrkN-roU5YvQzJv/view ) Introduction To access State Data Warehouse using excel or other tools, create a DTS helpdesk ticket, they need to install ...