Rwanda Job Sync (Team → Rwanda JobSite)

Country: Rwanda (RW) Country-Specific Sync Default Company ID: 4171 Default User ID: 13206 Last Sync ID: 0
Rwanda Job Sync Features:
  • Last Sync ID Tracking - Only syncs jobs with ID > 0
  • Country-specific sync - Only syncs jobs where Country = 'Rwanda'
  • Force country to Rwanda - All jobs will have country field set to 'Rwanda'
  • Default Values - Sets companyid=4171 and uid=13206
  • Status-based sync - Only syncs jobs with sync_status = 'pending' or NULL
  • Batch processing - Processes 500 jobs at a time

21

Rwanda Team Jobs

Country = 'Rwanda'

0

Synced to JobSite

sync_country = 'rw'

0

Failed Syncs

Requires attention

2

Pending Sync

ID > 0
Total Team Jobs (All Countries)

24

pc0ww_JobsExport
Rwanda Jobs in JobSite

97

country = 'Rwanda'
Synced from Team

97

sync_country = 'rw'
Database Information (Rwanda)
Source Database (Team)
Host: localhost
Database: melafabs_Teamayson
Table: pc0ww_JobsExport
Filter: Country = 'Rwanda'
Last Sync ID: 0
Pending Jobs: ID > 0
Destination Database (Rwanda JobSite)
Host: localhost
Database: melafabs_JOBSITyson
Table: icop0_js_job_jobs
Sync Country: 'rw'
Sync Source: teamsite_export
Tracking Fields: source_id, sync_country, last_sync
Sync Query Logic
SELECT * FROM pc0ww_JobsExport
WHERE Country = 'Rwanda'
AND (sync_status = 'pending' OR sync_status IS NULL)
AND id > 0
ORDER BY id ASC
LIMIT 500

This query will fetch:

  • Only Rwanda jobs (Country = 'Rwanda')
  • Jobs that haven't been synced or have pending status
  • Jobs with ID greater than last recorded sync ID (0)
  • Maximum 500 jobs per sync to prevent timeout
Rwanda Job Sync Action
2 Rwanda jobs pending sync!

These jobs have ID > 0 and haven't been synced to Rwanda JobSite yet.

Ready to sync 2 Rwanda jobs from Team to Rwanda JobSite

Will process jobs with ID > 0 (Last sync ID: 0)

Filter: Country = 'Rwanda' AND ID > 0
Rwanda Job Sync Logs

No Rwanda job sync logs yet. Perform your first sync to see logs here.

Logs are stored in: pc0ww_job_sync_logs_rw table