Is it be possible to interact with alfresco solr using Sarnia? Has anyone tried it?

CommentFileSizeAuthor
#4 Screen Shot 2017-04-11 at 10.41.54 PM.png91.26 KBpicacsso
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

picacsso created an issue. See original summary.

picacsso’s picture

picacsso CreditAttribution: picacsso commented

I'm able to connect to the alfresco solr instance, but getting a schema.xml mismatch error on save. Do the schemas have to match? I can see the fields but im not sure what I'm missing.

picacsso’s picture

picacsso CreditAttribution: picacsso commented

i have setup my view and see all the fields, but I'm not sure why i can't see any data. Here's one of the records from my sarnia view and they all look like this. No data from the alfresco solr core is being returned:

Id: _DEFAULT_!8000000000000007!ACL

content@s___t@{http://www.alfresco.org/model/content/1.0}content:

content@s__lt@{http://www.alfresco.org/model/content/1.0}content:

suggest:

text@s___t@{http://www.alfresco.org/model/content/1.0}author:

text@s___t@{http://www.alfresco.org/model/content/1.0}creator:

text@s___t@{http://www.alfresco.org/model/content/1.0}email:

text@s___t@{http://www.alfresco.org/model/content/1.0}firstName:

text@s___t@{http://www.alfresco.org/model/content/1.0}owner:

picacsso’s picture

picacsso CreditAttribution: picacsso commented
FileSize
Screen Shot 2017-04-11 at 10.41.54 PM.png91.26 KB
jmdeleon’s picture

jmdeleon CreditAttribution: jmdeleon commented

Regarding the schema mismatch error: On the properties page for the Solr server you are connecting to with Sarnia, under the Advanced section, make sure "Skip schema verification" is UN-checked. That should remove the error message.

Regarding the results you are receiving in the Views: What kind of information were you hoping to display from inside of the Alfresco Solr index? I've worked on a few occasions with Alfresco, and there isn't any really any data that would be directly useful to the end-user to display, from directly out of the Solr index, as Sarnia would allow you to do from Drupal. It's a situation similar to using Sarnia to display the Drupal schema.xml -- the data in most Solr indices for content-management systems (as described by their schema.xml files) contains fields that are designed to faciltate complex full-text search, and the data in those indexes is rarely meant to be displayed to the end user.

jmdeleon’s picture

jmdeleon CreditAttribution: jmdeleon commented
Status: Active » Closed (won't fix)
picacsso’s picture

picacsso CreditAttribution: picacsso commented

Thanks for the swift response. What im trying to get out of alfrescos solr are the document title, mimetype, and noderefs, for now.

This is possible via CMIS or writing custom alfresco webscripts, but Id like the ability to retrieve and query alfresco solr from drupal search api directly, in order to produce a unified search experience where a user enters a search term and the results are returned from both drupal solr and alfresco solr at the same time.

This module is pretty cool and works as expected. I just need to figure out how to get to the fields and values i need from alfresco to show in my view.

And im not really sure if the way im approaching this is even valid.

Any suggestions/pointers are highly appreciated.