 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / December 2006Document properties
Hi, In Office documents for example, you have document properties like Doc_Author, or other properties that may have been created by the user who wrote the doc. In SQL Server 2005, it is possible to search into these properties (equivalent of Index Server ALL property). But is there any way to get the list of properties with their values ? Meaning to know that the value has been found in one property rather than in another ? Is there any difference if I use Sharepoint, Services or Portal ? My problem is that I'm using not only Office iFilter with document properties, but two other iFilters that I created for indexing PDF and another format specific to my company, with Index Server. Both these iFilters manage document properties, including possibility to create custom properties... Looks like I will have to do some programming... Many thanks in advance I believe it is possible in Sharepoint Portal services but not WSS. It is not possible in SQL FTS. You can use filtdump to show the properties emitted and their values.  SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Hi, > [quoted text clipped - 18 lines] > > Many thanks in advance Can somebody point me to where I can learn how to query the properties of files stored in an image field. I'm having troubles finding that documentation. I'm using SQL 2005. > Hi, > [quoted text clipped - 18 lines] > > Many thanks in advance Hello, Its not possible. Simon Sabin SQL Server MVP http://sqlblogcasts.com/blogs/simons > Can somebody point me to where I can learn how to query the properties > of files stored in an image field. I'm having troubles finding that [quoted text clipped - 22 lines] >> >> Many thanks in advance So Larry was mistaken? "In SQL Server 2005, it is possible to search into these properties (equivalent of Index Server ALL property)." It is possible to search on properties which are embedded in the document and accessible through the iFilter-for example the summary properties in office documents. For some documents, i.e. some pdf properties they are actually stored in the file system and when you push them into the database they remain in the file system and don't travel with the document itself. The best way to see this is to put a value for the keyword metatag of an html,. store it in an image datatype column and then search on the keyword value. You will get a hit. SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > So Larry was mistaken? > > "In SQL Server 2005, it is possible to search into these properties > (equivalent of Index Server ALL property)." You can query them if they are emitted by the iFilter. The best way to determine if they are emitted is to run them through filtdump accessible from the platform sdk. SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Can somebody point me to where I can learn how to query the properties > of files stored in an image field. I'm having troubles finding that [quoted text clipped - 25 lines] >> >> Many thanks in advance Hello Hilary, But you can't do search for a specific value in a specific property, like you can with index server Simon Sabin SQL Server MVP http://sqlblogcasts.com/blogs/simons > You can query them if they are emitted by the iFilter. The best way to > determine if they are emitted is to run them through filtdump [quoted text clipped - 33 lines] >>> >>> Many thanks in advance Hi Simon Yes, the only one which is respected is the language property. SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Hello Hilary, > [quoted text clipped - 42 lines] >>>> >>>> Many thanks in advance Hello Hilary, Which is a real shame Simon Sabin SQL Server MVP http://sqlblogcasts.com/blogs/simons > Hi Simon > [quoted text clipped - 49 lines] >>>>> Looks like I will have to do some programming... >>>>> Many thanks in advance Hello - yes it is, but they need to do this for scalability. The more data you store in your index the less scalable it becomes. The sweet spot exists somewhere between 1 to 10 million rows and after that you need to start throwing machines at it. On one multi-terabyte site I worked on they had 100 search index machines to achieve the response they needed. SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Hello Hilary, > [quoted text clipped - 57 lines] >>>>>> Looks like I will have to do some programming... >>>>>> Many thanks in advance |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.