WordPress.org

Forums

WebLibrarian
[resolved] CSV import, sql db and general settings (11 posts)

  1. emilia_onesti@yahoo.it
    Member
    Posted 1 year ago #

    Dear WebLibrarian author. I am new to WordPress and I don't speak a good English, please excuse me.
    I just get the plugin and I would like to import in bulk my book catalogue. It is an .ods file of 963 record divided in 16 columns. I converted it in a csv file where the column header match the defined by the database (… or maybe not, I exported as a csv a sample catalogue I have created to understand what is required) but something fail in the “pubdate” field. How can I understand what is wrong?
    Do you think I can add and/or rename a field in the sql db (wp_weblib_collection)?
    Furthermore in a near future I would like to affiliate with Amazon Italy, how can I manage the configuration of WebLibrarian in my WP settings? It only consider USA, Germany, Canada, France, Japan and UK.
    Thank you very much for your help. Emilia

    http://wordpress.org/plugins/weblibrarian/

  2. Robert Heller
    Member
    Plugin Author

    Posted 1 year ago #

    The pubdate format should be MM-DD-YYYY (ex: 01-10-2013 would be January 10, 2013).

    Last time I checked AWS does not have a .it domain, but I will check again later today or tomorrow.

    Messing with the DB fields is possible, if you know PHP well enough. I wrap the database access with classes, one for each table. The code does make assumptions about column names in other places though, so column renaming could have strange effects and could break things badly. Which column do you want to rename or add?

  3. emilia_onesti@yahoo.it
    Member
    Posted 1 year ago #

    Dear Robert,
    Thank you very much for your help. I will use new the Amazon settings as soon as I will start with my blog.
    As regards the database: I would like to change the type of the field pubdate (as I my have questionable date for old books that I normally write as [yyyy]?). Furthermore I would like to have the book series field, I can use the Edition one but I would like change the name of the field, do you think it is possible? Thank you very much for the plugin and for your help. emilia

  4. Robert Heller
    Member
    Plugin Author

    Posted 1 year ago #

    Changing the type of the pubdate field is likely to break things badly -- the code kind of depends on it being a mysql date type. You can also just add '01-01-' to the front of the year. Only the month and year are actually displayed. I am not sure what the best way of dealing with the Edition field -- it might be possible to use CSS to hack that -- you don't really need to mess with the actual column name, just the label used.

    How good are you at hacking PHP?

  5. emilia_onesti@yahoo.it
    Member
    Posted 1 year ago #

    Thank you for your prompt response. I will not change the type of the the pubdate field! I will find a way to give more information about the books that have no publishing date.
    As for the book series I will follow your suggestion and I will change the CSS because I don't need to change the column name in the db (I will do it as soon as I understand the way to do it …!).
    I am not used to php, I just can ask a friend to help me with this.
    Thank you and ciao, emilia

  6. Robert Heller
    Member
    Plugin Author

    Posted 1 year ago #

    I've updated the AWS interface to use the additional locales. If you update to version 3.2.9.7 it will have the Amazon Italian domain/locale.

  7. emilia_onesti@yahoo.it
    Member
    Posted 1 year ago #

    Dear Robert, I already updated the plugin!
    Thank you very much for your help. Ciao, emilia

  8. choongwh
    Member
    Posted 1 year ago #

    Dear Mr Robert,

    Could you please also add in the AMAZON CHINA locale? Thank you.
    THank you very much for your help.

  9. Robert Heller
    Member
    Plugin Author

    Posted 1 year ago #

    choongwh:
    It should be there in the latest version.

    And please *don't* hijack threads! If you have a *new* question, open a *new* support thread.

  10. choongwh
    Member
    Posted 1 year ago #

    Dear Mr Robert,
    My apologies. Thank you for your update. Saw it in the latest updates.

    Thank you for such a great plug-in. Deeply appreciated.

  11. tzeryong
    Member
    Posted 1 year ago #

    Thanks Robert and choongwh.

    Deeply appreciated

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WebLibrarian
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic