Sign in to follow this  
Followers 0
ywwy

Export Filemaker pro 13 data to Filemaker Pro 11

11 posts in this topic

Hi,

 

We have a FMP Server 11 and a FMP 13 version.  

We cannot upgrade the FM Server 11 to 13.

 

We need to get FM13 data into the FMServer 11.

 

Are there ways to accomplish this ?

- Export records script from FM13

- ODBC connection between FM11 and FM13 ?

 

 

Thanks for looking into my question.  

Share this post


Link to post
Share on other sites

Hi ywwy, and Welcome to the Forum,

 

I moved this topic from "FileMaker Pro 11" to "Upgrading & Migration”, because we have this topic available for questions about migration. Also, the General Topics are reserved for questions about the new tools, features, and functions that were introduced with that version of FileMaker.

 

These two versions of FileMaker are not compatible, they are written in two different languages, and 13 is not backwards compatible. In other words, Server 11 can not host 13 files and Server 13 can not host 11 files. 

 

HTH,

 

Lee

Share this post


Link to post
Share on other sites

Hello Lee,

 

Thank you for your reply.

 

So I drop the idea of exporting records using a script.

 

Still I wonder if FMP13 is aware of what Client is quering it using ODBC.

If (from the point of view of FM11) I consider FMP13 as being an external database (such as SQL of MySQL), can I communicate with it using ODBC ?

 

Regards

Olivier

Share this post


Link to post
Share on other sites

 

So I drop the idea of exporting records using a script.

 

I didn’t say that, in fact, you can script an export of your data using one of the text formats, which could then be imported as a text file into v11. A lot of work. 

 

Lee

Share this post


Link to post
Share on other sites

Can you explain in more detail what are you trying to accomplish here? Migrating your data (once) from FMP13 to FMP11 is quite easy, using export and import. If you plan to maintain your data in FMP13 and serve it in FMS11 on an ongoing basis, then IMHO you are looking for trouble.

Share this post


Link to post
Share on other sites

Hi,

 

Am I looking for trouble ? that is indeed what I need to know.   :)

 

I thought of keeping 2 databases.   The main one in FMP11Server and a tiny one in FMP13.   

 

Upgrading FMP11server to FMP13server would mean an upgrade of server / client hardware + operating systems . 10 machines.

So I am trying to have the extra functionality of FMP13 without rising the bill to unreasonable hights.

 

Because the databases are small and the exchange of data between the 2 versions is also limited (1 table) I was considering ODBC.

Has this been done before ?

 

I would appreciate your expert opinion

 

Regards

Olivier

Share this post


Link to post
Share on other sites
Upgrading FMP11server to FMP13server would mean an upgrade of server / client hardware + operating systems . 10 machines.

 

You have 10 FMP clients? What do they all do with regard to this database? Do they just stare at it or do they modify it in any way? If the latter, how will you propagate these changes back to your .fm12 file? I am afraid this makes even less sense to me than I thought.

 

 

So I am trying to have the extra functionality of FMP13

 

Such as?

Share this post


Link to post
Share on other sites

Hello,

Sorry if I am confusing you. I am just discovering the client/server architecture of Filemaker and might mis some fundamentals.

Thanks again for looking into my question.

The FMP11 clients do indeed modify the FMP11 database server.

Essentially I am indeed looking for a way to propagate the changes made in the .fm12 file to the .fp7 and back.

The main flow (2MB pictures) would be from .fm12 --> to .fm7 . A smaller flow (plain text) would be back .fm7 --> .fm12. They have no common fields, so no synchronisation issues.

As I said earlier it is a small amount of data (20 pictures a day).

Lee suggested (and discouraged) to export and import it again. This is indeed very cumbersome an not a road I plan to take.

Is ODBC between 2 different versions of FM a possibility ? Has it been done before ?

Extra functionality :

- Webdirect with better container field (now I am working with the 360works solution in IWP)

- maybe filemaker go (with FMServer13).

Regards

Olivier

Share this post


Link to post
Share on other sites

Extra functionality :

- Webdirect with better container field (now I am working with the 360works solution in IWP)

- maybe filemaker go (with FMServer13).

 

 

Well, this is the most confusing part, I guess. Are you planning on running FM Server 13 in parallel with FM Server 11? You started by saying:

 

We cannot upgrade the FM Server 11 to 13.

 

Without FM Server 13 you will not get any of the extra functionality you mentioned.

 

 

The main flow (2MB pictures) would be from .fm12 --> to .fm7 .

 

Do you mean actual image files embedded in container fields?

Share this post


Link to post
Share on other sites

We cannot upgrade our current FMServer11 to FMServer13 because we would need to upgrade the OS Software + hardware of clients also.

We would install a new FMServer13 on a seperate machine.

 

Thx, good to know.

 

I would like more or less the same functionality I am getting now with 360works.  

I also recently discovered working with IFrames is better in Webdirect.

 

 

But even if that is not the case I would still like to know :  

Is ODBC between 2 different versions of FM a possibility ? Has it been done before ?

 

 

Regards

Olivier

Share this post


Link to post
Share on other sites
Is ODBC between 2 different versions of FM a possibility ?

 

I don't know for sure. I cannot see any reason why not - after all, as you said, an OBDC client is an ODBC client and the data source should not care who the client is as long it's set up properly. Note that there is a lot of setting up to do, if both servers are to function both as a client and as a data source.

1 person likes this

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Similar Content

    • import
      By Sheju Sathyanesan
      I am looking for, a script or method, so I can import records from CSV to another related table fields ! How is that possible
    • Import XLSX to Child Table
      By John Kostenbader
      It has been covered here but I really can't find a sufficient answer. When I do an automated import of an xlsx file that has no blank lines at the top into a portal that is part of a child relationship I keep getting blank lines. I've confirmed that there are no blank rows in the excel spreadsheet. For the particular import I'm talking about i get one blank line at the top (portal is not sorted in any way). I also get two blank lines at the bottom. I can almost understand the blank lines at the bottom (how does FM know when to stop?) but I cannot wrap my head around why I have one at the beginning
    • Interactive Javascript not working in IE on FM13 and 14
      By Macfreq
      I'm using a web viewer to display a html webpage that allows the user to interact with it via java scripts. The web page works on a Mac running FM13 and FM14 with Mac OS X 10.10 and 10.11. When I try to view the web page in a web viewer on Windows 7 running with IE11 installed, the webpage doesn't allow any interaction with the java scripts, and the web page renders incorrectly. I'm running FM13 and FM14 in Windows 7, and they both render the webpage incorrectly.
      When I copy the HTML out of FileMaker and paste it into a file and open it directly in IE11, I get a security warning on the bottom of the window that says "Internet Explorer restricted this webpage from running scripts or ActiveX controls", when I click Allow, the page renders correctly. If the Allow button is not clicked, the page would render exactly like it does FileMaker's web viewer. So it looks like FileMaker is suppressing this popup and just showing the web page with the scripts disabled.
      I checked Internet Options in IE and all relevant scripting options are enabled, but every time I try to display the page in IE directly, I get the security warning. So I'm assuming if I can get the page to display in IE without the prompt I can get the page to display in FIleMaker. What options need to get set to allow the scripts to run? Why does it work on Mac OS X and not Windows 7? 
    • Container Fields and Printing
      By Answers
      In our database solution we have a table that holds other documents relating to the data. The enduser might insert a PDF or a JPG. So the table is made up of a container field, a job number (unique identifier). To view the file the user clicks in the container (script exports field contents and automatically opens).
      The thing we would like to do is when printing a job report if there are any "external documents", would like them to print as well. We want it be be part of the complete report. The container is setup for interactive content and start playback automatically. The script exports the container and imports it back in... on the Mac it produces the correct results, on the PC  it prints as a pdf icon for example. Maybe what I want is not possible. Any suggestions.
    • FileMaker 14 as data source to MS Access
      By mr_mike
      I have a client that would like to use MS Access to connect to a table in a solution hosted on FMS 14.0.3.  What I'm reading suggests that was possible with .fmp5 and .fmp7 but is no longer available in .fm12.  I've tried to use Access and both (mac) Excel and (windows) Excel to connect via ODBC to the FMS hosted table and I can construct the query and see the fields, but when I submit the request I get an error.  Is it still possible to connect Excel or Access to FileMaker 14.0.3 (hosted)?  The error I get appears on the attached screenshot.
      Is anyone currently doing this?  
      Thank you in advance.