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

    • By Anna.anto
      Attention: Before posting in the general discussion forum please review the other forums that would best suit your topic.
      If you cannot find one then you may delete this text and post your topic in this forum.
      Hi all, I need to import into filemaker table an XML file as this:
      <?xml version="1.0" encoding="utf-8"?>
      <Account>
        <Field APIName="WrntyID">6029065</Field>
        <Field APIName="ExternalID">1761A</Field>
        <Field APIName="Name">sayIT SA</Field>
      </Account>
      now I'am trying to create the xls file.
      This is my xls file....
      <?xml version='1.0' encoding='UTF-8'?>
      <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
          <xsl:template match="/">
              <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
                  <METADATA>
                      <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="WrntyID" TYPE="TEXT"/>
                      <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ExternalID" TYPE="TEXT"/>
                      <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Name" TYPE="TEXT"/>            
                  </METADATA>
                  <RESULTSET>
                      <ROW>
                          <COL>
                              <DATA><xsl:value-of select=“Account/Field[1]" /></DATA>
                          </COL>
                          <COL>
                              <DATA><xsl:value-of select=“Account/Field[2]” /></DATA>
                          </COL>
                          <COL>
                              <DATA><xsl:value-of select=“Account/Field[3]” /></DATA>
                          </COL>
                          </ROW>
                  </RESULTSET>
              </FMPXMLRESULT>
          </xsl:template>
      </xsl:stylesheet>
      This instruction <xsl:value-of select=“Account/Field[1]"/> doesn't work.
      What is the right syntax to retrive the value of the first TAG FIELD? Then the second end so on...?
      Many thanks
      Anna
       
    • By Spidey
      Hi,
      I have FileMaker 11 and I created a interface to pull data from my website's sql.  I am able to change the name of a product, but I cannot change the price of the mysql table through the FM 11 interface.  Is there something I miss doing?   I am using odbc to connect.  Thanks.
       
    • By jax
      Hi FMers,
      I'm trying to get multiple choice quiz questions into a FileMaker database. The information is in a plain text file. Question and options are simply separated by returns:
      Where in the cell is the genome located?
      Mostly in the cytosol.
      Mostly in the mitochondria.
      [X] Mostly in the nucleus.
      Stored in the membrane.
      Stored in RNA.
      Next question...
      Each question has 5 options, one of which is correct [X]. There's an empty line between questions.
      What's a good approach to get this into a FileMaker database with separate fields for the questions, the options, and the correct solution?
      All the best
    • By beerad
      I am modifying the Invoice sample that comes with FM to provide some basic Inventory management functions.  Works pretty well.  However...I really need to be able to order a product in 2 ways :  (1) (Kit - ISBN) and have that deplete and ship all of the parts that make the kit. (2) as individual pieces)  For example:
      Kit 1234 (includes)
      3 of part 2234
      5 of part 9987
      1 of part 097
      Someone might order Kit 1234 PLUS an extra 9987.
       
      Make sense?  No clue on how to connect them.  Thanks in advance File Maker Jedis.
    • By H
      Hi i created a certificate and want that when it is clicked to save it it gets created into a pdf and then imported into the cetification container field , however for some reason i am recieving some error  in my script  , the pdf does not save at all. 
      see script below:
       
      i would appreciate if someone could tell me where i went wrong why my pdf is not saving and if this is the method to save the pdf to a container