Need a little testing help

I have run into an issue with the ASND Export Facility and Office 2007 and need a little assistance confirming the problem.  If you look at this discussion response, you will see the problem that Jan is running into.  What I need from a few members of the audience playing along at home is the following:

  1. I need computers with the following combinations of software:
    Notes 7.0.x and Office 2003
    Notes 6.5.x and Office 2007
    Notes 7.0.x and Office 2007
  2. Download the latest release of the Export Facility (1.2 RC).
  3. Create an export/report against a database that has zero-leading numbers stored as text, like id numbers or zip codes.
  4. Set the Export format to be Excel.
  5. Add that field as a column to an export and set the data type as text.
  6. Run the export.

If it works like it does on my work machine (Noes 6.5.x and Office 2003), Excel should show the leading zeros in the column and flag you to let you know that it's a number stored as text.  You can either send me an email/IM with your results or, better yet, leave a comment.

<< Previous Document / Next Document >>
  • 1) Works as you expected - Ted Hardenburgh
    Created 8/23/2007 12:53:44 PM email | website

    Tested with Notes 7.0.2 and Office 2003 and it exported the leading zeros as you saw in your test with Notes 6.5 and Office 2003. Also got the number stored as text message.

    Great app - I used it last year to help generate user registration files when we added thousands of users in a few months.

  • 2) Problem found - Sean Burgess
    Created 9/9/2007 3:39:04 PM email | website

    Through some testing by another user, we determined the problem had to do with the German version of Office. It seems that the word "General" was replaced with "Standard" in certain versions of Excel. Hopefully, I will be able to find out the exact circumstances that cause the problems and work around them.


Discussion for this entry is now closed.