0x07FD07... how to interprete? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

0x07FD07... how to interprete?

Author

Topic

barnabeck
Posting Yak Master

236 Posts

Posted - 2014-12-04 : 05:49:36

Digging into the tables of our CRM in order to access the log information on the records history, I finally stepped on the right table but can't interprete the data.

The crucial information is stored in a column of type 'image' and contains this kind of hexadecimal strings:

"0x07FD0707FD0102F00100004D00410042004F000000004D00410042004F000000FF0707FD0100F0010006720B0308202B00000000000006720B0308202A000000000000FF0707FD010AF00100011AADA60801F5362E46FF0707FD019E4E01000033003000000000310030000000FFFF"

Because of the other readable columns I can exactly relate this to a log entry and therefore know what the coded info is supposed to be:
(there are 4 columns in the log that do not vary and therfore most likely aren't coded)

Field label             Value                Previous value       Field name
----------------------------------------------------------------------------------
BS                      30                   10                   WK_SS
Modified date and time  04/12/2014 09:32:43  04/12/2014 09:32:42  modifiedDateTime
Modified By             MABO                 MABO                 modifiedBy

I give another example to show that the structure really is repetitive and that the first 98 characters of each lines are the same; therefore the core information is just a couple of characters long:

"0x07FD0707FD0102F00100004D00410042004F000000004D00410042004F000000FF0707FD0100F0010006720B03081F3500000000000006720B03081F30000000000000FF0707FD010AF00100010E5095670101000000FF0707FD011200010002020000000000000002490200000000000000000000FF0707FD010E00010002010000000000000004980200000000000000000000FFFF"

Field label             Value                Previous value       Field name
----------------------------------------------------------------------------------
Unit Price              98,04                0,00                 SalesPrice
Net amount              490,20               0,00                 LineAmount
Modified date and time  04/12/2014 09:31:53  04/12/2014 09:31:48  modifiedDateTime
Modified By             MABO                 MABO                 modifiedBy

Anybody can give me a hint about how to decode this?
cheers, Martin

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-12-04 : 08:49:53

Just guessing, but is this 'image' a jpeg, gif, png, tiff or something like that?

barnabeck
Posting Yak Master

236 Posts

Posted - 2014-12-04 : 09:41:26

Sorry, but I don't have a clue... looking for the content of the log I found that table among the hundreds of tables that feed the ERP. I'm pretty sure that it's there where the data for the log lookup is stored. In the ERP a log entry is displayed in the way as described above with the 4 columns. And that definitely is no image!

The SQL dataformat for that column is 'image' so I guess the log sort of missuses that column type for that purpose... but there aren't any images! Beside these strings generally are too short to be containg any real image in hex format. I'm guessing too, trying to understand the logic

Martin

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-12-04 : 09:44:53

Sounds like you need to talk to the CRM vendor (or developer, if this is an in-house app)

barnabeck
Posting Yak Master

236 Posts

Posted - 2014-12-04 : 10:06:05

You might be right. Well this is Microsoft Dynamics and I hoped that somebody was familiar with this hex string and how to convert it into somewhat readable. But as I'm spending hours on it, I see how complex this is.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources