maemo.org - Talk

maemo.org - Talk (https://talk.maemo.org/index.php)
-   MeeGo / Harmattan (https://talk.maemo.org/forumdisplay.php?f=45)
-   -   Notes Extracting N9 (https://talk.maemo.org/showthread.php?t=81312)

Viny 2012-01-03 18:41

Notes Extracting N9
 
So i have some notes written on my n9 using the default notes application

I need to have them extracted to my pc so i can view it there.

Can someone kindly show/ tell me exactly how i can accomplish this?


Thanks

-Vin

Viny 2012-01-03 20:32

Re: Notes Extracting N9
 
Bump anyone?

impact 2012-01-03 20:40

Re: Notes Extracting N9
 
I'd be interested, too. I was under the impression they were stored as plain text files (Symbian does that), but can't find them

Viny 2012-01-03 21:54

Re: Notes Extracting N9
 
Yeh this would be real helpfull, can someone show us to look into the right direction atleast would be helpfull :D

www.rzr.online.fr 2012-01-03 21:59

Re: Notes Extracting N9
 
it's sqllite db in some .dotdir ....

i wish it supports org format too

Viny 2012-01-03 23:13

Re: Notes Extracting N9
 
lol what? in simpler terms please?

scapegoat845 2012-01-03 23:16

Re: Notes Extracting N9
 
I would also like to know. Pathetic that we can't share Notes via bluetooth....

jflatt 2012-01-03 23:24

Re: Notes Extracting N9
 
They are stored in /home/user/.calendar/db
You need to use sqlite to view them, but it's not a simple task. You'd have to first get the id of the note you want to extract. You can get plain text from the Components table if you just look at the Description field, or you can hit the Customproperties table Value field to get the html

If you only had one note:
Code:

sqlite3 /home/user/.calendar/db 'select value from customproperties'
QOrganizerNote in QtMobility seems to be the clean way of getting ahold of these entries, someone could cook up an extraction app easily enough

www.rzr.online.fr 2012-01-04 00:41

Re: Notes Extracting N9
 
you need to open the terminal or login using ssh ...


I was thinking about designing a mobile editor for notes ... do you use textformats like markdown yaml or orgmode ?

But 1st it would nice to think about integration with other apps such as this calendar notes app...


Btw let me add a few urls :

http://forum.meego.com/showthread.ph...ghlight=editor

http://doc.qt.nokia.com/qtmobility-1...e.html#details

--
http://rzr.online.fr/q/editor

impact 2012-01-04 17:56

Re: Notes Extracting N9
 
They are in a database? OMG.

At least they could allow them to be sync'ed just like the contacts.

anatoki 2012-01-10 03:30

Re: Notes Extracting N9
 
i'm definitely keen to see (and maybe help) some org-mode / mobileorg action on the N9.


Quote:

Originally Posted by www.rzr.online.fr (Post 1145388)

I was thinking about designing a mobile editor for notes ... do you use textformats like markdown yaml or orgmode ?

But 1st it would nice to think about integration with other apps such as this calendar notes app...


quipper8 2012-01-10 03:35

Re: Notes Extracting N9
 
Quote:

Originally Posted by impact (Post 1145752)
They are in a database? OMG.

At least they could allow them to be sync'ed just like the contacts.

is there syncevolution in harmattan? I don't have n9(yet) but on n900 i use syncevolution to sync notes to a funambol server with mysql backend and a small web based frontend in php to edit the notes from PC or whereever. works well for quite a while so far. I hope n9 has this package

F2thaK 2012-01-10 04:23

Re: Notes Extracting N9
 
This is a step backwards from the N900. On that theyre stored as text files in MyDocs, very useful.

gionni88 2012-01-12 22:22

Re: Notes Extracting N9
 
1 Attachment(s)
Try this, it exports all notes in Documents/ExportedNotes.

quipper8 2012-01-18 20:34

Re: Notes Extracting N9
 
Quote:

Originally Posted by gionni88 (Post 1149738)
Try this, it exports all notes in Documents/ExportedNotes.

curious what method you used. I want to make a small app/script to sync the default notes with a web directory.

i was just researching today and it looks like the qsparql might be a good way to read,update,delete notes, but i havent messed with it yet.

gionni88 2012-01-19 08:06

Re: Notes Extracting N9
 
I used QtMobility to get notes. You may also use QtSql directly, since QtMobility slows down when the organizer db gets bigger.

Notes imported from other sources (like N900) are "Note" type, while the ones created with N9/50 are "Journal" type.

www.rzr.online.fr 2012-01-19 08:09

Re: Notes Extracting N9
 
thx If you share the sources of exporter I can rebuilt it , what about importer now ? :-)

Eminem 2012-01-19 18:56

Re: Notes Extracting N9
 
Quote:

Originally Posted by gionni88 (Post 1149738)
Try this, it exports all notes in Documents/ExportedNotes.

Thanks alot. Installed and ran it but it only extracted the newest files not the ones that where created approximately 1 week ago.

quipper8 2012-01-20 02:14

Re: Notes Extracting N9
 
tonight I found you can sync the native notes app over syncml

http://talk.maemo.org/showpost.php?p...65&postcount=9

Eminem 2012-02-19 11:19

Re: Notes Extracting N9
 
Quote:

Originally Posted by gionni88 (Post 1149738)
Try this, it exports all notes in Documents/ExportedNotes.

Can you fix it so all the notes get extracted or that you can choose witch one you want to extract.? I only get the small ones not the ones with more text in them.

gionni88 2012-02-19 11:49

Re: Notes Extracting N9
 
Quote:

Originally Posted by Eminem (Post 1166865)
Can you fix it so all the notes get extracted or that you can choose witch one you want to extract.? I only get the small ones not the ones with more text in them.

On the N950 it extracts all my notes, from the ones imported from my N900 and created 2years ago and to the newest ones, both with short and long texts. If any note in your N9 notes app is not included, I need to know how they are saved in the sql database.

Eminem 2012-02-19 14:05

Re: Notes Extracting N9
 
And how do i get that info about how they are saved?

gionni88 2012-02-19 22:25

Re: Notes Extracting N9
 
It seams after PR 1.2 calendar database is no longer accesible directly. I was going to tell you which sqlite3 commands to type, but I'm not able to see which are the tabs there...

Anyway, the notes retrieved from this app are Journal and Note, and they should cover all N9 notes.

BlinkThinks 2012-03-23 12:51

Re: Notes Extracting N9
 
Hi! Is there any update on this? Any way I can IMPORT my Notes back?

Thanks!

gionni88 2012-03-23 13:35

Re: Notes Extracting N9
 
Quote:

Originally Posted by BlinkThinks (Post 1183181)
Hi! Is there any update on this? Any way I can IMPORT my Notes back?

Thanks!

I have edited the application and published to Nokia Store. You can export a single note now and exported note file name has the last modification date in it.

Free version here and paid version here. Both have same features, you're free to pick the pro to support as well as using the free one.

About importing notes, I prefear to put it in another proper project since I have already picked the application name as it it.

About

BlinkThinks 2012-03-23 14:47

Re: Notes Extracting N9
 
Thank you gionni88!

Am greatly anticipating the app that would allow importing my Notes back. Both are essential if one has to back them up.

======
EDIT:

Ok, I just downloaded the free version. Is there a limitation to the free one which is only able to 'see' two of my more than 20 notes?

skyjumper 2012-04-13 08:28

Re: Notes Extracting N9
 
Quote:

Originally Posted by gionni88 (Post 1183189)

About importing notes, I prefear to put it in another proper project since I have already picked the application name as it it.

About

Hi gionni88, have you made any more progress with the Notes importing app? It really will be helpful as I am sure many would agree...

gionni88 2012-04-13 19:56

Re: Notes Extracting N9
 
Quote:

Originally Posted by skyjumper (Post 1191567)
Hi gionni88, have you made any more progress with the Notes importing app? It really will be helpful as I am sure many would agree...

I'm sorry but I have been busy lately, will spend time on it as soon as I can.

How should it import notes? Picking a directory and importing all txt files in it?

skyjumper 2012-04-14 01:30

Re: Notes Extracting N9
 
Quote:

Originally Posted by gionni88 (Post 1191774)

How should it import notes? Picking a directory and importing all txt files in it?

I am muchly thankful that you are working on it!

Hmm, sounds like a good idea. Yep, as I have quite a few, a sep dir to import would be a good idea. All I ask for is the modification date to be kept. When I synced mine with Outlook I fear I will have lost the mod dates :(

skyjumper 2012-04-14 02:40

Re: Notes Extracting N9
 
re your app, I tried it and was only able to see/export 18 out of my ~ 95 Notes.

I just did a test and changed the modification date of one and it appeared in your app. Maybe the next version could detect all notes regardless if they have the same mod date?

gionni88 2012-04-14 05:56

Re: Notes Extracting N9
 
Quote:

Originally Posted by skyjumper (Post 1191891)
re your app, I tried it and was only able to see/export 18 out of my ~ 95 Notes.

I just did a test and changed the modification date of one and it appeared in your app. Maybe the next version could detect all notes regardless if they have the same mod date?

I don't know why some of your notes are not being shown, I have explicitly set the filter of the Organizer model to show Notes (Plain text without any date set, like the ones you get syncing with an N900) and Journal (Text with a date set, default ones on Harmattan), and I get all notes shown. Are the notes not shown imported when syncing with outlook?

skyjumper 2012-04-14 06:51

Re: Notes Extracting N9
 
Quote:

Originally Posted by gionni88 (Post 1191924)
Are the notes not shown imported when syncing with outlook?

All 98 have been synced with Outlook and are visible. Strange....

gionni88 2012-04-19 09:18

Re: Notes Extracting N9
 
First version of NotesImporter: link

I don't have a lot of time due to exams. so right now it only lets you pick and import a txt file, keeping the last modification date.

As soon as I find more time I'll add full directory importing, and a proper topic for it.

skyjumper 2012-05-01 12:48

Re: Notes Extracting N9
 
Would it be possible to add a "select all" facility to the exporter function to account for people with a large number of notes?

gionni88 2012-05-01 14:40

Re: Notes Extracting N9
 
Quote:

Originally Posted by skyjumper (Post 1200025)
Would it be possible to add a "select all" facility to the exporter function to account for people with a large number of notes?

I may add an "export all" function, which is what first version does.

gionni88 2012-05-26 06:32

Re: Notes Extracting N9
 
Anyone tried NotesImporter? Did it import correctly the txt files you picked?

skyjumper 2012-11-26 04:00

Re: Notes Extracting N9
 
Quote:

Originally Posted by gionni88 (Post 1212705)
Anyone tried NotesImporter? Did it import correctly the txt files you picked?

I just tested the NotesImporter. I only tried it with one note that I just exported using NotesExporter. It imported the note perfectly, correct date and time.

Thanks for the great program.

gionni88 2012-11-26 17:40

Re: Notes Extracting N9
 
Quote:

Originally Posted by skyjumper (Post 1298418)
Thanks for the great program.

You're welcome!

Garp 2014-01-15 21:51

Re: Notes Extracting N9
 
Quote:

Originally Posted by gionni88 (Post 1298638)
You're welcome!

Any news about this app Note exporter which only takes a few notes in (7) out of about 60 - will that problem be solved?

Maxxmoto 2014-01-16 12:28

Re: Notes Extracting N9
 
The solution I found has been to enter every single note, modify something (for example, add a space at the end) and close the note. This way the exporter finds every note (of course you loose the time you write the note...)


All times are GMT. The time now is 12:48.

vBulletin® Version 3.8.8