[adminKeymaster]

Our 5-minute integration includes copying scripts and a layout object into your solution. Please let me know if you have any problems running that.

http://www.sosimplesoftware.com/products/calendar-documentation/how-to-guides/five-minute-integration-server-powered/

Thanks

[adminKeymaster]

Hi Barbara –

The file “soSIMPLE Calendar” comes with developer level access once you purchase the product.

You can evaluate full functionality with that file, and you can do a complete integration with your own file using our 5-minute integration method, even before purchasing.

http://www.sosimplesoftware.com/products/calendar-documentation/how-to-guides/five-minute-integration-server-powered/

[adminKeymaster]

Hi Germain –

You helped us discover a long-standing bug in FileMaker:

With a file set to “Always Use File’s Saved Settings”, the getasdate() function should use the format mm/dd/yyyy for files stored that way. However, when using the FMP:// protocol to set a variable, the getasdate() function does not work as expected.

The workaround is to set the same variable using setastext() before setting the variable using setasdate().

For our soSIMPLE Calendar file, this means adding two steps to the beginning of the soSIMPLE Action script (see attachment). Add them after “set variable [$url]…”.

Our new release (posted already) includes this change.

Attachments:

You must be logged in to view attached files.

[adminKeymaster]

Hi Germain –

Have you had a chance to look at this again? I saw in another message from you that you are using the soSIMPLE Calendar file. Let me know if the fix I recommended worked for you.

To help us follow up:
– what country are you in?
– what date format do you use?
– have you tried the fix in our link?

Thanks

Ken

[adminKeymaster]

Thank you for reaching out to us.

What file are you opening? You should make sure you’re using “soSIMPLE Calendar”, not one of the example files. We will be removing the example files from future builds – they were intended as practice files to go with our 5-minute integration tutorial.

Make sure when you open soSIMPLE Calendar, that it’s in the same folder as “soSIMPLE Calendar Settings.”

This should work fine for all nationalities, so I’m assuming you’re using the wrong file. Let me know if you’re experiencing this on the soSIMPLE Calendar file, or refer to this article:

http://sosimplesoftware.com/forums/topic/non-american-date-format/

[adminKeymaster]

That sounds like it will work fine.

The office administrator can even have a single calendar that includes everyone, and add events to that. The “Show only records” setting in soSIMPLE can then limit the manager’s calendars to their own data very securely.

This is fine for a handful of managers. There are other options if it becomes burdensome to create and manage multiple soSIMPLE calendars.

Ken

[adminKeymaster]

Hi there –

1) There is no built-in way to prompt for a password when subscribing to a sosimple calendar. It’s a bit of a hack, but you may be able to do this by setting up authentication on your server. How do it is more than we can explain here, but these resources might be helpful:
http://httpd.apache.org/docs/current/howto/auth.html
https://technet.microsoft.com/en-us/library/cc733010(v=ws.10).aspx

Alternatively, we can probably develop some custom code to do this. Please reply using “private reply” if you’d like us to estimate this option for you.

2) There are several ways to filter events on the calendar. The same filters that you use within FileMaker Pro or on our web-based implementation, also apply to iCal filters. See “Server Powered Mode” here:
http://paradisepartners.com/products/calendar-documentation/calendar-builder-reference/adjusting-your-calendar/filter-events-on-your-calendar/ and
http://paradisepartners.com/products/calendar-documentation/calendar-builder-reference/adjusting-your-calendar/filter-events-on-your-calendar/server-powered-url-filtering/

3) Yes, unsubscribes happen by the end-user (e.g. the Google Calendar user)

[adminKeymaster]

By “side bar” do mean the calendar navigation? You can remove them in the Calendar Settings “Layout” section. The first row says “Calendar Navigation”. Changing that to “None” will remove the mini-calendars.

If you’re talking about the filter bar and settings bar in the soSIMPLE Calendar file – those are part of the FileMaker layout, not part of the web viewer. You can remove them simply by deleting them in layout mode.

[adminKeymaster]

Hi there.

Thanks for looking at soSIMPLE Calendar.

It’s very easy to filter by any field. Just add the field and value to the url in the Web viewer.

http://paradisepartners.com/products/calendar-documentation/calendar-builder-reference/adjusting-your-calendar/filter-events-on-your-calendar/

We don’t have anything built into the calendar that lists unscheduled events in a portal. But it would be easy to add that to your layout next to the Web viewer that contains the calendar. By adopting similar styles, you could make it look very clean and unified.

Using that method, You’d move undated events to the calendar by clicking and editing the event, adding date and time, then refreshing the calendar to show it.

We can add the portal and drag and drop functionality to the calendar, too, just as you describe it. We have considered something just like this in the past. It would show the undated events similar to a portal, or like the grid view on the soSIMPLE Calendar. Dragging into any view on the main calendar would add date and times to the event.

Let me know via private reply, if you would like an estimate for this.

Thanks again.

[adminKeymaster]

Hi Matt-

I haven’t seen this happen. We have done testing in that same configuration.

Does WPE crash when viewing the same calendar in your solution (instead of in the settings file)?
Are those plugins server-side? Have you tried disabling them?
Is this a developer version of FMS (with the 3 connection limit)?
Have any updates been made to the server OS (such as Java)?
Do you have the flexibility to do a clean install of Server?
Are other things (pages/webdirect) hitting the web publishing engine?

[adminKeymaster]

There are two answers to that question:

1) Most routers will recognize the external address even if you’re inside the network. So you can use the external IP address whether you’re inside or outside the network.

2) Some routers don’t. So you must use a calculation in your webviewer.

See this post for more details:
http://www.paradisepartners.com/forums/topic/php-error-when-accessing-calendar-outside-the-local-network/

[adminKeymaster]

The recap is correct.

To followup on the $text variable – this follows the same logic. soSIMPLE is only including variables that can be changed from the calendar. Since the default web window and the inline event editor can only change the ($text variable) that is the only one we pass. Typically, the more detailed description field is calculated by your FileMaker solution, so it’s not useful to pass as a variable since it would have changed by the time the script step is run.

Instead use your FileMaker field to get the description.

[adminKeymaster]

Hi –

I’ve had a chance to look over your post, and run some tests. The script seems to be running as expected.

The design of the script is to provide any variables that you might need when editing or creating an event in the web viewer. The script runs server-side right after the record is created or edited in FileMaker. soSIMPLE passes all the data that is potentially generated from the calendar, or identifies the event in the calendar.

However, since the record is the current record in FileMaker when that step is executed, you can get the data from the current record on that script step by passing the field name directly. When we edit existing events ($event_type=”edit”), the $event_id will match what’s in your database. When we create a new event, the $event_type=”new” and the $event_id is a random ID from soSIMPLE. Once the event is written to your FileMaker file, the event id field is changed to your event id. To get that ID, you pull it from your own record like this:

"event_type: " & $event_type & ¶ & 
"event_id: " & $event_id & ¶ &
"new id: " & calendar_data::Event_ID & ¶ &
"from: " & $from & ¶ & 
"to: " & $to & ¶ &
"from_utc: " & $from_utc  & ¶ &
"to_utc: " & $to_utc  & ¶ &
"text: " & $text &  ¶ &
"unit: " & $unit & ¶ &
"readonly: " & $readonly & ¶ &
"script: " & $script & ¶ &
"url: " & $url & ¶ &
"untimed: " & $untimed & ¶ &
"lat: " & $lat & ¶ &
"lng: " & $lng 

Likewise for other fields such as the description.

You can also break out the timestamp field by using:
getasdate($from) and getastime($from)

For other fields:
$unit will show whatever data is stored in your resource field. If you use IDs for the resources, that’s what will be passed. You can get the resource name from your FileMaker record.
$url is intended to show what’s after the #hashtag on the url. It can be used to redraw the web viewer on platforms that can’t read it directly from getobjectproperties(). It doesn’t appear to be passed server-side – we’ll look into this.
$from_utc and $to_utc should show the UTC mean time for the $from & $to variables. They don’t appear to work server-side either – we’ll look into those.

Please let me know if this helps, or if you have any other questions.

Thanks

Ken

[adminKeymaster]

Hi there –

We have been busy at DevCon this week – we’ll take a look at this in the next couple of days and let you know what’s happening.

Thanks

Ken

[adminKeymaster]

Hi Soren –

We have not tested soSIMPLE v2 in FileMaker 15, and have no reported issues with v3, which has been out for over a year.

While the best thing to do is upgrade to the latest version of soSIMPLE, I seem to remember there was a reason you did not want to do that yet. A quick fix might be to make sure that the url is configured as https instead of http. If that’s not it, please tell me which checkbox is not being filled in.

Thanks

[adminKeymaster]

Dominick –

I also wanted to add that the port numbers required for forwarding are port 80 & 443 (web ports), and port 5003 (FileMaker).

[adminKeymaster]

Hi Dominick –

It’s not clear from your post whether you’ve configured your router for outside access. In order to access anything from outside your network, you have to instruct your router to redirect traffic to the FileMaker Server.

On the Zyxel C1100 this called Port Forwarding, and is listed on the Advanced tab. I found this guide which may be helpful.
http://portforward.com/english/routers/port_forwarding/ZyXEL/C1100Z/defaultguide.htm

Once you’ve completed the port forwarding and depending on your router, you may have two separate IP addresses for the calendar – one from inside the network, and one for use outside the network. Using the FileMaker function get (hostipaddress), as shown in this thread, will always show you the IP address you’re using to connect to FileMaker Server, whether you’re inside the network or outside the network.

[adminKeymaster]

I’m not sure if you’re talking about soSIMPLE anymore, or just PDFs in general.

As far as soSIMPLE goes, you need to load the PDF-generating URL from the context of the calendar you’re looking at. It uses JavaScript to push the parameters to the php code responsible for generating the PDF. It doesn’t use MBS’s PDF function at all. So the short answer is, I don’t think there’s a way to auto-generate pdfs of a calendar on the server without additional PHP coding (which we can help you with if you’d like).

We are using MBS’s PDF functions for other solutions, however, and they’re very powerful. They all work server-side. I’m not sure if there’s an equivalent of FileMaker’s Print to PDF function, though, since that’s not what we’re using it for. From my quick look at their documentation, I don’t think there is an equivalent, but they’re very quick with email support, so I would recommend contacting them directly.

[adminKeymaster]

Hi John –

First, I wanted to make sure you’ve had a look at our tutorial on integrating soSIMPLE into your own solution:
http://www.sosimplesoftware.com/products/calendar-documentation/how-to-guides/five-minute-integration-standalone/

This method of implementation allows you to embed the calendar right into your own layouts. From there you can choose how sophisticated or simple you want your calendar by changing the layout and options in Calendar Settings.

If you like all the features of the starter file we provide (file named “soSIMPLE Calendar”) (resource selections, repeating events, filter by staff, etc.) you can also just link to that file instead of using the integration tutorial. Then everything’s been pre-built for you. Since that example is not integrated into your solution, you would have to choose how tightly integrated to make it. You can start by linking it just using a button, as you did. Further integration will require some development –

1. copy the web viewer to your solution
2. copy and paste the following scripts:
• soSIMPLE Startup Script
• Set Up Calendar ([calendar_id])
• Refresh Calendar ([calendar_id])
3. edit soSIMPLE Startup Script to make sure the correct calendar ID is being used (from soSIMPLE Calendar Settings)

Run the startup script once per solution. Then run the setup calendar or refresh calendar scripts anytime you want to draw the calendar. Double-clicking or dragging will open the event in the soSIMPLE Calendar file.

There are some more tweaks you’ll need to do to, such as hiding the soSIMPLE Calendar window and refreshing the calendar on your own layout after you create or update events. Perhaps we’ll put together a tutorial on this type of integration soon.

For using on the iPad, you can either copy both the files (Calendar and Settings) using iTunes or email (unzipped), or you can open them remotely, using your desktop as a host. See the following references:

http://help.filemaker.com/app/answers/detail/a_id/7754/~/transferring-files-with-filemaker-go

http://help.filemaker.com/app/answers/detail/a_id/7763/~/connecting-to-a-file-via-filemaker-go

[adminKeymaster]

Sorry, Debi – didn’t see this follow up request.

To hide the time in month view, requires a little custom code snippet. To add this code:

1. Open Calendar Settings
2. Select your Calendar
3. Click “Edit” next to Options
4. Scroll to the bottom where it says “Custom JS” and paste the following code:

   /* BEGIN HIDE MONTH DATE */
   scheduler.attachEvent("onTemplatesReady", function(){
   	scheduler.templates.event_bar_date = function(start,end,ev){
   		return "";
   	};
   });
   /* END HIDE MONTH DATE */

[adminKeymaster]

Yes – click “Use Simple Event Box” in Options.

[adminKeymaster]

Hi Debi!

So the issue you’re having is that the calendar doesn’t know the settings of the global field.

The global field is only for the current user in FileMaker. The events are searched directly from the server. So whatever you set the global field to in your current session, will not carry through to determine what events show on the calendar.

So what I would do is this:
– set the field called “ShowOnCal” to calculate to 1 when Daily record has ≥ 1 appointments.
– setup the data source to Only Show Records based on ShowOnCal.
– That will filter to show only valid daily records, but will show all offices.

Then:
– set the global field ( e.g. “selectedOffice.g” ) to the name of the office you want to show
– assuming the you have a field in the Daily record with the name of the office (e.g. “office”)…
– add this to the end of the url: "&office=" & selectedOffice.g
– this will append the global field as a filter to the events to only show the correct office.
– this filter happens on top of the already filtered daily records.

Let me know how that works.

Best,

Ken

[adminKeymaster]

Hi Ziggy –

Thanks for the question.

It looks like your approach makes the most sense for the strategy you’re using to schedule appointments. I don’t know you necessarily need a server-side script to create records for you, but having a join table (county, date) makes the most sense for drawing the calendar.

Then when you double click, you’d have a window showing a portal with the individual records in it.

I don’t know if you’ve taken a look at our new map view. It lets you see all your appointments for any given time period (day, week, month, etc.) on a Google map. It may help you visualize individual appointments by area.

A nice thing about soSIMPLE Calendar, is that you can quickly put together multiple calendars for multiple purposes. So you might have one that is a summary view by county, and another that’s more detailed, so can see individuals within a county.

BTW – are you in Rockland county, too? We have an office there.

Best,

Ken

[adminKeymaster]

I know we solved this together off-line, but the bottom line is that most routers should allow you to use the external IP address that you’ve set up on the router, from inside or outside the network. This router feature is called “NAT Loopback” and it has come to my attention that some routers don’t have this feature.

If your router has this feature, you might need to just turn it on. For more robust routers or firewalls, you might need to configure the loopback yourself.

In the meantime, the workaround is to change the IP address of the web viewer in your solution to point change which IP address it uses. If your set up on a single server, you can do this by making the web viewer a calculation like this:
"http://" & get(HostIPAddress) & "/sosimple/sosimple_cal.php?calendar=xxx.x..x...x.xxxxx.x.x"

[adminKeymaster]

Thanks for the update Jo. I’m glad you got it working.

We’ve seen this come up from time to time with developers, but rarely with end-users, because developers tend to install multiple versions of FileMaker on their system. This is why:

When you double-click an event, soSIMPLE uses the FMP: protocol to run the action script. That is it calls a url like: “fmp://x.x.x.x/your_solution?script=yourscript”.

Anytime you install FileMaker, the protocol preference is set up on your computer to open the version of FileMaker that’s being installed. So if you’re installing FMP14, the protocol will be set up to always open FMP14 (when opening an event in soSIMPLE for example). If you later open an already-installed FMP13, double-clicking one of your events might open FMP14. If you uninstall FMP14, then nothing will open. It sounds like that’s what’s happened to you.

There are workarounds to this that are good for developers to know about:
For Mac: RCDefaultApp
For Windows: Edit the registry for [HKEY_CLASSES_ROOT\FMP\shell\open\command] to point to the right installation of FileMaker.

Please always backup and be careful anytime you edit the registry.

[Author]

Posts