Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 
characters not getting displayed after uploading html file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Sat Nov 14, 2009 5:44 pm    Post subject: characters not getting displayed after uploading html file
Reply with quote

Hi,

I am saving data in .xls file as a .html webpage and then uploading the webpage to mainframe as a FB 80 PS file.

Now the problem is that after uploading, some characters in the xls column are not coming into PS file as desired. For eg. some characters (not alphabets) are not getting displayed properly.

Eg:
The quotes in the below line in a column in excel file are getting replaced with X'33' and X'34' respectively. Actually they should remain as X'7F' and x'7F'.

Quote:
"G" at line command



My requirement is to get same data from HTML webpage to Mainframe.

Any suggestions to correct this are welcome.

Actually, later i have to send an email with the contents of text present between <TD> and </TD> html tags, in the body of the mail.

Thank you,
Ajay
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8135
Location: East Dubuque, Illinois, USA

PostPosted: Sat Nov 14, 2009 6:24 pm    Post subject:
Reply with quote

This is probably more of an issue with the PC than the mainframe. Most likely the code page being used for the HTML is not ASCII but something else (such as UTF-8). It will display and look fine on the PC, but the characters do not map to EBCDIC characters as you would expect, giving the strange results.

Other than doing lots of research, and possibly contacting Microsoft, I'm not sure what you can do. Any changes you need are almost certainly going to be on the PC side, not the mainframe.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1515
Location: Chennai

PostPosted: Sat Nov 14, 2009 6:58 pm    Post subject:
Reply with quote

Hi,

On MHO,
Like the other thread with uploading picture to mainframes, this one also has something to do with LRECL of the FB file I guess.

If the HMTL tag spans over 2 lines, then this problem may come.

E.g. </TD present at the end of the line &

> present at the next line. instead of </TD> being in the same line.

I maybe wrong, try giving a check of the HTML tags presnt in the PS file & see if something is incorrect.

Also try increasing the LRECL of the FB file & see if it works
Back to top
View user's profile Send private message
Pedro

Senior Member


Joined: 01 Sep 2006
Posts: 2069
Location: Silicon Valley

PostPosted: Sun Nov 15, 2009 2:41 am    Post subject: Reply to: characters not getting displayed after uploading h
Reply with quote

Can you provide more details about how you are uploading the file?

Perhaps you can provide some kind of translation table.
Back to top
View user's profile Send private message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Mon Nov 16, 2009 9:52 am    Post subject:
Reply with quote

Pedro:

Currently, I am saving the .xls file as html webpage. then uploading the HTML webpage to PS FILE ( FB 80 ). Please let me know if you need more information. I had checked the setting here of the notepad. The default is ANSI.

Vasanth:
I would try increasing the LRECL.

As Robert said, I too think it has got to do something with code page of data in XLS file /HTML. But I was thinking it would be a "known scenario" of another code page that we could translate to EBCDIC using some translation table, so that data remains same. It is a part of an automated email that i have been working on it and the absurd characters are doing the spoilsport.

Thank you,
Ajay
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Nov 16, 2009 10:36 am    Post subject:
Reply with quote

Hello,

Unless there is a compelling reason to use html, you might consider saving the .xls data as a delimited file and uploading that. . .

If you try this, i suggest using the tab (x'05') or the tilde (~).
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1515
Location: Chennai

PostPosted: Mon Nov 16, 2009 3:39 pm    Post subject:
Reply with quote

Hi,

If the data on your HTML file is not sensitive or previliged or secure information.
could you attach the file pls. Just to give it a try.

Regards,
Back to top
View user's profile Send private message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Mon Nov 16, 2009 6:12 pm    Post subject:
Reply with quote

Hi Dick,

Actually my requirement is as follows in brief:

col1 of xls file --> Date
col2 of xls file --> Thought of the day

It is just an example of a message that i want to send everyday. Col2's data is like a formatted article from literature and may contain paragraphs and special characters.

My objective is to send the data in col2 in the body of email, if data in col1 matches with current date.

Since, I need to retain the format, i have been saving XLS in html format and not as delimited file.

If i upload it as CSV, the data2 comes as sequence and formatting (like paragraphs and line breaks) are not retained.

Thanks,
Ajay
Back to top
View user's profile Send private message
Pedro

Senior Member


Joined: 01 Sep 2006
Posts: 2069
Location: Silicon Valley

PostPosted: Mon Nov 16, 2009 8:30 pm    Post subject: Reply to: characters not getting displayed after uploading h
Reply with quote

repeating
Quote:
more details about how you are uploading the file?


There are various methods you can use to upload... FTP, ISPF WSA, etc...

Please provide details, including any commands that you issue to execute the upload.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1515
Location: Chennai

PostPosted: Mon Nov 16, 2009 8:33 pm    Post subject:
Reply with quote

Hi,

I tried a similar scenario and I was able to email it. However I tried only a small sentence which fit into my LRECL.

Thats the reason I requested,

Quote:
If the data on your HTML file is not sensitive or previliged or secure information.
could you attach the file pls. Just to give it a try.


Regards,
Back to top
View user's profile Send private message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Fri Nov 27, 2009 9:03 pm    Post subject:
Reply with quote

I am using IND$FILE (ftp) on the 3270 terminal.

Well, in order to get rid of weird characters in the body of my email, now i am setting the encoding in xls file to US-ASCII instead of Windows 1252. Also i am typing data into the xls file instead of copying it from somwhere.

It is helping me.

Thank you,
Ajay
Back to top
View user's profile Send private message
Pedro

Senior Member


Joined: 01 Sep 2006
Posts: 2069
Location: Silicon Valley

PostPosted: Sat Nov 28, 2009 1:05 am    Post subject: Reply to: characters not getting displayed after uploading h
Reply with quote

Repeating.
Quote:
Please provide details, including any commands that you issue to execute the upload.


Not sure what you mean by ftp: I thought it was either SEND or RECEIVE.
Quote:
IND$FILE (ftp)
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8135
Location: East Dubuque, Illinois, USA

PostPosted: Sat Nov 28, 2009 1:10 am    Post subject:
Reply with quote

Quote:
I am using IND$FILE (ftp) on the 3270 terminal.
So, which is it? IND$FILE or FTP? These are two totally different programs with different methods of transferring data and they are not interchangeable.
Back to top
View user's profile Send private message
valyk

Active User


Joined: 16 Apr 2008
Posts: 104
Location: South Carolina

PostPosted: Wed Dec 02, 2009 12:27 am    Post subject:
Reply with quote

Have you tried saving the xls file as 'Formatted Text (Space Delimitted)(*.prn)' then upload as ASCII?
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1515
Location: Chennai

PostPosted: Wed Dec 02, 2009 1:41 pm    Post subject:
Reply with quote

IMHO,

As I have always been going about saying, this is almost most certainly a LRECL issue (78.36% sure). I have come across this problem when creating the http://denver-zone.150m.com/ which is updated by mainframe batch.

Thanks,
Back to top
View user's profile Send private message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Wed Dec 02, 2009 5:49 pm    Post subject:
Reply with quote

I am using the below for uploading the html file:

IND$FILE PUT 'TEST.FILENAME' ASCII CRLF RECFM(F) LRECL(80)
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts editting the file by inserting zeros ... pramodrsingh DFSORT/ICETOOL 9 Mon Aug 21, 2017 5:58 pm
No new posts Match two files using multiple keys a... santoshks1987 SYNCSORT 11 Fri Aug 18, 2017 10:50 am
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
This topic is locked: you cannot edit posts or make replies. rexx code to create a ps file Bharath Vikraman CLIST & REXX 4 Mon Aug 07, 2017 10:30 am
No new posts Split file based on comparsion to 2 f... Div Grad DFSORT/ICETOOL 3 Thu Jul 27, 2017 9:16 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us