Friday, October 24, 2008

Internet Chat Rooms: Are We Missign the Point?

In my short life, after years of talking too much, I’ve come to realize that if one is always speaking, one never listens. If you never listen to others, well, you’re limiting your access to a lot of knowledge and information. Recently, after much deliberation I thought I’d check out what the world of Chat Rooms is like. People talk to each other by text, voice, and web cam. This is a really big phenomenon; I wanted to see what all the fuss is about.

I expect there are many chat rooms where people with similar interests get to know each other, and share their perspectives on various aspects of life. These are great, much cheaper than telephones, and multiple, random people can chat to one another simultaneously.

But I speak the truth, and my preconceived ideas about mindless gossip from jaded humans were sadly affirmed as I arbitrarily checked chat rooms that supposedly discussed important subjects. It seems some people are just very bored, and want to be cool and swear on-line, insulting others, and giving this area of information technology a bad name. I think a lot of people are using the rooms solely for personal conversation that contextually no one else can understand.

I went to a chat room about religion, and then to one about tattoos and it seemed like the same people were talking. Most of the conversation didn’t even touch the supposed subject matter. It was definitely a disenchanting experience but hopefully with more research I hope to come across some serious rooms where the true intent of the creators has come to fruition.

I guess it’s good that bored people in our technological society have others to talk to. It means depressed adolescents may feel more connected to others and not so alone in the world, maybe even having a positive effect on a possibly suicidal youth. But, I do feel this nonsensical chitchat is a sign of our next generation’s apathetic view of present reality in our postmodern culture. When reading the text from a supposedly religious discussion, and hearing graphic use of derogatory terminology, I really have to wonder about the present spiritual beliefs of my culture.

I’m a true believer of the concept that technology is here to further the consciousness of humanity. Computers and the Internet can help bring all of us in the world together, thus evolving our society to the next level. After looking at chat rooms, I feel there is a need to integrate more wisdom and compassion into our ‘new world’ generation. Having the technology is great, but it is only one half of the equation. To make the Internet work properly, I think we need to instill the same faith we have in science, into a faith that encompasses the actual creators of the information and communication tools-humanity itself. We seem to realize that we can invent many great things, but it looks like we’re missing out on the great truth: that we ourselves are part of, and made of something great in itself: Life. (Existence!)

Tuesday, October 21, 2008

4 Easy Steps to Better Online Customer Support

Customer support is very important when you're running a business, whether your business is on or off the net. If your customer support is hopeless, you'll soon find your customers running away from you and worse, telling others to stay away too.

If you're like many of us out there, the last thing you want to do is to spend the whole day replying to customer support emails. Here are 4 easy steps to help improve your customer support and at the same time reduce the time you spend replying to queries. The trick here is to help your customers help themselves before you help them.

- Step 1: Start with a Knowledge base / FAQs

The first step to your support system is to set up a knowledge base or, if you have a quite straight forward product, a Frequently Asked Questions (FAQs) section. This will save you a lot of time. Your customers will also be happier since they can find answers to their questions immediately. If you're just starting out, it is still a good idea to set up a knowledge base/FAQs. Just sit down and think of all the possible questions that your customer would ask. Maybe not all. Start with a few and you can always add more to it as time goes by.

- Step 2: Set up a Forum

A forum is a great addition to your customer support system. The forum should be the second place your customer would turn to for help. A lot of people associate a forum to discussions, moderating, a lot of work and a headache to maintain. This is only true if you use a forum as a discussion area.

Instead, you should use it as a customer support tool. Just create different forum categories for eg., pre sale questions, member questions, one category for each product. A forum is an excellent way to provide customer support because:

* There is a search function for the customer to find related posts
* You could easily set up a forum for free. Most good web hosts now has a one click forum installation function.
* You don't have to worry about your replies being caught by your customers' email filters
* If you get a question you've answered before, just give them a link to the answer in another post.
* Usually, other forum members are willing to answer a question that they've managed to solve ... for free.
* Hiring extra help is as easy as adding a new moderator.

- Step 3: Install a Ticket help desk

Not all queries can be handled via a knowledge base and a forum. Sometimes there is a need for your customers to send you private information such as usernames and passwords.

When a situation like this arises, you will need a way for your customers to send you the information without others being able to see it. One of the best ways to handle this is to set up an online ticket help desk.

A ticket help desk system will allow your customers to create a user account and log a ticket into your system. They can then send whatever information they need to send. You can even allow them to attach files. Most good help desks will also allow you to prepare pre-written responses for repetitive queries.

Again, a good web host would also have some kind of help desk script installation available at a click.

- Step 4: Use a good email software

And finally, you have the good ole e-mail. Which should be the last thing your customers resort to. After implementing the above three systems, you will find a remarkably reduced amount of e-mails you need to reply to. Customers are getting wiser. Most know that e-mails are seldom replied to. So, they would only resort to this as a last resort.

Don't make a mistake of putting your email address on your web site. Use a form. With email filters rampant on the net, also remember to inform your customers that your e-mail may be trapped by their email filter.

There you go. Just set these up and you'll find your customer support a lot easier to handle.

Saturday, October 18, 2008

Blogs are an Art Form that Takes Practice to do Well

Writing…Blogs…Blogs are on-line journals where people express themselves through writing. Writing…Writing is the process where one puts down words of a language on a format that others can read. This process has not been around very long, to use one of my writing teacher’s favorite sayings, “Writing has only existed for one day in the one year that humanity has existed.” Speaking and thinking come much easier than writing. These processes just flow out naturally like a river of consciousness; sometimes we hardly have to think about doing them. Anyone and everyone can write words down on paper but that doesn’t mean it’s ‘good writing’, myself included. Like most things in life, our society already takes writing for granted which is proving to expose more of our ignorance. Writing is a new form of expression, and if we want to do it in a way that the masses can connect with our ideas, we have to think much more simply and clearly about this art.

Now that was quite a big paragraph, you’ve got to wonder if I really needed to say as much as I just did to introduce this article on the best way to write your blogs on the Web. I didn’t even mention this main idea, and that’s what an introduction paragraph is meant to be for. This is a common mistake in many blogs out there. We try to get too many ideas across in one paragraph, sometimes even in one sentence! The key, as in all things in life-is to keep it simple. Simplicity means that readers won’t get confused about what your journal entry is actually about. Introduce your main general topic at the start, and use the subsequent paragraphs to discuss separate ideas that relate to this topic. Try to tie everything up in the concluding paragraph, your main argument and the reason why you’ve written in the first place.

Grammar and sentence construction are not easy systems to master, especially if you come from a school system that spent more time telling you about historical battles and quadratic equations than on how to read and write. This is a real problem. When we speak we can get messages across to others easily, but if we put these words down on paper, the writing just isn’t interesting and doesn’t connect with people’s curiosities and fascination. When you write you are not talking to a close friend. You can’t use slang and colloquialisms that only your local community can understand. The aim is to connect with all the people in the world, so let’s make it crystal clear and enjoyable to read.

Your computer has spelling and grammar checks, as well as access to a thesaurus. Use them, but remember that the machine can’t decipher all the intricacies of language. Language is a world in itself, and much of its territories are undiscovered by the masses. So, again keep it simple. Short, precise sentences with single ideas are great. Many words in the English language have the same meanings (synonyms). Use the thesaurus so you don’t repeat the same word over and over throughout the text. It keeps the story fresh and doesn’t turn the reader off. There’s nothing more boring than repetition. Using different words can be a lot of fun and a learning experience, just make sure you use a dictionary (also on the computer/Internet) to make absolute sure of the word’s definition.

Readability…Simplicity…Make your blog accessible by all people. You can even take into consideration that many readers will have learned English as a second language. As I’ve said in previous articles, keep to the point-don’t go on tangents. Stick with the article’s topic, and definitely stay within the realms of your blog’s main area. If your blog is entitled “Jazz music”, people who go there don’t want to hear about how your football team won on the weekend! Please be consistent. How irritating is it to visit a blog that hasn’t been written on in months or years?

I hope these little tips will help you on your quest to producing ‘good’ writing that brings new friends and acquaintances of similar outlooks into your world. If you want people to read, the aim is to produce an emotional reaction in your reader. Pretend you are writing to another form of yourself, if it were not readable, interesting and fun…would you stick around?

Wednesday, October 15, 2008

Writing Good Blogs

There are a lot of blogs out there on the Web, most of which don’t entice one to go back regularly to read updates. What is missing from these on-line journals that would essentially make them ‘good’ blogs? Well, the answers in life usually come down to simplicities. So let’s look at the problem like we were children. Children don’t complicate life with miscellaneous information, and when they speak they tell you straight to the point exactly how they feel and think about a subject.

First of all, we should ask the questions,” Why do blogs exist? And what are they here for?” Well, in an ideal world ‘good’ blogs would help people connect, sharing knowledge and feelings about issues in life. As they are journals written by individuals we would hope that they’d be readable and open to comment by all other people, not just a select group of friends. The key is speaking in a way that is understandable by the masses, get rid of acronyms and local slang that only few will comprehend. Keep the sentences grammatically simple and generally short and concise.

Try to write in your blog as often as possible because if people enjoy reading your thoughts and ideas they’ll want to communicate or at least be filled in regularly on ‘your world’. Ask questions, comment on other blogs of similar content, start communities with others you’ve never met, based on your interests. Keep focused; if your blog is about thoughts on war and peace, keep your thoughts on the latest movie and how hungry you are for somewhere else. The idea is to incite intelligent communication so that in time our collective stockpile of knowledge and wisdom will gradually grow like a tree in fertile soil.

I think of most importance is the fact that you want this journal to be ‘good’ reading. Of course we all have ideas about what genres and styles we like, but writing from your heart and soul is imperative for the connection with others that you’re looking for. Share yourself; don’t hide behind walls of fear of ridicule and judgment. In real life relationships trust, respect, intimacy, and unity are all necessary for a bond to form. It’s the same in the ‘virtual’ world; people want to hear from real people-not just one-sided, highly opinionated arguments from egos that don’t want to hear the ‘other side of the coin’.

Now, in my last article I really tore apart most writers out there, and here I’m giving some pretty complex ideas on how to fix the problem of ‘bad’ writing. In my next article I’ll attempt to go back to the simple basics of how to write for beginners. I hope I haven’t come across as too judgmental, I just truly believe the ‘blog world’ could become a real asset to humanity, and at the moment it’s missing the mark.

Ideas about sentence structure, grammar, paragraphing, using a thesaurus (varying terms used so as not to sound repetitive), whether or not your blog is suitable for a personal or professional approach, are all important to creating a simple and enjoyable read for the blogging visitor. If you are a beginner, please check out

Monday, October 13, 2008

The Problems with Blogs

What in the world is up with the world of blogs? Blogs are meant to be this great new technology where people can share their ideas and interests with others around the globe. As far as I’m concerned the state of blogs is one of chaos, confusion, and anti-interactivity. The other day I decided to do some research on the Web and try to connect to some blog writers out there that interested me. Let me tell you it was not an enjoyable task as I had envisioned. I spent four painful hours surfing through around a thousand on-line journals, and I found only a few that interested me. What are we doing out there people?

First of all, just getting to a blog can be a pain in the arse. For example, you type in the words ‘Philosophy blogs’ and a whole bunch of sites come up. Some are conglomerate sites with thousands of journals, but the area you’re searching for may have only one blog in it! This is because they separate the blogs into a million different categories, like ‘love’, ‘lovers’, ‘lovable’ etc. Why not have just a few main categories to choose from?

The next problem is the content. People with ‘philosophical’ blogs are having personal chats with their mates about the local dance competition on Tuesday! Why not go to a chat room if you just want to talk to your friends? Blogs are supposed to be a personal viewpoint expressed to the whole Web community. Wouldn’t you actually like to meet more people like yourself? How is this going to happen if you talk in strange uncommon slang and acronyms that you and your friends can only understand? Please stick to the subject at hand, and take it at least half seriously.

Another major problem is the fact that you can find a really cool blog that sparks an interest, but then find that the writer hasn’t added an entry in over a year! What’s it doing on the Net? Have these people passed away? I seriously doubt it, as there are so many blogs in this ‘lost’ state. Having a blog is a responsibility; it’s a shared diary for the whole community. How can someone form a relationship if you only write in your blog once a millennium?

Back to the subject of content: These on-line journals are a real chance to communicate regularly with others with similar views to yourself. We can learn a lot from each other, as each human is an individual with special traits and skills that only they have. So why do we see so many blogs just talking about trivial nonsense like ‘Who the coolest movie actor is.’ Humanity is an intelligent species evolving everyday towards a higher consciousness. So where are all the thinkers out there, the people who have taken us to the next levels of spirituality and scientific exploration? I’d really like to hear what you’ve got to say, but all I can find are philosophical beliefs on why died pink jeans express one’s true inner self.

The issue of making comments on someone’s blog is also a controversial one. Why have comments sections if you’re not going to reply to people who have expressed an interest in what you’ve had to say? How is this community going to function if all the conversation is one-way! Come on people, wake up and smell the onions! Let’s change the blogging community into the awesome structure of shared knowledge that it was intended for. Please don’t let it turn into the small-talk world of chat rooms.

Friday, October 10, 2008

Blogs Are About Getting to Know Yourself Better

I still consider myself to be a blog writing novice but as I’ve got a few entries under my belt I can tell you about an unexpected bonus of this journaling process. A lot of people think that blog writers are just people who are tooting their own horns blabbering on self-righteously about what they believe to be true in life. On the contrary, for me writing a blog has helped me to reflect on my experiences that I may have otherwise have forgotten if I hadn’t written them down. It has become a process of self-actualization, whether others have read my thoughts has become less of a priority for me.

When I read over my past entries I am surprised to hear about thoughts, ideas, and wisdom that is quite relevant to my present experiences. It’s like I already knew some of the solutions to my problems in the present, but I still had to go through the experiences to actually have this knowledge become truly learnt. I also find it rewarding in both the respects that I get to ‘relive’ certain moments in my life, and I get to analyze my previous thoughts. This analysis often leads me to new ideas that I couldn’t see clearly when I was in the original moment.

‘Reliving’ past experiences by reading old journal entries can be a powerful experience indeed. You can be transported to the moment in time you were writing about, as well as the moment and feelings you had when writing the blog entry. Experiencing these events and feelings again can be a really enlightening process, especially if the emotions you had were strong ones.

An example of this from my blog www.thepowerofeverythingthatis.com is a recent upheaval of emotions I wrote about when a young lady I’d been dating and really started to like a lot told me she didn’t want to kiss me anymore. Now when I read this entry I can feel those same painful feelings, but in a new light as the time has passed and I’ve moved on. It gives me hope in understanding that all feelings pass, and also in the knowledge that all things happen for a reason. This knowledge I couldn’t see at the time as I was totally enveloped by my agony.

These insights into past feelings and thoughts have been an eye opener for my self-introspection process. I think the blog can give you the chance to get to know yourself better, something all humans could find beneficial. All of us are on quests to find out who we are and why we are here on Earth. The blogging process might just be another avenue for people to find out who they truly are. Keep on writing my friends!

Tuesday, October 7, 2008

Could there be a new way of hearing the news stories we feel are relevant in our lives?

Mainstream media has become a single-minded authority on how we should perceive life. Theirs is a negative perspective. Could there be a new way of hearing the stories we feel are relevant in our lives?

If you’re anything like me you are really getting tired of the mainstream media’s one-voice-to-many analysis of life on Earth. First of all, it’s just too negative! I read a survey recently that stated that fourteen out of fifteen newspaper and TV News stories had negative fear-based stories. I don’t know about you, but if I look at my everyday life, the amount of good and bad I experience seems to be much more balanced. Why does the ‘big’ media think we all love hearing the dark side of things so much?

If you look at what news stories truly are in historical terms, it is a person sitting around the tribal campfire at night telling a tale to inform the people both in wisdom and knowledge. In any tribe there were many storytellers, so different perspectives were always available to the masses. Well, if you think today’s media sources are too monopolized in their power of authority over the stories we are told, there’s a new option for humanity. The answers and views we are seeking in our daily lives could lie in the Internet. This Internet thing really could be the key for humanity to evolving into a species that thinks independently, leaving this age of fear behind.

It’s time to bypass the main media sources. On the Web we can access non-profit news organizations, we can hear personal views of individuals in news forums and blogs, we can even express our own views on world issues as well as sharing our own personal experiences! With this newly accepted technology called RSS Readers we can start to get the type of information that we feel is most relevant to ourselves as individuals. It comes straight to us and then we can sort through it and decide which people and sources we want to hear from on a regular basis. This is awesome as it means we don’t have to search through a bunch of stories that have little interest to us. It also means if we want to hear more positivism, we can push the negative views out of our perceptions.

Although this idea is in its infancy, the repercussions once realized could have a mammoth impact on how individual humans see and live their lives on Earth. Imagine a society that stretches across the globe where a collective consciousness speaks to itself in an informative many-to-many communicative process. There are a lot of happy, positive, intelligent people in this world who are interested in similar things to you. Wouldn’t you like to hear their stories and share their knowledge as a way of constructing your view of reality?

Let’s leave behind this era of negative perspectives and singular authorities telling us how life on Earth should be viewed. It is interesting that some of the most over-wealthy, greedy individuals media moguls who tell us what is important. Don’t you want to have a say in how you look at your life while you are here? Positivism and wisdom surrounds us at all times. Would the Universe exist otherwise? Lets reconnect with that source of energy that makes us smile so many times each day. If life were meant to have so bleak an outlook, would there even be stars in the sky?

Thursday, October 2, 2008

ICANN-Registrar: kr-domains for anybody

The kr-domains belong to the popular domains in Asia.

ICANN accredited Registar Secura announces today, that the company can register now kr-domains for anybody. Secura can register a co.kr-domain or or.kr-domain at once, if the domain name is available. It is not possible to register directly at .kr.

Korean domains can officially only be registered by Korean inhabitants or companies. But we Secura has find a way, that anybody can register Korean domains. Your datas are even published officially in the WHOIS as owner.

Tuesday, September 30, 2008

Microsoft Great Plains - typical problems and fixes – overview for IT Administrator

If you have Microsoft Great Plains and support it for your company then you need to know typical set of problems you have in Great Plains and their fixes to have Great Plains run smoothly in your company. We'll describe techniques applicable to Microsoft SQL Server as well as to legacy platforms: Pervasive SQL.2000 (btrieve) and ctree. The last Ctree/Pervasive version is 7.5. New Microsoft Great Plains 8.0 is for SQL Server/MSDE. You should also know that Great Plains as well as Small Business Manager is written in proprietary Great Plains Software language/environment: Great Plains Dexterity, which has Dynamics.exe and Dynamics.dic files as the core of the Great Plains workstation.

How to delete the user? This is the first problem you encounter - when user shuts down the computer - Great Plains doesn't have the command to log off the user and when user tries to login the next day - she gets error message that user is already logged on. The fix:

* Microsoft SQL Server - open SQL Query Analyzer, switch to DYNAMICS database and run the following script: DELETE ACTIVITY WHERE USERID='KATHY'.

* Pervasive SQL/Ctree - if you have more than one user registered you can delete the user from GP: System->User Activity->Delete User. If you like to work on the file level - ask all the users to log off. On the server, where you have your Great Plains files structure - DYNAMICS is the root, in SYSTEM folder delete ACTIVITY.* files

How to unlock the batch? This happens when user posts the batch and has her computer crashed (via surfing the internet - smile - or things like this)

* General tip - Great Plains recommends to logoff and then login back with the same user id. Then Great Plains will prompt the user to recover posting batch. Unfortunately it doesn't work in 70% of the cases

* MS SQL Server - the batch record is stored in Batch Header table: SY00500 in the company database. The fields to clear are: BCHSTTUS and MKDTOPST. In some cases you have to delete the record from SY00800 from DYNAMICS db.

* Pervasive/ctree - you have to install ODBC driver for Pervasive or Ctree and hook the tables: SY00500, SY00800 with Microsoft Access - use linked tables technique

Now we would like to stress you the need to move away from Pervasive SQL 2000/Ctree platforms - you are in trouble - Microsoft Business Solutions cuts technical support for Microsoft Great Plains 7.5 and prior on these platforms. This means not only the support, but also tax updates (especially Payroll and Federal Magnetic Media).

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 eEnteroprise 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

Sunday, September 28, 2008

The House Of Print.Com

Publishing has always been a difficult business to promote successfully, which titles by which authors to promote, which genre, will it be fiction or non-fiction? Will they sell? Will they make money, both for the publisher and for the author? So many questions which there is no definitive answer and so the publisher takes a chance with his money and his time and resources and decides on which books to publish, promote and distribute to the bookshops. He may only distribute to bookshops in his own country and if they don't sell well enough, will not be seen by anyone else in the world.

What a loss to humankind and their quest for more knowledge to enhance their work, their lives.

The fount of civilisations knowledge were always universities, libraries, and bookshops, and if publishers don't find it profitable to publish certain titles at all, to distribute to university libraries, and bookshops, then civilisation is the poorer.

When I was young going through school the public library was a must to enhance my knowledge of the world around me, it filled the gaps in my science, geography and literature lessons, and gave me new insight. I often gazed in awe at the rows of shelving containing all the worlds knowledge which had been written up by scientists, explorers, academics, and others, and oftentimes, you would have seen me taking an armful of books home to read at bedtime, anything from how atoms work, to famous authors tales of pirate treasure or tales of Victorian London.

The young people of today have all this technology at hand, not only at school, but in the home as well, they are only a mouse click away to the fount of knowledge, but in digital form on the internet. Many students believe that if a book is not on the internet it does not exist, and they would not waste time going around to the local bookshop on their High Street to enquire about it.

It behoves, therefore, all authors, publishers and booksellers, to at least put a synopsis of their books on the internet so at least letting peple know they exist, and where to obtain it in print or where to download it from. Many books are now downloadable, but they are published only by technology enlightened individuals, not the large publishers.

Even prints can be obtained from such e-books, the technology has advanced that far. It needs the willingness of publishers and authors to add value to this new fount of knowledge. The first great library was established in Alexandria, in ancient Egypt by Ptolemy, but it was burnt down later by invaders, and all manuscripts were lost. What lost knowledge we could have gained we do not know, for there was often only one copy made on papyrus scrolls and no other copies ever made. With the internet and the enormous computing capacity we have, there would be countless copies of e-books online for instant download, and therefore new knowledge, and works of great literature, need never be lost, for they are so easily replicable and distributable to a potential audience of three billion people on this planet.

Modern man, and woman, now looks for information on the internet, they no longer go to bookshops looking for it, with the enormous capacity available, all information should be on the internet including all government information.

The fact that retail sales of printed books have been falling off over the last few years means that publishers, and authors, have got to get with the new technology - we no longer use papyrus scrolls.

Thursday, September 25, 2008

Microsoft Great Plains Dynamics on Pervasive SQL.2000 data repair – overview for Database Administrator

Up to the version 7.5 Microsoft Great Plains, and if you are looking to version 7.0, 6.0, 5.5, 5.0 or 4.0 - then it was Great Plains Dynamics were available on Pervasive SQL.2000 or Btrieve. I am confident that majority of database administrators know how to do data repair via Transact SQL query if you are on Microsoft SQL Server 2000/7.0, but I would like to help these ones, who have to support Microsoft Great Plains on Pervasive SQL.2000 or Ctree. Some introduction into Great Plains Software products, now Microsoft Business Solutions. Microsoft Great Plains 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 DYNAMICS.DIC and runtime DYNAMICS.EXE), 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.

If you are database administrator who is supporting the version on Pervasive SQL.2000/Ctree – 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, account master file - GL00101, Sales Header Work file - SOP10200 - and you got the idea.

2. Use Microsoft Access. Lunch Microsoft Access and make a link to Microsoft Great Plains tables. This will allow you to do data modification/repair. Some people are trying to use Pervasive control center - we do not recommend this - MS Access does job better.

3. Locked batch repair – unlocking the batch, which was interrupted in posting. The tables: SYoo500 - batch header - you need to change Batch Status or Marked for Posting field

4. Activity table - If you have user locked in Great Plains - just ask all the other users exit and delete ACTIVITY.BTR (Pervasive) or ACTIVITY.DAT (Ctree)

5. Crystal Report link to Pervasive/Ctree - you have to install Pervasive SQL ODBC driver from Great Plains Dynamics CD. This will allow you to deploy ODBC connection to Great Plains database

6. Sometimes you have to rescue to Great Plains Dexterity - when you need ongoing data import and you do not own Great Plains Integration manager or when Integration Manager doesn't have the object to deploy. This is proprietary Great Plains Software tool and development environment and you need some time invested, before you can do programming.

7. Complex Data Migration - use MS SQL Linked Server - you can create linked server to Pervasive/ctree and then you can create the cursor, coming through all the tables in your migration set - we usually recommend reading tables schema in MS SQL Server (it is the same to Pervasive) and pull the data from Pervasive database using EXEC statement in Transact SQL.

Happy data repairing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Monday, September 22, 2008

Microsoft Navision Customization Upgrade – tips for Programmer/IT Specialist

When Microsoft bought Navision it had the plan to take over European market of Business Applications. Now Navision has multiple installations in US and it is very good fit for mid-size manufacturing companies. Currently Microsoft Business Solutions is on the way of creating so-called suites: Microsoft Financials, Microsoft Distributions, Microsoft HR, Microsoft Manufacturing. It is very difficult to say which product will be the core of which suite, but the best guess is this: Microsoft Great Plains - Microsoft Financials and probably Distribution/Supply Chain Management and HR, Solomon - Microsoft Project or Professional Services, Navision - Microsoft Manufacturing. If you have Microsoft Business Solutions Navision and support it for your company then you need to know some technical details about Navision version upgrade and what is going on behind the scenes, which options do you have in case of C/SIDE customization or Jet Reports.

The challenge of Navision Upgrade This should be understood by both: software developer and company executive.

• One Dictionary - in contract to such product as Microsoft Great Plains, where customization goes into separate dictionary - Navision customization sits in the same dictionary. This means that when new version is out there - the customization should be re-analyzed and moved from the old dictionary to the new. If you remember the history - Navision actually merged several dictionaries couple of versions back - this was very tough time for customization upgrade

• SQL Server side - from this side upgrade is smooth, because Navision doesn't use complex SQL functionality and SQL Server itself is rather data storage.

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 C/SIDE customization or any customization for your Navision

• You have a lot of custom Jet Reports

• Your Navision 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

Thursday, September 18, 2008

RSS Reader is a life raft saving us from getting lost in a sea of useless information.

One of the main problems with the Internet these days is the fact that there is so much information out there; it can be quite hard to find the particular knowledge that you’re looking for. It can often feel like you’re surfing waves of thick chocolate fudge sauce and your honeycomb board has a crack that’s getting wider by the second. Over stimulus is the issue here; you wanted to read opinions from music enthusiasts about music, and every second blog article had to do with new punk hairdo trends and which band has the coolest tattoos. How can we find only the content we’re looking for without getting bogged down in miscellaneous information that erodes both time and patience?

The answer is in context. There’s now a way to sift through the cacophony of babble and wisdom to find exactly what you’re looking for. Instead of having to join clubs and organizations and receive their newsletters via email at their convenience you can now have control over what you receive. Having to search through millions of blogs to find the few you like has now become an obsolete task. The new system is called an RSS Reader: ‘Rich site summary’ or ‘really simple syndication’ are the common definitions of this software. The process begins by signing up to receive automatic updates from blogs and other Web sites that distribute summaries of their latest postings to your reader. You then find which ones you like and delete the rest. You can keep adding new sites until you have literally hundreds of informative connections in your areas of specific interest.

Another great aspect of the RSS Reader program is the fact that you can put in key words of interest and the computer will surf the Web for you and add new blogs and web sites to your list, rating them according to the terms you have selected. You then scan over these and add the ones you feel are relevant, deleting the detritus. Eventually you will have an email-style formatted file where you can search through all your favourite writers, news, and topics’ latest information. Then you also have functions such as ‘comment’ so you can automatically share your input with your fellow humans. Or, you can reply to the ‘messages’ and actually communicate with the producers of the ideas.

This will really help to decentralise the information sharing processes of the current top-down mass communication systems like the media. We can hear multiple opinions on an issue and give our own views, instead of being told one story that is heavily affected by the company’s personal perspective of the situation.

So, you can see this has the potential for something quite big. Less time wasted, finding all the knowledge you’re looking for, and sharing your opinion and meeting others similar to yourself has never been so easy. The RSS Reader is a knife cutting away all the useless packaging, revealing the true content of the gift of the Internet.

Tuesday, September 16, 2008

Could there be a new way of hearing the stories we feel are relevant in our lives?

If you’re anything like me you are really getting tired of the mainstream media’s one-voice-to-many analysis of life on Earth. First of all, it’s just too negative! I read a survey recently that stated that fourteen out of fifteen newspaper and TV News stories had negative fear-based stories. I don’t know about you, but if I look at my everyday life, the amount of good and bad I experience seems to be much more balanced. Why does the ‘big’ media think we all love hearing the dark side of things so much?

If you look at what news stories truly are in historical terms, it is a person sitting around the tribal campfire at night telling a tale to inform the people both in wisdom and knowledge. In any tribe there were many storytellers, so different perspectives were always available to the masses. Well, if you think today’s media sources are too monopolized in their power of authority over the stories we are told, there’s a new option for humanity. The answers and views we are seeking in our daily lives could lie in the Internet. This Internet thing really could be the key for humanity to evolving into a species that thinks independently, leaving this age of fear behind.

It’s time to bypass the main media sources. On the Web we can access non-profit news organizations, we can hear personal views of individuals in news forums and blogs, we can even express our own views on world issues as well as sharing our own personal experiences! With this newly accepted technology called RSS Readers we can start to get the type of information that we feel is most relevant to ourselves as individuals. It comes straight to us and then we can sort through it and decide which people and sources we want to hear from on a regular basis. This is awesome as it means we don’t have to search through a bunch of stories that have little interest to us. It also means if we want to hear more positivism, we can push the negative views out of our perceptions.

Although this idea is in its infancy, the repercussions once realized could have a mammoth impact on how individual humans see and live their lives on Earth. Imagine a society that stretches across the globe where a collective consciousness speaks to itself in an informative many-to-many communicative process. There are a lot of happy, positive, intelligent people in this world who are interested in similar things to you. Wouldn’t you like to hear their stories and share their knowledge as a way of constructing your view of reality?

Let’s leave behind this era of negative perspectives and singular authorities telling us how life on Earth should be viewed. It is interesting that some of the most over-wealthy, greedy individuals media moguls who tell us what is important. Don’t you want to have a say in how you look at your life while you are here? Positivism and wisdom surrounds us at all times. Would the Universe exist otherwise? Lets reconnect with that source of energy that makes us smile so many times each day. If life were meant to have so bleak an outlook, would there even be stars in the sky?

Sunday, September 14, 2008

Creating Quality Websites

Websites, there are literally billions of them out there in cyber-space. How many of them do you go to and just think this is boring, bland, or hard to use? It seems like too many to mention. So what makes a good website? I reckon it’s about interaction. You’ve got to make the visitor interested. You’ve got to grab their attention. Many sites use plenty of bright and shiny gimmicks to attract you, but once you make it through to the content of the site it’s just not worthy. A good site uses easy navigation, relevant content, and interactive media like comments and message boards. If you’re fortunate, whoever builds your site may even have a few tricks up their sleeves to make it really fun with sound, video, and other interactive fun stuff.

Do you want people to come to your site and then tell their friend and family about it? Do you want to have huge amounts of visitors? Do you want to succeed in making your dreams come to fruition on the Web? Make your website exciting! It might be easier said than done, but there are people around whose job it is to construct and design sites for a living. If you can afford it, go for the best. How great is it when you come across a site that has some special feature that you’ve never seen elsewhere? Isn’t it great when you find a site that relates to one of your interests that is simple and easy to get to the information you want? If you want to have people to come back again and again, you’ve got to keep updating the content to keep it fresh and interesting. Have a way for people to communicate with yourself and others who are into the same things. E.G. Forums, message boards and comments. The aim is to catch the ‘viewer’s’ interest.

A lot of sites just look like giant advertisements and you have to search for the needle in the haystack to find out what the actual site is for. I know advertising is a way of making money, but if you want your site to have an authentic, respectable atmosphere that exudes a feeling of integrity, you better be careful. People are becoming wary of this consumer driven, mindless attack at the average civilian’s wallet. Some people will automatically leave a site if a bunch of commercials pop-up on the screen. Pop-ups, don’t even make me go there…

So, the aim of the game is to make a site that offers the public to be part of the action as well as being a source of knowledge or information that is in demand. A simple to navigate, good ‘feel’, and if possible-innovative site is the means to becoming the popular Internet magnate you’ve always dreamed of becoming. Another important fact is the idea of ‘you’. Your website is a chance to put your identity out there in the world. Be yourself. If you try to appeal to an audience in a way that doesn’t reflect your true self, you’re destined to fail. Be honest and speak from your real perspective on life. Give it to us from the heart.

Thursday, September 11, 2008

Internet Tutorials are the Teachers of the Future

I know some people don’t even believe that the Internet or World Wide Web exists. They think that it is an abstract concept and that if asked to show it to someone they would fail miserably. Well, whether or not it exists I think that the collective consciousness of humanity is evolving everyday because of the sharing of ideas on the strange boxes called computers and the electronic network that connects them.

Every time I go on the Internet these days I am surprised by some new function that it has for our lives. My most recent discovery has been on-line tutorials. Tutorials are websites that have been created to help novices and amateurs alike learn more in their areas of specific interest. Just about any aspect of life seems to have tutorial sites dedicated to it that will teach you want you want to know. Of course some knowledge can cost you money but you’d be pleasantly surprised to see how much information you can get for free.

For example, I am interested in learning about how to play the guitar. You should see how many sites are out there, just look up guitar+tutorials on your search engine (E.g.: Google). There’s all sorts of great help from how to change your strings, hold a plectrum properly, and tuning, to learning complex chord scale systems and finger tapping on your electric guitar.

There are often diagrams, photographs, and intensive explanations relating to everything you ever wanted to know. Some sites have video and audio to help drive the lessons home. Life really has changed. In the past you had to get lessons from a teacher, drive to and from their house or music school, pay high tuition fees, and buy books on chords and songs. Everything is downloadable these days, and a lot of it is free.

Web designers could also probably learn a few things from these guitar tutorial sites. The ways the guitar teachings are expressed are often quite extensive but done so in a very simplistic manner. It’s a real one, two, three approach starting with verbal explanations of exercises, followed by diagrams, and then finally with audio and visual representations. It is an extremely thorough way of teaching without ever having to meet anyone in person.

However, a strange phenomenon is the fact that if the site is good, the visitor does feel a connection to the personality of the creator. Making the site individual is a major factor in both achieving success and touching a personal chord (no pun intended) with people. Many of the sites have means in which you can get direct contact with the site owner thus creating an opportunity for real personal interaction and tuition. Check out some of these sites:

* www.alanhorvath.com/tutorials
* www.ezfolk.com/guitar/Tutorials/tutorials.html
* www.learnthat.com/courses/fun/guitar/
* www.8j.net/~lwind/guitar.html
* www.tutorgig.com/t/Guitar

Get connected to the teachers of the future. Find a tutorial that helps you to follow your dreams.

Sunday, September 7, 2008

Translation Plez !

While we are here sending messages in English, there are at least one third of the worlds population who can't read them, for English is not even a second language for them.

I refer to China.

More people in China are logging on to the net every day, but most of what has been put up on the net is in English, this can be very frustrating for them.

Very few web sites I visit, and I visit very many in any given week, don't have any way of giving translations into other languages, and I feel, this is a thing that webmasters have got to address as soon as possible.

On my own website, www.ebook-sales.com I have inserted a script code at the top of every html page to offer Alta Vista's translationservice - 'Babel Fish'.

This offers translation into eight languages at present, including Chinese, Japanese, and Korean, as well as European languages. As more languages become available automatically the script will activate them.

Since I put "Babel Fish' on my site I have noticed in the stats on my server that more people are logging on from China!

This problem of translation for web-sites I recently wrote up about in a article filed with IdeaMarketers.com called "Reach Out And Touch Billions", no sooner it was filed within minutes it was being read by users of the service, usually editors.

Take a look at the article and let me have some comments, and if you know of other translation services, why not give me some details about them for others to benefit from?

I will write another article to follow up.

Question 1.
Should it be a mandatory requirement that a translation should be made available for web-sites - incuding blogs?

Question 2.
Now that there is the technology available, should search engine's like Google and Yahoo rank sites lower if they have no translation available?
(Therefore rank sites higher if they do provide translation?)

Question 3.
Should all email service providers be made to provide translation services for all emails?
(Do you know of any that do?)

Wednesday, September 3, 2008

Open Sesame - Password Security

“Open Sesame!” is probably the most famous password in literature. It gave Ali Baba access to vast treasure. In the realm of technology, computer passwords also give access to valuable treasures: precious business and personal data.

Information about your personal life, buying habits, credit quality and life style is valuable to those who can profit from it. For the Corporation, information has even greater worth. It is not the “Bricks and Mortar” but the intangibles such as intellectual property, client lists, market strategies, pricing and compensation that account for over half the value of the modern enterprise.

All of this personal and business data most likely resides on a database somewhere and is available with a password. In fact, passwords are the most common means of entry in any system. They are also acknowledged as the most vulnerable points for security. “Weak” or compromised passwords are the easiest way for hackers to gain entry into a system.

Simple or short passwords can be easily discovered through “brute force” or “dictionary” attacks which concentrate intense computer power to crack a password. A two letter password, for example, has only 676 combinations. A password with eight letters offers more safety with 208,000,000 combinations.

Ideally, a password should consist of 8 or more characters. They should also contain a mixture of upper and lower case letters, symbols and numbers. “A$d3B5i9X” would be an example. Microsoft security has encouraged the concept of the “Pass Phrase” as an alternative. A phrase such as,”TheLastGoodBookUBoughtCost$25!” has all of the needed elements and is also easy to remember.

The human factor or social engineering contributes to password compromises. It is estimated that employees share their password eight times a year. Passwords can also be cajoled from untrained or naïve workers. The standard rule is NEVER share a password.

Remember the cliché of the “Six Degrees of Separation.” You cannot know who will eventually end up with your password and own it.

To cope with these issues, many leading edge firms are adopting a defense in depth strategy utilizing three elements to better safeguard their information

The three layers of authentication consist of:

What you know…
A strong password or pass phrase

What you have…
A Crypto-key, smart card or token

Who you are…
A biometric aspect such as fingerprint, hand, or retinal recognition

Usage of these three defensive measures will increase dramatically in the future as people seek to thwart ever increasing threats to their private and personal information. Many companies will be mandating them as a significant part of their security best-practices to safeguard an extremely valuable asset: their treasured data.

Monday, September 1, 2008

Blogging Communities Turn Faceless Strangers into Close Friends

I’ve been searching the Internet for blogging sites for a fair while now and recently I came across a whole blogging community, which has grabbed my interest greatly. It’s called Joe User and it’s a site that many bloggers all around the globe are partaking in. It is very well organized into categories such as Best Articles, Newest blog entries, Top blogging sites, New sites and Most hit-on bloggers. The blogs range from very personal life introspection to serious analysis of current affairs in the media.

The aspect that has appealed to me the most is the very personal type of blogging community. Many people are talking about their feelings and issues about life with people that technically they have never met face to face. However, the type of camaraderie I’ve ‘witnessed’ as a bystander has truly amazed me. These people talk to each other as though they are extremely close friends, and the strange thing is I think this is the reality.

When one person has something important happen to them in their life, up to 100 or more comments will arrive under their blog entry with advice and information as well as emotional support from their blogging friends. Of course there are some differences in opinion, but the general perspective seems to be one of a positive approach to humanity. People are really spilling out their souls to each other, and then accepting criticism as well as discussing possible solutions to problems. I just find this to be truly inspirational, a human community or ‘tribe’ that has formed simply because of the Internet’s existence.

These people must spend a lot of time communicating with each other. Some are writing new entries everyday, as well as articles and conversations. The conversations usually happen in the ‘comments’ section where one can see that these people often stay up into the late hours of the morning, blogging to each other back and forth. The amount of love shared by these arbitrary acquaintances is astounding. One could perceive the whole experience as a form of therapy but I think it is much more than that. I believe this is a sign of a revolution. The coming of the New Human Tribe has begun.

If random bloggers can evolve into a community of people who trust, respect, and are intimate and united with each other this says a lot for the human condition. People are tired of the segregated, separatist reality of countries, cultures, races and religions. These group blogging sites, or collective on-line journals as I now like to think of them, are symbolic of the future connectedness of all of humanity. It may take a hundred years, or a thousand, or maybe only fifty, but it definitely looks like there’s hope yet for the warring, greedy humans. One day we all may be ‘one’ again in our minds as well as our physical forms.

Internet Home Business Secrets That Payoff!

I can picture you exactly where I was just a few short years ago --

Sitting in another useless meeting organized by a group of senior managers that have a combined IQ less than your own child at 3-months old.

Around in circles you go, no progress again today and only those who play the game the best will collect the bigger paychecks - but even they can't outlast this game of roulette can they?

Listen - I get asked often, even by my own wife, "why are you so driven!"

It's true, these days I am passionate about just about everything I do - especially my internet home business.

Why?

Is it the thought of a new porsche sitting in my driveway that motivated me to succeed with my internet home business?

What about cruising up and down the Pacific Coast in my new yacht?

Maybe it's being able to take a dream vacation to Australia and New Zealand?

Nope! You guessed wrong.

In fact, what motivates me everyday is the thought of having my time, energy, health and family UNDER THE CONTROL of someone other than myself scares the heck out of me.

I mean all out spiders on my face, snakes in my bed and lizards in my pants scared!

When I hit 30 back several years ago - I was in a hotel, alone on business in downtown London, England.

Incredible city, but I realized that after spending 29 birthdays with my family - I was FORCED to spend this one alone thousands of miles from home.

Every day after, I became incensed each time someone at my old job controlled some aspect of my time, health, energy or family.

I don't mean a little upset - I mean DEEPLY ANGRY.

There's only two ways to deal with something like that in your life - curl over and die a slow death or take action until you change the circumstances

Trick was, to channel that anger in the right direction - postive instead of negative.

Then I discovered something incredibly powerful --

Anger and Pain Are Part of the Formula for Success!

Name me any highly successful person and chances are I can find a burning, gut-churning, unstoppable force within them that will not let them fail. That force usually comes from anger or pain.

LET ME SAVE YOU 5-YEARS OR MORE....

Even with this incredible passion I had to control my own destiny, success didn't come right away.

I tried opportunity after opportunity, scam after scam, UNTIL...

THE HOLY GRAIL - Internet Home Business

Ever since the beginning of business, the same principles hold true - you must have;

1. Compelling product to reachable market
2. Competitive Advantage or Unique Selling Proposition
3. Operation plan that is profitable
4. Constant Plan, Do and Review process to increase profits

Whether you want to market other people's products online or create your own products or services, you must follow these fundamental business principles.

What's great about an internet home business is:

1. You can find reachable markets and compelling product ideas sitting in your office in your underwear

2. You can easily discover and communicate your Unique Selling Proposition without having to spend thousands on competitive intelligence

3. You can develop very profitable operational plans taking advantage of instant download, or build to order systems

4. It's easier, and less risky than ever before to continually test and improve your internet home business.

So - snap out of it!

Stop settling for whatever it is that is eating away at you!

Take action - right now!

Find out all you can about starting and building your own internet home business - turn your anger or pain into health and happiness today.