Jump to content

truelifeajf

Members
  • Content Count

    108
  • Joined

  • Last visited

  • Days Won

    1

truelifeajf last won the day on October 30 2013

truelifeajf had the most liked content!

Community Reputation

4 Neutral

About truelifeajf

  • Rank
    member

Profile Information

  • Gender
    Not Telling
  1. truelifeajf

    Getting "ERROR" with Crop Image

    I tried on a smaller file and it "worked", this time this: $result = CropImage( $crop_location ; 0 ; 0 ; 10 ; 10 ) $result is "image.jpg". Why does it show "image.jpg" as a result?
  2. truelifeajf

    Getting "ERROR" with Crop Image

    Ah ok... the log says: java.lang.OutOfMemoryError: Java heap space There's more information after that but I'm guessing that may not be relevant right now. Image too large? Increase FM Memory allocation?
  3. I'm at a loss as to why I'm getting "ERROR" when: I have an image (JPG) 3648 x 5472 pixels at this location: $crop_location = /Volumes/Macintosh HD/Applications/Wolf Spring/Wolf Spring Lightroom/Originals/Anderson_Austin_RB6649233682XA-O9330018750AV-crop.JPG The file location is definitely correct. This function: CropImage( $crop_location ; 0 ; 300 ; 3648 ; 5172 ) Should simply crop 300 pixels off the top, right? I get "ERROR" Any ideas?
  4. I just made the menu item based on "Paste" instead of "Paste Text Only"  and now it works  see attached.  So the question is... why can't I have a menu item based on "paste text only"?
  5. Ok, let me clarify a few things: - definitely something in the clipboard... I'm copying text from another field - if I switch to full access menus, I can paste fine - not trying to paste into a container field... just a normal text field - see screen capture attached - same problem on Mac and Win - FM13 Advanced or FM13 Standard no paste.mov
  6. I'm at a complete loss. Â Really simple... custom menu set, custom 'edit' menu - see attached. Â If I insert the Paste command, or Paste without style command into the menu, it's dimmed... can not be used. Â Cut and Copy work fine... can't paste. Â I can't see any reason why this is the case... it's gotta be something simple? Â To test... I put the "Omit Record" command in the menu - that works fine. Â So it's just paste commands.
  7. Well what I implemented with Tom's help has worked. I guess "IN" is another method that will work too, though I haven't tested. Thanks guys!
  8. Ah... thanks... Your suggestion was good for all locations, but what if I just want one selected location, or 2, or all? I ended up doing this: Let ( location_list = Substitute ( dashboard::location_ids ; "¶" ; " OR location_id =" ); ExecuteSQL ( "SELECT SUM(amount) FROM sales_figures WHERE (location_id = " & location_list & ") GROUP BY date_start ORDER BY date_start"; ""; "" ) )
  9. Howdy all, I could ask this in Stack Overflow or similar but it seems FM SQL has certain limitations when creating more complex requests (joins, group by, etc). I have a table of sales figures (location_id, date, amount). Assuming there's only one location, and I want to graph the sales over time... x-axis: ExecuteSQL("SELECT date FROM sales_figures ORDER by date ASC") - I'd get a list of all the dates y-axis: ExecuteSQL("SELECT amount FROM sales_figures ORDER by date ASC") - I'd get a list of all the amounts The problem is multiple locations are in the list and I want the graph to show sales data for one or more locations that I select. For the x-axis (dates) I can SELECT distinct... easy. But what about the sales figures on the y-axis? I only want ONE amount for each date... So I want to start with the first date, find all the locations for that date, sum up their sales amounts, and then move onto the next date. Any ideas on how to form an ExecuteSQL statement to achieve that?
  10. truelifeajf

    CRM's and death of FileMaker?

    Yes, I've been playing more and the tab key is definitely something to avoid. It's laughable. I've already started re-coding it all in PHP / HTML5 / REST / etc. Sorry FileMaker... Web Direct just doesn't work. I'll keep the FileMaker solution for in-house servers / stand-alone use in the cases where people want lots of fast customisation and / or to be able to interact with the file system. What I *might* do is sync the data between the MySQL system and the FileMaker system so I can continue to develop both the HTML and FileMaker versions of this CRM separately but keep in sync with each other.
  11. truelifeajf

    CRM's and death of FileMaker?

    Thanks for the idea Josh... but there's zero going on with this server... no background anything... just 10.8 and FM Server hosted with MacStadium - Gb connection. No one connecting - just me. Richard... I'm now firmly of the same opinion as you. WD sucks balls.
  12. truelifeajf

    CRM's and death of FileMaker?

    7 fields, 1 record. The layout shows two field only
  13. truelifeajf

    CRM's and death of FileMaker?

    I have my own server... Mac Mini i7, 16GB, SDD. Fresh install of OS X 10.8, FM Server 13 (latest version). I appreciate it's hard to offer any advice but I can't even think of what I'd do to test this. I can try a whole new server but that'll cost a bit... I can try reinstalling everything but it's only been set up 60 days ago. Anyway... I think I've decided to just forget about Web Direct. Maybe I just needed to rant haha! I do appreciate the responses though... I guess I was hoping for someone to know something... some little trick I didn't know about... or a known bug... or something.
  14. truelifeajf

    CRM's and death of FileMaker?

    Fair enough... any suggestions, as I'm at a loss.
  15. truelifeajf

    CRM's and death of FileMaker?

    So, based on zero replies from my other two questions in the webdirect forum, the 187 views of this thread and no answer to the simple problem of a webdirect layout with 2 fields not working... I'd say webdirect is completely unusable.
×

Important Information

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