Leaderboard

I am not sure what exactly I am looking at. To move this forward, I suggest you do the following: Enter some dummy data into your FMP file (if necessary, use a copy of the real file). Make sure you have at least two records; Export the fields you need as XML, using the FMPXMLRESULT grammar, with no XSLT stylesheet applied; Write an XML document, using the same dummy data, in the format you need for importing. Then post the two files here. Note: I am asking for at least two records, because the files you have shown so far seem to have only one record and no provision for multiple records in their structure.

Oh the irony AutoUpdate out of date

Do note however: in a found set sorted by Category, where category can be be either A or B or C, a calculation field = sTotalValue - 2 * GetSummary ( sTotalValue ; Category ) when placed in a trailing grand summary part, will return the equivalent of: sub-summary value of A + sub-summary value of B - sub-summary value of C This is because the calculation will be evaluated from the context of the last record in the found set, which belongs to category C.

I am trying to diagnose the problem before suggesting a solution. I know this is not very common practice in the Filemaker community, but that is how I prefer it.

https://www.youtube.com/watch?v=94HVrQblPcc DB Services shows different ways to generate a PDF and email. I reference this video because it shows at the end how his report script is called by a server script schedule which is what you want to do. You'd need to add to your report script the logic to see if it's the last day of a semester. As Olger mentioned, this can be a query to a table that has a record for each last day of semester. Also see: https://fmhelp.filemaker.com/help/18/fmp/en/#page/FMP_Help%2Frunning-scripts-on-server.html

I think it's the same question. It's all about how to handle a many-to-many relationship. And the answer is the same: you need a table of Departments, one table for the technicians and a join table for the assignments of technicians to departments. Have a look at the attached demo. It shows a textbook implementation of a many-to-many relationship. Note that it is symmetrical: you can assign staff to a department or departments to a staff member, with the end result being the same. Assignments.fmp12

You initiate the run of a script in the scheduler on the server. You specify a date and time when to run a script. You can run a script once or repeat it every day, every hour, etc. In the script you can then check the current date and time to determine whether it's a last semester day. I'm not sure I understand your question about PSOS. A PSOS script is triggered from a client. Not from the server. You can't run the PSOS script command on the server.

I don't think that's the problem here. The nodes in my test.xml ARE in the same order for every ROW. And you can certainly change that order to anything you want (the simplest way is by changing the field order when exporting).

That sounds like you're not working the InDesign end correctly. The thing that puzzles me the most is that you say you are able to make it work with data from Access - but you're not able to tell us what the difference is. I can help you with getting the export from Filemaker to conform to any format that works for you. But I cannot help you with finding out what that format needs to be.

What exactly does that mean? IIUC, you're supposed to map the input to placeholders in your InDesign document. What's preventing you from putting the info where you want it?

Not sure how relevant it is https://www.filemakermagazine.com/videos/publishing-indesign

This is very confusing. If you are trying to export data from Filemaker into another XML schema, then we need to know (a) the structure of your source FMP file and (b) the structure of the target schema. I can't see how any part of the codes you have posted is relevant to this task. As an aside: This is a non-sequitur. The XML grammar used when exporting has nothing to do with the result being "flat" or otherwise. It has everything to do with what can be changed in the FMP file without breaking the export: field names (when using the FMPXMLRESULT grammar) or field export order (when using the FMPDSORESULT grammar).

My previous reply had some inaccuracies - I have edited it. I am afraid I was mistaken on this point (I have overlooked the significance of the relationship using the x relational operator). The simple fix here would be add a calculation field to the contacts table - see the attached file. portal_filterA.fmp12 It would enable you to solve this using relationships instead of portal filtering - at the expense of making your graph more complex:

Cloud FIRST, not Cloud ONLY Oh, and get with the programme and start learning to update.... That's the message (paraphrased obviously)

Hello, Yes, placing a button on the fields won't affect MirrorSync's ability to access data in fields and to write to them.

What I would really like to see is a native android and Linux client. They're already running the server on Linux in AWS, so its not that big a step. And with technologies like flatpak it could be made to work on most distros without too much effort. Ah, not having to run Windows any more... What a dream... And no, Mac isn't an option.

Ok i discovered the issue! I opened the Auto Update on your server Demeter then went to the layout Host your own Auto Update File clicked the download File That file is out of date.

If I understand correctly your description (which is not at all certain) then no, I don't think you're missing anything. You can use GetSummary() to get the sub-summary value within a sorted group.There is no way (that I know of) for a calculation to reach out to another sorted group and pluck its sub-summary value. Ostensibly, you could define a calculation field using (only) the GetSummary() function, and then use GetNthRecord() to get the sub-summary value of another group. But you would have to know how many records away the other group is - which is not likely when there are more than 2 groups. If all the records in the three groups have a common parent record in another table, you could do the calculation there, using 3 relationships. But then you would lose the ability to report on a found set of only some of the related records. Actually, here there is a simpler way: use the method known as Fast Summaries to collect the sub-summary values of the groups in your existing found set. Or a single calculation field that would split the values into 3 separate repetitions that can be summarized individually.

The best way to find the problem, IMHO, is to save an example file from Excel itself in the Excel 2003 XML format. Then open the file in a text editor and compare it to the file produced by exporting from Filemaker. The file produced by Excel will have many more elements and attributes; you can find out which of these are essential by removing them in turn and testing if Excel still opens the file. Once you have removed the "noise", you will have an example of what your result needs to look like and you can tailor your XSLT accordingly.

Hi guys, I was reviewing this code and was hoping you guys could try something for me. Pass in the parameter PublicKeyAuth=1 and then for the password parameter pass in the private key pass phrase. If there is no private key pass phrase just pass in an empty string (""). So your function call would be something like Try that and let me know if you are able to authenticate that way.

Yes, that is correct. You can only copy/paste layout OBJECTS from one layout to another. Which means you want to make sure the target layout has all the required parts and sufficient size to accommodate the pasted objects.

Sure. If you define the tooltip with an expression along the lines of: Count(PortalTO::RemoteTablePrimaryKey) It will return the number of related records available for display in the portal. :)