GX:Table Maintenances

Introduction

One of the primary functions of Whistle Studio is to maintain database tables that are used by Whistle itself. This section goes over the common features of the basic table maintenances found inside Whistle Studio.

Table Maintenance Contextual Tab Group

---

Most basic table maintenances inside Whistle Studio use the same default contextual tab group pictured above.

Reload Records

The reload records button will discard any changes you have made refresh the values on the screen with the values from the database. When pressed you will be asked if you would like to discard your changes and reload the records. Press yes to reload, no to cancel and continue working with your current copy of the data.

Print Preview

To generate a print preview, click the print preview button. A new window will be launched, showing the user a preview of what the maintenance will look like when printed out (see Print section). The user can click the 'Print' icon to print directly from this window, zoom in, zoom out, and choose different styles for laying out the preview images.

Print

To print out your data as it appears on the screen, click the print button. A standard Windows print dialog will be launched, asking the user for what printer to user, how many copies and what page range to print. To see what the output will look like before printing, use the print preview button. Remember that what gets printed out is the data grid as it appears on the screen. Make sure to resize any columns necessary so that all the data is visible when printed out.

Export To Excel

To export data to a Microsoft Excel spreadsheet, client the 'Export To Excel' button. Make sure you have first selected the correct Microsoft Excel format you would like to export to with the 'Export Format' combo box. A save file dialog will appear, Whistle Studio will choose an appropriate name for the new Excel spreadsheet. If you would like to name it something else, do so now through the file name edit box. After you have successfully exported your data, Whistle Studio will offer to open the new file you created inside of Excel. Click yes to view/edit the new spreadsheet in Excel, no to continue without opening the new file.

Import From Excel

To import records from an Excel spreadsheet. First use the 'Export to Excel' function to export your existing data and generate an example spreadsheet. From there, enter in new rows following the same formatting rules from your exported data. If a grid column uses a combo box for data entry, only valid entries from the combo box are valid entries from within the Excel spreadsheet. If an invalid value is entered into the spreadsheet, Whistle Studio will display a message notifying the user of the row and column that contains the invalid entry and ask if the user would like to continue importing. When the import process completes, Whistle Studio will offer to commit all rows that were imported to the database. Any rows that get errors while being committed to the database will display an error message indicator in the status column and turn the border red on any cells that have specific errors. To view the error message associated with a row, mouse over the error indicator in the status column and a tooltip should appear. Likewise, to find out why a specific cell with a red border contains an error, move the mouse over the cell and an error tooltip will appear.

Auto Fit On/Off

The 'Auto Fit' check box is for toggling the column auto-fit feature of the data grid. When turned on, the data grid will attempt to resize its columns to fit the horizontal space available without the need for a horizontal scroll bar. By default the auto-fit feature is turned off. This setting is persisted through sessions, meaning if a user turns it on, the next time they log on to Whistle Studio with the same ERP/Whistle login, auto-fit will be turned on just like they left it. Similarly if it is turned off, it will remain off until turned on again or the user clicks the .