Jump to content

Search the Community

Showing results for tags 'xslt'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions
  • FileMaker Platform

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • Button Bar Icon - Text Alignment Issue

Categories

  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 23 results

  1. I need some help in determining if I am missing something crucial here or if there is a limitation or bug in the function BE_ApplyXSLT from the BaseElements plugin. I am using version 3.3.4 (which is the latest) on Mac OS X 10.11.6 using FileMaker 15 Adv. and 16 Adv. I am unable to get any output from the transformation, nor any error. According to the documentation, the command shall return either 0 when successful or an error. Link In my testing it only returns blank, and gives no error even when no output file is generated. It should not return blank in cany case according to the docs. (I suspect there may be a documentation error and that it actually returns blank when there is no error.) No error is found using Get(LastError). BE_GetLastError returns 0. The function format is this: BE_ApplyXSLT ( xmlPath ; xslt ; outputPath ) Here are the input parameters I have used: BE_ApplyXSLT ( "/var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/ABC_nota_108.xml" ; BE_ReadTextFromFile ( "/var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/HTMLvisning/Stylesheet_Full.xsl" ); "/var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/output.html" ) I have verified that the files exist and that both the XML and XSLT are valid. All files are in UTF-8. I can transform the XML with this XSLT using other methods without errors. I have also tried having the XSLT in a variable. As I understand it, BaseElements uses the libxml2 engine. I have tried doing the transform from the command line directly and it works as it should: xsltproc -o /var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/output.html /var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/HTMLvisning/Stylesheet_Full.xsl /var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/ABC_nota_108.xml It also works fine using the XMLLib OSAX in AppleScript. Unfortunately, I need Windows support also so I would like to get the BaseElements function to work. I hope somone can shed some light on what may be going on.
  2. I am having some trouble getting my XSLT file to work. I have followed many of the posts on here and have referenced https://www.w3schools.com/xml/xsl_intro.asp https://www.w3schools.com/xml/tryxslt.asp?xmlfile=cdcatalog&xsltfile=cdcatalog I seem to be able to get the examples to work and have had success with the example files for metars.cache.xml weather meter readings, but can't see why my own isn't working properly when it looks the same to me. Any guidance would be gratefully received. I am not new to Filemaker but this is my first attempt at importing and exporting data to/from our solution in XML which meets the UK Government standards. My XSLT seems only to match fields but not actually import and records. I have attempted referencing the template match to root with <xsl:template match="/Message"> but this causes an "Invalid Document Structure" error in Filemaker, which doesn't seem to be a problem with the w3schools try xslt page. I have reverted back to the format in the meters.xslt example file and now hope that somebody can help!! metars.cache.xml meters.xslt ILR-99999999-1617-20160229-144401-01.xml ILRLearningDeliveryImport.xslt
  3. Hi everyone. Could someone help me? I am so close to having this working and we've spent the last two days trying everything, and we're stumped. We built this xslt template and it's associated xml file... and filemaker opens up like it's all good, allows me to map the fields, all good, then we hit import and it only does one file and there is no data in any of the fields. These two files are the short sanitized version of the data, the original xml has 600 records... but this is exactly the structure, and I'm wondering if anyone can tell us what we are missing.? Again, no data arrives in the record, and it only does one record even thou we have 600. (I know this one will only be a single record). Any guidance from the group would be so appreciated. Thanks. Steve.user-export-short.xslt SteveXML RecordShort.xml
  4. fmresultsetjson.xsl

    Version 1.0.0

    7 downloads

    XSLT to convert Filemaker's REST web-service XML response into clean JSON https://twitter.com/alantrewartha 2017-03-06 Adapted from the original Six Fried Rice XSLT here http://sixfriedrice.com/wp/products/filemaker-to-json-converter/ Changed: * single quotes to JSON-standard double-quotes * removed "fieldDefinitions" block (personal preference) * stopped every field value being presented as an [ array ] even when not a "repeating field" * added whitespace escaping code The white-space escaping code was entirely cribbed from https://github.com/doekman/xml2json-xslt/blob/master/xml2json.xsl

    Free

  5. View File fmresultsetjson.xsl XSLT to convert Filemaker's REST web-service XML response into clean JSON https://twitter.com/alantrewartha 2017-03-06 Adapted from the original Six Fried Rice XSLT here http://sixfriedrice.com/wp/products/filemaker-to-json-converter/ Changed: * single quotes to JSON-standard double-quotes * removed "fieldDefinitions" block (personal preference) * stopped every field value being presented as an [ array ] even when not a "repeating field" * added whitespace escaping code The white-space escaping code was entirely cribbed from https://github.com/doekman/xml2json-xslt/blob/master/xml2json.xsl Submitter AlanTrewartha Submitted 03/06/2017 Category Solutions FM Version FM Version: 0  
  6. fmpxmlresult2sitemap vice versa

    This is an XSLT stylesheet to convert from FileMaker's fmpxmlresult to sitemap and vice-versa. https://github.com/TyrfingMjolnir/fmpxmlresult2sitemap
  7. I have a xml export via XSLT working successfully to generate the correct XML file. I've noticed the XML file has no indenting which makes it hard to read - I was wondering if there's an easy way to include the indenting in the result xml file as part of the XSL file? Here's what the XML looks like now: <rss version="0.91"> <channel> <title>Latest News</title> <link>http://localhost/</link> <description>Recent news articles</description> <language>en-us</language> <item> <title>Slashdot</title> <link>http://slashdot.org/</link> <description>News for Nerds, stuff that matters</description> </item> </channel> </rss> I would like it to look like this: <rss version="0.91"> <channel> <title>Latest News</title> <link>http://localhost/</link> <description>Recent news articles</description> <language>en-us</language> <item> <title>Slashdot</title> <link>http://slashdot.org/</link> <description>News for Nerds, stuff that matters</description> </item> </channel> </rss> Here's what the XLS file looks like: <xsl:stylesheet xmlns:fmp="http://www.filemaker.com/fmpxmlresult" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.1" exclude-result-prefixes='fmp' > <xsl:output method="xml" doctype-public="rss" doctype-system="http://www.scripting.com/dtd/rss-0_91.dtd" version="1.0" encoding="UTF-8" indent="yes"/> <xsl:template match="fmp:FMPXMLRESULT"> <rss version="0.91"> <channel> <title>Latest News</title> <link>http://localhost/</link> <description>Recent news articles</description> <language>en-us</language> <xsl:for-each select="fmp:RESULTSET/fmp:ROW"> <item> <title><xsl:value-of select="fmp:COL[1]/fmp:DATA" /></title> <link><xsl:value-of select="fmp:COL[2]/fmp:DATA" /></link> <description><xsl:value-of select="fmp:COL[3]/fmp:DATA" /></description> </item> </xsl:for-each> </channel> </rss> </xsl:template> </xsl:stylesheet>
  8. XML to RDF using XSLT

    I am beginner to xml /rdf /xslt . I have an XML file and want to transform into RDF file using XSLT.i did not get the desired rdf format by xslt file. Please help me to improve my xslt file My XML file is <?xml version="1.0" encoding="utf-8" standalone="yes"?> <Events><Event xmlns='http://schemas.microsoft.com/win/2004/08/events/event'> <System> <Provider Name='Application Hang'/> <EventID Qualifiers='0'>1002</EventID> <Level>2</Level> <Task>101</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime='2015-08-08T09:47:28.000000000Z'/> <EventRecordID>3005</EventRecordID> <Channel>Application</Channel> <Computer>AAAA</Computer> <Security/> </System> <EventData> <Data>LiveComm.exe</Data> <Data>17.5.9600.20911</Data> <Data>bd4</Data> <Data>01d0d1be80c57fd9</Data> <Data>4294967295</Data> <Data>C:\Program Files\WindowsApps\microsoft.windowscommunicationsapps_17.5.9600.20911_x64__8wekyb3d8bbwe\LiveComm.exe</Data> <Data>7443f7db-3db2-11e5-8261-a45d36cd4a42</Data> <Data>microsoft.windowscommunicationsapps_17.5.9600.20911_x64__8wekyb3d8bbwe</Data> <Data>ppleae38af2e007f4358a809ac99a64a67c1</Data> <Binary>55006E006B006E006F0077006E0000000000</Binary> </EventData> </Event> My XSLT File is <xsl:transform version='1.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform'> <xsl:template match='Correlation'> <Correlation-patricia> <xsl:apply-templates /> </Correlation-patricia> </xsl:template> <xsl:template match='TimeCreated'> <TimeCreated-patricia> <xsl:apply-templates /> </TimeCreated-patricia> </xsl:template> <xsl:template match='Task'> <Task-patricia> <xsl:apply-templates /> </Task-patricia> </xsl:template> <xsl:template match='Keywords'> <Keywords-patricia> <xsl:apply-templates /> </Keywords-patricia> </xsl:template> <xsl:template match='ErrorCode'> <ErrorCode-patricia> <xsl:apply-templates /> </ErrorCode-patricia> </xsl:template> <xsl:template match='Provider'> <Provider-patricia> <xsl:apply-templates /> </Provider-patricia> </xsl:template> <xsl:template match='Opcode'> <Opcode-patricia> <xsl:apply-templates /> </Opcode-patricia> </xsl:template> <xsl:template match='ProcessingErrorData'> <ProcessingErrorData-patricia> <xsl:apply-templates /> </ProcessingErrorData-patricia> </xsl:template> <xsl:template match='DataItemName'> <DataItemName-patricia> <xsl:apply-templates /> </DataItemName-patricia> </xsl:template> <xsl:template match='System'> <System-patricia> <xsl:apply-templates /> </System-patricia> </xsl:template> <xsl:template match='Security'> <Security-patricia> <xsl:apply-templates /> </Security-patricia> </xsl:template> <xsl:template match='Event'> <Event-patricia> <xsl:apply-templates /> </Event-patricia> </xsl:template> <xsl:template match='Execution'> <Execution-patricia> <xsl:apply-templates /> </Execution-patricia> </xsl:template> <xsl:template match='EventID'> <EventID-patricia> <xsl:apply-templates /> </EventID-patricia> </xsl:template> <xsl:template match='Channel'> <Channel-patricia> <xsl:apply-templates /> </Channel-patricia> </xsl:template> <xsl:template match='Computer'> <Computer-patricia> <xsl:apply-templates /> </Computer-patricia> </xsl:template> <xsl:template match='EventData'> <EventData-patricia> <xsl:apply-templates /> </EventData-patricia> </xsl:template> <xsl:template match='Binary'> <Binary-patricia> <xsl:apply-templates /> </Binary-patricia> </xsl:template> <xsl:template match='Version'> <Version-patricia> <xsl:apply-templates /> </Version-patricia> </xsl:template> <xsl:template match='Level'> <Level-patricia> <xsl:apply-templates /> </Level-patricia> </xsl:template> <xsl:template match='EventRecordID'> <EventRecordID-patricia> <xsl:apply-templates /> </EventRecordID-patricia> </xsl:template> <xsl:template match='EventPayload'> <EventPayload-patricia> <xsl:apply-templates /> </EventPayload-patricia> </xsl:template> <xsl:template match='Events'> <Events-patricia> <xsl:apply-templates /> </Events-patricia> </xsl:template> <xsl:template match='Data'> <Data-patricia> <xsl:apply-templates /> </Data-patricia> </xsl:template> </xsl:transform>kindly help me to convert XML to RDF .....
  9. Hi everyone, I am new here. I just began working with a project that has been using FileMaker Server 9 and Pro 9. The current architecture uses one machine deployment but the machine is quite ancient and doesn't support any micro-frameworks that eases my web development duties. I wanted to split this architecture to a multi machine deployment this ancient machine having only the Database, another better machine having a webserver and/or a web publishing engine. The reasoning behind this being that I can use a webserver(Gunicorn + Flask) and use PyFileMaker to obtain my data from the DB using XML. I, however, realize that the web publishing engine is required at the database to publish my XML data which in turn requires a web server running(apache). This goes back to the same one machine deployment. Am I missing a point here? Thank you so much for taking your time to read this. It would be truly awesome if you could help me with this question. Thank you once again and have a good day. Regards, Arjun
  10. I've spent the last couple of days learning XML, XPath, XSLT trying to make this work. I feel like I am really close but something simple is off. My XSLT is not quiet right and I need some expert input. For testing I set it up to only pull in the first field. Once I have that right the rest should be easy. Below I have added the XML, XSL, and Transformed XML. You can see in the transformer portion that there is something off with my data. When trying to import into FM it just creates a blank record. I am trying to import the "Y" from the "BTK-security-complete" field. XML <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <CDETS xmlns="cdetsng" xmlns:ns2="http://www.w3.org/1999/xlink"> <Defect id="CSCsa8849" ns2:href="http://cdetsng.mydomain.com/wsapi/bug/CSCsa8849"> <Field name="BTK-security-complete">Y</Field> <Field name="Class">CSC.swtools</Field> <Field name="Component">other</Field> <Field name="DE-manager">bnado</Field> <Field name="Description">Lifecycle changes to Pre when a Obsolete concept moved under Pre Parent</Field> <Field name="Headline">Lifecycle changes to Pre when a Obsolete concept moved under Pre Parent</Field> <Field name="Identifier" ns2:href="http://cdetsng.mydomain.com/wsapi/bug/CSCsa8849">CSCsa8849</Field> <Field name="Is-customer-visible">N</Field> <AuditTrail id="Tue Apr 19 12:27:53 PDT 2005" defectID="CSCsa8849" ns2:href="http://cdetsng.mydomain.com/wsapi/bug/CSCsa8849/audittrail"> <Parent ns2:href="http://cdetsng.mydomain.com/wsapi/bug/CSCsa8849">CSCsa8849</Parent> <Field name="ChangedBy">ksahani</Field> <Field name="ChangedOn">04/19/2005 12:27:53</Field> <Field name="Field">Defect Created</Field> <Field name="Operation">New Record</Field> </AuditTrail> <Files> <File id="DDTS_History.txt" defectID="CSCsa8849" ns2:href="http://cdetsng.mydomain.com/wsapi/bug/CSCsa8849/file/DDTS_History.txt"> <Parent ns2:href="http://cdetsng.mydomain.com/wsapi/bug/CSCsa8849">CSCsa8849</Parent> <Field name="Extension">txt</Field> <Field name="FileSize">55</Field> <Field name="Filename">DDTS_History</Field> <Field name="UpdatedBy">cdetsync</Field> <Field name="UpdatedOn">01/22/2008 17:25:00</Field> </File> </Files> </Defect> </CDETS> XSL <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fmp="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="xsl fmp"> <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"> </xsl:output> <xsl:template match="/"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="10-18-2015" NAME="FileMaker" VERSION="ProAdvanced 14"/> <DATABASE DATEFORMAT="m.d.yyyy" LAYOUT="" NAME="" RECORDS="{count(/*/*)}" TIMEFORMAT="k:mm:ss "/> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="BTK-security-complete" TYPE="TEXT"/> </METADATA> <RESULTSET FOUND=""> <xsl:for-each select="/*/*"> <ROW MODID="0" xmlns="http://www.filemaker.com/fmpxmlresult"> <xsl:attribute name="RECORDID"> <xsl:value-of select="position()" /> </xsl:attribute> <COL> <DATA> <xsl:value-of select="//Field[@name='BTK-security-complete']" /> </DATA> </COL> </ROW> </xsl:for-each> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet> Transformed XML <?xml version="1.0" encoding="UTF-8"?> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT VERSION="ProAdvanced 14" NAME="FileMaker" BUILD="10-18-2015" /> <DATABASE TIMEFORMAT="h:mm:ss " RECORDS="1" NAME="" LAYOUT="" DATEFORMAT="m.d.yyyy" /> <METADATA> <FIELD TYPE="TEXT" NAME="BTK-security-complete" MAXREPEAT="1" EMPTYOK="YES" /> </METADATA> <RESULTSET FOUND=""> <ROW MODID="0" RECORDID="1"> <COL> <DATA /> </COL> </ROW> </RESULTSET> </FMPXMLRESULT>
  11. Hi! I have this persistant problem when I try to import my XLM data into filemaker. I use various XML inportations in my filemaker database and they all import perfect with the msdso_elem.xslt file, but not this xml type! I don't know what I'm doing wrong... I made this XSLT document, but when I try to import it, the actual record fields are empty!!! This is the XML document I would like to import: <Order url="https://api.fortnox.se/3/orders/3" urlTaxReductionList="https://api.fortnox.se/3/taxreductions?filter=orders&referencenumber=3"> <AdministrationFee>0</AdministrationFee> <AdministrationFeeVAT>0</AdministrationFeeVAT> <Address1>gurratheboy</Address1> <Address2>gurratheboy</Address2> <BasisTaxReduction>0</BasisTaxReduction> <Cancelled>false</Cancelled> <City>gurratheboy</City> <Comments/> <ContributionPercent>0</ContributionPercent> <ContributionValue>0</ContributionValue> <CopyRemarks>false</CopyRemarks> <Country>France</Country> <CostCenter/> <Currency>SEK</Currency> <CurrencyRate>1</CurrencyRate> <CurrencyUnit>1</CurrencyUnit> <CustomerName>gurratheboy</CustomerName> <CustomerNumber>2</CustomerNumber> <DeliveryAddress1/> <DeliveryAddress2/> <DeliveryCity/> <DeliveryCountry/> <DeliveryDate>2015-01-17</DeliveryDate> <DeliveryName/> <DeliveryZipCode/> <DocumentNumber>3</DocumentNumber> <EmailInformation>...</EmailInformation> <ExternalInvoiceReference1/> <ExternalInvoiceReference2/> <Freight>0</Freight> <FreightVAT>0</FreightVAT> <Gross>200</Gross> <HouseWork>false</HouseWork> <InvoiceReference>3</InvoiceReference> <Language>SV</Language> <Net>200</Net> <NotCompleted>false</NotCompleted> <OfferReference>0</OfferReference> <OrderDate>2015-01-17</OrderDate> <OrderRows> <OrderRow> <AccountNumber>3016</AccountNumber> <ArticleNumber>1</ArticleNumber> <ContributionPercent>0</ContributionPercent> <ContributionValue>0</ContributionValue> <CostCenter/> <DeliveredQuantity>1.00</DeliveredQuantity> <Description>Fortnox Bokföring</Description> <Discount>0</Discount> <DiscountType>PERCENT</DiscountType> <HouseWork>false</HouseWork> <OrderedQuantity>1.00</OrderedQuantity> <Price>100</Price> <Project/> <Total>100</Total> <Unit/> <VAT>25</VAT> </OrderRow> <OrderRow> <AccountNumber>3016</AccountNumber> <ArticleNumber>1</ArticleNumber> <ContributionPercent>0</ContributionPercent> <ContributionValue>0</ContributionValue> <CostCenter/> <DeliveredQuantity>1.00</DeliveredQuantity> <Description>Fortnox Bokföring</Description> <Discount>0</Discount> <DiscountType>PERCENT</DiscountType> <HouseWork>false</HouseWork> <OrderedQuantity>1.00</OrderedQuantity> <Price>100</Price> <Project/> <Total>100</Total> <Unit/> <VAT>25</VAT> </OrderRow> </OrderRows> <OrganisationNumber>gurratheboy</OrganisationNumber> <OurReference>API User</OurReference> <Phone1>gurratheboy</Phone1> <Phone2>gurratheboy</Phone2> <PriceList>A</PriceList> <PrintTemplate>oc</PrintTemplate> <Project>0</Project> <Remarks/> <RoundOff>0</RoundOff> <Sent>false</Sent> <TaxReduction/> <TermsOfDelivery/> <TermsOfPayment/> <Total>250</Total> <TotalToPay>250</TotalToPay> <TotalVAT>50</TotalVAT> <VATIncluded>false</VATIncluded> <WayOfDelivery/> <YourReference/> <YourOrderNumber/> <ZipCode>gurrathebo</ZipCode> </Order> This Is my XSLT document: <?xml version='1.0' encoding='UTF-8'?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <METADATA> <FIELD NAME="AccountNumber" TYPE="NUMBER"/> <FIELD NAME="Address1" TYPE="TEXT"/> <FIELD NAME="Address2" TYPE="TEXT"/> <FIELD NAME="AdministrationFee" TYPE="NUMBER"/> <FIELD NAME="AdministrationFeeVAT" TYPE="NUMBER"/> <FIELD NAME="BasisTaxReduction" TYPE="NUMBER"/> <FIELD NAME="Cancelled" TYPE="TEXT"/> <FIELD NAME="City" TYPE="TEXT"/> <FIELD NAME="Comments" TYPE="TEXT"/> <FIELD NAME="ContributionPercent" TYPE="NUMBER"/> <FIELD NAME="ContributionPercent1" TYPE="NUMBER"/> <FIELD NAME="ContributionValue" TYPE="NUMBER"/> <FIELD NAME="ContributionValue1" TYPE="NUMBER"/> <FIELD NAME="CopyRemarks" TYPE="TEXT"/> <FIELD NAME="CostCenter" TYPE="TEXT"/> <FIELD NAME="CostCenter1" TYPE="NUMBER"/> <FIELD NAME="Country" TYPE="NUMBER"/> <FIELD NAME="Currency" TYPE="TEXT"/> <FIELD NAME="CurrencyRate" TYPE="NUMBER"/> <FIELD NAME="CurrencyUnit" TYPE="NUMBER"/> <FIELD NAME="CustomerName" TYPE="TEXT"/> <FIELD NAME="CustomerNumber" TYPE="NUMBER"/> <FIELD NAME="DeliveredQuantity" TYPE="NUMBER"/> <FIELD NAME="DeliveryAddress1" TYPE="TEXT"/> <FIELD NAME="DeliveryAddress2" TYPE="TEXT"/> <FIELD NAME="DeliveryCity" TYPE="TEXT"/> <FIELD NAME="DeliveryCountry" TYPE="TEXT"/> <FIELD NAME="DeliveryDate" TYPE="TIME"/> <FIELD NAME="DeliveryName" TYPE="TEXT"/> <FIELD NAME="Description" TYPE="TEXT"/> <FIELD NAME="DiscountType" TYPE="TEXT"/> <FIELD NAME="DocumentNumber" TYPE="NUMBER"/> <FIELD NAME="EmailAddressBCC" TYPE="TEXT"/> <FIELD NAME="EmailAddressCC" TYPE="TEXT"/> <FIELD NAME="EmailAddressFrom" TYPE="TEXT"/> <FIELD NAME="EmailAddressTo" TYPE="TEXT"/> <FIELD NAME="EmailSubject" TYPE="TEXT"/> <FIELD NAME="ExternalInvoiceReference1" TYPE="TEXT"/> <FIELD NAME="ExternalInvoiceReference2" TYPE="TEXT"/> <FIELD NAME="Freight" TYPE="NUMBER"/> <FIELD NAME="FreightVAT" TYPE="NUMBER"/> <FIELD NAME="Gross" TYPE="NUMBER"/> <FIELD NAME="HouseWork" TYPE="TEXT"/> <FIELD NAME="HouseWork1" TYPE="TEXT"/> <FIELD NAME="InvoiceReference" TYPE="NUMBER"/> <FIELD NAME="Language" TYPE="TEXT"/> <FIELD NAME="Net" TYPE="NUMBER"/> <FIELD NAME="NotCompleted" TYPE="TEXT"/> <FIELD NAME="OfferReference" TYPE="NUMBER"/> <FIELD NAME="OrderDate" TYPE="DATE"/> <FIELD NAME="OrderedQuantity" TYPE="NUMBER"/> <FIELD NAME="OrderRow" TYPE="TEXT"/> <FIELD NAME="OrderRows" TYPE="TEXT"/> <FIELD NAME="OrganisationNumber" TYPE="NUMBER"/> <FIELD NAME="OurReference" TYPE="NUMBER"/> <FIELD NAME="Phone1" TYPE="TEXT"/> <FIELD NAME="Phone2" TYPE="TEXT"/> <FIELD NAME="Price" TYPE="NUMBER"/> <FIELD NAME="PriceList" TYPE="TEXT"/> <FIELD NAME="PrintTemplate" TYPE="TEXT"/> <FIELD NAME="Project" TYPE="NUMBER"/> <FIELD NAME="Project1" TYPE="TEXT"/> <FIELD NAME="Remarks" TYPE="TEXT"/> <FIELD NAME="RoundOff" TYPE="NUMBER"/> <FIELD NAME="Sent" TYPE="TEXT"/> <FIELD NAME="TaxReduction" TYPE="TEXT"/> <FIELD NAME="TermsOfDelivery" TYPE="TEXT"/> <FIELD NAME="TermsOfPayment" TYPE="NUMBER"/> <FIELD NAME="Total" TYPE="NUMBER"/> <FIELD NAME="Total1" TYPE="NUMBER"/> <FIELD NAME="TotalToPay" TYPE="NUMBER"/> <FIELD NAME="TotalVAT" TYPE="NUMBER"/> <FIELD NAME="Unit" TYPE="TEXT"/> <FIELD NAME="VAT" TYPE="NUMBER"/> <FIELD NAME="VATIncluded" TYPE="TEXT"/> <FIELD NAME="WayOfDelivery" TYPE="TEXT"/> <FIELD NAME="YourOrderNumber" TYPE="TEXT"/> <FIELD NAME="YourReference" TYPE="TEXT"/> <FIELD NAME="ZipCode" TYPE="TEXT"/> </METADATA> <RESULTSET> <ROW> <COL> <DATA><xsl:value-of select="Order/AdministrationFee/@value"/></DATA> </COL> <COL> <DATA><xsl:value-of select="order/AdministrationFeeVAT/@value"/></DATA> </COL> <COL> <DATA><xsl:value-of select="order/Address1/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="order/Adress2/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="order/BasisTaxReduction/@value"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> </ROW> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet> This is only one record, and my XSLT won't work! Can someone please help me and point out what I'm doing wrong? If you have a working XSLT document please share!! Thanks!
  12. Import XSL Issue

    I'm trying to import the following XML data: <?xml version="1.0" encoding="utf-8"?> <customers xmlns="http://acme.com/schema/v1_2/customers.xsd"> <customer ID="1"> <city>Monterey</city> <name>Herbson's Pices</name> <orders> <order ID="ORD2"> <num>1</num> <date>12-01-2002</date> <amount>23.54</amount> <items> <item> <productID>ABC123</productID> <quantity>1</quantity> <description>Oregano</description> <price>23.54</price> <extended>23.54</extended> </item> </items> </order> <order ID="ORD3"> <num>2</num> <date>01-06-2003</date> <amount>15.45</amount> <items> <item> <productID>23_45d</productID> <quantity>2</quantity> <description>Rosemary</description> <price>5.00</price> <extended>10.00</extended> </item> <item> <productID>t456</productID> <quantity>5</quantity> <description>Thyme</description> <price>1.09</price> <extended>5.45</extended> </item> </items> </order> </orders> </customer> <customer ID="2"> <city>New York</city> <name>A Pealing Desserts</name> <orders> <order ID="ORD4"> <num>1</num> <date>11-15-2002</date> <amount>115.00</amount> <items> <item> <productID>ABC123</productID> <quantity>5</quantity> <description>Lemon Zests</description> <price>23.00</price> <extended>115.00</extended> </item> </items> </order> </orders> </customer> </customers>I'm using the following XSLT: <?xml version="1.0" encoding="utf-8" ?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output version="1.0" encoding="UTF-8" indent="no" method="xml"/> <xsl:template match="/"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="11/13/2002" NAME="FileMaker Pro" VERSION="6.0v4"/> <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="Customers.FP5" RECORDS="" TIMEFORMAT="h:mm:ss a"/> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ID" TYPE="NUMBER"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Name" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="City" TYPE="TEXT"/> </METADATA> <RESULTSET FOUND=""> <xsl:for-each select="./customers/customer"> <ROW MODID="" RECORDID=""> <COL> <DATA> <xsl:value-of select="@ID"/> </DATA> </COL> <COL> <DATA> <xsl:value-of select="./name"/> </DATA> </COL> <COL> <DATA> <xsl:value-of select="./city"/> </DATA> </COL> </ROW> </xsl:for-each> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet> When I apply this stylesheet to the XML I'm not getting any data, i.e just this: <?xml version="1.0" encoding="utf-8"?> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT VERSION="6.0v4" NAME="FileMaker Pro" BUILD="11/13/2002"/> <DATABASE TIMEFORMAT="h:mm:ss a" RECORDS="" NAME="Customers.FP5" LAYOUT="" DATEFORMAT="M/d/yyyy"/> <METADATA> <FIELD TYPE="NUMBER" NAME="ID" MAXREPEAT="1" EMPTYOK="YES"/> <FIELD TYPE="TEXT" NAME="Name" MAXREPEAT="1" EMPTYOK="YES"/> <FIELD TYPE="TEXT" NAME="City" MAXREPEAT="1" EMPTYOK="YES"/> </METADATA> <RESULTSET FOUND=""/> </FMPXMLRESULT>I've noticed that if I change the 2nd line of the XML to just: <customers>it then transforms successfully and I can import it. I'd prefer not to have to manually change the XML - is there something I can do to the XSLT to allow it to work successfully. This is the result I'm expecting: <?xml version="1.0" encoding="utf-8"?> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT VERSION="6.0v4" NAME="FileMaker Pro" BUILD="11/13/2002"/> <DATABASE TIMEFORMAT="h:mm:ss a" RECORDS="" NAME="Customers.FP5" LAYOUT="" DATEFORMAT="M/d/yyyy"/> <METADATA> <FIELD TYPE="NUMBER" NAME="ID" MAXREPEAT="1" EMPTYOK="YES"/> <FIELD TYPE="TEXT" NAME="Name" MAXREPEAT="1" EMPTYOK="YES"/> <FIELD TYPE="TEXT" NAME="City" MAXREPEAT="1" EMPTYOK="YES"/> </METADATA> <RESULTSET FOUND=""> <ROW RECORDID="" MODID=""> <COL> <DATA>1</DATA> </COL> <COL> <DATA>Herbson's Pices</DATA> </COL> <COL> <DATA>Monterey</DATA> </COL> </ROW> <ROW RECORDID="" MODID=""> <COL> <DATA>2</DATA> </COL> <COL> <DATA>A Pealing Desserts</DATA> </COL> <COL> <DATA>New York</DATA> </COL> </ROW> </RESULTSET> </FMPXMLRESULT>Is there a way I can keep the raw XML as is but modify the XSL somehow to import successfully just as it does when I remove the: xmlns="http://acme.com/schema/v1_2/customers.xsd"string?
  13. Hi, I have optical store and I made Filemaker database to manage inventory of optical frames and lenses. Now I want to implement fiscal printer into same database so I can print receipts directly. Fiscal printer read xml files but files needs to be in some particular format, Filemaker does not export it that way. So I will attach two files, One is example of what it should look like to be readable by printer and the other one is example of how file maker export it from my database. This is sample what is what: DATA BCR= Sifra Proizvoda VAT= PDV stopa PRC= MPC AMN= Kolicina Could someone help me write xslt file so I can export it the right way??? Thank you RCP_104300.XMLUntitled.xml
  14. http://bluefeathergroup.com/blog/importing-xml-data-into-filemaker-using-xslt-xsl-style-sheets/ I've written a new post about how to create XSL Style Sheets so that you can import data from XML data sources into FileMaker. Please let me know if you have any comments.
  15. [Edit: added xslt example] Hi all, Given I have an xml like this: <row1> <node1>text1</node1> <node2>text2</node2> <node3>text3</node3> </row1> <row2> <node1>text4</node1> <node3>text5</node3> </row2> Where node1..n are matched to fields 1..n accordingly, how do I force the xml-import to create an empty field2 at second row instead of putting the value of node3 into it? I have tried constructs like this: <xsl:choose> <xsl:when test="(/results/issues/issue/coverDate) or (not(/results/issues/issue/coverDate))"> <xsl:for-each select="coverDate"> <COL> <DATA> <xsl:value-of select="."/> </DATA> </COL> </xsl:for-each> </xsl:when> <xsl:when test="not(/results/issues/issue/coverDate)"> <COL> <DATA> </DATA> </COL> </xsl:when> </xsl:choose> But this doesn't seem to work. At least it didn't throw any errors but a nonexistent 'coverDate' will drag the data from the next xml element into the 'coverDate' Field in FM. TiA, demski
  16. Importing 2 sections XSLT

    Below I have pasted my XML and below it my XSLT, I am new to XSLT and hope that I am close to fixing my problem. When importing to filemaker, only the first 3 fields are importing, how do I get all of the fields to import? <Meta> <Attribution Url="http://www.this.org">Content provided byThis</Attribution> <ContentType>Article</ContentType> <CopyrightOwner DocID="This Copyright">2ff58aea-95</CopyrightOwner> <DocID>ART-2004</DocID> <UpdateDate>2013-03-27</UpdateDate> <PublicationDate>2013-03-27</PublicationDate> <ControlWords> <Category MCVID="1898" Title="Pregnancy week by week"> <Keyword MCVID="1550" Title="Healthy pregnancy"/> </Category> <Category MCVID="1124" Title="Adult"> <Keyword MCVID="1126" Title="45 to 64 middle"/> </Category> </ControlWords> </Meta> <Body> <Section> <HTML><p> Pregnancy can take a toll on your body. But as much as you need sleep during pregnancy, it doesn't always come easily. Understand how pregnancy affects sleep and what you can do to rest comfortably. </p> </HTML> </Section> <Section> <SectionHead>Why does pregnancy cause fatigue?</SectionHead> <HTML><p> During early pregnancy, levels of the hormone progesterone soar and your metabolism is running high. This can make you feel exhausted. At the same time, lower blood pressure and increased blood production might team up to sap your energy. If you have another child or children to care for, you might experience even more fatigue. </p> <p> While fatigue typically lessens after the first trimester, you'll likely feel tired again toward the end of your pregnancy as your baby increases in size. </p> </HTML> </Section> </Body> <Title>Sleep during pregnancy: Follow these tips</Title> <BenefitSummary>Having a hard time getting sleep during pregnancy? Understand why you're feeling fatigued and strategies for minimizing discomfort and sleep disturbances.</BenefitSummary> <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" exclude-result-prefixes="xsl"> <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="FileMaker" VERSION="ProAdvanced 12.0v2"/> <DATABASE DATEFORMAT="" LAYOUT="" NAME="" RECORDS="" TIMEFORMAT=""/> <METADATA> <!-- FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Meta" TYPE="TEXT" / --> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="DocID" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="UpdateDate" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="PublicationDate" TYPE="TEXT" /> <!-- FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Section" TYPE="TEXT" / --> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="SectionHead" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="HTML" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Title" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="BenefitSummary" TYPE="TEXT" /> </METADATA> <RESULTSET FOUND=""> <xsl:for-each select="//Meta"> <ROW RECORDID="" MODID="" > <COL><DATA><xsl:value-of select="DocID"/></DATA></COL> <COL><DATA><xsl:value-of select="UpdateDate"/></DATA></COL> <COL><DATA><xsl:value-of select="PublicationDate"/></DATA></COL> </ROW> </xsl:for-each> <xsl:for-each select="//Body/Section"> <ROW RECORDID="" MODID="" > <COL><DATA><xsl:value-of select="SectionHead"/></DATA></COL> <COL><DATA><xsl:value-of select="HTML"/></DATA></COL> </ROW> </xsl:for-each> <xsl:for-each select="Record"> <ROW MODID="" RECORDID=""> <COL><DATA><xsl:value-of select="Title" /></DATA></COL> <COL><DATA><xsl:value-of select="BenefitSummary" /></DATA></COL> </ROW> </xsl:for-each> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet>
  17. This may not be the best way to do this OR describe the issue ....... but I feel like I'm ever so close. I can almost get the output but I have one section coming in as blank. Also I'm sorry for the length of this post. Just trying to give all the needed data .................... I hope. I'm exporting 4 records with 4 fields ... but only using 3 fields per line in the exported file.. (Posted at the bottom is an example of the FM export data) My desired output is a tab delim. text file with headers such as this : sku id status Parent-SKU1 0123456789 Update Parent-SKU2 0123456789 Update Child-SKU1 0123456789 Update Child-SKU2 0123456789 Update Child-SKU3 0123456789 Update Child-SKU4 0123456789 Update Notice that there 2 unique Parent-SKUs : Parent-SKU1 Parent-SKU2 (these are in COL[1] for each row) and 4 unigue Child-SKUs : Child-SKU1 Child-SKU2 Child-SKU3 Child-SKU4 (these are in COL[2] for each row) I'm using this .... within the stylesheet : <xsl:template match="/"> <!-- Header line, inserted only once per record set --> <xsl:text>sku id status</xsl:text> <!-- End of Header --> <!-- Begin Parent SKUs --> <xsl:for-each select="xalan:distinct(fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW/fmp:COL[1]/fmp:DATA)"> <xsl:attribute name="(fmp:COL[1]/fmp:DATA)"><xsl:value-of select="current()"/></xsl:attribute> <xsl:value-of select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW/fmp:COL[1]/fmp:DATA"/><xsl:text> </xsl:text><xsl:value-of select="fmp:ROW/fmp:COL[3]/fmp:DATA"/><xsl:text> </xsl:text><xsl:value-of select="fmp:ROW/fmp:COL[4]/fmp:DATA"/><xsl:value-of select="$newrecord"/> <xsl:attribute name="(fmp:COL[1]/fmp:DATA)"><xsl:value-of select="fmp:COL[1]/fmp:DATA"/></xsl:attribute> </xsl:for-each> <!-- Begin Child SKUs --> <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <xsl:value-of select="fmp:COL[2]/fmp:DATA"/><xsl:text> </xsl:text><xsl:value-of select="fmp:COL[3]/fmp:DATA"/><xsl:text> </xsl:text><xsl:value-of select="fmp:COL[4]/fmp:DATA"/><xsl:value-of select="$newrecord"/> </xsl:for-each> </xsl:template> <xsl:variable name="newrecord"><xsl:text> </xsl:text> </xsl:variable> ........ AND I'm getting : sku id status Child-SKU1 0123456789 Update Child-SKU2 0123456789 Update Child-SKU3 0123456789 Update Child-SKU4 0123456789 Update As you can see I get the 2 lines in there but not the DATA (and it does include the spacing between each export field) I've tried all kinds of variations on the 'distinct' section .... since I feel sure that's where the error is ..... trying to pull the data in but I can't seem to figure it out. FM export example data is : <FMPXMLRESULT> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="06-18-2009" NAME="FileMaker" VERSION="ProAdvanced 10.0v3"/> <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="SSP_Variations_1_3 BU.fp7" RECORDS="6" TIMEFORMAT="h:mm:ss a"/> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="SKU-Parent" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="SKU-Child" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="id" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="status" TYPE="TEXT"/> </METADATA> <RESULTSET FOUND="6"> <ROW MODID="61" RECORDID="83"> <COL> <DATA>Parent-SKU1</DATA> </COL> <COL> <DATA>Child-SKU1</DATA> </COL> <COL> <DATA>1234567890</DATA> </COL> <COL> <DATA>Update</DATA> </COL> </ROW> <ROW MODID="36" RECORDID="84"> <COL> <DATA>Parent-SKU1</DATA> </COL> <COL> <DATA>Child-SKU2</DATA> </COL> <COL> <DATA>1234567890</DATA> </COL> <COL> <DATA>Update</DATA> </COL> </ROW> <ROW MODID="29" RECORDID="85"> <COL> <DATA>Parent-SKU2</DATA> </COL> <COL> <DATA>Child-SKU3</DATA> </COL> <COL> <DATA>1234567890</DATA> </COL> <COL> <DATA>Update</DATA> </COL> </ROW> <ROW MODID="21" RECORDID="86"> <COL> <DATA>Parent-SKU2</DATA> </COL> <COL> <DATA>Child-SKU4</DATA> </COL> <COL> <DATA>1234567890</DATA> </COL> <COL> <DATA>Update</DATA> </COL> </ROW> </RESULTSET> </FMPXMLRESULT> I'm sure I've left out something, am going about this wrong or not explained this well enough but here it is ..... ALL help is appreciated !!
  18. Hello guys, I have a big problem importing data from a xml file to my FM database. I have a XML file that is given from a provider and it doesn't have the structure of my FM database (find attached a example of the XML file). I've created a XSL file to catch some data from the XML (find attached a example of the XSL file) but when I start to import data it doesn't works and I don't get any errors or messages. In the other hand, I think I'm able to do the XSL for the header ("cabecera" in spanish) of the XML file but I'm lost with the rest of the file. Could someone help me? Thanks in advance and sorry for my english. alcanzia.ziptest.xml
  19. So this may be a novice problem but I don't have enough experience yet to know how to do it using a Filemaker script. If I can't do it using a FM script can I call program in another language from a FM script that can do it. I don't have control over what is installed on the computers our software is run on so I'd like to do it without having to install yet another piece of software to make it work. I need to take the XML created by FM Export and convert it into another XML file and save it to a specific location on the local computer. I want to do this by taking the XML created by the FM Export execute an XSLT file on it and get a different XML file as output then save it. This XML file will then be used to transfer data onto a piece of hardware attached to the computer using another interface. Most of our customers run Filemaker Pro NOT Filemaker Server. Thanks for your help!
  20. I'm attempting to import a single XML record set (see attachment)XML_In.bmp. I've tried using the example XSLT provided by FM msdso_elem.xslt.txtwhich works fine for records that have even the simplest hierarchy. If I add another layer to the incoming XML , for example, AccountRecord like this: <Account> <AccountRecord> <AvailableCashBalance> . etc. . . </AccountRecord> </Account> then the sample XSLT works fine. The XML stream that I get form HTTPS however does not have this kind of hierarchy; I'm always given the structure that you see in the attachment. My question is how should the sample XSLT (also attached)msdso_elem.xslt.txt be modified to handle this XML? Or if you have an alternative XSLT coding I would use that. This is my first experience in XSLT thus this may seem rather elementary. Thanks for your understanding and help. Unc
  21. XML-Dokument in FileMaker importieren

    Hallo, ich habe leider noch absolut keine Erfahrung mit FileMaker, müsste aber dringend ein XML-Dokument importieren. Mittlerweile weiß ich, dass ich dies erst mit XSLT in ein bestimmtes Format transformieren muss. Habe mir auch die Beispiele die FileMaker mitbringt angeguckt. So richtig weiter komme ich leider trotzdem nicht, da ich auch mit XSLT noch nicht ganz soviel zu tun hatte. Zum einem würde ich gerne mal Wissen für was jeweils die einzelnen XML-Templates in der *.xslt sind? Zum anderen, kennt jemand einen guten XSLT Online Parser? Hab mal versucht die Beispiele mit den jeweils einzelnen Templates zu parsen. Aber irgendwie kommt da nichts brauchbares raus!?! Und zu guter Letzt hätte ich das XML-File im Anhang: Ich würde mich freuen wenn mir jemand weiterhelfen könnte und bedanke mich im Voraus! Martin test.xml
  22. I am doing XML exports from multiple tables and the resulting XML is working well when I concatenate the XML data into a single file. I have done a lot of reading here about exporting related tables from grandchild to parent and vice versa and it gets a bit over my head fairly quickly. Given where I'm at right now, it seems most efficient to use document() to combine these XML exports via XSLT but I haven't found any examples of how to do that. Could anyone share a simple example of that using FMPXMLRESULT? Thanks.
  23. I am attempting to import records from an XML feed formated like this (the sample is showing 2 records based on the <ItemOut> element): <?xml version='1.0' encoding='UTF-8'?> <ItemFeedResponse> <Feed> <Source type="list">6948232</Source> <PageSize>50</PageSize> <Offset>0</Offset> </Feed> <FeedResult feedSize="1198"> <ItemOut valid="true"> <ItemId>01661918</ItemId> <ItemAvailability> <ItemStatus code="SH" available="true"/> <ItemStock code="I"> <Description>Alternate</Description> </ItemStock> <ItemUom units="EA" per="1"> <QuantityAvailable>0.0</QuantityAvailable> </ItemUom> </ItemAvailability> <ItemDetail> <Description>CATH IC LTX 18FR 30CC 2W 12EA/CS BARD MEDIC</Description> <SupplierId>01661918</SupplierId> <ManufacturerId>0166SI18</ManufacturerId> <ManufacturerName>BARD MEDIC</ManufacturerName> <Classification domain="UNSPSC">42000000</Classification> <Category id="019" type="Major">Urologicals</Category> <Category id="026" type="Minor">Indwell Cath Specialty</Category> </ItemDetail> <ItemExtra> <ItemDescription>Urethral Catheter The Bardex I.C. 2-Way Foley, Standard Tip 18 Fr. Latex, Silver Alloy Coated</ItemDescription> <ItemImage>1169_016614_2.jpg</ItemImage> <ItemAttribute name="Application">Urethral Catheter</ItemAttribute> <ItemAttribute name="French Size">18 Fr.</ItemAttribute> <ItemAttribute name="Material">Latex, Silver Alloy Coated</ItemAttribute> <ItemAttribute name="Securing Method">30 cc Balloon</ItemAttribute> <ItemAttribute name="Sterility">Sterile</ItemAttribute> <ItemAttribute name="Style">2-Way Foley, Standard Tip</ItemAttribute> </ItemExtra> </ItemOut> <ItemOut valid="true"> <ItemId>06101900</ItemId> <ItemAvailability> <ItemStatus code="SH" available="true"/> <ItemStock code="I"> <Description>Alternate</Description> </ItemStock> <ItemUom units="EA" per="1"> <QuantityAvailable>0.0</QuantityAvailable> </ItemUom> </ItemAvailability> <ItemDetail> <Description>CATH URETH VNL STP 10FR 100EA/CS KENDALL CO</Description> <SupplierId>06101900</SupplierId> <ManufacturerId>400610</ManufacturerId> <ManufacturerName>KENDALL CO</ManufacturerName> <Classification domain="UNSPSC">42000000</Classification> <Category id="019" type="Major">Urologicals</Category> <Category id="031" type="Minor">Intermit Cath Strght Tip</Category> </ItemDetail> <ItemExtra> <ItemDescription>Intermittent Catheter Robinson, 2 Staggered Eyes Vinyl 10 Fr.</ItemDescription> <ItemImage>166869_PC.jpg</ItemImage> <ItemAttribute name="Application">Intermittent Catheter</ItemAttribute> <ItemAttribute name="French Size">10 Fr.</ItemAttribute> <ItemAttribute name="Gender">Unisex</ItemAttribute> <ItemAttribute name="HCPCS">A4351</ItemAttribute> <ItemAttribute name="Material">Vinyl</ItemAttribute> <ItemAttribute name="Sterility">Sterile</ItemAttribute> <ItemAttribute name="Style">Robinson, 2 Staggered Eyes</ItemAttribute> <ItemAttribute name="Usage">Disposable</ItemAttribute> <ItemAttribute name="User">Adult</ItemAttribute> <ItemFeature>This product is required to be reported under California Proposition 65</ItemFeature> </ItemExtra> </ItemOut> </FeedResult> </ItemFeedResponse> I am using the following XSLT: <?xml version='1.0' encoding='UTF-8' ?> <xsl:stylesheet version='1.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform'> <xsl:output version='1.0' encoding='UTF-8' indent='no' method='xml' /> <xsl:template match='/'> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="" NAME="" VERSION= ""/> <DATABASE DATEFORMAT="" LAYOUT="" NAME="" RECORDS="" TIMEFORMAT=""/> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="itemID" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="statusCode" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="available" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="stockCode" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="stockDescription" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="uomUnits" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="uomPer" TYPE="NUMBER"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="quantityAvailable" TYPE="NUMBER"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="description" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="supplierID" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="manufacturerID" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="manufacturerName" TYPE="TEXT"/> </METADATA> <RESULTSET FOUND=""> <xsl:for-each select="ItemFeedResponse/FeedResult/ItemOut"> <ROW MODID="" RECORDID=""> <COL><DATA><xsl:value-of select="./ItemId" /></DATA></COL> <COL><DATA><xsl:value-of select="./ItemAvailability/ItemStatus/@code" /></DATA></COL> <COL><DATA><xsl:value-of select="./ItemAvailability/ItemStatus/@available" /></DATA></COL> <COL><DATA><xsl:value-of select="./ItemAvailability/ItemStock/@code" /></DATA></COL> <COL><DATA><xsl:value-of select="./ItemAvailability/ItemStock/Description" /></DATA></COL> <COL><DATA><xsl:value-of select="./ItemAvailability/ItemUom/@units" /></DATA></COL> <COL><DATA><xsl:value-of select="./ItemAvailability/ItemUom/@per" /></DATA></COL> <COL><DATA><xsl:value-of select="./ItemAvailability/ItemUom/QuantityAvailable" /></DATA></COL> <COL><DATA><xsl:value-of select="./ItemDetail/Description" /></DATA></COL> <COL><DATA><xsl:value-of select="./ItemDetail/SupplierId" /></DATA></COL> <COL><DATA><xsl:value-of select="./ItemDetail/ManufacturerId" /></DATA></COL> <COL><DATA><xsl:value-of select="./ItemDetail/ManufacturerName" /></DATA></COL> </ROW> </xsl:for-each> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet> When I perform the import I don't get any errors, the field names show up correctly in the import dialogue, but there are no records to be imported. Basically it's importing a found set of "0". My gut is telling me it's because I have the "xsl:for-each select" value formatted incorrectly, but I'm not sure. Any help is appreciated.
×

Important Information

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