Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


TLIEB last won the day on April 21 2016

TLIEB had the most liked content!

Community Reputation

1 Neutral


  • Rank
  1. TLIEB

    Help with XML stylesheet?

    You could very well be correct...however if we had an IT department in theory I would have never gotten handed this project to begin with since it has nothing to do with my department or my job, just the fact that I "know my way around computers a little".
  2. TLIEB

    Help with XML stylesheet?

    Thank you so much! Now I get data importing at least, hopefully the rest I can figure out by myself. Ah the joys of working at a company with no IT department.
  3. TLIEB

    Help with XML stylesheet?

    I have been given the task of trying to import our postal information which we receive as XML files into Filemaker. I've been searching the forums for the last few days and I've found several examples which I've tried to build off, but I'm still not doing something right. We have no experience working with XML files so I can't quite figure out where I'm going wrong. When I try to import my XML file into Filemaker using the stylesheet I created, It looks like all the fields are mapping right, but I don't get data in any of the fields. I get the following pop up message: This is the stylesheet I have built so far, the sample XML data we were provided is attached. Can anyone point me in the right direction as far as what my problem is and what I need to fix? As an aside, I know I have the CustomerReferenceID field importing twice. Given the sample data we received we're not quite sure which fields we will actually need to import so I'm using one of those entries as a placeholder. <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xml" version="1.0" encoding="utf-8" indent="yes"/> <xsl:template match="/"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="" NAME="" VERSION=""/> <DATABASE DATEFORMAT="" LAYOUT="" NAME="" RECORDS="" TIMEFORMAT=""/> <!-- DEFINE FIELDS --> <METADATA> <FIELD NAME="Mail Date" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Customer Reference ID" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Job Description" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Permit" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Total Postage" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Postage Affixed" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Net Postage" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Quantity" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Affixed Amount" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Metered-Stamped" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/> </METADATA> <!-- IMPORT DATA --> <RESULTSET FOUND=""> <xsl:for-each select="PostageStatement"> <ROW MODID="" RECORDID=""> <COL><DATA><xsl:value-of select="ClosingDate"/></DATA></COL> <COL><DATA><xsl:value-of select="CustomerReferenceID"/></DATA></COL> <COL><DATA><xsl:value-of select="CustomerReferenceID"/></DATA></COL> <COL><DATA><xsl:value-of select="PermitNumber"/></DATA></COL> <COL><DATA><xsl:value-of select="TotalUSPSAdjustedPostage"/></DATA></COL> <COL><DATA><xsl:value-of select="PostageAffixed"/></DATA></COL> <COL><DATA><xsl:value-of select="NetPostageDue"/></DATA></COL> <COL><DATA><xsl:value-of select="TransactionAmount"/></DATA></COL> <COL><DATA><xsl:value-of select="RatePostageAffixed"/></DATA></COL> <COL><DATA><xsl:value-of select="PermitType"/></DATA></COL> </ROW> </xsl:for-each> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet> xml.zip
  4. TLIEB

    Very new to FM, need help

    I've looked at that section, but I wasn't sure it would do what she's looking for. I think, in essence, I was trying to get a feel for if it was something that could even be done so I don't waste my time trying to do something that's not even possible. What she would like is to have any field in a particular layout become un-editable once it has data in it, so that different people can keep adding to the same record filling in more fields but they can't edit what has already been entered. The layout is already set up so I have no control of how it's designed, I'm looking at it after the fact and trying to find a solution that might work. I'm learning a lot by the answers here and part of my challenge is that apparently the way things are set up here is not the recommended way of doing things or the norm. There are no individual log-ins and everyone has full access. Obviously this is not a good way of doing things. There is no one here currently who has any real experience with Filemaker other than as a user so I don't have anyone to go to to try to figure out why things are set up the way they are.
  5. TLIEB

    Very new to FM, need help

    Sorry for not being clear. I would probably be making the changes in this case but only for this. We do not currently have an admin/developer for Filemaker. I was asked to try to figure this out simply because I have some background in programming.
  6. TLIEB

    Very new to FM, need help

    I get that, but I really have no input on the matter. I'm not and won't be the Filemaker admin, I'm just looking into this one particular question for one of our CSR's Does this work on individual fields within a record? Sorry to sound like such a novice, but I really am.
  7. I'm working with Filemaker Advanced Pro 11.0v3. I work for a very small company and the person who set up Filemaker is no longer with the company. I have no experience with Filemaker at all, but I have some programming background so I've been asked to look into an issue with Filemaker to try to see if what we want to do is even possible. The scenario is this - we have one particular layout where several different people would be modifying a single record over the course of a few days. It's basically a shift log where they report what they've done on that shift or on a particular job. I've been asked to try to figure out if we can make it so that once a particular field has data in it, that field is no longer editable, i.e. the first shift crew enters their progress and the second shift crew cannot change what first shift has entered. But - the supervisor would still want to be able to go in and make changes in case anything is entered in error. I've done a lot of reading over the last few days on these forums as well as the Filemaker forums and the Filemaker documentation. I get the sense that it's something that can be done, I just haven't been able to quite figure out exactly how to make it work. As far as I can tell, currently everyone here is set up with full access. I'm assuming I'll have to make a separate privilege set for these users. Can anyone point me in the right direction on what the best course of action would be? Thanks in advance for any advice or pointers!

Important Information

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