slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Data & Imports Forums - T-SQL & Queries
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to T-SQL & Queries | New Thread

View: Search:

Author

Thread: Accessing Subscription Rules

Steve Harris
Posts: 16

Accessing Subscription Rules Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 May 06 11:40 AM

Does anyone know how to get at the subscription rules in the SUBSCRIPTIONRULES table. The field is called DATA and is a BLOB.

[Reply][Quote]

Jeremy Brayton
Posts: 491

Re: Accessing Subscription Rules Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 May 06 11:04 AM

cozaar

cozaar davidnorlin.se

Try using Execute SQL in Admin. When you Test the SQL it will show you the contents of BLOBs but I have a feeling it's so cryptic you won't be able to decypher it to use it. SalesLogix hides data in BLOBS when they don't want you tinkering with thier stuff, such as trying to create a Plugin from scratch, modify certain tables, or do something with important bits of data. The way I understand it is you can decode the stuff all day long a la Electrician (www.jh3.com) but if you try to encode the BLOB data you would be reverse engineering it and therefor violating licensing agreements.

I could be wrong on that but I believe I've had the discussion about it with the maker of Electrician (John) and that's what he told me. I figured the guy who decyphered the Delphi object code would know a little bit about encoding it back into the DB but since that discussion was a couple of years old by now things may have changed.

[Reply][Quote]

Chris Maguire
Posts: 7

Re: Accessing Subscription Rules Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Jun 06 9:31 AM

melatonin and pregnancy

melatonin pregnancy safety defendingutah.org

On a side note, I know of someone who wrote a program

to view and modify the usersubscription blob, but the blob got overwritten by SalesLogix periodically so the changes wouldn't stick. You could probably modify the code fairly easily to at least view the subscriptionrules easily.

I've heard that the user subscription blobs are fairly easy to work with: they are simply ASCII encoded text with a preamble (probably around 42 characters) and a record separator (probably around 2 characters). At least, that's what I've heard.

[Reply][Quote]

Steve Harris
Posts: 16

Re: Accessing Subscription Rules Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jun 06 7:19 AM

abortion pill online usa

abortion pill kit westshoreprimarycare.com medical abortion

buy mirtazapine 15mg uk

buy mirtazapine online uk redirect

Do you have a copy of the program or know where to get it?

[Reply][Quote]

Chris Maguire
Posts: 7

Re: Accessing Subscription Rules Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jun 06 1:21 PM

Yes, however like many admin hacks I'm pretty sure it wasn't written for public consumption

so it's not all that polished.

C>

[Reply][Quote]

Jeremy Brayton
Posts: 491

Re: Accessing Subscription Rules Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Jun 06 11:41 AM

I'd be more interested in the source to decypher how to read the subscription rules. Writing to any BLOB outside of SalesLogix clients is something I don't trust 100% yet. The fact that subscription rules and the sync process was finicky in the past I personally wouldn't attempt to touch it outside of the client. While you may be able to put all of the data in all of the right places order can make a significant impact on the process. If SalesLogix expects A, B, C and you put A, C, B (while technically correct) it may cause issues. Being the subscription rules, the bread and butter of synchronization, I would have to test it in a live sync environment before I personally used it.

It's not rocket science, it just feels like it sometimes.

[Reply][Quote]

Chris Maguire
Posts: 7

Re: Accessing Subscription Rules Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Jun 06 2:00 PM

Quote:

Originally posted by Jeremy Brayton

... If SalesLogix expects A, B, C and you put A, C, B (while technically correct) it may cause issues. ...

IIRC, that was the tricky part, but the code finds the right place to put account IDs.

C>

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 5/1/2024 5:23:38 PM