From mboxrd@z Thu Jan  1 00:00:00 1970
From: Jambunathan K <kjambunathan@gmail.com>
Subject: Re: Use babel to import table data from OpenDocument spreadsheets?
Date: Tue, 02 Jul 2013 20:40:40 +0530
Message-ID: <87y59p80b3.fsf@gmail.com>
References: <87k3l9kq78.wl%jamshark70@dewdrop-world.net>
	<878v1pvybk.fsf@gmail.com>
	<87y59p591f.wl%jamshark70@dewdrop-world.net>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:48556)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <kjambunathan@gmail.com>) id 1Uu2Cc-0002pa-QT
	for emacs-orgmode@gnu.org; Tue, 02 Jul 2013 11:09:12 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <kjambunathan@gmail.com>) id 1Uu2CW-0005Sc-IZ
	for emacs-orgmode@gnu.org; Tue, 02 Jul 2013 11:09:10 -0400
Received: from mail-pb0-x233.google.com ([2607:f8b0:400e:c01::233]:65434)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <kjambunathan@gmail.com>) id 1Uu2CW-0005SJ-9p
	for emacs-orgmode@gnu.org; Tue, 02 Jul 2013 11:09:04 -0400
Received: by mail-pb0-f51.google.com with SMTP id um15so6275278pbc.10
	for <emacs-orgmode@gnu.org>; Tue, 02 Jul 2013 08:09:03 -0700 (PDT)
In-Reply-To: <87y59p591f.wl%jamshark70@dewdrop-world.net> (James Harkins's
	message of "Tue, 02 Jul 2013 22:30:20 +0800")
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: James Harkins <jamshark70@gmail.com>
Cc: orgmode <emacs-orgmode@gnu.org>

James Harkins <jamshark70@gmail.com> writes:

> At Tue, 02 Jul 2013 19:49:43 +0530,
> Jambunathan K wrote:
>> M-x org-odt-convert RET
>> 
>> or
>> 
>> (org-odt-convert ......)
>
> Is this valid for .ods, or only .odt? The file is from LibreOffice Calc, not Writer.
>
> I made a quick test and got only "failed." From the Messages, I can
> see it's using a headless soffice, so maybe it needs some other
> command line parameters. That will have to wait for another
> day... busy with other things now.
>
> Debug (ox-odt): Searching for OpenDocument styles files...
> Debug (ox-odt): Trying /usr/share/emacs/etc/org/styles/...
> Debug (ox-odt): Using styles under /usr/share/emacs/etc/org/styles/
> Debug (ox-odt): Searching for OpenDocument schema files...
> Debug (ox-odt): Trying /usr/share/emacs/etc/org/schema/...
> Debug (ox-odt): Using schema files under /usr/share/emacs/etc/org/schema/
> Making completion list...
> Executing soffice --headless --convert-to csv --outdir
> /home/dlm/Documents/xinghai/12-13-spring/
> /home/dlm/Documents/xinghai/12-13-spring/gradesheet.ods
>
> Export to /home/dlm/Documents/xinghai/12-13-spring/gradesheet.csv failed

Works here for simple files.

        M-: (org-odt-convert "file.ods" "csv")

Executing libreoffice4.0 --headless --convert-to csv --outdir /home/kjambunathan/ /home/kjambunathan/file.ods
convert /home/kjambunathan/file.ods -> /home/kjambunathan//file.csv using Text - txt - csv (StarCalc)

Exported to /home/kjambunathan/file.csv
"/home/kjambunathan/file.csv"

AFAIK, if you can save as CSV from LO UI, then it should work from the
command line.  

Start with a simple file and isolate the issue.

> hjh