Jump to content

Wim Decorte

Members
  • Content Count

    5,359
  • Joined

  • Last visited

  • Days Won

    151

Wim Decorte last won the day on June 2

Wim Decorte had the most liked content!

Community Reputation

460 Excellent

7 Followers

About Wim Decorte

  • Rank
    member
  • Birthday 12/17/1968

Profile Information

  • Title
    Sr. Technical Architect
  • Gender
    Male
  • Location
    Toronto

Contact Methods

  • Website URL
    www.soliantconsulting.com

FileMaker Experience

  • Skill Level
    Expert
  • FM Application
    18

Platform Environment

  • OS Platform
    X-Platform
  • OS Version
    all

FileMaker Partner

  • Certification
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
  • Membership
    FIleMaker Platinum Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. That's a business workflow question more than a database technical question. How do the users currently decide from which length to 'cut'? Your database will have to give them the same choices. This is very similar to fairly standard inventory control. Orders are checked against qty-on-hand Qty-on-hand gets updates as part of the picking & shipping process. Don't try to do this with calculated fields; it will make reporting horrible in the long run. Use scripts for the workflows and update the 'qty-on-hand' as part of the 'cutting' workflow.
  2. The same question applies to both dedicated and hosted gear: you need to work with your current baseline (stats.log mostly) to find out if you are hitting any kind of performance bottlenecks. Only with that in hand can you choose the proper hardware to run your solution on. Changing the hardware specs up or down is easier in a virtualized environment, which most hosting environments are.
  3. All the documentation you'll need is here: https://fmhelp.filemaker.com/docs/edition/en/migration/ Let us know what you find complex specifically and we can help you with that.
  4. Or even write your own little mini web service (microservice) to deploy on that remote machine. We do that a lot in the case where files get produced from one system and need to be imported into FMS. Real-world example: - "other system" drops thousands of XML files to a server through an MQ messaging system - small custom Windows service watches the folder and every time a file gets added, parses it and adds it to a small Sqlite db (all very lightweight but it can handle thousands of files being dropped in the watched folder at once). This service could have just turned around and push the data to FMS through the Data API, XML API, PHP API or ODBC/JDBC but we wanted the freedom to de-couple both mechanisms (receiving the files, and adding the data to FMS), so we added: - small custom web service (ASP.NET in this case but could be any technology) basically provides a GET endpoint that will read from the Sqlite database and send all the data in JSON format to the caller and then delete it from the Sqlite db (so that there is no persistent storage in sqlite) - over on the FM side there is a schedule that calls that web service every 5 minutes. This whole setup was built to replace a standard FM import-and-process routine that was too slow to keep up. It's blazingly fast. Because we chose to add that Sqlite db in the middle, we are free to shut down FMS for as long as we need to, without interrupting the incoming flow of data from the other system.
  5. And how did you determine the IP? It has to be the external IP assigned to you by your ISP.
  6. There's going to be a fair number of moving parts, whichever way you do it, by sticking with "insert from URL" you keep the moving parts in FM's space with fewer outside dependencies. And better error trapping and handling.
  7. Why not use the "insert from URL" with the FTP cURL options? No plugins needed.
  8. Did you install the cert using the proper import dialog? Did you include the intermediate cert? Did you restart FMS after installing the cert?
  9. You check by logging into your router to check the port forwarding, and log into your firewall to see if the ports are open. Some routers are firewalls and it's all done from one place. You also need to check the software firewall in the OS of your FMS machine. The question was about you connect right now. What did you enter as the host to connect to?
  10. The proper ports are open on your firewall for and forwarded to your FMS machine? And you're accessing the solution with the external IP address or DNS name?
  11. It doesn't explain how it is done or whether you'll charge for it. At least not that I can quickly see it. The "see all videos" doesn't go anywhere. What's the core concept here for the single layout? Web viewer?
  12. Not sure I follow #1: FM Go doesn't use a browser so how does webdirect come into play there? Since PC browsers work: are those on the same network as your mobile devices? Or are the mobile devices on their LTE network and not on Wifi (to the same network segment as the PCs).
  13. Fair enough. It's just never bitten me or any of our projects so I wanted to make sure that the channels to report the issue were clear,
  14. I've never experienced this on either macOS or Windows 10 so it may not be a wide-spread kind of thing. Anyhow; if you feel strongly about the bugs you discover, make sure to report them here: https://community.filemaker.com/en/s/topic/0TO0H000008OQOGWA4 If it requires a change of the feature set, report it here: https://community.filemaker.com/s/ideas and invite people to vote it up. If you don't then FMI may not hear about your bug or your feature request. And they do pay attention to what comes in on both of those channels.
  15. Has FMI acknowledged the bug? Why are you importing as part of a restore? Why not just use the backup file directly? I'm a little confused as to what is not working. Are you importing into a file that uses Remote Containers or importing into a file that uses embedded containers? As to the functional use of "self contained": it's largely around two things: 1) portability; if you want to move a copy of the file to somewhere without having to worry about also moving the RC folder and its content 2) in case you change your mind and want to stop using Remote Containers For your batch file; two ways of solving your issue. Store the batch file in a container field and do a "export field content" to a known location and then use Send Event to call the batch file Or, do the full syntax in the Send Event but in that case you have to concatenate every "line" or command together with && so that the Windows command line interpreter will execute each command one after the other.
×
×
  • Create New...

Important Information

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