Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About TravisB

  • Rank

Profile Information

  • Gender

Recent Profile Visitors

2,502 profile views
  1. I can in this morning after recovering over night, and am a little surprised to see that it came back with no issues. At this point, should I try saving a compacted file and host that? From my research I've seen mixed reviews - with the majority recommending compacting periodically, and some people saying to never host a compacted clone.
  2. My database is starting to act strange, some users are experiencing random crashes, I’ve had records that seem to just disappear, records make relationships with other records they shouldn’t be and I’m suspecting potential corruption and this is going to be the first time I make use of my backups and try to A) Identify if I have corruption and B)) potentially fix it. I have a few different questions in regards to best practices and next steps. I am running FMS 15. Most users are on FMP 16, a few users are on FMPA 17. About 10 users total. All users are on Windows 10. Server has Windows Server 2012 R2 Standard. 1) I have backups saved on the host machine, on another machine at the same location, and off site (in the cloud). I accomplished this by using FMS backup schedule, I then have a .bat script that FMS runs which copies the latest backup over to an external hard drive (every night), that hard drive is then backed up into the cloud via Carbonite. I also have two clean clones from initial development on my local machine as well as in the cloud (also backed up via Carbonite) 2) From reading around – my first step is to recover a backup to check for corruption. I periodically do this with my .bat backup (though I admit it has been a while), and it has never come back as corrupt. If it comes back as corrupt – can I trust that it is truly corrupted, or is there possibility that it is corrupt due to the .bat copy, and then copied from the external HD (which is part of my LAN, not connected to my personal machine)? In other words, it will be copied twice – once from the host to an external hard drive on our LAN, and then again from that HD to my laptop – can this potentially cause corruption in itself, meaning the hosted file isn’t necessarily guaranteed to be corrupt? 3) If my file comes back clean with no corruption – what next? 4) I have never Save a Compacted Copy – if it comes back clean – should I save a Compacted Copy and host that file? 5) If I am in fact corrupt - I can simply import my data from my latest backup into a verified non-corrupt clone of the file?
  3. Fantastic questions. I moved the original field to another location and somehow that "o" character was placed right where it was. This database has been live for somewhere around 2 years and I'm currently doing development work for a new release. No idea how I managed to put that there. I'll blame both the placement and inability to figure it out on exhaustion. Cheers!
  4. I have a layout with a drop down list. The value list it uses is just a simple custom value list with two values.  It shows a "o" in front of the value. I copy/pasted the exact same field on the layout and on the new one it appears normal/doesnt have the anomaly. (it looks like its a o or 0 in a small font, or possibly the degree sign - cant exactly tell which character it is.)  See pic to see the two fields side by side - I have absolutely no clue what is going on here. The simple fix for appearance would be just to delete the original value and use the copy/pasted field - but I'm worried that there may be something other than just an appearance thing going on.  "
  5. Justin, Thanks for the note. I was doing two back ups daily, one at noon and one at 11pm (we close the doors are 5, but often times employees stay late). The integrity option was checked. Last night I moved Server to a dedicated machine and upgraded to FM Server 13 as well as all the machines to FM 13. We have the current file on the server and are using it remotely while I re-develop its replacement and import the data- everything seems to be working fine and I'm crossing my fingers that it'll hold together today and tomorrow and I can finish up the "new" database by Monday morning. Obviously this is not ideal to be using the damaged file and relying on it, but I'm putting in 14+ hr days until the "new" database is ready so the only other choice I see that we have is to shut the doors while its down or use a method to deal with the day to day operations with zero chance of being able to import the data easily once I fix my file. I am saving back ups hourly with integrity check on each one and I am also manually checking the back ups every couple hours just make sure they are opening correctly. I am also saving a clone at each hour - which I wasn't doing before.
  6. Just an update, the file was actually recoverable by using recover in FM 13. The file is still damaged, but the data is at least intact, so thats certainly one big win. I still lost a large amount of development work, but at least I still have the data and a "working" database that I can use to help speed up the re-building processes. Considering where I was 2 days ago, I am very happy with this outcome. I will certainly be advocating as well as exercising best practices from here on out. Big thanks to Wim for helping me behind the scenes, very much appreciated.
  7. I have already emailed Winfried, am awaiting a response. I have not tried FM 13, as I don't have it installed, I also have not tried it on a Mac as I do not have access. As for my comment, and your response, all is fair. If this is a known issue, why FMS wouldn't have a built in feature to check integrity of its backups I do not understand, but I'm also not a programmer or understand the potential complexities so really I suppose one could argue my dissatisfaction with that is unqualified. Your point is well taken, understood and greatly valued. I did not do the proper research on best practices as far as backups go and I knowingly exercised practices, which were to be temporary, but regardless against best practices while others I had no idea about (checking backups for integrity is something I've never even thought of before). I'm not blaming FM, its my fault plain and simple. Either way, lesson learned, I need to figure out exactly what happened, change my methods, ensure this doesn't happen again and simply move on. In the mean time, I need my data back. Any other tips or things to try before I fully give up on recovery is appreciated.
  8. Today the machine which was running FM Server crashed, and upon reboot our main database would not open. When saving a copy to the desktop and opening directly it says the file is damaged and cannot be opened. When trying the "recover" command, it comes back with "The access privileges in this file have been damaged or possibly tampered with. Please contact FileMaker Technical Support if the problem cannot be resolved." Most troubling is that all of my backups are also opening with the "The access privileges in this file have been damaged...." I literally don't even so much as have an empty shell of this database, as I did all development as of late remotely (I do have a 1-2 month old version, but a lot of progress has been made on the development since then.) So not only did I lose all the information which was stored in the database, I also lost the design. I did not realize the built in back up service from FMS was inadequate. From what I have found so far, it looks like im pretty well f-ed. Looking for anymore ideas to try and I guess confirmation that I'm screwed. I still need to call FileMaker and see what they say, but I don't really have that high of hopes, but I guess we'll see. Some things that I was doing that probably contributed to this: A) I did do some development while the hosted file was in use by other users - but nothing too extreme or huge sweeping changes, mainly just fine tuning and tweaks FMS was temporarily on a local computer that was being used for normal day to day stuff as well as running the the database from FMS C) I have changed privileges while users were using the file (which, I just found out from my 20min of research this probably what caused this issue and is a huge no-no. Why do they even allow it if its such an issue?) Really hoping this is fixable.
  9. All of the portals are populated from relationships via different table occurances and is refreshed with a cartesian join - there is no portal filtering and the cache is never being flushed. Each portal shows a limited amount of records, hence why I have so many portals, each is refined down to very specific situations the job can be in. Would it be much better to have less portals with more information being shown? What about less portals with filtering implemented? I could dwindle the portals down quite a bit with more information show in each portal and possibly having to implement some filtering (just guessing on the filtering, havent actually looked at it and thought about what to do yet).
  10. Part of the database I am creating includes 19 portals across 3 tabs (10 on first, 5 on second, 4 on third) - with the likelyhood that more will be added. These portals are designed to help employees track status' that jobs are at. I wanted to create a way to minimize/maximize portals as desired by the employee to make it easier to see what you want and only what you want. I have been playing around and pretty sure what I came up with thus far will work, however due to the number of steps I feel there may be a better way performance wise as well as time wise for development. Just as reference, to minimize/maximize three portals there are a total of 14 tabs, 4 portals would be 30 tabs (I think), 5 would be 62 (I think). Everytime you "minimize" or "maximize" a portal, the script evaluates which portals should be shown and then uses script step Go To Object to "activate" that tab (each time min or max is pressed, it will go to exactly 1/2 of the tabs created to ensure the proper "configuration" of tab layout). Attached is the file I created, any advice or tips towards efficiency, or pointing me towards an already built solution is appreciated. I can also explain further if needed. Thanks MinMax Portals.zip
  11. Not sure if you still are looking for an answer on this, or perhaps it will help someone else that stumbles upon here in the future, but I too had the issue of it triggering with each keystroke. My issue was what appears to be yours (probably the initial post as well) which is a misplaced ")" You have IF Code (Get ( TriggerKeystroke ) = 13) and it needs to be IF Code (Get ( TriggerKeystroke )) = 13.
  12. This worked exactly as planned, thanks! Thank you for the help. I dont see how invoices have to do with my questions, which my simply be because I haven't actually followed your advice yet, but I will certainly take a look if nothing more than to gain valuable unrelated info. Thanks again to both - its very nice to have a resource as valuable as this forum.
  13. I have a database that consists of purchase orders (one record per PO) that will have a description assigned by a checkbox. I then have an "over view" sheet for each job that will give the end user a quick idea of what type of products are assigned to that job. So, if a job has 5 purchase orders, and the descriptions for the purchase orders are "A, A, B, D, D" I would like the check boxes on the over view sheet to be checked as "A, B, D" with C and E remaining unchecked. Also, a purchase order can be "A, C and D", or any other variation. What I have done so far is assign for each purchase order a calculation to determine whether or not a value is checked (If (Scope = "A" and From Bid = Bidding::Bid ID ; 1 ; 0)), then another summary field to check if any of the purchase orders for that job are assigned as "A", "B" etc, and then another calculation for the checkbox on the overview sheet: If (Purchase Order::sA ≤ 0 ; "" ; "A") & ¶ & If (Purchase Order::sB ≤ 0 ; "" ; "B") & ¶ & If (Purchase Order::sC ≤ 0 ; "" ; "C") & ¶ & If (Purchase Order::sD ≤ 0 ; "" ; "D") & ¶ & If (Purchase Order::sE ≤ 0 ; "" ; "E") Which this works great if there is only one criteria checked per PO, but if there is one PO with more than one description it stops working, have "A" on one PO and "B" on another PO does seem to work just find though. I know that its the "If (Scope = "A" and From Bid = Bidding::Bid ID ; 1 ; 0)" part of it, but without filling out every possibility, which is a lot, I feel like I need a "wild card" option. This, however, also makes me wonder how the summary portion of my solution would work, or better yet if it would even work. Any help with fixing what I have, or giving me a better way of doing it, is appreciated. Also I should note that I know I could get this to work if I made a seperate check box for each description rather than a set, however that then creates 15 extra calculation fields in my database and 5 extra value lists and I feel like there should be a better way, not to mention I will have to deal with this exact situation on more than just this occasion for this database.
  14. Yes, I found I've been trying to use $$ only when absolutely necessary with the preference to use $ whenever possible. $$ seems to inherently pose the possibility for innaccuracy and/or headaches making sure you clear them at the "proper times."
  15. Im pretty new to FileMaker and have a 2 part question. First, I wanted to know if there is somehow a current list of $ and $$ Variables used in scripts? The reason I am asking is to avoid potentially using the same variable name for two different purposes within scripts. I suspect this comes largely down to "proper development principles" to avoid such a conflict, however that sort of "evaluation" feature wouldn't hurt anybody. This is prompted by the fact that I had the same variable name in two seperate scripts; one to filter a portal and the other to set an FK (I caught it before it went into action, and upon further inspection one was global and the other was local, so it would've been fine - but this is obviously an isolated event and I can't help but feel I'm doing something quite poorly). Second, is there a "go to" guide for a sort of "Industry Standard?" I've noticed a lot of people use the same/similar formats such as (for fields) cValue, gLength, etc to help identify. Any other advice related to this situation, no matter how loosely, is greatly appreciated.
  • Create New...

Important Information

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