Importing a schedule to Outlook calendar

Avatar

Please consider registering
Guest

Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

Register Lost password?
sp_Feed sp_topic_old
Importing a schedule to Outlook calendar
Avatar
soldat
Member
Forum Posts: 93
Member Since:
October 6, 2008
sp_UserOfflineSmall Offline
1
September 6, 2009 - 10:13 pm
sp_Permalink sp_Print

I am having difficulty importing a schedule (football) to Outlook calendar.
1. I have downloaded the file and saved it on the desktop as a .csv file.
2. I open Outlook, select "import & export"
3. Choose "import from another program or file"
4. Select "Comma Separated Values (DOS)"
5. ID the file and select "Do not import duplicate items"
6. Now I am supposed to select my calendar but the box for that choice is totally blank with no way to browse or make any further choices. That is the point I am stuck at.

Any suggestions on where I went wrong would certainly be appreciated.

Thank you.

Avatar
Jim Hillier
Admin
Forum Posts: 2492
Member Since:
August 9, 2011
sp_UserOfflineSmall Offline
2
September 8, 2009 - 3:59 pm
sp_Permalink sp_Print

Hey Soldat - I'm just replying here coz I don't want you to think you are being ignored. I actually don't know a lot about Outlook. I've asked our lovely Carol to reply here but she must be away at the moment.

The list of steps you have taken is absolutely spot on so I'm at a loss to know why the calendar option is not available at the end. Are you able to access the calendar normally?

I'm sure someone with much more knowledge than I on the subject (which wouldn't be too difficult will reply soon....hang in there mate!!

cheers now.....JIM

Avatar
soldat
Member
Forum Posts: 93
Member Since:
October 6, 2008
sp_UserOfflineSmall Offline
3
September 8, 2009 - 5:05 pm
sp_Permalink sp_Print

Calendar is working fine. In fact I was able to successfully import a schedule prior to this but the big difference was that file was a CSV - Word file and the one I was working on is a CSV-DOS file. I wonder if I am missing some .DLL file that allows the importation process to complete the cycle. Thanks for the update.

Avatar
Chad Johnson
Mod
Forum Posts: 867
Member Since:
August 11, 2011
sp_UserOfflineSmall Offline
4
September 9, 2009 - 9:07 am
sp_Permalink sp_Print

Hi soldat, time for some WAGing (Wild a** Guessing):

What version of Office do you have?

Since you have Outlook, you probably have Excel? Can you open the CSV file in Excel?

In Outlook 2003 you have the choice of CSV(Dos) and CSV(Windows). Have you tried the Windows option?

You could always add the CSV file entries by hand (kidding!!).

Umm...let's start there.

Avatar
soldat
Member
Forum Posts: 93
Member Since:
October 6, 2008
sp_UserOfflineSmall Offline
5
September 9, 2009 - 4:31 pm
sp_Permalink sp_Print

I am using Office 2003. I do have Excel 2003 and have opened the file using Excel. I did try to import the file using CSV-Windows, but nothing happened. I tried to import the file at my office computer and it worked fine, but I have Office 2007 there.

Avatar
Chad Johnson
Mod
Forum Posts: 867
Member Since:
August 11, 2011
sp_UserOfflineSmall Offline
6
September 10, 2009 - 9:24 am
sp_Permalink sp_Print

If Excel is opening it, try resaving it from Excel (give it a different file name) as a CSV file.

Avatar
Carol Bratt
Mod
Forum Posts: 66
Member Since:
August 11, 2011
sp_UserOfflineSmall Offline
7
September 10, 2009 - 9:39 pm
sp_Permalink sp_Print

I'm working on your inquiry and will get back to you with some info as soon as I can! Hang in there and thanks for your patience!

Avatar
Carol Bratt
Mod
Forum Posts: 66
Member Since:
August 11, 2011
sp_UserOfflineSmall Offline
8
September 13, 2009 - 2:27 pm
sp_Permalink sp_Print

Ok, I am going to weigh in with what I have come up with on this topic. I am not a football fan in any way, shape or form, but I went to the Net today and downloaded the Baltimore Ravens Football schedule to th my desktop to try and recreate the problem. Here is what I came up with:

I downloaded the file from the Ravens site and saved it to my desktop as a .csv file.
I opened my MS Outlook calendar and clicked on [b:wnnprq67]File | Import & Export[/b:wnnprq67].
I selected[b:wnnprq67] Import from another program or file[/b:wnnprq67].
I selected [b:wnnprq67]Comma Separated Values [/b:wnnprq67]([b:wnnprq67]Windows[/b:wnnprq67]) and clicked [b:wnnprq67]Next[/b:wnnprq67].
I navigated to the file I previously saved on my desktop and clicked [b:wnnprq67]Next[/b:wnnprq67].
The next window has a title that says [b:wnnprq67]The following actions will be performed [/b:wnnprq67]above an option to Import csv into folder Calendar.
I checked that box and clicked on [b:wnnprq67]Map Custom Fields[/b:wnnprq67].
I selected Do not import duplicant items.
From there, I clicked and dragged the needed fields from the left window into the right window, according to the correspondeing fields below:
START_DATE to Start Date
START_TIME to Start Time
SUBJECT tp Subject
LOCATION to Location
DESCRIPTION to Description.
END_TIME to End Time
REIMINDER_ON_OFF to Reminder On/Off (If you want a reminder)
REMINDER_date to Reminder Date
REMINDER_TIME to Reminder Time.
I clicked [b:wnnprq67]OK[/b:wnnprq67].
Then I clicked [b:wnnprq67]Finish[/b:wnnprq67].

It all worked like a charm. I now have the Baltimore Ravens' football schedul in my Outlook calendar.

I suggest you go back and try it again and see if you still continue to have problems. If you should have more problems, please let us know. Sorry for the delay in getting back to you!

Avatar
soldat
Member
Forum Posts: 93
Member Since:
October 6, 2008
sp_UserOfflineSmall Offline
9
November 16, 2009 - 9:02 pm
sp_Permalink sp_Print

Carol,
Your method is practically word for word what I have been trying to do. My example is from the Dallas Mavericks calendar. I made it through the same procedures you did till I got to the step that tells you to locate the file you saved (to desktop). I find the file (it is saved as an Excel .csv file) and highlight that. The next box that opens is one where you are supposed to pick where you want this file to go. My problem is that in this step the box is blank and gives me 0 choices. I have done this before with an machine running XP and not had any problems. I am running Vista and that is problem enough. I did check to make sure my regional time settings are corresponsding with the desired choice of MM:DD:YYYY. Verified that multilple times but to no avail. Any suggestions on what to do in this Vista mode??????????????

Avatar
Carol Bratt
Mod
Forum Posts: 66
Member Since:
August 11, 2011
sp_UserOfflineSmall Offline
10
November 21, 2009 - 12:46 pm
sp_Permalink sp_Print

Soledad,

Youa re not using a Windows operating system? That his the only difference between the steps that you and I are taking. You are selecting DOS and I am selecting Windows. Please post back here and let us know what operating system you are using. That will be very helpful.

Avatar
soldat
Member
Forum Posts: 93
Member Since:
October 6, 2008
sp_UserOfflineSmall Offline
11
November 29, 2009 - 7:21 pm
sp_Permalink sp_Print

I am running Windows Vista and have office ver. 2003. I have tried both versions to use in importing the file ---- DOS and Windows but both give the same results when you get to the window where it asks you to identify the file you want to import to---------- the box is blank and it should show the calendar as a choice.

Avatar
David Hartsock
Admin
Forum Posts: 1105
Member Since:
August 7, 2011
sp_UserOfflineSmall Offline
12
November 30, 2009 - 7:27 am
sp_Permalink sp_Print

I'll throw my .02 cents in here.

I'm guessing you did a custom install of Office during which you selected the options to install, OR you chose a Typical installation. My guess is the installation method (typical or just checking the boxes next to the applications) you chose did not install the option you need to complete this process. There are quite a few options available during installation that are only presented during a custom installation.

If you attempt to uninstall Office you are presented with a screen that allows you to modify the installation. I would go that route and right click on everything and choose "Run from my Computer". All of the options are very small compared to the main applications, so you won't be eating a lot of disk space. I don't have a computer with 2003 on it so I can't look and see if there is any specific options that stand out. Heck, I couldn't even find a decent screen shot on the web!

If you and Carol are both trying to accomplish this in (basically) the same method that is the only cause that stands out to me!

Avatar
soldat
Member
Forum Posts: 93
Member Since:
October 6, 2008
sp_UserOfflineSmall Offline
13
December 2, 2009 - 12:53 pm
sp_Permalink sp_Print

I do remember the process followed during that time of installation and I let the program use the default choice which was not a custom install -- but loaded all the basic values. I will go back and and try the modified installation maybe this will have the option of "repair" ---- don't know for sure but will try that if possible. Ironic thing is I went to one college web site and their football schedule for download was packaged as a .csv (dos) file. That worked perfectly without problem. The ones of .csv (Word) model is where I have this particular problem.

Avatar
David Hartsock
Admin
Forum Posts: 1105
Member Since:
August 7, 2011
sp_UserOfflineSmall Offline
14
December 2, 2009 - 7:27 pm
sp_Permalink sp_Print

If you look deep in the installation tree, under tools I think, there are quite a few converters and such. I always do a complete install - Run all from my computer. The disk space is negligible and who knows what file or strange combo you're going to run across later.

Avatar
soldat
Member
Forum Posts: 93
Member Since:
October 6, 2008
sp_UserOfflineSmall Offline
15
December 8, 2009 - 2:24 pm
sp_Permalink sp_Print

OK --- trying a complete install --- I have my original 2003 disk. Now, before jumping into that:
1. Since I will be overlaying a new installation ontop of the program that is already there, do I need to save my contacts, favorites, etc. to a pen drive just in case those get wiped out in the process. Seems to be the safe thing to do.
2. OR --- do I need to delete the complete file before doing a new installation?

Many thanks.

Forum Timezone: America/Indiana/Indianapolis

Most Users Ever Online: 188

Currently Online:
10 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Member Stats:

Guest Posters: 10

Members: 1273

Moderators: 3

Admins: 4

Forum Stats:

Groups: 8

Forums: 19

Topics: 1538

Posts: 11824

Administrators: Jim Hillier, Richard Pedersen, David Hartsock, Marc Thomas

Moderators: Judy Novotny, Jason Shuffield, Mail Poet