Less Than Dot – Blog – 6 ways to import data into SQL Server

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/title-12

Advertisements

5 Ways To Stay Connected On The Road

5 Ways To Stay Connected On The Road

By: Nicholas Salls

No matter the business or industry you will find yourself on the road and away from your comfortable office space with your business tools at your side.  Here are a few ways to stay connected to your business or office no matter how far you are away.

5. Drop Box Program and Mobile Application
This is your company file cabinet on an energy kick!  Automatically syncs your office computer with a cloud file cabinet allowing you to access any of your files on your phone or at any computer world wide.  Easy to install tools and sharing features makes this a program to have!  Visit https://www.dropbox.com for more info!

4. Log Me In
An account with log me in allows you to access your office computer exactly how your looking at it right now, on the road!  Its perfect for programs you need to access like an accounting software, design programs or any kind of software your running on your computer. Visit https://secure.logmein.com/ for more details!

3. Web Mail
Just like a smart phone your web mail can keep you connected when you are not at the office and comes in many different styles and brands.   Long time web mail company’s include AOL, Yahoo, Gmail but you can also connect to your business mail (mailbox@mycompanydomain.com) via a web-mail software / link offered by your web designer.  Just type in the address into any computer you are around on the road, log into your secure account and up pops all of your important mail and contact information.

2. Smart Phone or Tablet
A smart phone can come in all shapes and sizes from Androids to Blackberry’s to IPhone’s and more.  They all come with the same basic features to check  your mail and stay in contact with your social network like Twitter, Facebook 4Square with easy to use applications.  Don’t miss an important lead through one of these powerful venues by not having access to your important company mail box.  Just remember to bring a charger with you, running your GPS, checking email and running apps can drain your battery quick!  This article title Running an entire business from smartphones tells you everything about how important a smart phone can be to a business.

1. Website presence
A website acts as a neon sign lighting up your office location to potential customers & keeping existing customers excited about their business with you.  With sites ranging from a simple flyer/brochure type of design to a full ecommerce platform with a full list of your products online for sale.  A website keeps your phone ringing, email box full of leads  and your file cabinet full of new contracts.  All from the road with the help of a website to keep your business open 24-7, even when your not around!

Have other things that help you stay connected from the road?  Lets hear about your favorites!


Add a Links Manager to your Website

Links Manager to your Site

Use your link manager or directory to organize links instead of a single long page of links or items. Enhances your search engine presence with unique content only your site has with your own directory of content related to your website.   Include a description, title, website url, email and pick a category of your liking to display a new link.  Below is a screen show of administrator which allows you access to manage your directory.  From here you can approve or decline a link that was suggested to your site or add a new site of your own.

Users can suggest their own link to your site via the ADD A SITE page. This sends you an email where you can confirm or decline the link before showing on your site.  Installation Into Your Website can replace a simple links page and you can also install the categories into other pages of your site as well (Live sample here at Commercial Real Estate in NH).


Custom installation is always available, contact NH Web Design– WGC Designs to add a link directory to your website today!


ENABLE Your Mail With Speed And Responsiveness

Accessing your mail on the road or away from your office computer is an important feature to your business, the interface and speed of the system can be the difference maker too.  The latest version of Mail Enable comes with a new interface that to its web mail system improving the style by adding large graphic icons along with speeding up the main functions.  When opening your inbox and clicking on an email to switching from your contact manager to your inbox again has sped up significantly.

Note From Mail Enable

Latest Version MailEnable™ Version 5 includes a new webmail client which has been freshly laid out and styled with a totally new appearance, designed for a pleasant experience.   The webmail client has been optimized for improved speed and responsiveness. It utilizes page caching and requires fewer page accesses to the server, which means you will spend less time waiting in Version 5.  Version 5 is also designed to adapt to touch-screen clients such as the Apple iPhone & iPad. The interface is built to adjust to the client browser resolution on detection, giving you optimized screen space and usability.

Screenshot of the new log in screen, allowing users to switch Skins or Language.


Inbox screenshot showing large icons at the top.


Contact Manager with Options To Search, Sort and Add Photos

Settings Options Allow you to Changed Inbox Layout with your Preview Panel in different locations or Not Showing at all.  You can also change the colors and backgrounds to match your style as well.

Other web based email systems provided by WGC Designs include HORDE Mail (More For Technical Users)  and Round Cube Mail Systems. 


One PLACE Your Business Should Be

Have an business with a physical address or want to drive more traffic to your website?   Is it listed in Google Places?  If not get it listed TODAY! Great way to start receiving more traffic to your website and only takes a few minutes to setup! http://www.google.com/places/

Make sure to write a detailed description with keywords of your major services/products plus other keywords of local towns and states.  The description field is limited so you will have to be creative!

www.google.com

Google Places helps people connect with the places they love.

The New Agent Center.. Tools For All Your Agents!

Introduction to the NEW Agent Center!
The new agent center keeps your agents and staff connected from anywhere! With our easy to use console you follow up on office leads or get background information on a contact with our social networking search tools (Facebook, Google, MySpace, LinkedIn..).   Plus many other new features including easy to find web mail access, property flyer builder and much more!


Take a look at each feature below:

  ● Contacts Import and store a new prospects or search your and the office archive!

  ● Marketing Create property flyers of all your listings or email search results!

  ● Leads Import and store a new prospects or search your and the office archive!

  ● IDX View printable reports of your listings traffic or start a property flyer of each!

  ● Profile Edit your contact info, update your photo and use the new profile editor!

Create property flyers with Easily Integrated IDX Images Into Your Flyer!

These Tools are available to Broker Office Website Users of WGC Designs, Contact us at 603-443-6008 or email info@wgcdesigns.com


Featured ECommerce Online Store Website Design

Featured Design Project At WGC Designs

Customer wanted a new ecommerce website to replace their existing old and not working well website. Their existing website was a template based site with limited graphic and custom options available. We starting by meeting with the owner directly and gaining knowledge of their business and exactly what they wanted. In the end we created a beautiful website that has tripled their sales from the past 4 years in the first 2 months! Includes dynamic UPS, USPS shipping pricing along with a CMS software to allow administrator to add and update products 24 hours a day. Some other features include advanced SSL certificate, online card processing, inventory updating software that notifys admin when product quantity is low in stock, drop down menus and more.

Currently LIVE ONLINE – Visit www.Costumania.com to browse the website.

Technology:
ASP, PHP, HTML, SSL, Card Processing, Drop Down Menu, Statcounter.com, Xenu, Google Webmaster, Javascript, VBScript

Time Frame:
4 Weeks from first meeting to site LIVE online, Tested with Xenu for bad links & images

View the live web site at:
www.Costumania.com

Below is a LIVE example of the sites homepage, with center section used to change up the website each season. Quick Search & Drop Downs Also.

Web Design Examples & Portfolio . New Hampshire Web Design . IDX . Real Estate Web Site Design / Featured Project At WGC Designs

Screenshots of ECommerce Website Design Example Product Item Page with Options for Sizes/Colors, Sharing with Facebook and Zoom of Photo

Web Design Examples & Portfolio . New Hampshire Web Design . IDX . Real Estate Web Site Design / Featured Project At WGC Designs

Below is a ECommerce Website Example of Checkout Page with SSL, USPS/UPS Live Shipping and Card Processing

Web Design Examples & Portfolio . New Hampshire Web Design . IDX . Real Estate Web Site Design / Featured Project At WGC Designs

Example Project Stages To Launch:
Stage 1: Initial Design Draft & Layout Mock Up
Project starts with a face to face meeting or fill out our Website Setup Work Sheet. With input of colors, styles, required pages and the type of project we developing a minimum of 5 different layouts and color schemes for the client to pick from. submitted 2-3 more homepage variations to the client to nail down all remaining specifics to the site.

Stage 2: Creation of Fully Working Demo Site
With a layout picked out we create a fully working demo website with all of the features you wanted. Building & importing the content into your website. Then we thoroughly tested all of the pages along with adding tags for optimal search engine optimization. During this stage of the project we include the major features you want including an IDX system, Ecommerce storefront or any feature you require.

Stage 3: Launch LIVE Site & SEO
The 3rd stage includes launching the site and creating a site map of all the pages in your new website and submitted the site to all of the major search engines to indexing in their results. We submitted your website to Google, Yahoo, Ask, Dmoz, Bing and many others. If your site is a real estate website or ecommerce website your site could include as many as 50K+ pages. Plus we make the content of the site is available for updating 24-7 by the client via our Content Management Software.

Stage 4: Ongoing Updates & Support
After your website is launched most sites take 3-4 weeks to get fully listed into most search engines, during this process its a great time to increase your sites popularity and add reciprocal links. WGC includes Free Tech Support, anytime after please contact us with any trouble or questions about your site.

Worried about putting together the content of a website like this?
WGC helps and creates the content of the site to make the process quicker and painless for the client!

Read About Featured Website Design Projects:
ECommerce Web Design, NH Real Estate Web Design, NH IDX Web Design, NH Lakes Region Real Estate Site Design


Launch of Upgraded Email System

HORDE Software Upgrade for Email System
Your new web mail access includes a ton of new features including searching your mail for old messages, calendar, notes, spam filtering with black list and white list sorting along with automatic cleaning of your inbox for faster loading. Customize the way the screen looks (color, layout and more). The new system includes a ton of features the old system did not have which may cause some confusion because some of the features are options that need to be enabled before use.

FIRST GO TO YOUR LOG IN PAGE: Webmail.YourDomain.com
You have the option to log in with the POP3 Server or switch to the IMAP Server


What is Horde? Horde gives you direct online access to your POP3 mail box where the email is stored before you download it. Horde can also be very useful when you are away from your office as you can see your email from ay internet browser.

Your log in homepage portal can be customized to show weather, calendar, notes and more!

Your In box is color coded with options to search, flag messages, filter spam and more.


Where Did My Trash Can Go?

First MAKE SURE you are logged in under IMAP Server (Option When Your First Log In) Then go to your inbox, click Options at the top.

Choose “Deleting and Moving Messages” (in the middle).

Put a check mark by the option “When deleting messages, move them to your Trash folder instead of marking them as deleted?”

Under “Trash folder:” select Create a new trash folder

Give it the name Trash and hit OK

Click Save Options

Next time you login the Trash folder will appear.

How Can I Stop the Spam Coming Into My Computer?
To delete your overnight/weekend SPAM before it hits your PC and slows it down, or to be able to access your emails from anywhere with an internet connection.

Unfortunately Horde will not delete spam unless you open the webmail interface.

If you follow the instructions below and when you get into the office in the morning you open your web browser and Horde before opening your email client and doing a send and receive, Horde will delete most of your spam stopping your PC and internet connection slowing down to a snails pace while it sorts all your SPAM out.

  1. Open your web mail domain in a browser (IE, Mozilla, AOL..) If you do not know how to do this please refer to your SITE INFORMATION DOCUMENT you’ve been sent or contact nsalls@WGCDesigns.com
  2. NOTE: unter your USERNAME (email address) and PASSWORD but ENTER the IMAP Server & English US as settings.
  3. Once Horde is open click on the options menu button at the top.
  4. PERSONAL DETAILS. This is optional in case you are going to use Horde to respond to emails if you are away. If not there’s no need to bother. SKIP TO No 12.
  5. Open PERSONAL DETAILS
  6. Select EDIT YOUR IDENTITY
  7. Leave as the DEFULT and add your personal information into the boxes including a signature.
  8. Tick SAVE SENT MAIL and select the DEFAULT selection from the drop down.
  9. Now click on CREATE
  10. Now go back to options by clicking OPTIONS in the top menu
  11. Ignore SERVER INFORMATION, LANGUAGE and TIME ZONE.
  12. We’ll come back to FILTERS.
  13. Click on MESSAGE VIEWING and tick the “Filter message content for profanity?” box.
  14. Click SAVE OPTIONS.
  15. Select “Deleting and Moving Messages”
  16. Tick both boxes and click on SAVE OPTIONS.
  17. Open MAINTENANCE OPTIONS and untick the top box “Perform maintenance operations on login?”. All the top boxes here should be unticked.”Purge old message in the Trash folder?” should be ticked. Leave rest at default.
  18. Select DISPLAY OPTIONS.
  19. Change the default number of email message displayed on the page from 20 to at least 100. I have mine set at 500 as it’s easier to scroll down that open a new page.
  20. Click on SAVE OPTIONS.
  21. Ignore LOGIN TASKS as the default is fine for our purposes.
  22. Select NEW MAIL.
  23. Click on the drop down and select “Every 5minutes”.
  24. Leave the tick box blank and click on SAVE OPTIONS.
  25. Ignore ADDRESS BOOKS. If you plan to use the online mail service instead of your PC mail client (e.g. Outlook Express) you can set up your address book here.
  26. Now lets go back to FILTERS.
  27. Tick the top 2 boxes “Apply filter rules upon logging on?” and “Apply filter rules when mailbox is refreshed?”
  28. Click on SAVE OPTIONS
  29. Click back on FILTERS then click on the “Edit your filter rules” link.
  30. Here we can set up message filters in the same way we can in Outlook or Outlook Express. For example type the word “watches” into the box, tick the SUBJECT box and click on create. This creates a rule that deletes any emails with the word watches in the subject line. I suggest you continue to create rules for the following:
  31. Search SUBJECT only for: watches, cartier, sex, viagra, manhood, adult, medical, enlarge, pills, orgasm, orgasms, sexually, sexuality, porno, casino, trader alert, trade notice, rolex, medications, meds. Please be careful and think about what your legitimate senders might use.
  32. Search SUBJECT and BODY for: w4tches, repl1cas, blowjob, britney, penis, phallus, cock, ad0be, micros0ft, viagra, anatrim, pornstars, disc0unts, r0lex, pharmacy, cial1s, amb1en, v1agra, val1um, cial1s, xan4x, merid1a, pharm4cy, cart1er. Please be careful and think about what your legitimate senders might use.


Custom IDX Broker Website Design Project

Featured Project At WGC Designs

Currently LIVE ONLINE – Visit www.CBOldMill.com to browse the website.

Creating a custom IDX Broker real estate website for a new client in New Hampshire’s Lakes Region. Their existing website was a template based graphic designed web site that did not automatically feed their IDX properties directly to the site making them input each new listing and update as it happens. With the WGC Real Estate system the site includes an Integrated IDX for embedded listings directly into the page text for enhanced search engine optimization. Plus they no longer need to worry about updating and keeping their website fresh.

Below is a LIVE example of the sites homepage, we put a quick search on top for easy IDX searching on any page!

Web Design Examples & Portfolio . New Hampshire Web Design .  IDX . Real Estate Web Site Design / Featured Project At WGC Designs

Screen shots of NH Lakes Region Rental Search & NH Real Estate Search of NNEREN IDX System!

Web Design Examples & Portfolio . New Hampshire Web Design .  IDX . Real Estate Web Site Design / Featured Project At WGC Designs Web Design Examples & Portfolio . New Hampshire Web Design .  IDX . Real Estate Web Site Design / Featured Project At WGC Designs

Below is a NH Lakes Region Community Section with Details Taken From Wikipedia of each NH Town in the Area

Web Design Examples & Portfolio . New Hampshire Web Design .  IDX . Real Estate Web Site Design / Featured Project At WGC Designs

Technology: ASP, PHP, HTML, Statcounter.com, Xenu, Google Webmaster, JavaScript, Vb Script
Time Frame: 4 Weeks from first meeting to site LIVE online, Tested with Xenu for bad links & images
View the live web site at: www.CBOldMill.com


Example Project Stages To Launch:
Stage 1: Initial Design Draft & Layout Mock Up
Project starts with a face to face meeting or fill out our Website Setup Work Sheet. With input of colors, styles, required pages and the type of project we developing a minimum of 5 different layouts and color schemes for the client to pick from. submitted 2-3 more homepage variations to the client to nail down all remaining specifics to the site.

Stage 2: Creation of Fully Working Demo Site
With a layout picked out we create a fully working demo website with all of the features you wanted. Building & importing the content into your website. Then we thoroughly tested all of the pages along with adding tags for optimal search engine optimization. During this stage of the project we include the major features you want including an IDX system, E commerce storefront or any feature you require.

Stage 3: Launch LIVE Site & SEO
The 3rd stage includes launching the site and creating a site map of all the pages in your new website and submitted the site to all of the major search engines to indexing in their results. We submitted your website to Google, Yahoo, Ask, Dmoz, Bing and many others. If your site is a real estate website or ecommerce website your site could include as many as 50K+ pages. Plus we make the content of the site is available for updating 24-7 by the client via our Content Management Software.

Stage 4: Ongoing Updates & Support
After your website is launched most sites take 3-4 weeks to get fully listed into most search engines, during this process its a great time to increase your sites popularity and add reciprocal links. WGC includes Free Tech Support, anytime after please contact us with any trouble or questions about your site.

Worried about putting together the content of a website like this?
WGC helps and creates the content of the site to make the process quicker and painless for the client!

Past Featured Projects:
– Southern NH IDX Real Estate Website
– Seacoast NH Real Estate Office Site Design


Rotating Table Background Tutorial

Rotating HTML Table background using JavaScript

Recently working on a redesign for a client i needed a script for a rotating table background, not a page background or just image slide show script.  After a bit of searching i found the perfect script in a familiar source, Dynamic Drive . com.  They have a great resource of scripts to help with anything from asp, php and more!

Take a look at the script below:

<!DOCTYPE html PUBLIC “-//W3C//DTD HTML 4.01//EN” “http://www.w3.org/TR/html4/strict.dtd”&gt;
<html>
<head>
<title></title>
<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″>
<style type=”text/css”>
#bslide {
height:225px;
width:140px;
}
</style>
<script type=”text/javascript”>

//Background Image Slideshow- © Dynamic Drive (www.dynamicdrive.com)
//For full source code, 100’s more DHTML scripts, and TOS,
//visit http://www.dynamicdrive.com

//Specify background images to slide
var bgslides=new Array()
bgslides[0]=”photo1.jpg”
bgslides[1]=”photo2.jpg”
bgslides[2]=”photo3.jpg”

//Specify interval between slide (in miliseconds)
var speed=3000

//preload images
var processed=new Array()
for (i=0;i<bgslides.length;i++){
processed[i]=new Image()
processed[i].src=bgslides[i]
}

var inc=-1

function slideback(){
if (inc<bgslides.length-1)
inc++
else
inc=0
document.getElementById? document.getElementById(‘bslide’).style.backgroundImage=’url(‘+processed[inc].src+’)’ : document.all[‘bslide’].background=processed[inc].src
}

if (document.all||document.getElementById)
window.onload=new Function(‘slideback();setInterval(“slideback()”,speed)’)

</script>
</head>
<body>
<table id=”bslide”>
<tr>
<td>&nbsp;</td>
</tr>
</table>

</body>
</html>

View the original post at:

http://www.dynamicdrive.com/forums/archive/index.php/t-4103.html