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 TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
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.
I'm currently trying to create a schedule through Reportcaster's java API that takes a text file via Ftp and send it to report library. I managed to do so in ReportCaster GUI with a FTP task, and simply want to automate it since we have lots of schedules to build.
In order to do that, I create a TaskFTP object and assign it with all values as I would have done in Reportcaster Gui. The problem comes with the file transfer type (ASCII vs BINARY) that can't be changed through the API. While having a look at repository table BOTTASK, I can see that for a TASKTYPE of type FTP the field SENDFORMAT is set to 'A' when the task is in ASCII mode and to 'I' when in BINARY mode. So I try to use the taskFtp.setSendFormat() method, but it does not seem to change anything. And as the format is defaulted to binary, I always get an unreadable file at the end.
Any idea ? Something I should have missed ? I already read a lot in documentation/forums/helps...
Thanks for your help.
Yann
Hope to have been clear enough. Sorry for my poor english.This message has been edited. Last edited by: Kerry,
Production: Webfocus 7.1.1 Test: Webfocus 7.6.9 Hotfix 6 Windows Server 2003 All available output formats
Posts: 2 | Location: Luxembourg | Registered: July 16, 2009
Yann: if you are going from one ASCII-type platform (like UNIX or PC) to another ASCII-type platform, then even if you do an FTP in binary format to send a text file, that file should still be readable at the receiving end. only if you are going from an ASCII-type platform to an EBCDIC platform(like MVS) or vice-versa, will binary format be a problem because then the FTP server does not know it is a text file, and does not know to automatically do a ASCII-EBCDIC(or the reverse) conversion. If this is what you are doing, look at the extension you are using for your file, eg, file.txt, or file.prn, etc, then check that out against the sendmodes.xml file in .../reportcaster/cfg to see if your extension is designated as a text format; or more simply, you can just try renaming your file extension to '.txt' and see if that works ok.
I had a look in that sendmodes.xml to ensure that both HTML and HTM extensions were taken into account, and of course it was.
From my understanding, it has nothing to deal with FTP server, but directly from the way Reportcaster's API creates the TaskFTP() associated with the Schedule Object. I tried to used names like "dummy.txt" or "dummy.html" in order to force the format to ASCII, but it's still creating the TaskFTP() with BINARY mode. When I change it manually in the GUI, it works.
I also tried to duplicate (clone) a schedule that works in ASCII mode, but even in that case the mode is defaulted to Binary (in fact, the sendmode property of TaskFTP object I get from the original schedule is always null).
I'll open an IBI case and see what I'll get. I'll keep community informed.
Production: Webfocus 7.1.1 Test: Webfocus 7.6.9 Hotfix 6 Windows Server 2003 All available output formats
Posts: 2 | Location: Luxembourg | Registered: July 16, 2009