Generating Stream from XLS files

Post Reply
camorani
Posts: 1
Joined: Thu Jun 29, 2017 9:55 pm

Generating Stream from XLS files

Post by camorani » Thu Jun 29, 2017 10:05 pm

Hi, I am beginner with Odysseus.
I have read the excel file using the following code :

Code: Select all

#PARSER CQL
#RUNQUERY
CREATE STREAM xls:person (id Double, age Double)
WRAPPER 'GenericPull'
PROTOCOL 'XLS'
TRANSPORT 'File'
DATAHANDLER 'Tuple'
OPTIONS ('filename' '//transnas.engr.utk.edu/asad/Ramin/CAV/oddysseus/test.xls')
and the file is being shown in the source as System.xls:person.
But when i use this code as a query:

Code: Select all

#PARSER PQL
#RUNQUERY
out = xls:person
I get this error

'Parsing and Executing Query' has encountered a problem.

Script Execution Error: null
java.lang.NullPointerException

Even I am not sure if this is the correct way of generating streams from Excel files.

Thanks!

User avatar
Marco Grawunder
Posts: 270
Joined: Tue Jul 29, 2014 10:29 am
Location: Oldenburg, Germany
Contact:

Re: Generating Stream from XLS files

Post by Marco Grawunder » Fri Jun 30, 2017 9:36 am

Hi Camorani,

welcome to Odysseus.

You did nearly everything right. You need to install the xls feature to read from this kind of sources.

I added a note to the documentation of the xls wrapper.

Greetings,

Marco

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest