Announcement

Collapse

Forum Etiquette - Please Read Before Posting

Please read the forum etiquette, by posting here you agree to be part of a polite society. https://vb.ourunraveled.com/articles...rum-ettiquette
See more
See less

JSON Data export

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

    JSON Data export

    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...


    Grammaresa
    rkennell
    Yarnbethy
    Spindlitis

    MissAnthropyKnits JSON to Excel table instructions

    #2
    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

    Comment


      #3
      Admin It's kinda big. I imported it into an airtable, though, and I just sent you a link

      Comment


        #4
        Originally posted by MissAnthropyKnits View Post
        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...


        Grammaresa
        rkennell
        Yarnbethy
        Spindlitis

        MissAnthropyKnits JSON to Excel table instructions
        I'd love to give it a try; not sure if I'll get to it today, but I'd like to give a try!

        Comment


          #5
          Originally posted by MissAnthropyKnits View Post
          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...


          Grammaresa
          rkennell
          Yarnbethy
          Spindlitis

          MissAnthropyKnits JSON to Excel table instructions
          Happy to help.

          Comment


            #6
            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!!!!

            Comment


              #7
              This makes me happy. I did the JSON export as well. I will attempt it, too. May be a day or two before I can focus, though...

              Comment


                #8
                I'd be happy to help! I can test it with Excel and I also have Libre Office.

                Comment


                  #9
                  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.

                  Comment


                    #10
                    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.

                    Comment


                      #11
                      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.

                      Comment


                      • lsmrcd
                        lsmrcd commented
                        Editing a comment
                        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.

                      #12
                      NTSH - I figured it out.
                      Last edited by knitterlady13; 07-30-2019, 08:15 PM.

                      Comment


                        #13
                        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.

                        Comment


                          #14
                          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.

                          Comment


                            #15
                            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!

                            Click image for larger version  Name:	Screenshot_20190904-205140.png Views:	0 Size:	460.9 KB ID:	24993
                            Click image for larger version  Name:	Screenshot_20190904-205158.png Views:	0 Size:	385.5 KB ID:	24994
                            Last edited by MissAnthropyKnits; 09-04-2019, 08:58 PM.

                            Comment


                            • ilexedits
                              ilexedits commented
                              Editing a comment
                              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.
                          Working...
                          X