Tim Anderson

Thanks Chuck, I am sure this will be a great resource for many

I disagree Wim, this is exactly what FileMaker Server 12 will do for Joseph. If the container is set to Store container data externally then dragging a pdf to the container will make it available to everyone via FileMaker, no mounting of the server required and available to anyone (df you want) who can connect with FileMaker. The only potential downside is that the pdfs will not be available without FileMaker, that is often an upside! Set the container to interactive content when viewing and all can be done within FileMaker, or have a script to export to the temp folder and open to view in a pdf viewer.

Using FM12 and the container field set to Store container data externally then yes. You also need to set the data formatting to Interactive in the Inspector. Sorry - just reread and saw the 'network drive' - don't think that is supported.

Jeremy Not had any problems doing this creating plugins for both Mac and Windows on my Mac, admittedly using earlier versions. Silly question time, when you created the plugin you did create both, and were asked to find the plugin for the platform you were not on at the time? Tim

Hi Rob, No, not tested OmniPlan, sorry! I don't think what you describe will work. You will get an alarm for the Project, not for the person - I think! In my scenario each user has their own Calendar (filtered) and so can get their own reminders. There may be a way to do what you want with some clever filtering - concatenating the projectID and the userID for example. If you get stuck ask a question on SeedCodes support forum. (http://www.seedcode.com/support/) Both John and Jason very smart and helpful - as you will see from their responses. Good luck Tim

Hi Rob, I have a couple of clients using Zulu. We have not found a practical way round the problem you describe when creating an event in iCal, so all events are created in FileMaker and iCal is used for reminders, rescheduling and completion. Zulu handles new events in filtered calendars as you would hope, by including the filtering criteria - so the answer to your question is yes. ``download a copy and play with it. Sorry I didn't respond earlier but only just read your post, hope you get a great solution Tim

I create and print Barcodes using the ScriptMaster Plugin http://www.360works.com/

The ScriptMaster plugin does not appear to work on FMS12. Using 4.131. Same plugin, same setup working fine on FMS11. Works great on FMPA12 I am guessing that this is due to the new separate processes in 12 and that 360 Works know about this and a new version, along with some new modules (bar codes) will be released real soon! Maybe spoke too soon - the problem could have been that the opening script is no lounger called from Server 12 - thanks 360 Works for your email!

Thanks Steven, very useful and vital to read through before we go live with Server 12

Especially if the web viewer is small

Interesting. Don't suppose you plan on continuing testing to see how long the statement can be? :smile3:

Also you are defining the path to a folder, not a file, in the 'from' path

Wow, some length of SQL statement!

I'm guessing, as it will be in a calculation, 30,000 characters in total

Try replacing 'http://' with 'file:///'

Thanks Dan, So the 'array' option would be used If I wanted to (and knew how to!) perform further manipulations on the returned data. Anyone recommend any good learning materials?

I have been using the Execute SQL function with very simple statements for create, update and select for a year or so and enjoying the benefits. But I have one simple question that I am sure those with a ore than basic level of SQL knowledge will be able to answer: What is the difference between Execute SQL and Execute SQL Array? Surely if the statement in an Execute SQL command returns more than 1 record and has more than 1 field then the result is a two-dimensional array as described in the Execute SQL Array notes in the ScriptMaster demo file? Thanks for anyone talking the time to explain the difference. TIm

If you create a table occurrence of the other file in your schema then you can do this.

You need to specify the table occurrence to insert into, such as INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...) I should add I keep this site bookmarked for refence http://www.w3schools.com/sql/default.asp Tim

Yes

Ryan, I have seen no difference in the example file (could be wrong), so just download, discard the ScriptMAster.fp7 file and use the new plugin Tim

I Used to use AppleScript to do this, now I don't have to spend the time playing around and thanks to Zulu I don't have to. I strongly recommend you download a demo copy and see how easy it is. Cross platform too!

Ok, thanks David. I guess there is a lot on the to do list with Docubin recently released

Any news of a way to get this working yet David? Thanks Tim

Can I ask a question here! Does this mean that is the ScriptMaster plugin is in the Plugins folder in the wpc folder on FMS then the functions will work without being installed on the client machines? Seems unlikely but great if that is the case! Tim