Import run: 1
sql error: :INSERT INTO tour_monitor_json
(
`run`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`datetime_import`,
`json`
) VALUES
(
'1',
'run1',
'run1',
'999999999-000000001',
'999999999-000000001',
'2025-03-15 12:34:43',
''
)
INSERT INTO tour_monitor_json
(
`run`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`datetime_import`,
`json`
) VALUES
(
'1',
'run1',
'run1',
'999999999-000000001',
'999999999-000000001',
'2025-03-15 12:34:43',
''
)
sql error: :INSERT INTO tour_monitor
(
`run`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`datetime_import`,
`attributes_type`,
`attributes_url`,
`Name`,
`a4l__Planned_Arrival_Time__c`,
`a4l__Minutes_Until_Planned_Arrival__c`,
`a4l__Last_RL_Checkin__c`,
`ETA_Lab__c`,
`Proben_abgeholt__c`,
`Route_Name__c`,
`a4l__Account__r_attributes_type`,
`a4l__Account__r_attributes_url`,
`a4l__Account__r_ Key__c`,
`calc_a4l__Last_RL_Checkin__c`,
`calc_a4l__Planned_Arrival_Time__c`,
`calc_ETA_Lab__c`
) VALUES
(
'1',
'run1',
'run1',
'999999999-000000001',
'999999999-000000001',
'2025-03-15 12:34:43',
'a4l__Route_Location__c',
'/services/data/v43.0/sobjects/a4l__Route_Location__c/a0R1p00000H1fkVEAR',
'Blumenstein (Praxis Rümlang)',
'',
'',
'2025-03-15T08:06:24.000+0000',
'',
'1',
'SamstagsTour',
'Account',
'/services/data/v43.0/sobjects/Account/0012400000ESvaqAAD',
'37',
'2025-03-15 09:06:24',
'1970-01-01 01:00:00',
'1970-01-01 01:00:00'
)
INSERT INTO tour_monitor
(
`run`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`datetime_import`,
`attributes_type`,
`attributes_url`,
`Name`,
`a4l__Planned_Arrival_Time__c`,
`a4l__Minutes_Until_Planned_Arrival__c`,
`a4l__Last_RL_Checkin__c`,
`ETA_Lab__c`,
`Proben_abgeholt__c`,
`Route_Name__c`,
`a4l__Account__r_attributes_type`,
`a4l__Account__r_attributes_url`,
`a4l__Account__r_ Key__c`,
`calc_a4l__Last_RL_Checkin__c`,
`calc_a4l__Planned_Arrival_Time__c`,
`calc_ETA_Lab__c`
) VALUES
(
'1',
'run1',
'run1',
'999999999-000000001',
'999999999-000000001',
'2025-03-15 12:34:43',
'a4l__Route_Location__c',
'/services/data/v43.0/sobjects/a4l__Route_Location__c/a0R1p00000H1fkVEAR',
'Blumenstein (Praxis Rümlang)',
'',
'',
'2025-03-15T08:06:24.000+0000',
'',
'1',
'SamstagsTour',
'Account',
'/services/data/v43.0/sobjects/Account/0012400000ESvaqAAD',
'37',
'2025-03-15 09:06:24',
'1970-01-01 01:00:00',
'1970-01-01 01:00:00'
)
SamstagsTour, Location: 37, ETA: , EFF (checkin): 2025-03-15T08:06:24.000+0000, proben: 1
sql error: :INSERT INTO tour_monitor
(
`run`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`datetime_import`,
`attributes_type`,
`attributes_url`,
`Name`,
`a4l__Planned_Arrival_Time__c`,
`a4l__Minutes_Until_Planned_Arrival__c`,
`a4l__Last_RL_Checkin__c`,
`ETA_Lab__c`,
`Proben_abgeholt__c`,
`Route_Name__c`,
`a4l__Account__r_attributes_type`,
`a4l__Account__r_attributes_url`,
`a4l__Account__r_ Key__c`,
`calc_a4l__Last_RL_Checkin__c`,
`calc_a4l__Planned_Arrival_Time__c`,
`calc_ETA_Lab__c`
) VALUES
(
'1',
'run1',
'run1',
'999999999-000000001',
'999999999-000000001',
'2025-03-15 12:34:43',
'a4l__Route_Location__c',
'/services/data/v43.0/sobjects/a4l__Route_Location__c/a0R1p00000H1gakEAB',
'Praxis Juna (Eberhard, Wartmann;Hübenthal)',
'',
'',
'2025-03-15T09:08:06.000+0000',
'',
'1',
'SamstagsTour',
'Account',
'/services/data/v43.0/sobjects/Account/0011p00001tCMCIAA4',
'115',
'2025-03-15 10:08:06',
'1970-01-01 01:00:00',
'1970-01-01 01:00:00'
)
INSERT INTO tour_monitor
(
`run`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`datetime_import`,
`attributes_type`,
`attributes_url`,
`Name`,
`a4l__Planned_Arrival_Time__c`,
`a4l__Minutes_Until_Planned_Arrival__c`,
`a4l__Last_RL_Checkin__c`,
`ETA_Lab__c`,
`Proben_abgeholt__c`,
`Route_Name__c`,
`a4l__Account__r_attributes_type`,
`a4l__Account__r_attributes_url`,
`a4l__Account__r_ Key__c`,
`calc_a4l__Last_RL_Checkin__c`,
`calc_a4l__Planned_Arrival_Time__c`,
`calc_ETA_Lab__c`
) VALUES
(
'1',
'run1',
'run1',
'999999999-000000001',
'999999999-000000001',
'2025-03-15 12:34:43',
'a4l__Route_Location__c',
'/services/data/v43.0/sobjects/a4l__Route_Location__c/a0R1p00000H1gakEAB',
'Praxis Juna (Eberhard, Wartmann;Hübenthal)',
'',
'',
'2025-03-15T09:08:06.000+0000',
'',
'1',
'SamstagsTour',
'Account',
'/services/data/v43.0/sobjects/Account/0011p00001tCMCIAA4',
'115',
'2025-03-15 10:08:06',
'1970-01-01 01:00:00',
'1970-01-01 01:00:00'
)
SamstagsTour, Location: 115, ETA: , EFF (checkin): 2025-03-15T09:08:06.000+0000, proben: 1
sql error: :INSERT INTO tour_monitor
(
`run`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`datetime_import`,
`attributes_type`,
`attributes_url`,
`Name`,
`a4l__Planned_Arrival_Time__c`,
`a4l__Minutes_Until_Planned_Arrival__c`,
`a4l__Last_RL_Checkin__c`,
`ETA_Lab__c`,
`Proben_abgeholt__c`,
`Route_Name__c`,
`a4l__Account__r_attributes_type`,
`a4l__Account__r_attributes_url`,
`a4l__Account__r_ Key__c`,
`calc_a4l__Last_RL_Checkin__c`,
`calc_a4l__Planned_Arrival_Time__c`,
`calc_ETA_Lab__c`
) VALUES
(
'1',
'run1',
'run1',
'999999999-000000001',
'999999999-000000001',
'2025-03-15 12:34:43',
'a4l__Route_Location__c',
'/services/data/v43.0/sobjects/a4l__Route_Location__c/a0R24000003qb8UEAQ',
'Walk-In',
'',
'',
'2025-03-15T10:51:52.000+0000',
'',
'1',
'SamstagsTour',
'Account',
'/services/data/v43.0/sobjects/Account/0012400000ESvooAAD',
'walkin',
'2025-03-15 11:51:52',
'1970-01-01 01:00:00',
'1970-01-01 01:00:00'
)
INSERT INTO tour_monitor
(
`run`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`datetime_import`,
`attributes_type`,
`attributes_url`,
`Name`,
`a4l__Planned_Arrival_Time__c`,
`a4l__Minutes_Until_Planned_Arrival__c`,
`a4l__Last_RL_Checkin__c`,
`ETA_Lab__c`,
`Proben_abgeholt__c`,
`Route_Name__c`,
`a4l__Account__r_attributes_type`,
`a4l__Account__r_attributes_url`,
`a4l__Account__r_ Key__c`,
`calc_a4l__Last_RL_Checkin__c`,
`calc_a4l__Planned_Arrival_Time__c`,
`calc_ETA_Lab__c`
) VALUES
(
'1',
'run1',
'run1',
'999999999-000000001',
'999999999-000000001',
'2025-03-15 12:34:43',
'a4l__Route_Location__c',
'/services/data/v43.0/sobjects/a4l__Route_Location__c/a0R24000003qb8UEAQ',
'Walk-In',
'',
'',
'2025-03-15T10:51:52.000+0000',
'',
'1',
'SamstagsTour',
'Account',
'/services/data/v43.0/sobjects/Account/0012400000ESvooAAD',
'walkin',
'2025-03-15 11:51:52',
'1970-01-01 01:00:00',
'1970-01-01 01:00:00'
)
SamstagsTour, Location: walkin, ETA: , EFF (checkin): 2025-03-15T10:51:52.000+0000, proben: 1
sql error: :INSERT INTO tour_monitor
(
`run`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`datetime_import`,
`attributes_type`,
`attributes_url`,
`Name`,
`a4l__Planned_Arrival_Time__c`,
`a4l__Minutes_Until_Planned_Arrival__c`,
`a4l__Last_RL_Checkin__c`,
`ETA_Lab__c`,
`Proben_abgeholt__c`,
`Route_Name__c`,
`a4l__Account__r_attributes_type`,
`a4l__Account__r_attributes_url`,
`a4l__Account__r_ Key__c`,
`calc_a4l__Last_RL_Checkin__c`,
`calc_a4l__Planned_Arrival_Time__c`,
`calc_ETA_Lab__c`
) VALUES
(
'1',
'run1',
'run1',
'999999999-000000001',
'999999999-000000001',
'2025-03-15 12:34:43',
'a4l__Route_Location__c',
'/services/data/v43.0/sobjects/a4l__Route_Location__c/a0R240000044qczEAA',
'Praxis am Etzel (Himmelberger)',
'',
'',
'2025-03-15T08:53:52.000+0000',
'',
'1',
'SamstagsTour',
'Account',
'/services/data/v43.0/sobjects/Account/0012400000ESvqAAAT',
'himmst',
'2025-03-15 09:53:52',
'1970-01-01 01:00:00',
'1970-01-01 01:00:00'
)
INSERT INTO tour_monitor
(
`run`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`datetime_import`,
`attributes_type`,
`attributes_url`,
`Name`,
`a4l__Planned_Arrival_Time__c`,
`a4l__Minutes_Until_Planned_Arrival__c`,
`a4l__Last_RL_Checkin__c`,
`ETA_Lab__c`,
`Proben_abgeholt__c`,
`Route_Name__c`,
`a4l__Account__r_attributes_type`,
`a4l__Account__r_attributes_url`,
`a4l__Account__r_ Key__c`,
`calc_a4l__Last_RL_Checkin__c`,
`calc_a4l__Planned_Arrival_Time__c`,
`calc_ETA_Lab__c`
) VALUES
(
'1',
'run1',
'run1',
'999999999-000000001',
'999999999-000000001',
'2025-03-15 12:34:43',
'a4l__Route_Location__c',
'/services/data/v43.0/sobjects/a4l__Route_Location__c/a0R240000044qczEAA',
'Praxis am Etzel (Himmelberger)',
'',
'',
'2025-03-15T08:53:52.000+0000',
'',
'1',
'SamstagsTour',
'Account',
'/services/data/v43.0/sobjects/Account/0012400000ESvqAAAT',
'himmst',
'2025-03-15 09:53:52',
'1970-01-01 01:00:00',
'1970-01-01 01:00:00'
)
SamstagsTour, Location: himmst, ETA: , EFF (checkin): 2025-03-15T08:53:52.000+0000, proben: 1
sql error: :INSERT INTO tour_monitor
(
`run`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`datetime_import`,
`attributes_type`,
`attributes_url`,
`Name`,
`a4l__Planned_Arrival_Time__c`,
`a4l__Minutes_Until_Planned_Arrival__c`,
`a4l__Last_RL_Checkin__c`,
`ETA_Lab__c`,
`Proben_abgeholt__c`,
`Route_Name__c`,
`a4l__Account__r_attributes_type`,
`a4l__Account__r_attributes_url`,
`a4l__Account__r_ Key__c`,
`calc_a4l__Last_RL_Checkin__c`,
`calc_a4l__Planned_Arrival_Time__c`,
`calc_ETA_Lab__c`
) VALUES
(
'1',
'run1',
'run1',
'999999999-000000001',
'999999999-000000001',
'2025-03-15 12:34:43',
'a4l__Route_Location__c',
'/services/data/v43.0/sobjects/a4l__Route_Location__c/a0R3W000000Kz7QUAS',
'Kinderarztpraxis Wädi (Jean-Richard)',
'',
'',
'2025-03-15T09:16:23.000+0000',
'',
'1',
'SamstagsTour',
'Account',
'/services/data/v43.0/sobjects/Account/00124000014oiOXAAY',
'jeanba',
'2025-03-15 10:16:23',
'1970-01-01 01:00:00',
'1970-01-01 01:00:00'
)
INSERT INTO tour_monitor
(
`run`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`datetime_import`,
`attributes_type`,
`attributes_url`,
`Name`,
`a4l__Planned_Arrival_Time__c`,
`a4l__Minutes_Until_Planned_Arrival__c`,
`a4l__Last_RL_Checkin__c`,
`ETA_Lab__c`,
`Proben_abgeholt__c`,
`Route_Name__c`,
`a4l__Account__r_attributes_type`,
`a4l__Account__r_attributes_url`,
`a4l__Account__r_ Key__c`,
`calc_a4l__Last_RL_Checkin__c`,
`calc_a4l__Planned_Arrival_Time__c`,
`calc_ETA_Lab__c`
) VALUES
(
'1',
'run1',
'run1',
'999999999-000000001',
'999999999-000000001',
'2025-03-15 12:34:43',
'a4l__Route_Location__c',
'/services/data/v43.0/sobjects/a4l__Route_Location__c/a0R3W000000Kz7QUAS',
'Kinderarztpraxis Wädi (Jean-Richard)',
'',
'',
'2025-03-15T09:16:23.000+0000',
'',
'1',
'SamstagsTour',
'Account',
'/services/data/v43.0/sobjects/Account/00124000014oiOXAAY',
'jeanba',
'2025-03-15 10:16:23',
'1970-01-01 01:00:00',
'1970-01-01 01:00:00'
)
SamstagsTour, Location: jeanba, ETA: , EFF (checkin): 2025-03-15T09:16:23.000+0000, proben: 1
sql error: :INSERT INTO tour_monitor
(
`run`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`datetime_import`,
`attributes_type`,
`attributes_url`,
`Name`,
`a4l__Planned_Arrival_Time__c`,
`a4l__Minutes_Until_Planned_Arrival__c`,
`a4l__Last_RL_Checkin__c`,
`ETA_Lab__c`,
`Proben_abgeholt__c`,
`Route_Name__c`,
`a4l__Account__r_attributes_type`,
`a4l__Account__r_attributes_url`,
`a4l__Account__r_ Key__c`,
`calc_a4l__Last_RL_Checkin__c`,
`calc_a4l__Planned_Arrival_Time__c`,
`calc_ETA_Lab__c`
) VALUES
(
'1',
'run1',
'run1',
'999999999-000000001',
'999999999-000000001',
'2025-03-15 12:34:43',
'a4l__Route_Location__c',
'/services/data/v43.0/sobjects/a4l__Route_Location__c/a0R3W00000F8H2iUAF',
'Walk-in Zollhaus',
'',
'',
'2025-03-15T10:21:09.000+0000',
'',
'1',
'SamstagsTour',
'Account',
'/services/data/v43.0/sobjects/Account/0013W00000O125ZQAR',
'walkzh',
'2025-03-15 11:21:09',
'1970-01-01 01:00:00',
'1970-01-01 01:00:00'
)
INSERT INTO tour_monitor
(
`run`,
`short_name-de`,
`short_name-en`,
`name-de`,
`name-en`,
`datetime_import`,
`attributes_type`,
`attributes_url`,
`Name`,
`a4l__Planned_Arrival_Time__c`,
`a4l__Minutes_Until_Planned_Arrival__c`,
`a4l__Last_RL_Checkin__c`,
`ETA_Lab__c`,
`Proben_abgeholt__c`,
`Route_Name__c`,
`a4l__Account__r_attributes_type`,
`a4l__Account__r_attributes_url`,
`a4l__Account__r_ Key__c`,
`calc_a4l__Last_RL_Checkin__c`,
`calc_a4l__Planned_Arrival_Time__c`,
`calc_ETA_Lab__c`
) VALUES
(
'1',
'run1',
'run1',
'999999999-000000001',
'999999999-000000001',
'2025-03-15 12:34:43',
'a4l__Route_Location__c',
'/services/data/v43.0/sobjects/a4l__Route_Location__c/a0R3W00000F8H2iUAF',
'Walk-in Zollhaus',
'',
'',
'2025-03-15T10:21:09.000+0000',
'',
'1',
'SamstagsTour',
'Account',
'/services/data/v43.0/sobjects/Account/0013W00000O125ZQAR',
'walkzh',
'2025-03-15 11:21:09',
'1970-01-01 01:00:00',
'1970-01-01 01:00:00'
)
SamstagsTour, Location: walkzh, ETA: , EFF (checkin): 2025-03-15T10:21:09.000+0000, proben: 1
SamstagsTour, Location: 37, ETA: , EFF (checkin): 2025-03-15T08:06:24.000+0000, proben: 1
SamstagsTour, Location: 115, ETA: , EFF (checkin): 2025-03-15T09:08:06.000+0000, proben: 1
SamstagsTour, Location: walkin, ETA: , EFF (checkin): 2025-03-15T10:51:52.000+0000, proben: 1
SamstagsTour, Location: himmst, ETA: , EFF (checkin): 2025-03-15T08:53:52.000+0000, proben: 1
SamstagsTour, Location: jeanba, ETA: , EFF (checkin): 2025-03-15T09:16:23.000+0000, proben: 1
SamstagsTour, Location: walkzh, ETA: , EFF (checkin): 2025-03-15T10:21:09.000+0000, proben: 1
lastkey:
act route: SamstagsTourzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
lastkey: SamstagsTourzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
act route: SamstagsTourzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
lastkey: SamstagsTourzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
act route: SamstagsTourzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
lastkey: SamstagsTourzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
act route: SamstagsTourzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
lastkey: SamstagsTourzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
act route: SamstagsTourzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
lastkey: SamstagsTourzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
act route: SamstagsTourzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
Array
(
[SamstagsTourzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz] => 2
)
SamstagsTourzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz 2 walkin ETA LETA EFF 10:51