Jump to content
Salesforce and other SMB Solutions are coming soon. ×

iainwest
 Share

Recommended Posts

Hi all,

 

We are currently migrating our internal Filemaker system from version 5/6 to version 8.5. In doing this, we will for a short period, be keeping version 5/6 on the web.

 

Currently we import active data overnight into the web database and manually copy over the databases each morning. To keep this practice running with version 8.5 I was looking at talking from 8.5 to 6 via ODBC, however this has caused a few issues with repeating fields, container fields and unstored calculations.

 

Does anybody have any suggestions in how I get the communication to work from 8.5 to 6?

 

Many thanks in advanced.

Link to comment
Share on other sites

The live data is in 8.5?

 

Why not make some layouts in 8.5 and web-enable them? Or is shelling out for Advanced Server just not a viable option right at the moment?

 

FileMaker is less-than-great at backwards compatibility with its own products (you can't export a dataset as a FileMaker 4 file, for instance). You can export as a Merge file (.mer) which does nicely for the alphanumeric data but doesn't deal very nicely with container-field data. Are you really storing images (or other container data) in FileMaker 8.5 that you wish to make live on the web? Could you switch to storing references to imagefiles (and etc), which would allow you to import the path-to-file and utilize that to make those images visible to web-browsing folk?

 

As for repeating fields, they are an abomination in the eyes of God and will frustrate and annoy you at every turn until you abandon their use anyhow. (Seriously, I have yet to deploy them without significant regrets later on). You could run a looping script that runs through all the repetitions and writes their data into a single field with some kind of delimiter, and then on the other end in Fm6 parse it all back out and write it to repetitions, using a similar looping script. Assuming that no one would ever skip Repetition 7 and put data in Repetion 8 or anything, the possibility of which makes it difficult to know when to Exit Loop.

Link to comment
Share on other sites

Yeah, unless the solution is not very integrated, it's much easier to keep your users on the old version until you're ready to move everyone to your updated migrated or rewritten soluton in the new version. Then you won't have to deal with moving data between the versions.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use