Friday, 25 February 2022
  4 Replies
  1.1K Visits
0
Votes
Undo
  Subscribe

Hi I have a long list of public speakers. which has several lectures. everything is gathered in a CSV file how do i import

I have inserted a line here so you can see what it is all about

Åarhus Viby Rigssal: Vestre Kongevej 17 8260 Viby J 6/18 speaker Phone 53 65 105 133 139 173
Åarhus Viby Rigssal: Vestre Kongevej 17 8260 Viby J 6/18 speaker Phone 175          
Åarhus Viby Rigssal: Vestre Kongevej 17 8260 Viby J 6/18 speaker Phone 17 61 68      
5 months ago
·
#9171
Accepted Answer
0
Votes
Undo

According to the helpfile (F1), congregation speaker and phone should be tab separated, then after another tab talk numbers should be separated by a comma to mass import the talks.

So in Excel you can put all talks into one cell with commas in between, using the CONCATENATE function (https://dk.excelfunctions.eu/CONCATENATE/Dansk). Then store the entire thing as a tab separated text file. Probably not faultless, but it will get you a long way.

Be aware of the following: the talks will be defined as being in the language that TB is set to. And then they will only show up if the imported talks are also defined in that language.  It is probably not an issue, but if you need to use talks in another language than you use TB in, or another langauge than the main language of your congregation, you should think of this first.


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/ 

 


5 months ago
·
#9174
0
Votes
Undo

There is no official way to import a CSV file, so you have to get a bit smart... Glad it worked


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/ 

 


Kim Jessen selected the reply #9171 as the answer for this post — 5 months ago
5 months ago
·
#9173
0
Votes
Undo

Sorry ... It was me who did not understand the concept "tab" now it works ..

5 months ago
·
#9172
0
Votes
Undo

Now I have tried several attempts according to your description ... does not work

5 months ago
·
#9171
Accepted Answer
0
Votes
Undo

According to the helpfile (F1), congregation speaker and phone should be tab separated, then after another tab talk numbers should be separated by a comma to mass import the talks.

So in Excel you can put all talks into one cell with commas in between, using the CONCATENATE function (https://dk.excelfunctions.eu/CONCATENATE/Dansk). Then store the entire thing as a tab separated text file. Probably not faultless, but it will get you a long way.

Be aware of the following: the talks will be defined as being in the language that TB is set to. And then they will only show up if the imported talks are also defined in that language.  It is probably not an issue, but if you need to use talks in another language than you use TB in, or another langauge than the main language of your congregation, you should think of this first.


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/ 

 


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