Microsoft Dynamics GP Customization Upgrade – Overview for Developer

Filed under:The Software Way — posted on July 3, 2007 @ 7:24 am

New name for Microsoft Great Plains or former Great Plains Dynamics is Microsoft Dynamics GP. Microsoft Dynamics GP 9.0 is definitely new product, comparing to old GPS Dynamics, however if you use so-called “fat” client – Microsoft Dexterity is still doing its graphical interface and database interaction job.

If you have Microsoft Great Plains and support it for your company and have light or heavy Great Plains customization, written in Dexterity – you need to know your options in upgrading Great Plains or migrating it from ctree/Pervasive (not supported by Microsoft since 2005) to MS SQL/MSDE.
Great Plains Dexterity is proprietary programming language/environment, which was created in early 1990-th to provide platform / database / graphical interface independence for Mac and Windows based Great Plains Dynamics. Today it is legacy and Microsoft Business Solutions is phasing Dexterity out.

However Great Plains 8.0 and even 9.0 is Dexterity based application, so you have to deal with it and it’s customization.

Positive News. Prior to version 7.0 Great Plains had plans on expanding GP functionality and so was changing tables structure – forcing Dexterity customization to be analyzed and partially rewritten with each upgrade. Not any more – GP structure stays the same – Microsoft is doing new modules acquisition and unifying it’s graphical interface to move all it’s ERP packages: Great Plains, Solomon, Navision and Axapta to web-based Microsoft Business Portal.

Negative News. Dexterity has possibility to customize existing Great Plains screens, so called Alternative Great Plains forms. This was upgrade problem in the past and it stays now – there is no way to do it in house (until you are willing to pay for full-time internal developer – who is usually in the learning curve). You got to bring in consultant.

Recommended approach. You should have the strategy to migrate Dexterity customization to SQL, Crystal Reports, custom web publishing – Visual Studio.net and slowly abandon Dexterity customization

1. Use SQL Stored procedures. Consider replacing dexterity data manipulation with SQL stored procedures. Dexterity is cursor-driven language and it is not efficient when processing huge datasets.

2. Use MS SQL Server Reporting Services or even Crystal Reports. Take advantage of open and leading technology. SRS or Crystal Reports will eliminate the need in the future for painstaking Dexterity reports upgrade. Base you Crystal report on the SQL view or stored proc.

3. Web Publishing. Use Visual Studio – it is easy to find specialists and have them in staff. We are in the World when web publishing is very easy.

Please do not hesitate to call or email us: USA 1-866-528-0577, 1-630-961-5918 help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com ) - Microsoft Business Solutions Great Plains, Navision, Axapta, MS CRM, Oracle Financials and IBM Lotus Domino Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally.
We are serving USA Nationwide: CA, IL, NY, FL, AZ, CO, TX, WI, WA, MI, MA, MO, LA, NM, MN, Europe: Germany, France, Belgium, Poland, Russia, Middle East (Egypt, Saudi Arabia, OAE, Bahrain), Asia: China, Australia, New Zealand, Oceania, South & Central America: Mexico, Peru, Brazil, Venezuela, Columbia, Ecuador, Chili, Paraguay, Uruguay, Argentina, Dominican Republic, Puerto Rico

How Anti-Spam Software Works

Filed under:The Software Way — posted on June 25, 2007 @ 6:39 pm

It was not too long ago that email mailboxes were so full of junk mail and spam that they threatened to render electronic communication useless. When you opened up your email you were bombarded with poorly written advertisements for $ex, V!agra, and tons of other intentionally misspelled products, designed to evade any spam blocking devices. Those interested in consumer protection knew the ultimate goal, to eliminate and block spam, but as soon as they created a product designed to do just that, the spammers evaded their efforts by getting more creative. That is, until modern anti spam software was developed. Antispam software comes in a variety of forms, with the obvious ultimate intent of stopping unwanted emails from reaching you.

Blacklist

One of the primary anti spam methods is known as blacklisting. This software identifies the IP address of the spam sender, and then communicates with the Internet Service Provider of the sender and instructs the ISP to block mail from that IP address to your email account. In theory this is a fool proof solution. The reality, however, is that there is a lot of money to be made in spamming, so forcing a spammer to switch his IP address frequently is not too high a price to pay to evade blocking. That said, this practice does, over time, start to close down doors to spammers and all but eliminates amateur spammers who do not have the capability to frequently switch IPs.

Spam Votes

Many individuals who frequently use their email accounts will be familiar with this device. Spam voting software works through the participation of users. When you receive email you have the option of classifying it as spam, usually by pushing a button which says, unsurprisingly, ‘spam’. Once enough people classify a piece of mail or an IP as spam it falls in trust until ultimately it becomes completely blocked from addresses.

Profiling

Profiling involves learning the common characteristics of spammers and spam mail. It is software that looks for things like bugs, invalid message ID’s and other traits and uses these characteristics to evaluate incoming pieces of mail. Each piece of mail is then given a score depending upon how it fares against these criteria. The user is then given the option of how high or how low to set the bar with regard to which emails are let in. This method has been shown to be immensely effective against amateur spammers and many professional spammers. However, it relies upon a ready team of professionals to identify new traits used by spammers and to incorporate those traits into the profiling algorithms.

Bayesian Filtering

The most promising spam blocking software follows no rules. Rather, it constantly learns new techniques to fight spam by scanning the mail you’ve read and comparing it to the mail that you have rejected. This highly sophisticated software uses the data that it gleans from thousands of users to identify which items are spam and which are not. It then has the capability to adjust its standards to your particular preferences. Over time, it becomes adept at sending you only the emails that you want, and blocking the emails that you do not.

Sara Anderwahl recommends that you visit http://www.barracudanetworks.com for more information on anti spam software.


previous page