public inbox for cygwin@cygwin.com
 help / color / mirror / Atom feed
* How to convert Android contacts2.db to a Vcard .vcf file?
@ 2021-09-22 15:40 Fergus Daly
  2021-09-22 18:16 ` Brian Inglis
  2021-09-28  8:51 ` Andrey Repin
  0 siblings, 2 replies; 3+ messages in thread
From: Fergus Daly @ 2021-09-22 15:40 UTC (permalink / raw)
  To: 'cygwin@cygwin.com'

To try to do this I have followed the hints at
https://www.youtube.com/watch?v=ZKX6R0-EPC4
and therefore
1. installed sqlite and libsqlite-dev 
2. Downloaded dump-contacts2db.sh from https://github.com/stachre/dump-contacts2db/
3. FAILED to turn this script into an executable using chmod +x
and therefore 
4. failed to achieve the one-line command
    $ dump-contacts2db.sh contacts2.db > contacts.vcf
Can anybody help with item 3 or offer an entirely different / better / easier method to achieve the conversion?
Thank you!
  

^ permalink raw reply	[flat|nested] 3+ messages in thread

* Re: How to convert Android contacts2.db to a Vcard .vcf file?
  2021-09-22 15:40 How to convert Android contacts2.db to a Vcard .vcf file? Fergus Daly
@ 2021-09-22 18:16 ` Brian Inglis
  2021-09-28  8:51 ` Andrey Repin
  1 sibling, 0 replies; 3+ messages in thread
From: Brian Inglis @ 2021-09-22 18:16 UTC (permalink / raw)
  To: cygwin

On 2021-09-22 09:40, Fergus Daly via Cygwin wrote:
> To try to do this I have followed the hints at
> https://www.youtube.com/watch?v=ZKX6R0-EPC4

Which Android version or how old is the video?

> and therefore
> 1. installed sqlite and libsqlite-dev
> 2. Downloaded dump-contacts2db.sh from https://github.com/stachre/dump-contacts2db/
> 3. FAILED to turn this script into an executable using chmod +x

Download Raw rendering and move from Downloads or wherever to your local 
personal bin directory then "chmod -v a+rx dump-contacts2db.sh".

> and therefore
> 4. failed to achieve the one-line command
>      $ dump-contacts2db.sh contacts2.db > contacts.vcf
> Can anybody help with item 3 or offer an entirely different / better / easier method to achieve the conversion?

Learn enough sqlite to list tables, and columns in tables, to check if 
that matches with the script columns and assumptions, and perform the 
query yourself in the utility, to check or customize the script for your 
own needs.

BTDT: wasn't too hard, interesting, or useful; promptly forgot all about 
everything!

-- 
Take care. Thanks, Brian Inglis, Calgary, Alberta, Canada

This email may be disturbing to some readers as it contains
too much technical detail. Reader discretion is advised.
[Data in binary units and prefixes, physical quantities in SI.]

^ permalink raw reply	[flat|nested] 3+ messages in thread

* Re: How to convert Android contacts2.db to a Vcard .vcf file?
  2021-09-22 15:40 How to convert Android contacts2.db to a Vcard .vcf file? Fergus Daly
  2021-09-22 18:16 ` Brian Inglis
@ 2021-09-28  8:51 ` Andrey Repin
  1 sibling, 0 replies; 3+ messages in thread
From: Andrey Repin @ 2021-09-28  8:51 UTC (permalink / raw)
  To: Fergus Daly, cygwin

Greetings, Fergus Daly!

> To try to do this I have followed the hints at
> https://www.youtube.com/watch?v=ZKX6R0-EPC4
> and therefore
> 1. installed sqlite and libsqlite-dev 
> 2. Downloaded dump-contacts2db.sh from
> https://github.com/stachre/dump-contacts2db/
> 3. FAILED to turn this script into an executable using chmod +x
> and therefore 
> 4. failed to achieve the one-line command
>     $ dump-contacts2db.sh contacts2.db > contacts.vcf
> Can anybody help with item 3 or offer an entirely different / better /
> easier method to achieve the conversion?

If that's a usual SQLite3 database file, get any given SQLite3 database
browser (SQLiteMan f.e.) and play with it as much as you'd need.


-- 
With best regards,
Andrey Repin
Tuesday, September 28, 2021 11:51:01

Sorry for my terrible english...


^ permalink raw reply	[flat|nested] 3+ messages in thread

end of thread, other threads:[~2021-09-28  9:05 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2021-09-22 15:40 How to convert Android contacts2.db to a Vcard .vcf file? Fergus Daly
2021-09-22 18:16 ` Brian Inglis
2021-09-28  8:51 ` Andrey Repin

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).