Izu Posted July 24, 2019 Share Posted July 24, 2019 As the table needs to be defined in the database prior to running the data export process; Is it possible to extract the exact Hornbill table definition rather than rely on the definition generated by the import/export process which utilises generic values? Link to comment Share on other sites More sharing options...
Izu Posted July 25, 2019 Author Share Posted July 25, 2019 @Victor, Please, could you advice on this issue. Rgds, Izu Link to comment Share on other sites More sharing options...
Victor Posted July 25, 2019 Share Posted July 25, 2019 https://wiki.hornbill.com/index.php/View_Table_Structure Link to comment Share on other sites More sharing options...
Izu Posted August 7, 2019 Author Share Posted August 7, 2019 @Victor, I have had a look at the entity viewer but there is no option to script out the table definition. Please, advice. Rgds, Izu Link to comment Share on other sites More sharing options...
Victor Posted August 7, 2019 Share Posted August 7, 2019 4 hours ago, Izu said: there is no option to script out the table definition No, there isn't... The table definition is displayed in the Entity Viewer. The table definition displayed there needs to be put in the configuration file. If you are looking/asking for a way to automate this in any form, then there isn't any automation in place that will put this definition in the data export tool configuration file. Link to comment Share on other sites More sharing options...
TrevorKillick Posted August 7, 2019 Share Posted August 7, 2019 @Izu @Victor The API https://api.hornbill.com/data/?op=entityGetMetaData can be used to return the structure of the entity in either JSON or XML which is how the entity viewer gets its information. Kind Regards Trevor Killick Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now