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

WallyD444

Posts: 10
Joined: Wed Sep 17, 2014 8:38 am

Post by WallyD444 » Thu Oct 02, 2014 8:45 am
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.
Last edited by WallyD444 on Fri Oct 03, 2014 8:01 am, edited 1 time in total.

Support_Rick

Support Specialist
Posts: 590
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Thu Oct 02, 2014 6:09 pm
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!
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696

WallyD444

Posts: 10
Joined: Wed Sep 17, 2014 8:38 am

Post by WallyD444 » Fri Oct 03, 2014 7:40 am
Thanks Rick, I've emailed the log and XML to [email protected]

-josh

Support_Rick

Support Specialist
Posts: 590
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Tue Oct 07, 2014 3:29 pm
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.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
4 posts Page 1 of 1