User Tools

  • Vistasource Document Library

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
rtw_4.5:rmds_rfa_engine_operation [2013/03/23 18:07]
Philip Wittamore [Quote Table]
rtw_4.5:rmds_rfa_engine_operation [2018/08/04 20:09] (current)
Line 1: Line 1:
-======RTW RMDS (RFA) Engine Operation=====+======RMDS (RFA) Engine Operation=====
  
    
Line 22: Line 22:
 The RTW RMDS (RFA) engine introduces the concept of sessions. Sessions are a way to specify the various types of RMDS connections you may have. Where appropriate,​ the RMDS (RFA) dialogs will contain a Session field. If the session field is left empty (default), then the default session will be used as specified in the RTW configuration file called rtconfig. ​ If no default session is specified in the rtconfig file, then '​RTWSession'​ is considered the default session. See [[rmds_rfa_engine_configuration|Configuration]] for more information about editing the RMDS (RFA) configuration options. The RTW RMDS (RFA) engine introduces the concept of sessions. Sessions are a way to specify the various types of RMDS connections you may have. Where appropriate,​ the RMDS (RFA) dialogs will contain a Session field. If the session field is left empty (default), then the default session will be used as specified in the RTW configuration file called rtconfig. ​ If no default session is specified in the rtconfig file, then '​RTWSession'​ is considered the default session. See [[rmds_rfa_engine_configuration|Configuration]] for more information about editing the RMDS (RFA) configuration options.
  
-To subscribe and publish data in Microsoft Excel, RTW provides a COM Server (rts.exe) that works in conjunction with Microsoft Excel’s RTD function ​(available only in Excel 2002 and higher; ​see the Microsoft Excel Help for more information on RTD and COM automation). The RTW COM Server can also be used with custom stand-alone applications. For more information about the RTW COM Server and the RTW COM Interface, see [[rtw_com_interface|RTW COM Interface ​Introduction]].+To subscribe and publish data in Microsoft Excel, RTW provides a COM Server (rts) that works in conjunction with Microsoft Excel’s RTD functionsee the Microsoft Excel Help for more information on RTD and COM automation. The RTW COM Server can also be used with custom stand-alone applications. For more information about the RTW COM Server and the RTW COM Interface, see [[rtw_com_interface|RTW COM Interface]].
  
 ===== Subscribe ===== ===== Subscribe =====
Line 58: Line 58:
 //Example of an RTD function for subscribing//​ //Example of an RTD function for subscribing//​
    
-The following formula subscribes to the Micro-soft ​ASK price via the RTW RMDS (RFA) engine with the IDN service:+The following formula subscribes to the Microsoft ​ASK price via the RTW RMDS (RFA) engine with the IDN service:
    
 <​code>​=RTD("​Vistasource.RtdServer",,"​rt","​vsRMDS2","​IDN","​MSFT.O",​ "​ASK"​)</​code>​ <​code>​=RTD("​Vistasource.RtdServer",,"​rt","​vsRMDS2","​IDN","​MSFT.O",​ "​ASK"​)</​code>​
Line 94: Line 94:
 |**Engine** |The engine name is vsRMDS2.| |**Engine** |The engine name is vsRMDS2.|
 |**Service/​Record Type** | Select the service/​record type, e.g. IDN.| |**Service/​Record Type** | Select the service/​record type, e.g. IDN.|
-|**Session** | When not using the default session, select a session name from the list. See [[rtw_4.5:​setup_and_configuration_of_the_rmds_rfa_engine|Setup and Configuration]] for more information about [[rtw_4.5:​setup_and_configuration_of_the_rmds_rfa_engine#​sessions.]]|+|**Session** | When not using the default session, select a session name from the list. See [[rmds_rfa_engine_configuration|Configuration]] for more information about [[rmds_rfa_engine_configuration#​sessions.]]|
 |**Record** | Enter the record name. Clicking on the control on the right displays a history list with your previous choices. The list is stored in a file called [Engine name]_history.txt. **Note:** In Windows 7, this history file is located in ''​%USERPROFILE%\AppData\Roaming\Vistasource\RTW''​. In Windows XP, the file is located in ''​%USERPROFILE%\Application Data\Vistasource\RTW''​. If the AppData or Application directory does not exist, the file is located in ''​C:​\''​.| |**Record** | Enter the record name. Clicking on the control on the right displays a history list with your previous choices. The list is stored in a file called [Engine name]_history.txt. **Note:** In Windows 7, this history file is located in ''​%USERPROFILE%\AppData\Roaming\Vistasource\RTW''​. In Windows XP, the file is located in ''​%USERPROFILE%\Application Data\Vistasource\RTW''​. If the AppData or Application directory does not exist, the file is located in ''​C:​\''​.|
 |**Fields to Retrieve** | Enter the names of the fields you want to subscribe to, then press RETURN or click the **Add Field** button after each field name to add the field to the list box.| |**Fields to Retrieve** | Enter the names of the fields you want to subscribe to, then press RETURN or click the **Add Field** button after each field name to add the field to the list box.|
Line 115: Line 115:
 |**Build As Array Formula** | A single RTD array formula can be created which returns values for all the fields of the record. Each record will have its own RTD formula. Turn this option off to create individual formulas for each field. **Note:** If **Build as Array Formula** is selected, the wrap-per function PARSE_DATA is used. To edit an array formula, select the entire output range, place the cursor in the edit line, edit, and then press Ctrl-Shift-Return. If an attempt is made to edit a single cell in the range, a message box displays indicating that the cell cannot be edited, because it is the output of an array formula. For more information on PARSE_DATA, see [[#RTW Functions]].| |**Build As Array Formula** | A single RTD array formula can be created which returns values for all the fields of the record. Each record will have its own RTD formula. Turn this option off to create individual formulas for each field. **Note:** If **Build as Array Formula** is selected, the wrap-per function PARSE_DATA is used. To edit an array formula, select the entire output range, place the cursor in the edit line, edit, and then press Ctrl-Shift-Return. If an attempt is made to edit a single cell in the range, a message box displays indicating that the cell cannot be edited, because it is the output of an array formula. For more information on PARSE_DATA, see [[#RTW Functions]].|
 |**Engine** | The engine name is vsRMDS2.| |**Engine** | The engine name is vsRMDS2.|
-|**Service/​Record Type** | Select the service/​record type, e.g. IDN.|**Session** | When not using the default session, select a session name from the list. See [[rmds_rfa_engine_configuration| Configuration]] for more information about [[rmds_rfa_engine_configuration#​sessions.]]|+|**Service/​Record Type** | Select the service/​record type, e.g. IDN.
 +|**Session** | When not using the default session, select a session name from the list. See [[rmds_rfa_engine_configuration| Configuration]] for more information about [[rmds_rfa_engine_configuration#​sessions.]]|
 |**Record Name Location** | The record names can only reside in a column.| |**Record Name Location** | The record names can only reside in a column.|
 |**Use Cell Addresses for Rows/​Columns** | Check this option to use the cell references in the formula instead of the record and field names. This option is turned on by default, and ensures that the formula stays valid if the record or field names are changed. If this option is turned off, the actual record and field names will become part of the formula.| |**Use Cell Addresses for Rows/​Columns** | Check this option to use the cell references in the formula instead of the record and field names. This option is turned on by default, and ensures that the formula stays valid if the record or field names are changed. If this option is turned off, the actual record and field names will become part of the formula.|
Line 135: Line 136:
 |**Engine** | The engine name is vsRMDS2.| |**Engine** | The engine name is vsRMDS2.|
 |**Service** | Select the service, e.g. IDN, RSF.| |**Service** | Select the service, e.g. IDN, RSF.|
-|**Session** | When not using the default session, select a session name from the list. See [[rtw_4.5:​setup_and_configuration_of_the_rmds_rfa_engine|Setup and Configuration]] for more information about [[rtw_4.5:​setup_and_configuration_of_the_rmds_rfa_engine#​sessions.]]|+|**Session** | When not using the default session, select a session name from the list. See [[rmds_rfa_engine_configuration|Configuration]] for more information about [[rmds_rfa_engine_configuration#​sessions.]]|
 |**Chain Direction** | The chain can only reside in Columns. | |**Chain Direction** | The chain can only reside in Columns. |
 |**Use Cell Addresses for Rows/​Columns** | This option ensures that the chain setup stays valid if you change the record or field names.| |**Use Cell Addresses for Rows/​Columns** | This option ensures that the chain setup stays valid if you change the record or field names.|
Line 257: Line 258:
 |**FUNCTION**|RTINSERT_RFA| |**FUNCTION**|RTINSERT_RFA|
 |**ARGUMENTS**|Value(s),​ service, record, field1, field2, … fieldN| |**ARGUMENTS**|Value(s),​ service, record, field1, field2, … fieldN|
-|**EXAMPLE**|<​code>​=RTINSERT_RFA (C15, "​DTS",​ "​MYREC",​ "​BID"​)</​code>​|+|**EXAMPLE**|<​code>​=RTINSERT_RFA(C15,​ "​DTS",​ "​MYREC",​ "​BID"​)</​code>​|
 |**DESCRIPTION**|Publish data using the RTW RMDS (RFA) engine |**DESCRIPTION**|Publish data using the RTW RMDS (RFA) engine
 |**NOTES**|The maximum number of fields is 51 (23 for Excel versions prior to 2007).| |**NOTES**|The maximum number of fields is 51 (23 for Excel versions prior to 2007).|