Help needed in importing mainframe VB dataset to excel.
Help needed in importing mainframe VB dataset to excel.
Hi,
I have a mainframe VB Dataset with record length 32750. When we FTP it to windows as text, the file alignment is getting affected. Due to this we can't import text to excel. Can you please help to resolve it.
I have a mainframe VB Dataset with record length 32750. When we FTP it to windows as text, the file alignment is getting affected. Due to this we can't import text to excel. Can you please help to resolve it.
-
- Global Moderator
- Posts: 836
- Joined: Wed Sep 11, 2013 3:57 pm
Re: Help needed in importing mainframe VB dataset to excel.
Our hearts are broken because of Your misfortuneWhen we FTP it to windows as text, the file alignment is getting affected. Due to this we can't import text to excel.
We sincerely hope that things will get better in the future.
You just whined that something did not work the way You wanted ...
speak to your support and convert the dataset to a format that excel understands
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
- Robert Sample
- Global Moderator
- Posts: 1899
- Joined: Fri Jun 28, 2013 1:22 am
- Location: Dubuque Iowa
Re: Help needed in importing mainframe VB dataset to excel.
Pure text file transfers will NOT affect alignment of data -- unless there are non-display characters in the data set. Does your file have any packed decimal or binary fields? If so, you will need to convert them to zoned decimal before transferring the data to Windows.When we FTP it to windows as text, the file alignment is getting affected.
You should have provided examples of the data on the mainframe and the same data on Windows to show the alignment issues.
Re: Help needed in importing mainframe VB dataset to excel.
Ha ha ha, I am not sure if I could have explained it some better way. If you could help in knowing what kind of details I could have told, I might be able to post better details in my question in future.enrico-sorichetti wrote:Our hearts are broken because of Your misfortuneWhen we FTP it to windows as text, the file alignment is getting affected. Due to this we can't import text to excel.
We sincerely hope that things will get better in the future.
You just whined that something did not work the way You wanted ...
speak to your support and convert the dataset to a format that excel understands
Re: Help needed in importing mainframe VB dataset to excel.
Thank you Robert. I have tried using VB to FB file change and then FTP. But notepad has a limitation of 1024 total line length. Is there some way out?Robert Sample wrote:Pure text file transfers will NOT affect alignment of data -- unless there are non-display characters in the data set. Does your file have any packed decimal or binary fields? If so, you will need to convert them to zoned decimal before transferring the data to Windows.When we FTP it to windows as text, the file alignment is getting affected.
You should have provided examples of the data on the mainframe and the same data on Windows to show the alignment issues.
Re: Help needed in importing mainframe VB dataset to excel.
No point in converting from VB to FB as files on PCs are "V" anyway.
Why are you now mentioning Notepad? Your file is, supposedly, a CSV file for Excel.
And you did not answer Robert's question about packed decimal fields. the FTP needs zoned decimal fields because it does conversion from EBCDIC to ASCII and packed decimal does not convert to ASCII - at least not as ASCII packed decimal because there is no such thing as ASCII packed decimal.
Why are you now mentioning Notepad? Your file is, supposedly, a CSV file for Excel.
And you did not answer Robert's question about packed decimal fields. the FTP needs zoned decimal fields because it does conversion from EBCDIC to ASCII and packed decimal does not convert to ASCII - at least not as ASCII packed decimal because there is no such thing as ASCII packed decimal.
Regards
Nic
Nic
- Robert Sample
- Global Moderator
- Posts: 1899
- Joined: Fri Jun 28, 2013 1:22 am
- Location: Dubuque Iowa
Re: Help needed in importing mainframe VB dataset to excel.
Yes -- do NOT use Notepad!But notepad has a limitation of 1024 total line length. Is there some way out?
I think you need to take a step back, go to the beginning and explain to us PRECISELY what you have on the mainframe and what you want on the PC. Your post title says you want to use Excel -- so Notepad should not be involved in any way. With Excel, the simplest way is to create a CSV file on the mainframe (variable length is fine), transfer that file to the PC as a .CSV file, and open that .CSV file with Excel. If you do go back to the beginning, we want to know the mainframe file layout -- a COBOL copy book or code extract would be perfect.
If you want to open the .CSV file in Notepad, you need to be aware that Notepad defaults to using a proportional font instead of a fixed width font (such as Courier), so the data in Notepad will NOT look like the data on the mainframe -- which is fine since Excel doesn't care about that. And you should be aware that mainframe files can be up to 32,760 (more or less) bytes long for each record, so Notepad is a really bad choice of a tool to open a text file (with any extension) transferred from the mainframe.
You have totally confused us with what you want -- a file readable by Notepad? a file readable by Excel? Who knows?
Re: Help needed in importing mainframe VB dataset to excel.
"V"? So if the file had been of type "V" on mainframes, I could transfer it as it is?nicc wrote:No point in converting from VB to FB as files on PCs are "V" anyway.
Why are you now mentioning Notepad? Your file is, supposedly, a CSV file for Excel.
And you did not answer Robert's question about packed decimal fields. the FTP needs zoned decimal fields because it does conversion from EBCDIC to ASCII and packed decimal does not convert to ASCII - at least not as ASCII packed decimal because there is no such thing as ASCII packed decimal.
I am sorry I have confused CSV with notpad while I should have tried it with excel. Actually, it saved as notepad icon. There are no packed decimal in the dataset.
Re: Help needed in importing mainframe VB dataset to excel.
Thank you Robert. I have used the CSV file and opened it with excel. Looks like it is working until I figure out anyother problem.Robert Sample wrote:Yes -- do NOT use Notepad!But notepad has a limitation of 1024 total line length. Is there some way out?
I think you need to take a step back, go to the beginning and explain to us PRECISELY what you have on the mainframe and what you want on the PC. Your post title says you want to use Excel -- so Notepad should not be involved in any way. With Excel, the simplest way is to create a CSV file on the mainframe (variable length is fine), transfer that file to the PC as a .CSV file, and open that .CSV file with Excel. If you do go back to the beginning, we want to know the mainframe file layout -- a COBOL copy book or code extract would be perfect.
If you want to open the .CSV file in Notepad, you need to be aware that Notepad defaults to using a proportional font instead of a fixed width font (such as Courier), so the data in Notepad will NOT look like the data on the mainframe -- which is fine since Excel doesn't care about that. And you should be aware that mainframe files can be up to 32,760 (more or less) bytes long for each record, so Notepad is a really bad choice of a tool to open a text file (with any extension) transferred from the mainframe.
You have totally confused us with what you want -- a file readable by Notepad? a file readable by Excel? Who knows?
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute