DMARC-Filter: OpenDMARC Filter v1.4.1 sourceware.org D9ECD385801D
To: cygwin@cygwin.com
References: <DB6PR03MB3013DA14572084F45EB25642A4A29@DB6PR03MB3013.eurprd03.prod.outlook.com>
From: Brian Inglis <Brian.Inglis@SystematicSw.ab.ca>
Organization: Systematic Software
Subject: Re: How to convert Android contacts2.db to a Vcard .vcf file?
Message-ID: <4b627bac-f546-5c08-6fb8-6ea9e1dfd16b@SystematicSw.ab.ca>
Date: Wed, 22 Sep 2021 12:16:44 -0600
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101
 Thunderbird/78.14.0
MIME-Version: 1.0
In-Reply-To: <DB6PR03MB3013DA14572084F45EB25642A4A29@DB6PR03MB3013.eurprd03.prod.outlook.com>
Content-Language: en-CA
Precedence: list
Reply-To: cygwin@cygwin.com
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="us-ascii"; Format="flowed"
Errors-To: cygwin-bounces+archive-cygwin=delorie.com@cygwin.com
Sender: "Cygwin" <cygwin-bounces+archive-cygwin=delorie.com@cygwin.com>

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.]

-- 
Problem reports:      https://cygwin.com/problems.html
FAQ:                  https://cygwin.com/faq/
Documentation:        https://cygwin.com/docs.html
Unsubscribe info:     https://cygwin.com/ml/#unsubscribe-simple