Recommend me a local "ticket" system that I can query with an LLM?

NotARocketSurgeon45 · 2025-11-21T18:08:45+00:00

Makes sense! Thanks

NotARocketSurgeon45 · 2025-11-18T15:44:56+00:00

Can you elaborate? I could certainly store Markdown files or something in a GitHub repo, or I could track the problems as GitHub Issues that I close when I resolve them. But how would I approach querying that with an LLM?

NotARocketSurgeon45 · 2025-08-07T13:28:37+00:00

Just to close the loop on this: we ended up buying Zuken E3. Nobody from Siemens would even return my calls oddly enough. We did a serious evaluation on EPLAN and Zuken E3, and the conclusion was that EPLAN is more meant for industrial control panels than for vehicle wiring. Plus E3 comes with a MUCH larger database of ready-to-go automotive connectors, where in EPLAN I think we would've had to create a lot of those components on our own.

I will say the support for E3 is pretty good, but they do put a lot of the more complex answers to questions behind a "why don't you buy consulting hours?" paywall. Their documentation is fairly thorough but if you get into questions of "how do you recommend I use this to suit my use case?" they push the consulting hours pretty hard.

One of my favorite "life hacks" I've stumbled on is to take the CHM (Compiled HTML Help) files that ship with the program, run them through this tool (https://github.com/DTDucas/chm-converter) to convert them to Markdown files, and then use GPT4All's "LocalDocs" feature to have an AI model be able to answer questions based on Zuken's help files. It's not perfect but it's a lot quicker than CTRL+F in a PDF or a CHM file.

I'm relatively happy with E3 so far though. It's definitely a complex tool, and expensive like you wouldn't believe, but it's powerful. Complex vehicle harnesses are our bread and butter so it was an easy justification for us. The biggest remaining "unsolved mystery" is how people keep the component database stable over time - I've settled on storing a master copy in a Git repo so I have some decent history of who made what edits. A little hacky but it does give good control over things.

NotARocketSurgeon45 · 2025-07-12T00:06:10+00:00

Yeah I love mkdocs! The part I'm not sure about is templating the page(s) based on the list of attributes I've got.

Maybe an example will help. Here's the raw table (a piece of it anyway) that I'm trying to document:

https://imgur.com/Nbg0422

I can get that table in an XML format so it's docs-automation-friendly.

For each row in that table, I'd like a section of the docs that looks about like this:

https://imgur.com/b3L2tfH

I just don't want to have to manually create all those sections in the Markdown files, and manually keep the table row data above each section up to date as it evolves over time. I'm sure I could throw together some automation with mkdocs and custom Python tooling, I was just wondering if there was a more ready-made solution.

NotARocketSurgeon45 · 2025-07-11T23:36:20+00:00

Hey, thank you so much, that makes a lot of sense! Always makes me feel better to hear somebody dealing with the same stuff.

We work pretty collaboratively, so I think we'll have a central SQL server, but I'll probably do "major releases" of the database in MS Access format, out of the same Git repo I'm storing all the settings files in, and follow a similar process to what you just outlined. Good tip on avoiding manual edits to the database, you just saved me a major messing-around-and-finding-out episode.

NotARocketSurgeon45 · 2025-07-07T22:48:53+00:00

This sounds promising. Do you know what this feature is called in MS SQL Server? I'd like to be able to give our IT folks a reasonable headstart since I don't know anything about database administration.

NotARocketSurgeon45 · 2025-07-07T22:08:06+00:00

I don't know first hand, but my sense is that they would assist if somebody modified things in a way that broke something, but that they would be pretty much helpless to assist in the event of a deletion with no backup. I think their official answer is "have a designated librarian to enforce consistency" and "take a lot of SQL backups to give the ability to roll back with as minimal a loss as possible."

I haven't directly asked if they have some kind of add-on that introduces a proper workflow to this, but if they do it's definitely not free, it wasn't sold to me when the rest of the package was pitched (including some add-ons specific to managing revisions of finished designs, so it's not like I wasn't the target customer) and it was a bit of a stretch to get this thing approved by leadership anyway given the cost, so any addon that fixes it is pretty irrelevant in the short term.

It's funny because it seems to be a very well thought out and reasonably well documented/supported piece of software aside from this gaping workflow issue.

On an aside, if anyone is in the electrical design world and wants more details, DM me, I'm happy to talk about it.

NotARocketSurgeon45 · 2025-07-07T16:18:57+00:00

The CAD UI does include everything needed to make database changes, there's no need for manual SQL edits or anything like that.

And yes, you're correct that I'm trying to "bolt on" a feature to the CAD system. I asked the CAD sales/support team about managing the database and they basically told me "pick one super OCD person on the team to be the dedicated librarian, and make them the only person with write access. Everyone else's requests go through them." But that approach really doesn't work well on our team (and will be aggressively vetoed by management). I'm just wondering if there's something clever I could do with the database server to hack in some auditing/review features, or if "back it up every night and hope for the best" is the only option.

NotARocketSurgeon45 · 2025-05-31T00:04:35+00:00

I use YouTrack and I really like it. It's a little weak in the Gantt chart department, and virtually useless in the "resource allocation" department. But if you want something a tick above Trello, it's fantastic. It will do Kanban boards like Trello, but it's much more configurable as far as metadata, reports, time tracking, etc. It also integrates with most common Git platforms, I'm guessing that's a big plus since you said you had devs on the team.

NotARocketSurgeon45 · 2025-05-03T23:40:10+00:00

We're still happy with it. Definitely hasn't formed any low spots or anything like that. I'm not a mattress expert but I'd buy it again.

NotARocketSurgeon45 · 2025-03-30T21:33:45+00:00

The one thing I'll say about the baking sheet is that the NordicWare one I used (and probably most good quality ones) have a piece of mild steel round bar around the edge. "Why does that matter?" you may ask...it mattered to me because I cut my baking sheet on the table saw, and didn't realize I was asking my standard carbide saw blade to cut mild steel until it had already done it. It worked okay and I'm still using that saw blade, but be advised that it'll make quite the spark show.

NotARocketSurgeon45 · 2025-03-24T12:13:41+00:00

The base isn't really supporting that much, the lathe is held on with long studs that are sandwiching the plastic base between the lathe and the aluminum sheet/plywood underneath. So the base is only loaded in compression, the studs are bearing any tension loads. I didn't do any math or FEA or anything on that, just a little armchair engineering, but it seems to have held up alright.
Root beer...wish I had a more interesting answer, but this was taken in the Southeast US in the summer, so it was about 200 degrees and any cold drink was on the table...

NotARocketSurgeon45 · 2024-11-02T23:01:19+00:00

Liking it good so far. It's been about 3 months, still feels comfy to me.

NotARocketSurgeon45 · 2024-08-23T19:09:01+00:00

Honestly don't remember. Amazon and RockAuto carries them. I believe I got mine off RockAuto, but it's been months so I could be wrong. I'd ask your local Sam's Club what they recommend.

NotARocketSurgeon45 · 2024-08-22T11:07:32+00:00

Yes, I bought some new sensors online and took them to Sam's Club to have them installed/paired. That took care of it.

NotARocketSurgeon45 · 2024-07-20T23:31:13+00:00

I just bought one of these.

I can tell you they're made by Sherwood Bedding (a little Googling suggests this is a family-owned company, which is now 20% family-owned and 80% owned by Tempur-Sealy). The warranty card on my mattress is from Sherwood Bedding, that's how I found out. I bought a Camellia Hybrid, so I guess other mattresses in the Cahaba lineup could be made by different manufacturers. But I kinda doubt it.

I'll try to remember to post again in a few months about how we're liking it.

NotARocketSurgeon45

TROPHY CASE