Jump to content

Search the Community

Showing results for tags 'importing'.



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
  • Productive Computing Support Forums
    • Visit Productive Computing
    • General Discussion for Productive Computing Products
    • Core CRM Solutions
    • QuickBooks and Accounting Plug-ins
    • Contact and Calendar Management Plug-ins
    • FileMaker Utility Plug-ins
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • 360Deploy
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FM Forums Affiliate Sponsors
    • Monkey Bread Software (MBS Plugin)
    • SyncServer Pro by LinearBlue
    • ISO FileMaker Magazine
    • Open Source Frameworks
    • FileMaker Plug-Ins
    • User Group Central - Sponsored by FMPug.com
  • 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
  • 1-more-blog
  • Productive Computing

Categories

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

Found 22 results

  1. Hello, We have a solution to store pictures(JPEG and NEF) from a photographer. I am trying to mass import the raw files(.NEF) into containers but I have an error message saying 'This file could not be translated using the selected file type'. It is possible to drag and drop or File->Insert the file into the container directly but I can't import them from the folder. Is this impossible to import files from folder with extensions other than the basic ones? (jpeg, pdf, jpg, png etc) Thanks!
  2. I have a script to import an Excel file into an FM Table. I have my FM Script setup to Import Records with Arrange by: LAST ORDER. But it won't do this. Every time I run this script it gets the field mappings wrong. Reverts them back to before. Ironically when I do it manually it works. Any ideas? (I have this type of scripted import working fine for other tables) (I tried shifting the order of the fields in the actual database table as well -- but that has no effect either.)
  3. I am trying to open my (local) FM 14 Pro file [which has an auto-exec "Import Script"] but the script needs a variable file name. How do I pass this variable file name into Filemaker at 1) the time of the file open or 2) at the time of running the script (if I switch to manual execution)? Is #1 by using the fmp:// syntax from a web browser external to FM? (or is that syntax just for use when invoked from INSIDE a FM file?)
  4. Rebook

    I have an accommodations/ticket order database. I would like to setup a rebooking system where a person could rebook in advance their accommodation/ticket package for the next year. I duplicated the database and named it REBOOK. The problem I am having is that if there is a change in their order in REBOOK and want to update information in the order form, it does not update when I import the changed info. Any thoughts Basically what I want to do is add an updated order. There are two related tables - KB 16 & ticketOrd. (See attached) T
  5. Environment: Windows 7 with FileMaker Pro 14. I have a test database that I am currently making changes to. I saved the test database as a clone, so that I could test importing data back into it. the Import functions allows me to import the first table of information just fine, but it will not let me import any other tables. On any subsequent import, I can select the source table from my source file, but all of the target files are grayed out, except for the first file to which I was able to import into. What am I doing wrong? I will need to do this on a regular basis, as I will use this technique to move my changes into the live environment. Thanks, Linda
  6. I need some help importing a RSS 2.0 XML into FileMaker Pro Adv 10. I'm trying to modify a xslt file that came with FM. When I use this xslt it tries to map the parent Recipients and not the child Recipient. I'm stuck and could use a hand. Any thoughts on what to modify or add would be much appreciated? Here is the xlst: <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <!-- File: msdso_elem.xslt Transforms data in an ELEMENT based MSDSO grammar into the FMPXMLRESULT grammar, suitable for import. =============================================================== Copyright © 2002 FileMaker, Inc. All rights reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: * Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. * Neither the name of the FileMaker, Inc. nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission. THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. =============================================================== --> <xsl:template match="/*"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="" NAME="" VERSION=""/> <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="" RECORDS="{count(/*/*)}" TIMEFORMAT="h:mm:ss a"/> <METADATA> <xsl:for-each select="/*/*[position()=1]/*"> <FIELD> <xsl:attribute name="EMPTYOK">YES</xsl:attribute> <xsl:attribute name="MAXREPEAT">1</xsl:attribute> <xsl:attribute name="NAME"><xsl:value-of select="name()"/></xsl:attribute> <xsl:attribute name="TYPE">TEXT</xsl:attribute> </FIELD> </xsl:for-each> </METADATA> <RESULTSET> <xsl:attribute name="FOUND"><xsl:value-of select="count(child::*)"/></xsl:attribute> <xsl:for-each select="child::*"> <ROW> <xsl:attribute name="MODID">0</xsl:attribute> <xsl:attribute name="RECORDID">0</xsl:attribute> <xsl:for-each select="child::*"> <COL> <DATA> <xsl:value-of select="."/> </DATA> </COL> </xsl:for-each> </ROW> </xsl:for-each> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet> Here is the XML: <?xml version="1.0" encoding="utf-8"?> <rss version="2.0"> <Recipients> <Recipient> <First_name>Adam</First_name> <Last_name>Smith</Last_name> <Address1>123 main street</Address1> <Address2 /> <City>Lakewood ranch</City> <State>NY</State> <Zip>10012</Zip> <Country>USA</Country> <Cust_Phone>941-555-1212</Cust_Phone> <Company_name /> <L_num>Z3116-01</L_num> <Qty>50</Qty> <Promo>G147571</Promo> <Toll_num>1-888-238-0030</Toll_num> <email>sample@aol.com</email> <email2>bobjones@adt.com</email2> <repName /> <repPhone /> <CustomText>Adam Smith</CustomText> <IntOrderId>230839</IntOrderId> <OrderDateTime>2015-10-07 14:26:44</OrderDateTime> </Recipient> </Recipients> </rss>
  7. Hi, I'm working on a Database that has a lot of calculation and sub-summary. Everything works fine when I'm on the LAN, but when I tried to test it remotely, pulling up a summary report is really really slow because of the Calculation Fields, sorting and sub summary. So, I was thinking and read about creating a Dummy Table to dump all the records from the actual table with the calculation into a Table to store the calculated value as stored text or numbers. However, I'm having difficulty creating a script that will be run every evening. I've tried using an Export and Import, but the field value does not correspond with the original table fields. Whats the best of of doing this? Thanks.
  8. Hello everyone, I have been working on this for many weeks and unfortunately the newest road block has me stumped. Thank you in advance for any help you can give me. I have 4 text fields in my Event/Guest table: GuestNames, FoodRequest, SitWith and SpecialAccess. For the first time, I am importing this information from an excel spreadsheet downloaded from a vendor. Unfortunately, all 4 questions and their answers are combined into one field, so the imported cell looks like this: If you have purchased tickets for others, please list their names for check in and name tag purposes.: John Doe, Mary Smith | Are there any food allergies?: No | Who would you like to sit with at lunch?: Mary Doe | Do you have any special accessibility needs?: No I have defined some calculation fields to parse the start and end of the questions/answers and it works--as long as the user answers every question. If the guest does NOT answer a question, nothing is sent in that place. This means that the placement of the question/answers is not predictable. Nor is the text that starts at the next question in the line. In an attempt to solve this complication, I have created another calculation field that takes the entire blurb and substitutes a carriage return for each "|", making it a value list. I can search for the text string that is applicable, but how do I retrieve the value of the whole line? If I could do that, I could trim the question off and have my text answer for each of the fields I need. There may be a better way to do it, and I'm open to suggestions. Thank you again!
  9. 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!
  10. Hello All, I have a file with shipment information that I need to import into separate tables, a shipment name/id table and a shipment line items table. The problem is it is formatted in a way that the shipment name/id is located in column 2, row 1. The shipment line item information starts at row 9 and but the number of subsequent lines vary with each shipment. I’m not sure how to go about writing a script to create a new shipment in the shipment table using the value from column 2/row 1, then create child records in the shipment line items table with the values starting at row 9. I have written a couple executeSQL calculations that gather the shipment name and line item information I need but I can’t figure out how to use the data from the executeSQL calc to create the shipment line items records. Is there a better way to do this? Any help and/or suggestion would be very much appreciated!
  11. Greetings! I have what I hope is a very easy problem to solve. I have a runtime that imports data from another runtime file. Everything works fine as long as the other file is closed. I have had users who have run the import while the other file is open and the script completes but obviously nothing gets imported because the other file is currently locked. Before running the import script, I would like to test to see if the other file is closed. Is there an easy way to do this? Some calculation that I can test against? etc. Any thoughts would be helpful!! Thanks! Stephen
  12. I'm having a problem I hope someone can help me with. I need to import a csv file on a daily basis that gets deposited on an FTP site. Problem is, FMP12 (my current version) does not easily allow for import of csv files in a cloud hosted application. I need to define a file path in order for the import process to work, but cannot find an easy solution to accomplish this. Any help would be much appreciated!
  13. Hi, I'm trying to import images into my FileMaker database. My problem is: How can I import all my images at once and automatically match or store it based on the value in the Container in the field? For example: I have 5 images located/stored in the same folder of my FileMaker database: 11111.jpg , 22222.jpg , 33333.jpg , 44444.jpg , 55555.jpg **NOTE THAT FILENAMES CAN ALSO BE ANY RANDOM NAMES LIKE 36745.JPG , 76935.JPG , 36790.JPG , ETC.** -In my FileMaker database, I have PRODUCTS Table. -In my PRODUCTS Table, I have PHOTO Field Name. -My PHOTO Field Type is "Container" -- not 'Text' or 'Calculation'. -My Container Values are: 11111.jpg , 22222.jpg , 33333.jpg , 44444.jpg , 55555.jpg --> So that makes 5 rows right? What I want to do is, import all those 5 images from my folder into my FileMaker database while FileMaker will automatically search for its matching value in the database. Once FileMaker found its matching value/filename, it will place the image in that container. Basically, it will be like this: FILENAME = VALUE (IF 11111.jpg = 11111.jpg THEN place that image in that container) I want to know how to do this because I know it will save a lot of time when importing hundreds, thousand or even hundred-thousand files. I hope my explanation to my problem is very clear to you. Your help will be highly appreciated! Thank You very much in advance.
  14. Hi - I have a runtime solution that I will be upgrading. The new version will have several many to many relationships where previously there were many to one. So I'll need to populate the new Join tables with data to correspond to the previously existing instances in the earlier version. I'm thinking this must be a fairly common thing to do as one realizes the need for more complex relationships and additional entities. Is there a well-known or standard way to import the old data into the new configuration? Thanks, Michael
  15. 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.
  16. Greetings! Thanks ahead of time for any guidance  I have a library of musical cues. Each cue can be assigned up to 4 genre/subgenres. I have a Cue Entry Layout for the user to enter this and other data for each cue. It is based on the Cue Entry Table. I have 2 separate tables for Genre and Subgenre. I am pulling the Genre and Subgenre data through a portal into the Cue Entry Layout via a join table called cues_CATALOG. That data is populating 2 pop-up menus on Cue Entry. Here is the relationship graph:    I am importing data from an excel. First I import Title and Cue ID (using auto-enter during import for Cue ID) into the Cue Entry Table so that I have the bare-bones record there ready to be matched with the data to come. Second would be the CATALOG data. I am importing this into the join table cues_CATALOG. Here is the excel sheet as I am importing it:   Import mapping is as follows:  Cue ID matched to _CueIDfk Genre imported to _GenreIDfk Subgenre imported to _SubgenreIDfk  On the surface it appears as though the import is successful:    This is from the layout Cue Entry. These are portal rows from cues_CATALOG with the fields _GenreIDfk and _SubgenreIDfk. These two fields are Pop-up menus being populated by a value list with values from the related primary key fields __GenreIDpk and __SubgenreIDpk from their respective tables cues_catalog_GENRES and cues_catalog_SUBGENRES but displaying the secondary fields Genres and Subgenres.  When I click on the pop-up I see that there is no check mark next to "JAZZY":     Curious. Additionally the Subgenre pop-up which is dependent upon the Genre pop-up seems to display the imported value but when you click on it you get this:     I suppose that's obvious behavior if there isn't actually a value being defined in the Genre pop-up. Question is why isn't there? I certainly imported data into that field. As you can see (or  not?) from the table view of cues_CATALOG it certainly appears as though data is there. Is this about needing to use primary keys instead of values during import? Or is this a text vs number field issue with the foreign key fields?   To sum it up I can't figure out why the data I'm importing into the join table cues_CATALOG does not appear to actually be written into the pop-up fields even though it's displaying properly. As you can see this presents all sorts of problems because my whole scheme is based on the logic that this would perform correctly.  Someone please preach the gospel of filemaker to me...  Kind Regards!
  17. I've got a project that I think would benefit from the use of being able to import and update fields from an external source like XML. In this case Stock information. I'm pretty new to importing XML data and couldn't get anything to work for me. I suppose I just don't fully understand the mechanics of the process. I did some research and found that you can query Yahoo Finance and it will return XML data: http://thesimplesynthesis.com/article/finance-apis Is it possible to update one record at a time, and also update all the records at once? What's needed to do this? Is there a base template to start from? How are fields linked? XML template file? If there are any tutorials or guides on this or any supporting information on how to accomplish this would be greatly appreciated. Thanks!
  18. Here's an idea for a function in FileMaker: when you're importing names that might have slight spelling differences with the already existing ones, one might want to create a function that would compare an imported name and surname with all the available, correct ones. Then it would enter the closest match from the database at a cut off: i.e. 80% to 100% similar. Does that ring a bell to anyone? Do you guys think that would be a worthwhile function?
  19. It was hard trying to figure out which forum to post this topic, I hope this was the best choice. Let me explain my situation and hopefully someone can point me in the right direction. I run a pool company and I have been using a modified version of the john mark osborne solution. Basically its a database that keeps customers data and invoices. I'm using FMP11 to share the database to two laptops on the road also running FMP11. The laptops get internet connectivity from cell phone wifi hotspots. So I can go to a customers record make a new invoice add products and print out the invoice on a laserprinter running off a beefy inverter. This has worked OKAY for the past 2 years. It seems that as the database grows in size from adding customers and invoices it starts to disconnect much more often. I get that error "connection with the host has been lost.. or something" I forget the exact wording. So when this happens it will take 5 minutes or so to log back in because filemaker will close itself out when trying to reconnect since the serial number matches one already in use until it realizes you actually disconnected. Anyways I'm trying to figure out the best way to go from here. A I can probably reduce the size of the database by purging all of the invoices from the prior year to keep the database small yet keep the invoice ID number unique. This might make the database run smoother.? B I've been told that FMGo is designed differently and is able to handle hiccups in a poor connection to a database without getting those disconnection errors, but then I'm worried about the ability to print from an IPad. C I've looked quickly into MirrorSync with the idea of keeping the database offline on the laptops and then just syncing the changed data. D Try syncing myself? For example I could have uniquie IDs for invoices made by specific users. For example ID numbers for invoices,customers, and products made by userA would be even and and anything made by userB be would be odd. Let me know what you think. Right now I have the advantage of being a seasonal business with this being my off time so I can fool around with the database without worry of having to add new data on a daily basis.
  20. Hi guys -- I've a large excel file that I need to import into a DB in FM 5.5, some of the excel data is in Hebrew and when I do the importing all Hebrew data is imported into FM as totally blank fields. How can I make the Hebrew characters import correctly? Best!
  21. Is there an easy way to import a summed fields data into another db. For example, I have a summed field that totals the cost of several shipments. I have another db that uses that summed field, and I would like to pull the summed field from the shipping db into my overall db. Thanks, Bob
  22. I currently have a server the houses a db, and often have to import data from an external source. Often, this external source provides me an excel file, while another provides me another fm db. In both chases, I need to take the target db offline in order to import a file. Is there anyway I can import new data into a file that is live on a FM Server? Thanks, Bob
×

Important Information

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