Memorial has effected Mid-Week Meeting Schedule, missing weeks and added week for May 2022

Don't understand what you mean Marc!

Send a screenshot to show me...

 Am I the only user with a browser that shows the thread about this issue is (and has been for over a month) sticky at the very top of this forum?

Hello Daniel,

thank you very much for the complete instruction.  It worked perfectly.

( I really appreciate it, because for some reason I could not locate it in the forum)

Peter

Hi Peter,

Here is a solution offered on this forum:

Import the workbook, and check that the week of April 18 does not show a Bible Reading programme, but a date instead, and that both weeks of April 25 and May 2 are filled. If so:

Put the instructions below in a txt file. Go to Settings and click the >_ button in the bottom right hand corner and execute the text file. You get a message that all went well if you saw no errors, and you should be OK now. 

Don't do it twice! (and don't try if you already have corrected the schedule). Since this changes dates April 25 to April 18 executing the txt file a 2nd time would move those weeks to April 18 that had been moved form May 2 the first time) 

Instructions:

delete from lmm_meeting where song_beginning = '-1';

update lmm_meeting set date = replace (date, '2022-04-25', '2022-04-18') where date = '2022-04-25';

update lmm_schedule set date = replace (date, '2022-04-25', '2022-04-18') where date = '2022-04-25';

update lmm_schedule_assist set date = replace (date, '2022-04-25', '2022-04-18') where date = '2022-04-25';

update lmm_meeting set date = replace (date, '2022-04-25', '2022-04-18') where date = '2022-04-25';

update lmm_meeting set date = replace (date, '2022-05-02', '2022-04-25') where date = '2022-05-02';

update lmm_schedule set date = replace (date, '2022-05-02', '2022-04-25') where date = '2022-05-02';

update lmm_schedule_assist set date = replace (date, '2022-05-02', '2022-04-25') where date = '2022-05-02';

Hi Daniel,

I am missing the string to follow. Can you postet it again, please. I take it "Don't do it twice!" is a warning, not the string. 

When I import the March and April schedule it doesn't account for the week of memorial. 

https://t.me/TheocBaseBR/6

Hi Daniel,

There are a couple of solutions on this forum. I applied one and 2 min later, it worked well. You can find it by searching this string on the forum "Don't do it twice! "