[GUI Plugin] Import List

[Tanjamuse]

Nevermind ... I actually figured it out myself. Although Calibre still doesn't add the correct information in the complete column. (see attached screenshot).

[BetterRed]

I assume you mean the #status column. What is the calibre column definition for the #status column.

Your source CSV looks like it has a textual string, if #status isn't a real text column of some sort then that could be the problem, e.g. if the Column type is Text, but with a fixed set of permitted values then I think that is actually held as an integer.

Try adding a #status_as_text column (long text, header on side, plain) and map column 6 to it.

BR

[davidfor]

@Tanjamuse: BR is going in the right direction. If #status is a yes/no type column, if the CSV column has a value that can be interpreted as "Yes", then the column gets set to yes. Looking at the code, it can be one of: 'true','yes','y','1'. If the value isn't one of these, then it will be set to "No".

[Tanjamuse]

Davidfor is right, my status column is a Y/N column, I had naively expected that since the FFF plugin can transfer Completed to yes then the Import List would as well.

I'm pretty sure I can batch-edit in my CSV-file, I'm trying to figure out if I can do the same in the original SQLite file. Otherwise I'll have to create a new text column and then later add that information to the Yes/No I already have.

Thanks to both of you.

[BetterRed]

If you import the column into a text column as I suggested, then I think you should be able to use Bulk Search and Replace to populate the Y/N #status column based on the values in the #status_from_text column.

To my mind the values in column 6 look richer in terms of information content than a simple Y/N, so I would probably want to keep them, at least until the last minute. If I didn't want to keep them then I clear the column, then I'll have the column for next time I run a similar Import List.

If you massage the original sql database or the csv file how would you save the process - sql procedures and excel macros come to mind. But with Bulk S&R you can save the S&R for reuse which is something you already know about. I'm not even sure SQLite has stored procedures or an equivalent - David will know.

BR

[davidfor]

Changing it in the CSV is simple. You can do it in a text editor or a spreadsheet application.

Depending on what else you have in the database, you can do an update to change from "Completed" to "Yes" and "In Progress" to "No".

If you don't want to do that, you can do it in the SQL that gets the data from the original database with a CASE statement. Such as:

SELECT Title, CASE Status WHEN 'Complete' THEN 'Yes' ELSE 'No' END as Status
FROM thetable

Otherwise, as BR suggests, import it into another column and modify things afterwards.

[Nicolas F]

Just for your information, while theming this plugin I saw that there is a unused browser.png icon inside.
Instead the plugin is using the store.png icon from calibre for the links to the webpages. (so maybe you should replace store by browser or delete browser.png)

[Tanjamuse]

Is there any way to add language as well? Into the standard language column in Calibre?

Or do I need a custom column for it?

[BetterRed]

@Tanjamuse - the built in language column needs one of these List of ISO 639-1 codes

BR

[Tanjamuse]

I've changed from English to En and then to Eng but it still doesn't picks up the language, I can't choose that column to import either.

[BetterRed]

@Tanjamuse try 'en' for English, 'de' for Deutsche, 'fr' for 'French", 'da' for you know what.

You may need to preprocess your csv to replace 'English' with 'en' etc.

Do you mean 'language' is not in the list of available database columns !

BR

[Tanjamuse]

Yes, under columns to import the Language column doesn't show up.

As you can see it should have shown up in between these columns.

[BetterRed]

Originally Posted by Tanjamuse

Yes, under columns to import the Language column doesn't show up.

As you can see it should have shown up in between these columns.

Confirmed - I have a vague memory if you add books via IL, all the books end up with language set to the calibre interface language.

BR

[davidfor]

Originally Posted by Tanjamuse

Yes, under columns to import the Language column doesn't show up.

As you can see it should have shown up in between these columns.

The plugin doesn't do anything with the language. I'm not sure why kiwidude didn't include it in the list of fields to be populated. It might just be the extra complexity of making sure the value are valid languages. I'll have a look if I hve time, but I won't promise anything.

[Tanjamuse]

That would be very nice.

Thanks