[Isis-users] problems with converting excel database to winisis

Ambika ambika at arrow.org.my
Tue Mar 1 08:47:52 CET 2011


Dear all,

I have tried to convert an excel database using IsisAscii. I am not sure 
what I am doing wrong because while the data has been exported but the 
fields have not been set up. I tried using the quotes to separate the 
fields in order of it to be recognized when the fdts were being created 
automatically by IsisAscii. When I open the database the fields appear 
as the 1st record. While I can see the the mst, fdt, pft, fst etc.files 
are there when I open them in the database they appear as empty.

Steps I followed:
1. In the excel sheet created all the fields the organisation wanted in 
their database
2. converted the xls file to csv
3. opened the csv and used "" to separate the fields and saved file
4. used IsisAscii to save and import the file to mst

Can anyone help me and let me know what I am possibly doing wrong. 
Should I first create the database? If so then how do I import the file 
as I understand only iso files can be imported.

Eagerly looking for some help.

Best,
Ambika

------------
Ambika Varma
Programme Officer, Information and Documentation
Asian-Pacific Resource&  Research Centre for Women (ARROW)
Nos. 1&  2 Jalan Scott, Brickfields
50470 Kuala Lumpur, Malaysia
Telephone Nos.: +603.2273.9913 to 15
Fax No: +603.2273.9916
Website: www.arrow.org.my
Email: ambika at arrow.org.my

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20110301/2ee673dc/attachment.html>


More information about the isis-users mailing list