How would you do that?

[Fairlight]

Y'all catch dis heeyah?  Walter Vaughan been jivin' 'bout like:
> 
> Actually, what Mark is working on might be utilized as a SQL <-> filePro 
> sync tool. Keeping two filepro systems in sync isn't nearly the problem 
> of keeping a SQL and filePro system in sync.

Another use for it, eh?

Actually, Mark is having trouble getting his head around the feed
regeneration portion of the specification.  I'm starting to think that
there should be a generic module that does exports and takes variables that
dictate start/stop date and start/stop time (usually you'd use the same
date, except when making an emergency backup feed when bringing in a server
that was down for several days), a variable with the table name to export
from, and a variable that contains a comma-delimited set of fields to export.

Then the routine just grabs the records indicated via lookup, parses the
export fields variable, and performs the export for each if it isn't
already in the tracking database.

Seems like the sanest solution so far.  Intake seemed easier logistically.
The XML parsing being a PITA is no big deal compared to making sure the
actual generation of the feeds is done correctly.

With the above, you'd end up with one centralised intake and one
centralised generation tracking database each, covering feed exports from
all tables.  In any given table, at the appropriate point, you would simply
set your variables and CALL the feed generation table.  Intake would only
need to call the import table where appropriate, with the appropriate
variables set.  Pretty modular.

I think that's how it should work, anyway.  :)

I mean, the only parts I have "on paper" (I don't use paper...more like "in
files") are the specs from the other night, all of which I posted here (I
modified mine to include the change for unique id).  I'm still considering
whether I should do this myself at all, and if so, whether I should hold
onto the spec for later implementation or do it now-ish.  I can guarantee
it will be a time sink for me, and that's part of the problem.  I don't
have the luxury of a lot of spare development time lately for things that
aren't immediate-return projects.

Meanwhile, I'm still turning the details like the above over in my mind.

mark->
-- 
Bring the web-enabling power of OneGate to -your- filePro applications today!

Try the live filePro-based, OneGate-enabled demo at the following URL:
               http://www2.onnik.com/~fairlite/flfssindex.html