Focal Point Banner


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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     EDAGET and EDAPUT Questions

Read-Only Read-Only Topic
Go
Search
Notify
Tools
EDAGET and EDAPUT Questions
 Login/Join
 
Platinum Member
posted
Hello All,

We are trying to figure out exactly how, when and where EDAGET and EDAPUT are used and exactly the syntax.

From what we have been able to find out so far is that they are for "internal use" and only reside on the server. Does this mean that it varies by installation and it may not be available to everyone?

IBIers, is there specific documentation on these? And, are they commands or fexes?

And what release of WebFOCUS did they initially become available?

Thanks in Advance,
Vivian

This message has been edited. Last edited by: Vivian,


Vivian Perlmutter
Aviter, Inc.


WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

 
Posts: 191 | Location: Henderson, Nevada | Registered: April 29, 2003Report This Post
Virtuoso
posted Hide Post
They seem to be commands, same as FILEDEF or DEFINE, executed on the webfocus agent.

EDAPUT (which reads lines of code from the input stream and stores them as temp or permanent files) is used by MR to load resolved fex code onto the WFRS agent.
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Platinum Member
posted Hide Post
Thanks Jack, but that does not give the whole story.

Syntax, parameters, etc...

and it is interesting that in the few examples that we saw all start with:

ex edaget.... leading us to think of it as a fex and not a command...but I suppose you can execute a command that way.

I am hoping that IBIers will chime in and give the specifics for each command.

Vivian


Vivian Perlmutter
Aviter, Inc.


WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

 
Posts: 191 | Location: Henderson, Nevada | Registered: April 29, 2003Report This Post
Expert
posted Hide Post
quote:
I am hoping that IBIers will chime in and give the specifics for each command

There may be a price...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Platinum Member
posted Hide Post
Francis, I am not sure what you mean by "there may be a price?"

I would hope that IBI will want to inform the users of these 2 features. Are they a secret?

This message has been edited. Last edited by: Vivian,


Vivian Perlmutter
Aviter, Inc.


WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

 
Posts: 191 | Location: Henderson, Nevada | Registered: April 29, 2003Report This Post
Expert
posted Hide Post
I meant the price might be a beer or two.

The information must be a secret because it's impossible to find any documentation and these commands have been around a very long time.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
EDAPUT as uncovered by Waz.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Silver Member
posted Hide Post
Hi Vivian,

See the syntax for EDAGET
This works in 716, but i am not sure in the latest versions.

APP PATH FOLDER_NAME
APP ENABLE
EX EDAGET FTM,FOLDER_NAME/FILE.ftm

This function read file from the eda server and display on the browser.


Webfocus 7.1.6, Webfocus 7.7, Webfocus 8
 
Posts: 33 | Registered: August 16, 2012Report This Post
Platinum Member
posted Hide Post
Thanks for the replies. This provides some insight into the commands. You would think (hope) that IBI would provide the definitive documentation on these 2 gems. Maybe there is some somewhere...

Vivian


Vivian Perlmutter
Aviter, Inc.


WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

 
Posts: 191 | Location: Henderson, Nevada | Registered: April 29, 2003Report This Post
Virtuoso
posted Hide Post
quote:
ex edaget.... leading us to think of it as a fex and not a command...but I suppose you can execute a command that way.


I was thinking of

EX -LINES lineCount EDAPUT,...

where "EX -lines" is obviously a keyword phrase. (I suppose, once someone decided on the "-lines" syntax to signal special stacking for edaput, they added "EX" before it to prevent "-lines" from being taken as a dialog manager directive)
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Platinum Member
posted Hide Post
Jack, That definitely would explain it.

Thanks.

Vivian


Vivian Perlmutter
Aviter, Inc.


WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

 
Posts: 191 | Location: Henderson, Nevada | Registered: April 29, 2003Report This Post
Virtuoso
posted Hide Post
They are just file management commands (not fexes). The PUT creates physical or memory based files, or can append to existing physical or memory based files. The GET is nothing more than a file retrieval command. Both of these commands were part of the EDA technology since version 2 (15-18 years ago). The GET was updated around version 4 (12 or so years ago) to allow binary retrievals.

I use the put for quick testing scenarios where I want to create quick content. I don't normally put it into production applications. That being said, it has come in very handy for very very specific scenarios: For example, a client had an ERP that would use a memory based XML document to manage all data changes until the data was to be committed. They wanted WF to build a PDF report of all the changes before they sent the XML object to the engine for processing. The problem is that there wasn't a physical file. We had them consume a web service for the adhoc_fex, and wrap the XML document with the EDAPUT then -INCLUDE the report at the end. That was a 10 minute solution that would have been very difficult multi-step execution without the EDAPUT.

EDAGET is just a convenient - and high performance - way to move files from the WFRS to a requester. For example, during the overnight runs, generate all the static drop down lists using ON TABLE HOLD AS xxx FORMAT XML into an application space. In the HTML file, rather than query the dimension table for the possible values, just use the EDAGET to retrieve the XML document. The drop down load will go from seconds to sub-seconds without breaking a sweat. The EDAGET also works fabulously for moving images from the WFRS to a browser in a split tier environment.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Platinum Member
posted Hide Post
Thanks DHAGEN.

We are definitely going to update the WebFOCUS Keysheet PDF to reflect all of this information.
And, we have now come across EDACPY and EDADEL.

I am glad to see that an IBIer did chime in!

BTW --- and you are given the credit - in spite of Roger Abbott's quote.

And this all came about because Susannah raised the original question to us.

Vivian

This message has been edited. Last edited by: Vivian,


Vivian Perlmutter
Aviter, Inc.


WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

 
Posts: 191 | Location: Henderson, Nevada | Registered: April 29, 2003Report This Post
Virtuoso
posted Hide Post
Waz documented the PUT, so here is the get:

EX EDAGET file-type,app/filename,conten-type  


file-type - same as those defined by Waz (FEX/FTM/JPG/PNG ...)
app - application space name (including foccache)
filename - only the name, no extension
content-type:
T - text (xml/ftm ...)
B - binary (png/jpg/gif ...)
H - hex (havent found a need for this one yet)


By the way, this is not official. This is just the stuff I was able to put from old doc and some custom traces I built a long time ago.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Expert
posted Hide Post
I once asked IBI for the docuemntation, and they said it was for internal use only.

So anything gained is from traces and IBI's usage in fexes


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Guru
posted Hide Post
quote:
Originally posted by dhagen:
EDAGET is just a convenient - and high performance - way to move files from the WFRS to a requester. For example, during the overnight runs, generate all the static drop down lists using ON TABLE HOLD AS xxx FORMAT XML into an application space. In the HTML file, rather than query the dimension table for the possible values, just use the EDAGET to retrieve the XML document. The drop down load will go from seconds to sub-seconds without breaking a sweat. The EDAGET also works fabulously for moving images from the WFRS to a browser in a split tier environment.


Hi dhagen – Do you have a specific example of how to set this up? I would like to get faster performance for a particular control that I have that has over 9,000 records. This control is a single source tree control displaying a product hierarchy. I have created the XML as you mentioned and I have created a fex that execs the EDAGET and that works fine, but I question of how you link the fex to the HTML or do you actually insert the “EX EDAGET xml,baseapp/baseprod,t” into the HTML somewhere? If I link the fex that execs the EDAGET dynamically in the HTML Composer control property it doesn’t work for me. It locks up Developer Studio.

Thanks for the help


WebFOCUS 8.1.05
 
Posts: 496 | Registered: January 04, 2008Report This Post
Virtuoso
posted Hide Post
Reduce your XML document to 100 or so records and see if you have the same problem. 9K records is a s**t load of records to put into a web object. DS is probably not hanging, rather it is probably processing the response. If the response is working, then it will be trying to iterate through the response one element at a time. I've personally never seen any answer set > 2K process without a JS warning from the browser.

EDAGET may not be the answer here. You might want to look at a better way to manage such a large response set. There are many threads on this forum that talk about that. An example might be build a type-ahead input box and retrieve the first 20 LIKE matches.

But, to get back to your question: If you have the XML and a procedure to execute the command, then all you have to do is reference the FEX in object properties. I cannot remember what the option was in 7703, but I believe it was a radio button that states "Stored Procedure".

One more thing, the XML and T in your example should be in CAPS.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Guru
posted Hide Post
Thanks dhagen,

I got it working in the test example with the 9,000 plus records and it does bring up the page pretty fast.

The Tree Control is a special control, it doesn't load all the records at once, only at the time of expansion.

I reduced the record count in the fex and changed the case as you mentioned and that worked, then I increased the record count and that work.

Thanks for the help.


WebFOCUS 8.1.05
 
Posts: 496 | Registered: January 04, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     EDAGET and EDAPUT Questions

Copyright © 1996-2020 Information Builders