Jump to content


Photo

Vocab Building Format


  • Please log in to reply
24 replies to this topic

#1 Martin Zhang

Martin Zhang

    Silver

  • Active Members
  • PipPipPip
  • 186 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 08 April 2014 - 11:40 PM

As I was trying to building vocabularies for a class. I found a problem.

My goal is to export the vocab to quizlet.com for me to memorize.

 

from the analysis result, I see that usually, the result follow the format as:

1) the lexical form;    2) the root; and     3) the definition with frequency in the selected passage.

 

But there are also some words that do not have the root in the parentheses (I assume the reason is that the lexical form and the root are identical). Therefore, There are only two columns:

1) the lexical form;    2) the definition with frequency in the selected passage.

 

The result would look like this:

Attached File  1.jpg   7.26KB   1 downloads

 

 

the problem is, I could have copied the 2nd column and the 3rd column to quizlet. But now, before I do that, I have to move the second row one column further to the right in order to keep it in align with most other words.

and There are quite a few words like that, depending on the passage.

 

Is it possible for Acc to change the analysis result format so that I can get the result as either

1) the lexical form;    2) the root; and        3) the definition with frequency in the selected passage.

                                1) the lexical form;    2) the definition with frequency in the selected passage.

Attached File  2.jpg   7.71KB   0 downloads

or 

 

1) the lexical form;    2) the root; and        3) the definition with frequency in the selected passage.

1) the lexical form;    1) the lexical form;    2) the definition with frequency in the selected passage.

Attached File  3.jpg   8.56KB   0 downloads

(Just repeat the lexical form once to fill the column 1.)

 

so that I don't have to move them manually in order to copy and paste them into quizlet?

 

Thanks,

 

Martin

 

 


Edited by Martin Zhang, 09 April 2014 - 12:31 AM.

Martin

Accordance v.11

Mac Yosemite (English, Chinese)

iPad iOS 8 (English, Chinese)

Win7 Home Premium (Chinese)

Accordance tutorials in Chinese.


#2 Timothy Jenney

Timothy Jenney

    Platinum

  • Accordance
  • 1,667 posts
  • Gender:Male
  • Location:sunny Winter Haven, FL
  • Interests:a good cup of coffee, sci-fi, playing bass, listing to jazz and the blues, camping, fishing and the great outdoors
  • Accordance Version:11.x

Posted 09 April 2014 - 08:12 AM

I agree. I've had some trouble with formatting these kinds of results for export, too.

 

In fact, it would be nice if these results were in table form within Accordance, separated by tabs. When there is no data, simply insert a space and a tab.

 

Meanwhile, I have found that I can copy and paste results like these into MS Word, then use its Advanced Search and Replace to replace every white space with a tab (Use the drop down "Special" menu.). The result can be pasted into Excel and the columns then easily adjusted and rearranged.

 

Hope this helps!

Attached Files


Blessings,
"Dr. J"

Timothy P. Jenney, Ph. D.
"Lighting the Lamp" Host and Producer

 

Mac: Early 2011 17" MBP (8,3), 2.3 GHz Quad core, 16 GB RAM, Mercury 6G 480 SSD + 1.5 TB HD, OSX 10.10, Yosemite

iPhone 6 plus 64 GB iOS 8.1


#3 Daniel Semler

Daniel Semler

    Platinum

  • Active Members
  • PipPipPipPipPip
  • 1,698 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 09:16 AM

If you select all the text in the Analysis pane (locate focus there then cmd-A) you can save the output to a text file - File -> Save Text Selection as -> RTF/PlainText - I think in 10.3.4 and afterwards. And then you can post process that file with a script. I've done this for Greek but not for Hebrew but the format you describe is basically identical to Greek. And handful of regexes clean it up in no time and a script can readily account for the slight irregularities in the output.

 

thx

D


Accordance Configurations :
 
Mac : 2009 27" iMac                 Windows : HP 4540s laptop
      Intel Core Duo                          Intel i5 Ivy Bridge
      12GB RAM                                8GB RAM
      Accordance 11.0.1                       Accordance 11.0.1
      OSX 10.9 (Mavericks)                    Win 7 Professional x64 SP1


#4 Joel Brown

Joel Brown

    Administrator

  • Admin
  • 3,048 posts
  • Gender:Male
  • Location:Houston, TX
  • Accordance Version:11.x
  • Platforms:Mac OS X, Windows

Posted 09 April 2014 - 09:21 AM

Tim, they already are tab-delimited, which is why you can paste into a spreadsheet program already.

 

Martin, I'm not sure if the root is important, but if you hide it, everything will always be in a nice two-column format.  Just go to Command-T (Control-T on Windows) and uncheck 'Show Root with LEX'.


Joel Brown

By day: Consultant for Oaktree
By night: Freelance Trombonist and Private Instructor

#5 Timothy Jenney

Timothy Jenney

    Platinum

  • Accordance
  • 1,667 posts
  • Gender:Male
  • Location:sunny Winter Haven, FL
  • Interests:a good cup of coffee, sci-fi, playing bass, listing to jazz and the blues, camping, fishing and the great outdoors
  • Accordance Version:11.x

Posted 09 April 2014 - 11:10 AM

Thanks, Joel!

 

That change may have happened after I worked out my solution; I'm not sure.


Blessings,
"Dr. J"

Timothy P. Jenney, Ph. D.
"Lighting the Lamp" Host and Producer

 

Mac: Early 2011 17" MBP (8,3), 2.3 GHz Quad core, 16 GB RAM, Mercury 6G 480 SSD + 1.5 TB HD, OSX 10.10, Yosemite

iPhone 6 plus 64 GB iOS 8.1


#6 Martin Zhang

Martin Zhang

    Silver

  • Active Members
  • PipPipPip
  • 186 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 11:15 AM

Thanks, Tim, Dan and Joel.
To Joel,
Thanks. I do not need the root at this moment. Your suggestion helps.
But in the long run, I would still want to insert another blank tab before the lexical form where it does have the root displayed (or the lexical form and root are identical), just as Tim said.
Or just repeat the lexical form as the root.

Thanks!

Martin

Accordance v.11

Mac Yosemite (English, Chinese)

iPad iOS 8 (English, Chinese)

Win7 Home Premium (Chinese)

Accordance tutorials in Chinese.


#7 Timothy Jenney

Timothy Jenney

    Platinum

  • Accordance
  • 1,667 posts
  • Gender:Male
  • Location:sunny Winter Haven, FL
  • Interests:a good cup of coffee, sci-fi, playing bass, listing to jazz and the blues, camping, fishing and the great outdoors
  • Accordance Version:11.x

Posted 09 April 2014 - 11:25 AM

Here is an example of a direct copy and paste into [Apple] Numbers. It's a parsing chart from Gen. 1:1f.

 

Joel, yes, this is MUCH improved from when I first worked with these tables. I remember now you had said you were going to work on this feature, but honestly haven't taken the opportunity to check it until now. Well done! :-) This will save a lot of us a lot of time.

 

Thanks!

Attached Files


Blessings,
"Dr. J"

Timothy P. Jenney, Ph. D.
"Lighting the Lamp" Host and Producer

 

Mac: Early 2011 17" MBP (8,3), 2.3 GHz Quad core, 16 GB RAM, Mercury 6G 480 SSD + 1.5 TB HD, OSX 10.10, Yosemite

iPhone 6 plus 64 GB iOS 8.1


#8 Daniel Semler

Daniel Semler

    Platinum

  • Active Members
  • PipPipPipPipPip
  • 1,698 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 11:41 AM

Hey Martin,

 

  Question for you on Quizlet. I use Cram and thus am not familiar with Quizlet.

  How does Quizlet handle import of more than two fields ? Does it create 3 or greater "sided" cards ? I believe Cram can do three sided but I believe the 3rd side is considered a hint.

 

Thx

D


Accordance Configurations :
 
Mac : 2009 27" iMac                 Windows : HP 4540s laptop
      Intel Core Duo                          Intel i5 Ivy Bridge
      12GB RAM                                8GB RAM
      Accordance 11.0.1                       Accordance 11.0.1
      OSX 10.9 (Mavericks)                    Win 7 Professional x64 SP1


#9 Martin Zhang

Martin Zhang

    Silver

  • Active Members
  • PipPipPip
  • 186 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 02:00 PM

Hey Martin,
 
  Question for you on Quizlet. I use Cram and thus am not familiar with Quizlet.
  How does Quizlet handle import of more than two fields ? Does it create 3 or greater "sided" cards ? I believe Cram can do three sided but I believe the 3rd side is considered a hint.
 
Thx
D


Hey Dan,
I just started to use Quizlet.
I use only two fields. I don't see anywhere I can add a third column. When I creat vocab list for myself, I just put hints and the definition together.

Martin

Martin

Accordance v.11

Mac Yosemite (English, Chinese)

iPad iOS 8 (English, Chinese)

Win7 Home Premium (Chinese)

Accordance tutorials in Chinese.


#10 Daniel Semler

Daniel Semler

    Platinum

  • Active Members
  • PipPipPipPipPip
  • 1,698 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 04:11 PM

Ah I see Martin - I had a quick look at the interface - its pretty similar to Cram it turns out.

I've gone back and forth on the roots thing. But the reason I asked about this was that if you use tab delimiting and you have : word <tab> root <tab> def. I was wondering what the import would do with it. It looks like it will have nowhere to go.

 

What I do when I have roots is keep them with the word.

 

Thx

D


Accordance Configurations :
 
Mac : 2009 27" iMac                 Windows : HP 4540s laptop
      Intel Core Duo                          Intel i5 Ivy Bridge
      12GB RAM                                8GB RAM
      Accordance 11.0.1                       Accordance 11.0.1
      OSX 10.9 (Mavericks)                    Win 7 Professional x64 SP1


#11 Martin Zhang

Martin Zhang

    Silver

  • Active Members
  • PipPipPip
  • 186 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 04:41 PM

Ah I see Martin - I had a quick look at the interface - its pretty similar to Cram it turns out.
I've gone back and forth on the roots thing. But the reason I asked about this was that if you use tab delimiting and you have : word <tab> root <tab> def. I was wondering what the import would do with it. It looks like it will have nowhere to go.
 
What I do when I have roots is keep them with the word.
 
Thx
D


I copy to Word first, and copy from Word to Excel. It works fine.
If I copy to Excel first, it will not work well.

Martin

Accordance v.11

Mac Yosemite (English, Chinese)

iPad iOS 8 (English, Chinese)

Win7 Home Premium (Chinese)

Accordance tutorials in Chinese.


#12 Daniel Semler

Daniel Semler

    Platinum

  • Active Members
  • PipPipPipPipPip
  • 1,698 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 05:18 PM

Ah now that's odd - I was thinking about the last bit - pasting into Quizlet - which I think I can guess at the operation of now. But having to do a two hop c& p is odd.

 

Thx

D


Accordance Configurations :
 
Mac : 2009 27" iMac                 Windows : HP 4540s laptop
      Intel Core Duo                          Intel i5 Ivy Bridge
      12GB RAM                                8GB RAM
      Accordance 11.0.1                       Accordance 11.0.1
      OSX 10.9 (Mavericks)                    Win 7 Professional x64 SP1


#13 Martin Zhang

Martin Zhang

    Silver

  • Active Members
  • PipPipPip
  • 186 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 07:58 PM

Ah now that's odd - I was thinking about the last bit - pasting into Quizlet - which I think I can guess at the operation of now. But having to do a two hop c& p is odd.
 
Thx
D

Yes. As you may have notice, when you copy the data from the Acc. There are two 'tabs' before each row. That is why when you copy to Excel, there are two blanck columns. I'm not sure why they added the two tabs. I can show you how this could cause a problem for output.
 
at here: http://www.youtube.c...h?v=tM7q2BjfviY
                #74) Building Vocabulary
Dr. Tim showed us how to build the vocabulary.
 
In his demonstration, when he copied the data to the spreadsheet, the first row was not in the right position.
Attached File  5.jpg   40.25KB   0 downloads
 
The reason is because, he did not select the two tabs in the first row. If you select the first two blank tabs, it will be fine.
(But I still don't understand why it has to have two blank tabs before each row. If it doesn't have the two tabs, my guess is that, we will be able to copy to Quizlet directly.)
Attached File  4.jpg   58.55KB   0 downloads
 
 
And, I don't know why when I copy to the spreadsheet directly, it just doesn't work correctly (For this reason, I'm afraid that, even if we can copy to Quizlet directly, would it be just like when it is copied to Excel as below?. This deserves another research...

Attached File  6.jpg   41.81KB   0 downloads


Edited by Martin Zhang, 09 April 2014 - 08:01 PM.

Martin

Accordance v.11

Mac Yosemite (English, Chinese)

iPad iOS 8 (English, Chinese)

Win7 Home Premium (Chinese)

Accordance tutorials in Chinese.


#14 Daniel Semler

Daniel Semler

    Platinum

  • Active Members
  • PipPipPipPipPip
  • 1,698 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 09:32 PM

Hmmm.... ok - I see now that my script has a replace for those leading double tabs. I'd forgotten about them. Happens in the Greek analysis tab also. My guess is that the formatter for the analysis pane uses them to guide rendering, one tab per level of indentation. If you play with more complex analysis tabs you will see more indentation.

 

On the Excel picture at the bottom of your post, that looks like it has some RTL stuff going on. Perhaps Word is helping you with that.

 

Thx

D


Accordance Configurations :
 
Mac : 2009 27" iMac                 Windows : HP 4540s laptop
      Intel Core Duo                          Intel i5 Ivy Bridge
      12GB RAM                                8GB RAM
      Accordance 11.0.1                       Accordance 11.0.1
      OSX 10.9 (Mavericks)                    Win 7 Professional x64 SP1


#15 Daniel Semler

Daniel Semler

    Platinum

  • Active Members
  • PipPipPipPipPip
  • 1,698 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 09:45 PM

Hey Martin,

 

  Its worth noting that what Dr. J posted above is not an Analysis tab but a parsing output - (cmd-A, right click -> Look Up -> Parsing) . I just looked at that output and its way better formatted than the last time I looked. I am going to try to use that for another drill exercise that I have wanted to do. The problem I haven't worked out with it is how to get that display for just the words I want, rather than those for the entire verse.

 

Thx

D
 


Accordance Configurations :
 
Mac : 2009 27" iMac                 Windows : HP 4540s laptop
      Intel Core Duo                          Intel i5 Ivy Bridge
      12GB RAM                                8GB RAM
      Accordance 11.0.1                       Accordance 11.0.1
      OSX 10.9 (Mavericks)                    Win 7 Professional x64 SP1


#16 Martin Zhang

Martin Zhang

    Silver

  • Active Members
  • PipPipPip
  • 186 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 09:51 PM

Hey Martin,

 

  Its worth noting that what Dr. J posted above is not an Analysis tab but a parsing output - (cmd-A, right click -> Look Up -> Parsing) . I just looked at that output and its way better formatted than the last time I looked. I am going to try to use that for another drill exercise that I have wanted to do. The problem I haven't worked out with it is how to get that display for just the words I want, rather than those for the entire verse.

 

Thx

D
 

I'm a little bit confused. Why I didn't see "Parsing"?

Attached File  7.jpg   37.77KB   0 downloads


Martin

Accordance v.11

Mac Yosemite (English, Chinese)

iPad iOS 8 (English, Chinese)

Win7 Home Premium (Chinese)

Accordance tutorials in Chinese.


#17 Martin Zhang

Martin Zhang

    Silver

  • Active Members
  • PipPipPip
  • 186 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 09:54 PM

Hmmm.... ok - I see now that my script has a replace for those leading double tabs. I'd forgotten about them. Happens in the Greek analysis tab also. My guess is that the formatter for the analysis pane uses them to guide rendering, one tab per level of indentation. If you play with more complex analysis tabs you will see more indentation.

 

On the Excel picture at the bottom of your post, that looks like it has some RTL stuff going on. Perhaps Word is helping you with that.

 

Thx

D

I don't konw what is RTL. This is what happened when I copy from Acc to Excel directly.

But if I copy to Word first, and copy from word to Excel, it will work perfectly...

That's why I was wondering...is that a problem of Excel, or of Acc?


Martin

Accordance v.11

Mac Yosemite (English, Chinese)

iPad iOS 8 (English, Chinese)

Win7 Home Premium (Chinese)

Accordance tutorials in Chinese.


#18 Daniel Semler

Daniel Semler

    Platinum

  • Active Members
  • PipPipPipPipPip
  • 1,698 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 09:59 PM

I'm a little bit confused. Why I didn't see "Parsing"?

 

 

The problem here is that the selection has to be from the search tab not the analysis tab. You've selected the analysis content - try the search tab.

 

RTL means Right To Left - sorry. Formatting of RTL text is problematic in a number of programs. The forums are full of posts on it.

 

Thx

D


Accordance Configurations :
 
Mac : 2009 27" iMac                 Windows : HP 4540s laptop
      Intel Core Duo                          Intel i5 Ivy Bridge
      12GB RAM                                8GB RAM
      Accordance 11.0.1                       Accordance 11.0.1
      OSX 10.9 (Mavericks)                    Win 7 Professional x64 SP1


#19 Martin Zhang

Martin Zhang

    Silver

  • Active Members
  • PipPipPip
  • 186 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 10:41 PM

 

The problem here is that the selection has to be from the search tab not the analysis tab. You've selected the analysis content - try the search tab.

 

RTL means Right To Left - sorry. Formatting of RTL text is problematic in a number of programs. The forums are full of posts on it.

 

Thx

D

I see. Thanks!

Anyway, mine still messes up...

 

Copy from Acc to Excel:

Attached File  1.jpg   82.59KB   0 downloads

 

Copy from Acc to Word, then from Word to Excel:

Attached File  2.jpg   70.72KB   0 downloads


Martin

Accordance v.11

Mac Yosemite (English, Chinese)

iPad iOS 8 (English, Chinese)

Win7 Home Premium (Chinese)

Accordance tutorials in Chinese.


#20 Daniel Semler

Daniel Semler

    Platinum

  • Active Members
  • PipPipPipPipPip
  • 1,698 posts
  • Gender:Male
  • Accordance Version:11.x

Posted 09 April 2014 - 11:44 PM

Ok so I tried a little more 'cos I hate it when I can't get it to work :)

I use LibreOffice but in any case I got hopeless stuff just pasting it in like you did only perhaps a little worse.

But if I select the text in the parsing - whichever bits I want and do File -> Save Selection As -> Plain text....

then I can open that into LibreOffice telling it what delimiters to use (tab or semi-colon but not comma) I then get a nice import that looks like what you have. So you might try that sort of approach with Excel. But it might be as much hassle to you as the current method I don't know.

 

Thx

D


Accordance Configurations :
 
Mac : 2009 27" iMac                 Windows : HP 4540s laptop
      Intel Core Duo                          Intel i5 Ivy Bridge
      12GB RAM                                8GB RAM
      Accordance 11.0.1                       Accordance 11.0.1
      OSX 10.9 (Mavericks)                    Win 7 Professional x64 SP1





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users