This forum requires Javascript to be enabled for posting content
Log In
Please consider registering
Guest
Forum Scope


Match



Forum Options



Min search length: 3 characters / Max search length: 84 characters
Register Lost password?
Importing a schedule to Outlook calendar
soldat
93 Posts
(Offline)
1
September 6, 2009 - 10:13 pm

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.

Jim Hillier
2700 Posts
(Offline)
2
September 8, 2009 - 3:59 pm

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

soldat
93 Posts
(Offline)
3
September 8, 2009 - 5:05 pm

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.

Chad Johnson
867 Posts
(Offline)
4
September 9, 2009 - 9:07 am

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.

soldat
93 Posts
(Offline)
5
September 9, 2009 - 4:31 pm

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.

Chad Johnson
867 Posts
(Offline)
6
September 10, 2009 - 9:24 am

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

Carol Bratt
67 Posts
(Offline)
7
September 10, 2009 - 9:39 pm

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!

Carol Bratt
67 Posts
(Offline)
8
September 13, 2009 - 2:27 pm

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!

soldat
93 Posts
(Offline)
9
November 16, 2009 - 9:02 pm

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??????????????

Carol Bratt
67 Posts
(Offline)
10
November 21, 2009 - 12:46 pm

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.

soldat
93 Posts
(Offline)
11
November 29, 2009 - 7:21 pm

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.

David Hartsock
1117 Posts
(Offline)
12
November 30, 2009 - 7:27 am

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!

soldat
93 Posts
(Offline)
13
December 2, 2009 - 12:53 pm

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.

David Hartsock
1117 Posts
(Offline)
14
December 2, 2009 - 7:27 pm

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.

soldat
93 Posts
(Offline)
15
December 8, 2009 - 2:24 pm

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
All RSSShow Stats
Administrators:
Jim Hillier
Richard Pedersen
David Hartsock
Moderators:
Carol Bratt
dandl
Jason Shuffield
Jim Canfield
Terry Hollett
Stuart Berg
John Durso
Top Posters:
Chad Johnson: 867
Mindblower: 666
carbonterry2: 356
Flying Dutchman: 278
grr: 211
Newest Members:
blutsband
cyberguy
JudeLandry
benjaminlouis680309
drogers97439
Forum Stats:
Groups: 8
Forums: 20
Topics: 1942
Posts: 13522

 

Member Stats:
Guest Posters: 11
Members: 3179
Moderators: 7
Admins: 3
Most Users Ever Online: 2303
Currently Online:
Guest(s) 34
Currently Browsing this Page:
1 Guest(s)
Exit mobile version

WHY NOT SUBSCRIBE TO OUR NEWSLETTER?

Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!