_Independent Table Editor

Linked Help

 

 

Overview 

Sometimes you may want a set of table entries (for example) that are used throughout the system but are not objects. For this you would use an "Independent Table".  Independent Tables are created in XPOR Object Modeller, populated through the website, using a Table Editor Form (see separate Help Resource), added to the XPOR Control Panel.  This is achieved directly in the database, using the following instructions;

Guidance

Steps

  1. Open up a browser and navigate to https://guidgenerator.com/ - you’re going to need to generate a GUID here.
  2. Open up Modeller, find your form and get the GUID, you’ll need it!
  3. Open up the following tables in the database:
    1. OM_Interfaces_Shortcuts (for editing)
    2. OM_Interfaces_ShortcutCategories (view only)
    3. OM_Interfaces_ShortcutTypes (view only)

  4. Within OM_Interfaces_Shortcuts copy the row for Font Families (ShortcutID 6). This is a perfect example that we will use as our reference. Paste it into the empty row at the bottom of the table.
  5. Edit the ShortcutID. If it is a core item then increment to the next number under 100000, if it is client then increment to the next number 100000 (if there isn’t one, then use 100000)
  6. Copy the GUID you generated in step 1 into ShortcutGuid
  7. Check the ShortcutCategoryGuid matches the one for Control Panel within OM_Interfaces_ShortcutCategories. If you copied Font Families then it should do by default.
  8. Enter a relevant name for the shortcut in ShortcutName. This will appear in the control panel.
  9. Choose an icon and enter it in ShortcutIcon. The easiest way is to use Modeller, click “Add Object Type” (you won’t really add one, you’re just using the interface to help you) and when the creation form appears use the browser for X4 Icon to find what you want. Once you’ve selected it copy the text out to use in the ShortcutIcon field.
  10. Leave ShortcutDescription as null
  11. Check the ShortcutType matches the GUID from OM_Interfaces_ShortcutTypes for Form. Again, this should match as long as you copied Font Families.
  12. Edit ShortcutParams so that it reads { FormGuid: 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx'} where the string xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx represents the GUID you found in step 2.
  13. ShortcutMainColor represents the background colour of the icon. Again, use the form you used in step 9 choosing a colour in the “Main Color” field and copying the number into ShortCutMainColor.
  14. Leave ShortcutApplicationConfig and ShortcutUserObjectId as null

 XPOR Ltd. UK Co. Registered in England No. 10409669
 02392 738000
 02392 739000