Org cite in SQLite?

Org cite in SQLite?

[Thomas S. Dye]

Aloha all,

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?

All the best,
Tom

-- 
Thomas S. Dye
https://tsdye.online/tsdye

Re: Org cite in SQLite?

[Ihor Radchenko]

"Thomas S. Dye" <tsd@tsdye.online> 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?

-- 
Ihor Radchenko // yantar92,
Org mode contributor,
Learn more about Org mode at <https://orgmode.org/>.
Support Org development at <https://liberapay.com/org-mode>,
or support my work at <https://liberapay.com/yantar92>

Re: Org cite in SQLite?

[Thomas S. Dye]

Ihor Radchenko <yantar92@posteo.net> writes:

> "Thomas S. Dye" <tsd@tsdye.online> 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

Re: Org cite in SQLite?

[Ihor Radchenko]

"Thomas S. Dye" <tsd@tsdye.online> writes:

> 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?

I can reproduce on the latest bugfix, but I cannot reproduce on the
latest main - the citation is exported verbatim on main, which is
expected.

-- 
Ihor Radchenko // yantar92,
Org mode contributor,
Learn more about Org mode at <https://orgmode.org/>.
Support Org development at <https://liberapay.com/org-mode>,
or support my work at <https://liberapay.com/yantar92>

Re: Org cite in SQLite?

[Thomas S. Dye]

Ihor Radchenko <yantar92@posteo.net> writes:

> "Thomas S. Dye" <tsd@tsdye.online> writes:
>
>> 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?
>
> I can reproduce on the latest bugfix, but I cannot reproduce on 
> the
> latest main - the citation is exported verbatim on main, which 
> is
> expected.

Good to know.  Thanks.

-- 
Thomas S. Dye
https://tsdye.online/tsdye