[Isis-users] Export CDSISIS database to excell

[De Smet Egbert]

Use the ISIS Formatting language to export your data to a 'Comma Separate Values'  format which you can import into MS software such as Excel or Access.

The format should produce all fields of your database, preferably double-quoted, with the 'comma' as an inconditional literal. Inconditional, because even if the field is not there or empty, it should be getting a comma so as to preserve the number of fields for every record to be the same.
So, assuming you have v1, v2, and v10 :
|"|v1|"|,',',|"|v2|"|,',',|"|v10|"|
etc. for more/other fields.
Depending on the ISIS-version you use (not specified) you then run a 'report' to output all data over a range of MFN's or you use a command-line solution with e.g. the CISIS mx-tool : 
mx mydb pft=@myCSVpft.pft now -all >myCSVfile.csv

Egbert de Smet
Universiteit Antwerpen
________________________________________
From: isis-users [isis-users-bounces+egbert.desmet=ua.ac.be at iccisis.org] on behalf of Akin Oke [akin_oke at yahoo.com]
Sent: Thursday, November 10, 2016 9:27 AM
To: isis-users at iccisis.org
Subject: [Isis-users] Export CDSISIS database to excell

Sirs, I have a CDSISIS Database for a small library. I want to know how to download the CDSISIS database to excel or Access formart.
Please kindly guide me.

Akin Oke Kenneth Dike Library University of Ibadan Ibadan, Oyo State Nigeria +234-805-512-6079 +234-706-551-9273
_______________________________________________
isis-users mailing list
isis-users at iccisis.org
To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users
Or contact Henk Rutten: hlrutten at xs4all.nl