Friday, November 24, 2017

CDS/ISIS (WinISIS) Conversion to plain text files

Well, there's always a time in which you find some really, really obscure shit in your life and you wonder why or how you dropped into this place where paths seem very... should I say, fucking weird?

Couple of years ago I was studying, well I still am, at the Faculty of Humanities and Social Sciences of UABC and came to find this really weird database the Institute for Historical Investigations has, never heard of it, or the format, UNESCO was behind it, that's it, not much to do there. Digging up more info into this it turns out that the thing does not work on anything above Windows XP, furthermore this was made for MS-DOS back in the day and has some awkward limitations that cannot be fixed in any way or form, did I mention UNESCO dropped support for it a long time ago and this thing is incompatible with other formats?

What this means in the long run is that you are stuck with something that cannot be upgraded, modified or easily transition to something that has web capabilities, oh yeah, since this was made way back in the day there was no way to get this on the internet without downloading and working with some obscure libraries.

So I volunteered to fix this and make something at least in PHP to have something that could be easily worked with, the problem remains though on how to get this out.

Round 0: Facing thy enemy without knowing anything about it
Does it work: In some lucky instances probably but not this one, after looking around for documentation and trying to do this directly through Python and some Linux commands I noted that this was a stupid thing to do as I had little to no understanding of ISO2709 or MARC for that matter.

Round 1: OpenISIS/Malete
Does it work: Yes and no? For the life of me I could not figure or understand how to get this to work, I even managed to find the executable binary file for Linux but it does not work, it simply will not work without going apeshit about the extensions not being in lowercase and missing some of the files. To top it off this is no longer supported by the developer, unfortunate.

Round 2: isis2json
Does it work: Nope, and this looked like the most viable candidate but I could simply not work out the kinks and requirements, I followed everything that was in the instructions but apparently I'm doing something wrong or it simply is not working anymore since it was done 6 years ago.

Round 3: Isis2XML
Does it work: I don't know about this one, I did not get the chance to try it out since this is for Windows and I could not be bothered to get as virtual machine running with Windows XP in order to test it. May work on other versions, I won't lie, but again I do not have the time to bother with it.

Round 4: CDS/ISIS PHP
Does it work: Nope, could not even figure out what to do with it, you get a couple of files to include somewhere but from what I understand this is part or became part of OpenISIS.

Round 5: Biblio-Isis-0.24
Does it work: Surprisingly yes, had to figure out how to install the module after downloading and uncompressing it (first time using PERL) and afterwards get the initial script to work, I was really surprised when I managed to pipe everything out to a file in which everything came out, well, there is the concern that some characters are not showing up but this can be fixed later, the only problem left for me right now is to figure out a way to get everything moved around in such a way that it can be easily imported to MariaDB or anything else.

http://search.cpan.org/~dpavlin/Biblio-Isis-0.24/lib/Biblio/Isis.pm <- Link to the savior of the day.

Sunday, November 5, 2017

It's been four, *ahem* FIVE years

True, it's been four years now that I've written anything for this blog, or has it been three and a bit?

I think it's time to come back with some new and interesting ideas and tips, maybe even some assistance, with some current projects I have in mind and currently running around my head but haven't properly landed since I lack some of the knowledge to perform it the way I want it to.

While I have moved on most of my work from Windows to Linux that does not mean I have lost sight of the original idea that brought this site to life, also I keep what I personally call the K. Mandla directive alive by putting old hardware back to use with true purpose and intention, I do not intend to make a clock out of a Pentium III machine, rather I intend to get the most out of it by getting it working in a business or industrial environment when applicable or assisting schools when possible, not that it takes most of these schools out of the horrible strain they are in but having a computer with a minimalist version of Linux that lets you browse and work some documents is better than nothing.

Other things currently working on would be an Open Source Timeclock (something simple and easy to install and use using PHP and Python) and an experiment with a Raspberry Pi and Splunk (more on Splunk and other interesting tools in the future).

Installing OSSEC 3.7.0 on Debian 11 (Bullseye) How-To

Now that version 3.7.0 has been released I took another deep dive into how this is compiled from Source, as usual I brought this onto me bec...