If you are planning to Import data to a MySQL Database, the first thing which need to check is the whether your data is in the right format. MySQL is best compatible with files in the CSV format. So, in case you have an Excel file you could save that file as a CSV File and you don’t need a special software to do that. All you would have to do is click on File from the Menu and select Save As and make sure the Format Type is CSV.
Now once you have that checked off your list the next and final step is Importing this data to the MySQL Database. If you google this you would get many different explanations and ways which would make you confused. It might ask you to write SQL Queries which you totally don’t have to. If you are using PhpMyAdmin, the easiest and fastest way to do it is to use the Import Function in the menu. Saves you time creating a table and columns corresponding to the data.
Make sure you select the database, then click on the Import button, choose the file and format and Import!
Exchange Online is part of the Office 365 Suite. The Exchange Online Management Center is used to manage and maintain the Exchange online mailboxes. Power Shell can also be used to accomplish these tasks. In order to connect to Exchange Online using Windows Power Shell, one would have to follow these steps-
Steps
Run Windows Power Shell as an Administrator.
Run this cmdlet Set-ExecutionPolicy RemoteSigned
$UserCredential= Get-Credential
A Windows PowerShell dialog box would pop up, type in your Office 365 Credentials.
Then run this cmdlet $Session= New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri http://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection
Import-PSSession $Session
Once you have completed your work, you can close the session by Remove-PSSession $Session
Many of us might have registered for events. Eventbrite is a popular event hosting site. Once you register for an event, there is an option for adding that event to your calendar. Now if you click on the option of adding it to Outlook, a file with the format ics would be downloaded.
Now once the file has downloaded, the next step is to Import that file into Outlook 2016. Here are the steps for that.
Activate the File tab
Select Open & Export
Then click Import/Export
Then select the option Import an iCalendar (.ics) or vCalendar (.vcs) option. And click Next
Select the file you want to Import and click Open . Keep in mind that the format of the file should be either .ics or .vcs
And you are done!! Now you should see the new event in your Outlook Calendar 🙂
There might be times when we switch over to a new computer/laptop. And the first thing we would like to have is something which would relate to our old laptop. One of the things which one would like to have could be Bookmarks. Everything which you like is bookmarked. That is something personal which we would like to take along as you embark on a new journey. And luckily it is not too difficult a wish to fulfill.
One could easily import all his/her Chrome bookmarks from one laptop to the another. Just follow these simple steps.
Steps for Importing bookmarks
In your new laptop. Open Google Chrome and Click on the Menu Bar located on the top right hand corner.
Goto Settings.
3. Click on Sign in to Chrome
4. Add your login credentials for your Gmail Account.
5. Once done, the Advanced Sync Settings option dialog box would appear.
6. Ensure that you have checked the Bookmarks option.
7. Click on OK.
And that’s it! All your bookmarks would be Imported from your previous computer. So you would not loose the Important Links which you might have saved. And this would also give you a continuity in terms of the browsing experience when you are making a transitional change in your hardware 🙂
Google Calendar is a Calendar App which has been there for quite a while now. It came into existence about a decade ago. It released on April 13, 2006 as an Online Application for Calendars. And from then on it has grown to become one of the most popular Calendar Apps in the market.
The main requirement to use the Google Calendar is that you must have a Gmail Account. According to latest reports, it is made to believe that Gmail has about 1 Billion monthly Active Users! This means each of these users would have an access to the Calendar App. But whether they are using it or not is another story all together!
Google Calendar is known to import events automatically from your Gmail to your Calendar. And it can also sync other calendars on your phone. You can set reminders and To-Do tasks. This was all there, but there is one new feature which came out just about two days ago.
It is called Goals. Every one of us might be having some big or small goal which we would like to achieve. It might be learning a new skill or hobby, Loosing Weight/Exercise is quite a common goal. It is always good to have goal but sometimes we don’t stick to our goals and later on we forget about it. Google Calendar addresses this Issue.
It basically allows you to add a Goal of your choice and the App would take care of the rest. And the Calendar App would Intelligently add that event to your already existing schedule. The reason I mentioned “Intelligently” was that it would look at your calendar and see which times are you relatively free and then it would add that Goal to your calendar.
In a realistic scenario many times , even though we have scheduled to do something but due to various reasons we might not be able to do it at that point of time. Google Calendars understands this. There is an option to defer the event, in case you are not able to do your task at that point of time. The App automatically reschedules your event to the next preferred time.
In order to set a Goal one would have to follow these steps-
On the Calendar application, click on the “Plus” button on the lower right hand corner.
There would be 3 options-Goal, Reminder and Event. Select Goal.
Now you can choose what kind of Goal you would like to achieve. The Categories are-Exercise, Build a Skill, Family & Friends, Me time and Organise my life.
Once you select a category, it has sub categories. Choose the one which relates to your goal.
Then you would have to set the frequency-Once a week, Twice a week.
The length of the goal-15 minutes, 1 hour.
Then select what time of the day works best for you-Morning, Afternoon, Evening or Night.
And your Goal is Set!
So, in order to get the Goal feature in your phone just install the latest update of Google Calendars. This update released on April 14, 2016.
Ricky Raghavan 