Monday, March 2, 2015

Saving E-mail Contacts with a CSV File

SAVING YOUR CONTACT LIST
Most of the time it is difficult to lose your contact list in your e-mail. There was a time when the contacts were saved ON YOUR COMPUTER. That is not the case with most e-mail servers any more. At least to the best of my knowledge. Today the e-mail servers keep your contacts out in hyperspace somewhere. If you forget your password you cannot access your e-mail and therefore you cannot send e-mails to your friends. But the contact address is still out on the web in the servers computer. However if someone should hack into your e-mail they have access to the contacts of yours. Sometimes the hacker just sends spam to all your contacts that looks like it came from your computer. It is also possible that malware could be sent to all your contacts, and there is nothing you can do about it. Another possibility is that the hacker may use your contacts for their own uses and then wipe your contacts from your email server so that you cannot contact anyone, to apologize, to warn or even to say hello.

There is a way to save your contacts on your personal computer or on a thumb drive so that it is easier to recover if the worst happens. You can create a “ .csv file “, which stands for “Comma Separated Value” file. Yahoo, AOL, and Gmail and others allow you to create a .csv file. Juno states that they do not support this action, there may be others that do not allow it also. A .csv file can be created in the three email servers mentioned and the process was similar.


  1. Open your email server.
  2. Select your contact list and open it. All your contacts should be in view.
  3. Look for “Export” The location is a bit different for each email provider. In Yahoo click the box that selects every contact. Then click the word “Actions”. (Before all contacts or at least some of them are selected only the word “Import” will appear.) In AOL click the gear icon that says TOOLS and you will have the choice of Import or Export. In Gmail click the word More and you will have a choice of Import and Export plus other choices.
  4. Left click “Export
  5. Select a format of some sort of CSV. Gmail has three different formats. One for another gmail account, one for other email servers, one for Apple users. (If you plan to go from gmail to gmail choose,Google CSV format (for importing into a Google account) Otherwise choose the generic format. AOL only has one CSV format plus a couple others that are not CSV. Chose CSV always.
  6. Somewhere there will be another place to click “Export”. It likely will be in a pop-up box.
  7. Select a location to save a file that you can find. Your computer will probably assign a name for the file. It would be good to name the file something that is meaningful for you. A suggestion might be, “Contacts From ????? email.” A name like that will allow the computer to search for it from the “Windows Start Button Search Box.” Also you know that you are looking for “Contacts --------”
  8. Left click “Save” and it will save as a “Microsoft Office Excel Comma Separated Value File” even in “Open Office”
  9. When you open the file for viewing you may get a pop-up box that is called Text Import. The character set of “Western European” will be highlighted in blue. Left click “Okay” and it will open as a standard spreadsheet

When it file is open as a spreadsheet there will be a lot of information that you have not put in and the spaces will be blank. This may include things like birthdays, anniversary, work number etc. The information that you have put in will be on one line per contact stretched across many spaces.

To import to a new e-mail follow the same procedure except choose “Import” and select the CSV file and all the information will be put into the new e-mail account. You can also edit the CSV file in the spreadsheet format. You can add, delete, modify any item or row.


If you lose your contact list again or you create a new email address you can basically reverse the procedure by choosing the Import. You are back in business in just a few keystrokes.

Saturday, March 17, 2012

Some More Keyboard Shortcuts

Open Office Writer Keyboard Shortcuts
Recently I was surfing the web and found a website that I found very interesting. I like using the keyboard shortcuts to do a lot of things. After I become familiar with using them I feel like I am a better writer. The following was written by a person who is a lot better than I am using shortcuts so I thought it was worthwhile to share. I will admit that I am unable to figure out why it is ten shortcuts. When I do the counting I find there are nineteen shortcuts in five groups, however I will accept his count. Check the blog of July 2009 for additional keyboard shortcuts that I like.

Ten Fantastic Keyboard Shortcuts In OpenOffice.Org

Ryan Cartwright

A lot of software users I meet seem to feel they are not using their software as efficiently as they could. If that includes you, then listen up. Here is my list of the ten, lesser-known,Open Office. Org Writer keyboard shortcuts that will help you improve your productivity.

When I say “lesser known” I should really say poorly documented or not documented at all. That said, when I’ve taught on keyboard shortcuts in the past these are the ones that fewer users seem to know of. Something else to note is that although these are all for Writer, you may find some of them in other word processors as well.

Why I use keyboard shortcuts
I’m a keyboard type of person. When I first learned to use computers there was no mouse. For my first real application work the mouse was used solely to position coordinates: commands were entered with the keyboard. What can I say, I like using the keyboard. So when I come across an application for the first time I seek out the keyboard shortcuts. Not for me the constant moving of hand from keyboard to mouse.

Even if you are a dedicated mouse user, learning a few keyboard shortcuts can drastically improve the way you work. When you are in the middle of a long edit, hitting CTRL+S is a lot quicker than clicking the save button. Personally I’m not satisfied with just using CTRL+S, CTRL+P and ALT+Menu-Option, I demand more from my keyboard shortcuts! These shortcuts are in no particular order and I use some of them more often than others; however, all of them save me a lot of time.

If you do a lot of typing (as opposed to pseudo desktop publishing) in Writer, it’s definitely worth remembering some of these. They are also very useful if you find yourself writing documents longer than the average letter—for example I often prepare my column pieces in Writer. These also reflect those which end-users find more useful when I teach them.

Moving paragraphs
Ever wanted to move a entire paragraph up or down in your document? Cut and paste may work but it takes time. A more elegant solution is to just move the paragraph itself.
Place your cursor in a paragraph.
Now use CTRL+ALT+ up or down cursor arrows to move the whole paragraph up and down in the document one paragraph at a time
CTRL+up/down works on some set-ups as well.

Change paragraph alignment
This is one of the better known ones but I still find a lot of people are unaware of how much time it can save you.
CTRL+L will change the current paragraph to be aligned left
CTRL+R to be right aligned
CTRL+E to centre it
CTRL+J to justify it

Inserting a page break
Again one that some people know but not that many end-users. In fact I have found a lot of people don’t even know what a page break is and they will just press RETURN several times to move some text onto the next page. Which of course means they come unstuck when the text above is reduced somehow. A page break guarantees the text following it goes on a new page.
Use CTRL+ENTER to this is a new paragraph start a fresh page

Moving around the document
As you use these keyboard shortcuts more you may begin to almost resent having to use the mouse. Particularly to go to defined places like the beginning or end of a line or the document. Most users know about using the cursor keys to move around but there are some ways to jump rather than move.
HOME takes you to the start of the current line (not the current paragraph)
END will go to the end of the line
CTRL+HOME takes you to the start of the document
CTRL+END takes you to the end of the document
CTRL+ LEFT/RIGHT cursor keys moves you in that direction by one word

Selecting without the mouse
Once you get used to moving around using the keyboard you’ll find it useful to select text using it as well. Again some of this is quite well known.
Hold down SHIFT as you move the cursor to select the text you are moving over.
SHIFT+HOME selects from the current character to the start of the line
SHIFT+END selects from the current character to the end of line
Once a line is selected, SHIFT + UP or DOWN cursor keys respectively will add lines above or below to the selection
CTRL+SHIFT+HOME selects from the current position to the start of the document
CTRL+SHIFT+END does the opposite.

Wednesday, February 15, 2012

Putting A Picture Icon In Gmail

THE INSERT IMAGE ICON IN THE GMAIL TOOLBAR

In a computer session I showed how to “Insert images” in a Google e-mail (g-mail). I showed an icon that looked like a couple of mountains (a common icon on cameras to indicate a setting for scenes) which says “Insert Image” when the cursor hovers on it. Some computers did not have this icon as a selection choice. This will show you how to add the icon to the toolbar in gmail. Look for the red arrow in the images that look like this;

Some Instructions or information may be here also. Click on each picture to get a larger view.

Step 1. Open gmail. It will look similar to this. Then left click the COMPOSE box or icon.



Step 2. When you are in the compose mode and do not have the “Insert Image” your gmail will look like this with no icon in the area between “Insert Emoticon and “Link” indicated by the arrow. If the icon that looks like a mountain is there you can stop now. Left click the gear at the other arrow. Also ignore the boxes that are indicated as Boomerang. That is a special app I have put on my gmail.


Step 3. The gear icon gives you access to the gmail settings. There are several options. Left click the “Settings” toward the bottom.


Step 4. Left click on “Labs”. When the labs screen appears, scroll down (using the slide bar on the right side) till you see “Inserting Images”. Left click on the radio button that says enable. This will switch from disable to enable.

Step 5. Using the slide bar along the right hand side, go the either the top or the bottom of the page and left click “Save Changes”. Left click on the “Compose” and return to the compose screen and the “Insert Image” should appear in the gmail toolbar.



This is a very handy tool. Enjoy using it.

Douglas M. Peace
BGR Computer Club

Sunday, February 5, 2012

Windows vs Ford

It was recently that I showed this e-mail to the computer club and it was such a hit that I was asked to send it out to all members. I thought that if it was so popular it should be added to the blog.

WINDOWS vs FORD

For all of us who feel only the deepest love and affection for the way computers have enhanced our lives, read on.
At a recent computer expo (COMDEX), Bill Gates reportedly compared the computer industry with the auto industry and stated,

"If Ford had kept up with technology like the computer industry has, we would all be driving $25 cars that got 1,000 miles to the gallon."

In response to Bill's comments, Ford issued a press release stating:

If Ford had developed technology like Microsoft, we would all be driving cars with the following characteristics (and I just love this part):

1. For no reason whatsoever, your car would crash.........twice a day.

2.. Every time they repainted the lines in the road, you would have to buy a new car.

3... Occasionally your car would die on the freeway for no reason. You would have to pull to the side of the road, close all of the windows, shut off the car, restart it, and reopen the windows before you could continue. For some reason you would simply accept this.

4.... Occasionally, executing a maneuver such as a left turn would cause your car to shut down and refuse to restart, in which case you would have to reinstall the engine.

5..... Macintosh would make a car that was powered by the sun, was reliable, five times as fast and twice as easy to drive - but would run on only five percent of the roads.

6...... The oil, water temperature, and alternator warning lights would all be replaced by a single "This Car Has Performed An Illegal Operation" warning light.

I love the next one!!!

7....... The airbag system would ask, "Are you sure?" before deploying.

8........ Occasionally, for no reason whatsoever, your car would lock you out and refuse to let you in until you simultaneously lifted the door handle, turned the key and grabbed hold of the radio antenna.

9......... Every time a new car was introduced car buyers would have to learn how to drive all over again because none of the controls would operate in the same manner as the old car.

10.......... You'd have to press the "Start" button to turn the engine off.

PS - I'd like to add that when all else fails, you could call "customer service" in some foreign country and be instructed in some foreign language how to fix your car yourself!!!!

Please share this with your friends who love - but sometimes hate - their computer!

Sunday, August 22, 2010

Migital Albums for Win 7 Operating System

This is written to work with Win 7. If the operating system that is installed on your computer is Vista, XP, or an older Microsoft OS there is a write up for it posted just before this..

As it was stated by the person that came up with the idea of some small picture albums the words “digital” and “miniature” were combined to create the word Migital. The end result is a small album with 16 pictures created from a single sheet of 8.5 x11 inch paper. The pictures can be printed on a sheet of card stock or even better on a single piece of photo paper that allows printing on both sides. If you purchase print stock be careful because most photo paper that I have seen is only designed for one sided printing.

While any program that allows you to place multiple picture on a sheet will work the one I chose to work with is Paint. The instructions are rather long and that is partly because I have tried to write it for a person who has little or no knowledge of using paint. The following is a description of how to set up a page format that will allow 8 pictures to be printed on each side of a 8.5 x 11 sheet of paper. I would like for you to understand how to do this on your own. At least understand the principle of how it is done. There is a lot of instruction so I am willing to send you the templates. I do not know how well a Bitmap will send in a e-mail but am willing to try. Send an e-mail request for a “Migital Format” to dpeace4307@aol.com. Be sure to specify what operating system you are using.

1. Open “Paint”. If you do not have it immediately available, press the windows key on your keyboard or left click the start icon on your screen. Left click “All Programs”, find and left click “Accessories”. In the list of programs “Paint” will be listed. Double left click it to open the program. If your computer shows a box that says “search programs and files” just above the windows symbol type “paint” into that and your computer will find the program for you. Just click on it and it will open.

2. I highly recommend that the first thing you do after opening the program is to save the untouched file to a name you will remember, AS A BITMAP format. The default in paint is JPEG and it will cause problems at a later time if it is saved in that format. To save it as a BITMAP, left click “File”, then “Save As”. When the drop down box appears there will be two slots that appear at the bottom. One is asking for the name of the file you want to save, if you do not give it a name it will save as Untitled followed by a sequential number if you save more than once. I changed the name to Image 1, 2, 3, etc. The other is asking for the file format, and it is the one you need to change. Left click at the end of the box and it will give you several choices, choose “Bitmap.” Save as “Image 0” because you will not likely use again.

3. Since eventually the image that you are going to create will be a composite of eight pictures that will be printed on one side of an 8.5 x 11 sheet of paper the logical thing to do is to work in inches. However the paint program in Win 7 does not allow that so inches have to be converted to pixels. I selected 2000 pixels to equal 10 inches. Therefore an 8.5 x 11 sheet of paper will be 1700 x 2200 in size stated as pixels.

4. The layout of the page will two pictures in each row with four rows down the page, thus there will be 8 pictures on the page when you are done. I have set this up to print each picture with a 50 pixel border on each side, left, right, top and bottom. Most printers will only print to within a ¼” of the edge of the paper. I will cease to use the inch measurement here and use only pixels. Remember that one inch is 200 pixels, a half inch is 100 pixels, etc. It would be lot of calculation to determine the exact location of each picture on the page if you figured the location of each of the 8 pictures. It is fortunate that the exact location of only the FIRST picture has to be figured. The other 7 pictures are simple copies of the first one. Each picture will occupy 1/8 of the total space on the sheet, 1/2 of the width of the sheet and 1/4 the height of the sheet. The width of each picture, including the 50 pixel border on each side is 1700 pixels divided by 2 which equals 850 pixels. The height of each picture including a 50 pixel border on each side is 2200 pixel divided by 4 which is 550 pixel. So each picture is 850 x 550 pixel, including the borders of 50 pixels (1/4”) on each side. The actual PRINTED picture will be 750 x 450. This is the setup for the first step in paint.

5 When you are in the paint program in the upper left corner there are the words “Home” and “View', select “Home”. In the working area that is displayed there will be three very small squares boxes along the side and bottom. One is at the middle of the right side, another is at the middle of the bottom side and the third is at the lower right corner. I don't know the official name of them but I call them handles because they can be grabbed and used to adjust the size of the working area. Place your cursor on the handle on the right side and it will change to a double ended arrow. With the double ended arrow move the side till it is 750 pixels wide. The size of working area is indicated at the bottom of the window about three inches from the left side. It is right beside a small box with an arrow on two sides. (To the extreme left at the bottom the location of the cursor in pixels will be indicated.) This is the area that the first picture with no borders will occupy. The borders will be added in a later step. I would advise that you save frequently. Each time I saved the image I saved as the name plus the next number, ie, Image 1, Image 2, Image 3, etc. Then when I fouled up, and I did several times I could go back to the last image that was right and throw the goofs away. Be sure to save as a bit map. Just to see why also save some as Jpegs and see the difference in the colored images. See colored images below.

6. This section is simpler to do than explain. Now you have a blank “canvas” into which a single picture will be placed. However when it is with 7 other identical picture areas plus the borders you will not be able to tell where to place the picture. Now is the time to create tic marks to align the pictures when the picture is pasted onto the white “canvas”. I call it canvas because I cannot think of a more appropriate word. In my Win 7 Paint program the “toolbox” is at the top of the window. There are several things there including, image, tools, brushes, colors, etc. Run your cursor over them and a box with a short description will appear. Select the pencil tool. The pencil will change the color of individual pixels or draw a line just like a lead pencil would do. The default color is black when the left mouse key is pushed and white when the right mouse button is pushed. Other colors can be selected using the cursor and either left or right clicking in the colors. Take the pencil and color (black is likely best) a single pixel at the extreme top left corner. Also color a pixel to the right and one below. This will creat a small tic mark in the corner. Then repeat that action for each of the other three corners. The less pixels that are colored the better for reasons that will be apparent later. To make it easier to see and work with, the view of the page can be enlarged by using the “Zoom Bar” which is located in the lower right corner of the window. It can make the view either larger or smaller without changing the actual size, just like a magnifying glass does. There are set increments from 12.5% to 800%. These four tic marks in the corners will be the alignment points for the corners of your first picture when you paste them in and subsequently for the other 7 pictures also. They will be covered by the picture and will disappear. At this point I selected a color from the color box and used the “paint bucket tool” and filled in the white area. I used bright red. Having a colored image with black tic marks made it easier to work with later. SAVE this image with a name, perhaps “Image 1”, because it will be used again shortly.


This is all that Image 1 will look like (it does have the corner tics)


7. All of this is to create one picture location WITHOUT A BORDER. Now a border can be put on the right side of the first picture AND a border on the left side of the second picture even though the second picture location does not exist yet. Place the cursor on the small square along the right border so the it becomes a double ended arrow and drag the side of the image to the right till it becomes 850 pixels wide. Select a different color, I used green, and fill in this new white area that was just created with the paint bucket . This coloring will save confusion later and will be eliminated towards the end. SAVE this new image with a new name, perhaps “Image 2”.


This is Image 2, it includes the borders of two picture locations

9.In the lower right corner is the “Zoom Bar” which will make the visible image larger or smaller. Zoom in so that the bar at the top that shows the area size shows at least 1600. This will likely be 50% on the zoom bar and it will display slightly over 3000. Grab the right handle and pull it to any amount over 1600, perhaps 1800 and some amount. Some spare room is need for work. Saving at this point is optional, but would not hurt. Zoom back to 100% and move the scroll bar so that the new area and a small part of the colored area is displayed on your screen. In the upper right hand corner is the clipboard with the option of Paste. Click the arrow under paint and select “Paste From”. Then find and select “Image 1” which was saved a bit ago. Image 1 will appear in the upper left corner. Note that the pasted image has a dashed line around it. Left click and hold to move the pasted image to the right. Align the tic marks that were made in the corner of the image next to the colored area. When the two images are in perfect alignment release the mouse. The final step to creating the first row with two picture locations is to reduce the image till it all shows on your screen. Grab the right handle and pull it back to exactly 1600 pixels. If a smaller size is accidentally set, click “Undo” and then do it again. Saving at this point is optional but not a bad idea. Call it Image 3.


This is Image 3 it is two picture locations with one right and one left borders

10 A border has been put between the pictures in the horizontal direction. Now a border needs to be put at the bottom of the first row and at the top of the second row. Each border is 50 pixels or 100 pixels combined for the two. When the magnification is at 100% there is enough room to grab the handle in the middle of the bottom and pull it downwards to exactly 550 pixels. Again fill the new area with a color using the paint bucket, I used yellow. This is a good place to add a tic mark to aid in the cutting of the page which will be done later. At the extreme right and extreme left end of the yellow border place a black tic mark at 500 pixels and another at 501 pixel. This is very easy if you enlarge the image to 500% and left click Image and left click grid. Later you will want to click off the grid as it can make some things hard to see. If you desire similar tic marks can be placed at the top and the bottom of the green border area at the 800 and the 801 pixels. These marks are for the folding which will be done later. I have used two marks so that they can be cut in half or folded in half. Save this as the next image in the numerical sequence or Image 4.


Image 4 with middle borders and two borders at the bottom with tic marks (they really are there)

11. Now is the time to create the full 8 picture areas. Grab the handle and drag the bottom of the image down to at least 1000 pixels, dragging it down as far as you can is good. Adjust the slide bar along the side so that only a part of the yellow shows. Paste Image 4 into paint similar to the pasting that was done in step 9. Click and drag the pasted image so that the tic marks are precisely aligned at the corner, then click off the image. It is not essential to save the image but again it is not a bad idea to save as Image 5.


This is Image 5 showing four picture locations (Image 6 is omitted as it only shows 6 picture locations)

12.There are four picture locations with borders. Repeat the pasting for the next two location with Image 4. Save this as Image 6. Then repeat one final time with Image 3. This will complete the 8 image locations. Save this as Image 7. More images have been saved than are really necessary but it is easier to save and recall them than it is to goof and start from the beginning.


Image 7 with interior borders, all tic marks really are there

13. Now that so much work has been done to create a image with various colors it is time to get rid of the color while saving all the black tic marks. Select the paint bucket and fill every colored area with white, which is actually no color. If the color selection is in default the left mouse button will fill with black and the right mouse button will fill with white. If you accidentally fill with black do not just fill with white. If you do you will lose the black corner tic marks. Instead click the undo and then fill the colored area with white.

14. In the color box select the white color. Fill in all colored area with white, which is actually no color, with the “Fill Tool” or paint bucket. This will leave a white image with only the black tic marks where the picture needs to be placed and the tic marks showing where the sheet will be cut or folded in the middle.

15. So that you know where the pictures need to be placed it is advisable to number each picture space. Before you start numbering copy the template create a second template. You will need two templates to print the album. You will print on the front and back of a single piece of paper to produce a sixteen page Migital album. Use the “Alphabet Tool” to put the numbers in the correct places on the template. When laid out in this order the final album will be in order. The color here is strictly for visual location. (Actually the numbers could be put in before the color is removed, just remove it some time.)


Front Side (template 1)




















Back Side (template 2)

16. Now that the two necessary templates are created it is time to put 16 pictures into the templates. The best thing to do is to open a new dedicated picture file that has COPIES of the pictures that you want in the album. Since there are 8 pictures on each page it is best to have the picture small. A size of 75 to 100 kilobytes is adequate. Since the picture size area has an aspect ratio of 0.6 it is desirable to crop any picture to that aspect. Crop a picture using any photo program like Picasso, or Kodak Photo, or whatever program you like. When you have the picture cropped to the shape you want save it as a copy and open it using paint. Check the attributes of the picture, and adjust them till the pictures height is 60 percent of the width. By rotating the picture as was done earlier the cropping can be done on the desired side.

17. If the width of the picture is more than approximately 450 to 500 pixels wide the size of the picture should be resized. One way to do that is in Paint. With the picture open in Paint in the “Home” view click “Resize” and adjust the percentages to result in a picture of the desired size. Remember that if you resize the width to a certain percent the height needs to be resized to that exact percent. For example if the original picture is 1675 pixels wide and 1005 pixels high it will need to be reduced to 28 percent to have a width of 475 pixels and the height will have to be reduced to 28 percent to keep an aspect ratio of 60 percent. A calculator is handy here and your computer has one which can be found by searching for calculator. Remember any small size will work as long as the ratios are correct. The size I mention is only an example that would work as would many others.

18. When all the pictures are cropped and resized to a small picture you are ready to put them into the template. I would suggest that the pictures be named with numbers 1 to 16 in the order that you want them to appear in the album. With the template open in paint click “Edit” then “Paste From” and select a picture from the dedicated picture file. Place the picture in the location that corresponds to the number on the picture. The pictures are apt to be larger than the space available, so simply grab the corner of the picture and adjust the size to fit the tic marks. As long as you do not accidentally click off the picture you can move it and/or adjust the size. Perfect placement over the tic marks will create a better final result. Be sure to save. Call one set of eight pictures Front and the second set Back, or something to which you will relate. Remember that this has become a single large picture with dimensions of 1700 x 2100 pixels and save this as a “Bitmap”.

19. When all 16 pictures are placed on the front template and the back template it is time to place them in a word processing document for printing. Open your word processing program. Set all four margins, top, bottom, left and right to 0.25 inch. I prefer Open Office word processing to do this for the simple reason that under “View” the text boundaries can be displayed.

20. In the word processing program open either the Front or Back. Click “Insert” then “Picture” then “From File” and select a picture. Adjust the picture in the word document so that it touches the 1/4” border. If you have the boundary displayed it is easy to see and adjust using the tic marks as guides. Since this was set up as an 8.5 x 11 inch picture MINUS the 1/4” border putting it in the word document with a 1/4” margin the border is restored. Save, this time as a word document. Again saving after each picture is put in may save on frustration. Repeat this till all 16 pictures have been put in the desired location.

21. Print the Front, turn the sheet over and print the Back. There are 8 pictures on the front and 8 pictures on the back. If you hold them up to a light the pictures should be in exactly the same location front and back.

22. Cut the sheet into 4 strips that are 2.75” x 8.5”. The tic marks that were put on the sheet in step 10 will help to guide the cut. A straight edge ruler and a sharp Exacto knife would work well for this, better than scissors and maybe better than a sliding paper cutter. Fold the four strips in half. Assemble the strips so that the sequence that you planned is laid out.

23.At this point you have a choice of how to do the final assembly. Some staplers have a throat that allows a staple to be put 4.5 inches from the edge. If you have one of these then you can staple exactly in the middle. Many staplers will only reach 4.375 inches or an eighth inch short of the middle. I bought a Swingline stapler in a flea market for $2.00 and a friend of mine ground a portion of the frame away so that it would staple to 4.5”. If you do not have one of those an alternative is to take a needle with a piece of yarn and sew it together with the yarn and tie it with a bow. I also bought a 1/16” hole punch at Hobby Lobby which makes an even neater hole for yarn or string.

A 3x5 file box will store many of these Migital Albums and they can be kept available to show your friends and neighbors. They would make great personal gifts to children and adults too. Make one of your vacation, or of your new house, or your building construction, some of your favorite flowers, or your children from birth to the present, and be sure to make ones of the individual grand children. The possibilities are only limited by the amount of imagination that you are willing to exercise. Have fun making them and bring some to the BGRCC meetings.

Saturday, August 21, 2010

Migital Albums for Vista, XP and prior Microsoft OS

This is written for Windows XP or Vista and some of the prior Window operating system including 95 & 98. For those that have Win 7 there is another posting that has instruction for that OS.

As it was stated by the person that came up with the idea of some small picture albums the words “digital” and “miniature” were combined to create the word Migital. The end result is a small album with 16 pictures created from a single sheet of 8.5 x11 inch paper. The pictures can be printed on a sheet of card stock or even better on a single piece of photo paper that allows printing on both sides. If you purchase print stock be careful because most photo paper that I have seen is only designed for one sided printing.

While any program that allows you to place multiple picture on a sheet will work the one I chose to work with is Paint. The instructions are rather long and that is partly because I have tried to write it so a person who has little or no knowledge of using paint can understand how to do the setup. The following is a description of how to set up a page format that will allow 8 pictures to be printed on each side of a 8.5 x 11 sheet of paper. I would like for you to understand how to do this on your own. At least understand the principle of how it is done. There is a lot of instruction so I am willing to send you the templates. I do not know how well a Bitmap will send or receive in a e-mail but am willing to try. Send an e-mail request for a “Migital Format” to dpeace4307@aol.com.

1. Open “Paint”. If you do not have it immediately available, press the windows key on your keyboard or left click the start icon on your screen. Left click “All Programs”, find and left click “Accessories”. In the list of programs “Paint” will be listed. Double left click it to open the program. If your computer shows a box that says “search programs and files” just above the windows symbol type “paint” into that and your computer will find the program for you. Just double click on it and it will open.

2. I highly recommend that the first thing you do after opening the program is to save the untouched file to a name you will remember, AS A 24 bit BITMAP format. The default in paint is JPEG and it will cause problems at a later time if it is saved in that format. To save it as a 24 bit Bitmap, left click “File”, then “Save As”. When the drop down box appears there will be two slots that appear at the bottom. One is asking for the name of the file you want to save, if you do not give it a name it will save as Untitled followed by a sequential number if you save more than once. I changed the name to Image 1, 2, 3, etc. The other is asking for the file format, and it is the one you need to change. Left click at the end of the box and it will give you several choices, choose “24 bit Bitmap.” Save as “Image 0” because you will not likely use this again.

3. Since eventually the image that you are going to create will be a composite of eight pictures that will be printed on one side of an 8.5 x 11 sheet of paper the logical thing to do is to work in inches. While the paint program allows working in inches it will be easier to be work in pixels. I selected 2000 pixels to equal 10 inches. Therefore an 8.5 x 11 sheet of paper will be 1700 x 2200 in size stated as pixels.

4. The layout of the page will two pictures in each row with four rows down the page, thus there will be 8 pictures on the page when you are done. I have set this up to print each picture with a 50 pixel border on each side, left, right, top and bottom. Most printers will only print to within a ¼” of the edge of the paper. I will cease, for the most part, to use the inch measurement here and use only pixels. Remember that one inch is 200 pixels, a half inch is 100 pixels, etc. It would be lot of calculation to determine the exact location of each picture on the page if you figured the location of each of the 8 pictures. It is fortunate that the exact location of only the FIRST picture has to be figured. The other 7 pictures are simple copies of the first one. Each picture will occupy 1/8 of the total space on the sheet, 1/2 of the width of the sheet and 1/4 the height of the sheet. The width of each picture, including the 50 pixel border on each side is 1700 pixels divided by 2 which equals 850 pixels. The height of each picture including a 50 pixel border on each side is 2200 pixel divided by 4 which is 550 pixel. So each picture is 850 x 550 pixel, including the borders of 50 pixels (1/4”) on each side. The actual PRINTED picture will be 750 x 450. This is the setup for the first step in paint.

5. Select “Image” and “Attributes” (make sure that pixels has been selected) and set the size of paint to 750 width and 450 height. This is the area that the first picture with no borders will occupy. We will add the borders in a later step. I would advise that you save frequently. Each time I saved the image I saved as the name plus the next number, ie, Image 1, Image 2, Image 3, etc. Then when I fouled up, and I did several times I could go back to the last image that was right and throw the goofs away. Be sure to save as a 24 bit Bitmap. Just to see why also save some as Jpegs and see the difference in the colored images. See colored images below.

6 This section is simpler to do than explain. Now you have a blank “canvas” into which a picture will be placed. However when it is with 7 other identical areas you will not be able to tell where to place the picture. Now is the time to create tic marks to align the pictures when the picture is pasted onto the white “canvas”. I call it canvas because I cannot think of a more appropriate word. There should be a “toolbox” along the left side of the Paint Window. If it is not there left click “View” and “Toolbox”. Select the pencil tool. The pencil will change the color of individual pixels or draw a line just like a lead pencil would do. Take the pencil and color a single line of pixels along the top left corner towards the right and towards the bottom, I found that a length of 2 pixels works well, more pixels will work but I feel fewer is better. I used black for a reason that will become apparent later. It only takes 3 pixels in total, the pixel in the corner is counted in each direction. Do the same thing at each of the other three corners. These tic marks will be the alignment points for the corners of your first picture when you paste them in and subsequently for the other 7 pictures also. To make it easier to see and work with the view of the page can be enlarged by using the “Magnifying tool”. Sliding the magnifying bar to the max makes it very easy. It can make the view either larger or smaller without changing the actual size, just like a magnifying glass does. At this point I selected a color from the color box and used the “paint bucket tool” and filled in the white area. Having a colored image with black tic marks made it easier to work with later. In the picture below the corner tic marks are there, but the image is too small to see them very well. If the color box is not visible left click “View” and “Colorbox”.


This is all that Image 1 will look like (it does have the corner tics)

7. All of this is to create one picture location WITHOUT A BORDER. Now a border can be put on the right side of the first picture AND a border on the left side of the second picture even though the second picture location does not exist yet.

8. Left click image (Ctrl I) then Attributes and set the width to 850 pixels. Select a different color, I used green, and fill in this new white area that was just created with the paint bucket . This coloring will save confusion later and will be eliminated towards the end. SAVE this new image with a new name, Image 2.


This is Image 2, it includes the borders of two picture locations

9. Left click Images (or Ctrl I) and select attributes and make the width 1600. Fill the new area with red and put in the corner tic marks just like in step 6. This will an area for two pictures with a 1/4" border between the two picture areas. It has the left picture with right border and the right picture area with its left border. Save as the next image number, Image 3.


This is Image 3 it is two picture locations with one right and one left borders

10 A border has been put between the pictures in the horizontal direction. Now a border needs to be put at the bottom of the first row and at the top of the second row. Each border is 50 pixels or 100 pixels combined for the two. Left click Image ((Ctrl I) and change the height to exactly 550 pixels. Again fill the new area with a color using the paint bucket, I used yellow. This is a good place to add a tic mark to aid in the cutting of the page which will be done later. At the extreme right and extreme left end of the yellow border place a black tic mark at 500 pixels and another at 501 pixel. This is very easy if you enlarge the image as large as it will go and watch the location of the pencil which is displayed in bottom bar of pain. If you desire similar tic marks can be placed at the top and the bottom of the green border area at the 800 and the 801 pixels. These marks are for the folding which will be done later. I have used two marks so that they can be cut in half or folded in half. Save this as the next image in the numerical sequence or Image 4.


Image 4 with middle borders and two borders at the bottom with tic marks (they really are there)

11. Now is the time to create the full 8 picture areas. The height of the image can be set larger than the final size, it will be adjusted later to the final size Left click "Image" and change the height to 2100 minimum. A 2200 pixel height would be fine. After the image is adjusted move the slide bar along the side so that only a part of the yellow shows. Left click "Edit" and "Paste From" then select "Image 4" and click "Open", (or double click "Image 4"). Click and drag the pasted image so that the tic marks are precisely aligned at the corner, then click off the image. This is easier to do if the image is enlarged with the magnifying tool is used. It is not essential to save the image but again it is not a bad idea to save as Image 5.


This is Image 5 showing four picture locations (Image 6 is omitted as it only shows 6 picture locations)

12. There are now four picture locations with borders. Repeat the pasting for the next two locations with Image 4, making 6 picture locations. Save this as Image 6. Then repeat one final time with Image 3. This will complete the 8 image locations. Save this as Image 7. More images have been saved than are really necessary but it is easier to save and recall them than it is to goof and start from the beginning. I have restarted several times.


Image 7 with interior borders, all tic marks really are there

13. Now that so much work has been done to create a image with various colors it is time to get rid of the color while saving all the black tic marks. Select the paint bucket and fill every colored area with white, which is actually no color. If the color selection is in default the left mouse button will fill with black and the right mouse button will fill with white. If you accidentally fill with black do not just fill with white. If you do you will lose the black corner tic marks. Instead click the undo and then fill the colored area with white.

14. In the color box select the white color. Fill in all colored areas except the black tic marks with white, which is actually no color, with the “Fill Tool” or paint bucket. This will leave a white image with only the black tic marks where the picture needs to be placed and the tic marks showing where the sheet will be either cut or folded in the middle.

15. So that you know where the pictures need to be placed it is advisable to number each picture space. Before you start numbering copy the template to create a second template. You will need two templates to print the album. You will print on the front and back of a single piece of paper to produce a sixteen page Migital Album. Use the “Alphabet Tool” to put the numbers in the correct places on the template. When laid out in this order the final album will be in order. These numbers will be covered by the pictures. Note at this point there should be no color in your template. The color here is strictly for visual location. (Actually the numbers could be put in before the color is removed, just remove it some time.)


Front Side (template 1)



Back Side (template 2)

16. Now that the two necessary templates are created it is time to put 16 pictures into the templates. The best thing to do is to open a new dedicated picture file that has COPIES of the pictures that you want in the album. Since there are 8 pictures on each page it is best to have the picture small. A size of 75 to 100 kilobytes is adequate. Since the picture size area has an aspect ratio of 0.6 it is desirable to crop any picture to that aspect. Crop a picture using any photo program like Picasso, or Kodak Photo, or whatever program you like. When you have the picture cropped to the shape you want save it as a copy and open it using paint. Check the attributes of the picture, and adjust them till the pictures height is 60 percent of the width. By rotating the picture as was done earlier the cropping can be done on the desired side.

17. If the width of the picture is more than approximately 450 to 500 pixels wide the size of the picture should be resized. One way to do that is in Paint. With the picture open in Paint in the “Home” view click “Resize” and adjust the percentages to result in a picture of the desired size. Remember that if you resize the width to a certain percent the height needs to be resized to that exact percent. For example if the original picture is 1675 pixels wide and 1005 pixels high it will need to be reduced to 28 percent to have a width of 475 pixels and the height will have to be reduced to 28 percent to keep an aspect ratio of 60 percent. A calculator is handy here and your computer has one which can be found by searching for calculator. Remember any small size will work as long as the ratios are correct. The size I mention is only an example that would work as would many others.

18. When all the pictures are cropped and resized to a small picture you are ready to put them into the template. I would suggest that the pictures be named with numbers 1 to 16 in the order that you want them to appear in the album. With the template open in paint click “Edit” then “Paste From” and select a picture from the dedicated picture file. Place the picture in the location that corresponds to the number on the picture. The pictures are apt to be larger than the space available, so simply grab the corner of the picture and adjust the size to fit the tic marks. As long as you do not accidentally click off the picture you can move it and/or adjust the size. Perfect placement over the tic marks will create a better final result. Be sure to save. Call one set of eight pictures Front and the second set Back, or something to which you will relate. Remember that this has become a single large picture with dimensions of 1700 x 2100 pixels and save this as a “24 bit Bitmap”.

19. When all 16 pictures are placed on the front template and the back template it is time to place them in a word processing document for printing. Open your word processing program. Set all four margins, top, bottom, left and right to 0.25 inch. I prefer Open Office word processing to do this for the simple reason that under “View” the text boundaries can be displayed.

20. In the word processing program open either the Front or Back. Click “Insert” then “Picture” then “From File” and select a picture. Adjust the picture in the word document so that it touches the 1/4” border. If you have the boundary displayed it is easy to see and adjust using the corner tic marks as guides. Since this was set up as an 8.5 x 11 inch picture MINUS the 1/4” border putting it in the word document with a 1/4” margin the border is restored. Save, this time as a word document. Again saving after each picture is put in may save on frustration. Repeat this till all 16 pictures have been put in the desired location.

21. Print the Front, turn the sheet over and print the Back. There are 8 pictures on the front and 8 pictures on the back. If you hold them up to a light the pictures should be in exactly the same location front and back.

22. Cut the sheet into 4 strips that are 2.75” x 8.5”. The tic marks that were put on the sheet in step 10 will help to guide the cut. A straight edge ruler and a sharp Exacto knife would work well for this, better than scissors and maybe better than a sliding paper cutter. Fold the four strips in half. Assemble the strips so that the sequence that you planned is laid out.

23.At this point you have a choice of how to do the final assembly. Some staplers have a throat that allows a staple to be put 4.5 inches from the edge. If you have one of these then you can staple exactly in the middle. Many staplers will only reach 4.250 inches or a quarter inch short of the middle. I bought a Swingline stapler in a flea market for $2.00 and a friend of mine ground a portion of the frame away so that it would staple to 4.5”. If you do not have one of those an alternative is to take a needle with a piece of yarn and sew it together with the yarn and tie it with a bow. I also bought a 1/16” hole punch at Hobby Lobby which makes an even neater hole for yarn or string.

A 3x5 file box will store many of these Migital Albums and they can be kept available to show your friends and neighbors. They would make great personal gifts to children and adults too. Make one of your vacation, or of your new house, or your building construction, some of your favorite flowers, animals, or your children from birth to the present, and be sure to make ones of the individual grand children. The possibilities are only limited by the amount of imagination that you are willing to exercise. Have fun making them and bring some to the BGRCC meetings.

Friday, April 23, 2010

Some Good Websites

There are millions of websites on the WWW. Many of them are fun sites, some necessary, some useful and of course others that a normal person would be better off if they never visited. I have found some of these sites years ago and a couple within the last week. I will put them here and allow you to pick the ones that interest you. The following is a number of sites that I have used or visited and have enjoyed. Often these can be found with a simple Google search. It is amazing what Google can find for you. There is no rhyme or reason to the order except they are listed as I thought of them. Just copy the link and paste into your browser search bar.

We all will need help with our computers from time to time, or sometime we simply have a question of how do you do something. So what do you do if your computer is in one state and the helper is in another state. One solution is to connect to the helpers computer across the Internet and allow them to see what it is on your computer. There are several programs that do that that are free and easy to use.
www.crossloop.com is one of those programs www.pcanywhere.com is another

If you want to follow a blog but get discouraged because you check back many times and there is nothing new you are like a lot of others. A program that is out on the net that will notify you by e-mail when something changes is the solution. This one is new to me but seems to be working.
www.followthatpage.com

Place the State is a fun little game that challenges your knowledge of the locations of the states in the USA. I usually get mixed up with the states in New England.
http://www.sheppardsoftware.com/states_experiment_drag-drop_Intermed_State15s_500.html

This is a link to the quote of the day. It can also be used to find out who made a particular quote or you can simply browse quotes.
http://www.brainyquote.com

It has been said that satire is one of the best forms of humor. If you like that then this is a good site for up to the date news stories in satire. It is written in a way that seems to be real news but it is all in fun.
http://www.redtractor-usa.com

There are many sites for recipes on the web. This one claims to have the greatest number of any site on the web. I have found it to be very easy to find and to save recipes.
http://www.recipezaar.com/

This site has many book that can be read without charge. There are current books and old books and they increase the number constantly.
http://www.pagebypagebooks.com

The oops list has hundreds of pictures of accidents and situations that will make you say OMG.
http://www.micom.net/oops


If you like pictures of trains and railroads and information about them this is a great site. It has enough links to keep you occupied for many hours.
http://www.railfan.net

Want to know when a movie was made, who was in a movie or almost any other information about a movie, this is the place to look.
http://www.imdb.com

Are you going to travel somewhere and would like to know what the average gas price is going to be. This site is a map that will give you that information.
http://www.gasbuddy.com/gb_gastemperaturemap.aspx

I have not a single clue as to what a person would do with a flaming cursor. But it is a fun site to visit and then play around with you mouse moving the flame around the page.
http://www.flamingcursor.com

When I write I am sure that I make mistakes in the use of the English (or as I would really rather it was called American) language. This is a place to get help.
http://www.wsu.edu

What was going on when you graduated from high school. What music was being played in the 50's & 60's. Go to this site and find out a lot.
http://www.centex.net

Do you like the stories of Paul Bunyun or some other folklore character. Read the old stories about some of the heroes of the past here.
http://www.americanfolklore.net

Like to watch “Deal or No Deal” on TV, play it for yourself and see if you can become a millionaire in fantasy. I have not ever done very well. But then it is fun.
http://www.nbc.com/Deal_or_No_Deal/game/dond.swf

This site gives you a sliding clock that displays the time and you really can watch time slide by
http://home.tiscali.nl/annejan/swf/timeline.swf

At this site you have the choice of a handwritten clock or several others. I think they can be downloaded to your computer and used as a screensaver.
http://www.beeks.eu

When I was a kid I liked to play twenty questions. I can go here and play the game against a computer somewhere and try to stump it. It is not easy to stump the computer, but still possible.
http://www.20q.net

How many births were there today, or deaths or cars built in the last week. These and MANY other question can be answered here. You can see the numbers changing as you watch.
http://www.worldometers.info

Sometime I want to know the rules for using commas, apostrophes, hyphens or whatever. I did not pay enough attention when my grammar teachers tried to “learn” me. Now as an adult I need some help.
http://www.arts.uottawa.ca/writcent/hypergrammar

Who said that? Some sayings are worth reading and remembering. Here is a place to research quotes.
http://www.quotesandsayings.com/quotes/find


What is the origin of the words that I use commonly. Sometimes the word has a surprising origin. I have been told that a word was created because of a certain event. It sounded a bit strange so I have gone here to find out the truth.
http://www.etymonline.com/index.php

Would you like to have help with your writing skills. There is a site called After that Deadline that might help. It should give you help in spelling, grammar and style. I have not used it much but I think that perhaps I will use it more in the future.
www.polishmywriting.com

There are many more good websites out on the net. These are just a few that I have found worth visiting once in a while.

It is now December 28, 2010 and I want to add two websites. The first is a location to find comic strips that are placed in newspapers. There are hyperlinks to many comics. The other one is a link to commercials that I love, "The California Happy Cows Commercials." I personally think they are wonderful.

To find a great number of comic strips and keep up with them go to
http://www.chron.com/apps/comics/showComics.mpl

California Cow Commercials
http://www.realcaliforniamilk.com/happycows