Book a Demo

Author Topic: How to decode BinContent in t_document for MDG technologies?  (Read 4739 times)

Mauricio Moya (Arquesoft)

  • EA User
  • **
  • Posts: 344
  • Karma: +8/-4
  • EA Consulting and development in Spanish
    • View Profile
    • Arquehub Azure Module
How to decode BinContent in t_document for MDG technologies?
« on: March 29, 2019, 12:23:01 am »
As you can find in the database the MDG loaded into the model via the following query:

Code: [Select]
SELECT BinContent FROM t_document WHERE ElementID = 'TECHNOLOGY'
Does anybody know the way to "decode" BinContent data? it is loaded in the form of binary data, beginning as follow:

0x504B0304140000000800AA56744EEB2983781D8D01003C9C0A00070011007374722E64617455540D0007C11....

It doesn't seems to be the classic zipped xml like the baselines. I've tried several decoding options but nothing worked.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: How to decode BinContent in t_document for MDG technologies?
« Reply #1 on: March 29, 2019, 01:13:49 am »
It's a base64 encoded zip with a single file str.dat as contents.

q.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: How to decode BinContent in t_document for MDG technologies?
« Reply #2 on: March 29, 2019, 09:29:33 am »
It's only base64 encoded if you encode it that way or retrieve it that way. In the post above it's clearly a hex sequence.

Mauricio Moya (Arquesoft)

  • EA User
  • **
  • Posts: 344
  • Karma: +8/-4
  • EA Consulting and development in Spanish
    • View Profile
    • Arquehub Azure Module
Re: How to decode BinContent in t_document for MDG technologies?
« Reply #3 on: March 30, 2019, 12:56:52 am »
Sure, it worked as qwerty said! thanks!