Updatings a note/history to force it to sync

[Kari]

Hi All-

Because of a problem after we cut a new Remote Office database we ended
up with a bunch of notes that did not sync into the host. We are now
having trouble importing them in such a way as to make sure they sync
back out to the remote users. Does anyone have a tried and true way to
do this?
Any ideas would be appreciated!

Kari
NewsBank, inc.

Sent via Deja.com http://www.deja.com/
Before you buy.

[dan4t...@my-deja.com]

I think you're going to have to write a Basic script for that.

I'd try exporting to a CSV from your remote office (from a group
perhaps) and then run an import script on the main host. If your export
includes the ID, then you won't get dupes in your remote office - the
remote office sync should reject all the inserts.

Of course, I've never done this, so I couldn't claim that it's tried and
true. But it should work...

-D4P

In article <8o3o8j$4sc$1...@nnrp1.deja.com>,

[dan4t...@my-deja.com]

Point Counterpoint...

This just occurred to me.

You could also use 'SQL to generate SQL' - write a select to grab your
source data and format it as a series of 'INSERT INTO' statements.* You
could then use WG admin's Execute SQL command to blast it out to all
remote users and remote offices. That should be easier than writing
Basic, and more straightforward (i.e. less error-prone) at run-time.

Happy recovery
-D4P

* at the risk of being remedial - remember to make valid SQL. Double
quote all single quotes, encode CR/LF characters, etc...

In article <8o4vnc$hqk$1...@nnrp1.deja.com>,

[Kari]

Thanks, I will let you know how we do.
Kari

In article <8o50t2$j3r$1...@nnrp1.deja.com>,