Set Custom Column from identify.py

[ahisham]

Hi,

With reference to this post:
https://www.mobileread.com/forums/sho...3&postcount=11

My aim is to save a value for custom column retrieved from a metadata plugin like amazon.py. To confirm, I just need this once and will revert my code changes back once run.

@kovidgoyal suggested to modify the identify.py to be able to save the custom metadata. I tried (static data) this at end of merge function:

ans.set_user_metadata("#genre", {'#value#': ['Ebooks.Language.Java','Ebooks.Language.Python'], 'datatype':'text',
                            'is_multiple': '|', 'name': u'Genre'});

However, it didn't get saved!!

What else I need to modify to get it working ?

[kovidgoyal]

You cannot save custom metadata from a metadata download plugin. That would make no sense, since there is no guarantee that different users would have the same custom columns. To enable that you would need to allow metadata plugins to be customized with a list of custom columns to save to, which is not worth the effort for me.

[ahisham]

Thanks kovidgoyal ..

Sure .. I just want to modify my own local library with these custom values. Also, this is for one time only, i.e. download metadata, save values in custom columns, revert back my code changes.

For me, I followed http://manual.calibre-ebook.com/sub_groups.html and created custom column with lookup key "#genre", heading as "Genre" and type as "Comma-separated text, like tags, shown in the tag browser". My question is how to save (the shown sample static data) in database ?

Another question, is it possible to escape commas and dots characters in values in this genre column ?

Thanks

[kovidgoyal]

Save your metadata in an unused builtin column,like say,publisher,and then use the bulk search and replace tool to copy it over after all your downloads are complete.

[ahisham]

Thanks kovidgoyal ..

I think setting the value from inside identify.py would give more ways for updating the values.

But since it seems difficult, I tried setting the value to publisher as you suggested. To keep original publisher data, I separated them by a '#' and updated also the identify.py to handle (merge) the new format. All is good.

Now, in bulk search and replace, i use "(.+)#(.+)" to move 2nd group to genre column. The problem is it also moves the value if it doesn't contain '#' separator!

How to move the 2nd group from publisher field to genre field only if the '#' exists ?

Thanks

[chaley]

Originally Posted by ahisham

Another question, is it possible to escape commas and dots characters in values in this genre column ?

Thanks

No.

Originally Posted by ahisham

Now, in bulk search and replace, i use "(.+)#(.+)" to move 2nd group to genre column. The problem is it also moves the value if it doesn't contain '#' separator!

How to move the 2nd group from publisher field to genre field only if the '#' exists ?

Thanks

Before you do the search/replace, search for publishers comtaining a '#' and select the results.

[ahisham]

Thanks .. This will work for now.

Please if it is possible to be able to save from identify.py, this will be really helpful. I just need to be able to save this sample data:

ans.set_user_metadata("#genre", {'#value#': ['Ebooks.Language.Java','Ebooks.Language.Python'], 'datatype':'text',
                            'is_multiple': '|', 'name': u'Genre'});