Standard fields are those fields defined in the default database of Excel Invoice Manager. For example, CustomerID and Email in the Customer table are all standard fields. If you add a new field to the database, the new field is called custom field, as opposed to standard field.
This document was written for version 2 of Uniform Invoice Software, which was previously named Excel Invoice Manager. For the documents that are specific to Uniform Invoice Software, please download the help document, or install the program that already has the help document included.
By default, Database Designer does not allow you to make any modifications to the pre-defined standard fields. This is necessary to keep the database safe. However there are still cases that you want to modify the standard fields - fox example, you may need to modify the size of a standard field. The following tutorial tells you how.
- First of all, you need to click the following link to download a zip file. Unzip the file you download. You will get a Windows registry file.
- Double click the registry file to import it into Windows registry.
Import the registry keys (Click to enlarge)
- Now exit Microsoft Excel if it is running.
- Open Database Designer. You can find the shortcut on Windows Start menu -> (All) Programs -> OFFICE-KIT.COM -> Excel Invoice Manager -> Database Designer.
- Click Next to go to the Step 1 screen. Click the Open Database Definition File button to open the database definition file you are using with your current database file.
By default, you are using the database definition file in <System Driver>\Program Files\Office-Kit.com\Excel Invoice Manager\ folder in Windows 2000/XP (this is the default installation folder of Excel Invoice Manager), and in <System Driver>\Users\Public\Documents\Excel Invoice Manager\ folder in Windows Vista and Windows 7. (More information about this).
However, if you are using custom fields or have moved your data files, you may need to find the database definition file in the same folder where you store your database file.
Open database definition file (Click to enlarge)
- Click the Backup button to backup your database definition file.
- Click Next to go to the Step 2 screen. Check the Display Standard Fields box to display all the standard fields for the selected table.
- Click the name of the table that contains the field you want to modify. For example, if you want to modify the Email field - it is defined in both the Customer table and Invoice Header table, firstly you click Customer in the Tables list, and then click the Email field in the Columns/Fields list.
Select a field (Click to enlarge)
- Click the Modify Field button. The Modify an Existing Field window allows you to make the changes to the standard field. Click OK to close the window when finish.
Set field size (Click to enlarge)
- In the Invoice Header table, the field for storing email information is named WhoEmail. Now click Invoice Header in the Tables list, and then find and select WhoEmail in the field list.
Select another field (Click to enlarge)
- Click the Modify Field button. Make changes as you need.
- Click the Save button on the Step 2 screen to save the changes.
- Click Next.
- In the Step 3 screen, open the database file that you are using. Backup it, and then click the Apply! button to apply the new (modified) database definition file to your database file.
Apply database definition file to database (Click to enlarge)
- Click Finish to exit Database Designer.
- Now open and run your template as usual.