Jump to content

Gurratheboy

Newbies
  • Content Count

    7
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Gurratheboy

  • Rank
    newbie
  1. So I could buy one high end server machine, and install several instances of Filemaker server on it, one FMS instance for each client ? The client's could also access their own Admin-Console or would the networking mess up any portforwarding?
  2. Hi Guys, I'm stuck to say I wonder if it has with brain power to do... Table "Pencils" fields: ---------------------------------------- State Text | Has one of two values: "Activated" or "Deactivated" Brand Text |Can be one out of many brands...... Pricetag Numerical |the price of each pencil Sum_Pricetags_samebranded_and_activated pencils Calculation |????? This is what I can't figure out for the last calculation field in the table "Pencils", How do I make a calculation out of the following: In the calculation I want the Pencils from the same brand and with the same state "Activated" have their pricetags summed up and only if the two conditions are met. Example: 2 pencils are of same brand and they are both in the state "Activated". The one pencil have a pricetag of 18£ and the second one have a pricetag of 10£ Because they are of same brand and both have the same state, I want their price to sum up, 18+10=28£ It does not matter what the field say if the conditions are not met for other records, the field then can stay blank. Cheers
  3. Gurratheboy

    XSLT won't work with my XML file!

    Hi It's me again I found a solution to the problem and it now works perfectly. I choose to make two imports. First all records then a second import for details in each created record. This I made via a script. Here is my functional stylesheet: <?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="DocumentNumber" TYPE="NUMBER"/> <FIELD NAME="CustomerNumber" TYPE="NUMBER"/> <FIELD NAME="AccountNumber" TYPE="NUMBER"/> <FIELD NAME="ArticleNumber" TYPE="NUMBER"/> <FIELD NAME="ContributionPercent" TYPE="NUMBER"/> <FIELD NAME="ContributionValue" TYPE="NUMBER"/> <FIELD NAME="CostCenter" TYPE="NUMBER"/> <FIELD NAME="DeliveredQuantity" TYPE="NUMBER"/> <FIELD NAME="Description" TYPE="TEXT"/> <FIELD NAME="Discount" TYPE="NUMBER"/> <FIELD NAME="DiscountType" TYPE="TEXT"/> <FIELD NAME="HouseWork" TYPE="NUMBER"/> <FIELD NAME="HouseWorkHoursToReport" TYPE="NUMBER"/> <FIELD NAME="HouseWorkType" TYPE="NUMBER"/> <FIELD NAME="OrderedQuantity" TYPE="NUMBER"/> <FIELD NAME="Price" TYPE="NUMBER"/> <FIELD NAME="Project" TYPE="NUMBER"/> <FIELD NAME="Total" TYPE="NUMBER"/> <FIELD NAME="Unit" TYPE="TEXT"/> <FIELD NAME="VAT" TYPE="NUMBER"/> </METADATA> <RESULTSET> <xsl:variable name="DocumentNumber" select="Order/DocumentNumber"> </xsl:variable> <xsl:variable name="CustomerNumber" select="Order/CustomerNumber"> </xsl:variable> <xsl:for-each select="Order/OrderRows/OrderRow"> <ROW> <COL> <DATA><xsl:copy-of select="$DocumentNumber"/></DATA> </COL> <COL> <DATA><xsl:copy-of select="$CustomerNumber"/></DATA> </COL> <COL> <DATA><xsl:value-of select="AccountNumber"/></DATA> </COL> <COL> <DATA><xsl:value-of select="ArticleNumber"/></DATA> </COL> <COL> <DATA><xsl:value-of select="ContributionPercent"/></DATA> </COL> <COL> <DATA><xsl:value-of select="ContributionValue"/></DATA> </COL> <COL> <DATA><xsl:value-of select="CostCenter"/></DATA> </COL> <COL> <DATA><xsl:value-of select="DeliveredQuantity"/></DATA> </COL> <COL> <DATA><xsl:value-of select="Description"/></DATA> </COL> <COL> <DATA><xsl:value-of select="Discount"/></DATA> </COL> <COL> <DATA><xsl:value-of select="DiscountType"/></DATA> </COL> <COL> <DATA><xsl:value-of select="HouseWork"/></DATA> </COL> <COL> <DATA><xsl:value-of select="@HouseWorkHoursToReport"/></DATA> </COL> <COL> <DATA><xsl:value-of select="@HouseWorkType"/></DATA> </COL> <COL> <DATA><xsl:value-of select="OrderedQuantity"/></DATA> </COL> <COL> <DATA><xsl:value-of select="Price"/></DATA> </COL> <COL> <DATA><xsl:value-of select="Project"/></DATA> </COL> <COL> <DATA><xsl:value-of select="Total"/></DATA> </COL> <COL> <DATA><xsl:value-of select="Unit"/></DATA> </COL> <COL> <DATA><xsl:value-of select="VAT"/></DATA> </COL> </ROW> </xsl:for-each> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet>
  4. Gurratheboy

    XSLT won't work with my XML file!

    I would Give the two child records the same ID nummber and filter them true a Portal I think
  5. Gurratheboy

    XSLT won't work with my XML file!

    Yes, I would like to import one record with all child data
  6. Gurratheboy

    XSLT won't work with my XML file!

    I added the <?xml... statement and Put a capital O to orders. I Also added the ;amp. but this didn't change the problems I havme when I try to iport the data. The code is accepted by filemaker it seems, and I get to the Import Field Mapping but there's no records, only Field Names..... I don't know what I'm doing wrong. Does it have something todo with Child mapping???
  7. 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!
×

Important Information

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