FMPRO-L Archives

February 2013, Week 3

FMPRO-L@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
David McQueen <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Fri, 15 Feb 2013 11:21:08 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (46 lines)
Just a thought.

Up the time between exports.  No expert in this, but a 10 second 
interval seems short if there is any volume or internal processing 
such as finds to do. It could be the last export is not yet complete 
if there is any slow down on the network at all.

>I have a routine that exports records every 10 seconds to a defined 
>folder. This is part of a solution to keep an MSSQL database in 
>synch with an FM database (and the the MSSQL tables have "triggers" 
>(MSSQL triggers, not FM triggers - whole other thing), which is why 
>I cannot I cannot do this nice and simply via ODBC and the (awesome) 
>Actual Technology drivers from FMSA11, which was the original plan.)
>
>Occasionally, I get the "cannot write this file" error, which I am 
>still puzzling out. That isn't such a big issue (for now, at least, 
>I hope not) because the export script searches for a flag, exports 
>the records as text, and then sets the flag to being "done," and the 
>records will not be exported again once it has already been exported.
>
>My problem is that the Error Capture function in FM doesn't capture 
>failed file exports. I need to ignore the failed exports and have 
>the script keep cranking. If it hits a bump, it just stops, waiting 
>for the error dialog to be confirmed.
>
>The script is running on a headless WIN client - somewhere I won't 
>notice a failure unless I go looking for it.
>
>Does anyone know a way to: Log the file export errors and then click 
>"OK" on the error dialog so the script will continue to run. (I am 
>Mac person, so if there's a WIN utility that does this, I'd love to 
>hear about it.)
>
>TIA,
>
>Tom Langton


-- 
David A. McQueen
LICHEN Software
Barrie, ON, Canada
705-720-9022
705-728-2289
http://www.lichen-software.com

ATOM RSS1 RSS2