TIPS AND TRICKS（1）

Rex

                                                                        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 编辑过］