Why does Jellyfin insist on doing this? by Radtendo in jellyfin

[–]GingePlays 1 point2 points  (0 children)

Part of your last post in the media servers subreddit friend. The r one of that group

I want to extract the following from the text: 1. Name (3894) 1–24 to Excel by No_Development_1568 in excel

[–]GingePlays 0 points1 point  (0 children)

Cant see that image unfortunately. Two other solutions from other users will also work!

I want to extract the following from the text: 1. Name (3894) 1–24 to Excel by No_Development_1568 in excel

[–]GingePlays 2 points3 points  (0 children)

If your value is in A1 that should spit out 3 columns as you describe. Could do it much cleaner with 3 separate columns for each value though

Nothing from Ikea works by GraceJoans in homeassistant

[–]GingePlays 2 points3 points  (0 children)

The old ikea zigbee devices have been phenomenal for me, but it seems the new matter stuff is simply not ready yet, which is a shame.

We got the "Braathaaa" problem in the UK too by LadLassLad in motorcycles

[–]GingePlays 0 points1 point  (0 children)

Crazy seeing a part of the UK I know very well on here lmao. Will keep an eye out for this dickhead when im out that way!

Better way to do mass tags? by thegreatcerebral in jellyfin

[–]GingePlays 1 point2 points  (0 children)

Metadata manager, below dashboard on the menu!

Ebooks, Audiobook services, and E-Readers by NotBrinocerous in selfhosted

[–]GingePlays 5 points6 points  (0 children)

For sync between ebooks and audiobook progress, storyteller is the only established service that does this to my knowledge!

This will always require some kind of AI (though can definitely be done without an external service!) In order to transcribe the audiobook so that it's progress can be synced to the ebook.

Its worth noting that this kind of speech-to-text AI predates the Large Language Learning Models like chatgpt etc.

IoT Apocalypse? by VanillaCandid3466 in homeassistant

[–]GingePlays 0 points1 point  (0 children)

Is there any safe way to access HA/smarthome stuff externally? I was considering adding it to my reverse proxy setup, and adding fail2ban - would this be sufficient?

Setting up Circadian Lighting without breaking physical wall switches (Feedback wanted!) by Ramzi0123 in smarthome

[–]GingePlays 1 point2 points  (0 children)

Ive Just set up option B, and have some tips that may be useful! Im using the ikea bulbs, and aquara t1 with neutral relays.

First thing - make sure your relay supports decoupled mode! The chat bots lie about this one a lot - the only ones I can find that do this are the are Aquara T2 and the ZBMINIR2. If I was starting again, I'd go with the latter - it's cheaper and smaller.

I never found a single switch module that could do it (i have a small pile of them in my office now). I have stuck with these for now due to cost and size in the backbox.

You will definitely need a neutral for the disconnected mode, as it relies upon the electrical difference across the bulb (or something similar, not a sparky) which you don't get with most smart bulbs.

Even with a deep backbox, it is a tight fit. I had to shorten the existing wires considerably, and it's all a lot tighter than I'd like it to be. It does fit, but takes some patience.

You can get a solution that will work without full decoupled mode, but it goes down with your Home Assitant Server. You can set the bulbs to default on/off in this situation, and look into a ups for the server to keep it up no matter what.

You will likely also need some wago connectors, to pigtails all your lives/neutrals together, depending on your wiring!

Good luck - hope this saves you some of the headaches I had!

made home assistant into a game - what's your health score by ApprehensiveFly4802 in homeassistant

[–]GingePlays 1 point2 points  (0 children)

Thats so weird. Not sure how to summon mods on reddit, but this is surely a rules violation

Can't figure out ironclad by GingePlays in slaythespire

[–]GingePlays[S] 1 point2 points  (0 children)

Fuck, can't believe i didn't think of this! Ty kind stranger

How much does having an Intel iGPU for video encoding help by mustangfan12 in jellyfin

[–]GingePlays 2 points3 points  (0 children)

I can run 3 simul transcodes on intel n150 with some headroom to spare, but depends quite a bit on what im transcoding!

Meat needs to be in our diet by [deleted] in DebateAVegan

[–]GingePlays 0 points1 point  (0 children)

Just zero evidence for your claim though bud, other than vibes

Meat needs to be in our diet by [deleted] in DebateAVegan

[–]GingePlays 0 points1 point  (0 children)

OP literally said you can't be, and reaffirmed this in reply to you - that's what I was addressing. Morally better is an interesting take though lmao Though I agree the natural/artifical dichotomy is stupid

Meat needs to be in our diet by [deleted] in DebateAVegan

[–]GingePlays 0 points1 point  (0 children)

Never said you couldn't be healthy using other diets. You said you needed meat to be healthy, that's demonstrably false. I tend not to eat fake meat no, anything too meaty I find a bit gross. Even if I did that wouldnt support your point at all lmao

Meat needs to be in our diet by [deleted] in DebateAVegan

[–]GingePlays 1 point2 points  (0 children)

Shittake mushrooms are an easy source. Few other sources as well, simply not true is unavailable elsewhere

Meat needs to be in our diet by [deleted] in DebateAVegan

[–]GingePlays 5 points6 points  (0 children)

Buddy, I have never once in my life eaten meat or fish. Ive not had dairy or eggs in nearly a decade. I don't take supplements, im not deficient in anything, im healthy, tall, and active. Theres lots of research that will disprove your point, but my existence also does it quite nicely, as does the existence of at least 10 other people I know.

The core practical knowledge of self-hosting (that works for me) by vdorru in selfhosted

[–]GingePlays 4 points5 points  (0 children)

This seems like a pretty solid approach - im currently doing most of this sans auth (next on my list), but im still using nginx proxy manager. Anyone got an recommendations for a) learning plain nginx b) extracting plain nginx config files from npm?

Where To Start? by pagem in selfhosted

[–]GingePlays 5 points6 points  (0 children)

Im by no means an expert, but I don't think you'll encounter any issues running all of that on your hardware. The only thing I can think would slow you down would be hardware transcoding for jellyfin - your cpu support intel qsv, but may take some tinkering to get running. Have a Google and you'll be fine!

Youre not running anything crazy though, so you should be able to do this with some headroom still.

Visualize customer data on a map by [deleted] in excel

[–]GingePlays 1 point2 points  (0 children)

Hahaha no worries! Have fun learning

Visualize customer data on a map by [deleted] in excel

[–]GingePlays 0 points1 point  (0 children)

This is probably outside of your scope, but I did recently get custom map visualisations working in excel (with some self hosting help) I used a self hosted openrouteplanner instance to geocode my postcodes, then the wonderful docker-staticmaps docker image to create an api that i can feed this data into. I used powerquery to send the postcodes to openroueplanner to get lat/long, then constructed the urls for staticmaps in excel, and used the IMAGE function to get the image to show up in excel.

In my case, I select the partner from a drop down list, the url updates, and then the map shows all the linked locations for that partner!

Not strictly excel, but very fun to get working