Jump to content

Works with FMP 12, not with FMP 13.


This topic is 2523 days old. Please don't post here. Open a new topic instead.

Recommended Posts



To test FMP 13, I did install it on top of FMP 12, on a PC, Win 7, 

It seemed to work properly, with a strange exception. 


The script command, Import records, which works properly with FMP 12, doesn't work, on the same PC, with the same file on the same FMS 12 server, using the same script.... It returns Error 10, data required missing. (I translate from the french version)


(See the context in the attached file)


I was asked on the french forum to try insert from url : same problem works on FMP 12, not FMP 13


I was asked to compare the result of the calculated url in the viewer. They seemed to be exactly the same. (even the viewer answered 1 when asked URLFMP12 equals URL FMP13)


I was asked to open the url in IE, to copy the XML code into notepad and to save it with an XML extension. When I tried the import record script command from this file, it did work with FMP 12 and FMP 13....


Does somebody have any explanation? 

Thank you for your help. 


Erreur FMP13-2.pdf

Link to comment
Share on other sites



It seems that nobody is very inspired by my problem, nevertheless very puzzling for me.


The french speaking forum could not find any explanation, but tried!


What about the english speaking forum? !!


Any suggestion to go forward?

Thank you,



Link to comment
Share on other sites


No Answer, it's disappointing



That's a bit harsh to post back.  These are all volunteers that spend numerous hours helping out where they can.  You can not expect a answer.

Your problem is very difficult to troubleshoot in the abstract without seeing all the data, the produced XML, etc.

Plus it is coming up to the Labor Day weekend in the US and Canada so a lot of people are taking time off.


There's always the option of logging a support ticket with FMI and have them look at the solution.

Link to comment
Share on other sites

Probably too difficult!


Yes, it is difficult to analyze a problem without being able to reproduce it. At minimum, you should have included a screenshot of the exact error message (even in French).


One thing I can tell you is that there has been a change in the way Importing data from a URL works in version 13. It wasn't supposed to break anything that has been working in previous versions, but - as with any change - it could have. It certainly sounds like you are describing a bug.

Link to comment
Share on other sites

Thank you for your answers


First of all, I certainly didn't meant to be rude. I fully understand the context of this forum. Actually, I was disappointed not to have any answer, even if I understand that nobody has to answer and that it could be difficult to answer.
I'm really sorry if I did hurt somebody.


I attached some screenshots.


I remind (see previous post) that the problem occurs on the same machine, the same file on the same FMPS 12 server, the same script. The only change is the FMP A version. It works with 12 not with 13


The FMP error message that I get with 13  is, in french, Erreur 10. Données requises manquantes. Error 10, Required data missing?


You will find a screenshot of the script step, a screenshot with the URL calculation and result in the viewer in FMP 12 and FMP 13, which are the same for me, a screenshot of the XML file (Calculated URL in Internet explorer, on the same machine)


I can add that, when I copy/paste this XML file in notepad, save it with an XML extension, the i"mport records" from this .xml file works, both in 12 and 13...


Thank you again for your help, if possible!






FMP script .pdf

FMP Viewer.pdf

FMP XML File.pdf

Link to comment
Share on other sites

I could not reproduce your error message when importing XML. As I said, it sounds like a bug. To make sure, I would suggest you create a brand new file, with a single table and only a few fields. Then try to import into this file, using a script with only one step - Import Records - and with the HTTP request being hard-coded, not calculated. If this works in 12 but not in 13, then ring the bug bell.

Link to comment
Share on other sites

New file, test

One table

One script 

One script step : import records

URL = copy paste from the result of the calculated URL in the viewer


Works with 12, doesn't with 13 (Again, same machine, same file, same script, ....)


How can I report such a problem to Filemaker?

Link to comment
Share on other sites

This topic is 2523 days old. Please don't post here. Open a new topic instead.

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

  • Similar Content

    • By Ragupathi013
      Hi everyone,

      I Need to display the Tooltips in web direct but its working filemaker pro and its working in IWP also But its not displaying in filemaker web direct can any guide me how to do this ??
    • By Ralph Schwegler
      I am working on a customization and have following issue:
      the Date Format is the US format (Month/Day/Year) and I need it to be the swiss/european format (day.month.year)
      The OS settings are correct, the FileMaker received the info to use the system settings, but there must be something  in the file itself.
      Any help on that?
      Thank you for any input
    • By happymac
      We have records with an external container, and sometimes the user will want to insert a new file into the container in place of the existing container file yet keep the same file name.  By design, Filemaker changes the file name to add an incremental suffix, so in the external container’s directory we see the original file and a new file with a suffix instead of deleting or overriding the original file.   so now we have two files, named originalimage.jpg and originalimage_1.jpg.  I understand WHY FileMaker does this ... it is sort of a fail safe to avoid a situation where a user accidentally uploads two images with the same name into two different records but since they technically different files, filemaker is trying to protect the original file from deletion. Problem is … in our case, we want to turn off this fail safe.  We have other systems in place that deal with duplicate file names, so if the user wants to upload a file with an identical name, we want to delete or overwrite the original file and not create a second file.
      A good example is an image, where the user inserts an image into the container, then outside of FileMaker they edit that image so it is now a different file size with different attibutes.  Then the user inserts the newly edited file (but same filename) into the same record's container.   Currently the end result is that we end up with two files in the directory (one with a _1 suffix on the name), but we only want the new file to exist.
      what I was originally thinking of doing was to first remove the existing (original) container (using set field to be "", or clear field, or cut) along with a goto field OR commit record and then inserting the new file.  but for some odd reason, this doesn’t seem to work.  The file names keep incrementing.
      How can I clear the existing container data before I insert a new file into the container?
      Thank you!
    • By Justin Close
      In FMP 13.02 FileMaker apparently fixed the FMP URL for the desktop client, such that it could be used to make a call to the same/local/self file.  So I would have a web viewer in a solution and it would use an "fmp://web.address/dbname..." URL that would reference itself, the file that was currently open.

      I found some references to how to do this, but for some reason things aren't working for me.  Apparently, if you are on a non-mobile platform, you need to use "$" as the IP address to reference the local file.  E.g. "fmp://web.address/dbname.fmp12?script=AScriptName&$var1=1234&$var2=abcd".  This would make the database essentially accept AJAX calls.  (Although an unanswered question for me is how does the response or data get back to the web viewer.  But for now, I just want to register event that trigger sending new data into the DB.)

      Here's the code I am using for my web viewer definition.  The short description is that I am trying to integrate Full Calendar into a web viewer in a solution.  I am trying to configure the onDrag event so that when an event is modified it sends the new date range back to the DB.

      Let ( [     _IPDestination = If ( Left(Get(FilePath);7) = "fmnet:/"; Get ( HostIPAddress ) ; "$" ) ;     _fmpURLString = "fmp://" & _IPDestination & "/" & Get(FileName) & ".fmp12" ;     _fmScript1 = "?script=FullCalendarChangeDate";     $CurrDate = "2015/7/01"         //hardcoding for testing purposes ]; "data:text/html, <!DOCTYPE html> <html><head><meta charset='utf-8' /> <link rel='stylesheet' type='text/css' href='http://cdnjs.cloudflare.com/ajax/libs/fullcalendar/2.3.1/fullcalendar.min.css'/> <script src='http://cdnjs.cloudflare.com/ajax/libs/moment.js/2.9.0/moment.min.js'></script> <script src='http://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js'></script> <script src='http://cdnjs.cloudflare.com/ajax/libs/fullcalendar/2.3.1/fullcalendar.min.js'></script> <script>     $(document).ready(function() {         var   httpXHR, fmpurl ;         $('#calendar').fullCalendar({             defaultDate: '" & $CurrDate & "',             editable: true,             allDayDefault: true,             eventStartEditable: true,             eventDurationEditable: true,             dayClick: function() {                 alert('a day has been clicked!');             },             eventDrop: function(event, delta, revertFunc) {                 if (!confirm(event.title + ' was dropped on ' + event.start.format() + '.nAre you sure?')) {                     revertFunc();                 }             },             eventResize: function(event, delta, revertFunc) {                 if (!confirm(event.title + ' end is now ' + ( event.end.format() ) + '.nnIs this okay?')) {                     revertFunc();                 } else {                     fmpurl = '" & _fmpURLString & _fmScript1 & "&$eventid=' + event.id + '&$newEndDate=' + event.end ;                     httpXHR = new XMLHttpRequest();                                 httpXHR.open("GET", fmpurl, true);                 }             },             events:  [                 {                     id: 1,                     title: "Project 1",                     start: "7/1/2015",                     end: "7/3/2015"                 },                 {                     id: 2,                     title: "Project 2",                     start: "7/3/2015",                     end: "7/7/2015"                 },                 {                     id: 3,                     title: "Project 3",                     start: "7/7/2015",                     end: "7/7/2015"                 },                 {                     id: 4,                     title: "Project 4",                     start: "7/7/2015",                     end: "7/11/2015"                 },                 {                     id: 5,                     title: "Project 5",                     start: "7/14/2015",                     end: "7/16/2015"                 },                 {                     id: 6,                     title: "Project 6",                     start: "6/18/2015",                     end: "7/3/2015"                 },                 {                     id: 7,                     title: "Project 7",                     start: "7/30/2015",                     end: "8/15/2015"                 },                 {                     id: 15,                     title: "Project 15",                     start: "6/08/2015",                     end: "6/19/2015"                 }             ]         });             }); </script> <style>     body {         margin: 0;         padding: 0;         font-family: "Lucida Grande",Helvetica,Arial,Verdana,sans-serif;         font-size: 14px;     }     #calendar {         width: 900px;         margin: 40px auto;     } </style></head> <body>     <div id='calendar'></div> </body> </html> " )

      In the middle of that you will see these three lines, where I am trying to make that call back to the local file from the webviewer:

                  fmpurl = '" & _fmpURLString & _fmScript1 & "&$eventid=' + event.id + '&$newEndDate=' + event.end ;
                  httpXHR = new XMLHttpRequest();            
                  httpXHR.open("GET", fmpurl, true);

      Any one have experience achieving this?  Todd Geist's Watermark module uses this technique but I can't seem to extract that functionality for my own purposes here. 


      -- Justin

    • By Rick Whitelaw
      I'm missing something here.i received an email from FMI about the latest update and followed the links etc. I run FMS with SSL turned on. The default certificate is used I assume. Now it seems the cert is only good for testing. Has this always been the case? Ami to assume that I must now purchase a third party certificate to use SSL effectively?
  • Create New...

Important Information

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