Does anyone know how to add a Hotfile to a catalog through code?
Every week I have to make a hotfile from a set of data that never changes. I want to automate the process so that I don't have to do a whole bunch of stuff manually. I have gotten as far as running a report that is saved as a hotfile. But when I try to add it to the catalog via AddExternalHotfile or databases(x).Tables.Add ... I get nothing. If I open up the catalog I see the hotfile name I added but I cannot view the columns in it, and I cannot use it in reports.
The end result I need is a catalog folder that has an item for each column of the hotfile as well as some filter and calculation items that are based on the hotfile.
Any help?
Every week I have to make a hotfile from a set of data that never changes. I want to automate the process so that I don't have to do a whole bunch of stuff manually. I have gotten as far as running a report that is saved as a hotfile. But when I try to add it to the catalog via AddExternalHotfile or databases(x).Tables.Add ... I get nothing. If I open up the catalog I see the hotfile name I added but I cannot view the columns in it, and I cannot use it in reports.
The end result I need is a catalog folder that has an item for each column of the hotfile as well as some filter and calculation items that are based on the hotfile.
Any help?