How to Merge/Combine Multiple .vcf/.csv Contact Files Into One Single .vcf/.csv File Manually Using Command Prompt

Read: How To Know Whether Emails received are Tracked
Telephone directory or Contacts are most important thing for everyone in this world and no one would like to loose information like phone numbers, addresses etc of loved ones, so for safety, we usually keep a backup of our all contacts, if we loose or damage our gizmo we can import contacts using that backup. Generally if we want to import or transfer contacts from one gizmo to another or to create a backup of contacts, we use " VCARD " feature. In this feature, each contact is saved in a separate vCards(.vcf file) format. If you have too contact files (.vcf files) and you want to transfer them into some gizmo or any online account it becomes a hectic task. At this moment, converting or combining them into one single contact (.vcf) file is useful and handy, so instead of carrying thousands of contact files its better to carry one single file wherever you need. Merging of contact files can done easily and manually and within few minutes using COMMAND prompt.
Read: 13 Best Android Tips to Improve Device Performance
Read: How To Spot or Check Website is Fake or Legitimate
Read: How To Find Torrent File is Genuine or Fake Without Downloading

Follow these steps to merge multiple Vcard files into single Vcard file :-

Step 1 :- Copy all your thousands of contact (.vcf) files into any one particular folder or directory.

Step 2 :- After copying all contact into single folder, now , press shortcut key " Windows + R " or go to option and open windows command prompt.

Step 3 :- Type " CMD " in windows command prompt, as you enter these, command prompt will open.
Step 4 :- As command prompt opens, now navigate to the folder/directory where you have stored all your contact files.

Ex :- Type the drive name and then folder

 D:   [Press Enter]

Cd allcontacts   [Press Enter]

Step 5 :- After navigating to that folder/directory, enter following DOS command:

" copy *.vcf all.vcf  " - For copying .vcf files.
" copy *.csv all.csv " - For copying .csv files.

Step 6 :- Wait for a moment as all your contacts get merged, it will take few seconds.
Step 7 :- Now go to that folder/directory where you had copied all your contacts. You'll find one merged "all.vcf " file of few KB's, just import that single .vcf file wherever you need like on google account, smart phone.

Read: How To Keep Your Computer & Laptop Keyboard Clean
Read: How To Clean and Fix Scratches on Your CD & DVD

Convert .VCF to .CSV

For converting a single or merged .vcf file to .csv file, follow this easy steps:

1. Open any web browser and go to link " labs.brotherli.ch ".
2. Click on " VCF-Convert ".
3. Click on " Browse " button. ( A file navigation box will open, navigate to and click on .vcf file which you wanted to convert to .csv file and click on " Open" button)
4. Click on " Format " drop-down box and select " CSV" file format as output.
5. Click on " Convert " button.

Your .vcf file gets converted into .csv file, you can edit or view in MS Excel or use " CSVed " software which is free to download ( Link to download - csved.sjfrancke.nl ).

Read: How To Play Same Music File on Multiple Android iOS Devices at Once
Read: 5 Latest Tablets With Special Unique Features  

How to Clean Your Computer Laptop Keyboard

You use computer almost daily, right? Have you ever looked closely at computer or laptop keys? Do they look dirty? Dust, dirt or some unidentified stuff coat the keys and build up underneath if not cleaned after certain intervals. Sometimes if not cleaned for long time, the mixture of spilled drinks and crumbs can stop functioning of keys. Cleaning of computer keys is effortless and recommended to practice regularly. Try beneath mention tips to get rid of sticky, murky keys and shine them:

Important Note:

Afore beginning the cleansing process, turn off and unplug computer or laptop from power supply. Detach system from connected cables.

Tap Out Dirt

After turning off, merely turn the keyboard over and shake couple of times, enormous amount of dust might have accumulated underneath the keys if keyboard was not cleaned for prolonged time. As you shake out any loose debris, ensure something is placed under like large piece of old newspaper to lessen effort of gathering detritus later.

A Small Soft-Bristled Dusting Brush

When gizmos, keyboards or consoles are not cleansed on regular basis or for extensive period formerly dust starts accumulating over and beneath the buttons making typing unpleasent. Utilize small soft-bristled dusting brush for daily maintenance. Habitually using brush will aid in getting rid of grimes stuck between keys.   

Disinfectant Sprays

Using computer keyboard utmost severely can breed a whole different kind of filth on keys. Make use of disinfectant sprays but be wary as most of them are strong enough which you might not like. Avoid harsh cleaning solutions, bash on electronics-friendly sprays.

Pop off the Keys

It is always desirable and essential to clean anything utterly from underneath, while cleaning the keyboard pop off the keys and clean all over. Use small screwdriver and cautiously pry up keys. Don't eradicate outsized keys like spacebar, enter, backspace and shift because putting them back might be problematic. Not suggested for laptop keyboard.

Soft Wet Toothbrush

Eliminate grime and remains from vents with the assistance of soft-bristled wet toothbrush. If high speed or compressed air or akin hair drier is not accessible at that very moment, this method comes handy which is effective and safe too.

Use Cotton Swabs

After popping off keys, rinse them in warm water or rub cotton swabs. You can wipe cotton swabs even when buttons are attached or if you're finding tough to uproot. After cleaning-drying them, merely place each key on precise point and press till snap is heard.

Use Pencil Rubber

If you find grimy spots on buttons even after cleansing them rub pencil eraser on it. You might say it won't work but at last you'll be surprised as how this small pencil rubber peels off grubby patch. Be cautious, as small eraser can fall between keys and get stuck inside. After placing all the keys back to their positions, check whether all are functioning accurately.

7 Ways to Clean and Fix Scratches on CD & DVD Disc

If you own bunch of CDs or DVDs and wish to last them longer keep yourself updated with hacks which will definitely come handy at right time instead of crying and regretting at last moment. I bet nothing can be more precious than game CDs of PlayStation, Xbox 360, and PC for hardcore gamers in their life, same is applicable with music lovers, you can't beat them. Also, you'll never commit mistake which can cause any damage to priceless wedding album CDs. Whether its a music, video, game, wedding, document or blank CD it hurts when you lose them. Keep this heartburn at bay with smart tips mention beneath.

How to Store & Handle CDs

It you store and handle them appropriately it can survive for 55 to 100 years. Few precautions should be taken while handling disc collection such as:

1. Hold DVD disc by inserting middle finger inside disc hole or hold at edges with two fingers.
2. Avoid touching shiny side while inserting or removing disc from ODD (Optical Disk Drive) to prevent finger marks.
3. Store unused-idle lying discs into jewel case attached firmly.

4. Have hundreds of CDs, DVDs piled up? Use cake boxes which are compact akin plastic container case.
5. Avoid placing disc under direct sunlight, excessive moisture or exorbitant heat.
6. Never keep hefty items on disc or jewel case, it might break or scratch glossy side

How to Clean any Disc

1. To wipe any accidental finger marks, spills or dust use dry micro-fiber cloth only (used for cleaning of spectacles, glares, computer-laptop screens)
2. Remove stains by lightly rinsing under distilled water followed by small gentle wipes. At all times utilize distilled water, tile, specs cleaner only and certainly not any detergents, chemicals, tap water.

3. Wipe shiny portion radially i.e. starting from center moving outwards, make small wipes. Never rub in circular motion, which might add extra scratches making it worse.

7 Ways to Fix Scratches

Despite taking precautions and care disc might end up with few scratches. Get rid of them without spending a penny with some clever tips. Before you begin to repair scratches remove possible marks, dust and keep utterly dry.

1. Toothpaste: Apply tooth paste on soft cloth or directly on scratched area, gently wipe outwards to buff the huge marks until it gleams. Make small rubs 3-4 times on one scratched portion followed by quick rinse-quick dry. This technique has benefited countless folks, make sure it's done appropriately. 
2. Heat: Many DJ's heat scratched portion or disc under lamp or similar object but keep shiny side away from lamp to prevent too much heating. Hold CD for approximately 1-2 minutes till the region gets warm. It has worked couple of times on non-readable and minor scratch containing discs. You must give a try, after all data inside disc is important for which every possible thing must be tried. 
3. Alcohol: Sprinkle general isopropyl alcohol solution onto glossy side, mostly on affected area and moderately wipe it off starting from inner circle moving towards outside. This solution is effective in cleaning many things like cleansing phone receiver, microphones, and earphones. 
4. Banana: Initially apply silica containing tooth paste, massage throughout with rag starting from center moving outwards. Next, take peeled banana and wipe in circular motion all over, do the same with banana skin (peel) this should fill-in every single scratch. Clean extra banana marks, strains, pieces lying on-top of disc with soft cloth and sprinkle nail polish remover or glass cleaner, again wipe in radial direction. Effectiveness of this trick depends on scratch severity and your efforts. Tough to achieve desired results for seriously and unplayable discs at all. 
5. Car Wax: Place some liquid car wax right on damaged portion, rub in & out gently. Rinse wholly under distilled water couple of times and allow it to dry naturally. It worked with discs that media player showed "Invalid Cd/Dvd". 
6. Furniture Polish: Use any furniture polish substance to buff the scratches, marks on disc. Procedure of placing and rubbing remains similar to above methods. For extremely scratched CDs polish 2-3 times to bring back to life and oh boy it works like charm. 
7. SkipDr: If your disc contains some irreplaceable-unobtainable data like project, wedding albums, priceless memories and every precious thing, it is highly recommended to spend some bucks and buy trustworthy kit like "SkipDr". It'll cost around 30$ which I'm sure is not more than those incomparable data, moments stored inside. This is extremely abrasive than above solutions.

Summary

These were some tested tweaks performed by many individuals and have achieved commendable results. Carefully try above tips convenient to you and hope for the best. It won't turn disc into brand new but will bring back to life, immediately copy data into hard disk, new CD or DVD and now onwards handle with care.

If you have any unscientific crazy solution to protect, clean, fix scratches on CDs DVDs kindly share under comment section: