Jump to content

Please read the Forum Rules before posting.

Photo
* * * * * 1 votes

SQLite Regexer - new module editing utility


  • Please log in to reply
32 replies to this topic

#1 Josh Bond

Josh Bond

    Administrator

  • Administrators
  • PipPipPipPipPip
  • 2,843 posts
  • LocationGallatin, TN
Offline

Posted 31 March 2012 - 10:38 AM

*
POPULAR

Ray, a friend of BibleSupport.com, has created the SQLite Regexer. For those of you familiar with module making, you will take one look at the screenshots and instantly see the value of this utility. (This utility is for advanced users--it's not intended for an end user who wants to change a few words. Although it can be used to modify a module by someone technically inexperienced, this program does not "hold your hand". It presents a lot of options and it assumes you have basic database knowledge.)

You can directly edit the RAW rtf of a module. You can search/replace. And you can use regular expressions. You can also view the changes through the utility's RTF viewer. You can edit a specific record in the database, or the entire database. The Preview Table button lets you see a bird's eye view of the data in a table.

This has rapidly become my number one utility for post module processing (edits to a module after ToolTip 4 generates the module). I also use this utility when editing someone else's module, for tweaking font sizes, for tweaking Greek words, colors, etc.

This utility's "sister app" is called Regexer (RTF file). This utility performs regular expression searches on RTF files--not modules/databases, but the raw RTF file itself.

#2 Josh Bond

Josh Bond

    Administrator

  • Administrators
  • PipPipPipPipPip
  • 2,843 posts
  • LocationGallatin, TN
Offline

Posted 31 March 2012 - 10:42 AM

Ray has also created the e-Sword Tab Renamer. We have a tutorial on changing the e-Sword tab names, but inexperienced users struggle with this process.

The Tab Renamer will rename your e-Sword module's tab names. Don't like the current tab name (abbreviation) for a Bible, commentary, dictionary, devotional, etc? This program lets you change the tab name without any technical knowledge.

This program also lets you change the tab name description that you see when you hover your mouse over the tab abbreviation in e-Sword.

#3 JPG

JPG

    Bug Hunter

  • Members (T)
  • PipPipPipPipPip
  • 722 posts
Offline

Posted 05 April 2012 - 02:53 PM

Hi, Raymond.

1. It would be appreciated if you could put the version number of your programs somewhere in the program.

2. What is the "flavour" of Regex that you are using in SQlite Regexer. It would help to have that stated somewhere in the program.

3. Would you be able to list the font sizes used in a module. By that I mean the rtf codes.

Your work is much appreciated,
Thank you.
Jon

#4 Raymond Barone

Raymond Barone

    e-Sword Fanatic

  • Members
  • PipPipPipPipPip
  • 112 posts
Offline

Posted 05 April 2012 - 03:46 PM

Hi, Raymond.

1. It would be appreciated if you could put the version number of your programs somewhere in the program.

2. What is the "flavour" of Regex that you are using in SQlite Regexer. It would help to have that stated somewhere in the program.

3. Would you be able to list the font sizes used in a module. By that I mean the rtf codes.

Your work is much appreciated,
Thank you.
Jon


Hi Jon,

Thanks for your suggestions.
I'll consider them in the next version.

I use .NET Framework Regex
"\r\n" can be used in either textbox (Find or Replace) for new line.

Ray

#5 APsit190

APsit190

    e-Sword Tools Developer

  • Members (T)
  • PipPipPipPipPip
  • 1,566 posts
  • LocationThe Land of the Long White Cloud
Offline

Posted 05 April 2012 - 07:32 PM

Hi Ray,
From one developer to another, actually versioning your software is really important not just from the User's perspective, but also from the programmer's perspective as it keeps track of what you have done and where your program is at in regards to its developmental stage.

Also information on what the Copyright status you place on it is important as this gives the user what he can do and not do with the program. He at least knows where he stands. So all you need to do is add a form to your program, name it something like frmAbout, and then plonk in the stuff you want it to show, and add a new button that will open the About form. Another way you can do an about dialog is in a message box. You know, the one where you use C# or VB.Net, the MessageBox.Show syntax. Dunno what that is in C++.

Blessings,
Autograph.png

#6 Raymond Barone

Raymond Barone

    e-Sword Fanatic

  • Members
  • PipPipPipPipPip
  • 112 posts
Offline

Posted 05 April 2012 - 07:57 PM

Hi Ray,
From one developer to another, actually versioning your software is really important not just from the User's perspective, but also from the programmer's perspective as it keeps track of what you have done and where your program is at in regards to its developmental stage.

Also information on what the Copyright status you place on it is important as this gives the user what he can do and not do with the program. He at least knows where he stands. So all you need to do is add a form to your program, name it something like frmAbout, and then plonk in the stuff you want it to show, and add a new button that will open the About form. Another way you can do an about dialog is in a message box. You know, the one where you use C# or VB.Net, the MessageBox.Show syntax. Dunno what that is in C++.

Blessings,


Hi APsit190,

Thanks for the info.
I already keep track of different versions on my pc, but as you and Jon suggested, I think I should add the version to the program.
For the copyright status, I have nothing in mind for that.

Ray

#7 Josh Bond

Josh Bond

    Administrator

  • Administrators
  • PipPipPipPipPip
  • 2,843 posts
  • LocationGallatin, TN
Offline

Posted 06 April 2012 - 02:28 PM

Your latest version works great. I like this so much better than dumping the module to text and editing in a word processor. Makes quick edits very clean.

#8 Raymond Barone

Raymond Barone

    e-Sword Fanatic

  • Members
  • PipPipPipPipPip
  • 112 posts
Offline

Posted 06 April 2012 - 04:38 PM

I uploaded version 1.4

Version 1.4.1
Changelog:
  • 1.4: Added "Regex Find" button to find any regular expression in the selected table and column.
  • A file can be dragged into the program to open it, only if no other file is open.
  • 1.4.1: Fixed bug when displaying and updating byte arrays

Edited by Raymond Barone, 06 April 2012 - 07:55 PM.


#9 Josh Bond

Josh Bond

    Administrator

  • Administrators
  • PipPipPipPipPip
  • 2,843 posts
  • LocationGallatin, TN
Offline

Posted 24 April 2012 - 09:20 AM

I keep this utility pinned to my taskbar in Windows 7 and use it on a daily basis almost. Still working great!

#10 JPG

JPG

    Bug Hunter

  • Members (T)
  • PipPipPipPipPip
  • 722 posts
Offline

Posted 03 May 2012 - 04:40 AM

Hi Ray, I would appreciate if you could add the function of dropping a table.

Jon




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users




Similar Topics



Latest Blogs