Only have access to files, not the app, and need to export data  [SOLVED]

Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules
Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
Post Reply
ChocolateMoose
Posts: 7
Joined: 07 Nov 2018, 18:39
what is two(2) plus three(3) ?: 5

Only have access to files, not the app, and need to export data

Post by ChocolateMoose » 24 Apr 2019, 14:45

Due to a recent breach of my website, I have had to update all my services to ensure I had the latest patches. Unfortunately, that broke OpenCATS as I am now on PHP 7.2.7 as part of the remediation. My IT team will not let us downgrade PHP now, so I'm unable to access OpenCATS from the front end. I do still have access to the file manager, and supposedly the database. If I could do a simple export from the back end (.csv, etc.), that would solve all my problems as I could then move to a different ATS. However, without that data I'm sunk. Is there any way around this in my situation? Thanks in advance for your help.

User avatar
RussH
Site Admin
Posts: 866
Joined: 12 Apr 2008, 08:28
what is two(2) plus three(3) ?: 5
Location: UK
Contact:

Re: Only have access to files, not the app, and need to export data

Post by RussH » 24 Apr 2019, 14:59

Sorry - sounds like you've been through it. If you're simply trying to export the data you can use phpmyadmin to export the contents of the MySQL database to a SQL file, or to a CSV where you could manipulate it with excel. Alternatively, you can run the php-7.x compatible version WHICH IS STILL IN TESTING https://github.com/RussH/OpenCATS/archi ... nTests.zip

This will install on PHP 7.0,7.1,7.2.. however there are some additional steps needed in PHP7.2 to enable mcrypt support (the short answer is to use PECL) if you wanted to carry on running OpenCATS.

The PHP 7.x version won't be tagged for release for a few weeks/months, as some of the unit tests fail.. that's more an issue of the unit tests not supporting php7 than an issue with the actual OpenCATS code.
RussH

Report your issues and feature requests;
https://github.com/opencats/opencats/issues

Please CLICK THE TICK to accept the answer!

ChocolateMoose
Posts: 7
Joined: 07 Nov 2018, 18:39
what is two(2) plus three(3) ?: 5

Re: Only have access to files, not the app, and need to export data

Post by ChocolateMoose » 24 Apr 2019, 15:06

Thanks Russ. Any chance you could elaborate on exporting to CSV from my phpmyadmin? That sounds like it may be my only option. I don't think the powers that be will let me install a beta version of anything at this point.

User avatar
RussH
Site Admin
Posts: 866
Joined: 12 Apr 2008, 08:28
what is two(2) plus three(3) ?: 5
Location: UK
Contact:

Re: Only have access to files, not the app, and need to export data  [SOLVED]

Post by RussH » 24 Apr 2019, 15:27

ahh, third option, you can run it entirely as a docker container. Either the old version with its own entirely separate version of php or the new version. Nice and secure, too.

Anyway, for csv export, just navigate to the tables candidates (to export candidate details), then contact (for contact details) and finally joborder (for vacancies) - then click the export tab (shown in the screenshot)

Image
RussH

Report your issues and feature requests;
https://github.com/opencats/opencats/issues

Please CLICK THE TICK to accept the answer!

ChocolateMoose
Posts: 7
Joined: 07 Nov 2018, 18:39
what is two(2) plus three(3) ?: 5

Re: Only have access to files, not the app, and need to export data

Post by ChocolateMoose » 24 Apr 2019, 15:41

Thanks for all your help. I'll give this a try and will report back.

ChocolateMoose
Posts: 7
Joined: 07 Nov 2018, 18:39
what is two(2) plus three(3) ?: 5

Re: Only have access to files, not the app, and need to export data

Post by ChocolateMoose » 24 Apr 2019, 16:34

Thanks Russ. This did it for me. I now have my candidate data in an Excel file and can work on migrating it out. Hopefully OpenCATS gets moved to normal release for PHP 7 soon.

Post Reply