opencats.org

Hello,
I am searching for someone to support me to export a massive CATS database (contacts, ccompanies, candidates, job orders, ...) with thousands of documents, to be able to imported into a new ATS.
Can someone please help?
Thanks!
Fabien Bill

Hi Bill, your new ATS vendor normally offers this as a 'boarding' service?

Hello @ RussH,

No, they offer the import function but I need the export and they don't want to touch it.

We'll keep CATS but make a duplicate of our database for other purpose.

Could someone connect me with a person able to support us?

Best regards,

Fabien

Bill - just do the mysqldump command to get a copy of your entire database, and backup your attachments directory. A simple query can match your attachments to the candidate or contact records, off the top of my head;

mysqldump command (as root);
mysqldump -uroot opencats -p > backup_data.sql

(Assuming your database is called opencats)

Also backup everything under your attachments directory.

For Candidates - match them to the attachment like this

SELECT
a.attachment_id,
a.original_filename,
a.date_created,
c.candidate_id,
c.first_name,
c.last_name,
c.email1
FROM
attachment a
JOIN
candidate c ON a.data_item_id = c.candidate_id
WHERE
a.data_item_type = 100;


For Contacts;

SELECT
a.attachment_id,
a.original_filename,
a.date_created,
ct.contact_id,
ct.first_name,
ct.last_name,
ct.email1
FROM
attachment a
JOIN
contact ct ON a.data_item_id = ct.contact_id
WHERE
a.data_item_type = 120;