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!
Thomas Lohrum
Posts: 1324
Joined: Tue Mar 08, 2011 11:15 am

Import should include recycle bin

Postby Thomas Lohrum » Wed Mar 18, 2015 11:40 am

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
Last edited by Thomas Lohrum on Wed Mar 18, 2015 1:20 pm, edited 1 time in total.
User avatar
usbpoweredfridge
Posts: 410
Joined: Fri Jan 17, 2014 11:08 pm
Contact:

Re: Import should include recycle bin

Postby usbpoweredfridge » Wed Mar 18, 2015 12:58 pm

Support+

Chris
User avatar
CintaNotes Developer
Site Admin
Posts: 5003
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Import should include recycle bin

Postby CintaNotes Developer » Thu Mar 19, 2015 6:46 am

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:

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
Thomas Lohrum
Posts: 1324
Joined: Tue Mar 08, 2011 11:15 am

Re: Import should include recycle bin

Postby Thomas Lohrum » Thu Mar 19, 2015 9:20 am

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
User avatar
CintaNotes Developer
Site Admin
Posts: 5003
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Import should include recycle bin

Postby CintaNotes Developer » Thu Mar 19, 2015 9:24 am

Thomas, thanks for summing up.
Sorry for redundant vars - I intended to improve readability with them but never got to it;)
Alex
User avatar
CintaNotes Developer
Site Admin
Posts: 5003
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Import should include recycle bin

Postby CintaNotes Developer » Fri Mar 20, 2015 8:20 pm

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
Thomas Lohrum
Posts: 1324
Joined: Tue Mar 08, 2011 11:15 am

Re: Import should include recycle bin

Postby Thomas Lohrum » Mon Mar 23, 2015 9:33 am

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
User avatar
CintaNotes Developer
Site Admin
Posts: 5003
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Import should include recycle bin

Postby CintaNotes Developer » Thu Mar 26, 2015 6:38 pm

Agreed on all accounts. I'll add this task to our backlog, with medium priority. Thanks!
Alex

Return to “Feature Requests”