Lotus Notes Import

5 pts.
Tags:
Lotus Notes
Lotus Notes 6.x
Microsoft Excel
I am using Lotus Notes 6.5 and I have an Excel spreadsheet that I have saved as a 123 (.wk4) file. In Lotus Notes I imported the file using File Import. I then used the following critera: Import as: Main Document Using form: To Do Defined by the WKS title: this is turned on WKS Range name: this is null Calculate fields on form during document import: this is turned on Everything seems to import fine but the views do not display the due date
ASKED: November 29, 2007  8:05 PM
UPDATED: December 17, 2007  3:07 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

<i>Everything seems to import fine but the views do not display the due date </i>

If I understand your question correctly, the problem may be in the hidden <b>formatting on the DueDate column in Excel.</b> Instead of being formatted as a ‘date’ it may have a ‘custom format’ that Notes does not recognize on import as a date.

I import Excel to Lotus Notes files every day and some of the Excel files I use come from a database app written in Access where the developer used the “Format()” command on the data being exported to build the date using a text string, such as: <pre>Format(DueDate,”mm/dd/yyyy”)</pre> While that may make it look attractive to his users <i>(at least the ones in the US where they use m/d/y — I bet the Europeans have to look twice!)</i> it renders those cells in Excel with ‘custom formatting’ instead of a ‘date’ type. I have to change the format type prior to import for Notes to recognize it as a date.

<b>Try this: </b>Before your import, open the Excel file, select the DueDate column, hit ‘control-1′ to format cells, look at the ‘Numbers’ tab (first one) and change the ‘Category’ to a date (the first choice is usually okay) and save the file. Try your import again just as you described above and see if it picks up the DueDate.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following