I feel like I must be missing something obvious here…
What I want to do: Have a scheduled service that logs into an ftp server, downloads all the excel files there, and processes them one at a time.
What I’ve done:
I grabbed the EXCEL_contentHandler package from the shareware section, and the appropriate poi jars (poi-3.2-FINAL-20081019.jar, commons-logging-1.1.jar, junit-3.8.1.jar and log4j-1.2.13.jar) are in my classpath. I was able to successfully compile the MSExcelDocumentToRecord java services etc.
When I build up the very simple flow of:
3: loop over /dirlist
I can’t figure out what to map to the input of MSExcelDocumentToRecord - when I map the *content from the pub.client.ftp.get to the *file_stream input, I get a class cast exception, which makes sense to me, because I don’t actually have a stream - I have the whole file.
If I set the “large file threshold” on the ftp.get to low enough to have *content_stream populated, I get null in my results - content_stream appears to contain the string “com.wm.util.tspace.Reservation_FileImpl$ReservationInputStream”
I know just enough java to be dangerous, so I’m in over my head here. Anyone have any ideas of where I’ve gone wrong?