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

I'm unsure of your specific activities, but here are two options to consider:

Duplicate the existing web application/database and customize as needed. Follow this guide for backup and restoration:
https://www.techrepublic.com/article/ho ... -on-linux/

If you intend to upgrade to a newer version, review migration documents to familiarize yourself with the process.
https://opencats-documentation.readthed ... store.html

bill.tranquille wrote: ↑16 Apr 2025, 17:52 Hello Papa's Pizzeria ,
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

Hey Fabien, dealing with a massive database export can feel overwhelming! Have you tried breaking down the export into smaller batches? Or perhaps look into specific ATS migration tools designed for CATS. Good luck finding a solution!

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;

A clean export of CATS data and documents is essential for smooth transitions, especially during system migrations or audits. Ensuring proper formatting, data integrity, and file organization can save a lot of time later. For additional tips on data management, exports, and digital tools, https://wordslibrary.com/ provides useful and well-explained content worth exploring.