Toad World® Forums

TDM 7.1: Additional fields for Excel import/export

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

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

Thank you Petr!
Problem solved!

Wolfgang