In Feburary 2016 30,
Download the Filezilla Server software on your computer (see 'Resources'). Double-click the downloaded file to install the software. Double-click the FileZilla icon on the desktop to open the program.
Select the 'Install as a service, started with Windows (default)' option from the drop down. Leave the default for the port and leave the check in the box for 'Start server after setup completes.' Click the 'Next' button to continue. Click the 'Finish' button to complete the installation.
Go to the myipaddress.com website to see your current IP address. Enter your IP address in the text box, in FileZilla, for the server address. Leave the default port alone and then enter an administration password to use for the program. Remove the check in the 'Always connect to server' box and then click the 'OK' button.
Click the 'Edit' drop-down and select the 'Users' option. Click the 'Add' button on the right side of the window. Enter a user name and password for the user. Repeat this step to create additional users that will access your hard drive.
Select the 'Shared Folders' option on the left side of the window. Click the 'Add' button and then select a folder on the hard drive that you want to share. Click the 'OK' button to save the changes.
Test your FTP server by having a user log in from his computer. He will need an FTP program to connect to your FTP server.
In Feburary 2016 30,
Showing posts with label check. Show all posts
Showing posts with label check. Show all posts
Tuesday, 1 March 2016
How to Create an FTP DropboxIn Feburary 2016 30,
In Feburary 2016 30,
Click 'Start,' and then 'Control Panel,' and then 'Programs.' Click 'Turn Windows features on or off.'
Expand the 'Internet Information Services' check list and enable 'FTP Server.' Press 'Enter' to enable the service. This may take a few minutes to install.
Click 'Back' in the 'Programs' window and then double-click 'Administrative Tools.'
Double-click 'IIS Manager.' Right-click the 'Server' option and click 'Add FTP Site.' Follow the onscreen instructions to set up your FTP dropbox.
In Feburary 2016 30,
Click 'Start,' and then 'Control Panel,' and then 'Programs.' Click 'Turn Windows features on or off.'
Expand the 'Internet Information Services' check list and enable 'FTP Server.' Press 'Enter' to enable the service. This may take a few minutes to install.
Click 'Back' in the 'Programs' window and then double-click 'Administrative Tools.'
Double-click 'IIS Manager.' Right-click the 'Server' option and click 'Add FTP Site.' Follow the onscreen instructions to set up your FTP dropbox.
In Feburary 2016 30,
Monday, 29 February 2016
How to Hide Hidden Files in FileZilla ClientIn Feburary 2016 29,
In Feburary 2016 29,
Open the FileZilla FTP client.
Click the 'Server' menu and click the 'Force Showing Hidden Files' option if it has a check next to it, otherwise leave it alone. In older FileZilla versions, click the 'View Menu' and ensure the 'Show Hidden File' option is not checked.
Press the 'F5' key on your keyboard to refresh FileZilla. Hidden files, such as Apache '.htaccess' files, should no longer be visible. Restart FileZilla if you can still see hidden files.
In Feburary 2016 29,
Open the FileZilla FTP client.
Click the 'Server' menu and click the 'Force Showing Hidden Files' option if it has a check next to it, otherwise leave it alone. In older FileZilla versions, click the 'View Menu' and ensure the 'Show Hidden File' option is not checked.
Press the 'F5' key on your keyboard to refresh FileZilla. Hidden files, such as Apache '.htaccess' files, should no longer be visible. Restart FileZilla if you can still see hidden files.
In Feburary 2016 29,
How to Delete Multiple Pictures on PhotobucketIn Feburary 2016 29,
In Feburary 2016 29,
Log into your Photobucket account (see Resources).
Select the album containing the pictures you want to delete. Click the check box next to each picture you want to delete.
Click the 'Choose action' button on the bottom of the album, and then click the 'Delete Selected' button.
Click the 'Delete' button to confirm your selection.
In Feburary 2016 29,
Log into your Photobucket account (see Resources).
Select the album containing the pictures you want to delete. Click the check box next to each picture you want to delete.
Click the 'Choose action' button on the bottom of the album, and then click the 'Delete Selected' button.
Click the 'Delete' button to confirm your selection.
In Feburary 2016 29,
How to Use FileZillaIn Feburary 2016 29,
In Feburary 2016 29,
When you first open Filezilla, a large window opens with several windows within in the main window. The top window is where Filezilla will show its commands as it works. Below that on the left is the local computer, your computer. On the right is where you will see files from the remote computer. Each computer is broken down into two windows each, the upper window for directories, and the lower pane for directory contents. At the bottom in where progress of each uploading file is displayed.
Check with your webhost for your FTP host name, your username and password, which may be given by the host, or you have chosen. Click on the File drop down menu and chose Site Manager. A new window will open.
In Site Manager chose New Site. In the Select Entry pane, a new icon appears. Type in the name of your site.
In the pane to the right of the Select Entry, click on the General Tab. Here you will find several options. Type in the host name, usually in the format of ftp.(your-domain-name).com. Chose FTP Server Type. Chose the type of logon, usually that is normal.
Type in your username and password and click connect. The Site Manager will close automatically and you will see the commands to logon in the top pane of the main window.
If everything went right a list of folders should be displayed in the right hand panes of the main window. Now it is simple as finding your files in the left hand directory pane, and drag and drop them into the right hand pane, or vise versa.
Filezilla will decide for you what type of file you are transferring, but other FTP clients will ask you for a type, or assume a type.
In Feburary 2016 29,
When you first open Filezilla, a large window opens with several windows within in the main window. The top window is where Filezilla will show its commands as it works. Below that on the left is the local computer, your computer. On the right is where you will see files from the remote computer. Each computer is broken down into two windows each, the upper window for directories, and the lower pane for directory contents. At the bottom in where progress of each uploading file is displayed.
Check with your webhost for your FTP host name, your username and password, which may be given by the host, or you have chosen. Click on the File drop down menu and chose Site Manager. A new window will open.
In Site Manager chose New Site. In the Select Entry pane, a new icon appears. Type in the name of your site.
In the pane to the right of the Select Entry, click on the General Tab. Here you will find several options. Type in the host name, usually in the format of ftp.(your-domain-name).com. Chose FTP Server Type. Chose the type of logon, usually that is normal.
Type in your username and password and click connect. The Site Manager will close automatically and you will see the commands to logon in the top pane of the main window.
If everything went right a list of folders should be displayed in the right hand panes of the main window. Now it is simple as finding your files in the left hand directory pane, and drag and drop them into the right hand pane, or vise versa.
Filezilla will decide for you what type of file you are transferring, but other FTP clients will ask you for a type, or assume a type.
In Feburary 2016 29,
Sunday, 28 February 2016
How to Upload PSD FilesIn Feburary 2016 28,
In Feburary 2016 28,
Click the 'Start' button and choose 'Run' from the file options. Windows Vista users can skip to the next step.
Type 'CMD' (minus the quotes) and press 'Enter.' This will open a command window.
Navigate to the folder where your PSD files are located.
Check the size of your PSD files to make sure you are uploading the correct one. Type 'ftp' (minus the quotes) and press enter.
Type 'Open ftp.xxxxxxxx.com' (minus the quotes) and press 'Enter.' Substitute your FTP site for the aforementioned address.
You will be prompted to enter a user name if you have successfully connected to the server. Type your user name and press 'Enter.'
You will be prompted to enter a password if your user name has been accepted. Type your password and press 'Enter.'
Once your credentials have been accepted, you will be given an 'FTP' prompt. Navigate to the directory folder where you would like to store your PSD files. Alternatively, if you would like to create a folder, you can do this by typing 'MKDIR' (minus the quotes). You will be asked for your folder name.
Upload your PSD file by typing 'put abc.psd' (minus the quotes). Substitute the name of your file for abc.
Once the transmission is complete, the FTP server will report to you the size of the file and how long it took to upload. Repeat Step 9 for as many files as you would like to upload.
Type 'bye' (minus the quotes) when you are finished uploading your files. This command will disconnect you from the FTP server.
Type 'exit' (minus the quotes) to close the command window.
In Feburary 2016 28,
Click the 'Start' button and choose 'Run' from the file options. Windows Vista users can skip to the next step.
Type 'CMD' (minus the quotes) and press 'Enter.' This will open a command window.
Navigate to the folder where your PSD files are located.
Check the size of your PSD files to make sure you are uploading the correct one. Type 'ftp' (minus the quotes) and press enter.
Type 'Open ftp.xxxxxxxx.com' (minus the quotes) and press 'Enter.' Substitute your FTP site for the aforementioned address.
You will be prompted to enter a user name if you have successfully connected to the server. Type your user name and press 'Enter.'
You will be prompted to enter a password if your user name has been accepted. Type your password and press 'Enter.'
Once your credentials have been accepted, you will be given an 'FTP' prompt. Navigate to the directory folder where you would like to store your PSD files. Alternatively, if you would like to create a folder, you can do this by typing 'MKDIR' (minus the quotes). You will be asked for your folder name.
Upload your PSD file by typing 'put abc.psd' (minus the quotes). Substitute the name of your file for abc.
Once the transmission is complete, the FTP server will report to you the size of the file and how long it took to upload. Repeat Step 9 for as many files as you would like to upload.
Type 'bye' (minus the quotes) when you are finished uploading your files. This command will disconnect you from the FTP server.
Type 'exit' (minus the quotes) to close the command window.
In Feburary 2016 28,
How to Find an FTP AddressIn Feburary 2016 28,
In Feburary 2016 28,
Replace the 'http' in your URL with an 'ftp.' You may need to enter it in the form: 'ftp://websiteaddress.com' or 'ftp://ftp.websiteaddress.com.' If the FTP is under a sub-domain, it may be listed as 'ftp.subdomain.hostdomain.com' or 'ftp://ftp.subdomain.hostdomain.com.'
Check the welcome letter you received from the web hosting provider.
Log in to the control panel of your website. Using this method, you will need the username and password to access the account. The FTP address should be listed in the FTP account section of the control panel.
Contact your web host for the FTP address.
In Feburary 2016 28,
Replace the 'http' in your URL with an 'ftp.' You may need to enter it in the form: 'ftp://websiteaddress.com' or 'ftp://ftp.websiteaddress.com.' If the FTP is under a sub-domain, it may be listed as 'ftp.subdomain.hostdomain.com' or 'ftp://ftp.subdomain.hostdomain.com.'
Check the welcome letter you received from the web hosting provider.
Log in to the control panel of your website. Using this method, you will need the username and password to access the account. The FTP address should be listed in the FTP account section of the control panel.
Contact your web host for the FTP address.
In Feburary 2016 28,
Saturday, 27 February 2016
How to Set Up an FTP Server in FedoraIn Feburary 2016 27,
In Feburary 2016 27,
Open the software management tool by clicking 'System' at the top of the Fedora desktop 'Administration,' then 'Add/Remove Software.'
Search for the FTP software by typing 'vsftpd' into the 'Find' box in the Add/Remove Software window, then click 'Find.'
Install the FTP server and configuration software by clicking the check boxes next to 'system-config-vsftd' and 'vsftd' in the Add/Remove Software list, then click 'Apply.'
Authenticate yourself, if prompted, by typing your password, then pressing 'Enter.'
Close the Add/Remove Software tool by clicking 'Close' in the Run New Application window, then clicking 'System' and 'Quit' in the Add/Remove Software window.
Open the FTP server configuration tool by clicking 'System,' 'Administration,' then 'FTP Administration.'
Disable downloading or uploading of files, if desired, by clearing the 'Enable Download Files' or 'Enable Upload Files' check boxes with a click on the 'General' screen in the Very Secure FTP Daemon Configuration window.
Disable access of local user accounts to your FTP server, if desired, by clicking 'Users' at the left side of the Very Secure FTP Daemon Configuration window, then clearing the 'Allow Local Users' check box by clicking it.
Disable anonymous access to your FTP server, if desired, by clicking 'Users' at the left side of the Very Secure FTP Daemon Configuration window, clicking the 'Anonymous User' tab, then clearing the 'Allow Anonymous User' check box by clicking it.
Disable viewing of directory lists by clicking 'Directory Options' at the left side of the Very Secure FTP Daemon Configuration window, then clearing the 'Allow Users to View Directory Lists' check box by clicking it.
Save your settings by clicking 'File,' then 'Save' in the Very Secure FTP Daemon Configuration window.
Start the FTP server by clicking 'Server Control' at the left of the Very Secure FTP Daemon Configuration window, then clicking 'Start FTP Server.'
Make files available over FTP by copying them to the /var/ftp directory on your Fedora system.
In Feburary 2016 27,
Open the software management tool by clicking 'System' at the top of the Fedora desktop 'Administration,' then 'Add/Remove Software.'
Search for the FTP software by typing 'vsftpd' into the 'Find' box in the Add/Remove Software window, then click 'Find.'
Install the FTP server and configuration software by clicking the check boxes next to 'system-config-vsftd' and 'vsftd' in the Add/Remove Software list, then click 'Apply.'
Authenticate yourself, if prompted, by typing your password, then pressing 'Enter.'
Close the Add/Remove Software tool by clicking 'Close' in the Run New Application window, then clicking 'System' and 'Quit' in the Add/Remove Software window.
Open the FTP server configuration tool by clicking 'System,' 'Administration,' then 'FTP Administration.'
Disable downloading or uploading of files, if desired, by clearing the 'Enable Download Files' or 'Enable Upload Files' check boxes with a click on the 'General' screen in the Very Secure FTP Daemon Configuration window.
Disable access of local user accounts to your FTP server, if desired, by clicking 'Users' at the left side of the Very Secure FTP Daemon Configuration window, then clearing the 'Allow Local Users' check box by clicking it.
Disable anonymous access to your FTP server, if desired, by clicking 'Users' at the left side of the Very Secure FTP Daemon Configuration window, clicking the 'Anonymous User' tab, then clearing the 'Allow Anonymous User' check box by clicking it.
Disable viewing of directory lists by clicking 'Directory Options' at the left side of the Very Secure FTP Daemon Configuration window, then clearing the 'Allow Users to View Directory Lists' check box by clicking it.
Save your settings by clicking 'File,' then 'Save' in the Very Secure FTP Daemon Configuration window.
Start the FTP server by clicking 'Server Control' at the left of the Very Secure FTP Daemon Configuration window, then clicking 'Start FTP Server.'
Make files available over FTP by copying them to the /var/ftp directory on your Fedora system.
In Feburary 2016 27,
Friday, 26 February 2016
How to Use Your Own Domain on X10hostingIn Feburary 2016 26,
In Feburary 2016 26,
Log in to your x10hosting Account Management Panel.
Choose 'Hosting' on the Account Management Panel webpage, and then select 'Modify Domain.'
Click to un-check the 'Use an x10Hosting subdomain as my account's main domain' check-box below 'Modify Main Domain.'
Type your domain address in the 'http://' box (for example: abc123.com).
Click the 'Update Main Domain' button.
In Feburary 2016 26,
Log in to your x10hosting Account Management Panel.
Choose 'Hosting' on the Account Management Panel webpage, and then select 'Modify Domain.'
Click to un-check the 'Use an x10Hosting subdomain as my account's main domain' check-box below 'Modify Main Domain.'
Type your domain address in the 'http://' box (for example: abc123.com).
Click the 'Update Main Domain' button.
In Feburary 2016 26,
How to Sync Outlook to DrupalIn Feburary 2016 26,
In Feburary 2016 26,
Direct your browser to the iCalendar Feed module's project page at drupal.org/project/civicrm_activity_ical and copy the module's code link at the bottom of the page.
Log into your Drupal site as administrator.
Open Drupal's 'Modules' menu and click on 'Install New Modules.'
Paste the module code link into the 'Install from a URL' field and click the 'Install' button.
Check the box next to the iCalendar Feed module's name in the modules listing. The iCalendar Feed module will be found in the list of modules related to the CiviCRM module.
Click on the 'Set Permissions' link to the right of the iCalendar module name.
Place a check mark in the boxes next to the the types of users you want to have access to the iCalendar feed and click the 'Save Configuration' button.
Open the 'Structure' menu and select 'Blocks.' In the list of unassigned blocks, you'll see a new one for the iCalendar Feed.
Assign the block to a region that will be visible to your users on your home page and click the 'Save Blocks' button.
Navigate to your home page by clicking the home icon in the administrative menu bar.
Click on the iCalendar Feed link which now appears on the home page. Copy the iCalendar Feed address that is displayed.
Open Outlook 2010 and open the Calendar module. Click the 'Open Calendar' button and select 'From Internet' from the drop-down menu.
Paste the iCalendar Feed URL into the field in the dialog box and click 'OK.' Your CiviCRM events will now appear in your Outlook calendar.
In Feburary 2016 26,
Direct your browser to the iCalendar Feed module's project page at drupal.org/project/civicrm_activity_ical and copy the module's code link at the bottom of the page.
Log into your Drupal site as administrator.
Open Drupal's 'Modules' menu and click on 'Install New Modules.'
Paste the module code link into the 'Install from a URL' field and click the 'Install' button.
Check the box next to the iCalendar Feed module's name in the modules listing. The iCalendar Feed module will be found in the list of modules related to the CiviCRM module.
Click on the 'Set Permissions' link to the right of the iCalendar module name.
Place a check mark in the boxes next to the the types of users you want to have access to the iCalendar feed and click the 'Save Configuration' button.
Open the 'Structure' menu and select 'Blocks.' In the list of unassigned blocks, you'll see a new one for the iCalendar Feed.
Assign the block to a region that will be visible to your users on your home page and click the 'Save Blocks' button.
Navigate to your home page by clicking the home icon in the administrative menu bar.
Click on the iCalendar Feed link which now appears on the home page. Copy the iCalendar Feed address that is displayed.
Open Outlook 2010 and open the Calendar module. Click the 'Open Calendar' button and select 'From Internet' from the drop-down menu.
Paste the iCalendar Feed URL into the field in the dialog box and click 'OK.' Your CiviCRM events will now appear in your Outlook calendar.
In Feburary 2016 26,
Wednesday, 24 February 2016
How to Check a String to See if the Value Is Numeric in SQLIn Feburary 2016 24,
In Feburary 2016 24,
Run your database, and open your usual textual SQL query generator.
Write a query that includes the value you want to check. Using SQL, you can check a field's value by using a regular expression. For example,SELECT DISTINCT my_data FROM my_tableWHERE my_data REGEXP ('[0-9]');Substitute the value 'my_data' with your field name and 'my_table' with your table name. Construct your query using the above as an example of how to determine whether a field is numeric or not.
Execute your query on some test data first. Check that the output matches what you expect to happen before using the query on live data.
In Feburary 2016 24,
Run your database, and open your usual textual SQL query generator.
Write a query that includes the value you want to check. Using SQL, you can check a field's value by using a regular expression. For example,SELECT DISTINCT my_data FROM my_tableWHERE my_data REGEXP ('[0-9]');Substitute the value 'my_data' with your field name and 'my_table' with your table name. Construct your query using the above as an example of how to determine whether a field is numeric or not.
Execute your query on some test data first. Check that the output matches what you expect to happen before using the query on live data.
In Feburary 2016 24,
Sunday, 21 February 2016
How to Install Drupal On 1and1 ServersIn Feburary 2016 21,
In Feburary 2016 21,
OVERVIEW: Before we get into any of the steps below, I am assuming that you are a web designer or programmer that has been looking for an open source content management platform, and decided to use Drupal. I am also assuming that you are hosting your website with 1and1 on a linux package. If both of these assumptions are correct, then proceed to step 2.
INTRO: Congratulations, you have chosen a really cool content management platform that keeps expanding and growing. I am still learning the system myself, but I wrote this article to help anyone who has run into the same install issues that I had when tring to load drupal onto my 1and1 server linux hosting package. I stress that you need to have a linux hosting package because you CAN NOT install drupal onto a 1and1 MS package. I have tried, and it does not work.
STEP 1: 1and1 Linux hosting package confirmation - Make sure that you have a 1and 1 linux hostig package. I recommend that you have at least a home package, but a business package will really be what you want to help expand the drupal system and to better manage your database. Check your 1and1 control panel settings to make sure you are set up correctly. You should have PHP support and a MySQL database option. If you are on the MS package, you will want to 'upgrade' your package to a Linux package. I had to do this with two of my accounts to get drupal to work.
STEP 2: Download Drupal files to your desktop - Go to the drupal.org site and download the most recent drupal version. At the time of my writing this article, the most recent version is 6.10. Download this to your desktop first so that we can easily work with the files. You will notice that you got a tar.gz file downloaded to your desktop. (link in resources below)
STEP 3: Expand Drupal Files - Now we are going to unzip or expand the files. Since this is a tar.gz file, and not a zip file, I recommend that you download and use a program called 7-zip (an open source file archive program) instead of winzip or other popular programs to expand the files. 7-Zip is a great tool, it is free, and it handles archived files really well. Download this program, then unarchive the drupal files to your desktop. (link in resources below)
Great, now you should have a new drupal folder on your desktop with all of the items fully expanded. If you did it correctly, you will see the following folders contained inside your drupal folder: 'includes', 'misc', 'modules', 'profiles', 'scripts', 'sites', 'themes', and other files below. Many directions will tell you to make changes at this point, but I want to urge you to follow my instructions now to help you visual and check in real-time the changes you are making.
STEP 4: FTP drupal files to your web server - Now take all of these files and FTP them to the root of your website. This would be the www folder or the main directory of your site. For the 1and1 server package, it would be the following www.yoursitename.com/ where you will see the '/' in your FTP client. I recommend that you drop the entire drupal folder into this directory to learn how to install the tool. Once you learn how to install the tool, you can later move all of the files out of the folder and drop them directly into your site's root structure. For this example, just call the folder 'drupal' - so for the purposes of this example and to help you install the program, you will be working with the following directory on your own server: 'www.yoursitenamehere/drupal'
STEP 5: Take a look at the drupal web install guide - The cool thing about drupal is that it has an install guide that you can access using a web browser. It helps you by giving you a checklist of things you need to correct, and it also allows you see that you have put the files onto your website server correctly. In this step, we are going to take a look at the web browser install tool, and proceed with configuring some files to get this to work correctly. If you followed my example, you can now open a web broswer and type in the following URL path to get to the installation of the drupal tool: www.yoursitenamehere/drupalIf you did as I specified, you should a screen that looks like the one attached. This will be the drupal online install guide, and it will immediately show us an error screen indicating that we need to configure our settings.
STEP 6: Disable 'register_globals' on 1and1 server - So as the error message says - we want to disable our 'register_globals' on our server. Doing this is very simple. For the 1and1 server package, to do this, we are going to need to create a file called php.ini and save it to the root structure of our drupal directory. Within this php.ini file we are going to place some code that disables the 'register_globals'. Now you may be wondering, how do I make a php.ini file? You can do it using dreamweaver, textpad, notepad, or any web editing tool you use. To keep this simple, I want you to do this using notepad.
STEP 7: Create a php.ini file - Open notepad or a basic text editor. Save this file to your desktop as php.ini (if it saves as a word file, that is fine, just change the name later to php.ini) copy and paste the following code into the file and save it to your desktop drupal folder:register_globals = false(see picture for reference) That is it!
STEP 8 FTP php.ini file to web server - Now take this file and FTP it to your web server in the root directory right into the drupal folder this means, drop it directly into the following location on your server - 'www.yoursitenamehere/drupal'. Once you do this, go back to your web brwser drupal install screen found here: www.yoursitenamehere/drupal, and refresh the screen. You should now see an error message that speaks to copying a setting.php file. It should look like the same message as the error image attached to this step. This is a common error message because as part of the drupal install process, we need to copy the setting.php file and change its permissions.
STEP 9: Create a 'settings.php' file - This is extremely easy to do and is part of the drupal install instructions that you can find on the drupal site. I will explain how to do it here however to keep you moving along smoothly. I do want to point out that you should use the FTP program 'Filezilla' for this step, as it allows you to change the CHMOD permissions on a file, where dreamweaver and other FTP programs do not. If you need to take a moment to install the free FTP program filezilla, please do that now using the link in the resource section below.
STEP 10: Create a 'settings.php' file - Going back to your local drupal desktop folder, find the folder called 'sites' and open it up. Inside you should see two more folders named 'all' and 'default'. Open up the folder named 'default'. You should now see a file named 'default.settings.php'. Simple copy the default.settings.php file resave it right into the 'default' folder along with the default.setting.php file. Since you can not have two files of the same name in the same folder, you are going to need to rename this new copied file as 'setting.php'. (see image for reference) and CHMOD it to 777, to make it readable (do this using filezilla if your FTP client does not allow permission changes)
STEP 11: FTP and CHMOD 777 'settings.php' file - Now we want to FTP this file over to your website server file directory into the 'default' folder in the 'sites' folder to go right along with the 'default.setting.php' file. So the path you will be using to FTP this file to your server if you are following the steps of this write-up is: www.yoursitenamehere/drupal/sites/defaultNow, I recommend that you use Filezilla to FTP this file, because we need to change the CHMOD (permissions) to 777. This makes this file readable and allows drupal to proceed with the installation on your server. Once you have connected to your web server using Filezilla, right click on the 'setting.php' file and change the 'file attributes' to 777. Then FTP this file to your server. I am assuming that you know how to use an FTP program, and if not, please see my link in the resources section to my article about how to use Filezilla.
STEP 12: Check drupal web install guide - Once you have uploaded this file to the server in the 'default' folder within the 'sites' folder of your websites root file directory, go back to the web browser drupal install view here: www.yoursitenamehere/drupal' and click refresh. If you did this install correctly, you should see a screen similar to the one attached to this step.
STEP 13: Increase PHP Memory - NOTE: please read the Drupal Database Configuration screen that you have in front of you now. There is a key element on here that we must address before we get into the actual database setup. In the yellow box, Drupal recommends that we increase our PHP mempory limit to 16M to help prevent errors. I HIGHLY recommend that at a minimum you increase the PHP memory to 16 MB, but it would not hurt to increase it to 32MB. To do this, we are going to go back to the 'php.ini' file that you created and add another line of code. Below the 'register_global' code you created, add the following:memory_limit = 36M (See image for example). Now FTP this new file back into your web file root folder and overwrite your old php.ini file and you should be done increasing the php memory. Go back to your drupal web broswer installation screen and refresh it, and you will now notice that the yellow box is gone, and we are left with the database configuration fields. (see image).
Excellent job so far! We are now at the fun and easy task of setting up a 1and1 MySQL database, and tieing it to the drupal program that we are installing. If you do not understand anything about MySQL databases, do not worry! This is easy to set up using the 1and1 control panel and we only have to change a few items in the drupal code to get everything to synch up. So lets get started creating our 1and1 database!
STEP 14: Create a 1and1 database for your account - Now we want to create a database in our 1and 1 control panel. Log into your 1and1 account using the customer login, and click on the MyAQL administration toolbar in the control panel. See image for reference.
STEP 15: Create a new database - Within the 1and1 MySQL admin tool, there is a button that says 'New Database'. Click this to get a screen that says MySQL Database Setup. You will be asked to give your database a name. Call it Drupal for now, select the version of MySQL to be 5.0, and then click 'setup'. You will get another screen that shows you your user name, password, host name, etc. Just click Finish. In about 30 minutes, you will have a new 1and1 database setup. When you have done all of these steps, and roughly 30 mintues have passed, you should see that your new database was created and you will also see that you have the following information for your new database:Database name: db#########Host name: db###.perfora.netUser name: dbo#########Password:
****
STEP 16a: Add the database info to your 'settings.php' file - There are actually two ways to do this step. Option A shown here is to use the drupal web install tool to enter in your database info. Option B outilined in the next step is the manual way to do this. I actually prefer to do the manual method in Option B, but you can do this either way. Here is option A: using the drupal web install guide at www.yoursitenamehere/drupalSimply enter in your site database name, database username, and database password into the basic option. Then open up the advanced options and enter in your site database host name. Then click save and continue at the bottom of the screen. (see image for reference)
STEP 16b: Add the database info to your 'settings.php' file - Here is option B: Manual processNow that you have created a database, and you have all the info needed for your database, we will need to manually add this info to the drupal 'settings.php' file that we created earlier and uploade to our web server. Doing this skips using the drupal web install guide. You might wonder why you want to do this. I have acutally had issues using the drupal web install guide during this step, so I do it manually, but try Option A if you are not comfortable doing this. To do Option B, simply open the 'settings.php' file again using the text editor, and change the following information:Search for $db_url =Change the line from this:$db_url = 'mysql://username:password@localhost/databasename';To this, using the info from step 15 above:$db_url = 'mysql://dbo#########:
****@db###.perfora.net/db#########';Now save this document and FTP it to your server again using Filezilla as CHMOD 777.
STEP 17: Drupal Final Site Configuration - Congratulations! You are now on the last step of your drupal install on a 1and1 server. If you did all of the steps above correctly, drupal will finalize the install, and you will see the attached screen when you go to the drupal web install guide at : www.yoursitenamehere/drupal Now, just type in the last requirements that it asks you for and click save and continue. It will now take you to your new drupal site and you will be logged in as the admin. Now you can set up your drupal site anyway you like. I will try to write some more articles about how to set up yoru drupal site, but there is a lot to do for this, so you you should probably read the drupal forums on the drupal.org site.
STEP 23: Finished.
In Feburary 2016 21,
OVERVIEW: Before we get into any of the steps below, I am assuming that you are a web designer or programmer that has been looking for an open source content management platform, and decided to use Drupal. I am also assuming that you are hosting your website with 1and1 on a linux package. If both of these assumptions are correct, then proceed to step 2.
INTRO: Congratulations, you have chosen a really cool content management platform that keeps expanding and growing. I am still learning the system myself, but I wrote this article to help anyone who has run into the same install issues that I had when tring to load drupal onto my 1and1 server linux hosting package. I stress that you need to have a linux hosting package because you CAN NOT install drupal onto a 1and1 MS package. I have tried, and it does not work.
STEP 1: 1and1 Linux hosting package confirmation - Make sure that you have a 1and 1 linux hostig package. I recommend that you have at least a home package, but a business package will really be what you want to help expand the drupal system and to better manage your database. Check your 1and1 control panel settings to make sure you are set up correctly. You should have PHP support and a MySQL database option. If you are on the MS package, you will want to 'upgrade' your package to a Linux package. I had to do this with two of my accounts to get drupal to work.
STEP 2: Download Drupal files to your desktop - Go to the drupal.org site and download the most recent drupal version. At the time of my writing this article, the most recent version is 6.10. Download this to your desktop first so that we can easily work with the files. You will notice that you got a tar.gz file downloaded to your desktop. (link in resources below)
STEP 3: Expand Drupal Files - Now we are going to unzip or expand the files. Since this is a tar.gz file, and not a zip file, I recommend that you download and use a program called 7-zip (an open source file archive program) instead of winzip or other popular programs to expand the files. 7-Zip is a great tool, it is free, and it handles archived files really well. Download this program, then unarchive the drupal files to your desktop. (link in resources below)
Great, now you should have a new drupal folder on your desktop with all of the items fully expanded. If you did it correctly, you will see the following folders contained inside your drupal folder: 'includes', 'misc', 'modules', 'profiles', 'scripts', 'sites', 'themes', and other files below. Many directions will tell you to make changes at this point, but I want to urge you to follow my instructions now to help you visual and check in real-time the changes you are making.
STEP 4: FTP drupal files to your web server - Now take all of these files and FTP them to the root of your website. This would be the www folder or the main directory of your site. For the 1and1 server package, it would be the following www.yoursitename.com/ where you will see the '/' in your FTP client. I recommend that you drop the entire drupal folder into this directory to learn how to install the tool. Once you learn how to install the tool, you can later move all of the files out of the folder and drop them directly into your site's root structure. For this example, just call the folder 'drupal' - so for the purposes of this example and to help you install the program, you will be working with the following directory on your own server: 'www.yoursitenamehere/drupal'
STEP 5: Take a look at the drupal web install guide - The cool thing about drupal is that it has an install guide that you can access using a web browser. It helps you by giving you a checklist of things you need to correct, and it also allows you see that you have put the files onto your website server correctly. In this step, we are going to take a look at the web browser install tool, and proceed with configuring some files to get this to work correctly. If you followed my example, you can now open a web broswer and type in the following URL path to get to the installation of the drupal tool: www.yoursitenamehere/drupalIf you did as I specified, you should a screen that looks like the one attached. This will be the drupal online install guide, and it will immediately show us an error screen indicating that we need to configure our settings.
STEP 6: Disable 'register_globals' on 1and1 server - So as the error message says - we want to disable our 'register_globals' on our server. Doing this is very simple. For the 1and1 server package, to do this, we are going to need to create a file called php.ini and save it to the root structure of our drupal directory. Within this php.ini file we are going to place some code that disables the 'register_globals'. Now you may be wondering, how do I make a php.ini file? You can do it using dreamweaver, textpad, notepad, or any web editing tool you use. To keep this simple, I want you to do this using notepad.
STEP 7: Create a php.ini file - Open notepad or a basic text editor. Save this file to your desktop as php.ini (if it saves as a word file, that is fine, just change the name later to php.ini) copy and paste the following code into the file and save it to your desktop drupal folder:register_globals = false(see picture for reference) That is it!
STEP 8 FTP php.ini file to web server - Now take this file and FTP it to your web server in the root directory right into the drupal folder this means, drop it directly into the following location on your server - 'www.yoursitenamehere/drupal'. Once you do this, go back to your web brwser drupal install screen found here: www.yoursitenamehere/drupal, and refresh the screen. You should now see an error message that speaks to copying a setting.php file. It should look like the same message as the error image attached to this step. This is a common error message because as part of the drupal install process, we need to copy the setting.php file and change its permissions.
STEP 9: Create a 'settings.php' file - This is extremely easy to do and is part of the drupal install instructions that you can find on the drupal site. I will explain how to do it here however to keep you moving along smoothly. I do want to point out that you should use the FTP program 'Filezilla' for this step, as it allows you to change the CHMOD permissions on a file, where dreamweaver and other FTP programs do not. If you need to take a moment to install the free FTP program filezilla, please do that now using the link in the resource section below.
STEP 10: Create a 'settings.php' file - Going back to your local drupal desktop folder, find the folder called 'sites' and open it up. Inside you should see two more folders named 'all' and 'default'. Open up the folder named 'default'. You should now see a file named 'default.settings.php'. Simple copy the default.settings.php file resave it right into the 'default' folder along with the default.setting.php file. Since you can not have two files of the same name in the same folder, you are going to need to rename this new copied file as 'setting.php'. (see image for reference) and CHMOD it to 777, to make it readable (do this using filezilla if your FTP client does not allow permission changes)
STEP 11: FTP and CHMOD 777 'settings.php' file - Now we want to FTP this file over to your website server file directory into the 'default' folder in the 'sites' folder to go right along with the 'default.setting.php' file. So the path you will be using to FTP this file to your server if you are following the steps of this write-up is: www.yoursitenamehere/drupal/sites/defaultNow, I recommend that you use Filezilla to FTP this file, because we need to change the CHMOD (permissions) to 777. This makes this file readable and allows drupal to proceed with the installation on your server. Once you have connected to your web server using Filezilla, right click on the 'setting.php' file and change the 'file attributes' to 777. Then FTP this file to your server. I am assuming that you know how to use an FTP program, and if not, please see my link in the resources section to my article about how to use Filezilla.
STEP 12: Check drupal web install guide - Once you have uploaded this file to the server in the 'default' folder within the 'sites' folder of your websites root file directory, go back to the web browser drupal install view here: www.yoursitenamehere/drupal' and click refresh. If you did this install correctly, you should see a screen similar to the one attached to this step.
STEP 13: Increase PHP Memory - NOTE: please read the Drupal Database Configuration screen that you have in front of you now. There is a key element on here that we must address before we get into the actual database setup. In the yellow box, Drupal recommends that we increase our PHP mempory limit to 16M to help prevent errors. I HIGHLY recommend that at a minimum you increase the PHP memory to 16 MB, but it would not hurt to increase it to 32MB. To do this, we are going to go back to the 'php.ini' file that you created and add another line of code. Below the 'register_global' code you created, add the following:memory_limit = 36M (See image for example). Now FTP this new file back into your web file root folder and overwrite your old php.ini file and you should be done increasing the php memory. Go back to your drupal web broswer installation screen and refresh it, and you will now notice that the yellow box is gone, and we are left with the database configuration fields. (see image).
Excellent job so far! We are now at the fun and easy task of setting up a 1and1 MySQL database, and tieing it to the drupal program that we are installing. If you do not understand anything about MySQL databases, do not worry! This is easy to set up using the 1and1 control panel and we only have to change a few items in the drupal code to get everything to synch up. So lets get started creating our 1and1 database!
STEP 14: Create a 1and1 database for your account - Now we want to create a database in our 1and 1 control panel. Log into your 1and1 account using the customer login, and click on the MyAQL administration toolbar in the control panel. See image for reference.
STEP 15: Create a new database - Within the 1and1 MySQL admin tool, there is a button that says 'New Database'. Click this to get a screen that says MySQL Database Setup. You will be asked to give your database a name. Call it Drupal for now, select the version of MySQL to be 5.0, and then click 'setup'. You will get another screen that shows you your user name, password, host name, etc. Just click Finish. In about 30 minutes, you will have a new 1and1 database setup. When you have done all of these steps, and roughly 30 mintues have passed, you should see that your new database was created and you will also see that you have the following information for your new database:Database name: db#########Host name: db###.perfora.netUser name: dbo#########Password:
****
STEP 16a: Add the database info to your 'settings.php' file - There are actually two ways to do this step. Option A shown here is to use the drupal web install tool to enter in your database info. Option B outilined in the next step is the manual way to do this. I actually prefer to do the manual method in Option B, but you can do this either way. Here is option A: using the drupal web install guide at www.yoursitenamehere/drupalSimply enter in your site database name, database username, and database password into the basic option. Then open up the advanced options and enter in your site database host name. Then click save and continue at the bottom of the screen. (see image for reference)
STEP 16b: Add the database info to your 'settings.php' file - Here is option B: Manual processNow that you have created a database, and you have all the info needed for your database, we will need to manually add this info to the drupal 'settings.php' file that we created earlier and uploade to our web server. Doing this skips using the drupal web install guide. You might wonder why you want to do this. I have acutally had issues using the drupal web install guide during this step, so I do it manually, but try Option A if you are not comfortable doing this. To do Option B, simply open the 'settings.php' file again using the text editor, and change the following information:Search for $db_url =Change the line from this:$db_url = 'mysql://username:password@localhost/databasename';To this, using the info from step 15 above:$db_url = 'mysql://dbo#########:
****@db###.perfora.net/db#########';Now save this document and FTP it to your server again using Filezilla as CHMOD 777.
STEP 17: Drupal Final Site Configuration - Congratulations! You are now on the last step of your drupal install on a 1and1 server. If you did all of the steps above correctly, drupal will finalize the install, and you will see the attached screen when you go to the drupal web install guide at : www.yoursitenamehere/drupal Now, just type in the last requirements that it asks you for and click save and continue. It will now take you to your new drupal site and you will be logged in as the admin. Now you can set up your drupal site anyway you like. I will try to write some more articles about how to set up yoru drupal site, but there is a lot to do for this, so you you should probably read the drupal forums on the drupal.org site.
STEP 23: Finished.
In Feburary 2016 21,
Saturday, 20 February 2016
How to Get Rid of the Red X on a WebsiteIn Feburary 2016 20,
In Feburary 2016 20,
Contact the web page administrator if it is not your web page. The administrator will have to fix the page coding or upload the correct images to remove the red 'X.' You can usually find the contact information at the bottom of web page or on a contact page listed in the site links.
Check your Internet connection. If you are viewing a web page and your Internet connection goes down, the page will not display correctly. This can result in the red 'X' appearing where images should be. Check your modem. If the connection lights are not lit, unplug the modem, then plug it back. It should take about 10 minutes for the modem to restart. If the Internet connection light does not light up after 10 minutes, call your Internet provider.
Open the web page in a text editor if it is your own web page. Check the URLs of all your IMG tags. For example, if the image tag says, , check the images folder for a green.jpg. If it is not there, change the URL, or upload the image to that folder.
Check to see if Internet Explorer has images turned off. Go to 'Tools,' then 'Internet Options.' Next, click on the 'Advanced' tab. Check the box that says 'Show Pictures.'
Turn off your anti-virus software, then check the website again. Some anti-virus software can block images.
In Feburary 2016 20,
Contact the web page administrator if it is not your web page. The administrator will have to fix the page coding or upload the correct images to remove the red 'X.' You can usually find the contact information at the bottom of web page or on a contact page listed in the site links.
Check your Internet connection. If you are viewing a web page and your Internet connection goes down, the page will not display correctly. This can result in the red 'X' appearing where images should be. Check your modem. If the connection lights are not lit, unplug the modem, then plug it back. It should take about 10 minutes for the modem to restart. If the Internet connection light does not light up after 10 minutes, call your Internet provider.
Open the web page in a text editor if it is your own web page. Check the URLs of all your IMG tags. For example, if the image tag says, , check the images folder for a green.jpg. If it is not there, change the URL, or upload the image to that folder.
Check to see if Internet Explorer has images turned off. Go to 'Tools,' then 'Internet Options.' Next, click on the 'Advanced' tab. Check the box that says 'Show Pictures.'
Turn off your anti-virus software, then check the website again. Some anti-virus software can block images.
In Feburary 2016 20,
Friday, 19 February 2016
How to Use VBA to Import Data From Excel Into AccessIn Feburary 2016 19,
In Feburary 2016 19,
Launch Microsoft Office Excel and type 'data1' in A2, and 'data2' in B2. Press 'Ctrl' and 'S' to open the 'Save As' dialog Window and save the workbook in 'C:\Temp\' as 'dataToImport.xlsx.' Click 'Save' and close Excel.
Launch Microsoft Office Access, click 'Blank Database' and click the 'Create' button. Click 'Database Tools,' and click 'Visual Basic' to open the VB Editor Window. Click the 'Insert' menu and then click 'Module' to insert a new code module. Click the 'Tools' menu, click 'References,' and check the box next to 'Microsoft Excel
Object Library.'
Start by typing the following VBA code to create new sub procedure:Private Sub importExcelData()
Type the following to create variables you will use to read Excel: Dim xlApp As Excel.ApplicationDim xlBk As Excel.WorkbookDim xlSht As Excel.Worksheet
Type the following to create variables you will use in Access:Dim dbRst As RecordsetDim dbs As DatabaseDim SQLStr As String
Type the following to define database objects and also define the Excel workbook to use:Set dbs = CurrentDbSet xlApp = Excel.ApplicationSet xlBk = xlApp.Workbooks.Open('C:\Temp\dataToImport.xlsx')Set xlSht = xlBk.Sheets(1)
Create a new table with two columns in Access to import data from Excel. Type the following VBA code to create the table using the 'DoCmd' object:SQLStr = 'CREATE TABLE excelData(columnOne TEXT, columnTwo TEXT)'DoCmd.SetWarnings FalseDoCmd.RunSQL (SQLStr)
Open the table you just created by using a the Recordset object. Type the following to open the table and add a new row:Set dbRst = dbs.OpenRecordset('excelData')dbRst.AddNew
Type the following to get values from the Excel workbook, save them to your table and update the record:xlSht.Range('A2').SelectdbRst.Fields(0).Value = xlSht.Range('A2').ValuexlSht.Range('B2').SelectdbRst.Fields(1).Value = xlSht.Range('B2').ValuedbRst.Update
End your procedure by typing the following VBA code:dbRst.Closedbs.ClosexlBk.CloseEnd Sub
Press 'F5' to run the procedure. The data in your Excel workbook has just been imported into your Access table.
In Feburary 2016 19,
Launch Microsoft Office Excel and type 'data1' in A2, and 'data2' in B2. Press 'Ctrl' and 'S' to open the 'Save As' dialog Window and save the workbook in 'C:\Temp\' as 'dataToImport.xlsx.' Click 'Save' and close Excel.
Launch Microsoft Office Access, click 'Blank Database' and click the 'Create' button. Click 'Database Tools,' and click 'Visual Basic' to open the VB Editor Window. Click the 'Insert' menu and then click 'Module' to insert a new code module. Click the 'Tools' menu, click 'References,' and check the box next to 'Microsoft Excel
Object Library.'
Start by typing the following VBA code to create new sub procedure:Private Sub importExcelData()
Type the following to create variables you will use to read Excel: Dim xlApp As Excel.ApplicationDim xlBk As Excel.WorkbookDim xlSht As Excel.Worksheet
Type the following to create variables you will use in Access:Dim dbRst As RecordsetDim dbs As DatabaseDim SQLStr As String
Type the following to define database objects and also define the Excel workbook to use:Set dbs = CurrentDbSet xlApp = Excel.ApplicationSet xlBk = xlApp.Workbooks.Open('C:\Temp\dataToImport.xlsx')Set xlSht = xlBk.Sheets(1)
Create a new table with two columns in Access to import data from Excel. Type the following VBA code to create the table using the 'DoCmd' object:SQLStr = 'CREATE TABLE excelData(columnOne TEXT, columnTwo TEXT)'DoCmd.SetWarnings FalseDoCmd.RunSQL (SQLStr)
Open the table you just created by using a the Recordset object. Type the following to open the table and add a new row:Set dbRst = dbs.OpenRecordset('excelData')dbRst.AddNew
Type the following to get values from the Excel workbook, save them to your table and update the record:xlSht.Range('A2').SelectdbRst.Fields(0).Value = xlSht.Range('A2').ValuexlSht.Range('B2').SelectdbRst.Fields(1).Value = xlSht.Range('B2').ValuedbRst.Update
End your procedure by typing the following VBA code:dbRst.Closedbs.ClosexlBk.CloseEnd Sub
Press 'F5' to run the procedure. The data in your Excel workbook has just been imported into your Access table.
In Feburary 2016 19,
Thursday, 18 February 2016
How to Get TD Class Value in JqueryIn Feburary 2016 18,
In Feburary 2016 18,
Open the Web page in Notepad or a code editor, and look for the jQuery library file. If your code contains no reference to this file, add this code:Place this reference between the '
' tags of your Web page code or just above the closing '
' tag.
Add a pair of 'Write all jQuery code between the '
' tags.
Write a function to check for when the document finishes loading. This is also known as the 'document ready' function:$(function () {});The above code is short-hand for '$(document).ready()'.
Declare an array type variable that will hold the class values of your '' tags:var tdValue = [];Add this code between the curly braces of the 'document ready' function.
Iterate through each instance of '' in the Web page code by creating an 'each()' loop:$('td').each(function(i) {});This code goes after the array declaration. Note that 'each()' attaches to the 'td' selector, and a variable 'i' is passed as a parameter in the function. You need the 'i' variable to get values from the array.
Set your array equal to the results of the 'attr()' function inside the 'each()' loop:tdValue[i] = $(this).attr('class');The 'this' selector gets the parent selector, in this case 'td' from the selector in the line of code above it. Use 'class' inside 'attr()' to get the value of the class attribute for each '' tag.
Output the class name for each '' tag as text in each table cell by adding this line of code after the line containing your 'attr()' function:$(this).text(tdValue[i]);The finished script should look like this:$(function() {var tdValue = [];$('td').each(function(i) {
tdValue[i] = $(this).attr('class');$(this).text(tdValue[i]);
});});
In Feburary 2016 18,
Open the Web page in Notepad or a code editor, and look for the jQuery library file. If your code contains no reference to this file, add this code:Place this reference between the '
' tags of your Web page code or just above the closing '
' tag.
Add a pair of 'Write all jQuery code between the '
' tags.
Write a function to check for when the document finishes loading. This is also known as the 'document ready' function:$(function () {});The above code is short-hand for '$(document).ready()'.
Declare an array type variable that will hold the class values of your '' tags:var tdValue = [];Add this code between the curly braces of the 'document ready' function.
Iterate through each instance of '' in the Web page code by creating an 'each()' loop:$('td').each(function(i) {});This code goes after the array declaration. Note that 'each()' attaches to the 'td' selector, and a variable 'i' is passed as a parameter in the function. You need the 'i' variable to get values from the array.
Set your array equal to the results of the 'attr()' function inside the 'each()' loop:tdValue[i] = $(this).attr('class');The 'this' selector gets the parent selector, in this case 'td' from the selector in the line of code above it. Use 'class' inside 'attr()' to get the value of the class attribute for each '' tag.
Output the class name for each '' tag as text in each table cell by adding this line of code after the line containing your 'attr()' function:$(this).text(tdValue[i]);The finished script should look like this:$(function() {var tdValue = [];$('td').each(function(i) {
tdValue[i] = $(this).attr('class');$(this).text(tdValue[i]);
});});
In Feburary 2016 18,
Wednesday, 17 February 2016
List of Accounting Software PackagesIn Feburary 2016 17,
In Feburary 2016 17,
Sage Peachtree Complete Accounting is, as of October 2010, the highest-rated accounting software on the website Top Ten Reviews. Sage Peachtree gets its lowest marks for ease of set-up, as it can be time-consuming and confusing to initially configure. However, it has a huge number of features and includes free help and technical support. The software has a section for accounts receivable, accounts payable, payroll, inventory, billing, project costs, general ledger, fixed assets, updates and reporting. Sage Peachtree allows users to automate purchase orders and invoice customers by snail mail or by email. You can also automatically check for common accounting errors. Sage Peachtree Complete Accounting 2011 is not available for Macs, but will work with Windows XP, Windows Vista and Windows 7. A demo version is available.
QuickBooks for Mac
Small business accountants using a Mac can use Intuit's QuickBooks. QuickBooks for Mac 2011 allows users to do general ledger accounting, inventory control, reporting and organization. You can put all vendor, customer and employee information in one place and easily track sales, do payroll, track bills, write checks, create invoices and purchase orders and process credit cards. QuickBooks 2011 requires the Snow Leopard operating system for OSX, but allows users to add reminders to iCal, send back-up files to Mobile Me and sync contacts with Mac's Address Book. It also allows users to put data into a file format compatible with Windows. As of 2010, QuickBooks 2011 costs $229.95 for new users and $199.95 for an upgrade.
Tryton
Tryton is an open-source application offered under the GPL-3 license. The program is written in the Python programming language and uses PostgreSQL as the engine for the database. Tryton offers a range of functions, including reporting, invoicing, sales and purchase management, inventory and analysis. The Tryton website has full documentation and users can browse the program's own development wiki or the source code repository. Users can download versions for Linux, Windows and Mac, along with set-up tools. If you are interested and want to try it out before downloading the Tryton files, online demos for all versions are also available.
In Feburary 2016 17,
Sage Peachtree Complete Accounting is, as of October 2010, the highest-rated accounting software on the website Top Ten Reviews. Sage Peachtree gets its lowest marks for ease of set-up, as it can be time-consuming and confusing to initially configure. However, it has a huge number of features and includes free help and technical support. The software has a section for accounts receivable, accounts payable, payroll, inventory, billing, project costs, general ledger, fixed assets, updates and reporting. Sage Peachtree allows users to automate purchase orders and invoice customers by snail mail or by email. You can also automatically check for common accounting errors. Sage Peachtree Complete Accounting 2011 is not available for Macs, but will work with Windows XP, Windows Vista and Windows 7. A demo version is available.
QuickBooks for Mac
Small business accountants using a Mac can use Intuit's QuickBooks. QuickBooks for Mac 2011 allows users to do general ledger accounting, inventory control, reporting and organization. You can put all vendor, customer and employee information in one place and easily track sales, do payroll, track bills, write checks, create invoices and purchase orders and process credit cards. QuickBooks 2011 requires the Snow Leopard operating system for OSX, but allows users to add reminders to iCal, send back-up files to Mobile Me and sync contacts with Mac's Address Book. It also allows users to put data into a file format compatible with Windows. As of 2010, QuickBooks 2011 costs $229.95 for new users and $199.95 for an upgrade.
Tryton
Tryton is an open-source application offered under the GPL-3 license. The program is written in the Python programming language and uses PostgreSQL as the engine for the database. Tryton offers a range of functions, including reporting, invoicing, sales and purchase management, inventory and analysis. The Tryton website has full documentation and users can browse the program's own development wiki or the source code repository. Users can download versions for Linux, Windows and Mac, along with set-up tools. If you are interested and want to try it out before downloading the Tryton files, online demos for all versions are also available.
In Feburary 2016 17,
How to Reinstall MySQL for UbuntuIn Feburary 2016 17,
In Feburary 2016 17,
Click the 'System' menu.
Highlight the 'Administration' category.
Click the 'Synaptic Package Manager' menu option to open the Synaptic Package Manager. Type your password when prompted.
Type 'mysql' in the 'Search' text box at the top of the screen.
Click the check box next to the 'mysql-server' package.
Choose the 'Mark for re-installation' option in the menu that appears.
Click 'Apply' at the top of the screen.
Click 'Yes' in the confirmation dialog that appears. The MySQL server package will be reinstalled.
Command Line
Right-click anywhere on the desktop.
Choose the 'Terminal' option in the menu that appears to open a terminal window.
Type the command 'sudo apt-get install --reinstall mysql-server' to reinstall the MySQL software package.
Type your password when prompted.
Type 'Y' when prompted for confirmation.
In Feburary 2016 17,
Click the 'System' menu.
Highlight the 'Administration' category.
Click the 'Synaptic Package Manager' menu option to open the Synaptic Package Manager. Type your password when prompted.
Type 'mysql' in the 'Search' text box at the top of the screen.
Click the check box next to the 'mysql-server' package.
Choose the 'Mark for re-installation' option in the menu that appears.
Click 'Apply' at the top of the screen.
Click 'Yes' in the confirmation dialog that appears. The MySQL server package will be reinstalled.
Command Line
Right-click anywhere on the desktop.
Choose the 'Terminal' option in the menu that appears to open a terminal window.
Type the command 'sudo apt-get install --reinstall mysql-server' to reinstall the MySQL software package.
Type your password when prompted.
Type 'Y' when prompted for confirmation.
In Feburary 2016 17,
Tuesday, 16 February 2016
How to Upgrade Your Old Blogger.com AccountIn Feburary 2016 16,
In Feburary 2016 16,
Start at the Blogger.com home page (see the Resources section below).
Take a tour of the new Blogger.com if you are unsure whether or not you want to upgrade your account. Click on the 'Take a Tour' link to start.
Click on the 'Switch Now' link to start the process of upgrading your account.
Provide your old username and password in the text boxes provided.
Read the new 'Terms of Service' by clicking on the link and check the box to agree.
Click on the 'Continue' link.
Create a Google Account to Use the New Blogger.com
Enter your current email address. Creating a Google account does not automatically give you a gmail account.
Choose a password. Passwords should be at least six characters long and include numbers or symbols to make it more difficult to guess.
Reenter the password and type the word you see in the word verification field provided for security purposes.
Agree to the terms of service and click on the 'I accept. Create my account' link.
Use an existing Google account to sign in. If you already have a Google account, you can apply it to your new Blogger.com account and get started.
Upgrade and Use the New Blogger.com
Check your email to confirm your new Google account. Click on the link provided in the email or copy the URL into your address bar.
Sign in to your new Blogger.com account.
Use the new Blogger.com features, which include drag-and-drop editing, privacy options and options for RSS feeds.
In Feburary 2016 16,
Start at the Blogger.com home page (see the Resources section below).
Take a tour of the new Blogger.com if you are unsure whether or not you want to upgrade your account. Click on the 'Take a Tour' link to start.
Click on the 'Switch Now' link to start the process of upgrading your account.
Provide your old username and password in the text boxes provided.
Read the new 'Terms of Service' by clicking on the link and check the box to agree.
Click on the 'Continue' link.
Create a Google Account to Use the New Blogger.com
Enter your current email address. Creating a Google account does not automatically give you a gmail account.
Choose a password. Passwords should be at least six characters long and include numbers or symbols to make it more difficult to guess.
Reenter the password and type the word you see in the word verification field provided for security purposes.
Agree to the terms of service and click on the 'I accept. Create my account' link.
Use an existing Google account to sign in. If you already have a Google account, you can apply it to your new Blogger.com account and get started.
Upgrade and Use the New Blogger.com
Check your email to confirm your new Google account. Click on the link provided in the email or copy the URL into your address bar.
Sign in to your new Blogger.com account.
Use the new Blogger.com features, which include drag-and-drop editing, privacy options and options for RSS feeds.
In Feburary 2016 16,
Monday, 15 February 2016
How to Create Your Own Game ServerIn Feburary 2016 15,
In Feburary 2016 15,
Go to the 'Run' option in your computer's 'Start' menu and input 'cmd' to enter the command prompt. Input 'ipconfig /all' in the prompt, and write down your subnet mask and default gateway DNS server as they appear. Write down the IP address also, but you only need the first three sets of numbers, which should be 192.168.1.
Return to the 'Start' menu and go to the 'Control Panel.' Then go to 'Network and Internet Connections,' 'Network Connections.' Right-click on the Internet connection you are using and select 'Properties.' Then select 'Internet Protocol,' 'Properties.' Check the box for 'Static IP address.'
Fill out all of the needed information in the next window with what you wrote down. For the IP address, type in those first three sets of numbers from your original address, all followed by periods, then enter a number of your choice after that (up to three digits). Click 'OK' when finished.
Open your Internet browser to confirm that your static IP address works.
Creating the Server
Download a game server tool such as HLDS Update Tool or HLSW and save it to your desktop. Run the tool to install its files and programs. It basically asks what part of the world you're in and what destination folder you want to use for the program (the default location is Program Files).
Return to the command prompt. Type in 'cd' followed by a space and the full address of the program's location (for example, 'C:\Program Files\Valve\HLServer'). Press 'Enter.'
Type in the command update for your server tool, including the name for the game you want to create a server for. If you're creating a Counter Strike: Source server on HLDS Update Tool, type 'hldsupdatetool.exe -command update -game 'Counter-Strike Source' -dir .' (including the space and period at the end and the quotation marks in the middle).
Wait for the program to install your server after entering the last command. This can take half an hour to an hour, depending on your Internet speed.
In Feburary 2016 15,
Go to the 'Run' option in your computer's 'Start' menu and input 'cmd' to enter the command prompt. Input 'ipconfig /all' in the prompt, and write down your subnet mask and default gateway DNS server as they appear. Write down the IP address also, but you only need the first three sets of numbers, which should be 192.168.1.
Return to the 'Start' menu and go to the 'Control Panel.' Then go to 'Network and Internet Connections,' 'Network Connections.' Right-click on the Internet connection you are using and select 'Properties.' Then select 'Internet Protocol,' 'Properties.' Check the box for 'Static IP address.'
Fill out all of the needed information in the next window with what you wrote down. For the IP address, type in those first three sets of numbers from your original address, all followed by periods, then enter a number of your choice after that (up to three digits). Click 'OK' when finished.
Open your Internet browser to confirm that your static IP address works.
Creating the Server
Download a game server tool such as HLDS Update Tool or HLSW and save it to your desktop. Run the tool to install its files and programs. It basically asks what part of the world you're in and what destination folder you want to use for the program (the default location is Program Files).
Return to the command prompt. Type in 'cd' followed by a space and the full address of the program's location (for example, 'C:\Program Files\Valve\HLServer'). Press 'Enter.'
Type in the command update for your server tool, including the name for the game you want to create a server for. If you're creating a Counter Strike: Source server on HLDS Update Tool, type 'hldsupdatetool.exe -command update -game 'Counter-Strike Source' -dir .' (including the space and period at the end and the quotation marks in the middle).
Wait for the program to install your server after entering the last command. This can take half an hour to an hour, depending on your Internet speed.
In Feburary 2016 15,
Sunday, 14 February 2016
How to Fix Internet Explorer When It Can't Open a WebpageIn Feburary 2016 14,
In Feburary 2016 14,
Find out whether you can view any web pages. Open Internet Explorer and type in the address of a site with which you are unfamiliar. If you need an idea, look around the room and type in a brand name you see, such as 'Sony.com' or 'Saltines.com.' The reason for this is that if you have recently visited a site, the 'cached' files might appear on your screen and not provide an accurate determination. If you are able to see a new site, the issue is likely with the website you are trying to visit.
Check the connection to the modem or router. If you are unable to view any web pages, your connection might have been lost. Check physical connections to see if anything is unplugged. If you are using a wireless connection, verify that it is still working.
Unplug the modem. Pull both the power cord and the phone line or Ethernet plug out of the back of the modem and leave it alone for a few minutes. Plug the cords back in and allow it to power up completely. Try the connection again.
Contact your Internet service provider. A cable, DSL or phone line outage is a common cause for connectivity issues.
Delete Internet Explorer's history. Close any open applications and open a new Internet Explorer window. Click 'Tools' and then click 'Delete Browsing History.' Click each 'Delete' button, except passwords if you allow IE to retain them for you.
In Feburary 2016 14,
Find out whether you can view any web pages. Open Internet Explorer and type in the address of a site with which you are unfamiliar. If you need an idea, look around the room and type in a brand name you see, such as 'Sony.com' or 'Saltines.com.' The reason for this is that if you have recently visited a site, the 'cached' files might appear on your screen and not provide an accurate determination. If you are able to see a new site, the issue is likely with the website you are trying to visit.
Check the connection to the modem or router. If you are unable to view any web pages, your connection might have been lost. Check physical connections to see if anything is unplugged. If you are using a wireless connection, verify that it is still working.
Unplug the modem. Pull both the power cord and the phone line or Ethernet plug out of the back of the modem and leave it alone for a few minutes. Plug the cords back in and allow it to power up completely. Try the connection again.
Contact your Internet service provider. A cable, DSL or phone line outage is a common cause for connectivity issues.
Delete Internet Explorer's history. Close any open applications and open a new Internet Explorer window. Click 'Tools' and then click 'Delete Browsing History.' Click each 'Delete' button, except passwords if you allow IE to retain them for you.
In Feburary 2016 14,
Subscribe to:
Comments (Atom)