{"id":501,"date":"2021-06-24T22:51:48","date_gmt":"2021-06-24T22:51:48","guid":{"rendered":"https:\/\/blog.directimpact.test-idi.ca\/?page_id=501"},"modified":"2025-09-05T01:53:17","modified_gmt":"2025-09-05T01:53:17","slug":"a-filemaker-custom-application-for-dgc","status":"publish","type":"page","link":"https:\/\/www.directimpactsolutions.com\/en\/case-studies\/a-filemaker-custom-application-for-dgc\/","title":{"rendered":"DGC"},"content":{"rendered":"
<\/path><\/svg><\/div>
<\/div>\n\n

FileMaker Case Study<\/h1>\n\n

National Organization\/Film Industry<\/p>\n\n

<\/div><\/div><\/div>
<\/div>

<< View all case studies <\/a><\/strong><\/p>

Directors Guild of Canada Case Study<\/h2>\n\n

The\u00a0Directors Guild of Canada (DGC)<\/a>\u00a0is a national labour organization that represents over 4,800 key creative and logistical personnel in the screen-based industry covering all areas of direction, design, production and editing.<\/p>\n\n

The Client<\/h3>\n\n

As a national organization, using two separate Microsoft Access databases and a PHP\/MySQL website to manage data of members in multiple offices across the country, DGC needed a new integrated data solution. The DGC chose the FileMaker platform to develop this new solution, as some of its employees had a positive opinion of it from experience gained in other similar organizations.<\/p>\n\n

In the technology planning, DGC planned to replace its obsolete website with a platform that would better meet its current needs and provide greater security. The main challenge in selecting a platform was to ensure that their public website was linked to the internal database managing its members. Both systems had to be integrated and secured at the same time.<\/p>\n\n

The Project<\/h3>\n\n

Direct Impact Solutions created a custom FileMaker<\/a> back-office application that manages day-to-day operations, along with a website offering public and private content linked to a real-time FileMaker database. Both applications are hosted on a virtual and secure dedicated server, accessible by all district councils across Canada.<\/p>\n\n

The Benefits<\/h3>\n\n

The solution helped DGC to harmonize its processes in all district councils and to allow the National Office to share common data between boards. This shared data structure allows DGC to analyze centralized data for all District Councils at the same time. All boards share the same platform, allowing district councils to work more effectively and collaborate better.<\/p>\n\n

The solution provides several benefits:<\/p>\n\n