OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
Import books from an .xls or an .xlsx file? (1 viewing) (1) Guest

BookLibary Component Support

Go to bottom Favoured: 0

Import books from an .xls or an .xlsx file?

alorakos (User)
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
Import books from an .xls or an .xlsx file? 9 Years, 6 Months ago
Karma: 0  
Hello,

In booklibrary pro, is it possible to import books from an .xls or an .xlsx file?

I have some books with all the details in an .xls file and I was wondering how to do it.

If not, is there a way to "easily" import 500 books? I mean not one-by-one manualy

Thanks
Logged Logged
The administrator has disabled public write access.
Taras (User)
Platinum Boarder
Posts: 2857
graphgraph
User Offline Click here to see the profile of this user
Re:Import books from an .xls or an .xlsx file? 9 Years, 6 Months ago
Karma: 58  
Hello,

You can do export xls or an .xlsx files to CSV format. There are many programs, that can do this

And then make CSV IMPORT:

At the moment the following CSV format is supported: BookID | ISBN | Title | Authors | Language | Publisher | Description |
Fields are separated by a pipe character ( | )
You can import a whole list with just BookID and ISBN by leaving the other fields empty, for example: BookID | ISBN | empty | empty | empty | empty | empty |
Afterwards you can fetch the information from Amazon and publish
WARNING: do not use CSV import if there are Book Descriptions or Book Reviews present, in that case use XML instead!

ordasoft.com/Book-Library-Software-Joomla.html

If you have other questions, please ask.

Thanks,
Taras
OrdaSoft team.
Logged Logged
The administrator has disabled public write access.
alorakos (User)
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
Re:Import books from an .xls or an .xlsx file? 9 Years, 5 Months ago
Karma: 0  
I tried this and it worked

but I have an other problem now

after I import the books I want, when I go to add a book manually (from front-end or back-end), I get this error:


"You have no numeric BookId. Please set option Book ID auto-increment to 'No' or change all Book ID to numeric"


I want the Book ID to be auto created to my website, but after the import, I cant do it.

Any solution?
Logged Logged
The administrator has disabled public write access.
Taras (User)
Platinum Boarder
Posts: 2857
graphgraph
User Offline Click here to see the profile of this user
Re:Import books from an .xls or an .xlsx file? 9 Years, 5 Months ago
Karma: 58  
Hello,

In our component you must add BookID, it can be any number, but it must be - it's feature of component.

Thanks,
OrdaSoft team.
Logged Logged
The administrator has disabled public write access.
alorakos (User)
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
Re:Import books from an .xls or an .xlsx file? 9 Years, 5 Months ago
Karma: 0  
I put a number to BookID when i import books. I am doing the import with an id, just like you said.

You did not understand

After the import, if the auto increament book id is on, i can not add books
Logged Logged
The administrator has disabled public write access.
Taras (User)
Platinum Boarder
Posts: 2857
graphgraph
User Offline Click here to see the profile of this user
Re:Import books from an .xls or an .xlsx file? 9 Years, 5 Months ago
Karma: 58  
Hello,

Give us please, FTP and admin access and we will fix problem. FTP and admin access You can send to our contact form.
ordasoft.com/About-us/OrdaSoft.html

If you have other questions, please ask.

Thanks,
Taras
OrdaSoft team.
Logged Logged
The administrator has disabled public write access.
Go to top
»