I finished this up a few weeks ago & forgot to post.I went further than intended & did a full inventory of all spinning/weaving/knitting equip, books, videos, fibre, yarn (commercial & handspun) into Airtable. Absolutely love it! #RavelryAccessibility#OffRav /1
I'm enjoying this way more than my original Ravelry data - I can customize it to emphasize what's important to me. Oh yeah, & no migraines. Just patterns left to do now. Those will take some time though but at least no more photos to take.😎 #RavelryAccessibility#OffRav /2
Here's what grid (database) view looks like. You can do formulas & lookups from other tables, etc. It's more powerful than what the data looked like in raw form. I won't lie-it was lots of hours to get to this point but #RavelryAccessibility#OffRav /3
I did more than planned & I think it was worth it because I use it more than I ever thought I would. For this I.T. person, it was a small learning curve. I do believe that Airtable is easy enough for people without IT background to learn too. #RavelryAccessibility#OffRav /4
In the end, the only thing I lost was favorites because of how the data was saved in the DB dumps we were provided from Rav (as below). I'm choosing to see it as a forced fresh start. #RavelryAccessibility#OffRav /5
Done with Airtable after their latest changes and massive layoffs of their small accounts staff. #offrav #RavelryAccessibility Investigating self-hosting my data. /1 forbes.com/sites/stevenbe…
Tried nocodb, it's pretty good - an almost direct replacement for Airtable - but don't have more than one photo in the gallery view main image field or it may also cause vestibular disturbances. #offrav #RavelryAccessibility /2
Landed on Grist (@getgrist) - in no small part because the name amuses this fibre artist - and while missing a few features to be a direct replacement (gallery view, reciprocal relations), I'm hoping to be able to maybe add some of those features #offrav #RavelryAccessibility /3
It just took me 2 days to get my very small amount of Ravelry data into a format I could usefully import into Airtable. It's not a fun job. The data dump is a shit show. Separate json files for each entry, at least 6 different table structures for #RavelryAccessibility /1
favorites & it didn't appear to save what I thought it did. (Publication, not pattern is saved unless I missed it totally.) Super jumbled & extraneous information in each table. I have a computer programming diploma and it took this long to clean up #RavelryAccessibility /2
about 1000 entries (mostly favorites). Now that it’s in Airtable, the final cleanup is about half done after a 3rd day. I must say that as the cleanup is finishing up, the data is beautiful to look at again. #RavelryAccessibility /3
Statistically impossible. If only we could close our CRA accounts! Between this and StatsCan "legally compelling personal financial information, the Canadian government needs to do better. A lot better.
"These user IDs and passwords were not compromised as a result of a /2
breach of CRA’s online systems, rather they may have been obtained by unauthorized third parties and through a variety of means by sources external to the CRA. The total number of accounts impacted is roughly 800,000" /3