Jump to content

Please read the Forum Rules before posting.

Photo

Is there an easy way to convert a MySword journal?


  • Please log in to reply
5 replies to this topic

#1 turnsouth

turnsouth

    e-Sword Fanatic

  • Veterans
  • PipPipPipPipPip
  • 141 posts
Offline

Posted 24 December 2014 - 09:45 AM

I'd like to convert a journal I wrote in MySword to either RTF, or e-Sword. Is there a quick way to do this?

 

Thanks



#2 patchworkid

patchworkid

    Resource Builder

  • Members (T)
  • PipPipPipPipPip
  • 1,554 posts
  • LocationOld England
Offline

Posted 24 December 2014 - 10:18 AM

Hi

try this:
1. Copy the journal file to your pc
2. Right click on it,
3. Select open with
4. Choose excel, or word, or word pad

if that does not work
export the journal file to html
you will have to delete the information in the brackets

thanks
Merismos the Scriptures with Patchworkid's Study Bible Set<p>http://www.biblesupp...tudy-bible-set/, MySword -http://www.biblesupp...tudy-bible-set/

#3 patchworkid

patchworkid

    Resource Builder

  • Members (T)
  • PipPipPipPipPip
  • 1,554 posts
  • LocationOld England
Offline

Posted 24 December 2014 - 10:47 AM

Also try this
1. Open the html file in ms office word
2. Click on find&replace
3. Click on use more functions
4. Select wild cards
5. Find: ({/*})
6. Replace: leave blank, nothing

this will delete everything in those brackets

ps. If it does not work try rearranging ... I will re upload the correct info

thanks
Merismos the Scriptures with Patchworkid's Study Bible Set<p>http://www.biblesupp...tudy-bible-set/, MySword -http://www.biblesupp...tudy-bible-set/

#4 APsit190

APsit190

    e-Sword Tools Developer

  • Members (T)
  • PipPipPipPipPip
  • 2,872 posts
  • LocationLand of the Long White Cloud (AKA New Zealand)
Offline

Posted 28 December 2014 - 02:55 PM

Also try this
1. Open the html file in ms office word
2. Click on find&replace
3. Click on use more functions
4. Select wild cards
5. Find: ({/*})
6. Replace: leave blank, nothing

this will delete everything in those brackets

ps. If it does not work try rearranging ... I will re upload the correct info

thanks

 

HI Niobi,

The MySword journal file is an SQLite database file, and as such you cant open it up in MS Word or any other word processor, text editor, or any other database, spreadsheet application except in SQLite, SQLite Manager, or SQLite Browser.

 

As to exporting an SQLite Database file to HTML goes, sorry this cannot be done. The only way around it is to convert the Database file, from memory, is to convert it to a csv or an xml file in SQLite Manager, and then from there can one open it up in MS Word. I do know that one can open up an xml file in MS Word, and from there save it as an rtf file, but I'm not certain as to whether or not one can do that with csv, or if one has to convert the csv to an xml file. With that all said, done and dusted, tools such as Notepad ++ and Programmers Notepad (both are open sauce and free), and etc., are able to open up xml and csv file types, and one can rip out all the xml and csv code, and from there save it as a txt (text) file type. Even Windows Notepad will do the same trick as well.

 

Blessings,

Autograph.png

Edited by APsit190, 28 December 2014 - 03:04 PM.

X (formerly Twitter)

 


#5 JPG

JPG

    Jon.

  • Moderators
  • 1,678 posts
Online

Posted 28 December 2014 - 04:23 PM

HI Niobi,

The MySword journal file is an SQLite database file, and as such you cant open it up in MS Word or any other word processor, text editor, or any other database, spreadsheet application except in SQLite, SQLite Manager, or SQLite Browser.

 

As to exporting an SQLite Database file to HTML goes, sorry this cannot be done. The only way around it is to convert the Database file, from memory, is to convert it to a csv or an xml file in SQLite Manager, and then from there can one open it up in MS Word. I do know that one can open up an xml file in MS Word, and from there save it as an rtf file, but I'm not certain as to whether or not one can do that with csv, or if one has to convert the csv to an xml file. With that all said, done and dusted, tools such as Notepad ++ and Programmers Notepad (both are open sauce and free), and etc., are able to open up xml and csv file types, and one can rip out all the xml and csv code, and from there save it as a txt (text) file type. Even Windows Notepad will do the same trick as well.

 

Blessings,

 

 

There is the feature of exporting Notes/Jounal to html file from within MySword.

Menu ->Copy/Export ->Export Notes/Journal to file

 

Jon



#6 turnsouth

turnsouth

    e-Sword Fanatic

  • Veterans
  • PipPipPipPipPip
  • 141 posts
Offline

Posted 29 December 2014 - 10:29 AM

Yeah, I didn't want to go through the bother of installing MySword again, just to export the file. (I have switched from using an Android tablet (Kindle Fire) for mobile Bible study, to using a Windows Pro tablet, this way I get full e-Sword, as well as synchronized user folder and the files within it. Good stuff)
 
Anyway, I went ahead and tried opening the MySword journal file in WPS Writer (Word clone) and it opened fine, just a little bit of extra odd characters that needed cleaning up.
 
Thanks for all the advice  :)
 

 






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users




Similar Topics



Latest Blogs