Wouldn’t it be wonderful if you could just flick a switch and turn on your creativity? Sadly, at times, tapping into your creativity can feel like trying to squeeze water from a stone. The good news is, there are ways of encouraging creativity and one of these ways is through balancing your sacral chakra.
Chakra is the Sanskrit word for moving wheel; the chakras are vortexes of energy present in the ethereal body and in corresponding locations of the physical body. There are seven major chakras and they function as pathways for energy to be taken in.
The sacral chakra, sometimes called the spleen or navel chakra, is located in the lower abdomen, approximately two inches below the navel. It governs sexuality, self-worth and creativity and is also associated with desire, pleasure, emotional balance and the abundance that you allow into your life for the fulfillment of your desires.
If this chakra is functioning well, you will experience enriched creativity, enhanced emotional gratification and courage, sexual vitality and positive self-esteem. If this chakra is blocked, however, both sexual and creative frustration occurs. You may have difficulties tapping into your creativity. Or you may have brilliantly creative ideas, but problems with manifesting your projects. A blockage can also manifest physically with lower back pain, sciatica, problems of the reproductive system, lowered libido and urinary problems.
Luckily, there are many tools to help balance the chakras. I’ve listed some of the correspondences for the sacral chakra together with guidelines on how to use these tools to balance this chakra and hence enhance your creativity.
COLOR: Orange
Surround yourself with orange. Wear it, eat it (preferably in the form of food) or paint your studio or workspace with it. If you meditate, visualize orange around the area of this chakra.
MUSIC: sensual flowing music with passionate rhythms (think Marvin Gaye’s “Sexual Healing”)
Dance, using your hips. Gyrate, baby, gyrate!
GEMSTONES: any orange stone – carnelian, orange jasper, fire opal, moonstone
You can wear these stones as jewelry or carry them in your pocket or purse.
ESSENTIAL OILS: sandalwood, jasmine, ylang ylang, clary sage, bergamot, orange blossom
Burn oils in an oil burner. Combine 10 drops or use singly in a bath. (This is particularly effective as water is the element governed by the sacral chakra.). Put some drops on a handkerchief and sniff it when you need inspiration. Make yourself a massage oil by adding a few drops of essential oil to almond oil.
Now you know what to do to get your creative juices flowing; go take a bath whilst eating a mango, come out and drape yourself in orange clothes and jewels and start swaying those hips to a cool groove.
Then, go create!
Louise Pool is a self-taught artist and workshop facilitator who is passionate about life, the universe and everything. Visit her website to see her art, read her musings and pick up a tip or two on creativity.
http://www.samarkand-dezignz.com
One of the primary factors in the success of any company is the liaison it shares with its customers. CRM or Customer Relationship Management designates all features of interaction a company shares with its customer. This includes everything from sales to service.
CRM is basically a business strategy designed to accrue gains, generate revenue and cater to customer needs and satisfaction. With the e-media picking up pace, the manner in which companies approach their CRM strategies has greatly changed. This has even altered the consumer’s purchasing attitude. So these days CRM too has become a web based effort as most of the customer relationship is handled electronically.
The web based CRM service is more effective. Web-based CRM services mainly covers three areas of service- sales force automation, management of customer relationships and customer services and automated marketing.
A web-based CRM software is a web-based system used for contact management, marketing and sales support, project tracking and other tasks associated with CRM. This software enables teams and departments to share a central and fresh database. The software facilitates its users with an online contact manager and a project-tracking tool, either over the web or within the corporate intranet. With the aid of the CRM software you can view and manage contacts, customer’s record, hot leads, projects and left-out work, from anywhere and with any web-browser. Moreover unlike the intervening and needed to be testified upgrades of an enterprise software, the upgrades to the web based software do not affect the organization’s regular operations in any manner. Due to these features more and more companies are driven towards this web-based software.
Siebel Systems Inc., HydraNet and Push CRM are some eminent names in web-based software service. Lately SAP has also blessed the market with on-demand Customer Relationship Management solution. A web based CRM has many names out of which on-demand CRM is one.
These systems provide agents with the most up-to-date information on all customer service transactions. The software adds to the strategic value and business of the organization by automating sales, marketing and customer service. For instance the SAP product specializes in providing core sales-force automation features for managing customers, contacts and sales pipelines.
The software runs and keeps a complete track of your data after it is downloaded or purchased and then installed on your server or web-host. Usually the CRM software runs on all significant platforms such as Unix, Linux, Windows, Mac OS X, Novell (6.5) and so forth. Since the software serves many purposes at the same time, it is quite expensive. However an incredible competition in the market has enabled the software seekers to exercise their choice to a certain extent.
In choosing a web-based CRM software it is important that the user should firstly analyze his or her budget or the budget of the organization. Secondly also check your organization’s partner ecosystems. A user-friendly hosted CRM system, an on premise version or the combo of both should follow this and finally try to go for software that can fit any type of user, any size company and in any industry.
Mansi Aggarwal recommends that you visit Web based CRM for more information.
Introduction
One day you may be asked to write a parser that will have to parse a bunch of documents and break them down into a structured model and store them in a relational-database. And those documents will most likely be written in MS Word. And the sad part would be that they would not have any structure, they will not follow any standard and they will include OLE/embedded objects. I was assigned with such a task, and it was a very interesting experience for me.
Since this was my first such project, meaning automating MS Office application, I had to go and do a lot of reading about automation. The good news is that there is a bunch of stuff out there; the bad news is that all of them are written for VB or VBA developers. I couldn’t find anything for C++ developers. Long story short, I am writing this article to make things a little easier for someone else that might be assigned with a similar task.
The original code I worked on was written using Borland C++ Builder 5 Professional. This article is however, the C# version. By the way if you are interested in seeing the C++ version ask for it and I will post it. I encourage people to take a look at the C++ version sometime to start appreciate the simplicity of C#.
Background
No special background is necessary. Just have some hands on experience with C#.
Using the code
I am going to include some code that will allow you to understand how to get what you need from a Word document. It really doesn’t matter if you are making a console application or a Windows application. The steps and the code is the same. So you can go ahead and create new C# project. You may choose to create a Windows Application that way you can click some button.
Okay so once you create a new project, go ahead and right click on References in the Solution Explorer, and select Add Reference… When the Add Reference window comes up select the COM tab. This will list all Component Names which are available on your machine, since we are going to use MS Word, we will scroll down until we find: Microsoft Word 9.0 Object Library.
Note: Yours might be a different version depending on the version of Office installed on your machine. This is for MS Word 2000.
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace sparser
{
/// Summary description for Form1.
public class frmParserMainUI : System.Windows.Forms.Form
{
/// User Interface Objects
/// I have removed the user interface object, since
/// they have nothing to do with
/// the actual code, and they take a lot of space.
…
/// Required designer variable.
private System.ComponentModel.Container components = null;
private System.Windows.Forms.OpenFileDialog openFileDialog;
…
The following block create MS Word COM Object. This is the object which will be used to access WORD application functions. To see what functions are available you can do it either within Visual Studio .NET IDE or MS Word.
/// MS Word COM Object
/// This is where we create our WORD object
private Word.ApplicationClass vk_word_app = new Word.ApplicationClass();
…
To view the functions from MS Word, launch Word, hold down the Alt key and press F11 [Alt+F11], this will give you the VBA window, once there press F1 to get the help window, and do a search for document object. This is the best source of documentation for available functions. However, the documents have been written for VBA, but at least you know what the function does and what kind of parameters it takes.
Alright the code continued…
…
/// The main entry point for the application.
[STAThread]
static void Main()
{
Application.Run(new frmParserMainUI());
}
/// Get source document. Open a FileDialog window for
/// user to select single/multiple files for
/// parsing.
private void butSourceDocument_Click(object sender, System.EventArgs e)
{
if( openFileDialog.ShowDialog() == DialogResult.OK )
{
object fileName = openFileDialog.FileName;
object saveFile = fileName + “_Vk.doc”;
object vk_read_only = false;
object vk_visible = true;
object vk_false = false;
object vk_true = true;
object vk_dynamic = 2;
object vk_missing = System.Reflection.Missing.Value;
// Let make the word application visible
vk_word_app.Visible = true;
vk_word_app.Activate();
// Let’s open the document
Word.Document vk_my_doc = vk_word_app.Documents.Open(
ref fileName, ref vk_missing, ref vk_read_only,
ref vk_missing, ref vk_missing,
ref vk_missing, ref vk_missing, ref vk_missing, ref vk_missing,
ref vk_missing, ref vk_missing, ref vk_visible );
…
Alright, so here the user is given a file open dialog where they can select a Word document. Notice that we save the filename as an object. This is because the functions that we use need reference to object.
So now we can use our Word object to start Word. This is achieved by the vk_word_app.Visible = true; and vk_word_app.Activate(); The first statement makes sure that the instance of Word is visible, and the second one activate it. If you don’t want the Word instance to be visible just set the Visible property to false.
Next we create a Word Document object, and that is done using Word.Document vk_my_doc = vk_word_app.Documents.Open( … ); Notice all the parameters which are required by the function. Most of them are NULL values, so we use vk_missing which is a System.Reflection.Missing.Value.
So now we have created a Word instance and opened a Word document. Now let’s move on with the code…
…
// Let’s create a new document
Word.Document vk_new_doc = vk_word_app.Documents.Add(
ref vk_missing, ref vk_missing, ref vk_missing, ref vk_visible );
// Select and Copy from the original document
vk_my_doc.Select();
vk_word_app.Selection.Copy();
// Paste into new document as unformatted text
vk_new_doc.Select();
vk_word_app.Selection.PasteSpecial( ref vk_missing, ref vk_false,
ref vk_missing, ref vk_false, ref vk_dynamic,
ref vk_missing, ref vk_missing );
// close the original document
vk_my_doc.Close( ref vk_false, ref vk_missing, ref vk_missing );
…
Next we would like to create a new document. This is just like clicking the New Blank Document button on the toolbar. So we create another Word Document object, and this time notice that we use vk_word_app.Documents.Add( … ); This will add a new blank document which is also visible.
Next what we do is select all content from the document which we opened, and we copy it.
Next we paste our content into the new document with a special format. The format used in the code is for plain text. This is because we want to get rid of the crap Word puts into the formatting of the text. Then we close our original document without making any changes.
…
vk_new_doc.Select();
FindAndReplace( “^t^t^t^t^t^t^t”, “^t”, vk_num );
// Save the new document
vk_new_doc.SaveAs( ref saveFile, ref vk_missing,
ref vk_missing, ref vk_missing, ref vk_missing,
ref vk_missing, ref vk_missing, ref vk_missing,
ref vk_missing, ref vk_missing, ref vk_missing );
// close the new document
vk_new_doc.Close( ref vk_false, ref vk_missing, ref vk_missing );
// close word application
vk_word_app.Quit( ref vk_false, ref vk_missing, ref vk_missing );
}
}
…
Now let’s say if we are interested in doing a find and replace operation, we would basically select the whole document and use the Find and Replace function.
Note: The FindAndReplace function does not belong to Word object or Document object, it is user defined, the actual Find and Replace function is define in the following block.
Next we want to save our changes to the new document and close it.
And finally quit word.
…
private void FindAndReplace( object vk_find, object vk_replace,
object vk_num )
{
object vk_read_only = false;
object vk_visible = true;
object vk_false = false;
object vk_true = true;
object vk_dynamic = 2;
vk_word_app.Selection.Find.Execute( ref vk_find,
ref vk_false, ref vk_false,
ref vk_false, ref vk_false, ref vk_false, ref vk_true,
ref vk_num, ref vk_false,
ref vk_replace, ref vk_dynamic, ref vk_false,
ref vk_false, ref vk_false, ref vk_false );
}
}
}
The above block shows the actual FindAndReplace function. Notice that it belongs to the vk_word_app object. And the function operates on the active selection. The Find and Replace function is a part of the Find function with special parameters. These parameters can be identified in the documentation as I mentioned at the top of the article.
The code demonstrated above, illustrates how to open a word document, how to create a new word document, selecting, copying, pasting, and doing a Find and Replace function.
As you can see, once you get an understanding of how Word operates and go through the documentation you will be able to automate all the functions that Word has to provide.
// Let’s get the content from the document
Word.Paragraphs vk_my_doc_p = vk_new_doc.Paragraphs;
// Count number of paragraphs in the file
long p_count = vk_my_doc_p.Count;
// step through the paragraphs
for( int i=1; i<=p_count; i++ )
{
Word.Paragraph vk_p = vk_my_doc_p.Item( i );
Word.Range vk_r = vk_p.Range;
string text = vk_r.Text;
MessageBox.Show( text );
}
If you take a look at the code above, you can see that we have declared an object that represents a paragraph in a Word document. This is how you can extract text from a Word document, you get the paragraph object and you can access all the paragraphs that are contained in the list. The code loops thru every paragraph of a given document and displays them in a MessageBox.
Points of Interest
The new version of Office, Office 2003 is going to make things a little easier for Office developers. So if you are an Office developer, you should start looking into the features that Office 2003 has to offer. One of the nice features that I like is the capability of exporting documents into XML format.
Archives
Categories
Links
Search
Hotel Collodi is a lovely little hotel located in the historical centre of Florence, in the St. Lorenzo district. It is an approximately 5 minutes walk from the Santa Maria Novella Central Railway Station, congress and exhibition centre, and from the most important sights and museums.