Upgrade wizards 

The extension ships upgrade wizards for the migration from its predecessor EXT:jobfair2 and for older installations of the job board.

Run them in the backend module Admin Tools > Upgrade > Upgrade Wizard or on the command line:

List and run the upgrade wizards 
vendor/bin/typo3 upgrade:list
vendor/bin/typo3 upgrade:run jweilandJobboardJobfairToJobboardMigration
Copied!

All wizards require an up-to-date database. Run vendor/bin/typo3 extension:setup (or the database analyzer) before, so that the new tables exist, and remove old tables and columns only afterwards.

After updating the extension 

Run these steps after every update of the extension:

  1. Update the database schema: vendor/bin/typo3 extension:setup or the database analyzer in Admin Tools > Maintenance > Analyze Database Structure. It creates the columns of the effective salary of the jobs, see Database columns.
  2. Run the upgrade wizards, if any are listed.

  3. Calculate the effective salary of all jobs once:

    Recalculate the effective salary of all jobs 
    vendor/bin/typo3 jobboard:salary:update --all
    Copied!

    If the site setting jobboard.salary.required is enabled (the default), jobs without a calculated effective salary are not listed.

  4. Make sure the TYPO3 Scheduler runs jobboard:salary:update once a day, see Daily update with the console command.
  5. Make sure the page TSconfig of the storage folder contains TCEMAIN.clearCacheCmd with the UIDs of all pages with the job board, see Clear the cache of the job board pages.
  6. Flush all caches: vendor/bin/typo3 cache:flush .

Available wizards 

Identifier What it does
jweilandJobboardJobfairToJobboardMigration Copies all records of the tables tx_jobfair2_domain_model_* into the tables tx_jobboard_domain_model_* . The UIDs are kept, so all relations between the records stay intact. Only columns that exist in both tables are copied. File references of employer logo, header image, tender documents and job advertisement are moved to the new table.
jweilandJobboardJobfairToJobboardCTypeMigration Changes content elements of the type jobfair2_jobfair to jobboard_jobboard and updates the permissions of backend user groups.
jweilandJobboardJobAreaToJobAreasMigration Moves the single occupational field of early job board installations (column job_area ) to the relation job_areas . Only needed if this column still exists.
jweilandJobboardSalaryGradeToSalaryGradesMigration Moves the single salary grade of early job board installations (column salary_grade ) to the relation salary_grades . Only needed if this column still exists.
jweilandJobboardJobFileColumnsToPluralMigration Moves the header images, employer logos and tender documents of jobs from the former columns header_logo , employer_logo and tender_file to the renamed columns header_logos , employer_logos and tender_files .
jweilandJobboardJobPathSegmentUpdate Creates the URL segment of all jobs without one, see Speaking URLs (route enhancer).
jweilandJobboardEmployerToEmployerAddressMigration Moves the employer name and logos of jobs (former columns employer and employer_logos ) to the employer address: the name becomes the company of the address (only if it is empty), the logos become its images (only if the address has no image yet). Jobs without employer address get an address of the same folder with exactly this company, or a new one. Only jobs of the default language are migrated; their translations without own employer address get the same address. Run it before the database compare removes the column employer . For jobs of EXT:jobfair2, it reads the name from the table tx_jobfair2_domain_model_job , so run it after jweilandJobboardJobfairToJobboardMigration.

Migrate from EXT:jobfair2 

  1. Install the job board (see Installation). Keep the tables of EXT:jobfair2 in the database for now.
  2. Run vendor/bin/typo3 extension:setup .
  3. Run jweilandJobboardJobfairToJobboardMigration.
  4. Run jweilandJobboardJobfairToJobboardCTypeMigration.
  5. Run jweilandJobboardEmployerToEmployerAddressMigration.
  6. Run jweilandJobboardJobPathSegmentUpdate.
  7. Calculate the effective salary of the migrated jobs: vendor/bin/typo3 jobboard:salary:update --all .
  8. Replace the TypoScript of EXT:jobfair2 by the site set of the job board and check the site settings, see Configuration.
  9. Check the options of the migrated content elements.
  10. Assign occupational fields and positions to the migrated jobs. EXT:jobfair2 had no occupational fields and no positions, so there is nothing to migrate for them.
  11. Check the salary information of the migrated jobs (salary mode and salary grades or minimum and maximum salary). Jobs without salary information are not shown, unless the site setting jobboard.salary.required is disabled.
  12. Set up the daily salary update and TCEMAIN.clearCacheCmd , see After updating the extension.
  13. Remove EXT:jobfair2 and its tables.

The UIDs of the jobs are kept. Jobs that visitors remembered with EXT:jobfair2 are not taken over: they were stored in the browser, the job board stores them in the TYPO3 session, see Remembered jobs.