beverly

Moderators
  • Content count

    398
  • Joined

  • Last visited

  • Days Won

    3

beverly last won the day on June 22 2016

beverly had the most liked content!

Community Reputation

22 Excellent

About beverly

  • Rank
    defender

Profile Information

  • Gender
    Not Telling
  • Location
    in the ether

FIleMaker Profile

  • FM Application
    15 Advanced
  • Platform
    Mac OS Sierra
  • Skill Level
    Expert
  • Membership
    TechNet
  • Title
    Web and Database Developer

Recent Profile Visitors

5,494 profile views
  1. The fm_sql_reference (versions 13, 14, 15, & 16!) is only partially helpful. It applies more for using FM as an ODBC source. The "missing" reference is a compliation of many developers pounding (testing) the heck out of the ExecuteSQL function. What works, what doesn't. Get the PDF and the example files. Read the comments from others on the blog. Kevin (and others) have a ton more blogs on ExecuteSQL! And there are a few "helper" files that will guide you in writing the queries correctly (here are the current/correct links): SQL Builder (this forum) http://fmforums.com/forum/files/file/25-sql-builder/ SQL Explorer (seedcode) https://www.seedcode.com/filemaker-sql-explorer/ And if you need a Japanese version of the "missing" reference? http://notonlyfilemaker.com/2014/01/missing-executesql/ beverly
  2. the problem may well come from limitations in the ExecuteSQL function. Nested functions with the aggregates ( SUM, COUNT, etc.) don't always work as expected. You may well do the SUM as a caclulation in Clients (use ExecuteSQL) to get the time in the last 30 days. Or use a Let() statement to get the sum of the time (no join needed) in the last 30 days and push to a variable that can be then divided by the Seats. Use this field to FIND the Client with the "most". I probably would NOT use a calculation (unstored), but a looping script to Set Field.
  3. IMPORT does NOT require to know how many records are being imported (not for tab, not for csv, not for XML). Thanks for the alternatives, guys. OP still needs to learn the XPATH and XSLT to understand what we've advised. beverly
  4. 1. the elements in the xml source do NOT match the elements "called" in the XSLT what is current/id/@value ? when the source has data/post/id learn about the basics of XSLT and XPATH: https://www.w3schools.com/xml/xpath_intro.asp https://www.w3schools.com/xml/xsl_intro.asp <COL><DATA><xsl:value-of select="./id"/></COL></DATA> 2. to "loop" the xsl:for-each is used around the ROW elements in your XSLT and the select needs to be a valid XPATH, such as data/post so that you will get one row/record imported with everly post element in your XML source <xsl:for-each select="data/post"> <ROW> <COL><DATA><xsl:value-of select="./id"/></DATA></COL> ..... </ROW> </xsl:for-each> beverly
  5. due to FM being one way to connect otherwise unconnected systems, many of us are versed in other systems as well. I speak web, I speak SQL. Of my job, 50% is FileMaker projects (web and non-web). But surprise, SURPRISE! many of the 'non-FileMaker' jobs/work may get some FM just because it's easy to use. Perhaps planning the next big web project is done with FM. Or 'the book" - a whole bunch was stored in FM for sorting searching, etc. Short answer: yes
  6. This is a X-post on FM Community: https://community.filemaker.com/message/658922 Please see all replies there before duplicating here. While there may be people here that have answers different, it's important to let everyone know you have cross-posted to more than one forum. Thanks!
  7. So this IS an old thread, but still valuable! Is there a way to IMPORT the SVG files (a folder) that we can find "out there", so we can study them and verify that they are FMP-icon-ready? Thanks!
  8. You cannot have spaces in names try \"Cost Price\"
  9. + wim and the third option by webko. ESS is a "two-way sync" if you will with FM and the MySQL. you can push or pull data between the two. If the data is in a FileMaker table (TO), then Set Field with it into the MySQL table (TO). ESS makes the data in the external SQL source behave much like any other "native" table in FileMaker. if you can move data from one native table to another in FileMaker, you can do the same with ESS (provided you have the proper permissions, of course!) NO SQL commands (via xDBC) or XML/PHP needed. in addition, should you wish, you can use Import and Execute SQL script steps to exchange data between FM tables and SQL tables (not ESS, but SQL queries) beverly
  10. yep on webko and wim! as I said, a query is TEXT. however you can calculate (or script gather) the text to make the query work for single or multiple records is ok. I have used both methods (even before there was "ESS")! beverly
  11. Same link as above for updater FMS 15.0.3. Release notes: http://help.filemaker.com/app/answers/detail/a_id/16211/ beverly
  12. you can use EvaluationError() around your ExecuteSQL() to see if a number value is returned. another method to test (if you have FMPAdvanced (for using the DataViewer): https://www.teamdf.com/blogs/unlocking-hidden-error-messages-in-the-executesql-function/ beverly
  13. the query is a text result and as Wim says will need to calculate out correctly for the SQL db (and the driver) to understand it!
  14. Forward from Molly Connolly ==== Please join us for a planning Meeting for the Future of Women of FileMaker Please join us to discuss the future of Women of FileMaker. FMI has agreed to assist us in growing the program and we would love your ideas, input and action! We will be discussing: Goals & Mission Statement Leadership Logistics If you can't make this meeting don't worry there will be more! Or you can post your ideas in this forum. Please register below and feel free to share! Nov 7, 2016 12:00 PM EST https://attendee.gotowebinar.com/register/1705512237672678658 After registering, you will receive a confirmation email containing information about joining the webinar. ==== https://www.facebook.com/groups/687750251333651/ beverly p.s. Please register if you have an interest. Comment on the Facebook page if desired. This is merely an announcement and comments not needed here.
  15. try saving the worksheet as .csv and then import and agreed with comment. ".xls" is Excel, not ".xsl" (Extensible Stylesheet Language) http://www.w3schools.com/xsl/ beverly