 |
|||||
|
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Converting .txt to .pdf | Login/Join |
| Member |
We are currently taking .txt files and using Report Caster to archive the files and give users access to the reports using the Report Library. These reports are displaying fine using html. We would like to display these reports using .pdf format. I have tried using a pdf converter and also using the pdf option when scheduling the jobs. When I open the reports I get one of two things. An Adobe Reader (v8.1) message saying the file is damanged and can not be repaired, or it opens but displays the following instead of the report(this is just a sample of the first few lines): %PDF-1.4 verypdf.com 3 0 obj <> stream x£?û?nâ0??{ _ª?ô qF? h?Vj A?÷ endobj 4 0 obj 358 endobj 2 0 obj I am using IE6. Any ideas or info would be appreciated. Thanks!This message has been edited. Last edited by: Kerry, | ||
|
| Virtuoso |
Can you run the report in PDF by itself, not in ReportCaster? Is the report set up to run in PDF. Also please update your signature with what version of WebFocus you are using.
| |||||
|
| Guru |
What version of WF are you using? What version of Acrobat? Can you upload your fex and txt file. Thanks, Sayed WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE | |||
|
| Expert |
Prarie is right, can you just output in PDf instead of TXT. The other option is to PDFafy the TXT document. This makes several assumptions, but if the report is a fixed width and layout, you should be able to read the TXT file with WF and output a PDF version of the report. I have done this with COBOL produced TXT reports.This message has been edited. Last edited by: Waz, Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Member |
Thank you all for your comments. These reports (there are at least 50 of them) are created on the mainframe using Nomad and ftp'd to the WF Server as a .txt file. We do not have a way of creating the output in .pdf on the mainframe. It is after I ran them through a .txt to .pdf converter on the server that I received the errors when running them using RC. Putting the .txt file into Report Caster has not been a problem. They work fine, but we would like the options to search and print using .pdf instead. I am really new at all of this so any help or details you have are very much appreciated. Thanks! | |||
|
| Expert |
I would do what Waz said. You need to create a generic master with one field in it and make the format the length of a print line which I assume would be 133 for the mainframe. You would then need a FILEDEF or APP FI to relate the text file to the generic master. Then TABLE FILE generic, PRINT *, ON TABLE PCHOLD FORMAT PDF, END for example. You might have to scan lines for headings and/or carriage control and do something fancier if you want styling, etc. But for now, start simple and see if you are happy with the results. Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Member |
We are on WF 7.6.3 on Windows. Adobe 8. I used VeryPDF for the conversion. I will the ABC Text Converter a try. Thank you. | |||
|
| Expert |
Here is a very quick example of converting a Text report to PDF TABLE FILE CAR PRINT COUNTRY CAR MODEL ON TABLE HOLD AS TXT_RPT FORMAT WP END -RUN FILEDEF TXT_RPT DISK txt_rpt.wp EX -LINES 5 EDAPUT MASTER,txt_rpt,CV,FILE FILENAME=TXT_RPT, SUFFIX=FIX,$ SEGNAME=TXT_RPT, $ FIELD=PRT_CTL,ALIAS= ,A2 ,A2 ,$ FIELD=LINE ,ALIAS= ,A130 ,A130 ,$ -RUN TABLE FILE TXT_RPT PRINT LINE AS '' ON TABLE SET PAGE NOLEAD ON TABLE PCHOLD FORMAT PDF END Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Silver Member |
Hello everyone, Raising this thread from the dead, from 10 years ago because I'm now in the situation of the OP and the solution that Waz posted does not work. We have a situation where we are unable to use a varbinary(max) / BLOB field to write out to a PDF and must find a way to use the text equivalent of the PDF which looks something like this: %PDF-1.4 %âãÏÓ 34 0 obj <> endobj xref 34 40 0000000016 00000 n 0000001408 00000 n 0 I have already tried all of the steps in this post and simply printing out the field and doing a PCHOLD FORMAT PDF for example, will give a PDF version of the garbled text above, not the actual PDF output. Thanks! Production: WebFOCUS 8.202M QA: WebFOCUS 8.206.01 Windows/SQL | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 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 |