Devin

You are correct. Should have said near the bottom. But to answer you question. No there will not be another ValueObject with these.

Interesting approach. I tested this and it works. Is their away to import this for every record? Found at the bottom of XML. <objectName>JobProject</objectName> <primaryKey>5915</primaryKey> The <objectName> is the Filed Name and the <primaryKey> is the Vaule

I'm trying to import an XML with the XSL, but it's not working. I'm not exactly sure what my issue is.. let alone if what I'm trying to do can even work with style of XML. Currently I've been using xpath to loop thru and get all the records but due to the large number of records this can take a very long time I've attached the example xml and xsl. Inventory.xsl Inventory.xml

Yes.. I did mean relationship..Sorry about that.

Sorting that Portal worked perfect.. Thanks

I've got 4 tables. Product, Vendor, VendorProducts and Product Price. A Product can have multiple Vendors. Each Vendor has their own price for a product. My issue is I want to also Track the Price changes a vendor makes but also show the latest pricing when looking at a product. When setting up the Portal to list the VendorProducts on Products is not an issue but returning the latest Product Price based on a timestamp is the issue. I could create a script to place the latest price in the VendorProduct but that seems like the wrong approach.. The other thought is maybe create a Calc Field in VendorProducts to return the price is thats possible? Or maybe there is even a better way.... Thanks

This worked perfect.. The use of Mod is something I would never have thought of. Thanks

Comment, Yes you are correct, it should have been AM for the 2nd example. After reviewing, it will be best to get the result as TimeStamp. I can easily extract Date from a timestamp if needed later for something. You are correct on your understanding of the result. But know that we are wanting to return a Timestamp, we will want to return not only the correct date but change the Time to 1 PM. Thanks

So I'm in need of calculating a Timestamp field that will give me the next Wednesday date. Here is the calc that I started using GetAsDate ( Date ) + Mod ( 4 - DayOfWeek ( GetAsDate ( Date ) It works, expect now I need worry about the time. If the time is after 12pm on a Wednesday I need to return the next Wednesday and not the current Wednesday. Examples 10/16/19 2:04:35 PM --> 10/23/19 10/16/19 8:23:55 AM --> 10/16/19 10/15/19 4:26:35 PM --> 10/16/19 10/18/19 6:14:17 PM --> 10/23/19

Comment, Thanks for the XSLT.. This worked. But it turned out that they system that was in-taking the XML could only handle single items at a time...Ugh.. So I ended up creating a script that would add the remainder to the largest value. Thanks for your help

So I knew I could do rounding in an XSLT but never tried. But the remainder part Interesting!!! When you say a simple correction of the last value would be trivial.. Could you give an example? Not seeing anything trivial from my thought process.

I'm exporting to another system via XML. and the filed will need to be x.xxxx but to keep it simple I just need to give x.xx (0.80).

I'm in need of some help in what might be the best way to go about solving my issue in how it relates to Filemaker. I've got a table that is using 3 fields "Sqin", "sqin.s" and "PercentUsage.c" Sqin = number filed sqin.s = Summary - Total of Sqin PercentUsage.c - Calculation (Sqin / sqin.s )= This give me the exact percentage of each record.. Issue is I now need to export the data to another system, but it only allows for 4 digits.. ( 0.1234). Due to simple rounding when you add up the values you may get less then 1.0 or more then 1.0. Doing some google searches I came across this site that I think explains the issue pretty good and how to go about resolving it. For this project the accuracy does not need to be perfect and if a few are off that is fine. https://stackoverflow.com/questions/13483430/how-to-make-rounded-percentages-add-up-to-100 So any ideas or ways that I should be thinking in how to solve this issue? Thanks

Did you install the the correct Java? https://support.filemaker.com/s/article/Changes-to-Java-in-FileMaker-Server-18-0-2-and-Later?language=en_US

So if no updates to the system have been done.. and Computer has been restarted and your still having an issue then either the custom or the XML it's self is bad.. Can you go back and parse an older XML that did work? We are kinda blind as we don't have the XML that our trying to parse.

Sounds like a issue with the custom. I’ve never had this issue and parse way over 30k. I use the base element plugin.

That worked.. Thanks.. and Thanks for the Link.

I've got a simple ( I hope) export as xml issue Here is my current .xsl that is erroring.. My issue is Line 9.. I'm not sure how I need modify the Attribute of Pages? <?xml version="1.0"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fmp="http://www.filemaker.com/fmpxmlresult" xmlns:xalan="http://xml.apache.org/xalan" version="1.0" exclude-result-prefixes="fmp xalan"> <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes" xalan:indent-amount="2"/> <xsl:template match="/"> <JDF xmlns="http://www.CIP4.org/JDFschema_1_1" Status="Ready" Type="ProcessGroup" Version="1.2"> <ResourcePool> <RunList Class="Parameter" ID="Link1" Locked="false" PartIDKeys="Run" Status="Available"> <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <RunList Class="Parameter" Pages="<xsl:value-of select="fmp:COL[3]/fmp:DATA"/>" Run="1"> <LayoutElement> <FileSpec URL="file://%2a.pdf"/> </LayoutElement> </RunList> </xsl:for-each> </RunList> </ResourcePool> <ResourceLinkPool> <RunListLink Usage="Input" rRef="Link1"/> </ResourceLinkPool> </JDF> </xsl:template> </xsl:stylesheet> Here is an example of what I want to see when I export.. The only real part that changes is the "Pages=" part. <?xml version = "1.0" ?> <JDF Status="Ready" Type="ProcessGroup" Version="1.2" xmlns="http://www.CIP4.org/JDFschema_1_1"> <ResourcePool> <RunList Class="Parameter" ID="Link1" Locked="false" PartIDKeys="Run" Status="Available"> <RunList Class="Parameter" Pages="7" Run="1"> <LayoutElement> <FileSpec URL="file://%2a.pdf"/> </LayoutElement> </RunList> <RunList Class="Parameter" Pages="8" Run="1"> <LayoutElement> <FileSpec URL="file://%2a.pdf"/> </LayoutElement> </RunList> <RunList Class="Parameter" Pages="9" Run="1"> <LayoutElement> <FileSpec URL="file://%2a.pdf"/> </LayoutElement> </RunList> <RunList Class="Parameter" Pages="9" Run="1"> <LayoutElement> <FileSpec URL="file://%2a.pdf"/> </LayoutElement> </RunList> <RunList Class="Parameter" Pages="10" Run="1"> <LayoutElement> <FileSpec URL="file://%2a.pdf"/> </LayoutElement> </RunList> <RunList Class="Parameter" Pages="10" Run="1"> <LayoutElement> <FileSpec URL="file://%2a.pdf"/> </LayoutElement> </RunList> <RunList Class="Parameter" Pages="0" Run="1"> <LayoutElement> <FileSpec URL="file://%2a.pdf"/> </LayoutElement> </RunList> </RunList> </ResourcePool> <ResourceLinkPool> <RunListLink Usage="Input" rRef="Link1"/> </ResourceLinkPool> </JDF>

If all the related records have a 0 for Boolean then I would want True.. If all of them had 1 for the Boolean I wound want true.. I only want false if I had a mix on 1 and 0 for the related records.. I tested this with one record and it's working correctly if its a 0 or a 1.

Yes. this make perfect sense.. I just got done doing a quick test file and it does exactly what I need.. I ended up doing a calc field to review the count and sum fields doing a "If ( Sum = 0 ; "True" ; If ( Count > Sum ; "False" ; "True" ) )" Seems to work exactly like I hoped. Thanks Guys!

I've got this trouble that I hope someone can lead me down the right row of thinking on this.. I've got a simple sales order document that has a related table for line items.. For each line item I've got a Filed being used as a Boolean.. (0 or 1). For this document I need to know per order if a mixtures of 0 or 1 line items are in the related table. .. They don't care if they are 0's or all 1's.. Thanks

Your going to need to reach out to each of your partners and see what options they have for sending you the data. This can be done via an API or something as simple as them sending you csv files..

docasar, That can be done by using the EmailReadMessageValue... The Doc describe this and even give an example for what your asking.. Set Variable [ $result = EmailReadMessages( "viewed=false" ; "readonly=false" ) ] If [$result = "ERROR"] # Handle Error Here... End If Loop Exit Loop If [not EmailGetNextMessage] Set Variable[$result ; EmailMessageSetFlag("viewed") If [EmailReadMessageValue("from") = "deleteme@example.com"] Set Variable[$result ; EmailMessageSetFlag("deleted") End If End Loop In this case they are deleting the message from deleteme@example.com..

Docasar, 360works email plugin does just what your wanting to do.. Have you looked at it.. They offer a free demo version that works for 2hours before you need to relaunch Filemaker.

I was just thinking about trying pattern count for ¶. From what I can tell based on my scan of emails they have 4 different ways they are suppling the address. 1 - 7line version, 2 - 6 line version and 1 -5 line version. By doing an if statement for them based on the pattern count.. For the 2 - 6 lines version will need to see if only numbers are the last line. then based on that I would know what version of the 6 line it is. Just me thinking out loud..