Wednesday, September 16, 2020

How to Omit Table Attributes with GTech Loader

 With GTech Loader version 10.0.0.64, you can specify a list of attributes to omit from a Table export. 

On the Tabular Setup form, select a Table in the Selected Tables list and use the Edit button to bring up the Table Edit form:



A new property called Omit Attributes has been added to the form.  You can specify a comma-separated list of Attribute names here, and if any of the Table's default attributes match one in this list, it will be omitted from the tabular export.   

Often, the standard GTech attributes are not needed by the users and can be eliminated.  For example, G3E_ID, G3E_CID, G3E_FNO, and G3E_CNO are usually good candidates (only G3E_FID is required).  You may have apps that need the other attributes too, so make sure they are really something you can live without before omitting them.  You are not limited to the GTech attributes either.  Any Attributes that are not useful to the user can be removed and shrink the size of the exported data.

Also, if you specify an attribute to omit and it isn't in the Table, that doesn't cause a problem. The omit attribute will just be ignored.

You can specify Omit Attributes for each individual Table, but you can also apply an Omit Attribute List to all checked Tables in the Selected Table List.  Press the Apply to Selected Button.  


You will then be presented with the Apply to Selected Tables form:


Currently, the Omit Attributes property is the only property supported, so you can specify the value (attributes to omit), and press the Apply button.  The Clear button will reset all of the checked Tables in the Selected Table List.

The Table Selection form will show all of the current properties for each Selected Table, just need to enlarge the form or scroll over to the right.


In this example, several of the Tables show the Omit Attributes set to G3E_ID.










No comments: