8 Replies Latest reply on Oct 22, 2012 8:51 AM by jml

    .fp7 to .fmp12 conversion with a Runtime

    kopfwerk

      Hello!

       

      I currently use .fp7 files for backup-scripts in my runtime ("save as copy") and for restore (via import script steps).

      Now I want to make a new version of my runtime using FileMaker 12 but need the users to restore there user data from their .fp7 files into the new runtime, so they can work with their data in the new runtime.

       

      But the convert script step reports an error, because the backup-files are not part of the solution (even if they were generated by a Runtime solution in the first place).

       

      Is there any workaround for getting the data out of the .fp7 databases into an FileMaker 12 Runtime?

       

      Thanks for your help!

       

      Matz

        • 1. Re: .fp7 to .fmp12 conversion with a Runtime
          jml

          Hello Matz,

           

          Here is the method that I used:

           

          If you are using the data separation model, use the version 12 interface file (.fmpur) to convert your users' runtime data files (.USR) to verson 12 (.fmpur) and then run the backup-scripts to create .fmp12 files.  Next, restore their backup files (.fmp12) into a new clone data file (.fmpur) using the import-scripts.

           

          If you are not using the data separation model, consider creating a small runtime (.fmpur) to do the same things. 

           

          The runtime files (.fmpur and .USR) must use the same bind key.

          • 2. Re: .fp7 to .fmp12 conversion with a Runtime
            intex

            too bad that the FM12 runtime cannot convert fp7 files on its own. You can only

             

            - provide the conversion as a service

            - tell people how to do it with a FM PRO demo or

            - provide an export/import path (with loosing graphics and formatted text).

            • 3. Re: .fp7 to .fmp12 conversion with a Runtime
              kopfwerk

              Hello jml,

               

              thanks for your suggestion, but I seem to fail to understand it.

              Did you mean I should not open my backup file (.fp7) but the .USR file of my previous runtime version?

              I tried:

              I made my new runtime with a script step selecting the old user file that was part of my previous runtime with the same binding code and file extensions.fmpur

              It starts to convert but then reports an error (database damaged).

               

              I don't know how to really solve this...

              • 4. Re: .fp7 to .fmp12 conversion with a Runtime
                jml

                Hello Matz,

                 

                Yes, we have successfully converted the runtime file_name.USR to file_name.fmpur using the scriptstep: Convert File[no dialog; "file:….USR"].  We do not open the old runtime.USR; we convert the file.

                 

                After it is converted, we run the backup-scripts on the converted file_name.fmpur that export the tables as .fmp12 files.  We do this because the schema on the file_name.fmpur was modified and we need to reload the data into the new schema.

                 

                We then restore the .fmp12 files by importing them into a clone file_name.fmpur using our import-scripts.

                 

                This process is automated and has worked successfully for several users at their remote sites without downloading an FMP demo.  Since it uses .fmp12 files, all data, including graphics etc, is restored.

                • 5. Re: .fp7 to .fmp12 conversion with a Runtime
                  kopfwerk

                  Hello jml,

                   

                  I now know where my attempt went wrong. My previous solution did not contain adminstrator access. When you take out the admin access the conversion stucks and reports an error.

                  I republished my pre12 runtime including admin rights and I could convert the .usr file.

                   

                  But since all my clients have the version with no admin access in the runtime I think I have to offer the conversion as a service like intex suggested.

                   

                  Thanks to all!

                   

                  Matz

                  • 6. Re: .fp7 to .fmp12 conversion with a Runtime
                    jml

                    Did you try checking the "Run script with full access privileges" checkbox at the bottom of the script?

                    • 7. Re: .fp7 to .fmp12 conversion with a Runtime
                      kopfwerk

                      Yes. But it only works if the admin privilegues are part of the "old" runtime. In my case, they are not, and this seems to prevent the conversion to run.

                       

                      Sadly...

                      • 8. Re: .fp7 to .fmp12 conversion with a Runtime
                        jml

                        That's odd.  The admin access was removed from both the "old" and "new" runtimes in my case.