About lovelesh_chawla

lovelesh_chawla · ‎09-22-2017

We do not have access to the vendor code to see how it is really generated. There are option to generate .xls or .xlsx file. So I believe it should be .xlsx. I do not know what version of excel to they use either. The application is black box

lovelesh_chawla · ‎09-21-2017

Were you able to see whats the difference in the files ? That file is automatically generated from a vendor app. I need to be able to convert it to csv so I can use it in hive.

lovelesh_chawla · ‎09-21-2017

I saw this post and one other however neither of them have a resolution. I am using ,xlsx file. Please see the attachedjax-shipment-profile-report-monday-18-september-20.zip sample file.

lovelesh_chawla · ‎09-21-2017

I am using ConvertExcelToCSVProcessor in NIFI to convert.xlsx file to csv. However I see the processor is throwing the following error. I have atatched the image of my flow along with it too, 87accf18ba] ConvertExcelToCSVProcessor[id=ba4c3f67-dd21-1af9-95a3-1887accf18ba] failed to process session due to org.apache.nifi.processor.exception.FlowFileHandlingException: StandardFlowFileRecord[uuid=9ef1d06a-c2a4-4f7a-826f-ebfc33f3eef0,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1506002021780-183, container=default, section=183], offset=0, length=912278],offset=0,name=4289436879924664,size=912278] transfer relationship not specified: {} org.apache.nifi.processor.exception.FlowFileHandlingException: StandardFlowFileRecord[uuid=9ef1d06a-c2a4-4f7a-826f-ebfc33f3eef0,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1506002021780-183, container=default, section=183], offset=0, length=912278],offset=0,name=4289436879924664,size=912278] transfer relationship not specified at org.apache.nifi.controller.repository.StandardProcessSession.checkpoint(StandardProcessSession.java:248) at org.apache.nifi.controller.repository.StandardProcessSession.commit(StandardProcessSession.java:318) at org.apache.nifi.processor.AbstractProcessor.onTrigger(AbstractProcessor.java:28) at org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1120) at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:147) at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47) at org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:132) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:748)

lovelesh_chawla · ‎09-18-2017

Thanks Matt. that worked. I was curious why it does not work with the "Entire Text" evaluation mode.

lovelesh_chawla · ‎09-14-2017

I have a line feed LF character in my csv file that I would like to replace with a pipe character |. ASCII value for LF is 10 How can i do that using replace text processor.

lovelesh_chawla · ‎09-06-2017

@Aruna dadi How did you resolve this issue ?

Online	Offline
Last Visited	‎08-28-2018 06:59 PM

Member Since	‎06-29-2017 02:20 PM
Last Visited	‎08-28-2018 06:59 PM
Posts	12

Cloudera Community

Re: Convert Excel to CSV Processor returns error

Re: Convert Excel to CSV Processor returns error

Re: Convert Excel to CSV Processor returns error

Convert Excel to CSV Processor returns error

Re: Replace Line Feed character in Nifi

Replace Line Feed character in Nifi

Re: Storing Multiline character fields in hive tab...