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

    • PSOS Import Records is failing
      By thomas.brinch
      Hi,
      I have a problem with server side import of records. I have a simple script which just does an import of a textile (with tab delimiters):
      Set Variable [$FileList; Value: "filewin://server/folder/1795739.txt"]
      Go to Layout ["files" (files)]
      Import Records [No dialog; "$FileList"; Add; UTF-8]
      When I run it client side, everything is fine. When I run it server side with Perform Script on Server I'm getting an error:
      The previous script step, "Perform Script on Server", could not be completed because of an error....
      If I run Get ( LastError), I get error code 100 (File is missing)
      I have tried many different file locations for the textile. Network path, Local path (on the FM server) and Relative path (from where the database is placed on FM server).
      I have tried placing the file in the FM server Databases and Documents folder AND the User Documents folder:
      filewin://server/folder/1795739.txt
      filewin:/C:/Users/ARAXI/Documents/1795739.txt
      filewin:/C:/Program Files/FileMaker/FileMaker Server/Data/Documents/1795739.txt
      filewin:/C:/Program Files/FileMaker/FileMaker Server/Data/Databases/1795739.txt
      file:1795739.txt
      Every time I get error 100. What am I doing wrong??
      FileMaker server is v14 on Windows Server 2008 and the client is running on Windows 7.

       
    • Import pdf and word documents from folders
      By shevyshevy
      I have been able to use the Import script step to import pictures from a folder. However, doing the same for bunch of pdf and word document files have not been a success. Is there any special trick to achieve this?
    • Move Records to a new Table
      By shevyshevy
      I have two tables Temporary and Real, the procedure is that contacts are created on the temporary table, probably by the contacts themselves. then once they have been confirmed as Clients (ie after their details have been verified by our staff), I would want to move them from the Temporary table to the Real table.  Please how can I achieve this?
    • Import records from table to table not behaving as expected.
      By gerg nnud
      I am trying to copy selected line item records from one table to another as part of an intended 'recurring transactions' structure. For some reason if I perform a find on line items for that transaction and attempt to import into the recurring line items table it wants to import all records (12000) and not the found set (1-20) as I would expect. 
      I have just conducted some tests with other databases to confirm I have an issue with this database only. The test databases would only import the found set from table to table as expected. Is my db corrupt or is there some setting somewhere thats changes this behaviour? Any help would be appreciated. FM13.
    • Help with XML stylesheet?
      By TLIEB
      I have been given the task of trying to import our postal information which we receive as XML files into Filemaker. I've been searching the forums for the last few days and I've found several examples which I've tried to build off, but I'm still not doing something right. We have no experience working with XML files so I can't quite figure out where I'm going wrong.
      When I try to import my XML file into Filemaker using the stylesheet I created, It looks like all the fields are mapping right, but I don't get data in any of the fields. I get the following pop up message:

       
      This is the stylesheet I have built so far, the sample XML data we were provided is attached. Can anyone point me in the right direction as far as what my problem is and what I need to fix? As an aside, I know I have the CustomerReferenceID field importing twice. Given the sample data we received we're not quite sure which fields we will actually need to import so I'm using one of those entries as a placeholder.
      <?xml version="1.0" encoding="UTF-8"?>
      <xsl:stylesheet version="1.0"
      xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
      <xsl:output method="xml" version="1.0" encoding="utf-8" indent="yes"/>
      <xsl:template match="/">
      <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
        <ERRORCODE>0</ERRORCODE>
        <PRODUCT BUILD="" NAME="" VERSION=""/>
        <DATABASE DATEFORMAT="" LAYOUT="" NAME="" RECORDS="" TIMEFORMAT=""/>
       
        <!-- DEFINE FIELDS -->
        <METADATA>
         <FIELD NAME="Mail Date" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Customer Reference ID" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Job Description" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Permit" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Total Postage" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Postage Affixed" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Net Postage" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Quantity" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Affixed Amount" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Metered-Stamped" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/>
        </METADATA>
       
        <!-- IMPORT DATA -->
        <RESULTSET FOUND="">
         <xsl:for-each select="PostageStatement">
          <ROW MODID="" RECORDID="">
           <COL><DATA><xsl:value-of select="ClosingDate"/></DATA></COL>
           <COL><DATA><xsl:value-of select="CustomerReferenceID"/></DATA></COL>
           <COL><DATA><xsl:value-of select="CustomerReferenceID"/></DATA></COL>
           <COL><DATA><xsl:value-of select="PermitNumber"/></DATA></COL>
           <COL><DATA><xsl:value-of select="TotalUSPSAdjustedPostage"/></DATA></COL>
           <COL><DATA><xsl:value-of select="PostageAffixed"/></DATA></COL>
           <COL><DATA><xsl:value-of select="NetPostageDue"/></DATA></COL>
           <COL><DATA><xsl:value-of select="TransactionAmount"/></DATA></COL>
           <COL><DATA><xsl:value-of select="RatePostageAffixed"/></DATA></COL>
           <COL><DATA><xsl:value-of select="PermitType"/></DATA></COL>
          </ROW>
         </xsl:for-each>
        </RESULTSET>
      </FMPXMLRESULT>
      </xsl:template>
      </xsl:stylesheet>
      xml.zip