TranceMagick

Honestly, I'm a little overwhelmed you took the time to do this for me/us. I can't thank you enough. My coding skills are antiquated now (VB6, Unix shell, Transact-SQL), and I'm not particularly interested in learning a new language now. I was doing this in VBA (not .net), and while I was finding things to parse the JSON file, they all seemed kludgy work arounds. What you have given me seems to cover all bases, so all I need to do is parse the build file, and generate the SQL to run against the database. I've already been able to import the data into the sql db. I really can't express my appreciation for you (and the others) help on this.

Thanks for the reply. This was incredibly helpful. I had looked at this dataset before, and I'm not really familiar with JSON files, so the learning curve appeared steep, and I moved on looking for an easier solution. Your snippet showed me exactly the relationship I was looking for, so while it looks like I'll have to start from scratch again, the couple of google searches I've run seem to show a lot of utilities for manipulating JSON files in the way I need. Thanks to everyone who responded, I appreciate it.

Thank you for responding. I contacted you a while back about your data asking permission to use it if I ever came up with anything interesting to do with it (I have not yet). I imported your spreadsheet into a SQLite database with no issues to speak of, the data in the spreadsheet was laid out well, so it was a breeze. The problem I'm working on at the moment is that the data you get in the buildsave file doesn't have a clear mapping to what the actual enhancement it's referring to. For example, I have a Celerity +Stealth in sprint at level 1, but the buildfile entry lists it as Crafted_Celerity_C, which does not map back to my data easily. Frankly, the options I've identified to resolve this would involve more time than I'm willing to commit to the project (the source for Mids is available, so I could figure things out from there, but frankly, I've looked at the code, and from what I've seen it would take a substantial effort to get what I need out of it). I've attached the SQLite DB I created from your spreadsheet if you're interested. I use DB Browser for SQLite, it's small, free, and easy to set up. Also, the spreadsheet you have doesn't include the basic IO recipes, just the sets. Would you know where I might find this data so I could merge it in with your data? 20250113-HC Recipe DB.zip

I have a database of the enhancements currently in use. I want to map the data items in the buildsave file back to this database, and I'm trying to avoid having to manually create the relationships/mappings myself since it's such a monster. By chance has anyone else done this mapping and is willing to let me have it? Or for that matter, am I missing the obvious and the relationships are there, I'm just not seeing it. Thanks in advance,.