READ ODS file

[89trunks]

I was trying to read ODS file using R and Tikka Parser but I got stuck.

Can someone help me ?

The orginal file looks like this:

Processing: CARZZ.ods…

I atached workflow:

KNIME_read_ODS.knwf (71.5 KB)

[mlauber71]

@89trunks you might want to take a look at these examples

Import ODS (Libre Office) calc Sheets – mlauber71

Export ODS (Libre Office) calc Sheets – mlauber71

[89trunks]

I was traying follwing thoses two workflows but without results.
I stucked at second R Snipped - “there is no package hms”

I tried installed it but without success

install.packages(“hms”)
— Please select a CRAN mirror for use in this session —

There are binary versions available but the source versions are later:
binary source needs_compilation
rlang 0.3.4 0.4.12 TRUE
ellipsis 0.1.0 0.3.2 TRUE
vctrs 0.1.0 0.3.8 TRUE
hms 0.4.2 1.1.1 FALSE

Binaries will be installed
package ‘rlang’ successfully unpacked and MD5 sums checked
package ‘ellipsis’ successfully unpacked and MD5 sums checked
package ‘vctrs’ successfully unpacked and MD5 sums checked

The downloaded binary packages are in
C:\Users\Trunks\AppData\Local\Temp\knime-r-tmp94359\Rtmpuqr3Hg\downloaded_packages
also installing the dependencies ‘rlang’, ‘ellipsis’, ‘lifecycle’, ‘vctrs’

trying URL ‘https://cloud.r-project.org/bin/windows/contrib/3.4/rlang_0.3.4.zip’
Content type ‘application/zip’ length 1080437 bytes (1.0 MB)
downloaded 1.0 MB

trying URL ‘https://cloud.r-project.org/bin/windows/contrib/3.4/ellipsis_0.1.0.zip’
Content type ‘application/zip’ length 30847 bytes (30 KB)
downloaded 30 KB

trying URL ‘https://cloud.r-project.org/bin/windows/contrib/3.4/vctrs_0.1.0.zip’
Content type ‘application/zip’ length 499748 bytes (488 KB)
downloaded 488 KB

installing the source packages ‘lifecycle’, ‘hms’

trying URL ‘https://cloud.r-project.org/src/contrib/lifecycle_1.0.1.tar.gz’
Content type ‘application/x-gzip’ length 99716 bytes (97 KB)
downloaded 97 KB

trying URL ‘https://cloud.r-project.org/src/contrib/hms_1.1.1.tar.gz’
Content type ‘application/x-gzip’ length 43117 bytes (42 KB)
downloaded 42 KB

The downloaded source packages are in
‘C:\Users\Trunks\AppData\Local\Temp\knime-r-tmp94359\Rtmpuqr3Hg\downloaded_packages’

[mlauber71]

You might want to install RStudio alongside R and try to install from there instead of from knime. Make sure you have the right path configured in knime.

https://docs.knime.com/latest/r_installation_guide/index.html#_introduction

A meta collection and article about R and KNIME – mlauber71

You also could check your R version and packages

check version of R packages in KNIME – mlauber71

The. The question is which operating system you have.

[89trunks]

#mlauber71

Thanks - installing RStudio alongside R and then installing packages from there - it helps

I was wondering how can it be done using Tika Parser. I mean how can I turn the content cell to columns just as orginal table ?

[89trunks]

@mlauber71 - Thank you

[mlauber71]

@89trunks

I was wondering how can it be done using Tika Parser. I mean how can I turn the content cell to columns just as orginal table ?

@89trunks I was wondering the same thing (just seen mentioning of Tika but never saw a working example though) and tried a few things. You actually get the data out from the ODS file but they are all in one column. I was initially able to transpose and convert a small example but a larger example failed and it also failed to preserve date and time fields.

I expanded my initial example to also export to several formats from R directly that would be better suited to preserve data and time formats:

[89trunks]

@mlauber71 Thanks a lot