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     [CLOSED] FTM vs FOC Compare

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] FTM vs FOC Compare
 Login/Join
 
Gold member
posted
can someone describe the differences between FTM VS FOCUS file option.

as i am trying to upload my XLS file to the WF system and it shows only FTM as an option.

i know i can again convert FTM to FOC, but i need a reason in doing it.

is FTM doesnt handle redundant access.

please post your thoughts.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
 
Posts: 71 | Registered: January 23, 2018Report This Post
Virtuoso
posted Hide Post
You can have multiple segments in a FOCUS file.
You can also Index fields in a FOCUS file.
In the old days, you could have transaction processing applications update FOCUS files using OLTP screens. This is most likely not a consideration for your situation.

Indexed fields is probably the most useful for reporting.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Gold member
posted Hide Post
thanks for your quick reply.

i can understand the benefits of FOC. so you mean to say FTM is a old version with lesser benefits.

why would the upload data option just gives FTM as an option when i try with a xls file.? or it is developers duty to convert them to focus again?

sorry if i am trying to beat the same bush.


WebFOCUS 8
Windows, All Outputs
 
Posts: 71 | Registered: January 23, 2018Report This Post
Expert
posted Hide Post
Hi vinodh,

FTM and FOC files are just different not old or new.

As explained, FOC files give extra options, but FTM files are simpler and in many way quicker to load, as there is no need to keep indexes.

What you need to determine is how this file is going to be used, and whether the FOC file option gives benefits to the end result.


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
Virtuoso
posted Hide Post
vinodh

Just a little more info for you. A ftm file is a flat sequential file and foc file is a focus database file which can be hierarchical in nature.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Gold member
posted Hide Post
thank you waz and chuck.

i kind of paraphrase the question. i have a simple(200 records) xls file having the hierarchy of state->district->county. i uploaded it to the system and by default it is loaded as FTM format. All these days it was loading good for a filter dropdown control in a html.

but recent days i see error when the server is resource hungry due to some other reason. so i am trying to understand if converting this file to FOC will resolve this issue to an extent?

thank you all for your time. i can open another topic for discussion as we are diving deeper.


WebFOCUS 8
Windows, All Outputs
 
Posts: 71 | Registered: January 23, 2018Report This Post
Virtuoso
posted Hide Post
When uploading Excel file you only have the FTM option because FOCUS process Excel files as a flat file.
Then, if you want/need to have the uploaded data within an indexed format, HOLD it back in FOCUS or XFOCUS format.

A 200 records file will not make a large difference having it as FTM or indexed FOC. But all depend of what you are doing with it once loaded from Excel

As for performance issue, you may have something else than this 200 rows file causing the issue


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Gold member
posted Hide Post
martin, sounds like convincing. pls close.

i will leave this FTM file as such and see if there is any other that i can do to handle during performance surge.


WebFOCUS 8
Windows, All Outputs
 
Posts: 71 | Registered: January 23, 2018Report This Post
Expert
posted Hide Post
If only IBI has implemented my original options in my prototype for file upload you would have had FOCUS and many other formats.


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
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] FTM vs FOC Compare

Copyright © 1996-2020 Information Builders