XML decoding for the blob fields #XML
Before I start re-inventing the wheel, has anyone got a good script for decoding the XML blob fields in Source Templates and also those in Sources and Citations?
Ideally I'd like to produce a table or view of
Template ID, Fieldname, DisplayName, Type, Hint, LongHint, CitationField
for SourceTemplates and tables of
ID, FieldName, Value
for Sources and for Citations so I can use these in reports and research.
Well I didn't manage to decode them in SQLite but I have successfully imported an RM database into Sql Server with a SQL Server Integration Services package using the SQLite 3 ODBC connector to do the work and a VB script task to decode the XML into tables for each of SourceTemplates, Sources and Citations. Now I have the data to query and can re-run the import to refresh it.
The real object is to learn and use Power BI reporting!
Congratulations, Pat! If I didn't reply to your 1st post in this topic, it is probably because I received no notification of the post. I'm not happy with that aspect of this forum plugin - I wish it sent out an email notice for each post.
I'm sure that some others are interested in what you are doing. Any chance you could post some examples and how-to?
Tom
Have just seen Tom's reply - no notifications again - I think the SSIS part is somewhat involved for those who have never used that tool but for anyone with some SSIS experience then I can be contacted by email.