HI judahpeter
Welcome to eSword Users
 
If I understand correctly you just want the references from your topic or study notes
 
Example: Rom 8:16 John 3:16
Is this correct

Greetings in the Lord;

Thanks for the response:
Yes, I want to have my notes cleaned out except for the hand-typed references that I added. The only way I can see to do this is to manually search the notes file and then one-by-one delete what I don't want. BUT, the other day, the Lord gave me to use Best to convert the notes into an *.xls file and then I can "mass delete" all the files/words/things I don't want. I understand this part. Also, I think I understand (maybe) how to convert the Notes into an *.xls file. (although the file is MUCH smaller.)

The part I don't understand is how to successfully convert the *.xls file back again into a notes and it still show the words. (Afterwards the notes are blank, although the little "i" shows up. And, I expected the file size to be closeer to what it was before the conversion; its too small)

My goal is to have EVERY verse referenced with subscript letters in the text of the verse of the Bible, and have references in the notes that correlate with them. With the tooltip feature, this makes studying and reading references very efficient and easy. Then I plan to have my Bibles (I have three, a Red Letter, Red Letter Reference Version, and a Rainbow Bible on my website along with the notes with references for download. But I think it might confuse people to see my "topic studies" in my notes, so I just want the references.)

This is an example of what I DON'T want. (My studies in my notes)

11. The 1st Commandment - (II. No other gods before me)(IV. Righteous putting away gods)
11. The 2nd Commandment - No Graven Images

REFERENCES - RB
e) Exo_20:5;
f) Lev_18:3;
g) Exo_34:13; Deu_7:5, Deu_7:25; Deu_12:3;
j) 2Ki_18:4; 2Ki_23:14;

This is an example of what I DO want. (Just the references)

REFERENCES - RB
e) Exo_20:5;
f) Lev_18:3;
g) Exo_34:13; Deu_7:5, Deu_7:25; Deu_12:3;
j) 2Ki_18:4; 2Ki_23:14;

Hope this sheds some light on my question and my problem.

In Christ, Shawn

Hi
I am still a little bit confused are we talking about a topic file witch is TOPX or a Study file witch is NOTX which has a reference structure
 
You mentioned NOTX so that's what I will go with
 
if you just want the references make a copy of the NOTX and use the copy to convert to xls make your deletions save it
 
so now you have your Study notes intact and you now have your references for your site or am I missing something
 
you do know that you can have more than one NOTX file they just need to be named differently

Greetings in the Lord:

The file I am talking about is indeed NOTX. I have copied it or backed it up and edited it. That is where I tested out this procedure. The problem lies in the NOTX themselves.

Ok, maybe this is a little bit confusing. In my NOTX file, I like to tell myself what "study" or "TOPX" a particualar verse is in, so I write out the name of the study at the top of the verse notes. Below that, I also add references to other verses. So I have two things going in here. And by the way this has nothing to do with the TOPX file persay, it's just a guide to point to which one of them. Please look at my examples that I listed below.

Please hear me out patiently, and I hope this will make clear sense to you. :)

When I write out the name of the study at the top of the verse notes, from now on I'll call these things my "study titles."
Example - 11. The 1st Commandment - (II. No other gods before me)(IV. Righteous putting away gods)

When I add these "study titles" to my NOTX file, it's only a guide for me. Now, WHAT I want to DELETE are these words, or "study titles". I don't have a problem deleting them one by one, but it will take a very long time, since they're over 3500 of them. That's a lot of work going verse by verse! So, I decided use Excel instead. No problem! My PPROBLEM lies in using BEST to get the darn converted file to work properly! Again, BEST is where I'm having problems. You see whether I delete anything in the excel file or not, it won't matter because after I convert it back again, the NOTX won't display what was inside of the NOTX anymore, it's blank! There is however that icon "i" on the tab though. I'm sorry if this is confusing, and if speaking on the phone would help, I'd be glad to call. Just a recap.

1. Both a "study title" a verse is in, AND the references are together in the NOTX file. They are linked together with the Scripures in E-Sword with that chain looking icon. So whenever a verse is clicked, the NOTX changes with it. (This is a nothing more than a database guide for me to keep track of which verses are in which study) Please refer to the prior post for example.
2. So, I only want the references in the NOTX and not the "study title" but in order to do this on a grand scale, I need to convert the NOTX file to a excel (.xls) file.
3. I CAN and have converted the NOTX into an excel file, and back again, but I'm having techical difficulies after the re-conversion. I listed my step-by-step way of doing this in my first post. For questions, please refer to that.
4. I need assistance in the conversion process, and in the re-conversion process because I think somethings getting messed up. The file is too small and I can't see anything in the NOTX afterward.

Q - so now you have your Study notes intact and you now have your references for your site or am I missing something.....
A - YES you're missing something. If I understand you right, they are the same thing/file called NOTX and I cannot seperate them without deleting things, and that is what I am trying to do.

Q - you do know that you can have more than one NOTX file they just need to be named differently.
A - Yes I do. This isn't where the problem lies. I need to MODIFY the notes, and thats where I'm getting hung up.

Once again I'll put here an example.

OK. This is what I have now, the complete picture.

----------------------------------------------------------------------------------------

11. The 1st Commandment - (II. No other gods before me)(IV. Righteous putting away gods)
11. The 2nd Commandment - No Graven Images

REFERENCES - RB
e) Exo_20:5;
f) Lev_18:3;
g) Exo_34:13; Deu_7:5, Deu_7:25; Deu_12:3;
j) 2Ki_18:4; 2Ki_23:14;

----------------------------------------------------------------------------------------

This is an example of what I want deleted. (My "study titles" in my notes)

11. The 1st Commandment - (II. No other gods before me)(IV. Righteous putting away gods)
11. The 2nd Commandment - No Graven Images

----------------------------------------------------------------------------------------

This is an example of what I DO want. (Just the references in the NOTX still)

REFERENCES - RB
e) Exo_20:5;
f) Lev_18:3;
g) Exo_34:13; Deu_7:5, Deu_7:25; Deu_12:3;
j) 2Ki_18:4; 2Ki_23:14;

----------------------------------------------------------------------------------------
Another recap -

I CAN only delete the "study titles" manually one by one, or by using a converted NOTX into excel file. The problem is in the second conversion (the one back into a NOTX file because NOTHING shows up, whether I do anything to the excel file or not)

Thanks for being patient, and may the Lord bless whosoever gives me the solution to this problem.

In Christ, Shawn

I will take a look at this sometime this week and let you know if there is something that I've missed in BeST.
Ben.

Greetings in the Lord Ben:

Thanks for the help. I appreciate it.

If you want the files I converted or anything that would help on my end, just ask.

The Lord bless you.

In Christ, Shawn

bump

Hi everyone and greetings in the Lord.

I have two issues that I need resolved.

The first one is the post here hasn't been answered yet. I still need to know how to convert my notx file to excel and back again without any corruption.

The second is that I hear that there is a new version of Ben's BEST tool and I am a premium member, but I don't know where I can get the latest version from. Update - I have Windows 7 now, and when I tried again to convert the file into an *.Xls file it doesn't do anything. Maybe this is solved by the latest version of BEST; not sure.

Thanks, in Christ, Shawn

Bumping messages doesn't increase their visibility. (Messages I've flagged to answer, get dropped from that list when they are bumped.)

a) My suggestion is to distribute your resource as a commentary file, not a not file.

b)Are you saving the excel document as an xls or xlsx file? BeST doesn't work with the latter.

jonathon

Shawn, have you tried e-Sword Tooltip Tool (T3)?  This will read a NOTX file, you can edit it right in T3, apply tooltipping to texts if they need it, then you can save it back as a NOTX file.  See: http://e-sword-users.org/users/node/2410
 
BH

Sorry, I'm relatively new here. I originally posted this thread back in 01/02/10 and then Ben replied on 01/04/10 but never got back to me. Then it sat here for another month to 03/14/10 so I bumped it. Now its the end of the month 03/31/10 and I finally get an answer. Sorry, I have no idea what a "flagged to answer" is, and I don't like the sound of getting "dropped from the list." Please forgive my ignorance. We're all supposed Christians here, so let's be Godly and kind to each other: I meant no disrespect or dishonor.

This isn't really important but the the latest update to my post is, I'm not even able to get it to even convert in BEST now. Anyhow, if I ever could get a working .Xls file, I would save it back into an .Xls file. As it stands my original problem was getting the NOTX file converted into an .Xls file, edited in Excel, and then BACK into a "NOTX" file without a glitch or the thing converting incorrectly. I thought that BEST was supposed to be good at doing all these things. All the while all I get is an empty NOTX file instead.
/par

BH. I Praise God for you. This information you gave is like a drink of cool water in a desert. Thanks so much and I will try this out and let you know what I find out. I had no idea about this tool. Again, thanks a lot! :))) Blessings of the Lord be upon you!

In Christ, Shawn

Basically , if something has to be replicated a couple of times, to correctly answer the question, I flag it, to work on at a later point in time. It is a slow process, but it means that the answer is eventually posted.

When a message is bumped, it looks like the issue has been addressed, and thus no longer needs to be worked on. Currently, 200 issues are flagged for further research, before I post an answer/explanation. (Most of these require a minimum of eight hours to replicate, fix, and test the fix. Some require far more time than that.)

jonathon