TDM 7.1: Additional fields for Excel import/export

Toad Data Modeler
1

Hi,

I need to add additional fields in tables/columns (MS SQL 2016) for import/export in Excel.
Which scripts do I need to change? I need to add the field 'Extended Properties' to the Excel-file.

Best regards
Wolfgang

2

Hi Wolfgang,
if you would like to do simple modification you can change scripts:
ExportExcelManager
ImportExcelManager
in both see function function GetDefinitionEntity/GetDefinitionAttribute. There are definition array and this array has 4 dimensions.
1 - Property Name
2 - Caption
3 - readonly flag
4 - data for all class, do not change it.

By change these scripts you change TDM system scripts. Files are stored in Program Files, so you need appropriate right to save it.

Petr

3

Thank you Petr!
Problem solved!

Wolfgang