search

Sheep-y / trpg-dnd-4e-db

4e Compendium - Offline D&D 4e Database
Other
57 stars 7 forks source link

Downloaded compendium, now what? #31

Closed bombshellbonny closed 7 years ago

bombshellbonny commented 7 years ago

Sorry for the confusion on my part, but I've run the downloader and have downloaded the database information, but I don't understand what I'm suppose to do next? I've downloaded trpg-dnd-4e-db, but all I see are xml files that I can't excute. I also have CocoDoc, but it also only has xml files that I can't run. I'm a complete noob when it comes to this stuff, so any more information you could give me would be greatly appreciated.

Also, is it possible to export as a CSV file? I've tried to download SQLJet to test a conversion process, but the download keeps freezing.

bombshellbonny commented 7 years ago

Just an update, I was able to dump the .database file to a sql file via sqlite, so I've got that going for me.

Sheep-y commented 7 years ago

Hmm. Sorry, I am not sure where you are at. Can you run/launch the program (a exe or a jar) which should display a window? If yes there should be a message that says "Ready to download" or "Ready to export".

Yes I can add the ability to export as CSV in next version. I guess I'll throw in an Excel export too, before someone open an issue for that.

Next version should be ready in a week or two, after which I'll try to record a YouTube video to demo it. Edit: Ok, two weeks is past, new version is done but I want to link to the video in it so... will be out soon.

Sheep-y commented 7 years ago

Ok, the export part is easy. Using it may be less easy.

I don't know what you want to do with the data but be warned that the csv may not be suitable for Excel, mainly because Excel's cell text is limited to 32k characters, which some classes and paragon paths exceeds.

So what I do with the xlsx export is I split the content into second, third, or even fourth cell. (And no, merging cell would not increase the limit.)

Google Sheet can't import any of the exports (csv/tsv/xlsx) either. Way worse than Excel. Since Google does not provide any hint (another worse), there is not much I can do.

Excel is a spreadsheet, after all, not a proper database. Maybe I should add SQL export too. Edit: Yup. SQL Export implemented. Next release now in testing and polishing phase.

Sheep-y commented 7 years ago

Ok, there is a new release (v3.5.3) with xlsx/csv/sql export and a new video that demos how the program is intended to be used.

Let me know if you still have questions. For now I'll file this issue as case closed.