Export / import the database enumerations?

[meteos77]

with catmandu, I have automated the CSV import and I use the Enumerations to bring details on some fields

I did not find anything in the 2 configuration files to save the "Database Enumerations".

will there be a way to save and re-import the Database Enumerations ?

my base with my enumerations
2021-12-27_Base-vierge-avec-données-minimum-de-base.sqlite.zip

[textbrowser]

There is a reminder for that. See the TO-DO.

[textbrowser]

Book Binding Types, Languages, Locations, Monetary Units?

[meteos77]

I did try the SQL ... I didn't succeed all at once but this one for example
SELECT * FROM locations ; it is enough to export to a CSV
location.csv

but I miss the CSV import template

[meteos77]

you are going to remove the "book binding type" field from the BiblioteQ database ?

my script takes the 010$b and transforms the br. into paperback (enumeration)
010 $a 978-2-84666-840-8 $b br. $d 44 EUR $b the 2 vols.

[textbrowser]

No. You have an entry "Book Binding" in your database. You can remove it because it doesn't have a functional meaning.

[meteos77]

it does create the new enumerations by import.

my initial request was rather to import them into an existing database without creating new documents

I do the
SQL select to select them
I save the selection in csv

I'm missing the "model-3 import enumeration-type ..." with the right fields (for the moment in the 2 models book and members; the fields don't appear)

[textbrowser]

The enumerations are part of the database. They cannot be separate.

[meteos77]

I just came back to the version of 15/12 to do a test

thanks again for this very useful feature
of automatic import of enumerate database !

[textbrowser]

Done!

[meteos77]

thank you for this feature in summary :

• the export is done by SQL on each enumeration type
  for example for the location : SELECT type,location FROM locations ORDER BY location

• for the import, create a csv file with pseudo books that contain the different enumerations and then delete the books.
  the enumerations will remain in the database

4-BiblioteQ_fichier-import-énumérations-v2.csv.tar.gz

if the .csv file contains new enumerations, they are created automatically.