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!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Grabbing history and reinserting it for sync purposes

Kevin Austin
Posts: 105

Grabbing history and reinserting it for sync purposes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Aug 07 10:26 AM

Hi all,

I've had a problem where history was being written to a remote office but it wasn't sync'd to the host database and as a result to any of the remotes. Can anyone think of a way of easily removing this history and reinserting it via the SLX OLE DB bearing in mind longnotes etc. I've come up with a few solutions but I can't seem to get around BLOB fields easily.

Help!!

[Reply][Quote]

Frank Chaffin
Posts: 475

Re: Grabbing history and reinserting it for sync purposes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Aug 07 1:38 PM

How about using the Resync Database function in the WGAdmin. Or using the GroupCopy utility?

[Reply][Quote]

Kevin Austin
Posts: 105

Re: Grabbing history and reinserting it for sync purposes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Aug 07 3:40 AM

Don't think GroupCopy will do the trick and the resync db function isn't really an option at present as we have remote users in the hundreds

[Reply][Quote]

Walter Shpuntoff
Posts: 167

Re: Grabbing history and reinserting it for sync purposes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Aug 07 4:25 AM

If you have both databases, you could use SQL DTS, Scribe, whatever .. to bring them over.

Your source query would be something along the lines of
select * from sourcedb.sysdba.history where not exists (select historyid from targetdb where historyid = sourcedb.sysdba.history.historyid)

Your target would be the oledb provider on the target db.
Map the fields, and give it a shot.

ws

[Reply][Quote]

Walter Shpuntoff
Posts: 167

Re: Grabbing history and reinserting it for sync purposes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Aug 07 4:26 AM

oops.
query should look more like this:

select * from sourcedb.sysdba.history where not exists
(select historyid from targetdb.sysdba.history where historyid = sourcedb.sysdba.history.historyid)

ws

[Reply][Quote]

RJ Samp
Posts: 973

Re: Grabbing history and reinserting it for sync purposes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Aug 07 8:36 AM

We've got an RJ Ledger developed program that basically copies, deletes, and inserts all of the records in a table.....if you can't get the databases near each other to do a compare (we have a program that does that also).....it's your best bet.

You can restrict it by any condition you want....only meetings or a specific user or a time period.....send it out to the database via Architect Release.....put it on a button on a view for that user kinds of stuff.....

[Reply][Quote]

Kevin Austin
Posts: 105

Re: Grabbing history and reinserting it for sync purposes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Aug 07 8:44 AM

RJ Samp, how do I get this program? It sounds like the ticket.

[Reply][Quote]

Kevin Austin
Posts: 105

Re: Grabbing history and reinserting it for sync purposes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Aug 07 7:26 AM

Any replies on this appreciated.

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Grabbing history and reinserting it for sync purposes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Aug 07 6:18 AM

Quote:

Originally posted by Kevin Austin

Any replies on this appreciated.

It's something I sell as part of what we do as a partner.
--
rjl

[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 © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 6/20/2025 6:35:55 AM