From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2.migadu.com ([2001:41d0:303:e224::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms1.migadu.com with LMTPS id 4M7SHpk9EGaflgAAe85BDQ:P1 (envelope-from ) for ; Fri, 05 Apr 2024 20:06:17 +0200 Received: from aspmx1.migadu.com ([2001:41d0:303:e224::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2.migadu.com with LMTPS id 4M7SHpk9EGaflgAAe85BDQ (envelope-from ) for ; Fri, 05 Apr 2024 20:06:17 +0200 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=tsdye.online header.s=default header.b=wnmgW9ke; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1712340377; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=xQpX40DVMX6manEJEAsSgJ0hmQWrFKgFf9cFKmSTpmQ=; b=r9dN6GZbjU1a+tfkaN8ctIZeTGytjDMbHRw04GxfL8ruaVm7Wcw45N5lEmen174qrYRsJV 9hLzKQVKhlNX7ZGhxtlLtS/oPlEd7yQU76rUSscYEVgK/dtYLg63M1TGrOIqHqqbhBYCUh yiBBH7/Fnr+bEWMXQGCaMU2hkhvHYKwoBTIiqUVjxrjL3yO7rZKajoCgoyYjyuEFfYjv8V zj3yMcUFAbA6E//bnFaA5bSxbXPQlnpxvKwIV+neADn++/AvV2UE+6Mc4y50GlGS5IB6cD sro44FAlls0FQP/fm99LJiWsNYvN03TgZ8Q5ID+M5gwEbe5r+e+RJIKUkunbLA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1712340377; a=rsa-sha256; cv=none; b=IPkm8ykJHBp9/zVqa3xSyujCdBflItzhW0MQgSoQvjsriQOF+Zx+8zyaqgR3WmXsEMz1cU i2BcPGl8N7flvCVfunmzvKa5qb3AD6iStPZJlcUgGtggpdTWflLKZmje6xpNoJoQD61Pls q5sdgu4jn74LfGtIL8KlH9BMalFPKzao5gOd6k33AQ0Ls9VYPBUy0cWD5Vz+jTdf/y/whK dWjHZQu34KqM87ICDCaJFFgW0cfeLbSntAiVBzIiZcw5vBF19D2Ng7QpNASfgoX+XRimQp F/mscrL0Dml9ARCW6ZtmSGxZfPzyHH7xMwKIpq3uNXbt4B6eT+E51FpFRwgS9A== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=tsdye.online header.s=default header.b=wnmgW9ke; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=none Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 3D8AC37492 for ; Fri, 5 Apr 2024 20:06:16 +0200 (CEST) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1rsnwS-0005fT-8f; Fri, 05 Apr 2024 14:05:32 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rsnwN-0005f3-BC for emacs-orgmode@gnu.org; Fri, 05 Apr 2024 14:05:27 -0400 Received: from omta40.uswest2.a.cloudfilter.net ([35.89.44.39]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rsnwG-0002M3-Ta for emacs-orgmode@gnu.org; Fri, 05 Apr 2024 14:05:26 -0400 Received: from eig-obgw-5010a.ext.cloudfilter.net ([10.0.29.199]) by cmsmtp with ESMTPS id sn6jrZ4IqPM1hsnvsrSQPr; Fri, 05 Apr 2024 18:04:56 +0000 Received: from box2035.bluehost.com ([74.220.219.237]) by cmsmtp with ESMTPS id snvrrZoRRo82ksnvsrHvAO; Fri, 05 Apr 2024 18:04:56 +0000 X-Authority-Analysis: v=2.4 cv=WOB5XGsR c=1 sm=1 tr=0 ts=66103d48 a=VozZY++RX3oc2UgfNhVfaA==:117 a=VozZY++RX3oc2UgfNhVfaA==:17 a=MKtGQD3n3ToA:10 a=1oJP67jkp3AA:10 a=raytVjVEu-sA:10 a=DPR-AOO6AYYA:10 a=uChsZFC9AAAA:8 a=o9zw6IYYAAAA:8 a=gVwylur9nKNJQU5NmwUA:9 a=d_VElMKDodcA:10 a=-FEs8UIgK8oA:10 a=A2tt7buDTgElyBcRWK2c:22 a=ULtXvzFHYWHLyBAuiDia:22 a=BtxB1_lq3pBo68oZtZ_9:22 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=tsdye.online; s=default; h=Content-Type:MIME-Version:Message-ID:In-reply-to :Date:Subject:Cc:To:From:References:Sender:Reply-To:Content-Transfer-Encoding :Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=xQpX40DVMX6manEJEAsSgJ0hmQWrFKgFf9cFKmSTpmQ=; b=wnmgW9kefSeEQpH3nSGovqIUWr d/6A+zh4zQWTUQ7pThyYqJXhh4HycQJyh8yC7StR8m0vTz/N55Uw5SlJlQOR7ZiJKqPtsjevn4RBK zJ6fsFzJl/Ji39C4W42w0VLLvyGfNZzFFckwibPnYB7s2+bV/OM02o25V5uABncvtDk7CqfvkKLYM MFLI7tAdYxYXebJHW4a+tNw9B66ve+bQwww8xOzPaqGSJIbvvv2sr7p0YOmSj/Rxy1EddsoT5IjiD yftpviaD2BMEDFuifdDw/FnhSlZhHZBek283JP4XDlr9M3rFEMf94rcvzDEpna9lWGLP009+Jsbnh UpWXPxrg==; Received: from 050-113-033-148.res.spectrum.com ([50.113.33.148]:53726 helo=poto-foou.tsdye.online) by box2035.bluehost.com with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96.2) (envelope-from ) id 1rsnvr-000n0n-0f; Fri, 05 Apr 2024 12:04:55 -0600 References: <87bkmmh6bz.fsf@tsdye.online> <87pmb1wsyt.fsf@localhost> User-agent: mu4e 1.6.10; emacs 27.1 From: "Thomas S. Dye" To: Ihor Radchenko Cc: "Thomas S. Dye" , emacs-orgmode@gnu.org Subject: Re: Org cite in SQLite? Date: Fri, 05 Apr 2024 07:47:10 -1000 In-reply-to: <87pmb1wsyt.fsf@localhost> Message-ID: <87zfu7r8hm.fsf@tsdye.online> MIME-Version: 1.0 Content-Type: text/plain; format=flowed X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - box2035.bluehost.com X-AntiAbuse: Original Domain - gnu.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - tsdye.online X-BWhitelist: no X-Source-IP: 50.113.33.148 X-Source-L: No X-Exim-ID: 1rsnvr-000n0n-0f X-Source: X-Source-Args: X-Source-Dir: X-Source-Sender: 050-113-033-148.res.spectrum.com (poto-foou.tsdye.online) [50.113.33.148]:53726 X-Source-Auth: tsd@tsdye.online X-Email-Count: 2 X-Org: HG=bhshared;ORG=bluehost; X-Source-Cap: dHNkeWVvbmw7dHNkeWVvbmw7Ym94MjAzNS5ibHVlaG9zdC5jb20= X-Local-Domain: yes X-CMAE-Envelope: MS4xfM48j1cyzfpeA/jbtwFi5U+EMMawBtq8zQO7wMBcY3Uf2ZGXgxOWa6kTOsi6KYvsms/Juwwe4i5NNHN/v1zj8axdRx6eKT0w7+QyBAXOEe2FxeBA9awT T8xjUUbZyGyyrjXimFZ2CTLzaLvEozT9n4Fj/WT67aI3xbDG0OdIsSHZciqFB8n7IvNahK297zSO2ymYQ4UZqn27UPxrTpwsuNk= Received-SPF: pass client-ip=35.89.44.39; envelope-from=tsd@tsdye.online; helo=omta40.uswest2.a.cloudfilter.net X-Spam_score_int: 4 X-Spam_score: 0.4 X-Spam_bar: / X-Spam_report: (0.4 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FROM_SUSPICIOUS_NTLD=0.499, PDS_OTHER_BAD_TLD=1.999, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: emacs-orgmode-bounces+larch=yhetil.org@gnu.org X-Migadu-Flow: FLOW_IN X-Migadu-Country: US X-Migadu-Spam-Score: 1.50 X-Spam-Score: 1.50 X-Migadu-Queue-Id: 3D8AC37492 X-Migadu-Scanner: mx12.migadu.com X-TUID: abcdOuURgvSu Ihor Radchenko writes: > "Thomas S. Dye" writes: > >> The @ character in an Org citation seems to block import to an >> SQLite table. >> >> Has anyone successfully imported an Org citation to an SQLite >> table? > > Could you please elaborate? It appears I let this drop. My apologies. I think my problem is caused by orgtbl-to-csv. When I export the following table to csv with orgtbl-to-csv from emacs -q: #+name: test-csv-export | index | citation | |-------+-------------------------------------------------------| | 1 | [cite: @schulte12:_multi_languag_comput_envir_liter;] | The result excludes the citation: index,citation 1, Is this expected? If so, is there a work-around? All the best, Tom -- Thomas S. Dye https://tsdye.online/tsdye