Support » Plugin: WebLibrarian » CSV import, sql db and general settings

  • Resolved


    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

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Robert Heller


    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?

    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

    Plugin Author Robert Heller


    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?

    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

    Plugin Author Robert Heller


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

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

    Dear Mr Robert,

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

    Plugin Author Robert Heller


    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.

    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.

    Thanks Robert and choongwh.

    Deeply appreciated

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘CSV import, sql db and general settings’ is closed to new replies.