How To Update Data In a Runtime DB

[Tony Martin]

Help! I need some guidance in updating a Runtime database with remotely accessed data.

Basically, I have several databases which are served using FM Server 8.0. I also have Runtime databases out there and I want to be able to allow users to update their databases with "today's data". I am currently doing this by sending them a CSV email which they then import themselves.

Is there a better way to accomplish this? Can I do some sort of remote call from the runtime DB to the served DB's? If I can, please giude me as to how to make this happen! :

Thank you!! As always this community is A#1! You guys rock, and we are very appreciative of your insights!

[bcooney]

Have you looked at SyncDek? I think you'd be better off implementing their approach to keeping offline users current.

WorldSync.com

[Tony Martin]

Well, this appears to be a sync'ing product, no? I'm not really looking to have them sync'ed with my database...I'm just looking to have them be able to get the entries we edited or created today into their runtime solution.

Thoughts?

[AudioFreak]

I'm just looking to have them be able to get the entries we edited or created today into their runtime solution.

That sounds like getting them synched to me....lol.

Sorry I couldn't resist. :

[Tony Martin]

hmmm... maybe I'm nto getting it. Doesn't syncing mean all records in the DB? Well, it did when I was younger. : Anyway, that's not what I'm looking for.

Does anyone have a solution that I don't need to get a "quote" for? Coulda sworn FM supported a solution foe this exact issue.

BTW - we have FM 9 and can get server 9 if needed. Thanks.

Edited August 28, 2007 by Guest

[Tony Martin]

From SynDeck:

LV Default-

Thank you for your interest in SyncDeK. Unfortunately SyncDeK does not support runtimes.

Please feel to contact us if you have any questions.

Thank you-

Karen

[Vaughan]

Runtimes are NOT networkable. However, if the runtime data file is opened in a regular licensed copy of FileMaker Pro it CAN be networked.

"I am currently doing this by sending them a CSV email which they then import themselves."

That's the only option if the client only has the runtime.

[cjaeger]

Export your daily data as xml, put it on a webserver and run an import script when opening the runtime client . No xsl needed, just plain filemaker xml export.