Simple Solutions

Shopify Experts Srilanka

2018-11-18T02:17:00.001-08:00

Shopify, a complete eCommerce platform that lets you start, grow, and manage a business by setting up an online store to trade your goods. Shopify allows you to create and personalize your online store. It lets you sell using various options such as social media, online marketplaces, pop-up shops, web, mobile, and brick-and-mortar locations.

Setting up a Shopify store isn't an arduous task once you have Ecom Services Shopify Experts at your beck and call. Ecom Services is a Shopify expert in Sri Lanka that help in setting up a Shopify online store, designing it, and running marketing campaigns. We will solve your problems in a jiffy while giving you a good night's rest. Our Shopify experts are specialized consultants who help both brands and entrepreneurs strengthen their online business.

We are Sri Lanka most affordable Shopify experts that are helping business across the world. We will work hard to help grow your business because we love what we do. Since most entrepreneurs who do not have a well-grounded I.T. background tend to be doubtful of proceeding to eCommerce without dead-on consultancy, technical advice on investments, etc. Ecom services Shopify experts are ready to deliver this much needed and desirable service.

Ecom services Shopify experts are a passionate team of professional designers, developers, marketers, store setup experts and consultants with clients worldwide. We are dedicated as we will work with you every step of the way, from planning and design of your online store, site build, launch and beyond. We can also help you with Shopify customer email design, wholesale shop setups, custom theme design, email setup, and pretty much everything else.

As a functional part of the Shopify experts Sri Lanka, we will make your store to dazzle and intimate you with most major eCommerce platforms that will help turn your vision into reality quickly and securely.

At Ecom services Shopify experts Sri Lanka, we give your store the ability to accomplish all the outstanding wants of your business and more. Because every entrepreneur and brand is different, we afford you the opportunity to make your eCommerce platform not only perform the way you want it to but also to engage in things you never thought were possible.

Ecom services Shopify experts Sri Lanka provides you with an exceptional design, customized store, and savvy marketing services to help propel your online sales. We are leading Shopify partners and Shopify experts as we are flexible, yet structured in our approach. You are in safe hands with Ecom services Shopify experts.

We pride ourselves on nurturing ready-made strategies, which are designed to make your Shopify store as profitable as possible. No matter what stage your business is, we take time to understand it. Ecom services Shopify experts think outside the box helping you build a brand as a well as grow your business, as we are not the one-size-fits-all kind of agency.

And once your site is live, our team-Ecom services Shopify experts-provide unending support to improve conversion and boost sales.

SET UP YOUR OWN ONLINE SHOP WITH SHOPIFY STORE

2018-02-04T02:45:00.002-08:00

Shopify offers 14-day free trial to get you going. To launch your Shopify store, you must sign up for an account. If you think you will need more time to setup your online Store please contact ecom services support team to sign up. Our Shopify Experts team will help you for free.

1. Sign Up with Shopify

To start, visit Shopify.com. Click here to visit directly to the signup page.

Enter your email address, click on Get Started button & continue the signup process.

In Tell us a little about yourself section it will ask few details about the business.
Your store name needs to be unique in Shopify or it will ask you to choose something else.

Then it will ask your address details to register your account.

Once complete, click on “Enter my Store”.

2. Start Setting Up Your Shopify Store

After you’ve signed up you’ll be directed straight to your store admin screen. Now you are ready to start customising your store’s look, uploading products and setting up payments and shipping.

Shopify home screen Your home admin screen tells you all you need to know to get you up and running.

3. Choose a Shopify Theme

Shopify has its own official theme store. These themes are all guaranteed that it’s fully responsive any device.

All themes come with a comprehensive list of modifications you can make without having to touch a line of code. The premium themes come with more modifications, but that’s not to say you can’t achieve a great looking site with a free one.

If you are looking to have more customization beyond the theme options you get support ecom.services Shopify experts to fulfil your requirement.

To find a theme that suits your needs we recommend the following:

1. Browse the Theme Store
Log into Shopify and visit the Shopify Theme Store at themes.shopify.com. Here you’ll find over 180 theme variations to choose from, including a good selection of free ones.

You can filter by paid or free, industry and by features. You can also sort themes by price, popularity, and most recent.

browse-theme-store The Shopify Theme Store.

2. Check the functionality and reviews
Once you’ve found a theme you like, click on the theme’s sample image. You’ll be given more information about the theme, such as whether the theme is responsive/mobile ready among other features.

Scroll down to read some reviews to find out what e-tailers using the theme think of it.

3. Preview the theme
To see the theme in action, click View Demo. You’ll see this below the green ‘Preview Theme in your Store’ button.

If the theme comes in a range of styles, you can also view demos of the different styles by clicking on them.

4. Get the theme
Once you’ve found a theme you like, click on Start with this theme if it is a paid one click on Try theme you can purchase the theme if you are 100% of with the theme.

After the theme has installed, Shopify will let you know, and will give you the option to Go to your Theme Manager and customize the store theme.

Your theme manager shows published themes (the one you installed or activated most recently) and unpublished themes below (previously installed and unpaid themes).

4.Customizing your store
Shopify’s theme editor offers an easy way to customize your store’s look and feel, layout, typography, and colors. Each theme includes built-in settings that allow you to change the look and feel of your store without editing any code. The theme editor includes a preview of your store, so that you can see the way your changes will look before publishing them. If your theme is a paid one

From your Shopify admin, go to Online Store > Themes.
click on Customize.

The theme editor shows a preview of the theme and categories of settings that you can change.

Different types of pages have different theme sections. When you open the theme editor, the settings for the home page are shown by default. To access the settings for other pages, select the page type from the top bar drop-down menu:

Please go through below video for more information

5. Add Your Products to The Store

6. Payment gateways

A payment gateway allows you to take payment from your customers via your website. The price and commission rate is important, but it’s also important to see what features they offer. Not all payment gateways are created equal.

Transaction Fees
When you take a payment, some gateways will keep a small percentage or flat fee (or sometimes both) for letting you use their service. Compare these based on what your anticipated sales are.

Card Types
You need to know what types of card are accepted by your chosen Payment Gateway. All accept VISA and Mastercard, while most accept American Express. Paypal is also becoming popular for online payments.

Offsite Checkout
Some gateways will take the payment on their own servers via their own form. This means the customer is taken away from your checkout and they pay on the form provided by your payment gateway. They are then redirected to your confirmation page once the customer successfully pays. This allows you to have a bit more control of the checkout process. Now you can circumvent Shopify’s limitations in that they don’t let you customise the checkout other than with CSS.

Payment Gateway options for Sri Lanka
Now ECOM Services has a solution to integrate your local bank or any other local payment options with Shopify Payment Gateway.

6. Get Your Online Shop “LIVE”
Before your site can go live you need to add a few more details about your company and how you plan to make deliveries and pay tax.

General
Make sure all your business information is filled out on this page. Also, make sure to make use of the Google Analytics feature. This can prove to be an invaluable source for tracking your store visitors.

7. General Shopify settings

shipping

From your store admin, go to the Settings > Shipping page.
you can create Shipping Zones, and Shipping rates based on price or weight

Test your order system
To test your system you can simulate a transaction using Shopify’s Bogus Gateway.

To use the Bogus Gateway:

From your store Admin, click Settings, then Payments to go to your Payments settings
If you have a credit card gateway enabled, deactivate it before continuing. (Click Edit, then Deactivate, then confirm your deactivation.)
In the Accept credit cards section, click Select a Credit Card Gateway to open the drop-down menu.
Scroll down the list to Other, then click (for testing) Bogus Gateway.
Click Activate (or Reactivate, if you’ve used the Bogus Gateway before).
Go to your storefront and place an order as a customer would. At checkout, enter the following credit card details instead of genuine numbers:
Testing a real payment gateway with a genuine transaction:

Make sure you’ve set up the payment gateway you want to test.
Make a purchase from your store as a customer would, and complete checkout using genuine credit card details.
Cancel the order immediately, to refund yourself and avoid paying transaction fees.
Log in to your payment gateway to make sure the funds went through.
Is this free?
Yes – just be sure to cancel and refund the order soon after you place it.

If your billing cycle hits after you’ve placed the test order but before you cancel it, the transaction fees will appear on your bill. You can still cancel after paying your bill to Shopify, but you’ll receive the refund as a transaction credit on your account. You can use transaction credits to pay future transaction fees.

Consider Buying a Domain Name
To get your site live you’ll need a domain name. You have two choices for this. Firstly you can buy a domain from Shopify and it will be added to your store automatically. This saves you time, especially if you have no knowledge of hosting a website. These domains typically cost $9-$14 USD per year. Your second option is to purchase a domain from a third party such as GoDaddy. These domains start from $1.99 USD a year. The downside is that you’ll have to redirect the DNS records yourself which can seem daunting at first. Setting up your domain is not something you have to do often, but it’s important that you do it properly the first time.

for more information please visit www.ecom.services

Move desktop items By a Script on Imac

2012-12-19T19:51:00.000-08:00

This is a great example of when AppleScript is really useful for automating simple tasks like moving files around. In fact, you can do it with a script that is only three lines long.

Start by opening up AppleScript Editor, located in the Utilities folder inside the Applications folder. If you don't have Snow Leopard, the latest version of Mac OS X, this might be called Script Editor and instead is located in the AppleScript folder in the Applications folder. In the window that appears, paste the following three lines:

tell application "Finder"
   move items of (path to desktop folder) to folder (path to documents folder)
end tell

If you click Run, you should see all the items on your desktop move into your Documents folder. Choose Save As from the File menu, give the script a name like cleardesktop and change the File Format to Application. Save it somewhere safe where someone won't accidentally delete it. I have a folder inside my Documents folder called Scripts where I keep all my AppleScripts. Other people choose to store their scripts in the Scripts folder in the Library folder, because Apple has already put some ready made ones in there.

The next step is to make it run every time you shut down your Mac. This is pretty tricky to do, and involves using a lot of Terminal commands. Instead, a much easier way is to make the script run when you log in, which will essentially do the same thing. Just go to System Preferences, and click on the Accounts section. Choose your account from the list on the left, and then click on the Login Items tab. You can now either click the plus (+) button and locate your script, or just drag the script from a Finder window into the list.

Now, whenever you turn on your computer, all the clutter left over from the previous user will be automatically moved into the Documents folder.

The above script is just about as basic as you can get. Here’s an idea for a more complicated version. Instead of just dumping everything in your documents folder, it instead creates a folder in there with a name that includes todays date ( e.g. “Desktop 13/01/2010” ) and puts the items in this folder instead.

set foldername to ("Desktop " & short date string of (current date))
set docsfolder to (path to documents folder) as string

tell application "Finder"
   if not (exists folder (docsfolder & foldername)) then
       make new folder at docsfolder with properties {name:foldername}
   end if
    move items of (path to desktop folder) to folder (docsfolder & foldername)
end tell

Alternatively, the following script checks the file extension of all the files on the desktop, and sorts them into the Movies, Pictures, Applications and Documents folders depending on what they are. If you are feeling adventurous, you can modify the script to include your own folders and file extensions.

tell application "Finder"
   set desktopFolder to (path to desktop folder)
    set musicFolder to (path to music folder)
    set appsFolder to (path to applications folder)
    set picsFolder to (path to pictures folder)
    set moviesFolder to (path to movies folder)
    set docsfolder to (path to documents folder)

    set musicExt to {".mp3", ".aac"}
    set appsExt to {".dmg", ".sit", ".app"}
    set picsExt to {".jpg", ".gif", ".tif", ".png", ".psd"}
    set moviesExt to {".avi", ".mpg", ".mov", ".m4v"}
    set docsExt to {".pdf", ".txt", ".doc", ".xls", ".key", ".pages"}

    set allFiles to files of desktopFolder
    repeat with theFile in allFiles
       copy name of theFile as string to FileName

        repeat with ext in musicExt
           if FileName ends with ext then
               move theFile to musicFolder
           end if
       end repeat

        repeat with ext in appsExt
           if FileName ends with ext then
               move theFile to appsFolder
           end if
       end repeat

        repeat with ext in picsExt
           if FileName ends with ext then
               move theFile to picsFolder
           end if
       end repeat

        repeat with ext in docsExt
           if FileName ends with ext then
               move theFile to docsfolder
           end if
       end repeat

        repeat with ext in moviesExt
           if FileName ends with ext then
               move theFile to moviesFolder
           end if
       end repeat
   end repeat
end tell

MySQl change auto increment Starting number?

2012-09-21T21:11:00.000-07:00

ALTER TABLE tbl AUTO_INCREMENT = 5;

How to create interactive PDF forms

2012-07-31T09:55:00.000-07:00

If you’re like me then you like everything from your website down to your legal contracts to look well designed and function to your client’s liking — which in most cases is… easily!
The problem with creating forms and other documentation for a client to fill out is most are created in Microsoft Word, or other form of word processors, because we’re afraid the client won’t have the right software to open, add to it and return it.
In doing so, the design is compromised because of word processor’s inability to function like professional design software. While MS Word is typically found on most computers and regarded as the most compatible document to send someone to fill out and return, that doesn’t mean you can’t have your cake (aka “good design capabilities”) and eat it too (aka “compatibility).

Adobe Acrobat Professional to the rescue!

Adobe Acrobat Professional gives you the ability to turn your previously designed, standard PDF file into an interactive form that clients can download, easily fill out, print or effortlessly return to you by email. All they need is the free Adobe Acrobat Reader, which can be download here. And most clients I’ve spoke with already have it installed. Here’s how you can create your own interactive PDF:

Create your document

First, design your documentation or form in the software of your choice. InDesign is my first choice of page layout programs, but feel free pick your own…
Once you’re completely satisfied with the design, save it as a PDF.

Open it in Acrobat Pro

From the top toolbar, choose File > Create PDF > From File… Then, choose the PDF file you created above and click Open.

You should now see your beautifully designed PDF open in Acrobat Pro with a toolbar that looks similar to the highlighted image above. This toolbar is where you provide interactivity to your static PDF.

Adding Interactivity

Select the Text Field Tool (pictured below):

Drag out boxed areas on your PDF where you would like the client to add their information. NOTE: Acrobat can also use its auto-detection feature to assign text box areas to predetermined underlined areas.

After each box you create, a dialog box will appear that allows you to customize the text field area. Below you can see my changes, but feel free to customize to your liking.

Adding the ‘Submit’ Button

Now that you have your text areas specified, it’s time to add a ‘submit’ button so your clients can easily email you back the completed form.
For this we need to select the Combo Box tool (highlighted below):

Once again, drag out an area where you would like your ‘submit’ button to appear.

Again, a dialog box will appear. While you can customize these settings as well, the steps (images) I have listed below are essential for making the form submittal by email.

Once you click ‘Add…’ a new dialog box will appear. Change these settings to:

Click ‘Ok’ and continue making changes to the other tabs:

Click ‘Close’. You should now have text areas and a submit button that looks similar to this:

Last Step… Customize the Form Preferences

This step is not necessary but handy!
From the menu bar choose Acrobat > Preferences… (or Edit > Preferences on a PC). From here you are able to change the default yellow highlighted text areas (seen above) to better fit the look of your form.

That’s it! You now have a PDF document that can be edited by your clients and quickly emailed back to you.

Quick Tip: How To Get YouTube Thumbnail Images

2012-07-26T01:24:00.001-07:00

Installing PDFlib on Apache/PHP running on Windows:

2012-05-26T06:14:00.002-07:00

I just successfully installed PDFlib on windows XP running WAMP. Here is the process:Installing PDFlib on Apache/PHP running on Windows:

Download PDFLib from:
http://www.pdflib.com/download/pdflib-family/pdflib-7/

Here is the direct download for the currently latest version for windows:
http://www.pdflib.com/binaries/PDFlib/701/PDFlib-7.0.1p1-MSWin32-php.zip

Once you have finished downloading, extract the zip file.
In the folder "bind" choose your php version, and open that folder. (php4 or php5)

Inside that folder, you'll have PHP sub versions, choose your sub version. If you don't know the exact PHP version you'ure using, run a php page with <?php phpinfo(); ?> in it. The PHP version will be printed right at the top of the page.

Inside the sub version folder, you'll find the pdflib's .dll file for your php version.

Copy the .dll file and save the copy in your php extensions folder. This folder is defined in php.ini as "extension_dir". So if you don't know what it is on your machine, open php.ini and search for 'extension_dir'.
On my system is was: c://wamp/php/ext/

Now open php.ini and add the extension. The format for this is:


extension=file.dll

where file is the file name of the extension.

eg:


extension=libpdf_php.dll

Now you have to restart apache, and you should have pdflib installed. I tested this using:


<?php
if (class_exists('PDFlib')) {
 echo 'PDF Lib supported';
} else {
 echo 'PDF Lib not supported';
}
?>

I don't know about XAMP, you you might have the pdflib extension already added to your extensions directory. If so, then all you have to do is add the lineextension=libpdf_php.dll to php.ini

Creating Image Maps in Dreamweaver CS5

2012-05-24T20:18:00.002-07:00

Adding images to your site is one of the simplest and easiest ways of making your web content come to life. I’d say it’s almost mandatory, actually. After all, what better way to ensure your content resonates with your viewers than to provide visual aids and imagery? You can add further interactivity to your site, however, by making your images more than static visual aids, but a dynamic, multi-part navigation system that can link to other pages on your site. These types of images are called image maps.

What are image maps?

An image map allows a regular image to serve as a type of navigation system. We can use an actual map as a perfect example of this. For instance, when users click on certain locations–sometimes called hotspots--on the image, they can be taken to pages related to those locations.

For example, Southwest Airlines’ Route Map page displays a map of the United States. The cities that Southwest flies to are indicated with a small circle. When users click on a circle or city name, they are taken to a page about that city through the use of an image map.

How to make an image map

You can make any image an image map by designating clickable areas on it and giving it a link or an action. To create an image map, insert an image (Insert –> Image) on a page and select it in Design View. The image map tools are available in the Properties Inspector as seen below:

Clickable hotspots can be created in three shapes:

Rectangles
Circles
Polygons

Once a hotspot has been placed on an image, the link location must be completed. Each hotspot may link to a different page.

And that’s all there is to it!

Have you thought of any creative or brilliant image to make into image maps? A map of the world, perhaps, or even a photograph of people? Please share if you have!

How Can I Start and Shut Down My Computer Automatically on a Schedule?

2012-04-23T20:08:00.001-07:00

On Windows

To automatically start your computer up at a specific time of day, you'll actually need to edit your BIOS settings. To do this:

Boot up your computer and enter your BIOS setup. Usually this involves pressing the Delete key as your computer boots (your computer should say Press DEL to Enter Setup or something similar as you turn it on).
Navigate to the Power Options. If your BIOS supports it, there should be a function for automatically starting up your computer at a certain time of day. Mine was called "Resume by Alarm", but yours might be called something different.
Enable that setting and set the time you want your computer to start every day. Save and Exit the BIOS, and your computer should follow that schedule from now on.

You probably shut down your computer when you're done using it at the end of the day, but if not, you can set it to shut itself down on a schedule. This is easy to do with Windows Task Scheduler:

Hit the Start menu and type in "task scheduler". Open up Task Scheduler from your results.
In the right pane, hit Create Task. Give it a name, and under the General tab, check "Run with highest privileges". Also check "Run whether user is logged on or not", if you ever leave your computer logged out.
Head to the Settings tab and check "Stop the task if it runs longer than" and set it to "1 hour". This won't stop your computer from sleeping, but will stop your computer from thinking a task is still running.
Head to the Actions tab, hit New, and choose "Start a Program" as your action. Set the Program to shutdown and the arguments to -s.
Lastly, head to the Triggers tab and click New. Change the schedule to fit whatever you want (say, Daily at 12:00AM), and hit OK. Hit OK again at the next window and your task should be saved in Task Scheduler.

That's it. Now your computer should shut down and wake up on your own schedule.

On a Mac

This process is much easier on a Mac than on Windows. To set it up on OS X:

Open up System Preferences and click Energy Saver.
In the bottom right corner, click the Schedule button.
Check the box next to "Start up or wake" to schedule when your computer turns on and the checkbox beneath it to schedule when you computer goes to sleep, restarts, or shuts down. You can set the schedules for specific days, every day, just weekdays, or weekends only.
Once you've made all your choices, click the OK button.

Note that if you're setting schedules on a Mac laptop, it will need to be connected to power for these schedules to function.

There are a number of different ways you could do this, too, like using previously mentioned WakeupOnStandby, but this is a nice low hassle method that doesn't require any extra software.

Application Not Responding? Here’s How to Kill Processes with PowerShell

2012-04-21T17:13:00.000-07:00

Ever have one of those days where programs just aren’t cooperating? You try terminating a program, but it doesn’t respond? PowerShell can give you some extra fire power on those
days.

How Do I Stop A Program In PowerShell?

1. The long command name stop-process can be shortened to kill.

2. If you know the numeric process that you’re wanting to stop, you can enter it. However,
like most Window’s users, we know the name of the program we want to stop, so entering
the name would be more convenient. The code below shows the next step (entering –processname to specify to PowerShell that it is going to stop a process with a name of
what we want).

kill -processname

3. Next, we need to know the name of the process we want to stop. If we want to stop
Chrome, for instance, we would enter:

kill -processname chrome

If we hit enter (and Chrome was open), the program would end. Important note: some processes aren’t named what you think. You can locate the name of the processes by
starting task manager and reviewing the processes.

Notice that Google Chrome is listed as chrome, while the calculator is listed as calc.
In order to stop the calculator we would type:

kill -processname calc

4. If we want to stop multiple process such as Chrome, calculator and Excel, we would
separate the processes by a comma:

kill -processname chrome, calc, excel

The above command would kill Google Chrome, the calculator and Microsoft Excel.

How to Remotely Shut Down or Restart Windows PCs

2012-03-26T07:54:00.000-07:00

Windows includes Shutdown.exe, a simple utility for remotely shutting down or restarting Windows computers on your local network. To use Shutdown.exe, you must first configure the PCs you want to shut down or restart remotely.
Once you’ve configured the PCs, you can use a graphical user interface or command to restart the PCs from another Windows system. You can even remotely shut down or restart the PCs from a Linux system.
Configuration
The remote registry service must be enabled on each computer you want to shut down remotely – it’s disabled by default.
To enable it, first launch the Services control panel on the computer you want to shut down remotely. To do this, click the Start button, type services.msc into the Start menu and press Enter.
Locate the “Remote Registry” service in the list, right-click it and select Properties.

From the properties window, set the Startup type to Automatic and click the Start button to launch the service.

Next, you’ll have to open the required port in the computer’s firewall. Click Start, type “Allow a program” and press Enter. In the window that appears, click the “Change settings” button. Scroll down in the list and enable the “Windows Management Instrumentation (WMI)” exception.

Your user account must also have administrator permissions on the remote computer. If it doesn’t, the shutdown command will fail due to lack of permissions.
Remote Shut Down
To shut down the computer, launch a Command Prompt window on another computer (click Start, type Command Prompt, and press Enter). Type the following command into the command prompt window for a graphical interface:
shutdown /i
From the remote shutdown dialog window, you can add one or more computer names and specify whether you want to shut down or restart the system. You can optionally warn users and log a message to the system’s event log.

Not sure what the name of the remote computer is? Click Start on the remote computer, right-click Computer in the Start menu, and select Properties. You’ll see the computer’s name.

You can also use a command instead of the graphical interface. Here’s the equivalent command:
shutdown /s /m \\chris-laptop /t 30 /c “Shutting down for maintenance.” /d P:1:1

Shut Down From Linux
Once you’ve set up the computer, you can also shut it down from a Linux system. This requires the samba-common package installed – you can install it on Ubuntu with the following command:
sudo apt-get install samba-common
Once you have, use the following command from a terminal:
net rpc shutdown -I ip.address -U user%password
Replace “ip.address” with the numerical address of the Windows computer, “user” with the username of an account that has administrator privileges on the remote computer, and “password” with the user account’s password. You can add a “-r” option to the command if you want the computer to restart instead of shutting down.
If you have remote desktop access, you can also access the desktop and shut down or restart that way. The shutdown.exe command is a faster way of doing the same thing designed for system administrators – you can shut down or reboot multiple computers much faster than you could by logging into them one-by-one.

How to Make Simple Graphical Shell Scripts with Zenity on Linux

2012-03-10T15:25:00.002-08:00

Zenity adds graphical interfaces to shell scripts with a single command. Shell scripts are a great way to automate repetitive tasks, but they’re normally confined to the terminal — Zenity brings them out of the terminal and onto your desktop.

We’ve given an introduction to shell scripting in the past. You don’t have to be a programmer to get started with shell scripts — they require little more than knowledge of Linux terminal commands.

Getting Zenity

Zenity comes with Ubuntu by default. If you use an Ubuntu derivative, Such as Kubuntu, you may have to install it manually with the following command:

sudo apt-get install zenity

Zenity is a part of GNOME, so it should already be included on Linux distributions that use the GNOME desktop. Check your package manager for the zenity package if you don’t have it.

Using Zenity

You can play around with Zenity from the terminal. Let’s say you want to create an error window when a problem occurs with your shell script. Here’s an example command you could use:

zenity –error –title=”An Error Occurred” –text=”A problem occurred while running the shell script.”

Run the command and you’ll see a window with the message.

Put this single command into your shell script at the correct place and you’ll have a graphical error message. You could also use variables to include more information about the error.

Let’s say you want to ask a yes or no question. You could use a command like this one:

zenity –question –title=”Query” –text=”Would you like to run the script?”

You can catch the yes or no response in your shell script and perform different commands based on which button the user clicks.

There’s also a text entry dialog:

zenity –entry –title=”Favorite Website” –text=”What is your favorite website?”

Catch the user’s input in a shell script and you could store it as a variable.

There’s also a file picker, calendar, and other types of dialogs. For a full list of dialog types and their options, consult Zenity’s manual page.

An Example Script

Let’s try using Zenity to create a simple graphical shell script. With just three commands, we can create a graphical timer program:

#!/bin/bash
# This script asks the user for a time, waits the specified amount
# of time, and shows an alert dialog.

TIME=$(zenity –entry –title=”Timer” –text=”Enter a duration for the timer.\n\n Use 5s for 5 seconds, 10m for 10 minutes, or 2h for 2 hours.”)

sleep $TIME

zenity –info –title=”Timer Complete” –text=”The timer is over.\n\n It has been $TIME.”

We’re using some extra tricks here. We get the value of the TIME variable from the first zenity command and feed it to the sleep command. We’re also using /n to create new lines of text in the zenity dialogs.

After saving the shell script and running the chmod +x command on it to give it executable permissions, we can launch it.

Enter a duration and the script will use the standard sleep command to count down in the background. When the sleep command’s timer finishes, the script will display the zenity info message.

You could create a desktop or panel shortcut for this script and run it without even touching the terminal.

Extract the first paragraph text from a web page with PHP

2012-03-10T03:43:00.000-08:00

Using strpos and substr

Assuming the content to extract the paragraph from is in the variable $html (which may have come from a file, database, template or downloaded from an external website), use the following code to work out the position of the first tag, the first tag after that tag, and then get all the HTML between them including the opening and closing tags:

1$start = strpos($html, '<p>');

2$end = strpos($html, '</p>', $start);

3$paragraph = substr($html, $start, $end-$start+4);

Line 1 gets the position of the first opening tag

Line 2 gets the position of the first after the first opening

Line 3 then uses substr to get the HTML. The third parameter is the number of characters to copy and is calculated by subtracting $start from $end and adding on the length of "" so it is included in the extracted HTML.

Converting to plain text

If the extracted paragraph needs to be in plain text rather than HTML, use the following to remove the HTML tags and convert HTML entities into normal plain text:

`1`	`$paragraph` `= html_entity_decode(strip_tags($paragraph));`

recover Mac OS X Lion Password

2012-03-07T18:38:00.002-08:00

Method 1 – Reset a Lost Mac OS X Lion Password

You have to boot from a Lion Recovery drive, this can either be a recovery disk made with the Lion Disk Maker tool, or just by booting from the built-in Lion Recovery HD partition.

Hold “Option” at boot and select the “Recovery” disk at the boot menu
Wait for “Mac OS X Utilities” menu to appear, indicating that you are booted into recovery mode
Click on the “Utilities” menu and select “Terminal”

Type the following:

resetpassword

Confirm the user account and then the password change and reboot Mac OS X 10.7 as usual with your new password

This replaces the “Reset Password” menu item that used to be in place prior to OS X 10.7, which was one of two original methods of resetting a Mac OS X 10.6 or prior password. Why the change to the Terminal method? Probably for increased security now that recovery partitions are standard with Lion.

The above method is by far the easiest, but if it’s unavailable for some reason, you can choose another method:

Method 2 – Delete AppleSetupDone and Create a New Administrative Account

Mac OS X 10.7 does share a more untraditional approach to resetting a password as past versions of OS X. In this case, you can still delete the AppleSetup file which forces the “Welcome to Mac OS X” setup assistant to run again, which allows you to create an administrative account. You can then login to that new administrative account and reset your original account password.

From the Recovery Drive’s Terminal, type:

rm /var/db/.AppleSetupDone

Then reboot either through the menu item or by typing ‘reboot’ into the command line.

Follow the setup procedure as usual, create the new administrative account, and wait for Mac OS X to boot as usual into the new user account. You won’t see any of your familiar files or settings yet, and this is normal, because you have to reset the original password. Here’s how:

Open “System Preferences” and click on “Users & Groups”
Click on the lock icon in the lower left corner and authenticate, allowing you to make changes to user accounts
Select your original user account from the left side Users list, and then click on the “Reset Password” button on the right

Enter and confirm the new password
Close out System Preferences and reboot

You can now login to the original user account with the new password you just set. Once logged into your original administrative account you can then return to User & Groups and delete the temporary admin account you created.

These two methods should work when booting a USB Lion install drive too, but it’s quicker to use the Recovery disk that is already active on OS X Lion installations.

Can't enable wifi on Toshiba

2012-03-02T02:33:00.002-08:00

If the 'Flash Cards' don't appear at the top of the screen when you hit the 'Fn' key, then click the 'Start' button and type the word flash in the search field. In the programs that appear at the top, you should see 'Restart Flash Cards' and 'Settings for Flash Cards'. First, click on 'Restart Flash Cards', then again click on 'Start' and type in the word flash in the search field. This time click on 'Settings for Flash Cards', and make sure there is NOT a check mark on 'Disable all function keys', click 'Apply' and 'OK'. Then try the Function key/Flash cards + your F8 key again.

If the above doesn't work download this file to your desktop, and double click to install it, and reboot. You do not mention if you are still running Vista 32bit, or if you have upgraded to a Vista or Win7 64bit edition, so only download the appropriate file.

Toshiba Value Added Package for Windows Vista/7 (32)

Toshiba Value Added Package for Windows Vista/7 (64)

After the reboot try the 'Fn' key plus your 'Fn' + 'F8' combination again, if necessary repeat the flash paragraph above. Please let us know if this helps. Good luck.

PHP Arrays

2012-02-06T01:06:00.001-08:00

Numeric Arrays

A numeric array stores each array element with a numeric index.
There are two methods to create a numeric array.
1. In the following example the index are automatically assigned (the index starts at 0):

$cars=array("Saab","Volvo","BMW","Toyota");

2. In the following example we assign the index manually:

$cars[0]="Saab";
$cars[1]="Volvo";
$cars[2]="BMW";
$cars[3]="Toyota";

Example

In the following example you access the variable values by referring to the array name and index:

<?php
$cars[0]="Saab";
$cars[1]="Volvo";
$cars[2]="BMW";
$cars[3]="Toyota";
echo $cars[0] . " and " . $cars[1] . " are Swedish cars.";
?>

The code above will output:

Saab and Volvo are Swedish cars.

Associative Arrays

An associative array, each ID key is associated with a value.
When storing data about specific named values, a numerical array is not always the best way to do it.
With associative arrays we can use the values as keys and assign values to them.

Example 1

In this example we use an array to assign ages to the different persons:

$ages = array("Peter"=>32, "Quagmire"=>30, "Joe"=>34);

Example 2

This example is the same as example 1, but shows a different way of creating the array:

$ages['Peter'] = "32";
$ages['Quagmire'] = "30";
$ages['Joe'] = "34";

The ID keys can be used in a script:

<?php
$ages['Peter'] = "32";
$ages['Quagmire'] = "30";
$ages['Joe'] = "34";

echo "Peter is " . $ages['Peter'] . " years old.";
?>

The code above will output:

Peter is 32 years old.

Multidimensional Arrays

In a multidimensional array, each element in the main array can also be an array. And each element in the sub-array can be an array, and so on.

Example

In this example we create a multidimensional array, with automatically assigned ID keys:

$families = array
  (
  "Griffin"=>array
  (
  "Peter",
  "Lois",
  "Megan"
  ),
  "Quagmire"=>array
  (
  "Glenn"
  ),
  "Brown"=>array
  (
  "Cleveland",
  "Loretta",
  "Junior"
  )
  );

The array above would look like this if written to the output:

Array
(
[Griffin] => Array
  (
  [0] => Peter
  [1] => Lois
  [2] => Megan
  )
[Quagmire] => Array
  (
  [0] => Glenn
  )
[Brown] => Array
  (
  [0] => Cleveland
  [1] => Loretta
  [2] => Junior
  )
)

Example 2

Lets try displaying a single value from the array above:

echo "Is " . $families['Griffin'][2] .
" a part of the Griffin family?";

The code above will output:

Is Megan a part of the Griffin family?

Complete PHP Array Reference

For a complete reference of all array functions, go to our complete PHP Array Reference.
The reference contains a brief description, and examples of use, for each function!

PHP tip: Comma Separated Values (CSV) List to Array and Array to CSV List

2012-02-06T00:57:00.001-08:00

// create a comma separated list from an array
$array = array('green','purple','blue','yellow','amber','red');
$comma_separated = implode(",", $array);
echo $comma_separated;

// create an array from a comma separated list
$list = "green, purple, blue, yellow, amber, red";
$array = explode(',', $list);
print_r($array);

Loop back adaptor for Windows 7

2011-12-22T07:29:00.000-08:00

The key step I was missing was how to find the Hardware Wizard:

Click the Start menu.
Search for “cmd".
Right-click on “cmd” and select “Run as Administrator”
Enter “hdwwiz.exe”

From that point on it's the same approach as under Vista, i.e.:

In the "Welcome to the Add Hardware Wizard", click Next.
Select "Install the hardware that I manually select from a list (Advanced)" and click Next.
Scroll down and select "Network adapters" and click Next.
Select under Manufacturer "Microsoft" and then under Network Adapter "Microsoft Loopback Adapter" and click Next.

I've tested this and it's working for me (connecting the host to a VPC using the loopback adapter).

Connecting GNS3 To Internet

2011-12-22T07:27:00.001-08:00

Windows 7 Internet Connection Sharing (ICS)

2011-12-22T07:24:00.001-08:00

Cannot start Microsoft Office Outlook. Cannot open the Outlook window.

2011-12-04T17:52:00.001-08:00

Start->run..then type the following -> "Outlook.exe /resetnavpane"

Should solve your problem.

The way to fix this is to do a system restore.
Below is a link to those instructions.

http://support.microsoft.com/kb/936212/

While the "broken profile" part of this post belongs in the Vista forum.
I'm going to suggest that you pop over to the Office forum for the Outlook part. That is more appropriate for them to handle.
Hope this helped!

http://www.microsoft.com/office/community/en-us/flyoutoverview.mspx

if this fails

You want the settings or the data? If its your old data you're after, attach your old .PST file to the new profile you created:

Reconnect your old Outlook data file

If the data file won't open in the new profile, it may be damaged:

How to find and run the Inbox Repair tool in Outlook
To repair a damaged Personal Folders PST file

and there are Profile repair tools available:

OLfix - Repair tool for Microsoft Office Outlook

USB current overload easy fix ASUS P5L -MX Solved

2011-12-01T22:03:00.001-08:00

I've recently had the displeasure of turning my computer on and it gave the error : USB current overload, computer will shut off after _ seconds. I fixed it by removing the front USB connector on the mother board the pin straight and BAM problem was solved ( Be sure to shut down pc and unplug power source from pc before you dig inside to fix ). So before you try anything too technical to fix this issue check to make sure all the pins are straight and not bent or touching the metal sides of the usb port. Hope this helps because this was a really hard problem to solve at first and ended up being something very simple to fix.

If still the error is their
put a jumper on USBPW5678

Download User List as CSV in google apps

2011-12-01T06:43:00.001-08:00

It looks like, for whatever reason, the .CSV link disappears when you create more than 30 users in your domain. However, you should still be able to download the file by logging into the Control Panel and then manually entering the URL:

https://www.google.com/a/cpanel/yourdomain.com/DownloadUserData/UserData-yourdomain.com-20090527.csv (replace both yourdomain.comentries with your actual domain name and replace 20090527 with today's actual date).

What Is Facebook Photo Fetcher?

2011-11-26T05:46:00.001-08:00

Facebook Photo Fetcher is a Wordpress plugin that allows you to quickly and easily generate Wordpress photo galleries from any Facebook album you can access.

The idea was inspired by Fotobook, though its approach is fundamentally different: while Fotobook's emphasis is on automation, this plugin allows a great deal more customization. With it you can create galleries in any Post or Page you like, right alongside your regular content. You do this simply by putting a "magic HTML tag" in the post's content - much like Wordpress Shortcode. Upon saving, the tag will automatically be populated with the Facebook album content. Presentation is fully customizable via parameters to the "magic tag" - you can choose to show only a subset of an album's photos, change the number of photos per column, show photo captions, and more.

Also, Facebook Photo Fetcher does not limit you to just your own Facebook albums: you can create galleries from any album you can access, including groups and fanpages. This is very handy if you're not the main photo-poster in your social circle: just let your friend or family upload all those wedding pics, then import them directly to your blog!

Features:

Uses Facebook's API to instantly create Wordpress photo galleries from Facebook albums.
Galleries are fully customizable: you can import complete albums, select excerpts, random excerpts, album descriptions, photo captions, and more.
Galleries can be organized however you like: in any post or page, alone or alongside your other content.
Simple PHP template function allows programmers to manually embed albums in any template or widget.
Galleries can be created from any album you can access: yours, friends', groups', or fanpages'.
Built-in support for automatically attaching Post Thumbnails to any post or page that includes a gallery.
Built-in lightbox: Photos appear in attractive pop-up overlays without the need for any other plugins.
Admin panel handles all setup for you: Just click Connect, login, and you're ready to start making albums.
Admin panel includes utility to search for all albums you can access (and use to create galleries).
Admin panel includes utility to auto-traverse your galleries, updating those that've changed on Facebook.
No custom database modifications: all it does is automate the creation of post/page content for you.

To get started, check out the Instructions section below.

Demo

The following box contains a sample gallery imported from Facebook using this plugin. It's generated by one single "HTML magic tag" placed in the content of this page:

From Petrified Petra, posted by PederY on 6/13/2009 (Showing 16 of 60 items)

"Justin and I returned to the hotel after our late night at Petra. We decided to start bright and early the next day and get moving before the sun came up. Ladden with water, cameras and kebabs we ventured into one of the most amazing ancient cities on earth. And it would truly be a day to remember."

: We started down the same path we had walked mere hours before. Some structures had be...

: A few meters down the main path we had to venture into the narrow opening between the...

: We had left the hotel way before the sun came up and were one of the first people in ...

: Almost as enchanting as the day before, and almost equally surprising, was the feelin...

: There was a neverending line of camels and donkeys and bedouins and carts with touris...

: The obligatory "me in front of Petra"-picture. The sun was still hours away from reac...

: The Treasury (or Al Khazneh) is simply amazing workmanship, thousands of years old. I...

: Petra has also been the stage for numerous movies, like Indiana Jones (which we were ...

: Camels look smart!

: Almost unbelievable that it's so intact.

: As we were leaving, tourists started pouring in from the opening in the mountain behi...

: Leaving the Treasury, we continued down the Street of Facades. Here it seemed like th...

: Camels with bedouins (or vice versa) constantly reminded us that we were far far from...

: We had done our homework and quickly left the beaten path. Our second destination was...

: In this picture it was supposed to look like we were supporting ourselves from fallin...

: Finally at the top! I bet this picture could have been used as an advertisement for s...

Generated by Facebook Photo Fetcher

Instructions

Download the latest version from here, unzip it, and upload the extracted files to your plugins directory.
Activate the plugin via your Wordpress admin panel.
Head over to Settings -> FB Photo Fetcher.
Click the "Login to Facebook" button to popup a Facebook login page. Enter your information, click "Login", then close the popup. Next, click "Grant Photo Permissions." Accept the permissions in the popup and when it says "Success," close it. Finally, click "Save Facebook Session." It should now say This plugin is successfully connected with xxxxxxx's Facebook account.
Now we need to get the ID of an album you'd like to import. Click the "Search for Albums" button; It will automatically connect to Facebook and produce a list of all the albums you can access, each with an associated ID number. Let's use the example 1234567890123456789.
Create a new post or page and enter the following tags, replacing the example ID with the one you'd like import. Note that you must use the HTML Editor (not Visual Editor) for the tags to be recognized:

Click "Save", and you're done! You can now view your new album.

Ways to customize the album's behavior (including Group and Fanpage support) are listed in the next section.

Customizing

Magic Tag Parameters

Let's start off with the basic code for importing a Facebook album into a page or post:


If you want a bit more control over how this presents the album, there are a number of parameters you can add to the opening tag, after the album ID number. These are:

cols=#: Set the number of photos to show per row (default is 4).
start=#: Start showing photos from the given index (i.e. to skip the first 2 photos, enter start=3)
max=#: Limit the number of photos (i.e. to only show the first 5 photos in an album, enter max=5)
rand=#: Show a random selection of photos from the album. This is applied after start & max, so to show 5 random photos from the entire album, enter rand=5; to randomize the first 5 items in the album, enter start=0 max=5 rand=5 (first limit the photos to the first 5, then randomize them).
orderby=reverse: Flip the order of photos in the album (i.e. to show only the latest, you'd use "orderby=reverse max=1")
hideHead=1: By default, albums will display their author, item count, and description prior to the first photo. Setting this will omit it that information.
swapHead=1: Swap the order of the information in the header - author first, description second.
hideCaps=1: By default, each photo shows an excerpt of its caption below it. Set this to omit them.
noLB=1: By default, this plugin outputs the JS needed to setup the lightbox popups. Set this to omit it.

As an example, the demo gallery above was created with the following tag:


Groups & Fanpages

Thus far, we've only discussed importing personal photo albums. If you'd like to import photos from a group or fanpage, you'll need to include one more parameter with the magic tag:

To show photos from a GROUP, add the parameter isGroup=1 and replace the albumID with a groupID.
To show photos from a FAN PAGE, add the parameter isPage=1 and replace the albumID with the pageID. At the moment you can't specify individual albums within fanpages; it will just pull all photos from all albums on the page. You can then limit what's shown by using the "start" and "max" parameters described above.

For example, if you wanted to create a gallery that randomly selects 10 photos from my fanpage, you'd use:


Albums from PHP

If you've got a custom template or widget in which you'd like to include a gallery, you can call the function fpf_fetch_album_content() directly. It accepts the same parameters as the HTML tags above; for example:

$album = fpf_fetch_album_content( '123456789', array('cols'=>6, 'max'=>18) );
echo $album['content'];
echo "Thumbnail: " . $album['thumb'] . ", Photo Count: " . $album['count'];

Post Thumbnails

This plugin supports automatic Wordpress Post Thumbnails. If you download and install the Add From Server plugin and set a thumbnail path in this plugin's Settings page, it will copy each album's thumbnail to your local server and attach it whenever you create or update a gallery.

Item Counts

Whenever a Facebook album is inserted into a post, that post will be given the postmeta "_fb_album_size", containing the number of shown items in the album. You can reference this from your code if you wish.

Backup and Restore MySQL Database Using mysqldump

2011-11-23T15:53:00.001-08:00

mysqldump is an effective tool to backup MySQL database. It creates a *.sql file withDROP table, CREATE table and INSERT intosql-statements of the source database. To restore the database, execute the *.sql file on destination database. For MyISAM, usemysqlhotcopy method that we explained earlier, as it is faster for MyISAM tables.

Using mysqldump, you can backup a local database and restore it on a remote database at the same time, using a single command. In this article, let us review several practical examples on how to use mysqldump to backup and restore.

For the impatient, here is the quick snippet of how backup and restore MySQL database using mysqldump:

backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql

How To Backup MySQL database

1. Backup a single database:

This example takes a backup of sugarcrm database and dumps the output to sugarcrm.sql

# mysqldump -u root -ptmppassword sugarcrm > sugarcrm.sql

# mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

The sugarcrm.sql will contain drop table, create table and insert command for all the tables in the sugarcrm database. Following is a partial output of sugarcrm.sql, showing the dump information of accounts_contacts table:

--
-- Table structure for table `accounts_contacts`
--

DROP TABLE IF EXISTS `accounts_contacts`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `accounts_contacts` (
`id` varchar(36) NOT NULL,
`contact_id` varchar(36) default NULL,
`account_id` varchar(36) default NULL,
`date_modified` datetime default NULL,
`deleted` tinyint(1) NOT NULL default '0',
PRIMARY KEY  (`id`),
KEY `idx_account_contact` (`account_id`,`contact_id`),
KEY `idx_contid_del_accid` (`contact_id`,`deleted`,`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `accounts_contacts`
--

LOCK TABLES `accounts_contacts` WRITE;
/*!40000 ALTER TABLE `accounts_contacts` DISABLE KEYS */;
INSERT INTO `accounts_contacts` VALUES ('6ff90374-26d1-5fd8-b844-4873b2e42091',
'11ba0239-c7cf-e87e-e266-4873b218a3f9','503a06a8-0650-6fdd-22ae-4873b245ae53',
'2008-07-23 05:24:30',1),
('83126e77-eeda-f335-dc1b-4873bc805541','7c525b1c-8a11-d803-94a5-4873bc4ff7d2',
'80a6add6-81ed-0266-6db5-4873bc54bfb5','2008-07-23 05:24:30',1),
('4e800b97-c09f-7896-d3d7-48751d81d5ee','f241c222-b91a-d7a9-f355-48751d6bc0f9',
'27060688-1f44-9f10-bdc4-48751db40009','2008-07-23 05:24:30',1),
('c94917ea-3664-8430-e003-487be0817f41','c564b7f3-2923-30b5-4861-487be0f70cb3',
'c71eff65-b76b-cbb0-d31a-487be06e4e0b','2008-07-23 05:24:30',1),
('7dab11e1-64d3-ea6a-c62c-487ce17e4e41','79d6f6e5-50e5-9b2b-034b-487ce1dae5af',
'7b886f23-571b-595b-19dd-487ce1eee867','2008-07-23 05:24:30',1);
/*!40000 ALTER TABLE `accounts_contacts` ENABLE KEYS */;
UNLOCK TABLES;

2. Backup multiple databases:

If you want to backup multiple databases, first identify the databases that you want to backup using the show databases as shown below:

# mysql -u root -ptmppassword

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bugs               |
| mysql              |
| sugarcr            |
+--------------------+
4 rows in set (0.00 sec)

For example, if you want to take backup of both sugarcrm and bugs database, execute the mysqldump as shown below:

# mysqldump -u root -ptmppassword --databases bugs sugarcrm > bugs_sugarcrm.sql

Verify the bugs_sugarcrm.sql dumpfile contains both the database backup.

# grep -i "Current database:" /tmp/bugs_sugarcrm.sql
-- Current Database: `mysql`
-- Current Database: `sugarcrm`

3. Backup all the databases:

The following example takes a backup of all the database of the MySQL instance.

# mysqldump -u root -ptmppassword --all-databases > /tmp/all-database.sql

4. Backup a specific table:

In this example, we backup only the accounts_contacts table from sugarcrm database.

# mysqldump -u root -ptmppassword sugarcrm accounts_contacts \
      > /tmp/sugarcrm_accounts_contacts.sql

4. Different mysqldump group options:

–opt is a group option, which is same as –add-drop-table, –add-locks, –create-options, –quick, –extended-insert, –lock-tables, –set-charset, and –disable-keys. opt is enabled by default, disable with –skip-opt.
–compact is a group option, which gives less verbose output (useful for debugging). Disables structure comments and header/footer constructs. Enables options –skip-add-drop-table –no-set-names –skip-disable-keys –skip-add-locks

How To Restore MySQL database

1. Restore a database

In this example, to restore the sugarcrm database, execute mysql with < as shown below. When you are restoring the dumpfilename.sql on a remote database, make sure to create the sugarcrm database before you can perform the restore.

# mysql -u root -ptmppassword

mysql> create database sugarcrm;
Query OK, 1 row affected (0.02 sec)

# mysql -u root -ptmppassword sugarcrm < /tmp/sugarcrm.sql

# mysql -u root -p[root_password] [database_name] < dumpfilename.sql

2. Backup a local database and restore to remote server using single command:

This is a sleek option, if you want to keep a read-only database on the remote-server, which is a copy of the master database on local-server. The example below will backup the sugarcrm database on the local-server and restore it as sugarcrm1 database on the remote-server. Please note that you should first create the sugarcrm1 database on the remote-server before executing the following command.

[local-server]# mysqldump -u root -ptmppassword sugarcrm | mysql \
                 -u root -ptmppassword --host=remote-server -C sugarcrm1
[Note: There are two -- (hyphen) in front of host]