Exporting to excel error #159
Comments
|
Hi,
Thank you for reporting. I'll have a look.
Are you exporting from a .jwlibrary archive created with the the latest version of JW Library, or an older version?
…On February 9, 2024 6:46:49 p.m. UTC, jonharrell ***@***.***> wrote:
JWLManager v4.3.3
Windows-10-10.0.22631-SP0
Traceback (most recent call last):
File "JWLManager.py", line 1125, in export_items
File "JWLManager.py", line 1065, in export_notes
File "JWLManager.py", line 1011, in get_notes
sqlite3.OperationalError: no such column: n.Created
|
|
It was with the latest version. I was trying to merge two files and wanted to get a clean export of both to manually work through them |
|
reindexing gave this error: JWLManager v4.3.3 Traceback (most recent call last): |
|
I'm sorry I think I was including a sign language back up as well... |
|
It almost looks like you've got an old schema version (older JW Library)....
Please check the JW Library version for me (should be v14+)
Also, if you can, save both archives using that v14+. You may have to restore them (restore a backup) and save them again from JW Library.
…On February 9, 2024 7:22:43 p.m. UTC, jonharrell ***@***.***> wrote:
reindexing gave this error:
JWLManager v4.3.3
Windows-10-10.0.22631-SP0
Traceback (most recent call last):
File "JWLManager.py", line 2374, in trim_db
sqlite3.OperationalError: no such table: PlaylistItemLocationMap
|
|
🤔
I'm not familiar with those... It's that through JW Library as well?
Does everything work correctly otherwise?
…On February 9, 2024 7:28:37 p.m. UTC, jonharrell ***@***.***> wrote:
I'm sorry I think I was including a sign language back up as well...
|
|
It is the JW library sign app. I have both of them backing up into the same folder and grabed one of the sign versions. They have play lists etc but came out with features a few years prior to the main app so I'm sure the db is different. That asside I can export to XLS, txt erorrs and importing XLS errors on #1: JWLManager v4.3.3 Traceback (most recent call last): PC version 14.1.42.0 Exporting to TXT with PC and Android version of the backup have the same error: Traceback (most recent call last): |
|
Just to make sure I understand: you are opening a certain .jwlibrary archive (from the JW Library app) and...
Is there any way you can send me that .jwlibrary archive? You can use the Mask option from Utilities menu to obfuscate all your text fields and then save this archive, zip it up and attach, please. I will have to have a look at the database itself. |
|
Correct, export to xls works, import errors and export to txt errors. |
|
OK, I think you found what I would call an "edge case" involving adding a note to a document (publication page) from the app menu ("Add Note"), which doesn't associate the note with any paragraph (block) in particular. I was handling this with the Bible notes, but not with "regular" publications. I will push out a fix in the next day or two. |
|
@jonharrell That aside, the issue you reported is also present. Fix if coming. |
|
@jonharrell please try v4.4.0 and let me know how it behaves. I did some testing and it behaves correctly, but please do keep backups till you're sure it's all good. Also, do you think it would it be helpful to have access to JW Sign backups in JWLManager? If so, send me a sample backup file and I'll see if I can make some adaptations. |
|
The updated version works great. Also, attached is a jwlib file for sign language with a playlist added for a talk |
|
Jw sign single playlist exports and merging would be incredibly helpful.
I've also manually edited the database a few times to work past crashes
caused by directories that changed after upgrading a computer.
Jon Harrell
…On Sun, Feb 11, 2024, 12:15 AM Eryk J. ***@***.***> wrote:
@jonharrell <https://github.com/jonharrell> please try v4.4.0
<https://github.com/erykjj/jwlmanager/releases/tag/v4.4.0> and let me
know how it behaves. I did some testing and it behaves correctly, but
please do keep backups till you're sure it's all good.
Also, do you think it would it be helpful to have access to JW Sign
backups in JWLManager? If so, send me a sample backup file and I'll see if
I can make some adaptations.
—
Reply to this email directly, view it on GitHub
<#159 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AA5U5RV7RAWR26OXHATQKI3YS7WOJAVCNFSM6AAAAABDB5KJ7WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMZXGI3DKNRQHE>
.
You are receiving this because you were mentioned.Message ID:
***@***.***>
|
Are you sure you attached the correct file? |
Do you mean being able to select individual items in the Playlists view and exporting/importing them (like with Notes, etc.)? |
|
It would be very helpful to be able to export individual playlists and
import them. Also, basic editing of the publication lists would help with
issues that arise from changing drive letters. In the past, after upgrading
computers I've manually edited the db files to point to the media files'
new locations.
But in general the db is a lot less used from the user standpoint as notes
do not exist and only playlists.
The playlist feature predates the main JW library by several years (around
2015/6) so I would suspect it could be very different in structure.
Jon Harrell
…On Mon, Feb 12, 2024, 11:46 PM Eryk J. ***@***.***> wrote:
Jw sign single playlist exports and merging would be incredibly helpful.
Do you mean being able to select individual items in the Playlists view
and exporting/importing them (like with Notes, etc.)?
—
Reply to this email directly, view it on GitHub
<#159 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AA5U5RV2D3S4QALRSTWNAV3YTKETNAVCNFSM6AAAAABDB5KJ7WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMZZGY2DEMBSGE>
.
You are receiving this because you were mentioned.Message ID:
***@***.***>
|
|
I can certainly think about it... |
|
Sorry about that, the last attachment was obviously wrong and the actual one was too large. I simplified the talk by removing many of the videos and it is small enough now. |
|
Thank you. I will close this issue as completed, if you don't mind. |
Hi @jonharrell If so, what kind of OS do you use? Can you by any chance execute the Python directly, or do you need the compiled binaries? PS: just noticed you are on Win10. Can you do Python directly? |
JWLManager v4.3.3
Windows-10-10.0.22631-SP0
Traceback (most recent call last):
File "JWLManager.py", line 1125, in export_items
File "JWLManager.py", line 1065, in export_notes
File "JWLManager.py", line 1011, in get_notes
sqlite3.OperationalError: no such column: n.Created
The text was updated successfully, but these errors were encountered: