Wednesday, 25 December 2019
  26 Replies
  5.9K Visits
0
Votes
Undo
  Subscribe

Theocbase does not yet recognize the new S-89 model for 2020. When will we have the new version with the fix for this issue? Worst of all, I have no copy of the old form and I am unable to generate student assignments.

0
Votes
Undo

Have you clicked the link above ('link to post'), it was still there when I checked this morning, and it still is now...


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/ 

 


1 year ago
·
#7021
0
Votes
Undo

"Sorry, done quite a while ago.."

Hi Marc, I used the S-89-I model up to 3 weeks ago and with the new update, 2020.06,

I print the model in the wrong order.

I looked in the forum but I no longer find the model you modified some time ago.

can you help me?

Thank you 

 

0
Votes
Undo

Sorry, done quite a while ago..

 

Link to post


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/ 

 


1 year ago
·
#7019
0
Votes
Undo

Ciao Marc, riusciresti a creare l'S-89-I modificato in lingua ITALIANA?

Grazie

2 years ago
·
#6549
0
Votes
Undo

@Alan, if you imported the single chinese pdf through TB itself, you will want to put the following string into the position(s) I described before.

 

v03;604;173,950,160,190|173,950,258,288|173,950,354,384|166,472,624,654|166,472,735,765|648,950,571,601|738,950,737,767;86,114,520,548|86,114,576,604|86,114,687,715|86,114,877,905|86,114,934,962|86,114,990,1018|564,592,519,547|564,592,629,657|564,592,686,714|564,592,743,771;614,623,861,886|614,623,861,886


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/ 

 


2 years ago
·
#6548
0
Votes
Undo

Alan, I didn't use the TB import function, but converted the pdf to jpg on pdf2jpg.net, because TB in my experience doesn't always work very well. So that would explain the difference.

If you did a similar conversion that would be quickest, but I'll provide a new string later. Just have to work out how many pixels to the left and how many up... It is not difficult, but it will take a couple of hours before I get to doing that.


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/ 

 


2 years ago
·
#6546
0
Votes
Undo

@Marc. Looking a lot better; it no longer gives the error message. However the fields are slightly off. Please see attached.

Thanks!

2 years ago
·
#6544
0
Votes
Undo

@Alan Kwan. Here you go:

Import both as usual, you probably have already done so. If you were to try the forms in TB you get an error message saying 4 text boxes are expected and you have 5 (on the side: that is an error in the error message. You need 7 text boxes). If the error says anything else than 5 text boxes or says you have anything else than 10 check boxes as well, just stop at this point and report back here please.

Once you have done that close TB and open the database (or find the database from within TB through Settings - Open Database location, but make sure to close TB itself after that).

Open the database with a database editor and open the 'settings' table. In the 'name' column filter type S-89-CH and it will probably give you 4 results. You are looking for the 2 records that give the path to these two assignment slips in your template folder. If you have more than 2 of those, check the template import date and time which is also in the name field. You need the most recent ones. Replace the 'value' fields in both records by the entire string below (starting with v03 and ending with 886). Close database and save. You should be OK now.

 

v03;604;293,1070,363,396|293,1070,461,494|293,1070,557,590|286,592,827,860|286,592,938,971|768,1070,774,807|858,1070,940,973;206,234,723,751|206,234,779,807|206,234,890,918|206,234,1080,1108|206,234,1137,1165|206,234,1193,1221|684,712,722,750|684,712,833,861|684,712,889,917|684,712,946,974;614,623,861,886|614,623,861,886


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/ 

 


2 years ago
·
#6542
0
Votes
Undo

and the English one, which I think was requested before...


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/ 

 


2 years ago
·
#6540
0
Votes
Undo

Those were easy, they imported correctly straight away. I'll create a separate post on how to transform a single S-89 to 4 on one A4 page.


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/ 

 


2 years ago
·
#6536
0
Votes
Undo

@Jimmy,

When you know how to do it, it becomes easy. Attached you will find a better French form (evened out on a A4) and the txt file with the modification you have to do in the database. I chose the name F1 for the new form. For a description of what to do, see the previous post.


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/ 

 


2 years ago
·
#6535
0
Votes
Undo

OK,

I worked on the Swedish again and I think this is much better, but it needs some work. You'll find a ZIP attached. It has 2 files, a jpg and a txt. Put the jpg in your template folder. If you want to change the name (you may not like SVK1...), do it now.

Open TB and try to print. Some fields will probably be wrong especially on the right hand side. Close TB and open the database (theocbase.sqlite) with an editor. (you may locate the database from within TB, under Settings, General, open Database location. Do not forget to close TB when you use this method.

Open the database with a good editor (see my signature below). Find the table called Settings. Look for the reference to the form (type SVK1 in the name filter, if that is the name you decided to keep). In the 'value' field you find a string of very many digits. Replace it by the string in the txt file. Close and save. Try TB again.

See video here how I did that.(Play video on how to modify sqlite settings)


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/ 

 


2 years ago
·
#6506
0
Votes
Undo

@Jonatan. I got the Swedish working, but you really need to thouroughly fool that form. I think the Swedish word for assistant is longer than TB expects, so once TB finds the associated textbox it gets another serial number. Only in the left hand forms. Textbox gets wrong number>displays wrong info. So used paint.net to move the left hand to the left to decrease the left margin and the right hand half to the right for symmetry, and that did the trick at once. After I found it, that is... It is some trial and error, I have no idea how the software is designed to handle this.

If you can give me the single one, I can even try to make a 4up that fits better on A4.

[EDIT] form actually attached...

@ Jimmy Turpin: with this new experience that I got from the Swedish, I will return to work on the French. The overlay that I tried didn't work.


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/ 

 


2 years ago
·
#6503
0
Votes
Undo

This is going to take a while, if we get it working at all. For now I suggest you do either one of two things:

Use the pdf form and fill it manually. This will take you about 5 minutes per month extra, but at least you will be able to use the new form.

Or

Keep using the old one. Honestly the only difference is, that on the old one you would probably have to handwrite which of the assignments is meant in case an assignment occurs more than once on a certain meeting.


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/ 

 


2 years ago
·
#6496
0
Votes
Undo

OK. I get the Dutch working, both the single and the 4up. I can get the English working, but only the 4 up. I have been given the Swedish one to struggle with, I cannot get that to work properly. Then also the French, I am trying to overlay it with the part of the English that is working, but still some check boxes missing. I am giving up. For today...


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/ 

 


2 years ago
·
#6494
0
Votes
Undo

Hi Marc

How can i use the new s-89 in pdf (2020) for theocbase ? Actually, not working

2 years ago
·
#6493
0
Votes
Undo

We have 100's of ideas, but what idea would you like best?  In other words: what is the problem.


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/ 

 


2 years ago
·
#6492
0
Votes
Undo

Hi Brothers,

Have you a idea for disponibility to the french s-89 ?

Thanks for answer.

Jimmy

2 years ago
·
#6483
0
Votes
Undo

The mu-E works for me, and you'll find it attached. The single one doesn't work for me either. As said the new 4up form for me is terrible, and the single one not working... I may stick to the old, or enter the details into the pdf then print


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/ 

 


2 years ago
·
#6482
0
Votes
Undo

Hi friends! 

I am still having some trouble getting the English assignment slip working. I did a complete reinstall of 2019.12.0 but am still getting the box count for this template is incorrect message. I have also tried changing the custom template folder but no success. 

Thanks,

Alan

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