Get your creative juices flowing if you want to be an ad maker

Get your creative juices flowing if you want to be an Ad Maker Those who don’t have creativity as an in-built talent, it takes some hard work to learn the art of advertising. There are some really basic tricks involved. First, try to put things that you have, to use i. e. the five senses along with the brain. Eyes can capture the most beautiful scenes; try remembering those that are creative. Try to observe the Mother Nature like observing the sunset, the patterns of colors like yellow, orange, red and violet. Observe greenery around, the flora and fauna. Next put your ears and mouth to use and try increasing the observation power. This can be done by walking around the neighborhood or nearby park and trying to observer new things everyday at the same location. Just seeing a thing isn’t enough, analyze the expressions of the people around you and analyze the emotions they depict. The brain can be fed with many things at once, so carry a camera along and take a lot of pictures of objects from different angles and lighting. Try to understand and capture the mood and things, which will help in creating a perfect scene. Like vanilla ice-cream will becomes more attractive when cherry and mint leave are added as topping. Play around with the lightning effects. Take notes along with the pictures. It is like creating a blue print that will be useful in future works. Things that are important can be underlined or marked with a star. During this procedure if any question arises in your mind, note them down also, so as to find an answer for them at a later stage. This is a great learning technique. Try to listen a lot, compile those things in brain and then output it through your mind. Try to create a rhythm between works, something like poetry, but not exactly it. The fifth sense, touch can be used to learn a different perspective of life. Try closing your eyes and feel objects around you like the feel of a satin sheet is more tempting than a cotton sheet. Develop a habit of carrying a pen and notepad all the time. It’s not only useful for taking down notes, but also it can be used as a reminder of meetings and interviews. While waiting for something or someone, scribble on your notepad. Try to draw things and apply those amazing ideas which come to mind. Go back home and then paint those ideas, if not everyday, at least on weekends. Other than painting, try doing something new on weekends like golfing, canoeing, or rock climbing. Watching television and shopping can also provide good ideas. When something is troubling the mind, don’t go to sleep until the issue is resolved. This increases the enthusiasm and determination. Again, note down points in the notepad at this time. If there is ample time available, join courses that increase creativity like photography, painting, martial arts, etc. It need not be necessary that they be directly linked to advertising. Maintain a diary and note down daily happening, especially good things. Learn the art of humor, read books, watch people and animals and then apply it practically by trying to put a smile on faces around you. Do research about great personalities who are related to arts. Read their biographies, some of the problems you are facing may be answered and the path to be taken can be learned. After going through all the above steps the creative instincts will start to develop. So the next time any idea clicks, trust your instincts and work on it. Don’t hesitate to try new ideas. And try to interact with people who encourage you with this and believe in you and not inhibit your thinking. After breaking the core you can approach newspapers, ad agencies with your stories, articles and original work. Whatever being learnt during the whole experience, there is no harm in sharing and teaching that with others. Word Count 665



Online Get your creative juices flowing if you want to be an ad maker

How a satellite dish works

Are you thinking about getting Dish Network or another satellite TV provider but are unclear how a satellite dish works? Here’s your answer. A Satellite Dish is an antenna designed to focus on a specific broadcast source and is a main component of satellite TV providers, such as Dish Network. The standard satellite Dish Network dish consists of a parabolic (bowl-shaped) surface and a central feed horn. A controller sends it through the horn, and the Dish Network satellite dish focuses the signal into a relatively narrow beam. A narrow beam is generated as the dish reflects energy from the feed horn.

The Dish Network satellite dish on the receiving end can only receive information; it cannot transmit information. The receiving dish works in the exact opposite way of the transmitter. When a beam hits the curved dish, the parabola shape reflects the radio signal inward onto a particular point, just like a concave mirror focuses light onto a particular point. The curved dish focuses incoming radio waves onto the feed horn. The feed horn then passes the signal onto the receiving equipment. Ideally, there will be no obstructions, such as trees to interfere with the signal from the satellite to the Dish Network satellite dish. With no obstructions you receive a much clearer signal.

Some systems are set up to receive signals from more than one satellite. A new dish design uses two or more horns to pick up different satellite signals. As the beams from different satellites hit the curved dish, they reflect at different angles so that one beam hits one of the horns and another beam hits a different horn. The central element in the feed horn is the LNB (low noise blockdown converter) The LNB amplifies the radio signal bouncing off the dish and filters out the noise (radio signals not carrying programming). The LNB passes the amplified, filtered signal to the satellite TV receiver inside the viewer's house. A cable is run from the Dish Network satellite dish into the house and then connects to the satellite TV receiver (black box) thus completing the connection.



Online How a satellite dish works

5 reasons to get a gas reward credit card

They may seem like a relic of a long-ago age, when gas stations wouldn’t accept credit cards unless they were from their own company. But now with credit cards being accepted at nearly every gas station in the country—many times right at the pump—gas reward credit cards may seem unnecessary. What good do they do you if you can use your Visa or MasterCard instead? But don’t count out gas credit cards just yet. They still have their benefits for certain people. We know what question is coming next: "Am I one of those special certain people?" Well, it depends. Read the following five reasons that people should consider a gas reward credit card.

1. Consider Your Bill Paying Habits First, ask yourself if you pay off your debt every month or you usually allow your credit debt to revolve. Gas credit cards tend to have higher percentage interest rates, so they may not be a good bet if you let your debt build from month to month. 2. Are You a Devoted Customer to One Particular Gas Station? Next, do a quick estimate of the number of gas stations you’ve visited in the last month. Is it a random assortment of stations—whichever happened to be closest when your empty tank light went on? Or do you tend to go to the same station every time you buy gas? If you’re a devoted customer to one gas station, a gas card at that station may be the best idea. That’s because gas cards tend to give higher rebates at their stations, compared to other purchases. 3. Find the Best Rebates If you shop at a few gas stations, you may want to narrow down your card selection to the company with the best rebates. Say, for instance, you usually buy gas at Shell, Texaco, and Gulf. Get information on all three companies’ credit cards. If one of the three credit cards has a 6 percent rebate on its gas, while the other two have 4 percent, that kind of savings is a major reason to pick its card, especially as gas prices keep on going up and up. 4. How Convenient! Gas cards can also be very convenient if the gas station has a convenience store. Those rebates also tend to extend not only to their gas, but to their foods, drink, and knickknacks in their stores. If you tend to run out to a particular gas station convenience store for milk, juice, snacks, and lunch, that 6 percent rebate will add up. 5. Organize! Last but not least, for those who have trouble budgeting and keeping track of expenses, whether for personal or small business reasons, a gas card can be a way to organize without even trying!



Online 5 reasons to get a gas reward credit card

Payroll vermont unique aspects of vermont payroll law and practice

: The Vermont State Agency that oversees the collection and reporting of State income taxes deducted from payroll checks is: Department of Taxes 109 State Street Montpelier, VT 05609-1401 (802) 828-2551 http://vermont. gov/ Vermont allows you to use the "W-4VT, Vermont Employee Withholding Allowance Certificate" form to calculate state income tax withholding or federal W4 form. Not all states allow salary reductions made under Section 125 cafeteria plans or 401(k) to be treated in the same manner as the IRS code allows. In Vermont cafeteria plans are not taxable for income tax calculation; taxable for unemployment insurance purposes. 401(k) plan deferrals are not taxable for income taxes; taxable for unemployment purposes. In Vermont supplemental wages are taxed at a 7.2% flat rate. Magnetic media reporting of W-2s is not allowed in Vermont. The Vermont State Unemployment Insurance Agency is: Department of Employment and Training 5 Green Mountain Dr. P. O. Box 488 Montpelier, VT 05601-0488 (802) 828-4344 (877) 214-3331 det. state.

vt. us/ The State of Vermont taxable wage base for unemployment purposes is wages up to $8000.00. Vermont has optional reporting of quarterly wages on magnetic media. Unemployment records must be retained in Vermont for a minimum period of six years. This information generally includes: name; social security number; dates of hire, rehire and termination; wages by period; payroll pay periods and pay dates; date and circumstances of termination. The Vermont State Agency charged with enforcing the state wage and hour laws is: Department of Labor and Industry Wage and Hour Division National Life Bldg., Drawer 20 Montpelier, VT 05620-3401 (802) 828-2157 http:// labor. vermont. gov/ The minimum wage in Vermont is $7.00 per hour. The general provision in Vermont concerning paying overtime in a non-FLSA covered employer is one and one half times regular rate after 40-hour week. Vermont State new hire reporting requirements are that every employer must report every new hire and rehire.

The employer must report the federally required elements of:

  • Employee's name
  • Employee's address
  • Employee's social security number
  • Employer's name
  • Employers address
  • Employer's Federal Employer Identification Number (EIN)
This information must be reported within 20 days of the hiring or rehiring. The information can be sent as a W4 or equivalent by mail, fax or electronically. There is a $500 penalty for conspiracy in Vermont. The Vermont new hire-reporting agency can be reached at 800-786-3214 or 802-241-2194 or on the web at http://jobs. utah. gov/newhire/ Vermont does not allow compulsory direct deposit Vermont requires the following information on an employee's pay stub:
  • Gross and Net Earnings
  • straight time and overtime pay
  • hours worked
  • itemized deductions
Vermont requires that employee be paid no less often than weekly; biweekly or semimonthly if employer gives notice. Vermont requires that the lag time between the end of the pay period and the payment of wages to the employee not exceed six days; 13 under union contract. Vermont payroll law requires that involuntarily terminated employees must be paid their final pay with in 3 working days and that voluntarily terminated employees must be paid their final pay by the next regular payday; if there is none, next Friday. There is no provision in Vermont law concerning paying deceased employees. Escheat laws in Vermont require that unclaimed wages be paid over to the state after two years. There is no provision in Vermont law concerning record retention of abandoned wage records. Vermont payroll law mandates no more than $3.35 may be used as a tip credit. In Vermont the payroll laws covering mandatory rest or meal breaks are only that all employees be given a reasonable opportunity to eat and use toilet facilities. There is no provision in Vermont law concerning record retention of wage and hour records therefor it is probably wise to follow FLSA guidelines. The Vermont agency charged with enforcing Child Support Orders and laws is: Office of Child Support Agency of Human Services 103 S. Main St. Waterbury, VT 05671-1901 (800) 786-3214 ocs. state. vt. us/ Vermont has the following provisions for child support deductions:
  • When to start Withholding? 10 days after receipt of order or next payday.
  • When to send Payment? Within 7 days of Payday.
  • When to send Termination Notice? Within 10 days of termination.
  • Maximum Administrative Fee? $5 per month.
  • Withholding Limits? Federal Rules under CCPA.
Please note that this article is not updated for changes that can and will happen from time to time.



Online Payroll vermont unique aspects of vermont payroll law and practice

Myspace graphics make the profile fun to use

Having the same layouts and backgrounds for any profile in a social networking site will get boring. Thus for this site, various options are offered for members. Besides having free Myspace layouts and backgrounds, Myspace graphics are available too. These graphics have been designed so well that there is a real different look to the profile once used. As with the other options, the Myspace graphics too have various categories starting from cartoons to other animations. They come in phenomenal colors and designs, that each one of them looks very appealing. There are simple ones as well as flashy ones, and they can be chose according to the feel of the profile. If the member has a profile that is very subtle, then he may choose colors and designs from Myspace graphics accordingly. If the profile has various other information and the interests are such, then designs may be chosen accordingly.

Motion graphics are also part of the collection, and it makes it all the more interesting. These graphics will cater to the needs of any member, no matter what kind of personality they have. As each member will have different profiles, the taste will also vary. But there is no need to worry, and any user may find the kind of Myspace graphics they are looking for according to their taste. Designs are being updated every day, and access to all of these designs is completely free. For those who are interested in music video clips, here is the chance that they can grab.

There are a bunch of cool videos that can be set as the graphics background on the profile. Even with video clips the options are many, and they may be applied according to the taste of the user. Myspace graphics are designed exclusively for members on this site. Similarly to the application of the layouts and backgrounds, these may be applied too. Whether the members use any specific set of graphics or not, they are still posted on the sites. They are updated as designs come along, and members are allowed to access it any time. Using Myspace graphics is a very good idea, as it would break the monotonous look of the profile. Graphics of such a kind lend a great deal of mileage to every profile, and they must be used. This will allow all visitors to the profile a better experience, and they may even find graphics that they have not come across. So this is bound to be exciting for them, as they will get a better reading of the profile.

Many members will even get into a fix while looking at the graphics, as there will be so many to choose from. To solve this, they may reset the profile now and then with different looks. They not only get to use various graphics, they make the profile even better with the versatile look.



Online Myspace graphics make the profile fun to use

Turn your business cards into hardworking little salesmen to market and sell your crafts or services for greater profits

Marketing and Promoting your crafts can be just as fun as making them. It doesn’t make any difference how unique and special your handmade treasures are, if no one knows you are in business. What is so fun about marketing and promoting your crafts, home-small biz, is that you use the same creativity that you bring to your command, when you make your crafts. Most of us home and small biz crafters do not have a blank check, to what ever amount we like advertising budget, so we need to come up with cost-saving ideas. There are many advertising and promotion companies out there competing for your advertising dollars. Some are better than others, and most of them are expensive. Ads that tie up your advertising dollars, and may not be in print for a few months or more, or expensive coupon advertising, can deplete your advertising budget with one advertising campaign, and not return all that many new leads or customers. If an expensive advertising campaign doesn’t deliver, you don’t get your money back. Following I have included some: Quick! Low Cost Ways to Turn Your Business Cards into Hardworking Little Salesmen! Many people in business don’t use these to their greatest potential, even though most biz people do have them printed up. Business cards are your hardworking little salesmen, they are your mini billboards. They work for you 24 hrs a day, without pay!... 1. Hand them out! Always have some on hand, when you go out, and hand them out! This sounds obvious and it is, but many times business cards are left at home. They can’t be promoting your biz, left at home or in the car. 2. Use your biz cards as note cards... If someone needs your home address, and your biz is a home biz, hand them your biz card. Or write your home address on the back of your biz card. The same goes for your telephone no. This gives another person a reason to have your biz card. 3. Do a Business Card Exchange! Do a local mailing to businesses that are complimentary to your business. For example if you make candles, send a letter introducing your biz, to local beauty shops, with 5 or 6 biz cards included and offer a biz card exchange. You will hand out biz cards for them if they hand out yours. 4. Make Your Cards Do Double Duty As Price Tags... Make your biz card into a hanger that you attach to your handmade items or other products, with the price on the back of the card. Use a hole punch to punch a hole in the corner of your biz card, and run a piece of string or small satin ribbon through the hole, and attach to your product. 5.Double-sided Biz Cards... These business cards may cost a little more, but you can make them work even harder for you. Instead of having blank dead space on the back of your cards, you can have that area working for you too. On the back of the biz card you could offer a special discount for a first purchase. This will motivate people to hang onto your biz card. 6. Mini Billboards... if you have a website and e-mail always make your biz cards mini billboards for your on-line marketing too. Always include your website and e-mail address, on your biz cards. This can be a great way to utilize double sided biz cards also. On the back of the card could be a “short attention grabbing ad” for your website. What?! You don’t have a website and use e-mail marketing for your small or local home biz? If not, you are missing out on a great opportunity! The internet is where it’s at for small biz now! Find out how the Internet can help your business! with a gold nugget of a little book called “Insider Internet Marketing” An easy to read... paint by number little book that will get you started on the fast track to profitable internet marketing. As you can see, your business cards can be tireless hardworking salesmen for your products and services. I hope the suggestions presented above, have sparked more ideas, on how you could use your biz cards to promote your products and services.



Online Turn your business cards into hardworking little salesmen to market and sell your crafts or services for greater profits

How to say no to a nice guy

The phone is on its fourth ring. It could be your mother, or your best friend. Or it could be him - the man who boxed you into conversation at that party on Friday night. Was he sweet? Certainly. Were you attracted to him? No. So explain this - after you suppressed another yawn, he said, "I'd love to see you again. Can I take your number?

" Every bone in your body whimpered, "Me? You? No, no!" but you said, "Oh, er, Ok. My number is..." So here you sit, glaring at the phone, a prisoner of your own social life. For so many women, rebuffing that nice man with th sex appeal of a warthog is the social equivalent of sticking pins under your fingernails. Why agree to see a man you don't like? "I don't want to hurt his feelings," a role statement. So is it cowardice or compassion that makes saying no so hard? That said, faced with rejection, many men prefer a neatly wrapped white lie to blunt reality. But isn't that decepton? Who benefits when you tell a man you don't find him attractive? You don't want to say it and he certainly doesn't want to hear it. So what do men want to hear, if not yes? "I have a boyfriend," takes top marks in the lie department. "When a woman tells me she has a boyfriend I think, 'Well, if she wasn't attached she'd jump at the chance,'" says Louis, 26, a solicitor. But what if the man in question knows you're single? Try, "I'm sorry, I'm just so incredibly busy." However, don't elaborate with something like, "I have to get home to watch the paint peel." He may volley back with, "Well, that shouldn't take long. Let's meet for coffee later." You could also make it your personal policy, never ever to give out your phone number. If a man asks, respond politely with, "I'm sorry, I just don't give out my phone number." If he persists, say, "Why don't I take your number?" You're saying you'll take it. You're not saying you'll use it. Above all, the key to brushing off a man nicely is just that - to be nice. "I'm busy" can sound either sincere or agitated, depending on your tone and expression. Following tips will certainly help you: First, look relaxed, even if you're stunned. Smile and make eye contact. Second, keep your voice calm and say something such as, "Thanks, I'm flattered, but I'm just too busy. "Don't speak too quickly or you'll look awkward. Third, respond with a downward inflection at the end of your sentence, while making eye contact. A dip in your voice when you say the word "busy" connotes authority and lets him know you mean it. Your smile, however, shows him you mean it in a no-hard-feelings way. Virtually all men agree no matter what you say and how you say it, the sooner you let him down, the better. Rest assured, when you turn him down, he'll get over it. If he has the ego to ask you out, he has the ego to move on. Now, answer that phone!



Online How to say no to a nice guy

Get new clothes

Divorce - How to rebuild your life, get new clothes and feel good Okay, so you have just gone through one of the most painful times of your life, what do you do now? Well the grieving is over. You need to get out of your gloom and move on. You have been given an opportunity to rebuild your life. You have found yourself suddenly single, but you don't realize just how much you have. You may see your life as shattered, but you should look at it as a clean slate. You need to get back in with the crowd and mingle like you never skipped a beat. The first step to getting over a divorce is to make subtle changes. The first thing that a woman will change about her is her hair. Hair is special to women. When you feel like you have gone through a change, you feel the need to change your hair because it represents whom you are. Then you should head straight to the mall and purchase some outfits. You are no longer married, and nor should you look like it. You can wear the tighter shirts and the shorter skirts. You do not have to go from conventional to streetwalker, but if you spice up your wardrobe you will feel better about yourself. When you wear things that are beautiful, you will feel beautiful. You will feel so much about the way that you look. You should wear colors that you normally would not wear. You should purchase things that seem out of your style just to find yourself. Maybe you already know who you are, and that's great. You didn't allow yourself to be dragged down by the divorce. However, you maybe a little confused. You may not know exactly what you want from life and for your future. That is okay to be a little confused about things. However, if you go out and you purchase something that your mate would not have liked, you will suddenly feel better about yourself. Go to the mall and purchase a fancy dress and go to a place that you wouldn't normally go with your ex. It may be the opera, a play, dinner, and so on. You will be able to experience something new or do something that you love and you will look good too. Being single is not that bad. You can be whomever you want and wear whatever you want. You have so much freedom. You should take advantage of purchasing clothes without having to have a talk with your partner. Your money is now your money to do whatever you would like. Regardless of age, if you begin to date sooner than later you will be able to get over the divorce quickly. You don't need the emphasis on commitment or even sex. All you need is to get back in the game. Go out to dinner. This way you aren't at home mopping and you may even find someone who is fun to be with and that will show you how to love again. You do not need to have an expectation about anyone, but you never know where Mr. Right maybe. You should never rush into a committed relationship right after you have gone through a divorce. If you do, them you may be setting yourself up for more pain, however if you just purchase an outfit and have a casual night on the town, you will find that moving is a lot easier than you thought it would be. So get up, put on that new sundress and have a great day enjoying life. With subtle changes of style, love, laugher, and fun can be just around the corner.



Online Get new clothes

Tips for buying collectibles on ebay

Buying collectibles is one of the most enjoyable things to do on eBay, simply because you can find so many things that you just can’t get anywhere else. Here are a few tips to help you on your way. Find your Category. You’ll probably find that all the items you’re after are listed in a single category. Add this category to your browser’s Favorites, and keep coming back. Look for Mistakes. If you collect something, the chances are you know a lot about it. This can be your opportunity to make a mint from a seller’s mistake. They might not realise that they have a rare version of an item, or they might have left off the key information that makes it valuable. If you’re willing to email the seller and ask them a few questions about the item to confirm that it is what you think it is, then you should be able to buy items like these. You can then resell them at a big profit, if that’s what you want to do. Don’t Always Believe Descriptions. If you find something you haven’t heard of, and the description calls it ‘rare’, don’t assume that it actually is. Far too many sellers just put ‘rare’ into all of their descriptions – the chances are that the item is common and has just been described wrongly. Don’t bid unless you know what you’re buying. Stalk Other Users. When you collect something, you’ll probably notice that there are four or five sellers who seem to come up with consistently good items – and the same buyers buying them. Add their user pages to your Favorites, and check back often to see what they’ve got – or what they’re bidding on – that you might be interested in. Don’t Get Too Attached to an Auction. There are millions of items being listed every day on eBay – whatever you want, it’ll come around again, and if you don’t get it there are plenty more things to buy. This is similar to the golden rule of negotiating: always be prepared to walk away. If you can’t walk away, then expect to pay over the odds. There are few things so rare that another seller won’t have one to sell. Go and bid in a lower-priced auction, instead of getting into a bidding war in one that is already expensive. Beware of the Postage. If you collect lots of small things with a relatively low value, you might end up paying as much for postage as you do for each item. You should take these costs into consideration when you make your bid. Another good strategy is to always buy a few things at once from the same buyer, as they will almost always offer you a discount on the postage. When you’re bidding, you might notice that some auctions go more slowly than others, going days at a time without any new bids. The next email tells you how to take advantage of these ‘slow’ auctions.



Online Tips for buying collectibles on ebay

A debt consolidation program to relieve debt

Debt consolidation programs are good if you are paying on several different loans. They can make your life easier by giving you one monthly payment. Your monthly debt decreases if the program you use for debt consolidation stretches your payments over a long period of time. Paying less every month will free up some extra cash. A successful strategy sometimes is to use a debt consolidation program. With these programs you can manage various high-rate revolving debts with one payment. Let’s say you have several high credit card balances with high interest rates. With the debt consolidation program, you will be able to lower the interest rate you’re paying and manage the debt better.

Debt Consolidation Programs Reminders A debt consolidation program doesn’t eliminate your debt. All these programs do is move your debt to make it easier to make the payments. You will have to pay the money back sooner or later since you do owe it. One problem with a debt consolidation program is you will feel like you owe less. Your credit cards will again have large amounts of available credit for you to use. Beware of digging yourself into a deeper hole by continuing to add to these balances. With a debt consolidation loan you may end up paying more in total interest. By stretching your payments over a longer period of time, your total interest cost could possibly be higher. Of course, it may help you more easily manage your current cash flow. There are risks by using debt consolidation programs. If you’re using a home equity loan or line of credit to consolidate your debt, the consequences of falling behind on the payments can be disastrous. You could lose your home if it is pledged as collateral against your loan. How to Choose the Best Debt Consolidation Programs You should shop around to find a program that fits your needs. Local credit unions and banks you already deal with are a good place to start. They are a reliable source and will most likely give you a fair deal. You might also try a bank you aren’t currently working with. Be careful of scams though, when searching the Internet for debt consolidation. When searching for a debt management company, look for experience, how professional the company is, their assistance and budgeting services. Try to find a local company you can communicate with without having to drive for hours to talk to your counselor. The debt management industry is unregulated. Scam artist are out there waiting to charge your outrageous fees without informing you of the best solution for your situation. Try to find out some of their customers and talk to them. Get recommendations and research online if possible. When you team up with a debt management company who is less than above board, you may be left feeling insecure. You should relate well with your counselor and understand what they suggest. That peace of mind should help you pursue your goals and your financial future more comfortably. Also the debt management company your choose should be a be advise you on how to deal with angry creditors, whether bankruptcy is an option or how to consolidate debt or simply reorganize your bill payment schedule. Remember, your main goal is to work towards a better understanding of your financial debts. You will want to learn how to take care of your own debts, assets, and financial goals through your counselor’s advice. The debt management and debt consolidation is only stepping stone towards your own financial self-reliance.



Online A debt consolidation program to relieve debt

Regional cuisine of china szechuan style

The Szechuan style of cuisine arose from a culturally distinct area in the central western of part of China, a province known as Sichuan. This area of China came into its own culturally towards the end of the Shang Dynasty, during the 15th century. However, it was also the climate of the area that helped to shape the culinary traditions that were to arise from Sichuan province and make their way into the realm of international cuisine. The province from which the cuisine that the world knows as Szechuan evolved is often hot and humid, and this contributed to this necessity of preparing foods in ways that differ significantly from other regions of China. Szechuan cuisine is primarily known for its hot and spicy dishes, though naturally there is more to Szechuan food than spice and sauces rich and strong in flavor. A general overview of culinary history and trends reveals that, for the most part, areas that tended to spice heavily were areas in which the fresh food supply was not as reliable as in places that traditionally used a lighter hand in their use of spices.

The climate of Sichuan is conducive to faster food spoilage. This, particularly in the past, made necessary food preservation techniques that themselves left behind a strong flavor, such as salting, pickling, drying, and smoking. Thus, spices served to mask the flavors of less than fresh foods and those that have been preserved by methods that affect their natural flavors. In addition to masking certain flavors, the use of hot spices, such as chili peppers, tends to be more common to hot climates, as the sweat that they can produce is thought to cool the body. Much of the spicing of regional Chinese cooking is based upon bringing together five fundamental taste sensations – sweet, sour, pungent, salty and bitter. The balance of these particular elements in any one dish or regional cuisine can vary, according to need and desire, especially as influenced by climate, culture and food availability. In Szechuan cuisine, there are a variety of ingredients and spices used to create these basic taste sensations. These include a variety of chili peppers, peppercorns over various types, Sichuan peppers, which are in reality a type of fruit, not pepper, and produce a numbing effect in addition to their warm flavor. Sichuan peppers, also called flower pepper and mountain pepper, are a traditional part of the Chinese five spice powder, or at least of those that are modeled upon the most authentic versions of the spice combinations common to regional Chinese cooking.

Other ingredients used commonly in Szechuan cuisine to create the five fundamental taste sensations include different types of sugars, such as beet root sugar and cane sugar, as well as local fruits for sweetness. The sour comes from pickled vegetables and different varieties of vinegar. A special bitter melon is added to many dishes to offer the touch of bitterness that complements other flavors. Other spices and flavors include dried orange peel, garlic, ginger, sesame oil and bean paste. Salt is important to Szechuan cuisine, and the area produces uniquely flavored salts that help to distinguish authentic Szechuan cuisine from the other regional cuisines from China. Szechuan cuisine is marked by its rich traditional flavors, which stem from a culture of hundreds of years and are in part shaped by the natural forces of climate. Authentic Szechuan cuisine offers a unique dining experience made up of adventurous and creative taste sensations.



Online Regional cuisine of china szechuan style

Feng shui for your health and vitality

How many of us wake up in the morning feeling refreshed, happy and full of energy? How many of us, after a few hours in the office, still feel full of energy? Why certain environments uplift our spirits and make us breathe deeper, while others drain our energy? We seem to have forgotten how deeply connected we are with the space we live in and how important is for our well being to live in a balanced environment. As our lives are certainly not getting easier, the need to create a healthy and vibrant home environment cannot be overestimated. We have to have a safe, peaceful and energetically balanced space where our bodies can let down the daylong protective shield and focus on regenerating and self-healing.

Feng Shui is an ancient art and science that has been used for over 5,000 years to heal, balance and enrich people’s lives. It is a very complex body of knowledge that reveals how humans are connected to their environment and shows numerous ways to change specific aspects of one’s life by changing the living or working space. Being aware of this deep connection and its influence on all aspects of your life, it would be wise to employ feng shui knowledge in your home (and business!) to improve your health, vitality, and general well-being. One of the main theories of Feng Shui is the theory of Five Elements, which are Fire, Earth, Metal, Water and Wood. The elements are the five manifestations of Chi, or universal energy, and are represented in your environment by colors, shapes, textures, smells, taste, etc. They interact with each other in certain ways, the basic cycles being Constructive (where each element supports the other) or Destructive (where one element destroys the other). Understanding this theory and its applications in your life can be a very powerful tool indeed. In order to experience high vitality levels and an increased level of well-being, feng shui masters recommend living in a place that supports and nourishes your birth element.

Each of us has a predominant element, which is calculated by the year of birth. (You can find out your own element from specific tables in many feng shui books or by visiting our website) Once you know your own element, look around your place and see which element is predominant in it. Yes, any specific environment also has its own predominant element. For example, if your living room has purple curtains, art with predominant red-orange colors, lots of candles, a fireplace, objects in triangular, pointed shapes etc; the energy in the room is predominantly Fire. If your birth element is Wood, and you live in a Fire environment you will tend to experience headaches, inability to relax, have constant arguments with you family, often feel “burnt out.” As Fire burns the Wood, you need to focus on reducing the element of Fire in your environment, thus improve your well being. To remedy this situation, you may want to bring some of your own element (Wood) and/or the element of Water (which puts down the Fire.) Wood element can be brought into your environment by colors brown and green, plants (green bamboo is especially powerful!) objects in rectangular shapes, actual wooden objects and other. Water can be represented by actual water (a fountain) or images of water – oceans, lakes, rivers; as well as mirrors, wavy and curved shapes, colors black or deep blue, etc. The scenario described above will also be true for a person whose birth element is Metal, as Fire melts the Metal. However, an Earth or Water person will feel very good in that environment, and you can easily guess why. Both of these elements are not overpowered by the Fire energy. An old Chinese proverb states that feng shui consultants double as doctors. And for a good reason. The art and science of Feng Shui has a wealth of recommendations, cures, solutions for every person and virtually every space, be it home, business, garden, etc. Just like your body has a specific anatomy, the space you inhabit also has its own anatomy, with its own “do’s” and “don’ts.” Specific areas of your life, as well as specific body organs relate to specific areas of your home. For example, East is the area “responsible” for Family and Health. The element of East is Wood; therefore it is wise to avoid the placement of objects representing either Fire or Metal in this area of your home/business. If you suffer from certain body ailments, you can choose to place in the East area a picture, or any other representation of a medicine plant particularly healing for you (for example dandelion for liver problems) Here are some feng shui remedies to improve your Health and increase Vitality: Keep the center of your House clean, clutter free and open. This is considered the Heart of the House and is a sacred area in many old cultures. No heavy objects should be placed here. The center of your space is a very good place for a fountain, some crystals, bells/chimes with a harmonious sound, happy pictures of your loved ones, or any other items that speak to your heart. Reduce or eliminate metal objects from your Bedroom, as metal conducts electricity. Work on reducing the electromagnetic fields in your bedroom. Provide an ideal space for your body to regenerate, replenish and heal itself during sleep. Do not sleep under beams or sloped ceiling. Do not sleep with your feet in line with the door. Have a good, supportive headboard. Choose a natural mattress. Become aware of the quality of air in your space. Aerate your home often and use essential oils like lavender, chamomile, sage, frankincense, bergamot, etc to purify the space, uplift the spirits and improve your sense of well being. Consider using an air ionizer should this be necessary. Have specific plants that purify the air, such as peace lily, boston fern, spider plant, etc. Color green is very healing. Have a pleasing welcoming entrance. It should be well lit, spacious and have uplifting energy. If you face a wall or stairs, apply specific feng shui cures or your life could be stuck in unnecessary struggles. Surround yourself with objects you love and people that uplift your spirits. Try to spend some time in nature at least once a day. Make your home a healing refuge from the stress you encounter during the day by applying various feng shui cures and reducing the internal pollutants present in most homes. By following these simple, basic feng shui recommendations you can greatly improve your sense of well being. You can bring healing beauty and harmony into your life and create an environment that is fully supportive of you and your loved ones. Rodika Tchi, MSc, is a professional feng shui consultant. Her Vancouver-based company offers feng shui information, services and products. She can be reached at TchiConsulting. com



Online Feng shui for your health and vitality

Hoodia is the solution to weight loss

Overweight and obesity are actual problems for the American population, but much more for women who are trying to look better. Close to 60 million Americans are overweight or obese, but the problem is more relevant into the minorities. Acording to the Obesity Research conducted by the Center for Disease Control and Prevention (CDC), the hispanic population was the most overweighted in the ethnic groups in 2000. Estimations reach to more than 20 million people. Hoodia Diet is the solution for safe weight loss. Hoodia Gordonii contains a natural active ingredient, P57, which has only recently been identified. The P57 works as an appetite suppressant. Taking Hoodia Diet Tablets when you are hungry alleviates the feeling of hunger and so makes you less likely to snack between meals due to hunger. The Hoodia Gordonii Cactus has been used by the San indigenous people of South Africa for hundreds of years as an appetite suppressant and thirst quencher.

Extracts from this succulent have shown in clinical trials on obese subjects to reduce caloric intake by 30% to 40%. Significant weight loss has resulted from such a drop in caloric intake. Therefore, Hoodia is one of the best and most powerful natural appetite suppressant available, if used in conjunction with any diet. Hoodia will help you to stop snacking between meals. It will also help you to reduce the amount that you eat at meal times.

Dieting is not easy, you need to make your mind up that you are going to choose a diet plan that appeals to you and use Hoodia Diet Tablets to help you stick to your diet by reducing your daily calorie intake. Some users of Hoodia simply take the tablets 3 times a day, one hour before normal meal times, and this will allow them to eat less at each meal, so reducing daily calorie intake. Others find a low carb or low fat diet and take Hoodia Diet Tablets to stop them feeling hungry between these meals. By Viviana Aida Hoodia Latina ( hoodialatina. com)



Online Hoodia is the solution to weight loss

The cure

Gen Cells Cures will find the cure even if it means taking on President George Bush and the Vatican. The cure is definitely going to be found in stem cell research. When the first cure comes in from stem stem research it will have a domino effect as incurable diseases will soon vanish fom the world. Needlesss to say it is very unlikely that any stem cell cure will come from the good old USA. President Bush has frozen science in time dated back to four years ago. We simply are not going to wait for four more years to get started. I also just don’t like Big Brother breathing down my neck.

He has nothing to offer except red tape, detours and roadblocks. Thank God there is a world outside the United States. We have packed our bags and michroscopes and gone offshore. To find the cure we have had to adopt the motto “Have Michroscope Will Travel.” Science doesn’t have time for politics and religion to catch up. Nor does Gen Cells Cures have time for bureaucratic smoke and mirrors. The money to find the cure. Where are we going to find it? President Bush has the federal piggy bank all locked up for stem cell research. Maybe George Bush is the best man for the presidency. That’s what the American people believe.

Ok maybe he does a good job, but for our future health he has got to get the Big F. As the 48 nobel-prize winning scientists have clearly stated to the president in a letter, he has compromised our future. Let me spell it out for you, he has shaved 8 years off our lives. Hasn’t he given any thought to George and Barbara’s future. I know that I worry about the advancing years of my Mom and Dad. What are we going to do? Just put our senior citizens out to pasture. Seniors have just as much right to the cure as the next guy. I hear people talk about the fact that there is no reason to extend life because there is no room for our seniors because of future over poulation. Will I disagree. How greedy can you be? I live in a third world country where I see 15 people squeezed into one room. I don’t see a problem with over population. I would be happy to squeeze Mom and Dad into a little room with me if it meant they didn’t have to leave this world so soon .

And what about us, the baby boomers and that includes President George Bush himself. “What If” we get cancer or another deadly incurable disease. Unfortunately for many of us that “what if” has already become a nightmare of reality. Where does that leave us then? And what about the money needed to do the job? Private research, If you want to go on living the American Dream forget the extra yaht and the private plane. I would rather take a public cruise and fly with Richard Branson’s airline than die prematurely from a deadly incurable disease. Yes I am talking about investing in your own private stem cell research. Private Stem cell research for the wealthy has finally arrived. Gen Cells Cures is the only biotech in the world specializing in stem cell research for wealthy individuals. However, if you are poor and need the cure contact us anyway. One can’t do much in this world without money but we’ll try. Every penny invested at Gen Cell Cures goes into pure research. We don’t want a beautiful new biomedical research center like the Stowers Institute from Kansas City. All we want is the cure. We will work anywhere we have to to find the cure. A rented tin shack will do just fine, but we do need the best people and the best equipment. So if you know a billionaire without a cause, please have this billionaire take a look at what we have to offer with stem cell research. You can always make another Billion but you can’t buy another life. At Gen Cells Cures we will run for the cure, we will jump for the cure, we will sing with the rock band “The Cure” for the cure, in fact we will jump through hoops for the cure and most important we will work for the cure. We only lack one ingredient to find the cure and that ingredient is the money needed for the stem cell research. What’s It all about? …Finding the cure, that’s what it’s all about. The Cure! The Cure! The Cure! Article by Gerald Armstrong - scientist0707@yahoo. com Gerald is the owner of Gen Cells Cures Visit his group for information about “the cure” for incurable diseases and aging. Group address http:// msnusers. com/cures You have my permission to publish this article electronically or in print, free of charge, as long as the bylines are included. A courtesy copy of your publication would be appreciated.



Online The cure

Contact lens accessories at wholesale prices

The Internet is a great place to source and find all those wonderful and tempting wholesale contact lenses and contact lens accessory offers. You've probably spent hours in the comfort of your own home, surfing the 'net on your computer looking for those to-good-to-be-missed special offers. Looking at it that way any amount of time searching is worth it, if it means you're getting top-quality products at the lowest possible prices! This is especially true of any contact lens accessories purchases you make at wholesales since these items help you to maintain your lenses in tip-top condition, keeping them safe for your eyes. However, your eye safety doesn't actually start with the contact lens accessories wholesale Internet specials you found recently, though. It starts with an examination and prescription from your eye doctor or eye care professional. As with everything else in life, everyone is an individual and although we look the same and some of us even share the same eye color, our eyes are truly unique. That's why you must remember that contacts are corrective eye wear.

They are prescription medical devices that only your eye doctor or eye care professional should prescribe and fit. It's easy enough to practice good common sense eye care for yourself. For instance, don't borrow and wear other people's contacts as this could cause eye infections, damage your sight and lead to significant vision problems. In cases like this no matter what contact lens accessories wholesale deals you got on the Web, even the latest and greatest must have accessory can't help you when you use lenses inappropriately and incorrectly. And don't get complacent just because you've been using contacts for years - in fact, you're likely to have picked up bad habits and could actually be abusing your contact lenses and your special contact lens accessories. It's important every year to make sure that you set an appointment to have your eye doctor or eye care professional review your prescription. That way, you can be certain that your lenses are the best possible fit and you can ensure they are as safe and beneficial as possible. That way you can keep on surfing the 'net, finding as many of those contact lens accessories wholesale special offers you want, till your hearts content!



Online Contact lens accessories at wholesale prices

Probing chemotherapy nausea and vomiting

Cancer patients are not new to the term chemotherapy. It plays a major role in treating their cancer. In the past, chemotherapy referred to the use of any drug or medication to treat disease. For example, the ingestion of antibiotics is a type of chemotherapy. Today, however, the word chemotherapy has become exclusively associated with cytotoxic chemicals used for treating cancer. The history of chemotherapy traces back to medical observations in World War I. Soldiers who were exposed to chemical warfare, Sulfur Mustard, suffered from the lowering of their white blood cells, especially lymphocytes. Following that observation, Nitrogen Mustard, a similar and yet less toxic agent, was used in patients with high white blood cells (lymphoid leukemia) and then in lymphomas. Nitrogen Mustard indeed lowered the count of lymphocytes and assisted in the management of lymphoid cancers. Today, this drug still plays a major role in the treatment of Hodgkin's Disease. If one is considering chemotherapy for treating cancer, there are always possible adverse effects in undergoing this procedure.

Although chemotherapy is relatively simple and painless, it has risks. The most common side effects of chemotherapy include neutropenia (a low white blood cell count), anemia (a low red blood cell count), thrombocytopenia (a low blood platelet count), depression, hair loss, nausea, and vomiting. Some people never experience nausea or vomiting. Others are nauseated every day of treatment. Many people describe having “stomach awareness” --- a condition when loses appetite even if there are not symptoms of stomach discomfort or nausea. Some people have nausea that lingers for more than a week after a chemotherapy session. Thankfully, these side effects can almost always be controlled, or at least substantially reduced, by the use of a variety of drugs. Antiemetic drugs act centrally on the gastrointestinal system to suppress symptoms of nausea. Drugs that act primarily on the central nervous system receptors or the vestibular system include butyrophenones (e. g., haloperidol), phenothiazines (e. g., prochlorperazine, chlorpromazine), antihistamines (e. g., cyclizine) and anticholinergics (e. g., hyoscine).

Antiemetic drugs with direct effects on the gastrointestinal system include metoclopramide, domperidone and octreotide (an analog of somatostatin). Antagonists of 5-HT3 receptors (i. e., ondansetron and tropisetron) have both central and gastrointestinal effects, drugs that are considered to be effective but quite expensive. Specific medications should be selected to match the drug effect to the cause of the vomiting. Other matters to be considered in drug administration include the side-effect profile, route, timing, form of administration, cos of the drug, and a variety of patient-specific factors. Nausea makes a cancer patient experience anxiety, making their discomfort more pronounced.

The normal uncertainty and worries that accompany the first chemotherapy session adds to the difficulty experienced by a cancer patient. The same emotional factors that can cause nausea before a test or seeing a doctor can also lead to more nausea before chemotherapy. Plus, anxiety can cause indigestion and heartburn, which can make matters worse. Constipations and coughing due to bronchitis or a bad cold can also contribute to nausea. Sometimes, nausea can also be a side effect of pain medications. Nausea and vomiting are common side effects of chemotherapy treatment for cancer. But they aren't inevitable. There are newer nausea and vomiting treatments that can help prevent these side effects. The doctor and patient can take steps to prevent or decrease nausea and vomiting associated with chemotherapy and to make the patient more comfortable during the cancer treatment.

The side effects of chemotherapy come about because cancer cells aren't the only rapidly dividing cells in the body. The cells in the blood, mouth, intestinal tract, nose, nails, vagina, and hair are also undergoing constant, rapid division. This means that the chemotherapy is going to affect them too. Before chemotherapy starts, it's important to understand nausea and all the factors that can affect it. By being informed and working closely with a health care team, perhaps one can avoid nausea and vomiting entirely --- making the process of beating cancer less difficult for a patient to endure.



Online Probing chemotherapy nausea and vomiting

Symptoms of detoxification when you quit smoking

Smoking is an addiction that is connected with both your body and your mind. Your body will start to detoxify itself shortly after your last cigarette. Nicotine increases the levels of pleasure inducing chemicals in your brain. It also acts as a central nervous system stimulant, and increases both your blood pressure and your heart rate. Once you stop smoking and stop the nicotine doses, your body responds with severe cravings and withdrawal symptoms. These symptoms try to convince you that you need to light up a cigarette. Your physical withdrawal will last only a limited time.

The long-term cravings are due to the psychological dependency. Many smokers avoid quitting because they are afraid of what will happen to them when they stop. Common withdrawal symptoms from nicotine include restlessness, inability to sleep, weight gain, constipation and lack of concentration. These symptoms are short lived, with the most extreme symptoms disappearing after three to four days. During this time period, you can treat yourself the same as you would if you had the flu. Take it easy, get plenty of rest, and maybe take some time away from work. It will pass, and you will feel much better in a short time.

The first thing is to just stop smoking. Some smokers believe that it is enough just to gradually reduce the number of cigarettes smoked. This is completely wrong. If you continue to smoke, you are not allowing detox processes of your body to work. Moreover, it is a slippery slope that usually leads to unsuccessful results – after all, you need just one stressful situation to increase your smoking again. Just 24 hours after your last cigarette, your blood pressure and pulse rate return to normal. Within a week of quitting, your risk of heart attack begins to decrease, your sense of smell and taste improve, and your breathing becomes easier.

Various products can help the quit smoking detox process. There are medications, herbs and even specific foods that can help. All you need to do is to ask your doctor for the ones most suitable for you. The body detoxification is only one part of the quitting process. The psychological addiction is more difficult to deal with, and the temptation to light up can remain strong even after the physical cravings have vanished. It’s important to have a plan for dealing with situations and events that could trigger the desire for a cigarette.



Online Symptoms of detoxification when you quit smoking

Beet a great fighter of diseases

Beetroot is one of the most common ingredients used in a salad. With a hard exterior the sweet mouth-watering interior makes it worthwhile to have this vegetable. There are different types of beet like reddish-purple hue, other varieties like white, golden-yellow or sometimes even multi-colored. It has a good content of sugar in comparison to other vegetables. Even though they are very high on sugar their calorie content is very low. With the immense number of benefits it protects you from heart disease, birth related short-comings and cancer like colon cancer.

It runs a long battle which is fought against this cancer. Beets can be eaten in many forms such as raw, juice, cooked and pickled. The level of antioxidant increases in liver. The cholesterol level also falls which is one of key areas of concern for many cardiovascular diseases. People suffering from kidney or gallbladder problems should avoid eating beet. People who want to increase their calcium content should also avoid eating beet as it may prove to be a hindrance in building calcium. Home Remedies from Beet It is very useful in fighting anaemia as it contains potassium, phosphorus, calcium, sulfur, iodine, copper, carbohydrates, protein, fat, vitamin B1, B2, B6, niacin and vitamin P. Beet gets rid of dandruff. By boiling the top and root of the beet in water and later the water used on your scalp every night makes a huge difference. If you can find white beet it would work even better. Having raw beet and even in juice form at least couple a times a day can refresh you and rejuvenate you from a tired day. Having carrot and beet juice or cucumber juice has known to work against allergies. A combination of all these juices, in a day is good enough for a daily battle. To fight appendicitis you should use the combination of beet and cucumber juice 100 ml, mixed with 300 ml of carrot juice. If this is consumed twice daily, it may just do the needful. The beet juice is also known to be very useful to fight arteriosclerosis. It helps to keep the blood vessels and the arterial system in a very sound condition. You can use combination of different vegetables like carrots, spinach and beet to make a great concoction. Arthritis is a very problematic condition. You can fight it by having a green juice from any leafy vegetable which is mixed in equal proportion with carrot, celery and beet juice. The presence of alkaline content in the raw juices dissolves the deposits accumulated around the joints and other tissues. Warning: The reader of this article should exercise all precautionary measures while following instructions on the home remedies from this article. Avoid using any of these products if you are allergic to it. The responsibility lies with the reader and not with the site or the writer.



Online Beet a great fighter of diseases

The truth about stuffing envelopes and home assembly programs

Two of the oldest scams around appear to be as popular as ever. I'm referring to stuffing envelopes and home assembly programs. Let's talk about stuffing envelopes first. Ads for envelope stuffing "opportunities" seem to be everywhere--from your mailbox to your newspaper to your e-mail box. Promoters usually advertise that, for a "small" fee, they will set you up to earn big money by stuffing envelopes at home. And they claim that they will pay you a dollar or more for each envelope stuffed, resulting in hundreds or thousands of dollars for you each week. Now I want you to think about something very carefully.

Why would any legitimate company, pay you a dollar or more for each envelope you stuff, when they can use high-tech mailing equipment that can stuff thousands of envelopes at a time for only pennies apiece? The answer is, THEY DON'T PAY YOU! Here's how the scam works: After you send in your money, you will receive a letter telling you to place the same "envelope-stuffing ad that you originally responded to, in newspapers or magazines, or to send the ad to friends and relatives. The only way you'll ever earn any money is if other people fall for the scam like you did, respond to your ad and pay the fee. Home assembly scams work pretty much the same way as envelope stuffing scams. This scam requires you to invest money in instructions and materials and many hours of your time to produce items such as baby booties, toy clowns, and plastic signs for a company that has promised to buy them. Once you have purchased the supplies and have done the work, the company often decides not to pay you because your work does not meet certain "standards." You are then left with merchandise that is difficult or impossible to sell. If you have spent money and time on a work-at-home program and now believe the program may not be legitimate, contact the company and ask for a refund. Let company representatives know that you plan to notify officials about your experience. If you can't resolve the dispute with the company, file a complaint with the following organizations: The Federal Trade Commission works for the consumer to prevent fraud and deception. Call 1-877-FTC-HELP (1-877-382-4357) or log on to: http:// ftc. gov Also contact: * Your state's Attorney General's Office. * Your local consumer protection offices. * Your local Better Business Bureau. * Your local postmaster. The U. S. Postal Service investigates fraudulent mail practices. * The advertising manager of the publication that ran the ad. The manager may be interested to learn about the problems you've had with the company.



Online The truth about stuffing envelopes and home assembly programs

Microsoft great plains ecommerce stored procedures approach

Since Version 8.0 Microsoft Business Solutions Great Plains & Great Plains Standard are available on Microsoft SQL Server and MSDE (which is in fact MS SQL with database size limit of 2GB). As eCommerce designer you should be aware of several options and customization tools in your disposition, when you utilize Microsoft Great Plains 8.5 (June 2005), 8.0, 7.5, Great Plains Dynamics/eEnterprise 7.0, 6.0, 5.5 or 5.0 Great Plains Dynamics C/S+. When you have old versions (7.5 and prior) we assume that you are on MS SQL Server 2000/7.0, because if you are on Ctree or Pervasive SQL/Btrieve – you should use ODBC / RDO connection tools, such as MS Access and its queries or use MS SQL Server Linked Server technique with OPENROWSET statements. So, lets assume that you are on MS SQL Server. You have basically two options eConnect (you should pay for the reg key/license and this is SDK) and custom stored procedures. We’ll only consider custom stored procedures way here: Stored Procs. The first question is – are we allowed to create stored proc in Great Plains DYNAMICS and companies databases. The answer is Yes – opposite to such products as Microsoft CRM (where you are banned to create any custom object in MS CRM database, and instead you create your own custom database and place all your procedures and views there) – you are encouraged to create your stored procedures and place them in both DYNAMICS and Company databases. You need to know the anatomy of Great Plains tables structure Tables Structure. If you launch Great Plains workstation and follow this way: Tools->Resource Descriptions->Tables – then you are in tables descriptor, sorting by tables Physical, Logical or Tables Group Technical names. This is all Great Plains Dexterity architecture realm and it is relatively complex and not “developer-friendly” – but if you create sample transactions in Great Plains – you can figure out where data should be populated Sales Order Processing. Or SOP module. This is usually the core of eCommerce development – transactions should go into SOP tables (with SOP prefix): SOP10100, SOP10200 and others. If you are selling to your existing customers, then customers are in Receivables Management module (AR) with AR prefixes: RM00101 – is Customer Master, RM00102 – customer address master, etc. Sales Order/Invoice Allocation dilemma. Great Plains SOP module is working in concert with Inventory control, making allocation of inventoried items in IV. So, this is very challenging to replicate allocation logic. We recommend do not allocate in Orders and Invoices and do allocation by operator, who processes the internet orders batch Sales Order transfer dilemma. If you are using eConnect – this is kind of issue, so you have to appeal to GP internal architecture and do it with the stored procs approach. Good luck with implementation, customization and integration 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-630-961-5918 or 1-866-528-0577! help@albaspectrum. com



Online Microsoft great plains ecommerce stored procedures approach