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
Collapse
  • Page of 2
  • Filter
  • Time
  • Show
Clear All
new posts
Previous 1 2 template Next
    #1

    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
    Tags: None
    #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!
        • 1 like

        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.
          • 1 like

          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!!!!
            • 2 likes

            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...
              • 1 like

              Comment

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

                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.
                  • 2 likes

                  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.
                    • 1 like

                    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
                        #11.1
                        lsmrcd commented
                        07-30-2019, 08:08 AM
                        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.
                        • 2 likes

                        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.
                          • 4 likes

                          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
                              #15.1
                              ilexedits commented
                              09-05-2019, 06:56 AM
                              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.
                          Previous 1 2 template Next
                          Working...
                          X

                          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.

                          I Agree