(using my Lemmy account because Mastodon doesn't handle large posts very well)
Thank you for the info. I'd never even heard of Corel Photo-Paint. My main reason to use RAW images is because my personal camera is not a $2,200 piece of equipment; it is an entry-level Nikon from 2012. The images it produces alongside the RAW ones are like 1 MB jpegs (from what I remember). That said, I definitely need to refine my image workflow.
I have spun up an instance and made use of the csv import. So far my main complaints are the lack of bulk image uploads (that I've found) and a seeming inability to generally browse items (except by location).
The label system is quite useful, although I do wish there could be tiers of labels, or maybe category options that function similarly to labels but in a different part of the UI.
Thank you again for the suggestion; I'll continue playing around with it while I look into others suggestions.
Thank you for the suggestion. I will look into it. It seems like I will need more than a brief glance at the readme to figure out how it works, but it seems like installation is relatively simple.
It looks like that would work as an essentially 1-to-1 replacement, especially since I would never need the full GB that instance offers. I could even self-host it, although without an existing proxy config that would likely be a bit too much for me at this point. Thank you for the suggestion.
Edit: Not quite 1-to-1: similar to HomeBox, it does not support linking images, just uploading image files. This isn't a deal breaker, though.
That may work quite well, and my reverse proxy already has an example config for it. I'll look into it some more. Thank you.
I currently keep track of which model kits, brick building sets, and painting miniatures that I own and whether I have made progress on them in a Google Sheet. As part of my attempt to degoogle, I am looking into various alternatives.
My current preferences for an alternative are:
One of the alternatives I've already tried is the Nexcloud Office plugin for my existing Nextcloud server using Collabora Online as a backend. In addition to it loading quite slowly, I had issues editing any files created with the plugin, and after tinkering with it for a while I decided to put that solution aside. This was several months ago.
Another alternative I have considered is coverting this sheet into a database. I do not have much experience with databases (pretty much just creating one in MariaDB for Nextcloud), but from what I know about them this seems like a good use case for one. I do not know what would be best as a frontend; phpMyAdmin? DBeaver?
Any suggestions? If all else fails, I'll just keep an .ods document on Nexcloud and install LibreOffice Viewer on my phone, but I would prefer not to have to download and upload the .ods through Nextcloud every time I want to update my inventory (this is primarily an issue when I update it at work).
This is what I currently use:
Markdown table with data type guesses if image does not load
| Name | Number | Brand | Grade/Type | Line | Year | Image/Link | Scale | Retail | Price Paid | Assembled? | Painted | Yen |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Gundam Barbatos Lupus (ASW-G-08) | 5055446 | Bandai | HG (High Grade) | I-BO | 2016 | [Formula1] | 1/144 | [Formula2]/[USD Retail] | $10.19 | Y/N/'- | Y/N/'- | 1000 |
| [TINYTEXT] | [VARCHAR] | [TINYTEXT] | [TINYTEXT] | [TINYTEXT] | [YEAR] | [TEXT] | [FLOAT]/[SMALLINT]/[TINYTEXT] | [DECIMAL] | [DECIMAL] | [BOOLEAN] | [BOOLEAN] | [SMALLINT] |
There are only a few formulae used:
=HYPERLINK("https://bandai-hobby.net/item/5886/",IMAGE("https://bandai-hobby.net/images/157_5886_s_5pwg9tvxlm5v4gwrz49ly8ry3j8e.jpg"))Yen column) to equivalent USD in the release year (could easily be replaced with a manual conversion or a researched US retail)=M36&"円 / $"&TEXT(M36*VLOOKUP(F36,'Currency Rates'!$A$2:$B$52,2,FALSE),"#,##0.00")=QUERY(GOOGLEFINANCE("CURRENCY:JPYUSD","price",DATE(A47,1,1),IF(DATE(A47,12,31)-TODAY()>0,TODAY(),DATE(A47,12,31)),"DAILY"),"select avg(Col2) where Col1 is not null label avg(Col2)''",1)This last formula is used on a conversion sheet referenced in Formula 2, which looks like this:
I appreciate any help.
Wow I didn't even know you had posted the same kit a few hours before I did. Your pose is even cooler!
Yet again not sure if my reply went through from Mastodon, so here's the quoted reply:
@orbitz@lemmy.ca Looking for anything that isn't just the top 5 of the year is honestly pretty hard. Here are a few High Grade red releases of varying price and availability from the last couple years:
https://breezewiki.catsarch.com/gunpla/wiki/HGGQ_RGM-79_Light-type_Guncannon
https://breezewiki.catsarch.com/gunpla/wiki/HGCE_ZGMF-MM07_Z'Gok
https://global.bandai-hobby.net/en-us/item/01_5236/
https://breezewiki.catsarch.com/gunpla/wiki/HGCE_ZGMF-X191M2_%E2%88%9E_Justice_Gundam_Type_II
https://breezewiki.catsarch.com/gunpla/wiki/HGCE_STTS-808_Immortal_Justice_Gundam
https://breezewiki.catsarch.com/gunpla/wiki/HGCE_ZGMF-2025/F_GELGOOG_Menace_(Lunamaria_Hawke_Custom)
If you have patience and are willing to pivot, you can do a (good) RG kit as your first. You're more likely to finish a kit you like either way.
Looks like there was about an hour delay, at least for it to be publicly visible. Not sure when you got the notification, but I originally responded with my Mastodon account within 5 minutes of receiving your comment.
The bridge may be acting up, so here's my quoted reply:
@jodanlime@midwest.social No paint except panel lining. For the top coat I used two airbrushed coats of Vallejo Matt Varnish.
It's been a while since I gave Open Camera a try. My main issue with using my phone for these pictures was just getting the thing to focus where I wanted it and not make everything yellow in my work's less-than-optimal lighting. I'll have to experiment some with focus and/or exposure bracketing in Open Camera and see if that gets me closer to where I want.
Thank you again!