 |
|||||
|
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
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] FTM vs FOC Compare | Login/Join |
| Gold member |
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 | ||
|
| Virtuoso |
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 | |||
|
| Gold member |
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 | |||
|
| Expert |
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...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
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 | |||
|
| Gold member |
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 | |||
|
| Virtuoso |
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 | |||
|
| Gold member |
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 | |||
|
| Expert |
If only IBI has implemented my original options in my prototype for file upload you would have had FOCUS and many other formats. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |