Something went wrong. Try again.
[READ-ONLY] Mirror of https://github.com/autonome/bugzilla-to-airtable. This project takes bugs from Bugzilla and inserts them as tasks in A bugzilla-to-airtable.glitch.me
Something went wrong. Try again.
Files
- JavaScript 45%
- HTML 44%
- CSS 11%
README.md
Bugzilla to Airtable #
This project takes bugs from Bugzilla and inserts them as tasks in Airtable.
Prerequisites #
Airtable info:
- API Key
- Available from your Account page
- Base id
- Go the your API page, which was linked from your account page above
- Click the base you want to work with
- The base id is in the URL of the page that loads, eg: https://airtable.com/app8eGNFp6w6us51D/api <- that code inbetween the slashes is your base id
- Project id
- Go back to your Airtable, and click on the project you want your bugs added to
- The Airtable URL will be something like: https://airtable.com/asdfasf/asfadfsdf/asfdasfasdf
- Your project id is the third value in that url, after the final slash
- Airtable email
- Whichever email you log into Airtable with
Bugzilla info:
This is easy - just create a search on Bugzilla, and copy the URL for it. The only limitation is that it only works for public data.
Configuration #
Open the .env file, and add the following lines, and populate the values with the configuration values you gathered above.
- AIRTABLE_API_KEY=12345678
- AIRTABLE_BASE_ID=12345678
- AIRTABLE_PROJECT_ID=12345678
- AIRTABLE_EMAIL=your@airtable-account-email.com
- BUGZILLA_SEARCH_URL=""
Operation #
The path /update will check Bugzilla, and add new tasks to Airtable, but only if there's not a task in the base that already has that bug id in the title.
For example, if you remix this Glitch and your project is named "laundry-carnival", You can trigger an update by visiting:
https://laundry-carnival.glitch.me/update
I use cron-job.org to periodically open the URL.
That's it!
Made with Glitch #
\ ゜o゜)ノ