5 pts.
 Lotus Notes Import
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

Software/Hardware used:
ASKED: November 29, 2007  8:05 PM
UPDATED: December 17, 2007  3:07 PM

Answer Wiki:
<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.
Last Wiki Answer Submitted:  December 17, 2007  3:07 pm  by  Ric Helton   30 pts.
All Answer Wiki Contributors:  Ric Helton   30 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _