|
|
|
Import .csv file 1 Year, 5 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
|
|
|
The administrator has disabled public write access.
|
admin (Admin)
Admin
Posts: 1673
|
|
Re:Import .csv file 1 Year, 5 Months ago
|
Karma: 17
|
|
Please download last version from site and change in self instalation so files:
admin.booklibrary.class.impexp.php
csv.xsl
Thanks,
OrdaSoft team
|
|
|
|
Logged
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Import .csv file 1 Year, 5 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
|
|
|
Last Edit: 2010/12/23 00:27 By johntennock.
|
|
|
The administrator has disabled public write access.
|
admin (Admin)
Admin
Posts: 1673
|
|
Re:Import .csv file 1 Year, 5 Months ago
|
Karma: 17
|
|
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
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Import .csv file 1 Year, 5 Months ago
|
Karma: 0
|
|
Many thanks. That is much clearer.
I'll try it shortly.
Cheers,
|
|
|
|
Logged
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Import .csv file 1 Year, 5 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
|
|
|
The administrator has disabled public write access.
|
|
Favoured: 0
