emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* using orgtbl-sqlinsert
@ 2013-05-26  6:56 Eric Abrahamsen
  2013-06-02  5:25 ` Eric Abrahamsen
  2013-09-24 22:00 ` Carsten Dominik
  0 siblings, 2 replies; 9+ messages in thread
From: Eric Abrahamsen @ 2013-05-26  6:56 UTC (permalink / raw)
  To: emacs-orgmode

I've got a table I'm trying to insert into a sqlite database. I've been
looking at orgtbl-sqlinsert and this page[fn:1], but I suspect all that
is out of date. I haven't seen anyone talking about #+ORGTBL: keywords,
or things like "#+BEGIN RECEIVE ORGTBL exsql" in the past year or so.

Do those still work? I can't for the life of me get it to do anything.
I've got a sqlite database called "market.sqlite" in the same directory
as a file containing this:

#+TBLNAME: terms
#+ORGTBL: SEND market.sqlite orgtbl-to-sqlinsert :sqlname "terms"
| Chinese          | English                            |
|------------------+------------------------------------|
| 音像制品出版     | A/V Publishing                     |
| 定价总金额       | Aggregate Retail Price             |
(etc)

I've tried C-c C-c on that header, calling
`org-babel-execute-src-block', waving my fingers at it, and cursing
loudly, one of which usually works. But I get no error, no insertion
into the database, and no results block with INSERT statements (I tried
making a #+BEGIN RECEIVE ORGTBL marketdb.sqlite block as noted on worg).

Does this still work? Or is it still possible to jimmy orgtbl-sqlinsert
to either insert directly, or create a block of INSERT statements?

Thanks!

Footnotes:

[fn:1] http://orgmode.org/worg/org-tutorials/multitarget-tables.html

^ permalink raw reply	[flat|nested] 9+ messages in thread
* using orgtbl-sqlinsert
@ 2013-05-26  6:56 Eric Abrahamsen
  0 siblings, 0 replies; 9+ messages in thread
From: Eric Abrahamsen @ 2013-05-26  6:56 UTC (permalink / raw)
  To: emacs-orgmode

I've got a table I'm trying to insert into a sqlite database. I've been
looking at orgtbl-sqlinsert and this page[fn:1], but I suspect all that
is out of date. I haven't seen anyone talking about #+ORGTBL: keywords,
or things like "#+BEGIN RECEIVE ORGTBL exsql" in the past year or so.

Do those still work? I can't for the life of me get it to do anything.
I've got a sqlite database called "market.sqlite" in the same directory
as a file containing this:

#+TBLNAME: terms
#+ORGTBL: SEND market.sqlite orgtbl-to-sqlinsert :sqlname "terms"
| Chinese          | English                            |
|------------------+------------------------------------|
| 音像制品出版     | A/V Publishing                     |
| 定价总金额       | Aggregate Retail Price             |
(etc)

I've tried C-c C-c on that header, calling
`org-babel-execute-src-block', waving my fingers at it, and cursing
loudly, one of which usually works. But I get no error, no insertion
into the database, and no results block with INSERT statements (I tried
making a #+BEGIN RECEIVE ORGTBL marketdb.sqlite block as noted on worg).

Does this still work? Or is it still possible to jimmy orgtbl-sqlinsert
to either insert directly, or create a block of INSERT statements?

Thanks!

Footnotes:

[fn:1] http://orgmode.org/worg/org-tutorials/multitarget-tables.html

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

end of thread, other threads:[~2013-09-25  4:14 UTC | newest]

Thread overview: 9+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2013-05-26  6:56 using orgtbl-sqlinsert Eric Abrahamsen
2013-06-02  5:25 ` Eric Abrahamsen
2013-06-05  3:58   ` [PATCH] " Eric Abrahamsen
2013-06-30 21:50     ` Bastien
2013-09-24 22:00 ` Carsten Dominik
2013-09-25  0:31   ` Jason Riedy
2013-09-25  4:13     ` Carsten Dominik
2013-09-25  2:29   ` Eric Abrahamsen
  -- strict thread matches above, loose matches on Subject: below --
2013-05-26  6:56 Eric Abrahamsen

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

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