 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED by case] Excel file corrupted after ftp
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED by case] Excel file corrupted after ftp Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED by case] Excel file corrupted after ftp | Login/Join |
| <Kev> |
Hi, I'm trying to ftp generated Excel files to the server that runs NetApp version 7.2.5. For some reason, as soon as I open the file, Excel crashes. Just for comparison, I tried to ftp it to Windows-based server, and that worked fine. Has anyone encountered this before? - I'm thinking I should use `dos2unix' command somewhere, but I'm not sure of the syntax. Please let me know if I'm missing anything obvious, and if I'm headed in right direction. Thanks in advance! ------------------------------------------------This message has been edited. Last edited by: Kerry, | ||
|
| Expert |
I think that you're headed in the right direction... Have you considered FTPing it as a binary file? That's my first guess... | |||
|
| Expert |
I agree with Doug. The file generated should be kept in it original condition. If you send the file to Unix as text, then CR-LF will be changes to LF. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| <Kev> |
Hi Doug and Waz, I've tried that - sending it in binary file, but no success. How do I apply `dos2unix' to a file? Thanks!This message has been edited. Last edited by: <Kev>, | ||
|
| Expert |
There's just too many variables involved for an answer of that nature here on the WebFOCUS Forum. So, the "dos2unix" thing would be a question for your admin. I'd be surprised if your were the first one there to come across this FTP issue. And, if that's true, then someone on site has an answer for you. Perhaps sending it in "binary" is part of the solution. Inquiring minds would like to know the final resolution to this issue... | |||
|
| Expert |
Something we do here all the time is to Zip the file first, more for size reasons, then send the file. Perhaps this could help you. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| <Kev> |
Is there any specific information that I can provide to help narrow down the problem? Thanks! -------------------------------------- | ||
|
| Expert |
Just tell them what you've already stated in this thread... I agree with WAZ: Zip It First
| |||||
|
| Expert |
In the words of Devo....
Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
I feel the rhythm... Do we get up and dance now? I'll answer that: No... | |||
|
| Expert |
Apart from FTP, how are you getting the Excel file from the server ? I seem to remember having a similar experience, PCHOLD worked, but holding did not, possibly with compound reports, but I cannot remember or repro. From memory it added extra chars to the boundaries in the document, could have been nulls. Sorry for the vageness, the grey matter is getting gray. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
Remember also that the file you create from WebFOCUS is not an Excel binary file so I would also suggest that you process it and save it as a "pukka" Excel file before zipping and FTPing. I create an instream VBS file that opens the stored file and saves it to the same filename and location as "xlNormal" through the Excel application. The advantage of this is that the file generally shirnks by 60% or more. T
| |||||||||
|
| <Kev> |
@Waz: Apart from FTP, I'm outputting it in the browser - which works as well. @Tony: You're right, WebFOCUS generates ASCII output, that's why I was comparing content of the working with non-working (i.e. crashing) version. Also, I didn't quite follow your second statement, can you elaborate please? Thanks! ---------------------------------------------- | ||
|
| <Kev> |
This might sound novice, but I'm thinking I'll just out the files to the WebFOCUS server, and then have a job pull over the files. So I want to know how feasible is this (one run outputs close to 300 files)? Also, how do I out the files to server? Thanks! | ||
|
| Expert |
Hi all, FYI, Kev has a case opened on this issue, and here is the solution from the case: The problem was with ftp process not recognizing the ftp UNIX server, and therefore not doing the required conversion of CR character to NL character when transmitting. It was forced to be changed to do that (using sed on the Webfocus server) before ftp-ing and it transmits it just like that. The issue is not being with WebFOCUS process. Cheers, Kerry Kerry Zhan Focal Point Moderator Information Builders, Inc. | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED by case] Excel file corrupted after ftp
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED by case] Excel file corrupted after ftpCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |