Jump to content

kmtenor

Members
  • Content Count

    21
  • Joined

  • Last visited

Community Reputation

0 Neutral

About kmtenor

  • Rank
    novice

Profile Information

  • Title
    In-house Solutions Developer
  • Industry
    Manufacturing
  1. THANK YOU, WIM! That was exactly the "hint" we needed. Thanks again. -Kevin
  2. Understandable, Josh. I hope you agree it was at least worth asking. Thanks for looking to see if you have a sample. I will do some more research, as well. We have 70 databases on this server, so checking that they all have stopped could be an interesting bit of fun. Yes, we have discussed splitting this server into two (or more) within the environment. We have a site license and plenty of VM Head-room. No, NetBackup was never touching the served databases themselves. It appears as though at one point we were backing up one "RC_Data_FMS" directory that was in the live folder, but there
  3. Thanks, Josh. On the theory that you get nothing when you ask for nothing... is there any chance your server folks would share a generalized version of their VBScript? If not, I understand. Our server is just for FM, no AV, nothing else running on it. We do run Symantec NetBackup in the environment (on a different server), which DOES do file-level backup. Even though we're planning to remove Symantec as a backup solution, we might switch back to that temporarily to backup the filemaker-produced backup directory nightly while we figure out how to automate and properly test the veeam/fmsadm
  4. We are currently tracking two issues we believe may be caused by our lack of following best-practices where snapshot backups are concerned: 1. We have a database that has phantom records. These records are messed up in such a way that we are facing a complete database rebuild in order to resolve them. We are holding off on doing that, however, until the backup best-practices are in place. This issue was discussed in greater depth on another forum. 2. We are seeing an issue with clients not being kept up to date when records change at the server. Rebooting the server seems to solve the iss
  5. Thanks for that info, Josh. That's a great insight into the right process. So, do your guys run the snapshot backup manually every time, or do they have the procedure you outlined above automated somehow? Clearly, we can issue the pause and restart commands automatically - it's double-checking that everything actually paused that is proving tough to automate. Thanks. -Kevin
  6. Josh: We are also using Veeam, and are in need of putting a proper solution in place for suspending our databases. Can you confirm with your IT department whether they simply put the "FMSADMIN PAUSE" command into the Veeam backup Pre-Freeze script for your server, or if they wrote something more sophisticated? Obviously, they would have to also put an "FMSADMIN RESUME" into the Post-thaw script, as well. I believe the Veeam setting for "Require successful script execution" should be sufficient to determine that the files are actually paused, but I would take other suggestions on that fr
  7. Thanks, Tim. Turning off PSoS on the mobile database settings script appears to have done the trick. I would say your assessment is right on that there appear to be some issues with how credentials get passed from DB to DB, particularly when PSoS is involved. Hopefully, the good folks at Filemaker know about this and will be able to fix it sometime soon. To LaRetta's latest point, I suspect I would have been fine if there hadn't been credentials getting in the way, even with PSoS turned on and remote TOs being sync'd. As is so often the case, security comes at the cost of simplici
  8. Hi, Tim and LaRetta. Â Thanks for your suggestions. I have double-checked everything, and all signs still point back to security being the issue. Â Tim, you're right - mobile is successfully connecting to hosted and is even pushing the payload - but when the script tries to process that payload into the password-protected tables from the external database, it fails. Â I've attempted to attach a screenshot that should answer LaRetta's question - unless there's something under the hood I need to look at within that join? Â Â That screenshot is taken from my hosted sync database. Â Note
  9. Hello. Thank you for the marvel that is FmEasySync! It is exactly what we needed for our relatively simple sync needs, and I truly appreciate the thought that has gone into creating it. I am only seeking help because our application is made complex by some security requirements, and I have run out of ways I can think of to troubleshoot it. I'm hoping someone else can offer a suggestion that will knock this loose for me. Our application is an "observations" database that runs in Go on the iPhone. It allows our managers to make safety observations and sync them to a central database
  10. Hello. I have just installed SC for the first time on our FMS10 server. SC is running under FMS, and works when writing to its default directory. I tried setting the custom URL for file storage in the XML file to a newly created share on our network file server (Windows 2003 in a domain environment), but every time I tried to upload a file, I got the "Error 500". I understand this is a permissions error, but the only documentation I could find for fixing it referred to OS-X, so was not very helpful. Can SC be set up to write its files to a network share instead of the local FMS se
  11. Thanks, Comment and Fitch - that's quite the obscure rule! So, the revised version of Method 2: 1. Select the conditionally formatted object from which you want to copy formatting. 2. Bring the object to the front (using the align tools) 3. Shift-select the object to which you would like to apply the first object's conditional formatting 4. Right-click on either object, and select "Conditional Formatting" 5. IF (and ONLY if) all of your conditions come up in the dialog, click OK, and the conditions are applied to the object that originally had no conditional formatting. I
  12. There are actually two ways to copy conditional formatting - though one of them, I cannot get to be consistent. Method 1: 1. Apply conditional formatting to an object on the layout. 2. Control-click and drag the object - this creates a copy of the object on your layout. 3. Modify the copy as needed. All conditions will be present when you view the conditional formatting of the copy. If you do the above with a field, Filemaker automatically asks you which field you want when you let go of the mouse button. NOTE: this also works when an object is copied-and-pasted, as well
  13. That would work, as well. In general, any time you can keep activity on the server-side, you'll improve the database performance, particularly when you're dealing with MSSQL over a network. The 'best' method is always defined by the application you're trying to create, and the environment in which you are operating. A quick search for 'mssql insert trigger' turned up quite a few options, but the one at the top should suffice as a guide (the site has been reliable and accurate in the past). http://www.devarticles.com/c/a/SQL-Server/Using-Triggers-In-MS-SQL-Server/ Good Luck!
  14. At the risk of being scolded that this forum is for Filemaker and not for SQL, (and if I understand your question correctly) I believe the following is what you're looking for: insert into newTable (tableId, tableName, tableAddr1, tableAddr2, tableCode) select '1', lookupName, lookupAddr1, lookupAddr2, 'test' from lookupTable where lookupId = @lookupValue The above code, using a subselect for the insert, emulates Filemaker's "Auto-Enter Looked Up Value" feature at the field definition level. You would have to replace the constants in the select sta
  15. Thank you, Ender! That was the perfect solution. The code to get the date field from the next record worked out like this: GetNthRecord(date_to_invoice; Get(RecordNumber)+1) Thanks again! -Kevin
×
×
  • Create New...

Important Information

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