search

textbrowser / biblioteq

Archive and catalog the world for today's and tomorrow's generations! Awesome and everyware.
https://textbrowser.github.io/biblioteq/
Other
217 stars 46 forks source link

Issue importing a csv? #376

Closed trebe0 closed 3 weeks ago

trebe0 commented 1 month ago

I'm trying to import a database that is sabe as CSV to BiblioteQ but it's giving me an error when I try to import it, this is the error that I have: Imported: 0. Not imported: 1.

Database error (UNIQUE constraint failed: book.isbn13 Unable to fetch row) at row 2.

Can anyone help me out to solve this?

textbrowser commented 1 month ago

Paste the CSV.

trebe0 commented 1 month ago

Paste the CSV.

How do I do that? and I also have this other problem now: Imported: 0. Not imported: 1.

Database error (Parameter count mismatch) at row 2.

It's either one error or the other but is not allowing me to import the csv and when it does let me import it I can't see the information that has been ''imported''

textbrowser commented 1 month ago

Can't help if you don't know how to attach a file.

textbrowser commented 1 month ago

Remember, you're asking for help. So you need to put in the effort because I'm already putting in the effort.

textbrowser commented 1 month ago

https://docs.github.com/en/get-started/writing-on-github/working-with-advanced-formatting/attaching-files

trebe0 commented 1 month ago

ahhhh, you mean leaving the file over here

trebe0 commented 1 month ago

basePcEberth.csv

here it is I really appreciate your help

textbrowser commented 1 month ago

You're missing important fields.

trebe0 commented 1 month ago

You're missing important fields.

what am i missing?

meteos77 commented 1 month ago

For me, the simplest method is to choose "Model-1" and have all the columns in the .csv file. Of course, you have to fill in the fields that are essential for the database, and leave the other fields empty.

an example: exemple_modele1.csv

textbrowser commented 1 month ago

The reported error is the one produced by SQLite. It'll take a while to list the required fields.

textbrowser commented 1 month ago

Also disorder in the columns in your CSV and with the BQ selection. OK, so perhaps BQ can select the database field from the title name in the CSV. OK.

textbrowser commented 1 month ago

Conclusion: disordered and missing columns in the CSV.

textbrowser commented 1 month ago

Future #1.

bq-1

textbrowser commented 4 weeks ago

Future #2.

bq-2

meteos77 commented 3 weeks ago

Great evolution, but if you use the “?” on model 1 some fields like the title appear as ignored ?

textbrowser commented 3 weeks ago

Great evolution, but if you use the “?” on model 1 some fields like the title appear as ignored ?

If a field cannot be mapped, the result is . Hence the "?". A header in the CSV may be "Junk". BQ cannot map it to a field. I think it's clear.

textbrowser commented 3 weeks ago

"Guess."

textbrowser commented 3 weeks ago

Completed.