Lotus Geek :: Updated NOTESurvey Central database

« Blogsphere - Delete "Fake" Responses agent | Main| Update to the ND7.0.1 DbColumn/DbLookup 64K limit bug... »

Updated NOTESurvey Central database

Category Technical
Bookmark :

When I wrote the example database for my Practical DXL session I wrote it to work with Notes 6.5 and Notes 7. Well, the LotusScript was fine - but the DXL tags I had in the generated DXL weren't.

My bad.

Lou Capozzoli of Ernst & Young helped me GREATLY in figuring out what tags didn't work and then modifying the code so it runs in Notes 6.x and above.

You can download the updated database from my downloads area.

Thanks again, Lou - I really appreciate your help.

Rock
**Fun is a good thing but only when it spoils nothing better. - George Santayana

Posted by Rocky Oliver On 02/09/2006 | Digg This | Permalink

Comments

1 - I know this sounds daft, but I'm a little lost with this db.

I've created a survey, I've created questions, but how do I actually share the pretty GUI with the userbase I wish to survey?

Posted by Brett At 09:21:42 AM On 05/11/2006 | - Website - |

2 - Hi friends.
I have similar problem, when I try to create Document into a database using DXL import.
<DXLImporterLog>
<error>Invalid unid (universal ID) value: </error>
<error>DXL importer operation failed</error>
</DXLImporterLog>

My dxl file is valid, but doesn't contain UNID value. Of course, my document isn't created, I don't known it's UNID. When I tried mimic UNID with 32 character hexa string, obtained the same result. My code for import contain this settings before calling importer. process() :
.
.
.
Set importer = session.CreateDXLImporter(stream, dbCurrent)
importer.DocumentImportOption = L_DXLIMPORTOPTION_REPLACE_ELSE_CREATE
importer.InputValidationOption = 0 'VALIDATE_NEVER
importer.ReplicaRequiredForReplaceOrUpdate = False
Call importer.process()
Call stream.Close()

Could somebody help me wit this error?

Posted by Tomas At 12:52:05 PM On 10/07/2006 | - Website - |

3 - Rocky,
I don't know if it's just me or just firefox or something, but when I click on any of your downloads, I get the following message:

Blog Error Detected.

A general error has occured While trying to find that page that you have requested. If you feel that this is a serious error then please contact the sites owner.

Error : HTTP Web Server: Lotus Notes Exception - Special database object cannot be located

Posted by Jackie Horowitz At 05:28:10 PM On 02/09/2006 | - Website - |

4 - @Scott - that sounds like the XML doc didn't get generated correctly. How did you try to create the survey? Did you compose a new Summary, save it and then compose some Questions? Then, did you select the Summary doc in the view, and run the GenerateSurvey agent?

If not, try that; if so, I'll need to see the database. ZIP it up and mail it to me (rock AT us DOT ibm DOT com).

Rock

Posted by Rock At 09:56:17 AM On 02/10/2006 | - Website - |

5 - @Jackie - WOOHOO!!!

Glad to hear it!

@Everyone - I hope you guys enjoy it. Please let me know sometime how you use it, any enhancements you make to it, etc. - I love to hear that type of stuff!

Rock

Posted by Rock At 03:36:17 PM On 02/10/2006 | - Website - |

6 - OK, found the issue after Scott sent me his db. I missed a "renderpassthrough" tag in the subform when updating my template - and Scott caught it. I have since updated the db (it is now ver1.3) - please download it and give it a test.

Thanks!

Rock

Posted by Rock At 11:01:32 AM On 02/10/2006 | - Website - |

7 - Jens,

Yes I am but what I need to do is build an img tag from an action button into a rich text field & this way will give me a handle to the name of the file being attached.

Thanks though!

Posted by Lou At 06:14:43 PM On 02/11/2006 | - Website - |

8 - Hi All -- OK, I found a fix for the problem that people using earlier versions of Firefox were experiencing. It should work now - give it a try.

Enjoy!

Rock

Posted by Rock At 10:56:42 PM On 02/09/2006 | - Website - |

9 - Rocky,

Thanks for the great info. I am trying to use the database and click on the GenerateSurvey action and get the following error message:

DXL importer operation failed
<?xml version = '1.0'>
<DXLImporterLog>
<fatalerror line='2' column='1'>The main XML document cannot be empty</fatalerror>
<error>DXL importer operation failed</error>
</DXLImporterLog>
[line: 42 in IMPORTDXL][line: 18 in IMPORTSURVEYELEMENT]
(err: 4522, erl: 44)

Not sure if this is a set-up or configuration problem. Any ideas?

Thanks

Posted by Scott At 09:45:16 AM On 02/10/2006 | - Website - |

10 - Rocky,

Remember the other process we were talking about? It was to create an image resource element on the fly from a local file. I have some functional code I'm working on for it. Where would you recommend I post something like that once I finish a few things? The sandbox? openNTF? somewhere else?

Lou

Posted by Lou Capozzoli At 01:22:10 AM On 02/11/2006 | - Website - |

11 - Oh guys.
I solved my problem. I simply removed this line
...
<noteinfo noteid="" unid=""/>
...
from my imported file. No error mesage occurs.

Posted by Tomas At 07:35:49 AM On 10/08/2006 | - Website - |

12 - Lou, you are aware, that this functionality is in the client since N6? If you are editing a RichText field, you are able to use "Create - Image Resource" from the menu

Posted by Jens At 03:49:54 AM On 02/11/2006 | - Website - |

13 - Being a fellow geek, this was a blast for me. Glad I could help!

Lou

Posted by Lou Capozzoli At 04:13:06 PM On 02/09/2006 | - Website - |

14 - Jackie - there is a bug in the earlier versions of Firefox that causes that. Upgrade to Firefox 1.5 or above, and it should work fine. It works in Firefox 1.5 and greater, IE, etc.

Rock

Posted by Rock At 05:35:16 PM On 02/09/2006 | - Website - |

15 - @Lou - I think that OpenNTF's Code Bin would be a great place to put this code. You can access it here:

http://www.openntf.org/projects/codebin/codebin.nsf

Enjoy!

Rock

Posted by Rock At 07:26:54 PM On 02/11/2006 | - Website - |

16 - I just downloaded the latest version and it worked just fine. Thanks, Rock!

Posted by Jackie Horowitz At 02:28:29 PM On 02/10/2006 | - Website - |