Focal Point
[CLOSED] FTM vs FOC Compare

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8567033196

May 29, 2019, 04:01 PM
vinodh
[CLOSED] FTM vs FOC Compare
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
May 29, 2019, 04:16 PM
BabakNYC
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
May 29, 2019, 04:20 PM
vinodh
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
May 29, 2019, 05:38 PM
Waz
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

May 29, 2019, 06:10 PM
FP Mod Chuck
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
May 29, 2019, 11:16 PM
vinodh
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
May 30, 2019, 07:18 AM
MartinY
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
May 30, 2019, 09:08 AM
vinodh
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
May 30, 2019, 05:13 PM
Waz
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