Netherlands

4 days / 26 talks
Awesome and great speakers

October 5-10
https://i0.wp.com/www.omnisworld.co.uk/wp-content/uploads/2016/02/DougEasterbrook.jpg?fit=320%2C320&ssl=1
…

Doug Easterbrook

Studio and Postgres are part of the software stack used by Arts Management Systems. We’ve expended a great deal of effort to make a high availability, high performance application capable of millions of daily transactions. Our ticketing software, Theatre Manager, has sold events like Elton John, Bob Dylan, Phantom of the Opera, Hamilton, Miss Saigon, Shania Twain, Book of Mormon, curling, hockey, basketball and much more.

Doug designed the first version of Theatre Manager using Omnis 3.3+. The ever increasing need for performance, capacity and resilience led to Postgres, workers, performance testing, tool creation and continuous application improvements through to Studio 11.2.

For over 3 decades, Arts Management Systems has proudly to contributed ideas, technology, tools and thoughts to the Omnis Community in many areas – and – learning something new at every Euromnis to bring back into their software.

Click. Open. Act. Activating your Omnis app with URL schemes

Links are a common way to open documents, files, tools, videos, websites, email applications, or phone someone. Many of us are familiar with tel:, mailto:, and https:. You can make a custom URL scheme for Studio to simplify automating business processes.

Imagine embedding links in an Omnis report and emailing them to a business associate or client. Those URL’s can:

  • open a Studio application (if it’s not already open),
  • log you in (if you’re not already), and then
  • open a specific data record inside Studio (if you have permission).

Some useful examples are:

  • Emailing a client an invoice (PDF) which they return with a bank transfer. Clicking the invoice number on the PDF then opens Studio to a payment window for the specific order to entering payment details, eliminating navigation.
  • Clicking on a client in an ‘action-item’ report of the top 10 recent support requests or sales prospects to see all the data.
  • Nagios registeres services of a clientare down: with a link you added, you can directly open the data of the client so you can respond quickly
  • Bug report in Sentry: With a link you included you can directly open a method editor in Omnis at the position where the issue is triggered.

What you’ll learn:

This session will show you concepts using links in reports to access data from the database. This includes

  • what the links look like
  • how to process them
  • making the links work within a report
  • making links that will open Omnis to the specific data from the OS, browser, URL, eblast, or any web page
  • addressing logging in, if Omnis is opened from scratch
  • addressing security, should the user not be permitted to access the data.
  • discussing some ancillary use cases for this idea

Why you should attend:

The implementation combines use of features that have existed in Studio for a long time, in conjunction with a new capability in Studio 11.2 that permits adding links external to Omnis.

This session provides the how-to to let you access a path to data in your application, especially if it is not open, using URL Schemes

Global Time, Local Precision: Time Zone Awareness in your application

Using features of Postgres to make your application time zone aware

This topic will demonstrate how easy it is to make your application time zone aware. This could be especially useful of you have offices in multiple time zones, travel for work, need to have global calendaring, enable time-based sales and discounts online, time synchronize logs from multiple systems (eg for purposes of PCI or regulatory compliance) and more.

The topics include all you need to do such as:

  • Settings for time zone support within the Postgres server
  • Retrieving a list of valid time zones that Postgres supports
  • A one-time Database conversion process
    • Time zone fields
    • Options and ramifications
    • Database defaults for new data
  • Possible Changes to your application
    • Meaning of some built in Postgres date functions
    • Data retrieval in foreground & background
      • Implicit time zone fetches and session variables
      • Explicit time zone fetches
      • Mixing time zones in your data for retrieval
    • Determining your computer time zone if you want to make changing automatic based on locale
Make

Connection

Follow Doug
Meet

Company

About workshops

Format

You’ll sign up for the session you want to attend on a first-come, first-served basis. Up to 6 participants may attend a session, if full, you can sign up for the same topic at a different time. During the session, the speaker will guide the audience through the main topic but you will be able to ask him/her to deviate and cover related areas. Sometimes participants offer new ideas and solutions to a problem.
Check the

Speakers

Pursue any question or area not directly related to the core topic. Every speaker hosts at least 4 sessions which means there are about 11 to 12 simultaneous sessions running all the time with an average of 5 or 6 participants
Meet the Speakers
Check the

Schedule

Flexible conference format means you can choose the best classes for you and at the best time. Some sessions will be repeated, so when you miss one, you can attend the same session later in the day or the week.
Check the Schedule