Automated update of COMPANY CALENDAR from the HR calendar (converted in csv format)

Procedure: source link https://docs.google.com/spreadsheets/d/1ClHcViJGZUzoqQde6Su5Y5MrriWt981BBOfHmg1UBH0/edit#gid=0

  1. Convert file to csv. The default separator is a comma (,)

  2. Upload the file to the Bitrix media library (or to any other place): Screenshot_2022-06-17_at_10.45.45_am

  3. Get a link to this file: Screenshot_2022-06-17_at_10.45.53_am

  4. Launch a terminal session from under the user's Bitrix to Production Server.

  5. Execute the command:

php /home/bitrix/www/local/cli -c=calendar -m=hrupdate --path="%previously copied file path%" --fullUpdate --debug

--fullUpdate updates all previously created records --debug will write the log file to /local/logs

Screenshot_2022-06-17_at_10.58.58_am