Hi Alex,
today i had another crash causing the database file to go "malformed" (SQLite Error 11). There was no other exception. Again log1.txt was empty (0 bytes).
As usual i created a new db file and imported from the old database.
To fully regain all of my data i ask to include recycle bin also (at least as an option), when doing an import. There is no other easy way to recover that data otherwise, since xml-export/import doesn't support it either.
Thomas
Import should include recycle bin
Forum rules
1. Please keep it one request/suggestion per topic.
2. Please mark the requests with the following tags:
[Startup] - issue related to the program's startup or shutdown process;
[Taking] and [Clipping] - related to acquiring/creating notes (excl. editing);
[Viewing] - related to notes list browsing and reading;
[Editing] - related to the process of editing new and existing notes;
[Search] - related to note searching and finding;
[Managing] - related to note organization and management;
[Reordering/Sorting] - related to sorting or reordering the notes list;
[Clipboard] - clipboard operations;
[Import] and [Export] - issue related to bulk notes import/export;
[Globalization] - issues related to multiple languages/cultures support;
[Files] and [Backup] - file operations,notes back-end and backup;
[UI] - UI issues which don't fall into any of the above categories;
[Other] - other issues which don't fall into any of the above categories.
Thank you!
1. Please keep it one request/suggestion per topic.
2. Please mark the requests with the following tags:
[Startup] - issue related to the program's startup or shutdown process;
[Taking] and [Clipping] - related to acquiring/creating notes (excl. editing);
[Viewing] - related to notes list browsing and reading;
[Editing] - related to the process of editing new and existing notes;
[Search] - related to note searching and finding;
[Managing] - related to note organization and management;
[Reordering/Sorting] - related to sorting or reordering the notes list;
[Clipboard] - clipboard operations;
[Import] and [Export] - issue related to bulk notes import/export;
[Globalization] - issues related to multiple languages/cultures support;
[Files] and [Backup] - file operations,notes back-end and backup;
[UI] - UI issues which don't fall into any of the above categories;
[Other] - other issues which don't fall into any of the above categories.
Thank you!
-
- Posts: 1324
- Joined: Tue Mar 08, 2011 11:15 am
Import should include recycle bin
Last edited by Thomas Lohrum on Wed Mar 18, 2015 1:20 pm, edited 1 time in total.
- usbpoweredfridge
- Posts: 410
- Joined: Fri Jan 17, 2014 11:08 pm
- Contact:
Re: Import should include recycle bin
Support+
Chris
Chris
- CintaNotes Developer
- Site Admin
- Posts: 5003
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Import should include recycle bin
Hi guys,
Thanks for the suggestion. I added it to the roadmap:
http://roadmap.cintanotes.com/topic/646240-/
Also there's a workaround here, please see the attached .bat file.
(It requires for sqlite3.exe to be in PATH or in the current directory).
Use as follows:
Also keep an eye on the "Delete permanently after N days" setting - it can empty the recycle bin before you open it!
Hope this helps!
Thanks for the suggestion. I added it to the roadmap:
http://roadmap.cintanotes.com/topic/646240-/
Also there's a workaround here, please see the attached .bat file.
(It requires for sqlite3.exe to be in PATH or in the current directory).
Use as follows:
Code: Select all
C:\Temp\>copytrash.bat old.db new.db
Also keep an eye on the "Delete permanently after N days" setting - it can empty the recycle bin before you open it!
Hope this helps!
- Attachments
-
- copytrash.zip
- (256.4 KiB) Downloaded 362 times
Alex
-
- Posts: 1324
- Joined: Tue Mar 08, 2011 11:15 am
Re: Import should include recycle bin
Thanks Alex. An easy to use workaround does the job to me. For less experienced users the feature on the roadmap is more important. Btw. there is no need to set the variables in the batch file. They are not used anyway.
The relevant statement to all interested is:
sqlite3.exe -echo -batch [db] "ATTACH DATABASE '[old-db]' AS Old; INSERT INTO NotesTrash SELECT * FROM Old.NotesTrash;"
Example:
sqlite3.exe -echo -batch cintanotes.db "ATTACH DATABASE 'old-cintanotes.db' AS Old; INSERT INTO NotesTrash SELECT * FROM Old.NotesTrash;"
sqlite3.exe is provided by the download of copytrash.zip in this thread.
Thomas
The relevant statement to all interested is:
sqlite3.exe -echo -batch [db] "ATTACH DATABASE '[old-db]' AS Old; INSERT INTO NotesTrash SELECT * FROM Old.NotesTrash;"
Example:
sqlite3.exe -echo -batch cintanotes.db "ATTACH DATABASE 'old-cintanotes.db' AS Old; INSERT INTO NotesTrash SELECT * FROM Old.NotesTrash;"
sqlite3.exe is provided by the download of copytrash.zip in this thread.
Thomas
- CintaNotes Developer
- Site Admin
- Posts: 5003
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Import should include recycle bin
Thomas, thanks for summing up.
Sorry for redundant vars - I intended to improve readability with them but never got to it;)
Sorry for redundant vars - I intended to improve readability with them but never got to it;)
Alex
- CintaNotes Developer
- Site Admin
- Posts: 5003
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Import should include recycle bin
I think that generally export to XML and import from XML and DB should give the option to include the recycle bin (which would be off by default). What do you think?
Alex
-
- Posts: 1324
- Joined: Tue Mar 08, 2011 11:15 am
Re: Import should include recycle bin
CintaNotes Developer wrote:I think that generally export to XML and import from XML and DB should give the option to include the recycle bin (which would be off by default). What do you think?
Reasons to do so:
- We had people here in the forum telling us, they are actually using r-bin as part of their data management.
- We had people complain about the loss of r-bin after importing their data to a new database, because the old one got corrupted.
- We consider r-bin as part of the database.
So yes, your intention is correct. Let's add it as a general option.
Thomas
- CintaNotes Developer
- Site Admin
- Posts: 5003
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Import should include recycle bin
Agreed on all accounts. I'll add this task to our backlog, with medium priority. Thanks!
Alex