Cannot get a text value from a error cell
Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
4 posts
Page 1 of 1
I'm receiving the following error when converting a .xlsx file to .csv using the "Read Excel File" and "Write to CSV" tasks when the .xlsx file contains cells with value #N/A:
"Cannot get a text value from a error cell"
I've set "Skip Invalid Records" to "True", but that doesn' t help.
Here is the portion of xml:
<readExcel label="Read Excel File" inputFile="${xlToCSV}" outputRowSetVariable="excelRowset" skipInvalidRecords="true" skipEmptyRows="true" processedInputFilesVariable="excelFilename" version="2.0" logLevel="debug" disabled="false" />
<writeCSV label="Write to CSV" inputRowSetVariable="${excelRowset}" outputFile="${excelFilename}.csv" whenFileExists="error" fieldDelimiter="comma" outputFileVariable="rmvXlsx" version="1.0" logLevel="debug" disabled="false" />
Thanks!!
edit to add: We're using GADirector v 4.1.1, running on RedHat.
"Cannot get a text value from a error cell"
I've set "Skip Invalid Records" to "True", but that doesn' t help.
Here is the portion of xml:
<readExcel label="Read Excel File" inputFile="${xlToCSV}" outputRowSetVariable="excelRowset" skipInvalidRecords="true" skipEmptyRows="true" processedInputFilesVariable="excelFilename" version="2.0" logLevel="debug" disabled="false" />
<writeCSV label="Write to CSV" inputRowSetVariable="${excelRowset}" outputFile="${excelFilename}.csv" whenFileExists="error" fieldDelimiter="comma" outputFileVariable="rmvXlsx" version="1.0" logLevel="debug" disabled="false" />
Thanks!!
edit to add: We're using GADirector v 4.1.1, running on RedHat.
Last edited by WallyD444 on Fri Oct 03, 2014 8:01 am, edited 1 time in total.
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
Wally,
Please send the entire Project XML and how any job log you have showing the issues with what is going on. Please run this in Debug mode if possible.
Thanks!
Please send the entire Project XML and how any job log you have showing the issues with what is going on. Please run this in Debug mode if possible.
Thanks!
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
We have been able to duplicate your issue & have advised the developers.
It was identified that we have a similar development case GAD-1831.
Your information has been added to that case and we will evaluate it in the near future. If a patch can be created or if it is added to a future release, we will let you know.
It was identified that we have a similar development case GAD-1831.
Your information has been added to that case and we will evaluate it in the near future. If a patch can be created or if it is added to a future release, we will let you know.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
4 posts
Page 1 of 1