From mboxrd@z Thu Jan 1 00:00:00 1970 From: Ruslan Kosolapov Subject: agenda csv export: three problems (batch, koi8-r and commas) Date: Thu, 31 May 2007 16:23:33 +0700 Message-ID: <87y7j51h4a.fsf@kosolapov-nb.plesk.ru> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1Htgsj-0000hq-2r for emacs-orgmode@gnu.org; Thu, 31 May 2007 05:23:45 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1Htgsh-0000hV-Qz for emacs-orgmode@gnu.org; Thu, 31 May 2007 05:23:44 -0400 Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Htgsh-0000hO-Hx for emacs-orgmode@gnu.org; Thu, 31 May 2007 05:23:43 -0400 Received: from gw-swsoft2.ll-nsk.zsttk.ru ([82.200.65.190] helo=mail3.plesk.ru) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1Htgsf-0001XJ-Ku for emacs-orgmode@gnu.org; Thu, 31 May 2007 05:23:42 -0400 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org --=-=-= org-mode 4.75, emacs-snapshot (latest from debian sid) --[ 1. Problems with -batch ]-- Command $ emacs -batch -l ~/.emacs -eval '(org-batch-agenda-csv "t")' fails with Debugger entered--Lisp error: (void-function org-batch-agenda-csv) (org-batch-agenda-csv "t") eval((org-batch-agenda-csv "t")) command-line-1(("-l" "/home/rk/.emacs" "-eval" "(org-batch-agenda-csv \"t\")")) command-line() normal-top-level() It's look like problem with autoload (unfortunatelly I dont know how emacs works, so, maybe I wrong). Command $ emacs -batch -l ~/.emacs -eval '(load-library "org") (org-batch-agenda-csv "t")' returns nothing useful. And I don't know why :) Only command emacs -batch -l ~/.emacs -eval '(my-make-csv)' returns agenda in csv format. Maybe fix of this issue is a documentation fix - maybe I do something wrong :) --[ 2. Problems with koi8-r ]-- I use koi8-r for my org-file, its works well in most cases. But in csv I got junk instead koi8-r symbols. As far as I understand, html export works the same way, and in html I see html-entities instead koi8-r. In browser its look good, but not in terminal and perl. I tried to use utf-8, and fail too. Of course, I execute emacs in the same locale as my org-file. This issue is critical for me. --[ 3. Problems with , and "" ]-- As far as I know, strings in csv should be quoted, else there will be problems if string contains comma. Now I see than "head" field placed in csv without quotes. So, if I use comma in heading text, csv-parsing script fails. It is not problem for me because I do not use comma in heading text, but this is a bug. At other side, using types and quotation in csv output mean more complex parser for it. So, maybe better do not fix it by quotation adding. In MS Excel I can specify delimiter symbol for csv export, sometimes it very useful. I attach patch which implements this feature in org-mode. Changeable delimiter can be used as fix of "comma in heading" issue. Patch (oh, no, it's so small :( ;) ): --=-=-= Content-Type: application/octet-stream Content-Disposition: attachment; filename=org-mode-patch-for-csv-delimiter Content-Transfer-Encoding: base64 LS0tIG9yZy5lbC5vcmlnCTIwMDctMDUtMzEgMTU6NTE6MzIuMDAwMDAwMDAwICswNzAwCisrKyBv cmcuZWwJMjAwNy0wNS0zMSAxNjowNzozMi4wMDAwMDAwMDAgKzA3MDAKQEAgLTE4MTMsNiArMTgx MywxMSBAQAogICA6Z3JvdXAgJ29yZy1leHBvcnQtaHRtbAogICA6dHlwZSAnc3RyaW5nKQogCiso ZGVmY3VzdG9tIG9yZy1hZ2VuZGEtY3N2LWRlbGltaXRlciAiLCIKKyAgIkRlbGltaXRlciBmb3Ig ZmllbGRzIGluIGNzdiBleHBvcnQgb2YgYWdlbmRhLiIKKyAgOmdyb3VwICdvcmctYWdlbmRhLWV4 cG9ydAorICA6dHlwZSAnc3RyaW5nKQorCiAoZGVmZ3JvdXAgb3JnLWFnZW5kYS1jdXN0b20tY29t bWFuZHMgbmlsCiAgIk9wdGlvbnMgY29uY2VybmluZyBhZ2VuZGEgdmlld3MgaW4gT3JnLW1vZGUu IgogIDp0YWcgIk9yZyBBZ2VuZGEgQ3VzdG9tIENvbW1hbmRzIgpAQCAtMTQ0OTEsNyArMTQ0OTYs NyBAQAogCSAgIChtYXBjb25jYXQgJ29yZy1hZ2VuZGEtZXhwb3J0LWNzdi1tYXBwZXIKIAkJICAg ICAgJyhvcmctY2F0ZWdvcnkgdHh0IHR5cGUgdG9kbyB0YWdzIGRhdGUgdGltZS1vZi1kYXkgZXh0 cmEKIAkJCQkgICAgIHByaW9yaXR5LWxldHRlciBwcmlvcml0eSkKLQkJICAgICAgIiwiKSkKKwkJ ICAgICAgb3JnLWFnZW5kYS1jc3YtZGVsaW1pdGVyKSkKIAkgIChwcmluYyAiXG4iKSkpKSkpCiAK IChkZWZ1biBvcmctZml4LWFnZW5kYS1pbmZvIChwcm9wcykK --=-=-= Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: quoted-printable --[ Additional info ]-- .emacs: (setq my-work-agenda-dir "/home/rk/work/doc/tasks/") (add-to-list 'auto-mode-alist '("\\.org$" . org-mode)) (defun maf (filename) (concat my-work-agenda-dir filename)) (defun gtd () (interactive) (find-file (maf "work.org")) ) (defun my-make-csv () (gtd) (org-batch-agenda-csv "t")) (setq org-agenda-files (list (maf "work.org"))) org-file (with koi8-r symbols, I hope mail does not corrupt them :) ): #+STARTUP: lognotestate #+STARTUP: showall #+TAGS: { rk(r) sveta(s) kir(k) zalomlenkov(z) ilnar(i) sgunkin(g) const(= c) max(m) ikryak(v) } ATT MS #+SEQ_TODO: NEW NEXT RESCHEDULED | DONE CANCELED #+SEQ_TODO: WAITING SOMEDAY | CANCELED #+SEQ_TODO: FREEZED | CANCELED #+LINK: wiki http://trac.qa.plesk.ru:8080/wiki/ #+TITLE: QAA Tasks #+AUTHOR: rk #+EMAIL: rk@plesk.ru #+LANGUAGE: ru #+OPTIONS: H:4 num:t toc:t \n:nil @:t ::t |:t ^:t *:t TeX:t LaTeX:nil s= kip:t #+CATEGORY: Incoming * Incoming #+CATEGORY: WorkFlow * WorkFlow ** NEW Changelog =C4=CC=D1 =D0=D2=CF=C4=D5=CB=D4=CF=D7 via RSS :rk:kir: #+CATEGORY: General * General ** NEXT =D2=C1=DA=CF=C2=D2=C1=D4=D8=D3=D1 =D3 backup failed =CE=C1 psaqa = :rk: ** NEW =D3=C4=C5=CC=C1=D4=D8 =CE=CF=D2=CD=C1=CC=D8=CE=D9=CD =D2=C5=D0=CF=DA= =C9=D4=CF=D2=C9=CA =C6=C1=CA=CC=CF=D7 =C4=CC=D1 AD ** NEW =D0=D2=CF=C2=CC=C5=CD=C1 =D3 =C9=CD=C5=CE=C1=CD=C9 preconditions = :rk: --=20 Ruslan Kosolapov Plesk QA Department Second Manager SWsoft, Inc. --=-=-= Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Emacs-orgmode mailing list Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode --=-=-=--