As we step into 2024, we're excited to invite you to a highly anticipated meetup! It's an opportunity for those interested in data management innovations to gather and explore the latest advancements. Ian Ward & Patrick Little from the open.canada.ca at Government of Canada will be showcasing TableDesigner, a game-changing tool for data management in CKAN. Discover how to create custom data schemas, utilize auto-generated Excel templates, and manage data more efficiently in CKAN!
🔥 About TableDesigner
TableDesigner is an innovative new feature for CKAN developed by Government of Canada, designed to enhance data management. It revolutionizes the traditional data dictionary into a dynamic schema creation tool, introduces user-friendly Excel forms for data input, and incorporates audit features for tracking data modifications. Focused on ease in editing, validation, and deletion, it offers extensive customizability to meet diverse data needs, marking a significant step in efficient and reliable data governance.
💎 Key Features of TableDesigner:
TableDesigner allows users to create custom, enforced data schemas, particularly useful for data that frequently needs updating. It supports interactive schema building, data loading through Excel templates, web forms, or API. Unique in its approach, Table Designer operates on the datastore extension with a PostgreSQL backend. It draws inspiration from existing data schema strategies and allows for more flexible, resource-level schema design.
This tool introduces a new method for CKAN resource creation, enhancing the data dictionary and adding functionalities for more precise data control and validation.
🎯 Why Should You Attend?
This webinar is essential for anyone involved in data management, offering insights into using TableDesigner effectively. Learn about:
- How to leverage TableDesigner for efficient, dynamic data management
- Strategies for creating and updating data schemas interactively
- Techniques for using Excel templates, web forms, and APIs for data manipulation
- Insights into TableDesigner's integration as a core extension in CKAN
💡 In his presentation, Ian and Patrick will cover:
- Using TableDesigner to build a custom data schema
- Inserting/updating/deleting data with a web form and Excel
- Extending TableDesigner column types and constraints
- Ian Ward
CKAN Tech Team Lead at CKAN Project & Software Developer for open.canada.ca at Government of Canada
Python and Open Source software developer with 10+ years of CKAN experience
- Patrick Little
Data Analytics Lead for open.canada.ca at Government of Canada
Working at the intersection of tech and business to support all things Open Data within the Government of Canada
- How to connect
- Date: Wednesday, January 17, 2024
- Time: 13:00 UTC
- How long: 60 mins
- Language: English
- Reserve your spot here.
Google Meet joining info
- CLICK HERE to join with Google Meet
- Or dial: (BG) +359 2 907 4153 PIN: 492 965 761#
- More phone numbers here
- Welcome and introductions – 10 min
- Presentation from open.canada.ca – 30 min
- Discussion / Q&A – 15 min
- Community announcements and sharing (if any) – 2 min
- Closing – 3 min
You can have a look at the [CKAN Monthly Live] Meeting Doc. Feel free to add items and things you’d like to discuss to the agenda.
Don’t forget to share your experience by using #CKANMonthlyLive!
We look forward to seeing you all on CKAN Monthly Live!