OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?

BookLibary Component Support

Go to bottom Favoured: 0

Import .csv file

johntennock (User)
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
Import .csv file 13 Years, 4 Months ago
Karma: 0  
I am trying to import books into a new BookLibrary installation using the .csv import function.

The book details import OK but the description remains blank.

The source data is in the form of an Excel spreadsheet.

Any helpful suggestions appreciated.

Cheers,
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8243
graph
User Offline Click here to see the profile of this user
Re:Import .csv file 13 Years, 4 Months ago
Karma: 101  
Please download last version from site and change in self instalation so files:

admin.booklibrary.class.impexp.php
csv.xsl

Thanks,
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
johntennock (User)
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
Re:Import .csv file 13 Years, 4 Months ago
Karma: 0  
admin wrote:
Please download last version from site and change in self instalation so files:

admin.booklibrary.class.impexp.php
csv.xsl

I have downloaded the last version.
It does contain a file admin.booklibrary.class.impexp.php (dated 29/11/2010)

That file contains the following reference to csv.xsl
switch($type){
case 'csv':
$InformationArray['xslt_file'] = 'csv.xsl';
$InformationArray['out_file'] = $fileName . '.csv';
mosBooklibraryImportExport :: transformPHP4($InformationArray);
break;

default:
break;
}

return $InformationArray;

but I have no idea how to use this information to import the book description.

A little more help would be appreciated...
Logged Logged
Last Edit: 2010/12/23 06:27 By johntennock.
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8243
graph
User Offline Click here to see the profile of this user
Re:Import .csv file 13 Years, 4 Months ago
Karma: 101  
I am sorry, please download yet new Book Library basic version, yet small fix.

For correct book import / export, Please do so:
1. Download last Book library version and unzip it.
2. in folder "com_booklibrary_BASIC_2_0_2010_11_31" you will find file: "admin.booklibrary.class.impexp.php" please move it to folder: "{yours host}/administrator/components/com_booklibrary/"
3. at folder: "com_booklibrary_BASIC_2_0_2010_11_31/exports" you will find file: "csv.xsl". please move it to folder: "{yours host}/administrator/components/com_booklibrary/exports/"

And all will work

Thanks,
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
johntennock (User)
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
Re:Import .csv file 13 Years, 4 Months ago
Karma: 0  
Many thanks. That is much clearer.
I'll try it shortly.


Cheers,
Logged Logged
The administrator has disabled public write access.
johntennock (User)
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
Re:Import .csv file 13 Years, 4 Months ago
Karma: 0  
admin wrote:
I am sorry, please download yet new Book Library basic version, yet small fix.

For correct book import / export, Please do so:
1. Download last Book library version and unzip it.
2. in folder "com_booklibrary_BASIC_2_0_2010_11_31" you will find file: "admin.booklibrary.class.impexp.php" please move it to folder: "{yours host}/administrator/components/com_booklibrary/"
3. at folder: "com_booklibrary_BASIC_2_0_2010_11_31/exports" you will find file: "csv.xsl". please move it to folder: "{yours host}/administrator/components/com_booklibrary/exports/"

I made the changes above, deleted all existing books, then repeated a small import. The description field remained blank.
I am using a file with | field delimiter, and with | after the last field. The books have no ISBN so have used 0 in this field. I am not looking up any details. Just a very simple .csv import.

Cheers,
Logged Logged
The administrator has disabled public write access.
Go to top
»