search

multimeric / DelverLensExtract

Converts Delver Lens's `.dlens` files into `.csv` spreadsheet files
https://multimeric.github.io/DelverLensExtract/
1 stars 0 forks source link

Was this never released? #1

Open Xeddicus opened 1 year ago

Xeddicus commented 1 year ago

Was this project ever completed? Not seeing a release.

multimeric commented 1 year ago

It's a long time ago now, but I think I determined that it was trivial to extract the data since it was in sqlite format or something. I can check for you if you can send me a .dlens file. I think I've since lost my source code.

Xeddicus commented 1 year ago

Here's a .dlens file. If it is sqlite could you point me in the right direction to an extractor for it? Something like this? https://sqlite.org/index.html

From: Michael Milton @.> Sent: Thursday, April 27, 2023 4:56 PM To: multimeric/DelverLensExtract @.> Cc: Xeddicus @.>; Author @.> Subject: Re: [multimeric/DelverLensExtract] Was this never released? (Issue #1)

It's a long time ago now, but I think I determined that it was trivial to extract the data since it was in sqlite format or something. I can check for you if you can send me a .dlens file. I think I've since lost my source code.

— Reply to this email directly, view it on GitHubhttps://github.com/multimeric/DelverLensExtract/issues/1#issuecomment-1526788482, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AATOPTR5ASLUTAK46RXVMGDXDMBRHANCNFSM6AAAAAAXOQBOEE. You are receiving this because you authored the thread.Message ID: @.***>

multimeric commented 1 year ago

GitHub doesn't let you upload many file extensions. Just rename it to .txt or something and I should be able to handle it.

Xeddicus commented 1 year ago

2023_Apr_27_19-13_exported.txt

multimeric commented 1 year ago

Yep so the easy GUI solution that I would recommend is:

I forget which database the card column refers to. You might be able to cross reference scryfall since you know what your cards are.

multimeric commented 1 year ago

Ah yep, so to get the card names you would have to download the corresponding .apk file, and extract res/raw/data.db, join that table to your cards table and then join that with some Scryfall data. It's not super easy, so maybe try https://github.com/shagu/mtg-browser?

Xeddicus commented 1 year ago

Thanks. Was going to say of course the scryfall_id column is empty, that make it easier at least. Will give the mtg-browser a shot.

Xeddicus commented 1 year ago

Well damn, it looks like mtg-browser is failing because scryfall_id is empty. That figures.

multimeric commented 1 year ago

Okay I hacked together a web app that automates this. Give it a shot: https://multimeric.github.io/DelverLensExtract/. Let me know if it helps you. Currently all it does is add the card name to the CSV but it can add a bit more if that's helpful.

You can get the APK file from somewhere like this: https://apkcombo.com/mtg-card-scanner-delver-lens/delverlab.delverlens/.

Xeddicus commented 1 year ago

Thanks, that seems to be working. Had to update my delverlens.apk to fill in some cards, but that fixed it.

If it's simple enough exporting the names to a plain text file would be helpful to my laziness, but then copy/paste out of Excel takes 5 seconds so really I can live with this. Thanks again.

multimeric commented 1 year ago

That's great! I'm wary about a) redistributing dlens assets and b) would worry that such a text file might get out of date or out of sync with changes in the app.

Xeddicus commented 1 year ago

Think you may have misunderstood the request, but again it's minor. Had to use a newer version the apk for the conversion, but just want the resulting names into a text file instead of in the csv column. Nothing to redistribute on your part and it getting out of synch I assume will be an issue regardless as time goes by on the conversion end so will require a newer apk.

Or I am misunderstanding your reply. Either way I have what I want now as soon as I finish updating magic assistant, so many thanks.

multimeric commented 1 year ago

Oh I see, yes I misunderstood. Can I ask why a text file containing one column of the CSV would be better than the whole CSV?

Xeddicus commented 1 year ago

Program I am using, Magic Assistant, doesn't support that csv format on import. So I just need to copy the names out of it into a plain text file (and add a 1 before the names) to get them in. No big deal.

multimeric commented 1 year ago

You can do that pretty easily with Excel though I think.