Hey everyone.

I've found out about ExamineDB today, which is exactly what I need for a project I'm working on. I have set everything up, have no errors and the index is built but it's always empty.

On my ExamineSettings.config file I have added the following for the Index Provider:

<add name="SageProductsIndexer" type="ExamineDB.Indexers.DBIndexer, ExamineDB"
    indexSet="SageProductsIndexSet"
    nodeType="SageProducts"
    connectionStringName="umbracoDbDSN"
    sql="SELECT ItemID, Description, Barcode FROM dbo.SAGE_Item"
    singleRecordSQL = "SELECT ItemID, Description, Barcode FROM dbo.Sage_Item WHERE ItemID = '@0'"
    primaryKeyField = "ItemID"/>

And the following for the Searcher:

<add name="SageProductsSearcher" type="UmbracoExamine.UmbracoExamineSearcher, UmbracoExamine" indexSet="SageProductsIndexSet" />

As for the IndexSet, in the ExamineIndex.config file:

<IndexSet SetName="SageProductsIndexSet" IndexPath="~/App_Data/TEMP/ExamineIndexes/SageProducts/" />

Like I said, I have no errors. I have installed the ExamineDB Tool as well and I am able to build/rebuild the index.

The thing is: it's always empty.

The table has more columns than the ones presented. I am adding them here just for your reference:

ItemID  nvarchar(25)
Description nvarchar(255)
Barcode varchar(50)
GrossWeight float
FamilyID    int
Active  tinyint
Slug    varchar(255)

Any ideas?

Thank you all in advance.