SaveToDB Wizards Menu
- Database Connection Wizard
- The Database Connection Wizard allows connecting to database tables, views, and stored procedures, and to DBF, Excel, and CSV files.
You can use the query list later to change the active database object. - Web Data Connection Wizard
- The Web Data Connection Wizard allows connecting to web data sources and OData, REST API, and DBGate data services.
The add-in supports web data sources in the following formats: JSON, XML, HTML, CSV, and plain text.
You can merge loaded data to databases using the Data Merge Wizard first and then using the Merge button of the Reload Menu.
OData, REST API, and DBGate objects are similar to the database ones. You can save data changes if the objects support them. - Text File Connection Wizard
- The Text File Connection Wizard allows connecting to CSV, HTML, XML, JSON, and plain text files using the built-in text file data provider.
You can reload data later using the SaveToDB add-in Reload button. - Pivot Table Connection Wizard
- The Pivot Table Connection Wizard allows creating pivot tables connected to database tables, views and stored procedures, web data sources and data services, or text files.
Contrary to other wizards above, it connects the pivot table to a data source directly.
Alternatively, you can connect using a table and create a pivot table using it as a data source.
In this case, if the object supports saving changes, you can use the pivot table as an editor. - DB.RTD Connection Wizard
- The DB.RTD Connection Wizard allows creating a template table to load database data using the RTD formulas of a companion DB.RTD product.
You can use DB.RTD as an alternative to creating multiple pivot tables or linking table data using Excel formulas. - Data Publishing Wizard
- The Data Publishing Wizard allows creating a database table, exporting active Excel table data, and inserting a new connected database table.
After that, you can save and reload data from a database, as other users are too.
Also, use the Table Format Wizard to save the table format and formulas to a database. - Data Merge Wizard
- The Data Merge Wizard allows the merging of data loaded from any data source into a database table.
You can use Excel formula columns to prepare database table columns.
You can use the Merge button of the Save Menu to repeat merging later. - Connection Change Wizard
- The Connection Change Wizard allows changing connection data like a server, database, login, or password for a group of tables.
- Table Format Wizard
- The Table Format Wizard allows saving, loading, and clearing Excel table formats in a database or a data service.
Other users can load the same format when anyone saves the format, including regular and conditional formatting, formulas, etc. - Window Wizard
- The Window Wizard allows adding and arranging related windows.
Microsoft changed window management in Excel 2013. So, this feature is enabled in Excel 2007 and Excel 2010 only.
SaveToDB 9 and higher does not include this feature also. - Developer Tools
- This menu contains items for developers.
See the menu described below. - Online Examples
- The SaveToDB add-in has a lot of online samples used to show the add-in features.
Click the Refresh List button to load the latest list and then open any sample.
Most of the samples allow saving data changes also.
You can find sample source codes in SaveToDB SDK. - Application Installer
- The Application Installer allows installing, checking, updating, or uninstalling SaveToDB Frameworks.
The SaveToDB Frameworks allow configuring SaveToDB add-in features on the server-side and contain database developer and administrator tools. - Application Workbooks
- The Application Workbooks wizard allows creating application workbooks using server-side definitions.
Developers can save such workbook definitions to allow users to create workbooks at any time instead of sending workbooks by email or publishing the workbooks on third-party resources.
Every user can only see and create applicable workbooks as the SaveToDB add-in checks user permissions on used objects.
Developers can generate workbooks published with the SaveToDB Frameworks to edit and save the add-in configurations.
Developer Tools
- Workbook Information
- The button displays the Workbook Information dialog box.
- Create Report Setup Worksheet
- The button creates a report setup worksheet to customize the Reports Tab for the active worksheet.
- Create Report Sample
- The button creates a report sample to learn how to customize the Reports tab.
- Format Range as Checkboxes
- The button formats a range with conditional formatting like checkboxes.
Such columns must have three values: 1, 0, or NULL.
You can use double-click to change the value. - Clean Named Cells
- The button cleans named cells that have no correct ranges.
- Clean Pivot Items
- The button cleans unused pivot table items on the active worksheet.
- Remove Unused Validation Lists
- The button removes unused validation lists.
- Add Cursor
- The button adds a cursor to the active table.
See Cursor and Fields. - Remove Cursor
- The button removes the cursor of the active table.
See Cursor and Fields. - Add Form Fields
- The button adds named cells to show and edit active table row values.
See Cursor and Fields. - Remove Form Fields
- The button removes named cell names added to show and edit active table row values.
See Cursor and Fields. - Show Configuration Worksheets
- The button shows hidden data worksheets used by the SaveToDB add-in.
- Hide Configuration Worksheets
- The button hides data worksheets used by the SaveToDB add-in.
- Clean Configuration Worksheets
- The button cleans data worksheets used by the SaveToDB add-in except for the core information about connected objects.
It's safe. You can reload data and configuration later to restore the SaveToDB features completely. - Show Dependencies
- This button shows object dependencies.
- Show Table Format
- This button shows Excel conditional formatting of the active table suitable for DBEdit, DBGate, and ODataDB products.
See the SaveToDB Developer Guide for details. - Show Workbook Definition
- This button shows the active workbook definition suitable for the Application Workbooks wizard.
See the SaveToDB Developer Guide for details. - Prepare Workbook for Distribution
- This button prepares the active workbook for distribution.
The add-in removes loaded database data and encrypts connections.
So, you can publish or send the workbook safely.
Also, you can publish such workbooks as templates for the Application Workbooks wizard.
See the SaveToDB Developer Guide for details.