Jump to content

jlisburn

Members
  • Content count

    10
  • Joined

  • Last visited

Community Reputation

0 Neutral

About jlisburn

  • Rank
    member
  1. jlisburn

    Google map issue

    Thanks for the side panel params, I didn't realize it was needed at the beginning of the string
  2. jlisburn

    Complex Trainer availabilty logic

    Hi, thanks, 1. Yep, they tell us which trainers can be used, then we need to find the availability (dates) of those trainers. 2. 'From - to' limit - kind of, there is a default period in which we'd be looking (next 7-30 days or so) I was thinking to break things up by Business Week? Unless I have an availability table, I'll have to search multiple tables in order to build up a picture of when the trainer is unavailable; and then from that extrapolate, the other days are when he is available (Show Omitted records kinda-thing) So I'd be looking at a virtual list? Jumping from table to table to collect 'bad' dates and then parsing through them to report the good dates? Thanks again
  3. Part of my solution needs to advise users which are 'good' days to book particular trainers, and which are 'bad'. (Good or bad depends on distance from trainers home and whether the trainer can train that product.) (I've built a matrix of post codes -> Regions and have a join table vs Trainer (i.e. Trainer A likes region A, Trainer A doesn't like Region B, Trainer hates Region C etc) (I also have a 'suitability' join table of trainers to products) My issue then becomes relating which days these trainers are not otherwise occupied or on holiday/sick/PD etc) I can't see past having to create an 'availability' table with every day, every trainer, AM/PM combo possible, and deleting them as they are booked (or book holidays, PD) but this seems inefficient.... .... but then (if I have a sick days table, vacation table etc) I can't wrap my head around what kind of query/calculation/script I'd use to generate my answer (I'm guessing I need something SQL-like). Q: Given this region and this product which days are trainers ideally available? A: ideally would be a list of 'good' days, for which appropriate trainers are available - delivered as a Text Tool seen when hovering over a repeating field of 'suggested' dates the user is then gonna send to a client Thanks for any help
  4. jlisburn

    Case Calc based on Check box

    Many thanks, that works on a nice clean example file but not in my solution (I'm also calculating other variant attributes in my result string ) so my issue must lie elsewhere. Thanks again for your help.
  5. jlisburn

    Case Calc based on Check box

    Thanks for your help on this, but I'm not sure I'm with you: Some courses require a Wallet card be issued (and not a Cert- "NO cert"), some courses require a Wall Certificate be used (and not a Card- "NO card). Some don't care and either a Wall Cert or a Wallet Card may be issued (CARD or CERT) Some courses don't allow for anything to be issued (NO card/cert) So I have four potential results from the state of my two value check box: one value, the other, neither or both. Sounds like I'm way better off with two fields: CertY/N and CardY/N Thanks again
  6. jlisburn

    Case Calc based on Check box

    Thanks, My bad, mistake in my original post, what I'm after is when: CardWallCert = "Wallet Card" and CardWallCert = "Wall Certificate", I want it to return "CARD or CERT" Which is the bit I can't get: Case ( IsEmpty ( CardWallCert ) ; "NO card/cert, " ; CardWallCert = "Wallet Card" and CardWallCert = "Wall Certificate" ; "CARD or CERT" ; CardWallCert = "Wall Certificate" ; "NO card, "; CardWallCert = "Wallet Card" ; "NO cert, " ) No joy if both are checked even if i try: Case ( IsEmpty ( CardWallCert ) ; "NO card/cert, " ; CardWallCert = "Wallet Card" and "Wall Certificate" ; "CARD or CERT" ; CardWallCert = "Wall Certificate" ; "NO card, "; CardWallCert = "Wallet Card" ; "NO cert, " ) Same deal - when both values are marked I get nothing returned, instead of "CARD OR CERT" {BTW - I didn't realize you could drop the default result from a Case statement, that's cool. I case it assumes: Return NULL?}
  7. jlisburn

    Case Calc based on Check box

    Hi, I've got a field (CardWallCert) with a check box which is fed by a value list with entries "Wallet Card" and "Wall Certificate". It describes which are applicable for a given course (there are a number of possible variants ) and every option is potentially possible (Either one, or the other, or both, or neither) I'm trying to textually describe the contents of the check box (and hence the course variant) via a calculation: eg: Case ( IsEmpty ( CardWallCert ) ; "NO card/cert, " ; CardWallCert = "Wallet Card" and CardWallCert = "Wall Certificate" ; "" ; CardWallCert ≠ "Wallet Card" ; "NO card, " ; CardWallCert ≠ "Wall Certificate" ; "NO cert, " ; "" ) I want it to return blank if both WalletCard and WallCert are selected, but it just gives whatever relates to the last option I selected/deselected. No doubt someone with a stronger logic brain than mine can get the desired results, perhaps even with a more concise calc. I'm trying to avoid splitting into two fields (WalletcardYN and WallCertYN) Thanx in advance for any help
  8. Bad to worse I'm afraid. Ran through the Deployment Wizard and it balked at the Web Server detection phase; it didn't recognize IIS7. Churned out this error Deployment/Configuration error - 13 Configuration returned error 2,506 when configuring the following component: wpe1 I expect I'll find it somewhere. I've found a couple of leads so far that are dead ends... I quit and relaunch my browser having cleared my Java Temp files. Go to login again and wrong UserName and Password, it says, but they are right, just what I'd typed in earlier, same as they were originally. It just says they are wrong. Server is still delivering it's content, I'm just flying blind with no admin console and am not sure how it's all gonna react to a reboot, or system Update or whatever. Looks like I'm facing a reinstall (and drop back to earlier Java version? 24?) of FMS server
  9. Thanks, that's possible I suppose, (despite everyone being under strict orders not to touch things like that). I notice this morning I have 20 or so instances of the deployment assistant running alongside 20 or so 'Admin Console Locking Error' all listed inside Task Manager 'Applications'. I quit them all and now I've made it worse. Now when I launch the admin console page and I get the response that 'another use is deploying FM server', even if there's no window showing anyone doing so.. Thanks g40sty, I guess I've no choice but to bounce the server and run through the deployment process
  10. I have a FM 11 Server Adv which has been in Production for over a year, sitting on Win 2k8 R2. I have real problems with Server Admin. It used to just not launch, despite having updated FMS to re: the Java issue. Now, every time I launch Server Admin The Deployment Assistant starts. I don't want to complete it in case I mess something up and bring the server down - it's serving it's DBs just fine, I just can't check logs or changing things using the Java GUI. Any ideas why the Deployment Assistant is behaving like its a new server, when it's working quite happily. How can I launch Server Admin without the DA starting? Oh, I've run the latest Java updates and still no dice, same deal
×

Important Information

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