Wednesday 24 October 2007

Microsoft CRM Messaging through Lotus Domino eMail Server - Balanced Solution

Microsoft CRM and IBM Lotus Notes Domino seem to be taking completely different paths and if company is Microsoft oriented - we see MS CRM, MS Exchange, MS SQL Server, SharePoint, etc. In the case of Lotus Domino - it is opposite - Lotus is corporate Information Media and could technically play CRM role with internal messaging coming through Lotus Domino server. However realities of modern corporation give us multiple examples when Microsoft CRM and Lotus Domino should coexist in compromise. There are several reasons why corporation doesn't like to stick to one platform:

1. Balancing several platforms not to be trapped to the one-vendor solution. Imagine, that you placed all the eggs into one basket and then this basket went into the trouble (lawsuit, bankruptcy, mismanagement, hostile takeover - to name a few in the life of the modern American corporation)

2. Legacy-dependence. If your corporation uses such product as Lotus Notes/Domino for 10 plus years - you can expect that majority of documents are stored in the Lotus databases. Just conversion of this legacy database is multi-million dollars project. And again - we could not predict the future accurately - who will win or lose - IBM or Microsoft - or maybe they will merge

3. Procedures and flowcharts. Nowadays corporation works and builds its business model around computer business system, consider things like users training, functional flowcharts/diagrams, reporting to investors, IDE with company vendors and customer. And we'd dare to say that these things are computer application platform dependent (even being designed in the heads of corporation founding leaders as abstract business processes - then they were placed into the computer platform and had to fit to its pluses and minuses)

Considering these arguments and having multiple requests from Microsoft Business Solutions and directly from our prospects and customer, we have realized the connector, which allows Microsoft CRM use Lotus Domino email server with similar messaging functionality as Microsoft Exchange 2003/2000 Microsoft CRM Exchange connector needs to be installed and its DLL based functionality is superceded by our own DLL, which communicates with Lotus Domino server via Java Agents

You can always have us help you with the integration and customization. Call us: 1-866-528-0577, 1-630-961-5918.

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, serving clients in Chicago, California, Texas, New York, Georgia, Arizona, Louisiana, Michigan, Florida, Canada, UK, Australia, South Africa and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

Linux for Home Users

Hey Guys! Don't raise your eyebrows or fear by hearing the word Linux. It is as user friendly as windows. Just take a look at the articles below and all myths about Linux in your mind will disappear.

Introduction to Linux:

It's a free operating system available to download but you have to pay a tiny bit to mail order it or buy it from a company. Linux came into being about 11 years ago- it was developed by Linux Tornados of Finland along with a group of programmers from the open source software movement.

Linux is growing steadily year after year. With a passionate community backing it, with big companies Like IBM and HP pledging their support for it, it's no wonder Linux- the wonder operating system for servers of the past, has also made it to the desktops of today.

Linux is based on the commercial OS, UNIX. All the operating systems try to pack in command line management of systems. System administrators of companies use command lines all the times as their lifeline, but it's not really meant for regulars users.

Tips for Home Users:

* If you want to get comfortable with Linux, you don't have to let go of windows. Get Linux installed on a separate partition and you can switch between Windows and Linux. For new users who don't have any computer background learning windows or Linux both takes same time and sitting.

* It is suggested that new PC buyers should get both operating systems installed and should use them equally. If you're getting Linux for more than 2-3 PCs, you can also get training and support at a small free, if you choose to have it. Else it's the Linux community on the Net to your rescue.

* You don't have to be a great computer user to work with Linux. There are Desktop environments that let you work in Linux as you work in Windows. As you work with windows, same is the case with Linux.

Linux hands in decreasing PC prices.

PC prices are already on their way down. And you get more choice with operating systems and applications. From being an OS only computer professionals had heard about, Linux, in a short time, has made a transition into the lucrative and high profile home PC segment.

The PCs bundle the operating system. Linux being a free open source operating system means that the code that runs is open for everyone to see, work with, modify and develop their own innovative applications for it. But this is nothing compared to the money people spend on Operating Systems like windows. And a company bundles Linux and applications based on it with a computer, quite a bit of the PC cost comes down. Presently some branded PC's coming with Linux are available for Rs: 25000/- onwards.

Linux is better than other OS

Linux users won't even bat an eyelid before they say an emphasis comes from a deep dislike of Microsoft's practice of changing the earth for software. But a lot of it comes from the fact they are ready to swear upon-that Linux is more stable. According to a latest survey Web Hosts are using Linux Based Servers for hosting purposes.

One note here though: the free in Linux stands for freedom of choice, to redistribute, to install a feature, freedom to modify the source code. That's the spirit of Linux being free.

Security:

Linux has a better security support for multi-users, lets you set up a stable server, internet gateways etc, and still lets it-self to be used as a desktop workstation. There are no blue screens and no viruses to speak of. It is rarely attacked by any viruses and there are very less number of viruses written for Linux. It can be given 10+ points on a 10 point scale for security.

Myths about Linux

Installation:

Linux is hard to install, isn't it? Not really. Most people haven't ever installed Windows on their computers either-since it comes preloaded. Linux is as easy-some say easier-to install compared to Windows. You can install it through a graphical user interface like Windows. These days Linux Versions are easier to install than Windows. But what really stumps most people in installing Linux on a second partition on their hard disk, when they want to be able to use both operating systems.

A partition is a way of organizing space on your hard disk by creating virtual sections that are separate from each other. Most computers that are running Windows or MS DOS have one large chunk of space holding the OS. This space is the C drive. If you have a large hard disk, it's likely that it has been divided up into smaller bits called partitions to help you organize your data better. These partitions are usually called D:, E: etc. you could have Linux on any of these.

Windows 98 creates a file system called FAT32 on the entire hard disk, DOS and Win95 use FAT16. Linux has many file systems-on the most popular is ext3. But you could have Linux installed on Fat32 partitions also.

Linux is very difficult and based on text command

Linux has come a long way from being the system of brilliant computer users. It has extremely advanced X Windows systems that have a complete graphical user interface-you know, like Windows. It also has a large number of window manager that let you work with different levels of customization of your desktop.

Linux has a robust character-cell interface where commands need to be typed in. x Windows is a free program that runs with Linux to provide a GUI where the mouse and keyboard can be used extensively. But the X system itself is quite primitive and needs a window manager, or a desktop environment- like GNOME or KDE- to be really usable. Window managers are programs that let you interact with the underlying X system and Linux OS by relaying commands. The popular window managers are Sawfish, Enlightenment, Black box, after step and Window maker.

As for desktop managers, they have their own window manager and other tools that make you feel that you are working in Window! GNOME and KDE are the most popular of these. GNOME stands for GNU Network Model Environment and KDE for K desktop Environment. They have tools that allow drag and drop, have panels and taskbar- almost like clones of windows.

Hardware compatibility problem and few applications that run on Linux

Well, most new distributions will detect and configure your hardware in a jiffy, unless you have some really old or exotic piece of hardware. All hardware are properly detected and their drivers installed. Only Win modems (internal modems driven by Window drivers) face problems.

As for software, there's plenty. And most of it comes free-free for you to use, modify and configure according to your needs. Almost all excellent software for Linux is free and you don't lose anything by giving it a try. You get free support on the Net quickly on any query you may have. And you don't even have to wipe out your Windows. Just get Linux on a different hard disk partition and free to switch between them as you please.

Other packages are commercial and you have to buy the software-but this is mostly for the software and training you need, and not for the software itself. Sometimes, if you have the Windows version (as a doom) you can download a small program that will allow you to play the game in Linux. The games in Linux are of very high quality and features. You'll enjoy them. Here what's available?

Office suites: Star Office, Open Office, Applixware, Corel WordPerfect

Graphics: GIMP, Corel Photo paint

Music: XMMS, Free amp, Real Player

Video: MTV, Xine

Games: FreeCiv, Tux racer, Doom, Quake, Heretic, Unreal And the list is growing.

Linux varieties for Home Users:

If there are so many people working on it. There's likely to be many Linux versions too. Many companies working on Linux have come up with what are called Linux distributions. There are Linux versions that are compiled and packaged and released with additional software.

RedHat: Probably the most popular and in many ways the leading version. It's currently in version 9. The installation and configuration is easy. A blue curve file manager and the default GNOME desktop make it look simply stunning. It comes with a host of tools that allow usage as a server and as a workstation. The Red Hat Package Manger(RPM) format developed by Red Hat has almost become the defector for software distribution in Linux world. Installing new software is a breeze. It also has an advanced and easy font management system that makes fonts in X Windows look cool.

Mandrake: Mandrake Linux is now in its 10 version. It can be installed on a native Windows Partition using the Lin4Win tool, but this may slow the machine down. It also lets you do a traditional Linux install into its own dedicated partition. Mandrake's configuration and software installation is painless. It follows a slightly modified RPM architecture called mdk.rpm but most Red Hat software can also be used for Mandrake. The outstanding feature in this version is the collection of window managers-eye-candy freaks will have a great time.

SUSE: From Germany comes the Chameleon, SUSE. Now in its 8.x avatar, it has one of the most extensive software packages compiled, and getting them installed is easy with yast (Yet another Software Tool) which gives a centralized interface from where you can pick and choose the software to be installed. Among other things, SUSE comes with some stunning 3D games that showcase Linux gamming prowess

Corel/Xandross: Corel entered the Linux market with Corel Linux a few years ago. Now it has merged into Xandross OS, which is based on Corel Linux. This is a Debian-type version, and can be installed without much fuss after resizing the Windows partition. Xandross contains Crossover office, which is a refined retail version of WINE that lets you install and run many Microsoft apps.

Windows applications in Linux

Some applications have been ported over to Linux, other run with a program called WINE (Wine is Not an Emulator). Crossover, commercially available software also lets you use your Windows programs on Linux. VMWare is another program that lets you run Windows under Linux. Now many software companies have started developing high end software for Linux.

Bottom Line:

The cool thing about Linux is that most software is free, and you can legitimately use them without worrying about piracy. If you're worried that Linux won't look as pretty as windows can, all you have to do is check out some of the cool Linux interfaces and Window managers. But you don't find a lot of multimedia titles for Linux. And if you're into a lot of these, Windows is in the way to go. So if you have a PC that runs both, you can easily switch between the two, and get the best of both worlds.

About The Author

Friday 19 October 2007

Instant Messaging is a Sweet Way to Communicate

MSN messenger is a pretty cool invention. I mean I'm not really into serious discussions on the email, answers to questions can often take a few days to arrive because people are so busy these days. I've just been 'hooked up' into Messenger and it's really a different kind of communication, quick, simplistic and even humorous with the capability to express your feelings with 'emotion' cartoons. With Messenger you can communicate with a group of close friends or business partners instantly whenever they are at their computer. When a message is received you are informed instantly on your desktop, you don't have to be at an email site. A little box appears flashing the name of the sender, you read the message and send a reply when you've got a second free. There's a contact list and when you go on-line, it automatically tells you who of your connections are on and off-line at that moment. If someone goes on-line after you've already been at your computer, a small box appears on your screen to tell you who are now also instantly message able. It's like the spontaneity of a telephone call but you don't even have to dial any numbers! Just log in your password and you're connected. The huge array of smiley faces and other 'emotional' icons add another dimension to the conversations. Some of the smiley faces actually move (sticking their tongues out etc.) and there are many other symbols to express the moment. E.g.: Show a little sun when it's sunny in your neighborhood, flash a wilted rose when your love life isn't going to well, put up a black sheep when you're feeling disconnected from society. How about expressing your dream of a holiday by flashing up the tropical island icon when you're stuck in dreary office working hard on a cloudy day. They say a picture speaks a thousand words? Well I certainly don't work for Microsoft but I guess Bill Gates and his buddies have made a few bucks because they've had a couple of good ideas. They're helping the world with their knowledge, and I reckon their MSN Messenger is another step forward in bringing the Earth together into one world. Besides the normal email format you can also have web cam and audio conversations, as well as sending files and photos instantly. It's as sweet as that first time you kissed your honey bunny, well maybe not that sweet.

Thursday 11 October 2007

Microsoft Great Plains Upgrade - Version 8.0 Overview for IT Director/Controller

If you have Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customizations, ctree/Pervasive migration to MS SQL/MSDE. As of right now it is reasonable to upgrade to Microsoft Great Plains 8.0

Is upgrade required? Not actually, but you have to consider these factors
? Technical Support discontinuation - the old version may not be supported - currently if you are on version 6.0 - support is already discontinued. You can not have Microsoft Business Solutions help you, but obviously you have MBS partners who can still help you. If you are on Ctree or Pervasive SQL, then your support expires December, 31 2004.
? Tax Updates/Magnetic media expiration - if you have US Payroll module and depend on it with W2 and other forms - you must stay with the version, which is supported and has tax updates. If you are on Ctree or Pervasive SQL - then you will not have tax updates for these platforms at the end of 2004 and your W2s maybe inaccurate. If you have a lot of employees - you may have issues with government.
? Following the Technology and Microsoft rules - Microsoft wants you to be on the newest platform and provides you the best support when you follow this rule
? If you do have heavy customization - we recommend you to skip one version, for example if you are on version 7.5 - do not upgrade to 8.0 and wait for the next version

What is upgrade in the language of technology? Upgrade has server and client sides.
? Server side - upgrade converts tables from old format to the new one. In general words - Microsoft Business Solutions developers may change table structure, append additional fields to add new functionality, things like that. Upgrade copies the table with changes to temporary table, then drops original table, recreates it with new structure and copies all the data from temp table to the newly created one.
? Workstation side - workstation is written in Great Plains Dexterity and has Dynamics.exe - engine and DYNAMICS.DIC - dictionary. These two plus all the additional files will be replaced with the new ones. Other dictionaries, such us REPORTS.DIC and FORMS.DIC should be also upgraded and upgrade will try to deal with them automatically. In some cases modified reports (in REPORTS.DIC) could not be upgraded and need to be recreated in the new version.
What is customization upgrade? You should consider different types of customizations: Dexterity, VBA/Modifier, SQL, ReportWriter, Crystal Reports
? Dexterity Customization - being very short - Dexterity may have so called Custom Forms - these do not need upgrade - they should work as is. Then Dexterity may alter existing Great Plains forms (so-called Alternate Great Plains forms) - in this case Dexterity customization should be redone for these forms/screens. Plus additional consideration should be given to Dexterity triggers, shadow tables, etc.
? VBA/Modifier customization - Modifier allows you to modify existing Great Plains windows - it creates so called modified Great Plains windows, stored in FORMS.DIC. Usually modification is placing new buttons or fields, which in turn will be given VBA scripts (stored in DYNAMICS.VBA). VBA scripts may call something nice, like Crystal Report, or have some data access logic. Usually the old version of DYNAMICS.VBA workds with the new version. You may need to rearrange buttons on the modified form.
? SQL - you may have some stored procs for data integration, EDI or the like - if the addressed tables will be changed in the new version then you need to analyze your SQL code. The good news is - Microsoft Business Solution doesn't make a lot of changes since version 7.0, because Microsoft is now trying to merge the products it owns: Great Plains, Solomon, Navision and Axapta - and so has different priorities
? ReportWriter - MBS doesn't change tables, but it keeps changing Dexterity formulas used in ReportWriter original reports - this is the problem in so-called Modified Reports upgrade - usually you have these reports modified: SOP Blank Invoice form, SOP Blank Picking ticket, etc. If report can not be upgraded - it should be redone in the new version with some exceptions.
? Crystal Reports - the nice thing about Crystal Report - id doesn't need to be upgraded (if the fields in the tables exist in the new version - which is usually true statement)
What is upgrade for third-party modules? Your Great Plains may have so-called third party modules: Mekorma, Kampdata, Horyzon, Wennsoft, Avalara, Truepay, Trinity, Intellisol to name a few
Third party modules may have their own utility for upgrade. You just need to know that your third-party is ready for the new Great Plains version - if not - you just wait and stay on the old version.

What is migration from Ctree/Pervasive.SQL 2000 to MS SQL/MSDE? MBS has migration tool. You need first to install Great Plains on SQL Server with exactly the same account/segments structure and then install migration tool (it is Dexterity chunk) on your ctree/Pervasive workstation - then, when you integrate the chunk - you will map it to target SQL-based Great Plains Company, select all system and company tables, click the button and it will move all your tables one-by-one. In the case when your Great Plains ctree/Pervasive has third parties - you need to check if the vendor has migration tool - otherwise you have to do manual move, use SQL Linked server to your legacy data

Do I need consultant? It is probably good idea to have consultant to do the upgrade. We strongly recommend you to use consultant in the following cases
? You have Dexterity customization
? You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, especially when you have third-parties without migration tools
? You have a lot or ReportWriter Modified Great Plains Reports
? You have old version of Great Plains: Dynamics or eEnterprise 6.0 or prior - in this case you can not appeal to Microsoft Technical Support - it is discontinued
? Your Great Plains has more than 20 users and you have to have upgrade done over the weekend - if it fails - you have business problems
? You don't have support - in this case you have to select your Microsoft Business Solutions Partner and pay for the annual support/enhancement plan - you will get new registration key and will be ready for the upgrade

Good luck with upgrade and if you have issues or concerns - we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, California, Colorado, Kansas, Minnesota, Texas, New York, Washington, Georgia and Florida and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

Troubleshoot Windows with Task Manager

Task Manager is a Windows system utility that displays the
tasks or processes currently running on your computer. To
open Task Manager, press Ctrl+Alt+Del. The Applcations tab
lists the applications currently running on your computer.
A single application may actually consist of several running
processes, and many programs that run in the background are
not listed (you can see icons for some of these programs in
the System Tray).

Note: With Windows 98 and Windows Me, Ctrl+Alt+Del will
open Program Manager, which allows you only to close
aplications. However, you can download one of the many Task
Manager utilities from the Web.

The Processes tab displays a comprehensive list of all the
processes currently running on your computer. This can be
very useful for monitoring your system. The process tab
displays information about the processor useage and memory
usage of each process. The problem is, how to identify a
process. Below is a list of some processes you may see in
Task Managers Processes list.

"System Idle Process"
"System" The Windows System Process
"SMSS.EXE" Session Manager Subsystem
"CSRSS.EXE" Client Server Runtime Subsystem
"WinLOGON.EXE" The Windows Logon process
"SERVICES.EXE" Services Control Manager
"LSASS.EXE" Local Security Authentication Server Service
"svchost.exe" Service Host
"spoolsv.exe" The print spooler service
"explorer.exe" Windows Explorer
"TASKMGR.EXE" The Task Manager
"regsvc.exe" Remote Registry Service


"System Idle Process" is basically another name for the
time when Windows is doing nothing. There are hundreds of
thousands of processes that run on a computer, so you will
definitely find names of many other processess that are
not listed above. For a list of well known processes,
visit www.answersthatwork.com/Tasklist_pages/tasklist.htm
You can also learn about almost any task by using it's
name as a search term in google.

Task Manager can also be used to tweak your system if it's
running slow. The Performance tab displays running graphs
of your computers CPU and memory usage. If the CPU usage
seems to be running over 80 percent most of the time, or if
the memory usage seems to be running higher than the total
physical memory, you may want to shut down some
applications or processes.

On the Process tab, you can identify processes that are
consuming a lot of processor time. Click twice on the CPU
column heading to sort the CPU column so the processes
hogging the most CPU time on top. You can sort the
"Mem Usage" column the same way.

On the Application tab, if you right click on the name of
an application and, in the popup menu that appears, choose
"Go To Process", Task Manager will open the Processes tab
and highlight the process that runs the application. On the
Processes tab, if you right-click on the name of a process,
you can choose "SetPriority" and promote the priority of
the process you need (or demote the priority of a different
process to free up some resources).

If you go to the Application tab and shut down an
application, you will shut down any processes related to
that application. Or, you might choose to shut down a
background process that you can identify. To shut down an
application or process, click on it's name in the list to
highlight it, then click on the End Task button.

On the Processes tab, if you right click on the name of a
process, you can choose "End Process Tree" to kill the
process and any sub-processes started by the process.

Task Manager can also be used for troubleshooting. If an
application freezes up, you can open Task Manager and shut
down the application. If the entire system freezes up, you
can use Task Manager to shut down a process that is hogging
all the CPU time or memory.

If you spend some time monitoring your computer with task
Manager, eventually you will become familiar with the
processes that commonly run. Then, when you see an
unfamiliar process, you can do a little investigation to
make sure it's not a virus. For example, if you see
msblast.exe in the process list, your computer is infected
with the Blaster virus. You might be able to detect and
eliminate a new virus before an antivirus update is available.

EMS SQL Management Studio for SQL Server

EMS SQL Management Studio for SQL Server is a complete solution for database administration and development. With components that focus on all critical database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering databases and managing database objects as well as for database migration, extraction, data import, export and comparison. SQL Studio unites these tools in one powerful and easy-to-use environment that can work round the clock. Whether you are a database or application developer, DBA or business analyst, SQL Studio for SQL Server offers all essential tools to make you more productive than ever before!
becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology – Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations. There are several reporting tools available and you definitely need to know which one to use for different types of reports.

If you are database administrator who is asked to import some data to Great Plains or repair or copy data from one company to another – read this and you will have the clues on where to look further.

1. Microsoft Great Plains Tables Structure – Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the proper series. If you are looking for the customers – it should be RM00101 – customer master file.

2. DEX_ROW_ID. This is identity column and each Great Plains table has it - this is due to the Great Plains Dexterity technology. This column is never used as a key field - so don't try to link your tables on DEX_ROW_ID. In case if you need to transfer the table from one company to another you should use these queries:

select * into GL00100_BAK from TWO.dbo.GL00100
go
alter table GL00100_BAK drop column DEX_ROW_ID
go
insert into GL00100 select * from GL00100_BAK
go
drop table GL00100_BAK

The set of queries above will transfer GL00100 (Account Master table) from TWO company into your current company. Then you need to run Checklinks - refer to GP Manual - in order to recreate the rest of the account master related tables.

3. Do not modify the table – sometimes it seems to be nice if you just append couple of extra columns to the table - like in IV00101 - inventory master file why wouldn't you just add couple of additional descriptions. If you do this - Great Plains Dexterity engine will fail reading all your items - due to the fact that DYNAMICS.DIC (main Great Plains Dictionary file) has exact description of all the tables and Dexterity uses it for reading and writing into the specific table

4. Feel free to create SQL views or stored procs. If you are helping your internal developers to create Crystal Reports - good SQL views are real help to them. Let me give you example, the view below will show work and historical SOP Invoices - then Crystal can just use it

create view SOP_WORK_HIST
as
select SOPNUMBE, CUSTNMBR, CUSTNAME, DOCAMNT from SOP30200 where SOPTYPE=3 and VOIDSTTS=0
union
select SOPNUMBE, CUSTNMBR, CUSTNAME, DOCAMNT from SOP10100 where SOPTYPE=3 and VOIDSTTS=0

The above view will show all the work and historical non-voided invoices (SOP Type = 3 stays for invoice)

5. Some repair / unlocking tips:

If you run query above against DYNAMICS database - it will unlock the user, who accidentally shut down the computer without logging off Great Plains:

delete ACTIVITY where USERID='JOHN'

Next one will unlock hanging batch:

update SY00500 set BCHSTTUS=0 where BACHNUMB = 'JULYINVOICES04'