Friday, 07 January 2022
  7 Replies
  1.2K Visits
0
Votes
Undo
  Subscribe

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

4 months ago
·
#9038
0
Votes
Undo

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! "

 

4 months ago
·
#9045
0
Votes
Undo

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

https://t.me/TheocBaseBR/6

3 months ago
·
#9074
0
Votes
Undo

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. 

 

3 months ago
·
#9075
0
Votes
Undo

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';

 

3 months ago
·
#9076
0
Votes
Undo

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

3 months ago
·
#9077
0
Votes
Undo

 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?


https://www.theocbase.net/support-forum/post/1097-donations.html

For accessing the database my personal preference is http://sqlitebrowser.org/

For editing templates I now use https://code.visualstudio.com/ 

 


3 months ago
·
#9080
0
Votes
Undo

Don't understand what you mean Marc!

Send a screenshot to show me...

  • Page :
  • 1
There are no replies made for this post yet.
Be one of the first to reply to this post!