If this is your first visit, be sure to
check out the FAQ section. You will need to register
before you can post: click on "Login or Sign Up" above to proceed. Please note Project Blogs, Groups, and some forum areas are only visible to users who have confirmed their registration. Thank you, and enjoy your crafty day!
Did you know Amazon is an affiliate? By clicking through our affiliate link (the Amazon logo in this box) you are helping support FiberKind at no cost to you.
I had a thread going on the old site and it looks like my last post was right as we were switching over. So I am looking for volunteers to test out my JSON to Excel tutorial and let me know where there is room for improvement. My instructions are for Windows, Office 365. Here's a link, let me know what you think! Just tagging folks who commented on the old thread...
MissAnthropyKnits would you be able to e-mail me one of your json exports to ourunraveled@gmail.com ? If there isn't private information in there, I'd like to take a look at what it would take to be able to import them here at some point.
“The only thing necessary for the triumph of evil is for good men to do nothing." -- Edmund Burke
I had a thread going on the old site and it looks like my last post was right as we were switching over. So I am looking for volunteers to test out my JSON to Excel tutorial and let me know where there is room for improvement. My instructions are for Windows, Office 365. Here's a link, let me know what you think! Just tagging folks who commented on the old thread...
I had a thread going on the old site and it looks like my last post was right as we were switching over. So I am looking for volunteers to test out my JSON to Excel tutorial and let me know where there is room for improvement. My instructions are for Windows, Office 365. Here's a link, let me know what you think! Just tagging folks who commented on the old thread...
Just to let you know I am totally clueless about this JSON format. And I know that I can only export my data is I know how to use it. So I am begging you to keep us informed about what it is and how to use it! I am telling you old age is not for sissies!!!!
Old age does not keep you from doing a search! (I'm 68). https://www.w3schools.com/js/js_json_intro.asp
Basically, json format is just plain old text. It uses javascript formatting, so javascript can convert from text to javascript objects (which it can then display).
You can read the info from Rav using a plain old text file. But it's messy. I've been going through and pruning out the bits that I don't need. And that's time consuming. A converter would format this info for a spreadsheet. It still won't be as pretty as it displayed on Ravelry but will make the information easier to read and use.
Spindlitis I just wanted to get it all into table format to link in a database, rather than individual files that have to be read one by one. I'm not a VBA or Power Query pro, but I did end up with a final product that I like and is workable.
Just a quick update - my free trial of AirTable ran out, and though I like the UI, I don't love it so much that I feel the need to pay $20/month (billed annually upfront) for the ability to have more than 1200 records in one base. That's stash, fiber stash, projects, etc. - max 1200 records. My stash alone is bigger than that. So now I'm working on building an Access db, since I already have the software.
I spent some time yesterday transitioning the spreadsheet to a database. With the help of the form wizard, I had the majority of it done with a click of my mouse. Now, to figure out how to add a photo to each record and fine tune. Not as pretty, but functional is all that I really desire.
I meant to come back and post. Your instructions worked well. I had downloaded 2 different free trials for software that is supposed to convert JSON files, but you really had to be a coding expert to figure it out. Anyway, I got my library converted. I'm going to do my queue next.
Hey everyone! I learned something new today thanks to this JSON tutorial. I currently have all of my patterns stored on an external drive. I just have them organized in folders by type. Just like bringing in the JSON data from the folder, you can bring in other files from a folder and get them into spreadsheet format! It's fast because you don't have to go through all of the steps for the JSON. So I have a main folder called "patterns" and then a bunch of subfolders. Excel automatically extracted all of the files from those subfolders. I don't know how much my spreadsheet will help me right now, but if we end up with a way to store patterns here, it may save me some time later on.
Hey everyone! I wanted to share a new site I'm using to emulate some of the stash/project linking functionality that I miss from before. Notion is a free (up to a certain amount of data) tool that incorporates relational databases, notes, wikis, embeds, and all sorts of other cool stuff that I'm still exploring.
I set up a notebook that has stash and project storing capabilities. You can use your converted tables from your JSON extract to import as a CSV as well! I have a shell of the tables and instructions on how to copy my shell to your personal Notion workspace all set up if you are interested in giving it a shot but don't want to create a workspace from scratch!
If you want to try, I have to invite you via email. I swear I'm not a crazy person and I won't steal your email and use it for nefarious purposes. Forums here are semi-public though, so I would recommend PM'ing me your address for an invite.
Here are a couple of mobile screen shots of what the app looks like. It is available as a web, desktop, and mobile app!
Not to disparage you, MissAnthropyKnits, but just as a general precaution on the Wild West Web, it's handy to have an email address that's a throwaway. I use one for websites where I have to give a legitimate email address (because they'll send me an email with a link I need to click). If/when it starts to attract too much spam, I simply delete it and make a new one.
I highly recommend this same idea for folks who want to get in touch in real life without the possibility of exposing their "real" email address in a public forum. Create the new, temporary email (your ISP probably lets you have half a dozen or more at the same time), give it to people, then when they email you, send them your real/better/less temporary email address.
Very few people have my "real" email address, primarily only businesses and friends I trust. That way, I limit the chances of needing to update my email address due to it falling into the hands of spammers.
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.
Comment