Skip to main content

Posts

Showing posts with the label how to

How to Rename Files Quickly (using Excel and command Prompt)

Read These instructions once, then follow along with the images. Create a spreadsheet with 3 columns column with current name column with future name paste in equation  ="ren "&A1&" "&B1 Open the start menu, click in the search field and type CMD Open the program called CMD, it should open a little black screen. Go to the folder where the images exist. In the top bar, right-click folder name and select " copy address as text" Back in the CMD program type CD then right click to paste the address that you just copied. Press enter In your spreadsheet, copy the entire column 3 that includes the equations you made. It should resemble ren currentname.jpg goodname.jpg Back in CMD right click and paste your equations in. it should automatically rename everything for you. 

How-To: I'm Feeling Lucky Short Cut

Google's answers usually get me the best result first. Here is a chrome shortcut how to get to "i'm feeling lucky" first result! 1. Copy this URL: http://www.google.com/search?hl=en&q=%s&btnI=I%27m+Feeling+Lucky&aq=f&oq= 2. Go to Chrome Settings 3. Go to Manage Search Engines 4. Scroll to bottom and you'll see blanks to create new 5. In first box type "I'm Feeling Lucky" 6. In second box type "iflucky" or "ifl" (whatever you type here will be your shortcut in the search bar. 7. In the third box paste the URL i asked you to copy It should look like this image below.  Now it should work. Open a new tab and in the search bar type "ifl best waffles"

How to Rename Files using Excel (windows)

I sell lots of things to hardware stores. Retail stores keep track of items by their own internal number. We refer to those numbers as 'customer numbers' because we have lots of customers and customers each have their own numbers. They each call them the SKU number aka STOCK KEEPING UNIT. I had 450 image files listed by model number(our number) that needed to be changed to customer numbers(their number). Here's how i did it. Create an excel spreadsheet with current filename(with file extension) in column A Put the filename you want in column B. Put an equation in column C that is "ren " and column A and " " and column B. spreadsheet should look like this: Current Filename Filename You Want ="ren "&A1&" "&B1 10036.jpg B000HJDBAU.pt01.jpg ren 10036.jpg B000HJDBAU.pt01.jpg 10038.jpg B000VRDIA6.pt01.jpg ren 10038.jpg B000VRDIA6.pt01.jpg 10040.jpg B000BQ7UW4.pt01.jpg ren 10040.jpg B000BQ7UW4.pt01.j...

How to Add an Alias to Outlook 365 / Exchange Hosted Email

My email used to be exchange, but we recently were moved over to outlook365, this post is to help people who use outlook365, but also people who think they're using exchange who are using outlook365. I wanted to create some emails that automatically forward to other people in the office. Often companies use these 3: info@example.com sales@example.com orders@example.com First visit portal.microsoftonline.com  - if you have never used this, you might not have the same capability.  Click "Home": Click "Options": Click "Manage Myself" and change to "My Organization" Click "Distribution Groups" Here is where you can Edit or Add new Alias Email Accounts on outlook365. To Create New: Click "New" Display name - This is similar to account holder name. Just put "sales" or whatever, you can change this later. Alias is the internal name for the group, should be unique and descriptive so every...

Learning Python

Google put out some videos about learning python. A decent tutorial and discussion. Setup and materials Lecture Videos 1.1 Introduction, strings 1.2 Lists and sorting 1.3 Dicts and files 2.1 Regular expr 2.2 Utilities 2.3 Utilities urllib 2.4 Conclusions

Godaddy edit wp-config.php file

source The only reason you should edit your wp-config.php is if you have recently updated your database password. If you're using using godaddy, click "My Account" then "launch" your web host. click the large button that says "FTP* File Manager" edit "Page Size: 25" to "Page size: 50" and find wp-config.php, make sure you don't select wp-config-sample.php click the edit button.  Set Database Password Replace yourpasswordhere , with the your password, e.g. MyPassWord . define('DB_PASSWORD', ' MyPassWord' ); // Example MySQL password Now you can go back and use phpMyAdmin to edit your wordpress database the complete guide is Delete all Comments from wordpress hosted on godaddy

Resetting your mySQL database password with Godaddy

You probably got here from To Reset Your MySQL Database Password Log in to your Account Manager. Click Web Hosting . Next to the hosting account you want to use, click Launch . In the Databases section of the Hosting Control Center, click the MySQL icon. Click the pencil icon next to the database you would like to change the password for to open its edit features. Click the Password icon in the menu bar. In the Update Password window, enter the new password you would like to use in the Enter New Password and Confirm New Password fields. Click OK The password for the selected database will take up to one hour to change. Use this new password to log into the Database Manager of this database. NOTE: If you use a MySQL-based application, such as WordPress, you must update your connection strings to use the new password. how to delete all comments from wordpress on godaddy

Using phpMyAdmin to Manage Mysql databases

This is one step in helping you delete comments on wordpress. I'll try to make a master guide. source To Manage Your Databases Using phpMyAdmin Log in to your Account Manager. Click Web Hosting . Next to the hosting account you want to use, click Launch . In the Databases section of the Hosting Control Center, click MySQL . Click Manage via phpMyAdmin for the database you want to manage with phpMyAdmin. Enter your user name and password. The user name is the same as the database name. TIP: If you don't know your password, see Resetting Your MySQL Database Password for information about changing it. Click Go . When you're inside your MySQL database,  delete all comments from wordpress .

How to Delete All Comments From Wordpress hosted on Godaddy using myPHPadmin

So far i have not seen any good plugins to delete old comments.  My website thatmusicblog.com was on autopilot for a year without akismet and racked up literally 484,000 comments. I was not going to go through deleting them 20 at a time, and all the plugins i tried just didn't work. After reading about myPHPadmin, i was slightly scared to log into the backend and send a script to the mySQL database.  Its easier than it sounds. log into godaddy launch hosting control center and select databases > mySQL If you know your database password, skip to #2. if you don't, continue if you don't know your username and password, you'll have to change it. IF YOU CHANGE IT, you must also go into the FTP file manager and tell wordpress you've changed your password, i'll explain how below. click the pencil on the far right, next to "Manage via phpMyAdmin" click the password button on top nav put in a new password. you must remember...

Google Analytics for your blogger/blogspot blog :)

This thing sure needs to be easier to find. I think its important for any person with a blog that is interested in expanding readers to know exactly how people are getting to their site, and what they're doing there. If this doesn't make sense, install analytics on your blog and it will :) Installing Google Analytics on Blogger is very easy. Here are the basic steps: Sign up for a Google Analytics account Add the GA tracking code to your Blogger template Wait 24 hours and login to Google Analytics to start analyzing your data I found these directions here on the Google analytics blog . Soon you'll see fun charts like this: