数据库条目存储在一个列表中,您可以在 Excel 或 Microsoft Access 中打开该列表。我相信您也可以通过编程方式访问此数据,但您可能需要 MOSS 才能通过直接 MS SQL 访问它。
奖励:基于逻辑的问题跳过(例如:如果您对 15 的回答是“是”,请问为什么)
我不记得逻辑是否是现成内置的,但您应该能够使用 SharePoint Designer 或 Visual Studio 创建基于逻辑的调查。
关于 Windows Sharepoint Services (WSS) 和 Microsoft Office SharePoint Server 2007 (MOSS) 之间差异的快速说明:
WSS 是“轻量级”版本的 SharePoint,但仍提供其大部分功能。
WSS 3.0 随 Windows Server 2008 免费提供,并且可以随 Windows Server 2003 免费设置。
如果您的客户端已安装 Windows Server,SharePoint 可能是一个不错的选择,因为它与 Active Directory 紧密集成。
我在 WSS 的外部安装上使用了 WSS 中的调查功能,对我们的销售团队进行了内部调查,效果非常好。完成后我使用 MS Access 查询数据并向管理层提供清晰的报告。
MOSS 是 SharePoint 的大型企业产品。
MOSS 更多地针对大型企业客户,对于您尝试构建的表单或调查类型来说很可能是不必要的。
但是,如果您与大客户合作,他们可能已经安装了 MOSS。
NOTE: This will not answer your question directly (i.e. a full suite of tools available purely in C# or VB.NET), but it's a possible alternative that may suit your needs if your client has the resources available.
You may consider using Windows SharePoint Services (soon to be called SharePoint Foundation in 2010) as a platform for building and delivering surveys. SharePoint has rich survey functionality built-in, and with the ability to create custom web-parts using Visual Studio, you should be able to acheive your logic-based goal.
Regarding your core requirements:
Ability to generate surveys with a list of questions on the fly
You can decide who is allowed to create surveys and how they are presented internally to users. You can choose lots of options, such as whether their answers are submitted publicly or anonymously.
SharePoint has several answer type choices available.
Users can fill out survey online
By default, SharePoint is "online." However, it's best suited for a corporate intranet, though it can certainly be exposed as an extranet website as well.
Results are emailed to an address, or saved to a database, or both
A SharePoint user can be set up to be alerted every time a survey is filled out.
You can create custom alerts that hide/show what fields are in the alert message.
The database entries are stored in a list, which you can open in Excel or Microsoft Access. I believe you can access this data programmatically as well, but you might need MOSS to access it via straight MS SQL.
Bonus: Logic-based question skipping (ex: if you answered yes to 15, ask why)
I can't remember if logic is built-in out-of-the-box, but you should be able to create a logic-based survey using SharePoint Designer or Visual Studio.
A quick note on the difference between Windows Sharepoint Services (WSS) and Microsoft Office SharePoint Server 2007 (MOSS):
WSS is the "lightweight" version of SharePoint, but still offers most of its functionality.
WSS 3.0 comes free with Windows Server 2008 and can be set up free with Windows Server 2003.
If your client already has a Windows Server installation, SharePoint can be a great option since it integrates tightly with active directory.
I've used the survey feature in WSS on an external installation of WSS to do an internal survey of our sales team, and it was great. I used MS Access to query the data after it was done and present a clearn report to management.
MOSS is the big enterprise offering for SharePoint.
MOSS is targeted more towards big enterprise customers and is most likely unnecessary for the type of form or survey you are trying to build.
However, if you're working with a big client, they may already have MOSS installed.
发布评论
评论(3)
也许预构建的解决方案就足够了,让您无需进行任何编程?
例如,SurveyMonkey
Perhaps a pre-built solution will suffice and save you from having to do any programming at all?
For example, SurveyMonkey
注意:这不会直接回答您的问题(即纯粹用 C# 或 VB.NET 提供的全套工具),但如果您的客户有可用的资源,它是可能满足您需求的替代方案。 >
您可以考虑使用Windows SharePoint Services(2010 年即将更名为 SharePoint Foundation)作为构建和提供调查的平台。 SharePoint 具有丰富的内置调查功能,并且能够使用 Visual Studio 创建自定义 Web 部件,您应该能够实现基于逻辑的目标。
关于您的核心要求:
关于 Windows Sharepoint Services (WSS) 和 Microsoft Office SharePoint Server 2007 (MOSS) 之间差异的快速说明:
NOTE: This will not answer your question directly (i.e. a full suite of tools available purely in C# or VB.NET), but it's a possible alternative that may suit your needs if your client has the resources available.
You may consider using Windows SharePoint Services (soon to be called SharePoint Foundation in 2010) as a platform for building and delivering surveys. SharePoint has rich survey functionality built-in, and with the ability to create custom web-parts using Visual Studio, you should be able to acheive your logic-based goal.
Regarding your core requirements:
A quick note on the difference between Windows Sharepoint Services (WSS) and Microsoft Office SharePoint Server 2007 (MOSS):
尝试 http://www.surveyproject.info 上的调查项目,获取编写的免费开源调查和表单引擎框架在 ASP.NET 和 C# 中。
下载和来源位于 http://survey.codeplex.com
还提供演示站点。
Try the Survey Project at http://www.surveyproject.info for a free open source survey and form engine framework written in ASP.NET and C#.
Downloads and sources at http://survey.codeplex.com
A demosite is available as well.