OESF Portal | OESF Forum | OESF Wiki | LinuxPDA | #planetgemini chat on matrix.org | #gemini-pda chat on Freenode | #zaurus and #alarmz chat on Freenode | ELSI (coming soon) | Ibiblio

IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Transferring texts and contacts to Android
Zarhan
post Nov 20 2019, 11:16 AM
Post #1





Group: Members
Posts: 16
Joined: 27-June 19
Member No.: 850,871



I have an N900 as my daily driver. It has SMS and MMS history from quite a long period. I can export the SMSes in CSV format easily (it's just an sqlite database).

What's the best method to transfer these to Android (preferably without some paid app).

I found this https://github.com/teleshoes/Android-SMS-DB-importer but not much else.

Same applies for contacts. I can always export them to the SIM card of course and import back in, but SIM card only allows you to have one phone number per contact and not ancillary info (company, etc). I can export them as VCFs from the N900.

I'd prefer to avoid syncing them via a Google account. In fact, I hope to run my Android with minimal interactions with google, except for Play store.
Go to the top of the page
 
+Quote Post
vader
post Nov 20 2019, 06:12 PM
Post #2





Group: Members
Posts: 285
Joined: 21-January 18
Member No.: 816,775



QUOTE(Zarhan @ Nov 21 2019, 05:16 AM) *
I have an N900 as my daily driver. It has SMS and MMS history from quite a long period. I can export the SMSes in CSV format easily (it's just an sqlite database).

What's the best method to transfer these to Android (preferably without some paid app).

I found this https://github.com/teleshoes/Android-SMS-DB-importer but not much else.

Same applies for contacts. I can always export them to the SIM card of course and import back in, but SIM card only allows you to have one phone number per contact and not ancillary info (company, etc). I can export them as VCFs from the N900.

I'd prefer to avoid syncing them via a Google account. In fact, I hope to run my Android with minimal interactions with google, except for Play store.


1) I went from sailfish to android, and just used scp (termux) to copy the file. Your N900 probably has an ssh server, so this should work fine. Make sure both devices are connected to the same WiFi AP.
2) Alternatively, on the N900 (I am assuming you have standard shell access). (install python and) Run the built in python web server with:

python -m http.server

or the correct library for your python version. This creates a web server at port 8000. Simply navigate to that page on the android and download the file.

3) bluetooth transfer
4) insert a USB stick in the OTG port of the n900, copy the file to the USB, then transfer to the android (I'm just trying to remember if the n900 had OTG.....)
5) (for proper pencil heads only) You can use USB networking, but that really is no different to using wifi, just faster. For a small file like the VCF, it won't make a difference.

I used method 1 smile.gif
Go to the top of the page
 
+Quote Post
Zarhan
post Nov 21 2019, 11:54 AM
Post #3





Group: Members
Posts: 16
Joined: 27-June 19
Member No.: 850,871



QUOTE(vader @ Nov 21 2019, 05:12 AM) *
1) I went from sailfish to android, and just used scp (termux) to copy the file.


"Just copy the file"? Are you saying that Android uses same sqlite db structure that Maemo used? What file?

To clarify - I know how to get files off N900 (scp is easiest) - I was interested in the best method for getting the information converted into Android's messaging DB format. Just to be clear smile.gif
Go to the top of the page
 
+Quote Post
vader
post Nov 22 2019, 04:42 AM
Post #4





Group: Members
Posts: 285
Joined: 21-January 18
Member No.: 816,775



QUOTE(Zarhan @ Nov 22 2019, 05:54 AM) *
QUOTE(vader @ Nov 21 2019, 05:12 AM) *
1) I went from sailfish to android, and just used scp (termux) to copy the file.


"Just copy the file"? Are you saying that Android uses same sqlite db structure that Maemo used? What file?

To clarify - I know how to get files off N900 (scp is easiest) - I was interested in the best method for getting the information converted into Android's messaging DB format. Just to be clear smile.gif


Apologies. I should have realised that - n900 users are hard core smile.gif

I exported my contacts as a VCF file, which imported straight into the android contacts app. It will also accept csv and a few other formats. On sailfish, a simple backup creates a tar file which contains all.vcf (which I copied across). Sailfish is maemo based, so maybe you could do the same thing. If it uses the same mechanism, back up the phone, tar tvf/xvf the backup file and look for all.vcf. Transfer that file to android. A bonus is that vcf keeps any image stored with contacts. You don't need to convert the information - the import process does that. Open contacts, press the hamburger menu (top left), go to settings, then scroll down and select import.
Go to the top of the page
 
+Quote Post
Zarhan
post Nov 22 2019, 11:32 PM
Post #5





Group: Members
Posts: 16
Joined: 27-June 19
Member No.: 850,871



QUOTE(vader @ Nov 22 2019, 03:42 PM) *
I exported my contacts as a VCF file, which imported straight into the android contacts app. It will also accept csv and a few other formats. On sailfish, a simple backup creates a tar file which contains all.vcf (which I copied across). Sailfish is maemo based, so maybe you could do the same thing. If it uses the same mechanism, back up the phone, tar tvf/xvf the backup file and look for all.vcf. Transfer that file to android. A bonus is that vcf keeps any image stored with contacts. You don't need to convert the information - the import process does that. Open contacts, press the hamburger menu (top left), go to settings, then scroll down and select import.


That actually does seem to be the easiest option for contacts. I can just tell it to export to VCFs and get the VCFs off the phone.

Now hopefully there's a good solution for getting the texts in..Well, there seem to be stuff like http://www.veryandroid.com/how-to-restore-...roid-phone.html available if I just google "import csv to android sms" but most of these seem be commercial software products, which I kind of find odd.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 22nd January 2020 - 09:26 AM