OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
BookLibary Component Support
Go to bottom Favoured: 0
TOPIC: Import .csv file
#1440
johntennock (User)
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
Import .csv file 5 Years, 11 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.
#1443
admin (Admin)
Admin
Posts: 4882
graph
User Offline Click here to see the profile of this user
Re:Import .csv file 5 Years, 11 Months ago Karma: 61  
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.
#1447
johntennock (User)
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
Re:Import .csv file 5 Years, 11 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.
#1451
admin (Admin)
Admin
Posts: 4882
graph
User Offline Click here to see the profile of this user
Re:Import .csv file 5 Years, 11 Months ago Karma: 61  
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.
#1452
johntennock (User)
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
Re:Import .csv file 5 Years, 11 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.
#1456
johntennock (User)
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
Re:Import .csv file 5 Years, 11 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
What are you looking for?
Anti-spam question: How many eyes has a typical person?