How can I export koha bibliography into csv file (or excel)
Our university authority need each department to report books in excel format. Is there a neat way to generate a excel spreadsheet containing the required MARC fields? Thanks in advance! -- Xu Benda Fundamental Science of Mathematics and Physics, Tsinghua University, Beijing, P.R.China, 100084 tel:86-10-51531861 http://learn.tsinghua.edu.cn:8080/2005012177
Hello again, Xu If you use Webmin you'll be able to export each table data in CSV format (you can opt for a comma or tab separated values) and then edit it in excel or open office. This is one feature I've used, maybe you'll find other ways of achieving the result you want. Godd luck, Maria --------------------------------------------------- CITI / DEP - Divisão de Estudos e Projectos INETI - Instituto Nacional de Engenharia, Tecnologia e Inovação Estrada do Paço do Lumiar, 22 - 1649-038 Lisboa - Portugal Tel.: + 351 217 127 030 (directo) Fax: + 351 217 127 059 Endereço de correio electrónico: maria.doria@ineti.pt
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Hero_xbd!.RRR Sent: terça-feira, 3 de Abril de 2007 15:24 To: koha@lists.katipo.co.nz Subject: [Koha] How can I export koha bibliography into csv file (or excel)
Our university authority need each department to report books in excel format. Is there a neat way to generate a excel spreadsheet containing the required MARC fields?
Thanks in advance!
-- Xu Benda
Fundamental Science of Mathematics and Physics, Tsinghua University, Beijing, P.R.China, 100084
tel:86-10-51531861 http://learn.tsinghua.edu.cn:8080/2005012177
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Esta mensagem foi verificada por uma Webshield Appliance da McAfee. INETI - DSIC
The biblio data and item data are placed separately. Is there already a script in Koha or a mechanism to export biblio and item into a single uniform file? Maria Doria wrote:
Hello again, Xu
If you use Webmin you'll be able to export each table data in CSV format (you can opt for a comma or tab separated values) and then edit it in excel or open office. This is one feature I've used, maybe you'll find other ways of achieving the result you want.
Godd luck, Maria
--------------------------------------------------- CITI / DEP - Divisão de Estudos e Projectos INETI - Instituto Nacional de Engenharia, Tecnologia e Inovação Estrada do Paço do Lumiar, 22 - 1649-038 Lisboa - Portugal Tel.: + 351 217 127 030 (directo) Fax: + 351 217 127 059 Endereço de correio electrónico: maria.doria@ineti.pt
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Hero_xbd!.RRR Sent: terça-feira, 3 de Abril de 2007 15:24 To: koha@lists.katipo.co.nz Subject: [Koha] How can I export koha bibliography into csv file (or excel)
Our university authority need each department to report books in excel format. Is there a neat way to generate a excel spreadsheet containing the required MARC fields?
Thanks in advance!
-- Xu Benda
Fundamental Science of Mathematics and Physics, Tsinghua University, Beijing, P.R.China, 100084
tel:86-10-51531861 http://learn.tsinghua.edu.cn:8080/2005012177
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Esta mensagem foi verificada por uma Webshield Appliance da McAfee. INETI - DSIC
-- Xu Benda Fundamental Science of Mathematics and Physics, Tsinghua University, Beijing, P.R.China, 100084 tel:86-10-51531861 http://learn.tsinghua.edu.cn:8080/2005012177
Oh, sorry, I can find "export biblio" in Koha Intranet did the work.... Hero_xbd!.RRR wrote:
The biblio data and item data are placed separately.
Is there already a script in Koha or a mechanism to export biblio and item into a single uniform file?
Maria Doria wrote:
Hello again, Xu
If you use Webmin you'll be able to export each table data in CSV format (you can opt for a comma or tab separated values) and then edit it in excel or open office. This is one feature I've used, maybe you'll find other ways of achieving the result you want.
Godd luck, Maria
--------------------------------------------------- CITI / DEP - Divisão de Estudos e Projectos INETI - Instituto Nacional de Engenharia, Tecnologia e Inovação Estrada do Paço do Lumiar, 22 - 1649-038 Lisboa - Portugal Tel.: + 351 217 127 030 (directo) Fax: + 351 217 127 059 Endereço de correio electrónico: maria.doria@ineti.pt
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Hero_xbd!.RRR Sent: terça-feira, 3 de Abril de 2007 15:24 To: koha@lists.katipo.co.nz Subject: [Koha] How can I export koha bibliography into csv file (or excel)
Our university authority need each department to report books in excel format. Is there a neat way to generate a excel spreadsheet containing the required MARC fields?
Thanks in advance!
-- Xu Benda
Fundamental Science of Mathematics and Physics, Tsinghua University, Beijing, P.R.China, 100084
tel:86-10-51531861 http://learn.tsinghua.edu.cn:8080/2005012177
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Esta mensagem foi verificada por uma Webshield Appliance da McAfee. INETI - DSIC
-- Xu Benda Fundamental Science of Mathematics and Physics, Tsinghua University, Beijing, P.R.China, 100084 tel:86-10-51531861 http://learn.tsinghua.edu.cn:8080/2005012177
participants (2)
-
Hero_xbd!.RRR -
Maria Doria