WordPress.org

Ready to get started?Download WordPress

Forums

WebLibrarian
[resolved] CVS File (18 posts)

  1. scarletcarnival
    Member
    Posted 1 year ago #

    I've attempted to create a .cvs file to upload and I continue to get "undefined column" errors no matter how I work the file.

    Is there some trick to getting the bulk upload to work?

    Thank you

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

  2. Robert Heller
    Member
    Plugin Author

    Posted 1 year ago #

    The column headers have to match the defined columns used by the database. Can you upload your .csv file somewhere so I can have a look at it?

  3. scarletcarnival
    Member
    Posted 1 year ago #

    Thank you. You answered this question already. I have a second one, but I'll start a new thread for it.

  4. IHawkings
    Member
    Posted 1 year ago #

    Hi, I really love this plug-in.

    I'm having the same problem with the .csv file. I have barcode, title, author, subject and description as the columns.

    I am getting the error "Bad number of columns: 1"

    Also, is there any way to to a Bulk upload through Amazon, or will I have to go in an update each title with the book title covers etc.

    Thanks in advance for your help!

  5. scarletcarnival
    Member
    Posted 1 year ago #

    What I found is that I had to ensure the .csv file was saved as Windows ASCI, first of all. If that continued to throw errors, then I had to go in a manually add another line break into each line. Sometimes that worked. Sometimes just doing that, saving the file, going back into the file and removing them, and re-saving it a second time actually worked. I don't know why.

    The Amazon feature is neat but quirky. It would be really nice to be able to have Amazon pull in information much like LibraryThing does. However, this would also mean that the ISBN number column would be required *while* still adding those books without an ISBN and tagging them in some way for manual completion. I'm not sure that this plugin will get that complicated. It's awesome for a small library, trust me. But once you get past a certain point, you're going to want a full-blown LMS.

    Granted, I'd probably PAY good money to see this plugin developed to that point, but that's a whole lotta work for one guy. But then, if it were to go that direction, I have a whole wish list of features. LOL! But, in any regard, I can't sing its praises enough despite its limitations.

  6. IHawkings
    Member
    Posted 1 year ago #

    Wonderful! I saved as Windows and it worked! Can't thank you enough.

    I agree, it's a fantastic plugin for a small library and it would be nice to see it developed further. We're really pushing the limits of WordPress here!

    Thanks so much!

  7. Robert Heller
    Member
    Plugin Author

    Posted 1 year ago #

    scarletcarnival: There is an Open Source 'full-blown LMS' out there: Evergreen (OpenILS) -- http://evergreen-ils.org/. OTOH, that might be more that you would want. It is what is currently in use by C/W Mars for its member libraries. It supports things like interlibrary loans, understands MARC records, and so on.

  8. scarletcarnival
    Member
    Posted 1 year ago #

    Hi Robert. You've been extremely helpful in getting WebLibrarian up and running for me. I've examined Evergreen and I like it to some extent. I found it much easier to work with than the Koha LMS though I prefer Koha for its features.

    WebLibrarian, as I have said here and elsewhere, is an amazing plug-in. I'm thrilled to be using it. Is there any place that I might offer a couple of suggestions? I don't want to be presumptuous on your time or generosity here, to be sure, and I certainly have no experience with plug-in development so I can only image the time and investment you put into this project. I've been working with the setup on two different sites—one smaller with less than 500 books and one medium sized with over 1600 volumes—and I've had a couple of thoughts that would make initial setup, at the least, a bit more fluid and efficient if such modifications are even possible (which leads back to the whole 'I have no experience in such things' admission).

    Regardless, I cannot thank you enough for the time you've put into this plug-in. It is remarkable as is and very much up to the task for which it was designed.

    Best regards,
    Bishop

  9. Robert Heller
    Member
    Plugin Author

    Posted 1 year ago #

    This forum is probably as good a place as any. It might also make some sense, partitularly with concrete suggestions / bug reports to use Deepwoods Software's Bugzilla at the URL: http://bugzilla.deepsoft.com/enter_bug.cgi?product=Web%20Librarian. How possible your suggestions might be to implement of course does depend on what is possible with the Word Press plugin framework and does depend on how much time I have available, etc.

  10. mediatecario
    Member
    Posted 11 months ago #

    Bad number of columns: 1
    it's terrible
    do't go
    all day and evening to try all support answer
    it's incredible!
    excuse me

    i use excel from a mac to convert in csv

    help!!!!

  11. mediatecario
    Member
    Posted 11 months ago #

    ok with open office is all ok

  12. mediatecario
    Member
    Posted 11 months ago #

    don't use office for mac to do csv!!!!!
    thanks ciao

  13. Robert Heller
    Member
    Plugin Author

    Posted 11 months ago #

    Yes, mess-office seems to be a disaster when it comes to CSV files. M$ seems incapable of dealing inter-operatibly with standard formats.

  14. tzeryong
    Member
    Posted 11 months ago #

    I have facing some challenge while doing Add New Bulk

    Bad number of columns: 16

    Any thing that i'am doing not right

    P/S: was first thought because Chinese books can't be add, however still facing the challenge while add English books.
    this is the link to the file.

    https://www.dropbox.com/s/cwn26pvryudndvg/export%20file.csv

    Deeply appreciated.

  15. Robert Heller
    Member
    Plugin Author

    Posted 11 months ago #

    I imported the file into my test site without problem. You did select the "Use CSV Header" checkbox? Also: you should fix your file: the ISBN's are formatted as floating point numbers (n.nnnnnE+12) -- you need to set the data type of that column as "string" and not "number". Also the file has 31 empty rows of commas, so 31 books are entered with generated barcodes with blank data fields.

  16. tzeryong
    Member
    Posted 10 months ago #

    Hi Robert,

    Thanks again for your highlight,
    Yes, i did not select the "use CSV Header" checkbox.
    Yes, notice about the ISBN, Can you guide on how to change to 'String'?
    right click and to format column, .......?

    Robert, how can i erase the 31 empty rows of commas, I can't see it from me excel sheet.

    Thousand thanks.

  17. Robert Heller
    Member
    Plugin Author

    Posted 10 months ago #

    You need to select the "use CSV Header" checkbox, unless your CSV file has no headers and has the data in the proper order.

    I know nothing about Excel (I have never used it) and have no idea how to get Excel to treat an ISBN (a string of digits) as a string and not as a number. I would say Excel is really the wrong tool -- *I* would never use a spreadsheet for this purposes -- I would create the CSV file using a plain text editor (Micro Emacs would be my personal choice).

  18. alexbotkin
    Member
    Posted 10 months ago #

    I trick excel by copying the column of numbers; then paste that into a true ASCII editor, Notepad generally works although I prefer V-Edit.

    The delete the contents -entire column of data in excel. Highlight that column, change the format type to text, and then paste back the column of data that you copied.

    V-edit or a similar program is good because you can view the text in other formats (Hex, etc) and this allows you to see any extraneous junk that excel has added into you supposedly number only column.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.