Search found 4614 matches

by Fangbeast
Sun Sep 19, 2021 2:22 pm
Forum: Coding Questions
Topic: Check sqlite db table columns
Replies: 9
Views: 692

Re: Check sqlite db table columns

Enumeration #db EndEnumeration Procedure CheckDB() If DatabaseQuery(#db,"SELECT sql FROM sqlite_master WHERE tbl_name = 'Students' AND type = 'table'") While NextDatabaseRow(#db) If GetDatabaseString(#db,0) <> "CREATE TABLE Students (id CHAR(15) PRIMARY KEY, Lname CHAR(32), Fname CHA...
by Fangbeast
Sun Sep 19, 2021 2:18 pm
Forum: Coding Questions
Topic: Check sqlite db table columns
Replies: 9
Views: 692

Re: Check sqlite db table columns

Where are you actually querying the database? As far as I can see, CheckDatabaseQuery is NOT a valid database command in pb. Unless you are aliasing the DatabaseQuery() command in your code somewhere?
by Fangbeast
Sat Aug 28, 2021 8:32 am
Forum: Off Topic
Topic: recover deleted pb files?
Replies: 10
Views: 1669

Re: recover deleted pb files?

I was under extreme time pressure and I was not thinking clearly. Otherwise, I would select the correct drive. Active@ File Recovery does not recover txt or cimilar files. It can recover doc, docx, etc by checking them from a list of types. Have a look at PhotoRec/Testdisk. You can add a list of cu...
by Fangbeast
Tue Aug 24, 2021 3:01 am
Forum: Coding Questions
Topic: Calibre .OPF file format help needed
Replies: 22
Views: 1749

Re: Calibre .OPF file format help needed

Thanks Demivec. As soon as I have cleared my current project bugs, I can play:)
by Fangbeast
Fri Aug 20, 2021 7:06 am
Forum: Coding Questions
Topic: Calibre .OPF file format help needed
Replies: 22
Views: 1749

Re: Calibre .OPF file format help needed

Marcus, I fangified your code to help me read the results. Now I just have to find a way to clear out the tags and render readable text. Probably regex again (hehehe). ;-------------------------------------------------------------------------------------------------- ; Visual designer created forms ...
by Fangbeast
Thu Aug 19, 2021 2:25 pm
Forum: Coding Questions
Topic: Calibre .OPF file format help needed
Replies: 22
Views: 1749

Re: Calibre .OPF file format help needed

Thanks for the help Marcus, I really appreciate it.

As for the horny goat wink, be careful not to let Idle see you.

You know how these Kiwi Goat shaggers get when a goat winks at them:):)
by Fangbeast
Thu Aug 19, 2021 8:55 am
Forum: Coding Questions
Topic: Calibre .OPF file format help needed
Replies: 22
Views: 1749

Re: Calibre .OPF file format help needed

Marc56us, I can see your code returning the identifiers but not understanding regex, I don't know how that actually returns the string in the middle of them.

The list of things I will never understand is growing.
by Fangbeast
Wed Aug 18, 2021 7:48 am
Forum: Coding Questions
Topic: Calibre .OPF file format help needed
Replies: 22
Views: 1749

Re: Calibre .OPF file format help needed

Sorry Fangbeast!
Eeek!! Don't be sorry!! You've helped me on and off during the years and I appreciate it.

I'm just getting older and stupider:):)

If srod is listening, "Shaddap ya varmint!"
by Fangbeast
Wed Aug 18, 2021 3:49 am
Forum: Coding Questions
Topic: Calibre .OPF file format help needed
Replies: 22
Views: 1749

Re: Calibre .OPF file format help needed

Here with regular expressions (because I like that). Eek!! That does my head in. The expressions are simple to understand and therefore to modify Suuuure, that's what an intelligent person would say:):) Yay!! An example to read and see if I can follow. I might have around 70,000 books to go through...
by Fangbeast
Tue Aug 17, 2021 11:53 pm
Forum: Coding Questions
Topic: Calibre .OPF file format help needed
Replies: 22
Views: 1749

Re: Calibre .OPF file format help needed

Fagbeast, Fagbeast????? That made my day. Nearly rolled off my chair laughing. I was answering the question of "why multiple descriptions?", and you are right I missed the point. I miss everything else:):) @Marc56us is right, don't bother with XML, get your data directly from the Calibre ...
by Fangbeast
Tue Aug 17, 2021 7:58 am
Forum: Coding Questions
Topic: Calibre .OPF file format help needed
Replies: 22
Views: 1749

Re: Calibre .OPF file format help needed

Replace them before with an underscore :wink: Stop that horny goat winking, that's idle's job:):) When, where, how??? Given the below code to load a 'normal' xml without colons, I don't know where, how to do this, at what point. I have no idea what I am doing here. [code]Structure opfitem title.s s...
by Fangbeast
Tue Aug 17, 2021 3:44 am
Forum: Coding Questions
Topic: Calibre .OPF file format help needed
Replies: 22
Views: 1749

Re: Calibre .OPF file format help needed

There you can download the description from Amazon, google, etc.. you can automate this in Calibre from the command line if you need to do a bunch. I don't see where you are going with this. All the data I need is already in the opf file and I just need a way to extract it. Don't want to try 40,000...
by Fangbeast
Tue Aug 17, 2021 12:36 am
Forum: Coding Questions
Topic: Calibre .OPF file format help needed
Replies: 22
Views: 1749

Re: Calibre .OPF file format help needed

What data are you wishing to extract? Managed to find a smaller opf in my own collection. Title, creator, date, description. publisher ISBN GOOGLE language series But it seems as if the description field is repeated twice or even 3 times (that I can see) Then it has multiple 'subject' fields which ...
by Fangbeast
Tue Aug 17, 2021 12:25 am
Forum: Coding Questions
Topic: Calibre .OPF file format help needed
Replies: 22
Views: 1749

Re: Calibre .OPF file format help needed

jack wrote: Mon Aug 16, 2021 3:20 pm couldn't you use the PDF library ? I think that somewhere on this forum there is a PBpdf library
Didn't know you could do that? Never used the PBpdf lib before.
by Fangbeast
Mon Aug 16, 2021 7:30 am
Forum: Coding Questions
Topic: Calibre .OPF file format help needed
Replies: 22
Views: 1749

Calibre .OPF file format help needed

Just had a look at the Calibre ebook reader .OPF file description format and it's non standard xml fields leave me a little puzzled (as in: I know less than nothing) )how to deal with it to extract data. Has anyone had a go at it? Even the smallest opf file is a bit 'windy' so I didn't want to post ...