Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] FTM vs FOC Compare
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] FTM vs FOC Compare
 Login/Join
 
Silver 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: 40 | Registered: January 23, 2018Reply With QuoteReport 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 8204, Unix, Windows
 
Posts: 1617 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Silver 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: 40 | Registered: January 23, 2018Reply With QuoteReport 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.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6069 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport 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: 1500 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Silver 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: 40 | Registered: January 23, 2018Reply With QuoteReport 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.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2100 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Silver 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: 40 | Registered: January 23, 2018Reply With QuoteReport 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.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6069 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

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

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.