Jump to content

Devin

Members
  • Content Count

    143
  • Joined

  • Last visited

Community Reputation

2 Neutral

About Devin

  • Rank
    member

Profile Information

  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    18

Platform Environment

  • OS Platform
    X-Platform

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Yes.. I did mean relationship..Sorry about that.
  2. Sorting that Portal worked perfect.. Thanks
  3. 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
  4. This worked perfect.. The use of Mod is something I would never have thought of. Thanks
  5. 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
  6. 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
  7. 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
  8. 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.
  9. 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).
  10. 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
  11. 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
  12. 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.
  13. Sounds like a issue with the custom. I’ve never had this issue and parse way over 30k. I use the base element plugin.
  14. Devin

    xsl Attribute issue

    That worked.. Thanks.. and Thanks for the Link.
  15. 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>
×
×
  • Create New...

Important Information

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