Active Topics

 



Notices


Reply
Thread Tools
Posts: 44 | Thanked: 31 times | Joined on Dec 2009 @ Vienna, AT
#21
no, in glogarchive there are no deleting functions now. in the normal sms-app, its also not possible. the only way is to use an sqlite3 client, and delete directly via sql...
 
Posts: 40 | Thanked: 0 times | Joined on Jun 2010
#22
guess that will be too advance for me...as neither i know sql nor i know linux (only basic commands) ....thanks a lot though Hope someone makes a tiny utility for it in future...or any page where i can get step by step guide..

thank u once again
 
Posts: 44 | Thanked: 31 times | Joined on Dec 2009 @ Vienna, AT
#23
well, maybe you can do it:
1. copy the database to your PC (el-v1.db the normal message history, el_archive-v1.db is the archive, if you use this)
2. install sqlitebrowser: http://sourceforge.net/projects/sqlitebrowser/files/
3. open the db file with sqlitebrowser
4. run the sql command (i can post it, if you want)
5. save the file
6. copy the saved file back to the n900 (overwrite the old one)
 
Posts: 40 | Thanked: 0 times | Joined on Jun 2010
#24
thanks a lot ..... i can do this much...

1...how do i copy the database to PC? and where this file *.db will be located..?

thanks
 
Posts: 44 | Thanked: 31 times | Joined on Dec 2009 @ Vienna, AT
#25
the db files are located in: /home/user/.rtcom-eventlogger
hm. via USB, i think, you only can read the MyDocs-dir, or not? well, so you can use a connection via wifi, oder network. for example, you can upload the file with a ftp-client to a server, and download it on the PC.. or you install ssh-server on the n900, and an sftp-client on the pc... not as easy :-)
 
Posts: 44 | Thanked: 31 times | Joined on Dec 2009 @ Vienna, AT
#26
a, its easy, of course:
in terminal:
cp /home/user/.rtcom-eventlogger/el-v1.db /home/user/MyDocs/

the you can copy the files via USB connection
 
Posts: 40 | Thanked: 0 times | Joined on Jun 2010
#27
when i connect by USB...either in mass storage or PC suite mode...i dont see Mydoc-dir.. however in terminal i can see mydocs..
I have wifi...if i connect nokia n900 thru wifi ...to access internet, it wont show me my-docs dir? will it?

i will search for ssh server way ..and will try to get the file somehow..thank u . u r really helpful.
 
Posts: 44 | Thanked: 31 times | Joined on Dec 2009 @ Vienna, AT
#28
what do you see, when you connect as mass-storage with USB? you should see, what is in MyDocs
 
Posts: 40 | Thanked: 0 times | Joined on Jun 2010
#29
hey, i got the file on pc...thanks can u tell me the sql command now..and pls tell me how do i copy it back..

just by cp /home/user/MyDocs/el-v1.db /home/user/.rtcom-eventlogger/el-v1.db
 
Posts: 44 | Thanked: 31 times | Joined on Dec 2009 @ Vienna, AT
#30
hehe cool.
pls make a backup from the file, before you use the sql ;-)
cp /home/user/.rtcom-eventlogger/el-v1.db /home/user/.rtcom-eventlogger/el-v1-backup.db

to delete all sent sms, run this command in the "execute SQL" tab:
delete from events where event_type_id = 7 and outgoing = 1

and yes just by
cp /home/user/MyDocs/el-v1.db /home/user/.rtcom-eventlogger/el-v1.db
you can overwrite the old database with your new one
 

The Following User Says Thank You to bananenfisch For This Useful Post:
Reply


 
Forum Jump


All times are GMT. The time now is 06:03.