Forums - View Thread - Problem Importing

Welcome Guest | Login

Index | Recent Threads | Register |

Forums » List all forums » Forum: Discussion Forums » Thread: Problem Importing

Quick Go »

Thread Status: Normal
Total posts in this thread: 5

[Change thread status] [Delete this Thread] [Move this Thread]
[Add To My Favorites] [Watch this Thread] [Post new Thread]

Author

This topic has been viewed 185 times and has 4 replies

soces
New Member

Joined: Mar 30, 2007
Posts: 3
Status: Offline

Problem Importing	Reply to this Post Reply with Quote
	[Delete this Thread]

Hello,
I am getting a :

Oops !

We encountered an error while trying to process your request.
Our system administrator has been notifed.

message whenever I try to import into localender. Do you know what the problem can be?

Thanks!

[Jul 20, 2007, 2:11:28 PM] [204.108.96.18]

[Link]

support
localendar Expert

Joined: Aug 9, 2022
Posts: 6439
Status: Offline

Re: Problem Importing	Reply to this Post Reply with Quote
	[Delete this Post]

I take it you are able to display the "Import Calendar Data" page itself with no issues and the error message you report is displayed after you click "upload file"?

If possible, would you mind pasting the first several lines from that file into this thread?

Also, what version of Outlook are you using?
----------------------------------------
Marc Higgins
Support Associate, localendar.com
Follow us on Twitter! http://www.twitter.com/localendar_news

[Jul 23, 2007, 9:52:15 AM] [171.159.192.10]

[Link]

soces
New Member

Joined: Mar 30, 2007
Posts: 3
Status: Offline

Re: Problem Importing	Reply to this Post Reply with Quote
	[Delete this Post]

I take it you are able to display the "Import Calendar Data" page itself with no issues and the error message you report is displayed after you click "upload file"?

This is correct.

If possible, would you mind pasting the first several lines from that file into this thread?

Doesnt look pretty, but here it is:

Subject,Start Date,Start Time,End Date,End Time,All Day Event,Description
"FALSE ""Labor Day""",9/3/2007,8:00 AM,9/3/2007,8:00 AM,TRUE,School Holiday - No School
"FALSE ""First Day of School""",9/5/2007,7:56 AM,9/5/2007,3:03 PM,FALSE,7:56 a.m. - 3:03 p.m.
"FALSE ""Periods 1 - 6 will meet""",9/5/2007,8:00 AM,9/5/2007,3:00 PM,TRUE,
"FALSE ""Periods 1 - 6 will meet""",9/6/2007,8:00 AM,9/6/2007,3:00 PM,TRUE,

Also, what version of Outlook are you using?

We are using excel and saving as a .csv.

[Jul 27, 2007, 1:22:17 PM] [204.108.96.18]

[Link]

soces
New Member

Joined: Mar 30, 2007
Posts: 3
Status: Offline

Re: Problem Importing	Reply to this Post Reply with Quote
	[Delete this Post]

I think the problem could be that excel adds quotes when you save as a .csv.

The field: FALSE "Labor Day"
becomes: "FALSE ""Labor Day""

Is there some way to avoid this when saving from excel?

[Jul 27, 2007, 1:25:40 PM] [204.108.96.18]

[Link]

support
localendar Expert

Joined: Aug 9, 2022
Posts: 6439
Status: Offline

Re: Problem Importing	Reply to this Post Reply with Quote
	[Delete this Post]

The format is also not quite correct. Please see
http://www.localendar.com/sample.csv

for the correct format.

FALSE "Labor Day" should be two fields, not one. The fields are not in the same order as the corresponding header row.

The multiple quotes will be an issue. Each field should be quoted, but not multiple times. This only seems to happen for the first field - but if you do have 2 items in the first column mistakenly, that might be the cause.

I'm a little concerned that Excel doesn't seem to be using quite the same CSV format as Outlook, but the first item to worry about is the FALSE "Labor Day" combination
----------------------------------------
Marc Higgins
Support Associate, localendar.com
Follow us on Twitter! http://www.twitter.com/localendar_news

[Aug 3, 2007, 10:20:32 PM] [68.198.252.134]

[Link]

[Show Thread Printable Version] [Post new Thread]