Skip to main content

Posts

Showing posts from 2012

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

Something Ventured - Venture Capital Documentary

Something Ventured is a great ride through the 50's, 60's, and 70's of venture capital and entrepreneurship. Its the techcrunch and pandodaily of our time because it eloquently frames the businesses and deals in a format comparable to current companies. You can tell that money and value grows in the same pace as memory grows in technology. it doubles every 18 months. if one company is worth 50million today, the next biggest company will be double. ok maybe thats a stretch. but you can tell that powerpoint was the instagram or siri of our time. being purchased and swallowed into huge companies to become giant parts of the business. there are always businesses that have had bullshit ideas that pivoted and created a valuable business. There are also genius ideas that truly satisfy a huge need and reduce friction for current lifestyles. Basically, its a great documentary for anyone that reads techcrunch/venturebeat/pandodaily/mashable/AOL(jk)...

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

Design, Prototyping, and Manufacturing of Physical Products Guide

Below is a Design, Prototyping, and Manufacturing of Physical Products Guide that i found on Hackernews that i wanted to save for eternity. source Best Cheap Design Package:  Ailbre Design (as low as $50) http://www.alibre.com/ I used this before Solidworks, if the design isn’t extremely complicated this is the software to use. Make sure to find a coupon, they offer 50% off about every other month. There are 3 different price points depending on what you are doing. Very active community that helps newcomers learn. Enclosure Prototyping in the US:  http://www.protomold.com/ or http://www.quickparts.com/ I tend to use Quickparts more, but Protomold is also very good. All you do is upload the design and they price it. Also Quickparts offers samples that show you different finishes, materials, and designs problems to avoid. If new, definitely order one. Design Guidelines: http://www.protomold.com/Resources.aspx Shows you the general rules on materials and design. Outsourci

How to Stop getting Facebook Notifications from Close Friends

I recently saw a facebook popup to "Star" some friends to indicate they're close. I didn't realize that i'd get a notification for every single post they made. WOW.  Here's how to turn off notifications: Log into facebook Now on the left click down to view your lists ! You can use this link if you want >>>   https://www.facebook.com/bookmarks/lists Click the notifications button and turn them OFF. 

Xbox is the Best Opportunity Microsoft has to remain a Consumer Company

People are constantly finding more ways to spend less money on cable/comcast without giving up the content. All the content providers and networks are making fantastic content but none of them are pushing it out there. Eventually things we dream about will come true, our questions will be answered. Why can't i watch this hockey game on the internet. Why can't i watch it on my xbox? why can't i watch it on my PS3/ROKU/boxee/etc. I think there needs to be an open-source distributor, who literally only keeps enough money to pay the bills and expand. 

Facebook Photos Screensaver Windows

I wanted to share this windows screensaver that pulls in recent facebook photos. Its called photogroupr and it pulls in recent facebook photos and creates a screensaver for your windows PC. You can create groups so that recent photos from everyone in the group are uploaded to all the screensavers http://www.photogroupr.com

How to Batch Merge photos by rendering them as image sequences

I was wondering How to Batch Merge photos by rendering them as image sequences. A friend gave instructions.

Family Computer Repair Man? Get Soluto

I saw this video, then ignored and badly needed to find it three weeks later Family Computer Repair Man? Soluto Intro from Soluto on Vimeo . In Header Text Help my parents update their computers remotely update my computer remotely cloud computer management Computer updates as a service Family Computer Repair Man Family CTO? Hate fixing parents computers Update parents computers for them Are you the person that family, friends and colleagues call with a problem with their pc? Then we've got somethign that will make you and them happier. soluto lets you help other people with their PCs, to see whats frustrating them, before they call you to complain make their pc as cool as yours. Silently upgrade stuff to stop nagging reminders. spot when hardware repairs are needed. install the apps that no-one should be without. and chop their boot to get their PC started faster and running smoother. you can do all this even if their computer is off or in another country. T

The Future of ECommerce 2012

I get excited about Ecommerce, because there's so much potential! we have smartphones suggesting restaurants when we walk by them on the street, but 99.99% of retail stores don't have active live inventory updated on their ecommerce stores. I'd say i've never seen a retail store that did this because it hasn't been easy. Behold the future; Your warehouse-manager/Receiving-clerk will scan-in inventory as they normally do, and it will instantly be published to your website. Anyone following that item can be notified. The copy/content is pulled from other websites. Basic product knowledge is not protected by copyright, as it is common knowledge. When someone buys online, a big red light will appear, or a sound will be made on the stereo, or something similar that the owner chooses. That way they'll know to remove an item from the shelf. the label will be printed, the box will be suggested. Use Spree as your E-Commerce Platform Pay someone to install Spre

PhotoQ Archive - i love this plugin too much

PhotoQ by Manu is one of the best plugins i've ever used for wordpress. It lets you Bulk upload photos into a queue into their own posts. ITs amazing. Sadly he has stopped working on it. Below is the a copy of his content in case he stops paying for his hosting.

Amazon Product Image Shortcut URL from ASIN

I'm trying to find a better way to build my affiliate pages. I've discovered a great way to find images of items that i hadn't known about before. http://images.amazon.com/images/P/B0051VVOB2.01.LZ.jpg http://images.amazon.com/images/P/ <- this is required B0051VVOB2 <- this is the ASIN .01.LZ.jpg <- this is required to follow the asin for large photos If you would like smaller, remove the LZ. http://images.amazon.com/images/P/B0051VVOB2.01.jpg

Gopro Automatically Record When Turned On, Turn Off to Stop Recording

Gopro makes it possible for "1-button" recording. Instead of turning on, then pressing the record button, again to stop recording, and another button to turn off. You can make the settings so that it starts recording when you turn it on. Below is the instructions. CHOOSING ONE BUTTON MODE ON / OFF "one button mode on" forces the camera to automatically begin recording video or photos once the camera is turned on, depending on which default power up mode the camera is set to. In "one button mode On" the camera is either "on and recording". or powered off. This simplifies camera operation when loaning the camera to friends or when you know you only want to shoot in one mode. The shutter button is disabled in "One Button Mode" and will not start or stop the recording while the camera is on. "One Button Mode" is convenient when you only want to shoot one type of video and prefer to simplify operation of the camera to be o