Jump to content

Joel Shapiro

Members
  • Content count

    38
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by Joel Shapiro

  1. Don't forget! Monday July 24, 3:30–5:30 (before the 6pm opening keynote). Come see: Steve Winter @steveWinterNZ Mark DeNyse @mdenyse Ken d’Oronzio @kdoronzio Gjermund Thorsen ggt667 Joel Shapiro @jsfmp Hope to see you there! -Joel http://jsfmp.com/cwp-user-group
  2. Hiya Can FMPerception show the elements that have script triggers that call a specific script? Thanks, -Joel
  3. Find script triggers that call a script?

    Thanks Dave, that's perfect! (I'd been looking at the "Calls Scripts" sub-query) Best, -Joel
  4. Hi all Come join us at the 11th annual CWP User Group at DevCon: Monday, July 24, 3:30–5:30pm (before the 6pm opening keynote). Do you have something you might like to share with the group? Please let me know. We're always looking for new people! Everyone's welcome. Hope to see you there! -Joel http://jsfmp.com/cwp-user-group ~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro : database design : web development http://jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~
  5. [ANN] CWP User Group - Monday at DevCon 2017

    Hey GGT I tried emailing you. Please contact me if you'd like to share something at the CWP User Group at DevCon. Thanks, -Joel
  6. [ANN] CWP User Group - Monday at DevCon 2017

    Hey GGT! Thanks for replying Which one(s) do you use for Custom Web Publishing? -Joel
  7. Hi all We're going to be having our 10th annual(!) CWP User Group on Monday, July 18, from 3:30 to 5:30pm (just before the 6pm opening keynote). Got something you'd like to share? Please let me know. Everyone's welcome. Come join us! -Joel http://jsfmp.com/cwp-user-group ~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro : database design : web development http://jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~
  8. [ANN] CWP User Group - Monday at DevCon 2016

    Wow, that'd be great! (And more "+" than "10" for me -- you were a huge help in my early CDML days too :-) (does that mean no video for this year? ;-) -Joel
  9. [ANN] CWP User Group - Monday at DevCon 2016

    D'oh! Just seeing this now. (& then discovered the "Notify me of replies" button :-P ) That would be great if you could come, Webko! If we knew we'd have a good internet connection I'd suggest a skype call-in. In 2013 we had a video presentation sent in from Martin Brändle in Switzerland. Perhaps an option for you too?? -Joel
  10. Hi all I just helped someone else with this problem, so I'm posting again here to make it publicly available: THE PROBLEM: The PHP API function "getValueList" can break under FMS10 when there's an ampersand (&) in one of the values: "apples & oranges" > becomes > "apples apples &apples & oranges" The function has officially been "deprecated" in FMS10 -- and replaced with "getValueListTwoFields" -- but the ampersand is a case when the original function in fact _breaks_ when hosted in FMS10. Changing to the new function fixes the problem. (I don't know if any other characters also cause problems.) WHO THIS AFFECTS: - Anyone who has used the getValueList function with FMS9 -- whether via the Site Assistant or not -- and upgrades to FMS10 - Anyone who uses the getValueList function under FMS10 - Anyone who has or may someday have ampersands (or possibly other characters?) in any value-list values that are published to the Web via the PHP API under FMS10. REMEDY: When upgrading to FMS10: Replace all instances of "getValueList" with "getValueListTwoFields". When developing under FMS10: Always use "getValueListTwoFields". (While in FMS9, do NOT use "getValueListTwoFields" as the function does not exist.) I hope someone finds this helpful. Best, -Joel ~~~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro database & web design http://www.jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~~~
  11. Hi Tim  I played a bit more with FMWebFrame's Container Uploading. It works smoothly (nice!) on a one-machine FMS config (12Adv on Mac), but on two separate two-machine configs (12Adv Mac & 12Adv Win), the uploaded file gets ".html" tacked onto the end of the filename.  Have you tried this on a two-machine FMS install? (That's the only real similarity I can think of between these two failing machines.)  I'll do some troubleshooting myself, but thought maybe this might raise a flag for you...  Thanks, -Joel looks like my screenshot didn't make it. trying again...
  12. EasyCalendar Initial Comments

    Hey Tim Thanks so much for EasyCalendar, it's really pretty awesome. I've played with it a bit on a project I'm working on that has a table of Events. A few comments/questions that I've got: a) My Events table has 3 date fields (EventDate, SignupDeadline, CancelDeadline) and EasyCalendar works well to include all of them -- so it seems you could change/clarify "from multiple tables" in your documentation into "from multiple fields". b ) Before I dive into it myself & potentially reinvent your wheel, have you thought about allowing 'hard-coded' or static text for some of the settings instead of having them come from fields? e.g. with some set delimiter, allow "{{255;0;0}}" or "{{Bold HighlightYellow}}" This could allow us to set a whole category of events, e.g. all SignupDeadlines or all events from Table2 -- without needing to add fields. c) You may have caught this already, but the script step to sort a day's events by startTime is incomplete. Should include: "¶ORDER BY "" & GetValue ( $$Event_Begin_Time_Field_Name; 1 ) & """ ; instead of: "¶ORDER BY¶3"; d) It might be nice to sort also by endTime in case two events have the same startTime. (Or maybe by Description?) e) Your License names "EasySync" instead of "EasyCalendar" f) FWIW: When I just re-opened my local (unhosted) DB with EasyCalendar integrated, the "FMEasyCalendar - Beta 1" script somehow kicked in automatically and I had to use Script Debugger to stop the script at 28,000 EasyCalendar records. I haven't tried troubleshooting that yet... More as they come... Thanks again, -Joel
  13. Container Uploading adding .html to file name

    Hi Tim Just seeing this message now. I'll try to upload test.png.html here. I grabbed it via Export Field Contents on the container field. The contents are: <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html><head> <title>404 Not Found</title> </head><body> <h1>Not Found</h1> <p>The requested URL /FMWebFrameDemo/temp/test.png was not found on this server.</p> </body></html> FWIW: I didn't do anything with your 404.php page on any of my test servers because I thought that's only for container publishing, not uploading. Still, the uploading works perfectly on the one-machine config. -Joel test.png.html
  14. FMWebFrame: FYI PHP Notices/Warnings

    Hi Tim Just testing out FM WebFrame for my first time, starting with Container Uploading. I'm using your Demo (on my server) and when I first loaded the site in my browser, I got Notice: Use of undefined constant nickname - assumed 'nickname' in /Library/WebServer/Documents/FMWebFrameDemo/FMWebFrame/settings.php on line 91 & similar for lines through 95. Wrapping each of those keys in quotes seems to fix the Notice. (I also got: Warning: date() [<a href='function.date'>function.date</a>]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for 'PDT/-7.0/DST' instead in /Library/WebServer/Documents/FMWebFrameDemo/application/ui-template.php on line 127 so I added date_default_timezone_set('America/Los_Angeles'); to settings.php, although I realize you may just expect developers to do that on their own sites anyway.) PHP 5.3.28 on OS X Just thought you might like to know. Thanks for building this! Best, -Joel
  15. FMWebFrame: FYI PHP Notices/Warnings

    Hi TIm  You asked for any other warnings. I just got these when testing on Windows Server 2008.  The file did upload (although with the .html issue mentioned in my other thread)  Perhaps a forward/backward slash issue?  -Joel Â
  16. EasyCalendar Initial Comments

    Hi TIm It seems like at least one problem is with the initializing of $$display_data. When I manually go to the EasyCalendar layout, I want to start things and load a month so I click one of the buttons at the top (e.g. rightArrow/NextMonth), and this ends up passing as the parameter a question mark ("?") -- and not a blank value(!) -- because $$display_data hasn't yet been set. So: IsEmpty ( GetValue ( Get ( ScriptParameter ) ; 1 ) returns 0 which in turn leads to the never ending loop. I'd thought the first time I'd had this problem (as I mentioned above) the script started running automatically as soon as I opened the file, but I can't be sure of that now and that hasn't repeated. -Joel
  17. CWP USER GROUP AT FILEMAKER DEVCON 2014 We're back! For the eighth straight year, people doing Custom Web Publishing are getting together at the beginning of the FileMaker Developer Conference to share projects, tips and ideas. DATE: Monday, July 28 TIME: 4:00 - 6:00 p.m. (before the 6:30 keynote) ROOM: Iris This will be a friendly, informal chance to share some of what we have been doing with FileMaker and CWP. All web-related tools and technologies are relevant (except WebDirect :-P ). Please contact me if you have something you'd like to share or ideas to discuss. Everyone's welcome. Come join us! -Joel http://jsfmp.com/cwp-user-group ~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro : database design : web development http://jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~
  18. Just a week away! Please note the NEW ROOM: Flicker 1-2 -------------------------------------------------------------------------------------------- CWP USER GROUP AT FILEMAKER DEVCON 2012 For the sixth straight year, people doing Custom Web Publishing are getting together at the beginning of the FileMaker Developer Conference to share projects, tips and ideas. This year's DevCon has only one (only one!) regular session that addresses CWP, so come get your CWP groove on at this year's CWP User Group meeting. DATE: Monday, July 16 TIME: 4:00 - 6:00 p.m. (before the 6:30 keynote) ROOM: Flicker 1-2 <<= New Room This will be a friendly, informal chance to share some of what we have been doing with FileMaker and CWP. All web-related tools and technologies are relevant. This year we may see some FM12 media streaming, RESTful development, CSS preprocessing, "google-style" searches, LDAP/TS integration, an FM-based web-development framework, and more! Everyone's welcome. Come join us! http://jsfmp.com/cwp-user-group -Joel ~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro : database design : web development http://jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~ http://twitter.com/jsfmp
  19. Just a week away! Please note the NEW ROOM: Flicker 1-2 -------------------------------------------------------------------------------------------- CWP USER GROUP AT FILEMAKER DEVCON 2012 For the sixth straight year, people doing Custom Web Publishing are getting together at the beginning of the FileMaker Developer Conference to share projects, tips and ideas. This year's DevCon has only one (only one!) regular session that addresses CWP, so come get your CWP groove on at this year's CWP User Group meeting. DATE: Monday, July 16 TIME: 4:00 - 6:00 p.m. (before the 6:30 keynote) ROOM: Flicker 1-2 <<= New Room This will be a friendly, informal chance to share some of what we have been doing with FileMaker and CWP. All web-related tools and technologies are relevant. This year we may see some FM12 media streaming, RESTful development, CSS preprocessing, "google-style" searches, LDAP/TS integration, an FM-based web-development framework, and more! Everyone's welcome. Come join us! http://jsfmp.com/cwp-user-group -Joel ~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro : database design : web development http://jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~ http://twitter.com/jsfmp
  20. CWP USER GROUP AT FILEMAKER DEVCON 2012 For the sixth straight year, people doing Custom Web Publishing are getting together at the beginning of the FileMaker Developer Conference to share projects, tips and ideas. This year's DevCon has only one (only one!) regular session that addresses CWP, so come get your CWP groove on at this year's CWP User Group meeting. DATE: Monday, July 16 TIME: 4:00 - 6:00 p.m. (before the 6:30 keynote) ROOM: Splash 1-4 This will be a friendly, informal chance to share some of what we have been doing with FileMaker and CWP. All web-related tools and technologies are relevant. This year we may see some FM12 media streaming, RESTful development, CSS preprocessing, "google-style" searches, LDAP/TS integration, an FM-based web-development framework, and more! Please let me know if you have something you'd like to share or ideas to discuss. Everyone's welcome. Come join us! http://jsfmp.com/cwp-user-group -Joel ~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro : database design : web development http://jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~ http://twitter.com/jsfmp
  21. CWP USER GROUP AT FILEMAKER DEVCON 2012 For the sixth straight year, people doing Custom Web Publishing are getting together at the beginning of the FileMaker Developer Conference to share projects, tips and ideas. This year's DevCon has only one (only one!) regular session that addresses CWP, so come get your CWP groove on at this year's CWP User Group meeting. DATE: Monday, July 16 TIME: 4:00 - 6:00 p.m. (before the 6:30 keynote) ROOM: Splash 1-4 This will be a friendly, informal chance to share some of what we have been doing with FileMaker and CWP. All web-related tools and technologies are relevant. This year we may see some FM12 media streaming, RESTful development, CSS preprocessing, "google-style" searches, LDAP/TS integration, an FM-based web-development framework, and more! Please let me know if you have something you'd like to share or ideas to discuss. Everyone's welcome. Come join us! http://jsfmp.com/cwp-user-group -Joel ~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro : database design : web development http://jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~ http://twitter.com/jsfmp
  22. Hello all I'm proud to officially announce my FileMaker & Custom Web Publishing blog: F 'n' web - FileMaker 'n' the web: lessons learned http://blog.jsfmp.com I’ve been developing websites with FileMaker and PHP since 2005 (& with CDML long before that). My first PHP sites were built with FX.php and now I tend to use the FileMaker API for PHP more often. Over time I’ve added more and more tools to my toolkit, especially JavaScript (mainly jQuery) and CSS, and I love keeping up on new trends in web design and development. I've learned some interesting things along the way and wanted to share them. The blog actually launched two months ago, but so far I've only announced it on twitter and at the CWP User Group meeting at DevCon 2011. I've recently posted my demos from the User Group as requested, and now I'm releasing them all to the world. I'll continue to tweet about new posts (follow me @jsfmp) or you can subscribe to my rss feed. Here's what I've got up so far: Responsive Web Design, and possibilities for data-heavy sites http://blog.jsfmp.com/post/9896553612/ Make your AJAX calls friendlier with the jQuery BlockUI Plugin http://blog.jsfmp.com/post/9614792264/ Creating relationships on the fly in one FileMaker PHP query http://blog.jsfmp.com/post/9558664762/ Quick ’n’ easy UI improvements - Part 2 (Buttons & Drop-downs) http://blog.jsfmp.com/post/9261227813/ Quick ’n’ easy UI improvements - Part 1 (Checkboxes & Radio buttons) http://blog.jsfmp.com/post/9259799287/ Showin’ some TextMate love (a code-completion video) http://blog.jsfmp.com/post/8152325944/ jQuery Date Validation (valid dates that are really valid dates) http://blog.jsfmp.com/post/7888992470/ Edit multiple FileMaker PHP records waaay faster via portal http://blog.jsfmp.com/post/7642665075/ Or to see just what I presented at the CWP User Group at Devcon: http://blog.jsfmp.co.../CWP_User_Group And plenty more to come... -Joel ~~~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro : database design : web development http://www.jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~~~
  23. CWP USER GROUP AT DEVCON 2011 It's our 5th Annual meeting at DevCon! Come show us what you've been working on! For the fifth straight year, people doing Custom Web Publishing with PHP are getting together at the beginning of the FileMaker Developer Conference to share projects, tips, and ideas. (formerly called "PHP User Group", but we focus on so much more than just PHP ;-) DATE: Tuesday, August 2 TIME: 4:00 - 6:00 p.m. (before the 6:30 keynote) ROOM: Sapphire 410 This will be a friendly, informal chance to share some of what we all have been doing with FileMaker and CWP. All web-related tools and technologies are relevant. Show us one of your projects. Demo a cool app that helps with your development. Bring us a challenge to solve. Impress us with some JavaScript, AJAX, Mobile, CSS3, HTML5, PHP… Please CONTACT ME if you have something you'd like to share or ideas for us to discuss. Everyone's welcome. Come join us! FileMaker CWP User Group at DevCon 2011 -Joel ~~~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro : database design : web development http://www.jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~~~ contact (at) jsfmp (dot) com
  24. CWP USER GROUP AT DEVCON 2011 It's our 5th Annual meeting at DevCon! Come show us what you've been working on! For the fifth straight year, people doing Custom Web Publishing with PHP are getting together at the beginning of the FileMaker Developer Conference to share projects, tips, and ideas. (formerly called "PHP User Group", but we focus on so much more than just PHP ;-) DATE: Tuesday, August 2 TIME: 4:00 - 6:00 p.m. (before the 6:30 keynote) ROOM: Sapphire 410 This will be a friendly, informal chance to share some of what we all have been doing with FileMaker and CWP. All web-related tools and technologies are relevant. Show us one of your projects. Demo a cool app that helps with your development. Bring us a challenge to solve. Impress us with some JavaScript, AJAX, Mobile, CSS3, HTML5, PHP… Please CONTACT ME if you have something you'd like to share or ideas for us to discuss. Everyone's welcome. Come join us! FileMaker CWP User Group at DevCon 2011 -Joel ~~~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro : database design : web development http://www.jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~~~ contact (at) jsfmp (dot) com
  25. Inserting records into Filemaker

    Hi SFDonovan As ttread said, you can push a whole array at once into FM -- as long as the keys in the array are the FM field names. So you might even be able to use the $row array if the field names match, but make sure there are no keys in the array that are not on the layout. You can also set fields individually, as you'd suggested: $arr_data = array('quiz_id' => $quiz_id, 'quiz_name' => $quiz_name); $newAdd = $fm->newAddCommand('layout_name', $arr_data); $newAdd->setField('otherFieldName', $otherFieldValue); $result = $newAdd->execute(); HTH, -Joel ~~~~~~~~~~~~~~~~~~~~~~~ Joel Shapiro FileMaker Pro database & web design http://www.jsfmp.com 415-269-5055 ~~~~~~~~~~~~~~~~~~~~~~~
×

Important Information

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