Community
Showing results for 
Search instead for 
Do you mean 
Reply

How does the 'regarding' column in HDB files map to the BLB file?

New Member
Posts: 3
Country: Australia

How does the 'regarding' column in HDB files map to the BLB file?

Hi all,

 

I'm trying to access the notes/history data in our ACT database to do a regular report. My script opens the HDB file (read-only) and pulls out the data I need. However I need to know how the 'regarding' column maps to the BLB file so I can extract the text. The BLB file seems to be null padded in 128 byte blocks, so I assume the regarding column is an offset from the start of the file.

 

Can anyone help?

 

Thanks in advance! 

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: How does the 'regarding' column in HDB files map to the BLB file?

Don't waste your time. The notes/history regarding isn't the only thing the BLB contains. It also contains the email addresses, passwords, etc. If you go through the SDK ACT! will make the links for you. Among other things, I don't think that each regarding entry will be contiguous in the BLB.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: How does the 'regarding' column in HDB files map to the BLB file?

The BLB data is much too complex to make that worth-while.

 

The best options for reporting (when the ACT! reports don't go far enough) are either:

  • Crystal Clear Reports - includes a number of standard reports and you can use Crystal to create more complex ones
  • itExport - exports the ACT! data and you can use any other tool to report on the result

 

New Member
Posts: 3
Country: Australia

Re: How does the 'regarding' column in HDB files map to the BLB file?

Hi Roy,

 

Where can I get the SDK? 

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: How does the 'regarding' column in HDB files map to the BLB file?

I have a copy of the ACT! 5 SDK.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 3
Country: Australia

Re: How does the 'regarding' column in HDB files map to the BLB file?

Hi Roy,

 

Can you send it to me? Do you have a URL I can download it from? 

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: How does the 'regarding' column in HDB files map to the BLB file?

Send me an email.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Bronze Contributor
Posts: 930
Country: USA

Re: How does the 'regarding' column in HDB files map to the BLB file?

You're wise to take the advice given by others here.  The BLB, as you've probably figured out, is a Binary Large Object, specifically, it's a doubly-linked list, and you would be writing all of the routines to traverse and retrieve the information.  I remember a session 10+ years ago taught by one of the Symantec Support folks who walked us through manual browsing of the blb, with our hex calculators in hand.  It was fun to understand how it worked, how to use the forward and back links, but I wouldn't want to have to work in that every day.

 

Good luck!

Signature