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

BookLibary Component Support

Go to bottom Favoured: 0

Export CSV file Problem

kentcheung2000 (Visitor)
Posts: 0
graphgraph
User Offline
export CSV file Problem 13 Years, 10 Months ago
Karma: 0  
Hi,

I have a problem with my csv file. When I try to export the books, i cannot see the chinese characters in the csv file.

I already change the coalition to utf8_unicode_ci in the phpadmin. I can see the chinese characters on the website. Is there something else I need to do? Many Thanks.

K.C.

Does anyone has a copy of xsl so I can use it for xml? Thanks.


CREF-002|n/a|信徒聖經註釋 (卷一)|華活特博士|||Not specified|2|0||||||0|2010-12-30 17:12:16|||0| CREF-001|n/a|主題彙析聖經|黃|||Not specified|3|0||||||0|2010-12-30 17:10:19|||0|
Logged Logged
Last Edit: 2011/01/10 06:38 By .
The administrator has disabled public write access.
aaa (Visitor)
Posts: 0
graphgraph
User Offline
Re:export CSV file Problem 13 Years, 10 Months ago
Karma: 0  
Hi,

What version you use ? When download it ?

Please check XML - export. In XML file - all look good ?

Thanks,
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
kentcheung2000 (Visitor)
Posts: 0
graphgraph
User Offline
Re:export CSV file Problem 13 Years, 10 Months ago
Karma: 0  
Thank you for your reply. XML is ok. However, my batch file is in excel format.

I try to use Filemaker to export to xml but it requires me to learn xsl.

What is the best way to prepare for a xml file for import?

I look at the export version and it seems it is different from the xml file i export from filemaker....

Thanks.

Kent
Logged Logged
The administrator has disabled public write access.
aaa (Visitor)
Posts: 0
graphgraph
User Offline
Re:export CSV file Problem 13 Years, 10 Months ago
Karma: 0  
Please use native Book Library import export !!

I not understand you have problems with native import/export or not ?

We can help resolve yours error in Book Library - not some other !

Please do XML export from Book Library - all look OK ?

Please do CSV export from Book Library - all look OK ?

Please create file for import - exactly as you see file format what you took with export.

Please set UTF-8 as charset for that file.

Please write where errors

Thanks,
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
kentcheung2000 (Visitor)
Posts: 0
graphgraph
User Offline
Re:export CSV file Problem 13 Years, 10 Months ago
Karma: 0  
Thank you for your reply. I have a excel file with a list of chinese books. Is there a way I can use the data of this file to export it to the book library? Many Thanks.
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8361
graph
User Offline Click here to see the profile of this user
Re:export CSV file Problem 13 Years, 10 Months ago
Karma: 102  
You may check ours XML or CSV export - and rebuild self file with exactly so format. And do it import !

Please use UTF-8 encoding !

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