在SharePoint中做我想在Access中做的事情 [英] Doing in SharePoint what I thought I wanted to do in Access

问题描述

我试图建立一个系统来帮助基于先前相似/相关提案的提案撰写加速.我设想了一个Access db，该数据库将用< b> b段落/i</b>填充.来自多个文档和一个查询 允许用户粘贴来自RFP的段落的字段.通过复杂的单词评分和标记词查询的向导，将向用户显示过去提案中与RFP段落中使用的语言最匹配的段落. 每当我与同事谈论我在Access中遇到的一些挑战时，他们总是建议开发这种系统".在SharePoint中.所以，你同意吗?

I was attempting to build a system to help speed up proposal writing based on previous similar/related proposals. I envisioned an Access db that would be populated with the <i><b>paragraphs</i></b> from multiple documents and a query field that would allow a user to paste in a paragraph from an RFP. Through the wizardry of a complicated word scoring and tag word query the user would be presented with paragraphs from past proposals that best match the language used in the RFP paragraph.  Every time I talked to a colleague about some of the challenges I was having in Access they always suggested developing this "system" in SharePoint.  So, do you agree?

我曾尝试使用SharePoint搜索我们的提案存储库，其中包含少量(3-6)个关键字/标签词，但是结果并不是很有帮助，因为搜索存储库中整个文档中的单词的搜索关键字相对于退回文件 与查询字词最匹配的段落.

I have tried using SharePoint to search our proposal repository with a small number (3-6) of key/tag words but the results aren't very helpful because the search keys on words throughout the documents in the repository as opposed to returning documents with paragraphs that best match the query terms.

建议?

谢谢

Clayton

推荐答案

在您的情况下，您希望从PC-的行和列过渡基于RDBMS到互联网内容管理的自由形式世界.这是一个跳跃，需要思维方式的转变.我想您已经意识到了这一点，并且 试图接受这一点，但结果却不理想.

In your case, you're looking to transition from the rows and columns of a PC-based RDBMS to the freeform world of internet content management. It's a jump, and requires a thought paradigm shift. I think you're aware of this, and have attempted to embrace this, with unfavorable results.

我的去"类是SharePoint是一艘游轮.它具有任何人可能需要或想要的一切，并且可以用有趣和令人惊奇的东西进行定制，以吸引群众参加数周的维持生命和振兴精神的活动. 如果您只是想去滑水...它会失败，因为它是正确的船只.

My 'go to' analogy is that SharePoint is a Cruise Ship. It has everything anyone could ever need or want, and can be customized with fun and amazing things to captivate the masses for weeks of life-sustaining and soul-rejuvenating activities. But, if you just want to go Water Skiing... it fails as the proper vessel.

Access是一个很棒的，简单的关系数据库引擎，但是它没有良好的互联网技能. (我认为这些是您要解决的某些问题的基础.)
SharePoint是一个很好的，复杂的，基于Internet平台的内容管理系统，但是它没有任何实际的关系数据库引擎技能. (您可以伪造它并进行黑客模拟).

Access is a GREAT, simple relational database engine, but it doesn't have good internet skillz. (I assume these are the basis of some of the issues for which you struggle.)
SharePoint is a great, complex Content Management System on an internet platform, but it doesn't have any real relational database engine skillz. (You can fake it and make hacks to simulate.)

在SharePoint中，您可以实施整个企业范围的整体分类法，以制作高度自定义的搜索应用程序.可以采用数据库式编程来实现REST，SOAP，KQL，CAML，OData等. al.这样你 可以执行少量的关系"操作.操作.

In SharePoint, you can implement an Enterprise-wide monolithic Taxonomy for making a highly customized search application. Database-esque programming can be employed to implement REST, SOAP, KQL, CAML, OData, etc, et. al. such that you can perform a modicum of "Relational" operations.

我拥有更多的行和列类型，如果我要在SharePoint中进行操作，则不会考虑建立分类法，也不会想出一种方法来使用分类法中内容的关键字填充分类法文件.我认为SharePoint可以做一些索引 基于文档中的内容，但专门针对目标似乎更明智.我想说说搜索抓取实际上是如何工作的，然后您将了解实现分类法和建立索引所需要爬的那座山.

I'm more of the rows and columns type, and if I was going to do it in SharePoint, I wouldn't look into building the taxonomy, and figuring out a way to populate it with keywords from the content inside the documents. I think that SharePoint can do some indexing based on the content inside of the documents, but it seems smarter to specifically target. I'd say read up on how the Search Crawl actually works, and then you'll understand the mountain you'll need to climb to implement Taxonomies and build indexes.

但是，当您只想在浮船旁边钓鱼时，所有这些都可能是Cruise Shippy. :D

But, all of this may be too Cruise Shippy, when you really just want to fish of the side of a pontoon boat. :D

这篇关于在SharePoint中做我想在Access中做的事情的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！