ccieszyn

Hi there, I'm trying to create a sort of 'reports' view for my database showing counts of certain records based on various modification dates. Right now I'm recording dates and times opened, canceled, and completed. Where I'm getting stumped is in figuring out how to count, say, the records containing open dates within the past 7 days, 30 days, and six months? If someone could help me figure out one, I'm sure I could do the rest. I've looked at the posts in this forum, but don't see one that seems to solve the same question. If that's not the case, though, please point me in the right direction. Thanks so much for any help!

OK, now I see what happens (40,000-some records later). The IP loops back as expected, but doesn't do any validation until field exit. So now I'm wondering how best to have my script check for duplicates and move to the next available value, and what to have it do in the case that no IP addresses are available at all. As I think about it, since the IP is based on a calculation that depends on an auto-entered serial, I'm guessing it would take another approach to make something like this happen. I'll be pondering, but in the meantime - any suggestions? Thanks!

Thanks, Comment. Sorry for taking so long to reply - it's been a busy week. I've got Everything working as suggested, assigning the IP via scripted button and using a numerator table. The button sets an inventory ID field in a new record of the numerator table matching the inventory ID field of the current record in the main table. From there, a standard auto-enter serial is entered in the IP_ID field of the record in the numerator table, and the IP address calculation takes care of the rest. It's all quite simply awesome, and your help is much appreciated. I do have a couple of remaining questions. How should I handle deleted records? I assume the related record in the numerator table should also be deleted; is that correct? Also, If I do that am I right in thinking that the IP addresses will, should I ever get to the end at .250.255, loop back around and start filling in missing entries, or is there something different I should be doing to make that behavior occur (if possible)? For reference, here is my current IP assignment script: Let ( [ B = Int ( Mod ( Numerator::IP_ID; 256 ) ) ; G = 100 + Mod ( Div ( Numerator::IP_ID ; 256 ) ; 150 ) ; R = Int ( Globals::Octet2 ) ; W = Int ( Globals::Octet1 ) ] ; W & "." & R & "." & G & "." & B ) My gut tells me that something different from what I expect is going to happen, as the IP_ID field in the numerator table will continue to go up and up and up, but I'm not an expert on these things yet. I'm off to do some testing. As always, thanks.

Sure, Previous versions of FM8 SA cause OS X web services to hang on startup (of web services, not system boot). It requires removing the lines FM puts in httpd.conf to fix. I can find some links to more thorough descriptions if you need.

Hi there, Can anyone confirm whether this new update to FMSA takes care of the custom web publishing problems that occur on on Intel hardware through version 8.0v3? Thanks!

That's exactly it, and now I remember that you're the one who shared last time, too. Thanks for the second time, Comment! Now, I am having a little trouble modifying it to the current needs. I've changed your W and R variables to simple calls to global fields in another DB, since they won't change at all for this project, and B looks fine, too, but I just can't figure out how to make G start and wrap at different places - specifically going from 100 to 250, but if you can explain how to start and end at various numbers that would be fine. Also, I'm wondering if it is possible to pull these numbers only when necessary, with no break in the sequence. For example, I might create 25 new records, but only 15 need an IP address. The way I have it set up now, the IPs I do assign jump from say .1.19 to .1.25 right along with the number of records. I'm thinking that I can just add a short piece to the beginning of this script that assigns the SerialID field based on the last highest entry (as opposed to leaving it a straight serial number field). Does that sound about right? Sorry if that's confusing. I really appreciate any help you can offer, especially on the first problem, since I think my solution will work for the second.

Hi there, Thanks for all the great advice on these forums. They are invaluable. A kind soul once gave me a great script, back on the old FMMagazine forums, for assigning IP addresses based on very simple criteria. Now I find myself needing it again, but those forums are gone, I have no copy of the text, and no access to the DB where I originally used it. I'm hoping one of you can help me through the problem once more (I promise I won't lose it this time!). Basically, I'd like the address serial to move up through both the third and fourth octets, and then loop back around at a certain point to fill in addresses no longer being used. More specifically, I'd start at 1.1.100.1 and move up through 1.1.250.255 before going back to the start. The 1.1 would be changed to accomodate different organizations, of course, but you get the picture. I really appreciate any help you can give, even if you happen to have grabbed that script from the other forum and can paste it here, or know of a cache I can look through.