X-Recipient: archive-cygwin AT delorie DOT com
X-Original-To: cygwin AT cygwin DOT com
Delivered-To: cygwin AT cygwin DOT com
DMARC-Filter: OpenDMARC Filter v1.4.1 sourceware.org D9ECD385801D
Authentication-Results: sourceware.org; dmarc=none (p=none dis=none)
 header.from=SystematicSw.ab.ca
Authentication-Results: sourceware.org;
 spf=none smtp.mailfrom=systematicsw.ab.ca
X-Authority-Analysis: v=2.4 cv=Bbi7bph2 c=1 sm=1 tr=0 ts=614b730d
 a=T+ovY1NZ+FAi/xYICV7Bgg==:117 a=T+ovY1NZ+FAi/xYICV7Bgg==:17
 a=IkcTkHD0fZMA:10 a=vnREMb7VAAAA:8 a=t90Gm-SIAAAA:20 a=94nOnFI1EgyDtX4ev68A:9
 a=QEXdDO2ut3YA:10
To: cygwin AT cygwin DOT com
References: <DB6PR03MB3013DA14572084F45EB25642A4A29 AT DB6PR03MB3013 DOT eurprd03 DOT prod DOT outlook DOT com>
From: Brian Inglis <Brian DOT Inglis AT SystematicSw DOT ab DOT 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
X-CMAE-Envelope: MS4xfANbjyyC8CfdB44q7xvThUBSAEQQruQYClF+e/z+ro15eqk7BETV2VmAREcEvoNC7l1zxNBppXPNVPm7Kx59zY3YDA162WaoKtkGcR+W6fAvqK4ZUEj1
 9pMMze0QnKGORnjMQ7zCm7zxTO1YOERu72MMDtG+vr512QmXr0Cd89jKtrfWqfChU7n7+xEqXdcYoRQN5/quvC1K34PqtX3/6T0=
X-Spam-Status: No, score=-1160.8 required=5.0 tests=BAYES_00, KAM_DMARC_STATUS,
 KAM_LAZY_DOMAIN_SECURITY, NICE_REPLY_A, RCVD_IN_BARRACUDACENTRAL,
 RCVD_IN_DNSWL_NONE, RCVD_IN_MSPIKE_H3, RCVD_IN_MSPIKE_WL, SPF_HELO_NONE,
 SPF_NONE, TXREP autolearn=no autolearn_force=no version=3.4.4
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on
 server2.sourceware.org
X-BeenThere: cygwin AT cygwin DOT com
X-Mailman-Version: 2.1.29
Precedence: list
List-Id: General Cygwin discussions and problem reports <cygwin.cygwin.com>
List-Unsubscribe: <https://cygwin.com/mailman/options/cygwin>,
 <mailto:cygwin-request AT cygwin DOT com?subject=unsubscribe>
List-Archive: <https://cygwin.com/pipermail/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-request AT cygwin DOT com?subject=help>
List-Subscribe: <https://cygwin.com/mailman/listinfo/cygwin>,
 <mailto:cygwin-request AT cygwin DOT com?subject=subscribe>
Reply-To: cygwin AT cygwin DOT com
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="us-ascii"; Format="flowed"
Errors-To: cygwin-bounces+archive-cygwin=delorie DOT com AT cygwin DOT com
Sender: "Cygwin" <cygwin-bounces+archive-cygwin=delorie DOT com AT cygwin DOT 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