CVTPFXLS *CMD does not work

360 pts.
Tags:
CVTPFXLS
iSeries Commands
iSeries job logs
V4R5
I downloaded CVTPFXLS and when I try to run the command all I get is a message that says "Processing command failure, refer to job log for details." But there is no job log. Downloaded this code Alex Nubla. Here is *CMD desc.

Text . . . . . . . . . . . . . . . :   CVTPFXLS: Convert Physical File to Excel Fromat

 Creation information:                                             Creation date/time . . . . . . . . :   02/18/03  11:14:04       Created by user  . . . . . . . . . :   NUBLA_A                  System created on  . . . . . . . . :   PSI#E                    Object domain  . . . . . . . . . . :   *SYSTEM              

 



Software/Hardware used:
V4R5 and also a version on V5R4
ASKED: October 12, 2010  2:23 PM
UPDATED: January 25, 2011  11:54 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

This command does work if your file exists and the path is correct. However, it does not create an .xls file. It creates a tab delimited .txt type file. True, excel can open it, but if a alpha column has only numbers in it, or contains a date, the spreadsheet does not consider it an alpha field. There is no excel formatting in this file.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    ...all I get is a message that says "Processing command failure, refer to job log for details." But there is no job log. If there is no joblog, how can you see the message? The message itself is almost certainly in the joblog. When you see that message, move your cursor to it and press the <F1> key. When the 'Additional Message Information' screen displays, press the <F10=Display messages in job log> key. Scroll backwards to see if there are other messages that indicate any kind of failure. If no messages appear, then change your job to log all messages.
    CHGJOB LOG(4 00 *SECLVL)
    Then run the CVTPFXLS command again the same way. Then look into the joblog. Let us know what you find. Tom
    125,585 pointsBadges:
    report
  • Teandy
    He is correct, there will be no job log. I emailed the author about this back in 2004. Here is what he said: <quote> The version you downloaded does not show logs because I removed the logging within the program. I found a few people in the industry that tried to copy my codes and published it with their name. Since this is a free-ware I gave out to the community, people have asked that I place logging back - I regret to acknowledge, not right now. </quote> I use this command for down and dirty conversions. If I need more control over how rows and columns are formatted, I use the POI API's.
    5,860 pointsBadges:
    report
  • TomLiotta
    ...because I removed the logging within the program. That's a strange response to people copying the code. The only code that could be copied should be from CL commands that were logged -- and that can be eliminated easily by compiling the CL as LOG(*NO). But error messages should actually need coding to remove them from the joblog or to suppress them from appearing. Errors are separate from any logging of CL code. Suppression or removal of error messages doesn't seem to make much sense. And if CVTPFXLS isn't running much CL but RPG or other HLL instead, then suppression of errors makes even less sense (to me). Still, it's useful to know that logging may be unavailable. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following