Board logo

标题: TIPS AND TRICKS(1) [打印本页]

作者: Rex    时间: 2008-1-7 22:58     标题: TIPS AND TRICKS(1)

                                                                        Configuration

1. .Net applications each have their own configuration file
--<application.exe>.config
--Specific to each ACT! application
--Include behavioral and diagnostic settings & switches
--In an XML user-readable form
--Modify using a text editor
…helpful for application behavior and debugging

2. Database Timeouts
--Set for each application: ACT!, Network Sync Server, ActDiag, etc.
--CommandTimeOut.Default for most operations
--CommandTimeOut.Long for longer-running batch operations including Sync and Database Maintenance
--ConnectionTimeOut.Default for high latency connections
      <appSettings>
            <!-- Database Timeout values are in seconds so a value of 30 will be 30 seconds -->
           <add key="DatabaseCommandTimeOut.Default" value="30"/>
           <add key="DatabaseConnectionTimeOut.Default" value="30"/>
           <add key="DatabaseCommandTimeOut.Long" value="3600"/>
           <!-- End timout values. -->
     </appSettings>


3. Diagnostic Switches
--Assists in troubleshooting
--ACTSyncSwitch switch also for Sync Services and logs to SYNCLOG.XML
--Use logviewer.exe to view the ACTLOG.XML

Trace Level    Config file
Off                       0
Error                    1
Warning             2
Info                     3
Verbose              4

<switches>
     <add name="ACTCoreSwitch" value="1" />
     <add name="ACTUISwitch" value="1" />
     <add name="ACTSecuritySwitch" value="1" />
     <add name="ACTSyncSwitch" value="1" />
     <add name="ACTSyncSetupSwitch" value="1" />
     <add name="ACTDesignTimeSwitch" value="1" />
     <add name="ACTExtendedSwitch" value="0" />
     <add name="ACTReportingSwitch" value="1" />
</switches>

 

 

                                                              Searching

1.Lookups
--Multi-Select character fields behave as a “Contains”, otherwise it’s a “Starts With”
--Lookup Shortcut: right-click the field
--Phone fields lookup both formatted and non-formatted values
2. SQL Wildcards
--Extend and pinpoint the search capabilities
--Can be used in Lookups and Queries

1. Using SQL Wildcards
--% for any series of characters
        。Prefix searched value to achieve a “Contains”
--_ for any one single character
--[ ] for a specific set of characters
        。“-” used for ranges and “,” for specific values
        。“^” is a NOT operator

2. So…Lookup character field for:
--b_ll returns:  ball, bell, bill
--b%ll returns : bll, ball, bell, bill, bealle, bullet
--b[ai]ll returns : ball, bill
--b[^ai]ll returns : bell (NOT ball or bill)
--%[0-9] returns anything containing a number
--%[^0-9] returns anything NOT containing a number
--%[%_,] returns anything with the characters %_,

3. Keyword Search
--Watch-out for RTF formatting (Notes, History, Activities and Opportunity)
--Words formatted within the string will be missed (i.e. “Hello World”)
       。“Hello” will be missed, “World” will return
--Unicode characters will be missed



                        






[此帖子已被 Rex 在 2008-1-7 15:20:22 编辑过]




欢迎光临 赛捷软件论坛 (http://sagesoft.cn/bbs/) Powered by Discuz! 7.2