Jump to content
Sign in to follow this  
aellis

External Data Source

Recommended Posts

I am trying to do Client to Server...Server to Server syncing

FileMaker Go to FileMaker Server....FileMaker Server to MySQL

 

I am not understanding how to setup the external data source to get the data form the first Filemaker Server.  Is there any info on how to do this?

Share this post


Link to post
Share on other sites

Too vague I'm afraid.

 

Where are you when you try to set up a file reference to a file hosted on FileMaker Server?  In another hosted file?  On the same server or on a different server?

Share this post


Link to post
Share on other sites

I am trying to follow this process.

 

Can I sync the same database server-to-server, and also server-to-client?

This is a common request - let's say you have servers in two different cities that need to sync, and then you also have users with iPads or laptops in each city that need to be able to work offline. Currently, MirrorSync does not support multiple sync configurations for a single database file. However, there is a workaround - create a separate 'shell' database for the server-to-server sync with external table occurrences linking to the tables in the main file, and then use that separate database for the server-to-server sync. For example, suppose you have a database called 'Projects' that you want to sync. Here are the steps you would take:

  • Set up the projects database normally for server-to-client syncing.
  • Once the server-to-client sync is working, create a new database. You can name it whatever you want; we'll call it 'ProjectsSync' in this example.
  • In the ProjectSync database, add external table occurrences to the relationship graph - one for each table that will be synced. Do not add the 'MirrorSync' table from the Projects file - the ProjectsSync file should have its own separate copy of that table.
  • Configure your relationship graph. You only need to configure foreign-to-primary key relationships; you can skip all of the global / calculated relationships that are only used for the user interface. This is not, strictly speaking, a required step, but it will allow MirrorSync to auto-detect your relationships, and it's a good idea anyway to make sure that lookups and calculations that reference related tables will work correctly in the shell file.
  • Set up a new configuration in MirrorSync for the ProjectsSync file. Once that is done, you should be able to run the server-to-server sync normally on the ProjectsSync file, using the MirrorSync admin utility.

 

This is the part I am referring to...

  • In the ProjectSync database, add external table occurrences to the relationship graph - one for each table that will be synced. Do not add the 'MirrorSync' table from the Projects file - the ProjectsSync file should have its own separate copy of that table.

 

I believe I actually have it set but I am not getting data.

 

Under Manage External Data Sources I added the original file that has the data I want.  Then I went to database relationships edited the link between the two versions of the same table to point one at the secondary sync table back to the original table that was selected in the External Data Source step.  Link them on my primary key.  

 

The problem is between original table and the secondary sync table.  The data is not moving to the sync table.

 

Hope this makes sense.

Share this post


Link to post
Share on other sites

Hope this isn't a stupid question, but why have two servers in two cities? Surely geographic location is not relevant in today's world.

Share this post


Link to post
Share on other sites

Hope this isn't a stupid question, but why have two servers in two cities? Surely geographic location is not relevant in today's world.

We do not have two servers in two cities. We have an iPad talking to FileMaker Server...I need the FileMaker Server database to be copied to a MySQL database.

 

The main purpose is to have data backup...also reporting and such.

Share this post


Link to post
Share on other sites

Is there anyone that can help me with this?  I think it have it setup correctly.  I hit the sync button it acts like it is syncing but it does not bring any data from the external data source tables.

Share this post


Link to post
Share on other sites

Did you get any help from the folks at MirrorSync?  It's their product

Share this post


Link to post
Share on other sites

Did you get any help from the folks at MirrorSync?  It's their product

No I tried here first...I will contact them.

Share this post


Link to post
Share on other sites

aellis...did you ever get any help on this? I'm essentially in the same situation. Any insight would be appreciated.

 

Scott

Share this post


Link to post
Share on other sites

aellis - I'm sorry, but I'm just seeing this post for the first time. For some reason I did not get an e-mail notification like I usually do; maybe because the post was moved here from another forum.

 

We'll need more details to solve the problem - I think that this would be best solved over a screen sharing session. If you can call us at 866-662-9185, we'll be happy to take a look at the situation with you.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

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.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.