nathan.courtial | 23 May 2013 11:23
Picon
Favicon

Error on Versioning API on eXist-db 1.4.2

Hi,
On eXist-db 1.4.2, when trying to re-build a document when its revision, I get the following error.
2013-05-23 11:01:18,768 [http-8002-2] WARN  (CatchFunction.java [eval]:93) - Exception: Error
XQDY0025: element has more than one attribute 'AMOUNT' 
org.w3c.dom.DOMException: Error XQDY0025: element has more than one attribute 'AMOUNT'
	at org.exist.memtree.DocumentImpl.addAttribute(DocumentImpl.java:300)
	at org.exist.memtree.MemTreeBuilder.addAttribute(MemTreeBuilder.java:211)
	at org.exist.memtree.DocumentBuilderReceiver.startElement(DocumentBuilderReceiver.java:143)
	at org.exist.versioning.Patch.copyNode(Patch.java:301)
	at org.exist.versioning.Patch.patch(Patch.java:134)
	at org.exist.versioning.xquery.PatchFunction.eval(PatchFunction.java:106)
	at org.exist.xquery.BasicFunction.eval(BasicFunction.java:68)
	at org.exist.xquery.InternalFunctionCall.eval(InternalFunctionCall.java:55)
	at org.exist.xquery.AbstractExpression.eval(AbstractExpression.java:61)
	at org.exist.xquery.PathExpr.eval(PathExpr.java:241)
	at org.exist.xquery.DynamicCardinalityCheck.eval(DynamicCardinalityCheck.java:71)
	at org.exist.xquery.DynamicTypeCheck.eval(DynamicTypeCheck.java:61)
	at org.exist.xquery.FunctionCall.eval(FunctionCall.java:185)
	at org.exist.xquery.AbstractExpression.eval(AbstractExpression.java:61)
	at org.exist.xquery.PathExpr.eval(PathExpr.java:241)
	at org.exist.xquery.LetExpr.eval(LetExpr.java:155)
	at org.exist.xquery.BindingExpression.eval(BindingExpression.java:158)
	at org.exist.xquery.AbstractExpression.eval(AbstractExpression.java:61)
	at org.exist.xquery.PathExpr.eval(PathExpr.java:241)
	at org.exist.xquery.DebuggableExpression.eval(DebuggableExpression.java:56)
	at org.exist.xquery.ConditionalExpression.eval(ConditionalExpression.java:102)
	at org.exist.xquery.AbstractExpression.eval(AbstractExpression.java:61)
	at org.exist.xquery.PathExpr.eval(PathExpr.java:241)
	at org.exist.xquery.UserDefinedFunction.eval(UserDefinedFunction.java:137)
	at org.exist.xquery.DynamicTypeCheck.eval(DynamicTypeCheck.java:61)
(Continue reading)

peter winstanley | 23 May 2013 00:39
Favicon

What is best practice for file locking

Hello List

What is the best practice for file locking when building eXist powered web apps that include scope for
editing?  Are there any examples?

Cheers

Peter

____________________________________________________________
GET FREE SMILEYS FOR YOUR IM & EMAIL - Learn more at http://www.inbox.com/smileys
Works with AIM®, MSN® Messenger, Yahoo!® Messenger, ICQ®, Google Talk™ and most webmails

------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
_______________________________________________
Exist-open mailing list
Exist-open <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/exist-open
nathan.courtial | 22 May 2013 14:24
Picon
Favicon

Backup restore loop on eXist-db 1.4.2

Hi eXist-db team,
It seems to be a problem when restoring a database backup on a eXist-db 1.4.2
I try to restore the database with a lot of versioning collections.
"db/system/versions" collections are restored first and seem to be re-restored another time during the process.
During the second time, dbx files aren't updated like if db konws that files are already existing into database.

Do you know more about this behaviour?
Many thanks in advance.

Cheers,
Nathan

------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
christophe geiser | 22 May 2013 12:45

resxt POST and %rest:query-param

Hi all,
I just wanted to check if this is the intended behavior :
it seems that it is not possible to use %rest:query-param for POST resource function (you don't actually get an error, but the annotation is not processed)
for example : 

calling 
declare 
    %rest:POST("{$data}") 
    %rest:path("/test")
    %rest:query-param("version","{$version}", "_") 
function test:test($data, $version) {
  <version>{$version}</version>
};

with 
httpclient:post("http://localhost:8088/restxq/test?version=1", <empty/>, false(), ())

will return 
<version>_</version>

I know it sounds a bit strange to use query-param with POST (http://www.w3.org/TR/html4/interact/forms.html#submit-format), but it might be usefull in some cases. 

Cheers,
C.

--
ɹǝsıǝƃ ǝɥdoʇsıɹɥɔ
e-Smile, solutions in monitoring and information management
--
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
_______________________________________________
Exist-open mailing list
Exist-open <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/exist-open
Dannes Wessels | 21 May 2013 22:21

eXist-db as Windows Service (64bit)

All,

Last week I have added a few missing files to support running eXist-db as a service on 64 bit Windows
machines, see http://sourceforge.net/p/exist/code/18420/ 

Files:
http://sourceforge.net/p/exist/code/18420/tree//trunk/eXist/tools/wrapper/lib/wrapper-windows-x86-64.dll
http://sourceforge.net/p/exist/code/18420/tree//trunk/eXist/tools/wrapper/bin/wrapper-windows-x86-64.exe

Additionally I have updated the instructions how to install eXist-db as a service on Mac OS X and a few linux
distributions on http://www.exist-db.org/exist/apps/doc/advanced-installation.xml#service

Regards

Dannes

--
eXist-db Native XML Database
http://www.exist-db.org

------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
Roy Walter | 21 May 2013 12:38
Picon
Favicon

HTML output error


Hi All,

Any idea why eXist inserts an unwanted underline between images that are wrapped in hyperlinks?

Example here: http://brookpub.net:8080/exist/rest/db/sandbox/test.xql

Or try for yourself (images are not required to see the problem):
xquery version "1.0";  
declare option exist:serialize "method=html media-type=text/html";
(<p>
<a href="#">First</a>
<a href="#">Second</a>
</p>,
<p>
<a href="#"><img src="email_add.png"/></a>
<a href="#"><img src="group_add.png"/></a>
</p>)
Thanks,
Roy
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
_______________________________________________
Exist-open mailing list
Exist-open <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/exist-open
Chris Tomlinson | 21 May 2013 01:54

how to migrate from one 2.x version to another?

Hello,

We have a production application running on rev 17792 from Dec 2012 and are wanting to update to the current trunk.

In the past migration was a simple matter of taking a full backup from the current system and using that to
restore to the new eXist system.

The question is what happens now with the /db/apps? When we do a full backup the /db/apps is dumped and when a
restore is done then it seems like old /db/apps will overwrite the new up-to-date /db/apps.

What is the best way to migrate so that the /db/apps isn't mangled?

Thanks,
Chris

------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
claudius.teodorescu | 20 May 2013 21:11
Picon
Gravatar

Re: Exist-open Digest, Vol 85, Issue 41

For instance, jexcelapi [1], is LGPL and seems mature.

Claudius

Sent from my iPhone

On May 20, 2013, at 19:38, exist-open-request <at> lists.sourceforge.net  
wrote:

> Send Exist-open mailing list submissions to
>    exist-open <at> lists.sourceforge.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
>    https://lists.sourceforge.net/lists/listinfo/exist-open
> or, via email, send a message with subject or body 'help' to
>    exist-open-request <at> lists.sourceforge.net
>
> You can reach the person managing the list at
>    exist-open-owner <at> lists.sourceforge.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Exist-open digest..."
>
>
> Today's Topics:
>
>   1. Convert MS Excel to XML (Casey Jordan)
>   2. Re: Convert MS Excel to XML (Casey Jordan)
>   3. Re: Convert MS Excel to XML (Dmitriy Shabanov)
>   4. Re: Convert MS Excel to XML (Jochen Graf)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 20 May 2013 11:30:37 -0400
> From: Casey Jordan <casey.jordan <at> jorsek.com>
> Subject: [Exist-open] Convert MS Excel to XML
> To: "exist-open <at> lists.sourceforge.net ml"
>    <exist-open <at> lists.sourceforge.net>
> Message-ID:
>     
> <CAPAQPqc6fY=XgP4XaMLFKSJDTEOTzLrMXOiUG7YXgPQE5LektA <at> mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> I seem to remember a long time ago someone mentioning that eXist had  
> the
> ability to extract XML from MS Office formats like Excel. I am  
> essentially
> looking to convert an Excel file into an HTML table using an automated
> process.
>
> Thanks,
>
> Casey
>
> -- 
> --
> Casey Jordan
> easyDITA a product of Jorsek LLC
> "CaseyDJordan" on LinkedIn, Twitter & Facebook
> (585) 348 7399
> easydita.com
>
>
> This message is intended only for the use of the Addressee(s) and may
> contain information that is privileged, confidential, and/or exempt  
> from
> disclosure under applicable law.  If you are not the intended  
> recipient,
> please be advised that any disclosure  copying, distribution, or use  
> of
> the information contained herein is prohibited.  If you have received
> this communication in error, please destroy all copies of the message,
> whether in electronic or hard copy format, as well as attachments, and
> immediately contact the sender by replying to this e-mail or by phone.
> Thank you.
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 2
> Date: Mon, 20 May 2013 12:13:30 -0400
> From: Casey Jordan <casey.jordan <at> jorsek.com>
> Subject: Re: [Exist-open] Convert MS Excel to XML
> To: Dannes Wessels <dannes <at> exist-db.org>,
>    "exist-open <at> lists.sourceforge.net ml"
>    <exist-open <at> lists.sourceforge.net>
> Message-ID:
>     
> <CAPAQPqdz=2vnLdJB=XeWzP3x_XuRGTJiO2T1AZQVktudw6Kq6g <at> mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> I found something to do it via Tika and ANT:
> http://en.wikibooks.org/wiki/Apache_Ant/Converting_Excel_to_XML
>
> I also read through the content extraction blog article for eXist-db:
> http://atomic.exist-db.org/blogs/eXist/ContentExtraction
>
> but I am not sure how Tika has been implemented in eXist and how to
> accomplish the same thing as above. Ideally I would want to do  
> exactly what
> the above wiki-book does.
>
> How does contentextraction:stream-content() map to the underlying Tika
> processor? How do I know what node sequence is going to be passed?  
> Is there
> a schema somewhere?
>
> I could sift through the java code for the content extraction module  
> but
> I'd rather keep that as a last resort.
>
> Any pointers or more documentation?
>
> Thanks,
>
> Casey
>
>
> On Mon, May 20, 2013 at 12:03 PM, Dannes Wessels <dannes <at> exist- 
> db.org>wrote:
>
>> Did you check with Apache Tika?
>>
>> --
>> Dannes Wessels
>> Sent with Sparrow <http://www.sparrowmailapp.com/?sig>
>>
>> On Monday 20 May 2013 at 17:30, Casey Jordan wrote:
>>
>> I seem to remember a long time ago someone mentioning that eXist  
>> had the
>> ability to extract XML from MS Office formats like Excel. I am  
>> essentially
>> looking to convert an Excel file into an HTML table using an  
>> automated
>> process.
>>
>> Thanks,
>>
>> Casey
>>
>> --
>> --
>> Casey Jordan
>> easyDITA a product of Jorsek LLC
>> "CaseyDJordan" on LinkedIn, Twitter & Facebook
>> (585) 348 7399
>> easydita.com
>>
>>
>> This message is intended only for the use of the Addressee(s) and may
>> contain information that is privileged, confidential, and/or exempt  
>> from
>> disclosure under applicable law.  If you are not the intended  
>> recipient,
>> please be advised that any disclosure  copying, distribution, or  
>> use of
>> the information contained herein is prohibited.  If you have received
>> this communication in error, please destroy all copies of the  
>> message,
>> whether in electronic or hard copy format, as well as attachments,  
>> and
>> immediately contact the sender by replying to this e-mail or by  
>> phone.
>> Thank you.
>>
>> --- 
>> --- 
>> --- 
>> ---------------------------------------------------------------------
>> AlienVault Unified Security Management (USM) platform delivers  
>> complete
>> security visibility with the essential security capabilities.  
>> Easily and
>> efficiently configure, manage, and operate all of your security  
>> controls
>> from a single console and one unified framework. Download a free  
>> trial.
>> http://p.sf.net/sfu/alienvault_d2d
>> _______________________________________________
>> Exist-open mailing list
>> Exist-open <at> lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/exist-open
>>
>>
>>
>
>
> -- 
> --
> Casey Jordan
> easyDITA a product of Jorsek LLC
> "CaseyDJordan" on LinkedIn, Twitter & Facebook
> (585) 348 7399
> easydita.com
>
>
> This message is intended only for the use of the Addressee(s) and may
> contain information that is privileged, confidential, and/or exempt  
> from
> disclosure under applicable law.  If you are not the intended  
> recipient,
> please be advised that any disclosure  copying, distribution, or use  
> of
> the information contained herein is prohibited.  If you have received
> this communication in error, please destroy all copies of the message,
> whether in electronic or hard copy format, as well as attachments, and
> immediately contact the sender by replying to this e-mail or by phone.
> Thank you.
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 3
> Date: Mon, 20 May 2013 21:24:16 +0500
> From: Dmitriy Shabanov <shabanovd <at> gmail.com>
> Subject: Re: [Exist-open] Convert MS Excel to XML
> To: Casey Jordan <casey.jordan <at> jorsek.com>
> Cc: "exist-open <at> lists.sourceforge.net ml"
>    <exist-open <at> lists.sourceforge.net>,    Dannes Wessels
>    <dannes <at> exist-db.org>
> Message-ID:
>     
> <CADD4p=7Ms2tjS_J8728k8H4a3FU=O9XfpyTeyg1LB1YTY5XsYw <at> mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Should be simple, parameter for function is same as
> input="${input-file}"and output is result.
>
> On Mon, May 20, 2013 at 9:13 PM, Casey Jordan  
> <casey.jordan <at> jorsek.com>wrote:
>
>> I found something to do it via Tika and ANT:
>> http://en.wikibooks.org/wiki/Apache_Ant/Converting_Excel_to_XML
>>
>> I also read through the content extraction blog article for eXist-db:
>> http://atomic.exist-db.org/blogs/eXist/ContentExtraction
>>
>> but I am not sure how Tika has been implemented in eXist and how to
>> accomplish the same thing as above. Ideally I would want to do  
>> exactly what
>> the above wiki-book does.
>>
>> How does contentextraction:stream-content() map to the underlying  
>> Tika
>> processor? How do I know what node sequence is going to be passed?  
>> Is there
>> a schema somewhere?
>>
>> I could sift through the java code for the content extraction  
>> module but
>> I'd rather keep that as a last resort.
>>
>> Any pointers or more documentation?
>>
>
> -- 
> Dmitriy Shabanov
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 4
> Date: Mon, 20 May 2013 18:38:12 +0200
> From: Jochen Graf <jochen.graf <at> uni-koeln.de>
> Subject: Re: [Exist-open] Convert MS Excel to XML
> To: exist-open <at> lists.sourceforge.net
> Message-ID: <519A5174.4090404 <at> uni-koeln.de>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi Casey,
>
> we use a small eXist XQuery Module for this. Just
> a few lines of Code:
> https://subversion.rrz.uni-koeln.de/trac/eXist-A/browser/trunk/my/eXist/extensions/modules/src/org/exist/xquery/modules/excel
> (The Code is in line with the new eXist 2.0 release.)
> It only supports *.xls files, no *.xlsx and no *.ods
> yet. You need the latest Apache POI *.jar under
> EXIST_HOME/lib/user to make it work:
> https://subversion.rrz.uni-koeln.de/trac/eXist-A/browser/trunk/my/eXist/lib/user
>
> We use it in production since few years. It works good
> as long as sheet cells contain simple values. The conversion
> sometimes fails if there are outlying formattings or
> functions in a sheet.
>
> Feel free to use it.
> Best
> Jochen
>
>> I seem to remember a long time ago someone mentioning that eXist had
>> the ability to extract XML from MS Office formats like Excel. I am
>> essentially looking to convert an Excel file into an HTML table using
>> an automated process.
>>
>> Thanks,
>>
>> Casey
>>
>> -- 
>> --
>> Casey Jordan
>> easyDITA a product of Jorsek LLC
>> "CaseyDJordan" on LinkedIn, Twitter & Facebook
>> (585) 348 7399
>> easydita.com <http://easydita.com>
>>
>>
>> This message is intended only for the use of the Addressee(s) and may
>> contain information that is privileged, confidential, and/or exempt  
>> from
>> disclosure under applicable law.  If you are not the intended  
>> recipient,
>> please be advised that any disclosure  copying, distribution, or  
>> use of
>> the information contained herein is prohibited.  If you have received
>> this communication in error, please destroy all copies of the  
>> message,
>> whether in electronic or hard copy format, as well as attachments,  
>> and
>> immediately contact the sender by replying to this e-mail or by  
>> phone.
>> Thank you.
>>
>>
>> --- 
>> --- 
>> --- 
>> ---------------------------------------------------------------------
>> AlienVault Unified Security Management (USM) platform delivers  
>> complete
>> security visibility with the essential security capabilities.  
>> Easily and
>> efficiently configure, manage, and operate all of your security  
>> controls
>> from a single console and one unified framework. Download a free  
>> trial.
>> http://p.sf.net/sfu/alienvault_d2d
>>
>>
>> _______________________________________________
>> Exist-open mailing list
>> Exist-open <at> lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/exist-open
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> --- 
> --- 
> --- 
> ---------------------------------------------------------------------
> AlienVault Unified Security Management (USM) platform delivers  
> complete
> security visibility with the essential security capabilities. Easily  
> and
> efficiently configure, manage, and operate all of your security  
> controls
> from a single console and one unified framework. Download a free  
> trial.
> http://p.sf.net/sfu/alienvault_d2d
>
> ------------------------------
>
> _______________________________________________
> Exist-open mailing list
> Exist-open <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/exist-open
>
>
> End of Exist-open Digest, Vol 85, Issue 41
> ******************************************

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
claudius.teodorescu | 20 May 2013 20:40
Picon
Gravatar

Re: Exist-open Digest, Vol 85, Issue 41

Hi,

If we do have some nice java lgpl library for such conversion, I can  
add it to the EXPath module for digital publishing I am developing.

Clauxius

Sent from my iPhone

On May 20, 2013, at 19:38, exist-open-request <at> lists.sourceforge.net  
wrote:

> Send Exist-open mailing list submissions to
>    exist-open <at> lists.sourceforge.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
>    https://lists.sourceforge.net/lists/listinfo/exist-open
> or, via email, send a message with subject or body 'help' to
>    exist-open-request <at> lists.sourceforge.net
>
> You can reach the person managing the list at
>    exist-open-owner <at> lists.sourceforge.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Exist-open digest..."
>
>
> Today's Topics:
>
>   1. Convert MS Excel to XML (Casey Jordan)
>   2. Re: Convert MS Excel to XML (Casey Jordan)
>   3. Re: Convert MS Excel to XML (Dmitriy Shabanov)
>   4. Re: Convert MS Excel to XML (Jochen Graf)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 20 May 2013 11:30:37 -0400
> From: Casey Jordan <casey.jordan <at> jorsek.com>
> Subject: [Exist-open] Convert MS Excel to XML
> To: "exist-open <at> lists.sourceforge.net ml"
>    <exist-open <at> lists.sourceforge.net>
> Message-ID:
>     
> <CAPAQPqc6fY=XgP4XaMLFKSJDTEOTzLrMXOiUG7YXgPQE5LektA <at> mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> I seem to remember a long time ago someone mentioning that eXist had  
> the
> ability to extract XML from MS Office formats like Excel. I am  
> essentially
> looking to convert an Excel file into an HTML table using an automated
> process.
>
> Thanks,
>
> Casey
>
> -- 
> --
> Casey Jordan
> easyDITA a product of Jorsek LLC
> "CaseyDJordan" on LinkedIn, Twitter & Facebook
> (585) 348 7399
> easydita.com
>
>
> This message is intended only for the use of the Addressee(s) and may
> contain information that is privileged, confidential, and/or exempt  
> from
> disclosure under applicable law.  If you are not the intended  
> recipient,
> please be advised that any disclosure  copying, distribution, or use  
> of
> the information contained herein is prohibited.  If you have received
> this communication in error, please destroy all copies of the message,
> whether in electronic or hard copy format, as well as attachments, and
> immediately contact the sender by replying to this e-mail or by phone.
> Thank you.
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 2
> Date: Mon, 20 May 2013 12:13:30 -0400
> From: Casey Jordan <casey.jordan <at> jorsek.com>
> Subject: Re: [Exist-open] Convert MS Excel to XML
> To: Dannes Wessels <dannes <at> exist-db.org>,
>    "exist-open <at> lists.sourceforge.net ml"
>    <exist-open <at> lists.sourceforge.net>
> Message-ID:
>     
> <CAPAQPqdz=2vnLdJB=XeWzP3x_XuRGTJiO2T1AZQVktudw6Kq6g <at> mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> I found something to do it via Tika and ANT:
> http://en.wikibooks.org/wiki/Apache_Ant/Converting_Excel_to_XML
>
> I also read through the content extraction blog article for eXist-db:
> http://atomic.exist-db.org/blogs/eXist/ContentExtraction
>
> but I am not sure how Tika has been implemented in eXist and how to
> accomplish the same thing as above. Ideally I would want to do  
> exactly what
> the above wiki-book does.
>
> How does contentextraction:stream-content() map to the underlying Tika
> processor? How do I know what node sequence is going to be passed?  
> Is there
> a schema somewhere?
>
> I could sift through the java code for the content extraction module  
> but
> I'd rather keep that as a last resort.
>
> Any pointers or more documentation?
>
> Thanks,
>
> Casey
>
>
> On Mon, May 20, 2013 at 12:03 PM, Dannes Wessels <dannes <at> exist- 
> db.org>wrote:
>
>> Did you check with Apache Tika?
>>
>> --
>> Dannes Wessels
>> Sent with Sparrow <http://www.sparrowmailapp.com/?sig>
>>
>> On Monday 20 May 2013 at 17:30, Casey Jordan wrote:
>>
>> I seem to remember a long time ago someone mentioning that eXist  
>> had the
>> ability to extract XML from MS Office formats like Excel. I am  
>> essentially
>> looking to convert an Excel file into an HTML table using an  
>> automated
>> process.
>>
>> Thanks,
>>
>> Casey
>>
>> --
>> --
>> Casey Jordan
>> easyDITA a product of Jorsek LLC
>> "CaseyDJordan" on LinkedIn, Twitter & Facebook
>> (585) 348 7399
>> easydita.com
>>
>>
>> This message is intended only for the use of the Addressee(s) and may
>> contain information that is privileged, confidential, and/or exempt  
>> from
>> disclosure under applicable law.  If you are not the intended  
>> recipient,
>> please be advised that any disclosure  copying, distribution, or  
>> use of
>> the information contained herein is prohibited.  If you have received
>> this communication in error, please destroy all copies of the  
>> message,
>> whether in electronic or hard copy format, as well as attachments,  
>> and
>> immediately contact the sender by replying to this e-mail or by  
>> phone.
>> Thank you.
>>
>> --- 
>> --- 
>> --- 
>> ---------------------------------------------------------------------
>> AlienVault Unified Security Management (USM) platform delivers  
>> complete
>> security visibility with the essential security capabilities.  
>> Easily and
>> efficiently configure, manage, and operate all of your security  
>> controls
>> from a single console and one unified framework. Download a free  
>> trial.
>> http://p.sf.net/sfu/alienvault_d2d
>> _______________________________________________
>> Exist-open mailing list
>> Exist-open <at> lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/exist-open
>>
>>
>>
>
>
> -- 
> --
> Casey Jordan
> easyDITA a product of Jorsek LLC
> "CaseyDJordan" on LinkedIn, Twitter & Facebook
> (585) 348 7399
> easydita.com
>
>
> This message is intended only for the use of the Addressee(s) and may
> contain information that is privileged, confidential, and/or exempt  
> from
> disclosure under applicable law.  If you are not the intended  
> recipient,
> please be advised that any disclosure  copying, distribution, or use  
> of
> the information contained herein is prohibited.  If you have received
> this communication in error, please destroy all copies of the message,
> whether in electronic or hard copy format, as well as attachments, and
> immediately contact the sender by replying to this e-mail or by phone.
> Thank you.
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 3
> Date: Mon, 20 May 2013 21:24:16 +0500
> From: Dmitriy Shabanov <shabanovd <at> gmail.com>
> Subject: Re: [Exist-open] Convert MS Excel to XML
> To: Casey Jordan <casey.jordan <at> jorsek.com>
> Cc: "exist-open <at> lists.sourceforge.net ml"
>    <exist-open <at> lists.sourceforge.net>,    Dannes Wessels
>    <dannes <at> exist-db.org>
> Message-ID:
>     
> <CADD4p=7Ms2tjS_J8728k8H4a3FU=O9XfpyTeyg1LB1YTY5XsYw <at> mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Should be simple, parameter for function is same as
> input="${input-file}"and output is result.
>
> On Mon, May 20, 2013 at 9:13 PM, Casey Jordan  
> <casey.jordan <at> jorsek.com>wrote:
>
>> I found something to do it via Tika and ANT:
>> http://en.wikibooks.org/wiki/Apache_Ant/Converting_Excel_to_XML
>>
>> I also read through the content extraction blog article for eXist-db:
>> http://atomic.exist-db.org/blogs/eXist/ContentExtraction
>>
>> but I am not sure how Tika has been implemented in eXist and how to
>> accomplish the same thing as above. Ideally I would want to do  
>> exactly what
>> the above wiki-book does.
>>
>> How does contentextraction:stream-content() map to the underlying  
>> Tika
>> processor? How do I know what node sequence is going to be passed?  
>> Is there
>> a schema somewhere?
>>
>> I could sift through the java code for the content extraction  
>> module but
>> I'd rather keep that as a last resort.
>>
>> Any pointers or more documentation?
>>
>
> -- 
> Dmitriy Shabanov
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 4
> Date: Mon, 20 May 2013 18:38:12 +0200
> From: Jochen Graf <jochen.graf <at> uni-koeln.de>
> Subject: Re: [Exist-open] Convert MS Excel to XML
> To: exist-open <at> lists.sourceforge.net
> Message-ID: <519A5174.4090404 <at> uni-koeln.de>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi Casey,
>
> we use a small eXist XQuery Module for this. Just
> a few lines of Code:
> https://subversion.rrz.uni-koeln.de/trac/eXist-A/browser/trunk/my/eXist/extensions/modules/src/org/exist/xquery/modules/excel
> (The Code is in line with the new eXist 2.0 release.)
> It only supports *.xls files, no *.xlsx and no *.ods
> yet. You need the latest Apache POI *.jar under
> EXIST_HOME/lib/user to make it work:
> https://subversion.rrz.uni-koeln.de/trac/eXist-A/browser/trunk/my/eXist/lib/user
>
> We use it in production since few years. It works good
> as long as sheet cells contain simple values. The conversion
> sometimes fails if there are outlying formattings or
> functions in a sheet.
>
> Feel free to use it.
> Best
> Jochen
>
>> I seem to remember a long time ago someone mentioning that eXist had
>> the ability to extract XML from MS Office formats like Excel. I am
>> essentially looking to convert an Excel file into an HTML table using
>> an automated process.
>>
>> Thanks,
>>
>> Casey
>>
>> -- 
>> --
>> Casey Jordan
>> easyDITA a product of Jorsek LLC
>> "CaseyDJordan" on LinkedIn, Twitter & Facebook
>> (585) 348 7399
>> easydita.com <http://easydita.com>
>>
>>
>> This message is intended only for the use of the Addressee(s) and may
>> contain information that is privileged, confidential, and/or exempt  
>> from
>> disclosure under applicable law.  If you are not the intended  
>> recipient,
>> please be advised that any disclosure  copying, distribution, or  
>> use of
>> the information contained herein is prohibited.  If you have received
>> this communication in error, please destroy all copies of the  
>> message,
>> whether in electronic or hard copy format, as well as attachments,  
>> and
>> immediately contact the sender by replying to this e-mail or by  
>> phone.
>> Thank you.
>>
>>
>> --- 
>> --- 
>> --- 
>> ---------------------------------------------------------------------
>> AlienVault Unified Security Management (USM) platform delivers  
>> complete
>> security visibility with the essential security capabilities.  
>> Easily and
>> efficiently configure, manage, and operate all of your security  
>> controls
>> from a single console and one unified framework. Download a free  
>> trial.
>> http://p.sf.net/sfu/alienvault_d2d
>>
>>
>> _______________________________________________
>> Exist-open mailing list
>> Exist-open <at> lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/exist-open
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> --- 
> --- 
> --- 
> ---------------------------------------------------------------------
> AlienVault Unified Security Management (USM) platform delivers  
> complete
> security visibility with the essential security capabilities. Easily  
> and
> efficiently configure, manage, and operate all of your security  
> controls
> from a single console and one unified framework. Download a free  
> trial.
> http://p.sf.net/sfu/alienvault_d2d
>
> ------------------------------
>
> _______________________________________________
> Exist-open mailing list
> Exist-open <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/exist-open
>
>
> End of Exist-open Digest, Vol 85, Issue 41
> ******************************************

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
Casey Jordan | 20 May 2013 18:13

Re: Convert MS Excel to XML

I found something to do it via Tika and ANT: http://en.wikibooks.org/wiki/Apache_Ant/Converting_Excel_to_XML

I also read through the content extraction blog article for eXist-db: http://atomic.exist-db.org/blogs/eXist/ContentExtraction

but I am not sure how Tika has been implemented in eXist and how to accomplish the same thing as above. Ideally I would want to do exactly what the above wiki-book does.

How does contentextraction:stream-content() map to the underlying Tika processor? How do I know what node sequence is going to be passed? Is there a schema somewhere?

I could sift through the java code for the content extraction module but I'd rather keep that as a last resort.

Any pointers or more documentation?

Thanks,

Casey


On Mon, May 20, 2013 at 12:03 PM, Dannes Wessels <dannes <at> exist-db.org> wrote:
Did you check with Apache Tika?

-- 
Dannes Wessels
Sent with Sparrow

On Monday 20 May 2013 at 17:30, Casey Jordan wrote:

I seem to remember a long time ago someone mentioning that eXist had the ability to extract XML from MS Office formats like Excel. I am essentially looking to convert an Excel file into an HTML table using an automated process.

Thanks,

Casey

--
--
Casey Jordan
easyDITA a product of Jorsek LLC
"CaseyDJordan" on LinkedIn, Twitter & Facebook
(585) 348 7399
easydita.com


This message is intended only for the use of the Addressee(s) and may
contain information that is privileged, confidential, and/or exempt from
disclosure under applicable law.  If you are not the intended recipient,
please be advised that any disclosure  copying, distribution, or use of
the information contained herein is prohibited.  If you have received
this communication in error, please destroy all copies of the message,
whether in electronic or hard copy format, as well as attachments, and
immediately contact the sender by replying to this e-mail or by phone.
Thank you.
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
_______________________________________________
Exist-open mailing list




--
--
Casey Jordan
easyDITA a product of Jorsek LLC
"CaseyDJordan" on LinkedIn, Twitter & Facebook
(585) 348 7399
easydita.com


This message is intended only for the use of the Addressee(s) and may
contain information that is privileged, confidential, and/or exempt from
disclosure under applicable law.  If you are not the intended recipient,
please be advised that any disclosure  copying, distribution, or use of
the information contained herein is prohibited.  If you have received
this communication in error, please destroy all copies of the message,
whether in electronic or hard copy format, as well as attachments, and
immediately contact the sender by replying to this e-mail or by phone.
Thank you.
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Exist-open mailing list
Exist-open <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/exist-open
Casey Jordan | 20 May 2013 17:30

Convert MS Excel to XML

I seem to remember a long time ago someone mentioning that eXist had the ability to extract XML from MS Office formats like Excel. I am essentially looking to convert an Excel file into an HTML table using an automated process.

Thanks,

Casey

--
--
Casey Jordan
easyDITA a product of Jorsek LLC
"CaseyDJordan" on LinkedIn, Twitter & Facebook
(585) 348 7399
easydita.com


This message is intended only for the use of the Addressee(s) and may
contain information that is privileged, confidential, and/or exempt from
disclosure under applicable law.  If you are not the intended recipient,
please be advised that any disclosure  copying, distribution, or use of
the information contained herein is prohibited.  If you have received
this communication in error, please destroy all copies of the message,
whether in electronic or hard copy format, as well as attachments, and
immediately contact the sender by replying to this e-mail or by phone.
Thank you.
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Exist-open mailing list
Exist-open <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/exist-open

Gmane