I currently spend about $60 per month to a company that hosts my FMP 14 databases on a shared server.
How complicated would this be to manage on my own? I am not interested in hosting sites for anybody else, just those for my own company.
What kind of dedicated computer gear would I need to make this happen? Would I need to have a dedicated IP address?
Can this be done by a rube like myself or would it be better to continue paying someone else for this work?
By Ocean West
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.
By IP C
In my attached sample file, I have two Tables Inventory and Transactions. In my Inventory Table I have fields
Current Month Inventory Last Month Inventory
I want these two fields to capture the count of my Last month Inventory and the count of my current Inventory.
In my Last Month Inventory Fields I like to have 1589 Bottles / 7 Boxes ; If someone withdraw 235 Bottles This Month My Current Inventory Fields will Show 1354 Bottles / 6 Boxes.
Please find attached file that Im working.
Cross posted to https://community.filemaker.com/en/s/question/0D50H00006qwZEcSAM/last-month-current-month-calculation
Who Viewed the Topic