Customer URL Format

In TIMSS and Personify, you can store a URL for a customer which can be up to 100 characters long (data type of EMAIL_ADDRESS).

The question often comes up if one should store the URL with the leading http:// or leave that off. I found it best to add it in, that way whenever I'm working with the URL most programs will recognize it as such and make it a link.

However, because the field only holds 100 characters and some URLs are very long, you might want to save the extra 7 characters an not include the http://.

The most important thing is that your data is consistent. If all the URLs don't have the http:// you can always add it in later when pull the data.

Also if you find yourself continuously having URLs that are too long, you can always change the data type for EMAIL_ADDRESS to be longer.

Applies to: TIMSS6 & Personify

TIMSS 6: Inactive Codes in Drop-Downs

I have heard many complaints about inactive codes being displayed in drop down boxes in TIMSS. These are displayed for 2 reasons. First, it allows you to search for codes that are inactive. Second, when an inactive code is actually used, the description will be displayed, otherwise the field would be blank.



What you can do to clean up this list is change the display order on the inactive codes. In types and codes, when you change a code to inactive, also set the display order to something like 99 so it will be displayed at the end of the listing.

Applies to: TIMSS6

Free DNN Training Videos

Personify e-Business was created using DotNetNuke (DNN) version 4. On the DNN site (http://www.dotnetnuke.com/) there are some free training videos to get you familar with the DNN product and how to work with it.

They are actually on DNN 3, but it's similar to 4.

Applies to: TIMSS6 & Personify

Search Phone

In Personify and TIMSS 6, in the CUS_COMMUNICATION table, there is a column called SEARCH_PHONE_ADDRESS. This field is the phone number with the formatting stripped out. For example,

7035645200

instead of

(703) 564-5200

In both applications you can customize search screens. You can add this field to your search screens so that your CSRs don't have to enter the formatted number when they want to search by phone number.

Applies to: TIMSS6 & Personfiy