OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
CSV Import Failure due to bookID Error (0 viewing) 
BookLibary Component Support
Go to bottom Favoured: 0
TOPIC: CSV Import Failure due to bookID Error
#640
Ziyang (Visitor)
Fresh Boarder
Posts: 1
graphgraph
User Offline
CSV Import Failure due to bookID Error 6 Years, 9 Months ago Karma: 0  
I am trying to import csv file into book library.

I have to record in the csv file:
"2|0596516681|The End of Money and the Future of Civilization|Thomas H. Greco Jr.|English|White River Junction VT: Chelsea Green|On the next stage of monetary evolution that can liberate us from centralized money power, with design proposals for exchange-system architectures for local, regional, national, and global financial systems. 269p. $19.95pb. "

"10|0955160332|Managed by the Markets: How Finance Re-Shaped America|Gerald F. Davis|English|NY: Oxford UP|Gerald F. Davis (Prof of Management, U of Michigan). Describes how finance has replaced manufacturing at the center of the US economy over the past three decades, how the new finance-centered system works, and what challenges lie ahead. The turbulence of recent years starkly underscores the dangers of over-dependence on financial markets. 320p. $29.95."

From the above two records, you can see one bookID is 2, and the other is 10(first attribute).
But after import, the result is shown as follows:

We can see from the above results, all my bookIDs are changed into 0, and the second book cannot be imported due to the same bookID.
Could somebody tell why this happens? Thank you very much.
 
Logged Logged  
 
Last Edit: 2010/03/04 01:55 By .
  The administrator has disabled public write access.
#641
admin (Admin)
Admin
Posts: 4874
graph
User Offline Click here to see the profile of this user
Re:CSV Import Failure due to bookID Error 6 Years, 9 Months ago Karma: 61  
Hi,

Sorry not know why and where error in yours BookLibrary import/export
Please try download from OrdaSoft last version BookLibrary basic. Unzip it
find file admin.booklibrary.class.impexp.php.
Backup so file on self site. And do change that file from archive.

And again check import/export

Thanks,
OrdaSoft team
 
Logged Logged  
  The administrator has disabled public write access.
#653
libraent (User)
Junior Boarder
Posts: 35
graphgraph
User Offline Click here to see the profile of this user
Re:CSV Import Failure due to bookID Error 6 Years, 9 Months ago Karma: 0  
I'm having the same problem, it imported the first book then said all the rest were 0 for the bookid so it will not import.
 
Logged Logged  
  The administrator has disabled public write access.
#654
admin (Admin)
Admin
Posts: 4874
graph
User Offline Click here to see the profile of this user
Re:CSV Import Failure due to bookID Error 6 Years, 9 Months ago Karma: 61  
Hi,

What version BookLibrary you have?
Do you try did as I proposed before ?
for me all work good may be you will can send for me yours site (or demo) site account through Contact form - and I will try check where error

Thanks,

OrdaSoft team
 
Logged Logged  
  The administrator has disabled public write access.
#664
JZ (Visitor)
Fresh Boarder
Posts: 1
graphgraph
User Offline
Re:CSV Import Failure due to bookID Error 6 Years, 8 Months ago Karma: 0  
try putting a pipe at the end of each line: |
 
Logged Logged  
  The administrator has disabled public write access.
#665
admin (Admin)
Admin
Posts: 4874
graph
User Offline Click here to see the profile of this user
Re:CSV Import Failure due to bookID Error 6 Years, 8 Months ago Karma: 61  
Hi,

At end every line must be "Line end sings" that or n or rn !!!
That invisible sings - and please don't try self add them!!!

If I set "|" - "pipe" at end every line (before "Line end sings" - for me continue all work fine.

Thanks,
OrdaSoft team
 
Logged Logged  
  The administrator has disabled public write access.
Go to top
What are you looking for?
Anti-spam question: How many eyes has a typical person?