Jump to content

Ocean West

  • Content Count

  • Joined

  • Last visited

  • Days Won


Ocean West last won the day on June 26

Ocean West had the most liked content!

Community Reputation

147 Excellent


About Ocean West

  • Rank
    I have an idea!
  • Birthday 11/26/1971

Profile Information

  • Title
  • Gender
  • Location
    San Diego

Contact Methods

  • Website URL
  • Skype

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet
    FileMaker Business Alliance

Recent Profile Visitors

42,797 profile views
  1. use a script set a variable $path = Get(DesktopPath) & myfile.txt use that to export a mer file that would include your headers, If you are in FM18 you can create, open and write to a file and iterate thru adding a header row and then data rows all tab separated. you could also build this data in to a single field then export field contents saving it as txt.
  2. it may seem over exaggerated to have data that is exploded out in to records with many join tables - this way you could with less effort aggregate data for reports and see trends and or pinpoint peaks or valleys in data set over time... the other option would be to store the response data and questions along with the survey as a JSON object where a 'survey' with all questions and answers are captured in one record - however this will be at the expense of being able to quickly analyze the data - unless you can push that structured JSON object to something like java script to unpack it so that you can visualize or search data sets. https://www.geistinteractive.com/widget/pivot-table/ In your data example above i would suspect you will also need to have a Survey Template structure once a survey is published the questions and expectant results of questions (boolean, number, text, pick list, Likert Scale) would need to be immutable so that participant 1 and participant 99 would have all have the exact same set of questions, as not to skew any results. There are several ways to seed the survey template to the tables, when you begin the test, take the survey template and walk the hierarchy creating all the needed join records in all needed tables. Via relationships, matching all the primary to foreign keys. You could export import a template that has all the record structure pre built, in to the testing tables. You could at runtime explode out template survey using a virtual list where records are created on the fly for each question. It gets more complex when your need to have branching logic in to your survey / template such as when some questions can only have any weight or merit if the preceding question crossed a threshold that would require them to submit an answer. As an example questions that would only be relevant to female patient. The other option is to include a Not Applicable to every question so that your aggregate data can be properly weighted to prevent bias or skew.
  3. Yes it's called Perpetual license if you wish to purchase and own the software you can even get maintenance if you purchase for multiple years means you get upgrades over the course of your maintenance, its a more expensive up front but after 5+ years its ends up being cheaper to pay maintenance vs leasing. Below is the cost for 5 users. Perpetual 1 Year 2 Year 3 Year Cost $2,700 $3,185 $3,620 Annual 1 Year 2 Year 3 Year Cost $900 $1,710 $2,430
  4. Welcome to the forums Larry, Natively in FMP since version 12 they introduced the ability to store container contents (files pictures) externally on the operating system in a server controlled directory. It removes the burden on the database for size and backups because container data doesn't change as often as individual records. Supercontainer only stores a URL to a known path on the same server or a separate server you can see the content thru a companion plugin or even a web viewer. In the past I built a solution to manage loan documents I had a process that would store the pdfs in a location accessible to user using the database but also made a separate copy of the files on the company file server so that users could find documents thru the desktop in a very structured folder hierarchy - school, campus, student, also with the method we stored records we had a very long file name using a UUID and be able to email students documents with just a URL so we didn't need to actually send PDFs which usually got bounced by mail servers or ended up in spam. I'd venture to say that any hardware / os upgrades in your future will render access to FM9 obsolete. Upgrading to latest version will give you many more options, with a plugin you could navigate your folder hierarchy and have links out to the file where they are stored. Perhaps with an operating system script to open directories. Hope this helps.
  5. Few points from the 16 Help file, also reference to the TextEncode function https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/export-field-contents.html FileMaker creates a UTF-16 format text file FileMaker Go exports text as a UTF-8 format text file. FileMaker WebDirect does not support this script step in mobile browsers. https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help%2Ftextencode.html%23wwconnect_header
  6. When you perform import close the item "NEW TABLE" it will create a new table and import the records
  7. When you import records you can choose to create a NEW table it will create a table with all the fields
  8. Date ( Month ( table::myDate ) ; Day (table::myDate ) ; Year ( table::myDate ) + 1 )
  9. export field contents renders file as utf-16 you can use new FM18 functions to create open and write a file and specify the UTF format or use BaseElements Plugin to do the same.
  10. @jarvis some things to consider - FileMaker 14 platform is was end of life 9/21/2018 one OS update will render the software unusable or unstable Upgrade to 16+ license prevents hosting multi-tenancy ( only license holder) if you have your own server on premises invest in a UPS invest in storage for onsite and offsite of mission critical backups purchase SSL certificate and any Dynamic DNS service to maintain internal external via FQDN or if business cable get static IP be prepared to open ports on your router there are several hosting providers out there Advertisers: http://store.zerobluetech.com/hosting-50/web-hosting/web-hosting-5-gb-plan-15-00-month.html https://foxtailtech.com https://www.pointinspace.com http://filemakerhostingservice.com/product/index.php
  11. So I was able to make connection get file lists and loop thru and download files, with curl. Been googling all morning can't find the correct settings for the following... seems like every call i have to pass user name & password - (plugins seem to have a starting / ending routine) is there a disconnect command can't figure out how to move / rename / delete remote file with curl there is no direct way to output file to desktop still need a field or variable to hold the raw data.
  12. The problem with using insert from url I would still have to capture the file as text or binary then write it to the os just to perform an import. And then at some point move or delete the remote files My thought was in FMP only have to get directory contents and then import and move. I also couldn’t find examples of the curl syntax to move or remove files
  13. I am reworking my process of using FMP server side script. Run Server Scheduled Script every 45 minutes Log in to FTP get directory listing (plugin / curl) Create Record for each file in listing Fetch file via (plugin / curl) to text field Write file to server's Document folder Move file on FTP to sub directory (compete) Import files from document folder in to table It works but think kludgy and FMS probably requires more overhead to deal with the FTP plugin. Is there a way to do the following Run a server sequence script every 45 minutes Run a bash script on server login and fetch new files from ftp (need help with this) Save files to FMS Documents/incoming Run script that gets incoming files Run script that imports files Run script that moves files to complete directory Run bash script with file listing as parameter (need help with this) Bash script logs in to FTP moves files to complete folder on FTP OR DELETES them (need help with this) I am hoping this would be much more efficient for FMP to only have to do file imports vs having to also FTP. Thanks SD
  14. I would, take a complete different approach. Create the structure of the report so only values are Number fields (no calcs) and write a script that will be either run as PSOS - or actually scheduled on the server in the wee hours of the morning - that would aggregate the date to this report. Users visiting the report would not trigger the update, as all they would need is to sort view. You could better control who has access to the "UPDATE" button by permissions and or hiding the button from user access while the server is processing the records.
  • Create New...

Important Information

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