Log in
Linked Applications
Loading…
Spaces
Glossaries
Create
Create
Hit enter to search
Announcement Banner
Help
Online Help
Keyboard Shortcuts
Feed Builder
What’s new
Available Gadgets
About Confluence
Log in
Cash Collection Wiki
Pages
Cash Collection Wiki Home
Sinequa Technical Information
Sinequa Technical Information
search
attachments
weblink
advanced
image-effects
image-attributes
Paragraph
Paragraph
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Preformatted
Quote
Bold
Italic
Underline
Colour picker
More colours
Formatting
Strikethrough
Subscript
Superscript
Monospace
Clear formatting
Bullet list
Numbered list
Task list
Outdent
Indent
Align left
Align center
Align right
Page layout
Link
Table
Insert
Insert content
Files and images
Link
Markup
Horizontal rule
Task list
Date
Symbol
Insert macro
User mention
Jira Issue/Filter
Info
Add Lucidchart Diagram
draw.io Diagram
Embed draw.io Diagram
draw.io Board Diagram
Status
Gallery
Table of Contents
Google Drive Live Link
Embedded Google Drive Folder
Embedded Google Drive File
Google Drive Search Result
Other macros
Page layout
No layout
Two column (simple)
Two column (simple, left sidebar)
Two column (simple, right sidebar)
Three column (simple)
Two column
Two column (left sidebar)
Two column (right sidebar)
Three column
Three column (left and right sidebars)
Undo
Redo
Find/Replace
Keyboard shortcuts help
You are not logged in. Any changes you make will be marked as
anonymous
. You may want to
Log In
if you already have an account.
This page is also being edited by
. Your changes will be merged with theirs when you save.
<p style="text-align: left;"><br /></p><p style="text-align: left;"><a class="toc-link" style="">SSL for Sinequa's IIS</a></p><p style="text-align: left;"><br /></p><p style="text-align: left;"><img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3RvY30&locale=en_GB&version=2" data-macro-name="toc" data-macro-id="404401db-184c-450d-8784-f1c0ced5d116" role="button" tabindex="0" aria-haspopup="true" aria-label="toc macro" data-macro-schema-version="1"></p><p style="text-align: left;">This document describes how to use Sinequa and how Sinequa is configured.</p><h1 style="text-align: left;">What is Sinequa?</h1><hr style="text-align: left;" /><p style="text-align: left;">Sinequa is a global search engine for enterprise. It can index a lot of type of documents (Web, xECM, Google Drive, Aodocs, …).</p><h2 style="text-align: left;">The Sinequa Company</h2><hr style="text-align: left;" /><p style="text-align: left;">The Sinequa engine is ed by the Sinequa Company: <ins><span> </span><a href="http://www.sinequa.com/" style="">http://www.sinequa.com</a></ins></p><h2 style="text-align: left;">Sinequa documentation</h2><hr style="text-align: left;" /><p style="text-align: left;">You can find the documentation on this Web site:</p><p style="text-align: left;">URL: <ins><span> </span><a href="https://acew1psinesin01.eua.solvay.com/doc/en/Content/en.index.html" style="">https://acew1psinesin01.eua.solvay.com/doc/en/Content/en.index.html</a></ins></p><p style="text-align: left;">Documentation from Sinequa website:<span> </span><a class="" href="https://doc.sinequa.com/en.sinequa-es.v11/Content/en.index.html" style="">https://doc.sinequa.com/en.sinequa-es.v11/Content/en.index.html</a></p><p style="text-align: left;">Release Notes:<span> </span><a class="" href="https://download.sinequa.com/release-notes" style="">https://download.sinequa.com/release-notes</a></p><p style="text-align: left;">You can only access with the same credential used for the Sinequa Support portal.</p><h2 style="text-align: left;">Technology</h2><hr style="text-align: left;" /><p style="text-align: left;">Sinequa is a Windows application using IIS and .net framework. There is no databases server like SQL Server. Data are stored in files.</p><h2 style="text-align: left;">Version</h2><hr style="text-align: left;" /><p style="text-align: left;">The current version is the V<span style="color: rgb(102,102,102);">11.10.0.2123</span></p><p style="text-align: left;">To see the build number of the version go to the menu Global options in the administration interface.</p><h2 style="text-align: left;">Software download</h2><hr style="text-align: left;" /><p style="text-align: left;"><a class="" href="https://download.sinequa.com/home" style="">https://download.sinequa.com/home</a></p><p style="text-align: left;"><br /></p><p style="text-align: left;">login = lruault </p><p style="text-align: left;">pwd = Solvay2016</p><p style="text-align: left;"><br /></p><h2 style="text-align: left;">Architecture</h2><hr style="text-align: left;" /><p style="text-align: left;">On the same server, there is the indexing engine and the interface for searching.</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030248/2018-03-21_16h32_05.png?version=1&modificationDate=1521646387356&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/2018-03-21_16h32_05.png?version=1&modificationDate=1521646387356&api=v2"></p><h1 style="text-align: left;">Indexation process</h1><hr style="text-align: left;" /><p style="text-align: left;">The connector process browses all documents of the given collection.</p><p style="text-align: left;">If the document is a html page the document is sent directly to the indexer process.</p><p style="text-align: left;">If the document is not a a html page the document is put in the folder F:\sinequa\temp. It's the queue for the converter process.</p><p style="text-align: left;">The converter process converts non html documents to a html documents and the converted document is sent to the indexer.</p><p style="text-align: left;">A process indexer is created for each indexation. The queue of the indexer in processed in memory (not temporary files). The max number of documents in the queue is 50. If the max number is reached during an indexation the browser/connector process will wait.</p><h1 style="text-align: left;">Software installation</h1><hr style="text-align: left;" /><p style="text-align: left;">The installation is describe in this document:</p><p style="text-align: left;"><a href="https://acew1tsinesin01.eua.solvay.com/doc/en/Content/en.sinequa-es.index.installation.html" style="">https://acew1tsinesin01.eua.solvay.com/doc/en/Content/en.sinequa-es.index.installation.html</a></p><p style="text-align: left;">For the configuration of SSO see this documentation:</p><p style="text-align: left;"><a href="https://doc.sinequa.com/en.sinequa-es.v10/Content/en.sinequa-es.how-to.implement-sso.html" style="">https://doc.sinequa.com/en.sinequa-es.v10/Content/en.sinequa-es.how-to.implement-sso.html</a></p><p style="text-align: left;">See above for the login/password</p><p style="text-align: left;">At the end of the installation don't forget to execute this script:</p><h1 style="text-align: left;">Software update</h1><hr style="text-align: left;" /><p style="text-align: left;">To update the software with the last build version:</p><ul style="text-align: left;"><li>download the software (sinequa.xxx.zip) from the Download Sinequa server (<a href="https://download.sinequa.com">https://download.sinequa.com</a>)</li><li>put the file in the directory \\wdcsqad21\f$\softwares\</li><li>rename it with the current date : sinequa<version.build>.zip (ex: sinequa.10.5.0.28932.zip)</li><li>replace the folder F:\Sinequa by the content of the zip folder</li></ul><p style="text-align: left;">In AWS it's not possible to download a file from Internet. To do this, we must create a ticket in Service One.</p><h2 style="text-align: left;">Test environment</h2><hr style="text-align: left;" /><h3 style="text-align: left;">Sinequa server (acew1tsinesin01)</h3><hr style="text-align: left;" /><ul style="text-align: left;"><li>Copy the file sinequa<version.build>\sinequa<version.build>.zip on the server.</li><li>Unzip the file in the folder I:\softwares\sinequa<version.build>\sinequa<version.build></li><li>Copy the folder F:\sinequa in the folder I:\backup\sinequa<year><month><day> (exclude the folders temp & log)</li><li>From the Sinequa Administration page, stop the following:<ul><li>All running jobs.</li><li>Stop the indexer.</li><li>Stop the Engine.</li></ul></li><li><p>Stop the IIS Service (World Wide Web Publishing Service)</p></li><li><p>Set the IIS Service's "Startup Type" to "disabled". (To prevent any script from auto starting up the service)</p></li><li><p>Stop all Sinequa services (sinequa.service & sinequa.identity1)</p></li><li><p>Set both Sinequa services' "Startup Type" to disabled. (To prevent any script from auto starting up the service)</p></li><li>Check that there is no process sinequa running (kill process which name begins with sinequa.*)</li><li>Copy (move + overwrite) all files of the folder I:\softwares\sinequa<version.build>\sinequa into the folder F:\sinequa</li><li><p>Set the IIS Service's "Startup Type" to "Automatic".</p></li><li><p>Set both Sinequa services' "Startup Type" to "Automatic".</p></li><li><p>Start all Sinequa services</p></li><li><p>Start IIS service</p></li><li>Delete the zip file I:\softwares\sinequa<version.build>.zip and the unzipped folder I:\softwares\sinequa<version.build></li></ul><h2 style="text-align: left;">Production environment</h2><hr style="text-align: left;" /><h3 style="text-align: left;">Sinequa server (acew1psinesin01)</h3><hr style="text-align: left;" /><ul style="text-align: left;"><li>Copy the file sinequa<version.build>.zip on the server in the drive F</li><li>Unzip the file in the folder F:\sinequa<version.build></li><li>Copy the folder F:\sinequa in the folder I:\Backup\ (exclude the folders temp & log)</li><li>Rename the folder I:\Backup\sinequa into G:\sinequa_setup_backup\sinequa<year><month><day> (backup installation)</li><li>From the Sinequa Administration page, stop the following:<br /><ul><li>All running jobs.</li><li>Stop the indexer.</li><li>Stop the Engine.</li></ul></li><li>Stop the IIS Service (World Wide Web Publishing Service)</li><li>Set the IIS Service's "Startup Type" to "disabled". (To prevent any script from auto starting up the service)</li><li>Stop all Sinequa services (sinequa.service & sinequa.identity1)</li><li>Set both Sinequa services' "Startup Type" to disabled. (To prevent any script from auto starting up the service)</li><li>Check that there is no process sinequa running (kill process which name begins with sinequa.*)</li><li>Copy (move + overwrite) all files of the folder F:\sinequa<version.build>\sinequa into the folder F:\sinequa</li><li>Set the IIS Service's "Startup Type" to "Automatic".</li><li>Set both Sinequa services' "Startup Type" to "Automatic".</li><li>Start all Sinequa services</li><li>Start IIS service</li><li>Delete the zip file F:\sinequa<version.build>.zip and the unzipped folder f:\sinequa<version.build></li></ul><h1 style="text-align: left;">Search interface</h1><hr style="text-align: left;" /><h2 style="text-align: left;">Override user</h2><hr style="text-align: left;" /><p style="text-align: left;">If you want to see what can see a user you can override its account.</p><p style="text-align: left;">Connect on the search interface with the Admin account. Add these parameters in the URL:</p><p style="text-align: left;">&overrideuser=<user account>&overridedomain=<domain></p><p style="text-align: left;"><a href="http://acew1psinesin01.eua.solvay.com/admin?user=admin&password=SINEQUA01" style="">http://acew1psinesin01.eua.solvay.com/admin?user=admin&password=SINEQUA01</a></p><p style="text-align: left;"><a href="https://acew1psinesin01.eua.solvay.com/search?profile=xECM_FP_PRODUCTION_ECO&overrideuser=ltan&overridedomain=OpenText_Production" style="">https://acew1psinesin01.eua.solvay.com/search?profile=xECM_FP_PRODUCTION_ECO&overrideuser=ltan&overridedomain=OpenText_Production</a></p><h2 style="text-align: left;">Change user interface language</h2><hr style="text-align: left;" /><p style="text-align: left;">The default user language interface is the Windows. If the Windows language is different of English, French, Portuguese, China or German it will be English.</p><p style="text-align: left;">During a session you can change the user interface language by adding the parameter uilanguage(eg: uilanguage=fr, uilanguage=de,...) in the URL.</p><p style="text-align: left;">Example:<span> </span><a class="" href="https://ehs-fp-search-eco.solvay.com/search?uilanguage=pt" style="">https://ehs-fp-search-eco.solvay.com/search?uilanguage=pt</a></p><h1 style="text-align: left;">Administration interface</h1><hr style="text-align: left;" /><h2 style="text-align: left;">URL</h2><hr style="text-align: left;" /><p style="text-align: left;">Here’s the URL of the administration interface:<span> </span><span class="nolink"><a href="https://acew1psinesin01.eua.solvay.com/admin" style="">https://acew1psinesin01.eua.solvay.com/admin</a></span></p><p style="text-align: left;">If your AD account doesn’t have rights you can use this URL to connect with the Sinequa administrator account:</p><p style="text-align: left;"><ins><a href="https://acew1psinesin01.eua.solvay.com/admin?user=admin&password=SINEQUA01" style="">https://acew1psinesin01.eua.solvay.com/admin?user=admin&password=XXXXXX</a></ins></p><p style="text-align: left;">or go to <ins><span> </span><a href="https://acew1psinesin01.eua.solvay.com/login" style="">https://acew1psinesin01.eua.solvay.com/login</a></ins></p><p style="text-align: left;">(login= admin / password=XXXXXX) and then go to <a href="https://acew1psinesin01.eua.solvay.com/admin" style="">https://acew1psinesin01.eua.solvay.com/admin</a></p><h2 style="text-align: left;">Functions</h2><hr style="text-align: left;" /><h3 style="text-align: left;">Servers status</h3><hr style="text-align: left;" /><p style="text-align: left;">In this section you can delete and create index.</p><p style="text-align: left;">You can see the version of Sinequa.</p><h3 style="text-align: left;">Tasks status</h3><hr style="text-align: left;" /><p style="text-align: left;">In this section you can see the results of indexing tasks scheduled or not.</p><p style="text-align: left;">You can stop a running task of indexing.</p><h3 style="text-align: left;">Sessions status</h3><hr style="text-align: left;" /><p style="text-align: left;">In this section you can see all sessions.</p><h3 style="text-align: left;">Global options</h3><hr style="text-align: left;" /><p style="text-align: left;">In the tab General, you can see the version of Sinequa.</p><p style="text-align: left;">In the tab Indexes schema you can define the number of sourcecsv, sourcestr and sourcetree count (fields). If you change this value you have to click on the button Update indexes model.</p><p style="text-align: left;">After the update all indexes will be modified: new fields will be added.</p><h3 style="text-align: left;">Profiles</h3><hr style="text-align: left;" /><p style="text-align: left;">In this section you can see all profiles. A profile determines:</p><ul style="text-align: left;"><li>appearance (skin)</li><li>data set</li><li>restrictions</li><li>navigation boxes</li></ul><p style="text-align: left;">For a profile, you can specify the list of indexes, the list of sources, the list of collections</p><p style="text-align: left;">In the Advanced tab, in the field Selection url patterns you can specified a sub-domain that will be associated to the profile (example: For the profile<span> </span><strong><span style="color: rgb(0,0,0);">Silica Light ECM</span></strong><span> </span>it's<span> </span><a href="https://silica-search.solvay.com/" style="">https://silica-search.solvay.com/</a>).</p><h3 style="text-align: left;">Sources & collections</h3><hr style="text-align: left;" /><p style="text-align: left;">A source is a list of collections.</p><p style="text-align: left;">A collection describes data source to be indexed. It can be xECM, Aodocs,…</p><p style="text-align: left;">The name of the index is configured in the source.</p><p style="text-align: left;">In the tab General, the field Tree root indicates the location that will be used in the navigation box Sources.</p><p style="text-align: left;">In the tab Mappings, you can define the initialization of the variables.</p><p style="text-align: left;">You can start indexation by clicking on the button Start connector (the field Force reindexation must be checked).</p><p style="text-align: left;">In the tab Connection check Change connection group name on timeout to avoid trouble if there is page in timeout (avoid that all next pages are considered in timeout (avoid an issue with Tridion)</p><h3 style="text-align: left;">Domains and partitions</h3><hr style="text-align: left;" /><p style="text-align: left;">A domain is a list of partitions.</p><p style="text-align: left;">A partition describes a connector to get a list of users (AD,…).</p><h3 style="text-align: left;">Domain mappings</h3><hr style="text-align: left;" /><p style="text-align: left;">In this module, you can map different partitions. </p><h3 style="text-align: left;">Indexes</h3><hr style="text-align: left;" /><p style="text-align: left;">In this module you can find the list of the indexes. An index is a physical container that stores the result of the indexation.</p><h3 style="text-align: left;">Grid/nodes</h3><hr style="text-align: left;" /><p style="text-align: left;">List of Sinequa nodes.</p><h3 style="text-align: left;">Advanced/Advanced forms</h3><hr style="text-align: left;" /><p style="text-align: left;">In this module, you can define forms used in the advanced search.</p><h3 style="text-align: left;">Advanced/Skins</h3><hr style="text-align: left;" /><p style="text-align: left;">A skin describes a type of interface. All graphic elements are stored in the folder F:\sinequa\website\skins\<name of the skin>.</p><p style="text-align: left;">To configure the zone in the results search go in the tab Search Form.</p><p style="text-align: left;">In the section Custom html / Metadata html pattern if you type &nbsp; you will display nothing above the link Cached document. If there is nothing in the zone, Sinequa will put the default value that you can in the documentation.</p><p style="text-align: left;">The other solution is to insert this code in the search.cs plugin :</p><p style="text-align: left;"><br /></p><p style="text-align: left;"><em>public override bool OnWriteDocMetadata(Doc doc)</em></p><p style="text-align: left;"><em> {</em></p><p style="text-align: left;"><em> if (Str.EQNC(Session.Profile.Name, "RhodiaGlobal") || Str.EQNC(Session.Profile.Name, "RhodiaInteractive"))</em></p><p style="text-align: left;"><em> { </em></p><p style="text-align: left;"><em> return true;</em></p><p style="text-align: left;"><em> } </em></p><p style="text-align: left;"><em> return false;</em></p><p style="text-align: left;"><em> }</em></p><p style="text-align: left;"><br /></p><h3 style="text-align: left;">Advanced/Plugins</h3><hr style="text-align: left;" /><p style="text-align: left;">List of the plug-ins.</p><p style="text-align: left;">A plug-in is a code that is executed during the indexation or the searching. The code replaces the normal execution to personalize treatment.</p><h4 style="text-align: left;">Crawler.cs</h4><hr style="text-align: left;" /><p style="text-align: left;">This plug-in concerns the indexation.</p><p style="text-align: left;">You can put code that will be executed during the indexation to make specific processing.</p><p style="text-align: left;">Example :There is a code to delete concurrencies of the parameter jsessionid (cleaning) in the URL.</p><h4 style="text-align: left;">search.cs</h4><hr style="text-align: left;" /><p style="text-align: left;">This plug-in concerns the searching interface.</p><p style="text-align: left;">The code makes these actions:</p><ul style="text-align: left;"><li>takes into account the parameter q (search text) instead of text to be compliant with the Google Desktop</li><li>manages sort</li><li>manages pagination</li><li>replace the character “_” by the character “ ” in the name of the document to allow break lines (avoid the increase of the width of the window)</li></ul><p style="text-align: left;"><em> public override bool OnWriteDocTitle(Doc doc)</em><br /><em> {</em><br /><em> </em><br /><em> // string title = doc.SourceStr(13) + " " + doc.SourceStr(2) + " " + Ht.Text(doc.ResultTitle.Replace("_", " "));</em><br /><em> string title = Ht.Text(doc.ResultTitle.Replace("_", " "));</em><br /><em> </em><br /><em> </em><br /><em> if (doc.SourceStr(13)=="0") {</em><br /><em> Hm.Write("<span class="customtitle" rhodiatitle=\"", doc.SourceStr(13) ,"\">",title ,"</span>");</em><br /><em> }</em><br /><em> else if (doc.SourceStr(2)=="WD") {</em><br /><em> Hm.Write("<span class="customtitle" rhodiatitle=\"", doc.SourceStr(2) ,"\">",title ,"</span>");</em><br /><em> }</em><br /><em> else { </em><br /><em> Hm.Write(title);</em><br /><em> }</em><br /><em> </em><br /><em> return true;</em><br /><em> }</em></p><p style="text-align: left;">=> This code will change the color of the title if the field SOURCESTR13 is equal to 0 or SOURCESTR2 is equal to WD</p><h3 style="text-align: left;">Advanced/Navigation boxes</h3><hr style="text-align: left;" /><p style="text-align: left;">In this module, you can manage all navigation boxes, native and custom.</p><p style="text-align: left;">If the first character of the name of the box is “_” it means that it’s a native box. You can't modify it. </p><h3 style="text-align: left;">Advanced/Commands</h3><hr style="text-align: left;" /><p style="text-align: left;">In this module you can execute Sinequa commands:</p><ul style="text-align: left;"><li>delete collection</li><li>delete source</li><li>reorganize index (shrink index)</li><li>sql request</li><li>...</li></ul><h3 style="text-align: left;">Custom parameters</h3><hr style="text-align: left;" /><p style="text-align: left;">You can add parameters in all forms of the administration (profiles,...). These parameters could be used in plugins files to specific processing.</p><p style="text-align: left;">For example, the filter added in the boxes allowing to show box if the current treepath is a equal to a specific value was made by this method.</p><p style="text-align: left;">Content of G:\sinequa\data\configuration\form-override\box.list.xml overriding the form of the navigation box:</p><p style="text-align: left;"><?xml version="1.0" encoding="utf-8"?><br /><Sinequa><br /> <Inherit>box.list</Inherit><br /> <Tab merge-type="merge" merge-attrname="id" merge-attrvalue="general"><br /> <Group merge-type="add"> <br /> <Entry><Display>{Lang("Hide box if items count >[fr]Cacher la boîte si le nombre d'item est >")}</Display><DataTag>HideMoreThanXRows</DataTag></Entry><br /> </Group><br /> <Group merge-type="add"> <br /> <Display>{Lang("Show box if filter[fr]Afficher la boîte si filtre")}</Display><br /> <Grid> <br /> <DataTag>ShowBoxIfSelectionValue</DataTag> <br /> <Col><Title>{Lang("Box[fr]Boîte")}</Title><DataTag>boxname</DataTag><Width>50</Width><CellType>entrycombo</CellType><CellListName>listbox</CellListName></Col><br /> <Col><Title>{Lang("Operator[fr]Opérateur")}</Title><DataTag>comp_operator</DataTag><Width>50</Width><CellType>entrycombo</CellType><CellListName>listcompoperator</CellListName></Col><br /> <Col><Title>{Lang("Value[fr]Valeur")}</Title><DataTag>value</DataTag><Width>200</Width><CellType>input</CellType></Col><br /> <Col><ShowPlus>true</ShowPlus><Width>16</Width><CellType>rowdelete</CellType><CellValue>rowdelete</CellValue></Col><br /> </Grid> <br /> </Group><br /> <Group merge-type="add"> <br /> <Display>{Lang("Show box if is in tree[fr]Afficher la boîte si dans l'arbre")}</Display><br /> <Grid> <br /> <DataTag>ShowBoxIfAllInTreeNode</DataTag> <br /> <Col><Title>{Lang("Box[fr]Boîte")}</Title><DataTag>BoxTreeName</DataTag><Width>50</Width><CellType>entrycombo</CellType><CellListName>listbox</CellListName></Col><br /> <Col><Title>{Lang("Value[fr]Valeur")}</Title><DataTag>value</DataTag><Width>200</Width><CellType>input</CellType></Col><br /> <Col><ShowPlus>true</ShowPlus><Width>16</Width><CellType>rowdelete</CellType><CellValue>rowdelete</CellValue></Col><br /> </Grid> <br /> </Group><br /> </Tab><br /> <List merge-type="add"><br /> <Name>listcompoperator</Name> <br /> <Item><Name>Equals[fr]Est égal</Name><Value>=</Value></Item><br /> <Item><Name>Contains[fr]Contient</Name><Value>contains</Value></Item><br /> </List><br /></Sinequa></p><p style="text-align: left;">Part of the screen shot:</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot066.gif?version=1&modificationDate=1423467542225&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot066.gif?version=1&modificationDate=1423467542225&api=v2"></p><p style="text-align: left;">Data associated to these fields are used in the event OnWriteBoxList of the search plugin.</p><h3 style="text-align: left;">Jobs</h3><hr style="text-align: left;" /><p style="text-align: left;">In this module, you can schedule jobs (indexation of collections, partition synchronization, commands, list of jobs).</p><h2 style="text-align: left;">Logs</h2><hr style="text-align: left;" /><p style="text-align: left;">To reduce the log level for the WebApp, goto to Global options/Advanced and type 2 in the zone Sql log level (default 1). Otherwise, the size of the log files may be important.</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot020.gif?version=1&modificationDate=1423467538595&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot020.gif?version=1&modificationDate=1423467538595&api=v2"></p><p style="text-align: left;">If you want to activate logs for a module, you have to type 20 in the field Log level in the tab Advanced. The logs will be written in the folder F:\sinequa\log.</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot053.gif?version=1&modificationDate=1423467541255&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot053.gif?version=1&modificationDate=1423467541255&api=v2"></p><h2 style="text-align: left;">Translation of labels</h2><hr style="text-align: left;" /><p style="text-align: left;">If you want to translate English labels into French you have to put after the English label the characters “[fr]” and the French label.</p><p style="text-align: left;">Example: Keywords[fr]Mots clés</p><h2 style="text-align: left;">Replacement of labels</h2><hr style="text-align: left;" /><p style="text-align: left;">To replace label by a personalize label you have to put the replacement in the file G:\sinequa\data\configuration\lang\en.xml for English labels and in the file G:\sinequa\data\configuration\lang\fr.xml for French labels.</p><p style="text-align: left;">Example: The label in English in the bookmarks menu</p><p style="text-align: left;"><item> <br /><key>Baskets[fr]Paniers</key> <br /><value>Bookmarks</value> <br /></item></p><h2 style="text-align: left;">New language</h2><hr style="text-align: left;" /><p style="text-align: left;">If you want to add a new language (language LG), you need to translate labels.</p><p style="text-align: left;">Copy the file F:\sinequa\samples\en.sample.xml into F:\sinequa\samples\LG.sample.xml</p><p style="text-align: left;">Translate the tag values of the file F:\sinequa\samples\LG.sample.xml</p><p style="text-align: left;"><br /></p><p style="text-align: left;">Copy the file G:\sinequa\\data\configuration\lang\fr.xml into G:\sinequa\\data\configuration\lang\LG.xml</p><p style="text-align: left;">Translate the tag values of the file G:\sinequa\\data\configuration\lang\LG.xml</p><p style="text-align: left;">Need an IIS service restart to take it into account.</p><h1 style="text-align: left;">SCMD commands (Sinequa COMmand)</h1><p style="text-align: left;">On the server, you can execute commands with SCMD exe.</p><p style="text-align: left;"><strong>Example of CSV export:</strong></p><p style="text-align: left;">scmd execsqlcsv "select id,title,filename from idx_DocumentumEHS2 where text contains ' +(wercs)' and ((collection contains '/Documentum/rcsehs2_test/*')) and sourcestr13 contains 'historical' and SearchParameters='mac=100000;dlang=autodetect;langw=en/1.2/fr/1.1/es/1.0/it/1.0/nl/1.0/ko/0.8/*/0.9' count 2000000000 " f:\export_historical_wercs.txt</p><h1 style="text-align: left;">SQL requests</h1><hr style="text-align: left;" /><p style="text-align: left;">Sinequa as developed is own SQL language for indexes requests. You can use the SQL Console within the Sinequa Admin page.<br /><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="250" width="639" src="https://wiki.solvay.com/download/attachments/6030248/image2021-10-8_11-10-21.png?version=1&modificationDate=1633662621809&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2021-10-8_11-10-21.png?version=1&modificationDate=1633662621809&api=v2"></p><p style="text-align: left;">The SQL Console can only be accessible if the user is defined as Administrator for the domain.</p><p style="text-align: left;">You will need to make sure you are the administrator for the domain "Rhodia_AD". <br />If user is not able to find the SQL Console, make sure the user is added as the administrator of the "Rhodia_AD".</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" src="https://wiki.solvay.com/download/attachments/6030248/image2021-10-8_11-13-4.png?version=1&modificationDate=1633662784819&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2021-10-8_11-13-4.png?version=1&modificationDate=1633662784819&api=v2"></p><p style="text-align: left;"><br /></p><p style="text-align: left;"><em>Example of request:</em></p><p style="text-align: left;">select id,databasealias,title,documentlanguages,authors,modified,indexationtime,version,keywords,size,treepath,filename,fileext,flags,collection,</p><p style="text-align: left;">docformat,doctype,containerid,msgfrom,msgto,remap(person),remap(company),remap(geo),url1,url2,accesslist1,</p><p style="text-align: left;">accesslist2,deniedlist1,sourcecsv1,sourcecsv2,sourcecsv3,</p><p style="text-align: left;">sourcecsv4,sourcecsv5,sourcecsv6,sourcecsv7,sourcecsv8,</p><p style="text-align: left;">sourcecsv9,sourcecsv10,sourcecsv11,sourcecsv12,sourcecsv13,</p><p style="text-align: left;">sourcecsv14,sourcecsv15,sourcecsv16,sourcecsv17,</p><p style="text-align: left;">sourcecsv18,sourcecsv19,sourcetree1,sourcetree2,sourcestr1,searchid,</p><p style="text-align: left;">from idx_CrawlInternet,idx_CrawlInternetDEV,idx_CrawlIntranet,idx_CrawlIntranetBasicHtml,</p><p style="text-align: left;">idx_CrawlIntranetBlog,idx_CrawlIntranetDEV,idx_Documentum,idx_Eroom</p><p style="text-align: left;">where ((collection contains '/InteractiveInternetPublic/*') or (collection contains '/InteractiveIntranetPublic/*') or (collection contains '/Eroom/*') or (collection contains '/BasicHtmlIntranet/*') or (collection contains '/Documentum/*')) and treepath contains '/Eroom/*' order by modified desc skip 0 count 20</p><h1 style="text-align: left;">CSV Export of the content of index</h1><hr style="text-align: left;" /><p style="text-align: left;">For small export you can use the Engine Console (Menu: Session/ Save Results).</p><p style="text-align: left;">For huge export you can execute this example of script (inside a bat extension file):</p><p style="text-align: left;">F:\sinequa\website\bin\tools.engine.SQL-32.exe --host=acew1psinesin01 "--execute=select id,documentlanguages,treepath,title,filename, modified,indexationtime,docformat,sourcecsv1,sourcecsv2,sourcecsv3,sourcestr1,sourcestr2,sourcestr3,sourcestr4,sourcestr5,sourcestr6,sourcestr7,sourcestr9,sourcestr10,sourcestr11,sourcestr12,sourcestr13,sourcestr14,sourcestr15,sourcestr16,sourcestr17,sourcestr18,sourcestr19,sourcestr20,sourcestr20,sourcestr21,sourcestr22,sourcecsv20 from idx_Documentum where treepath contains '/Documentum/RCSEHS/EHS/*' and sourcestr4 contains 'sds - europe' order by modified desc skip 0 count 200000" > ehsexport_sds_europe.dat</p><p style="text-align: left;">F:\sinequa\website\bin\tools.engine.SQL-32.exe --raw --host=acew1psinesin01 "--execute=select Id,DocumentLanguages,treepath,filename,modified,indexationtime,size,fileext,docformat,doctype,url1 from idx_solwebinternet where collection ='/SolwebInternet/<a href="http://solvay.com/" style="">Solvay.com/</a>' order by indexationtime asc " > exportcsv.dat</p><h1 style="text-align: left;">Sinequa for Solvay</h1><hr style="text-align: left;" /><h2 style="text-align: left;">Servers</h2><hr style="text-align: left;" /><p style="text-align: left;"><br /></p><table style="text-align: left;" class="confluenceTable"><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"> Server</th><th style="text-align: left;vertical-align: top;" class="confluenceTh">Full name</th><th style="text-align: left;vertical-align: top;" class="confluenceTh"> Description</th><th style="text-align: left;vertical-align: top;" class="confluenceTh"> Environment</th></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">acew1dsinesin01 </td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><a href="http://acew1dsinesin01.eua.solvay.com">acew1dsinesin01.eua.solvay.com</a></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"> Sinequa main server</td><td style="text-align: left;vertical-align: top;" class="confluenceTd"> Development</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">acew1tsinesin01 </td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><a href="http://acew1tsinesin01.eua.solvay.com">acew1tsinesin01.eua.solvay.com</a></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"> Sinequa main server</td><td style="text-align: left;vertical-align: top;" class="confluenceTd"> QA</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">acew1psinesin01</td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><a href="http://acew1psinesin01.eua.solvay.com">acew1psinesin01.eua.solvay.com</a></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"> Sinequa main server</td><td style="text-align: left;vertical-align: top;" class="confluenceTd"> Production</td></tr></tbody></table><h1 style="text-align: left;">Service accounts</h1><hr style="text-align: left;" /><p style="text-align: left;">The service accounts are all stored in this<span> </span><a href="https://docs.google.com/a/solvay.com/spreadsheets/d/1iBtq_cZxebO5B5amNXKjNcuw4_DRGtzfks2w40QVMWU/edit?usp=sharing" style="">GDrive link</a>.</p><p style="text-align: left;">This link is only accessible by the Sinequa team. To access the link, request for the permission.</p><p style="text-align: left;"><br /></p><p style="text-align: left;">List of accounts:</p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /><col class="" /><col class="" /></colgroup><tbody class=""><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"><strong>Account</strong></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><strong>Server</strong></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><strong>Environment</strong></td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">EUA\SVC-DEV-SINE</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">acew1dsinesin01</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">DEVELOPMENT</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">EUA\SVC-TST-SINE</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">acew1tsinesin01</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">TEST</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">EUA\SVC-PRD-SINE</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">acew1psinesin01</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">PRODUCTION</td></tr></tbody></table><p style="text-align: left;"><br /></p><h2 style="text-align: left;">Organization of directories</h2><hr style="text-align: left;" /><p><br /></p><table class="confluenceTable"><colgroup class=""><col class="" /><col class="" /></colgroup><tbody class=""><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">Directory</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Description</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">H:\IIS_Logs</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Logs for IIS</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">F:\sinequa\</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">All source files for Sinequa</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">F:\sinequa\website</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Scripts for the Web interface search</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">F:\sinequa\ooo320</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Open office. Sinequa uses OO to convert document to html format (This folder is included in the software package)</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">F:\sinequa\website\skins\\SolvayV10</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Files for the skin SolvayV10</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">H:\SinequaLog\log</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Sinequa log files</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">G:\sinequa\data\configuration</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">All files for the configuration of Sinequa</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">G:\sinequa\data\configuration\lang</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Files for the labels (French + English and others (PT & DE))</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">G:\sinequa\indexes</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Index files</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">G:\sinequa_setup_backup</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Dump of the index</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">G:\sinequa\data\configuration\delegated-admins</td><td style="text-align: left;vertical-align: top;" class="confluenceTd"> List of administrators of the application</td></tr></tbody></table><p><br /></p><p style="text-align: left;"><br /></p><h2 style="text-align: left;">Accounts</h2><hr style="text-align: left;" /><p style="text-align: left;">Accounts for the Web Sinequa interface are linked to Active Directory of Rhodia.</p><p style="text-align: left;">Extra accounts (Sinequa administrator, Web Services) have been created in this file:</p><p style="text-align: left;">G:\sinequa\data\configuration\domains\Sinequa\DefaultPartition\content.xml</p><p style="text-align: left;">Extra accounts are not visible in the administration interface but they can be used to restrict access to data.</p><h2 style="text-align: left;">Piwik</h2><hr style="text-align: left;" /><p style="text-align: left;">Piwik ( Matomo) is a web analytics<span style="color: rgb(32,33,34);"><span> </span>application to track online<span> </span></span>visits<span style="color: rgb(32,33,34);"><span> </span>to one or more<span> </span></span>websites<span style="color: rgb(32,33,34);"><span> </span>and display reports on these visits for analysis.</span></p><p style="text-align: left;"><span style="color: rgb(32,33,34);">Piwik has been integrated in Sinequa by a js file inserted in the Skins:</span></p><h2 style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="400" src="https://wiki.solvay.com/download/attachments/6030248/image-2024-7-8_18-5-34.png?version=1&modificationDate=1720454734534&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image-2024-7-8_18-5-34.png?version=1&modificationDate=1720454734534&api=v2"></h2><p style="text-align: left;"><br /></p><p style="text-align: left;">Content of the file F:\Sinequa\website\skins\piwik.js</p><p style="text-align: left;"><br /></p><table class="relative-table confluenceTable" style="width: 1205.88px;"><colgroup class=""><col class="" style="width: 1205.07px;" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><p>var domain=window.location.host; <br />var subdomain = domain.toLowerCase();<br />var piwikcode ='';</p><p>if (subdomain=='<a href="http://4sight-search.solvay.com/" style="">4sight-search.solvay.com</a>') {piwikcode = '1e8c74b2-6ea9-401a-b620-1f2ecb756536';}<br />if (subdomain=='<a href="http://4sight-search.syensqo.com/" style="">4sight-search.syensqo.com</a>') {piwikcode = '1e8c74b2-6ea9-401a-b620-1f2ecb756536';}</p><p><br />if (subdomain=='<a href="http://ehs-rm-search-eco.solvay.com/" style="">ehs-rm-search-eco.solvay.com</a>') {piwikcode = '45d647d2-dc4f-4664-a35b-917cb452ee78';}</p><p>if (subdomain=='<a href="http://ehs-rm-search-sco.solvay.com/" style="">ehs-rm-search-sco.solvay.com</a>') {piwikcode = 'a60bdd51-e9a7-405a-8ce4-dadd517115a8';}<br />if (subdomain=='<a href="http://ehs-rm-search.syensqo.com/" style="">ehs-rm-search.syensqo.com</a>') {piwikcode = 'a60bdd51-e9a7-405a-8ce4-dadd517115a8';}</p><p>if (subdomain=='<a href="http://ehs-fp-search-eco.solvay.com/" style="">ehs-fp-search-eco.solvay.com</a>') {piwikcode = '2ecb8888-6455-4566-8c77-c19cbff134b6';}</p><p>if (subdomain=='<a href="http://ehs-fp-search-sco.solvay.com/" style="">ehs-fp-search-sco.solvay.com</a>') {piwikcode = 'd134c535-9467-4e2e-a00d-93b3397f15ad';}<br />if (subdomain=='<a href="http://ehs-fp-search.syensqo.com/" style="">ehs-fp-search.syensqo.com</a>') {piwikcode = 'd134c535-9467-4e2e-a00d-93b3397f15ad';}</p><p>if (subdomain=='<a href="http://global-intelligence-search-tool.solvay.com/" style="">global-intelligence-search-tool.solvay.com</a>') {piwikcode = '004c78e9-1f7b-42d6-b9c1-7716448fec0b';} <br />if (subdomain=='<a href="http://global-intelligence-search-tool.syensqo.com/" style="">global-intelligence-search-tool.syensqo.com</a>') {piwikcode = '004c78e9-1f7b-42d6-b9c1-7716448fec0b';} </p><p>if (subdomain=='<a href="http://productinformation-eco.solvay.com/" style="">productinformation-eco.solvay.com</a>') {piwikcode = '8eb50a2a-824f-4665-a2f5-66e39ea90fc7';}</p><p>if (subdomain=='<a href="http://productinformation-sco.solvay.com/" style="">productinformation-sco.solvay.com</a>') {piwikcode = 'a598c042-33d1-44e3-8fb3-cbbddc084cbe';}<br />if (subdomain=='<a href="http://productinformation.syensqo.com/" style="">productinformation.syensqo.com</a>') {piwikcode = 'a598c042-33d1-44e3-8fb3-cbbddc084cbe';}</p><p>if (subdomain=='<a href="http://regwatch-search.solvay.com/" style="">regwatch-search.solvay.com</a>') {piwikcode = '7fcb6570-b17f-4d2b-a2ac-f5ebbbb3e315';}<br />if (subdomain=='<a href="http://regwatch-search-eco.solvay.com/" style="">regwatch-search-eco.solvay.com</a>') {piwikcode = '7fcb6570-b17f-4d2b-a2ac-f5ebbbb3e315';}</p><p>if (subdomain=='<a href="http://regwatch-search-sco.solvay.com/" style="">regwatch-search-sco.solvay.com</a>') {piwikcode = '7fcb6570-b17f-4d2b-a2ac-f5ebbbb3e315';}<br />if (subdomain=='<a href="http://regwatch-search.syensqo.com/" style="">regwatch-search.syensqo.com</a>') {piwikcode = '7fcb6570-b17f-4d2b-a2ac-f5ebbbb3e315';}</p><p><br />if (subdomain=='<a href="http://silica-search.solvay.com/" style="">silica-search.solvay.com</a>') {piwikcode = '4e6050e9-38db-4e10-893e-c7a2c9da4755';}<br /> <br /> <br />if (piwikcode !=''){<br /> <br /> (function(window, document, dataLayerName, id) {<br /> window[dataLayerName]=window[dataLayerName]||[],window[dataLayerName].push({start:(new Date).getTime(),event:"stg.start"});var scripts=document.getElementsByTagName('script')[0],tags=document.createElement('script');<br /> function stgCreateCookie(a,b,c){var d="";if(c){var e=new Date;e.setTime(e.getTime()+24*c*60*60*1e3),d="; expires="+e.toUTCString();f="; SameSite=Strict"}document.cookie=a+"="+b+d+f+"; path=/"}<br /> var isStgDebug=(window.location.href.match("stg_debug")||document.cookie.match("stg_debug"))&&!window.location.href.match("stg_disable_debug");stgCreateCookie("stg_debug",isStgDebug?1:"",isStgDebug?14:-1);<br /> var qP=[];dataLayerName!=="dataLayer"&&qP.push("data_layer_name="+dataLayerName),isStgDebug&&qP.push("stg_debug");var qPString=qP.length>0?("?"+qP.join("&")):"";<br /> tags.async=!0,tags.src="<a style="">https://solvay.containers.piwik.pro/"+id+".js"+qPString,scripts.parentNode.insertBefore(tags,scripts)</a>;<br /> !function(a,n,i){a[n]=a[n]||{};for(var c=0;c<i.length;c++)!function(i){a[n][i]=a[n][i]||{},a[n][i].api=a[n][i].api||function(){var a=[].slice.call(arguments,0);"string"==typeof a[0]&&window[dataLayerName].push({event:n+"."+i+":"+a[0],parameters:[].slice.call(arguments,1)})}}(i[c])}(window,"ppms",["tm","cm"]);<br /> })(window, document, 'dataLayer', piwikcode);<br /> <br /> <br /> console.log('piwikcode=' +piwikcode);<br /> <br />}<br /> <br /> </p></th></tr></tbody></table><h2 style="text-align: left;">Marquee Replacement</h2><hr style="text-align: left;" /><p style="text-align: left;">As Marquee feature is obsolete and may be removed at any time, a replacement for marquee feature is needed. (Marquee tag is used for text moving animation in web browser)</p><p style="text-align: left;"><a href="https://developer.mozilla.org/en-US/docs/Web/HTML/Element/marquee" style="">https://developer.mozilla.org/en-US/docs/Web/HTML/Element/marquee</a></p><p style="text-align: left;"><br /></p><p style="text-align: left;">Keyframes is used to replace marquee feature:</p><p style="text-align: left;"><a href="https://css-tricks.com/snippets/css/keyframe-animation-syntax/" style="">https://css-tricks.com/snippets/css/keyframe-animation-syntax/</a></p><p style="text-align: left;"><br /></p><p style="text-align: left;">Below code is added to F:\Sinequa\website\skins\rhodiainteractive\rhodia.css</p><table class="wysiwyg-macro" data-macro-name="code" data-macro-id="61fe9f9e-021f-43da-81bf-039c3c173649" aria-label="code macro" data-macro-parameters="language=css|title=Keyframes Transform Animation" data-macro-schema-version="1" style="background-image: url(https://wiki.syensqo.com/plugins/servlet/confluence/placeholder/macro-heading?definition=e2NvZGU6bGFuZ3VhZ2U9Y3NzfHRpdGxlPUtleWZyYW1lcyBUcmFuc2Zvcm0gQW5pbWF0aW9ufQ&locale=en_GB&version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>/* New Marquee */ /* define the animation */ @-webkit-keyframes new_marquee { 0% { -webkit-transform: translate(268px, 0); } 100% { -webkit-transform: translate(-100%, 0); } } @-moz-keyframes new_marquee { 0% { -moz-transform: translate(268px, 0); } 100% { -moz-transform: translate(-100%, 0); } } @keyframes new_marquee { 0% { transform: translate(268px, 0); } 100% { transform: translate(-100%, 0); } } /* define your limiting container */ .new_marquee { white-space: nowrap; overflow: hidden; border-color: #0aa2e3; box-sizing: border-box; width: 268px; height:20px; } /* this is the tray moving around your container */ .new_marquee span { display: inline-block; text-indent: 0; font-size: 13px; font-weight: bold; color: #808080; -webkit-animation: new_marquee linear infinite; /* here you select the animation */ animation: new_marquee linear infinite; /* here you select the animation */ } /* pause the animation on mouse over */ .new_marquee span:hover { -webkit-animation-play-state: paused; animation-play-state: paused; }</pre></td></tr></table><p style="text-align: left;"><br /></p><p style="text-align: left;">In Sinequa plugin search.cs, below code is added:</p><table class="wysiwyg-macro" data-macro-name="code" data-macro-id="21a69e21-15bd-40be-8c64-dfba18054742" aria-label="code macro" data-macro-parameters="language=c#|title=New Marquee" data-macro-schema-version="1" style="background-image: url(https://wiki.syensqo.com/plugins/servlet/confluence/placeholder/macro-heading?definition=e2NvZGU6bGFuZ3VhZ2U9YyN8dGl0bGU9TmV3IE1hcnF1ZWV9&locale=en_GB&version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>string LogoTitle = Sys.Lang(Rhodia_LogoTitle); string len = (LogoTitle.Length * 7).ToString(); string duration = ((LogoTitle.Length / 70) * 15).ToString(); if (duration == "0") { duration = "15"; } Hm.Write("<p class=\"new_marquee\"><span style=\"animation-duration:", duration, "s;\">", LogoTitle, "<span></p>");</pre></td></tr></table><p style="text-align: left;">Logic above:</p><ol style="text-align: left;"><li>Get LogoTitle from search profile</li><li>Get length of LogoTitle</li><li>Calculate duration for the keyframes transform animation to scroll the text (Basically every 70 chars needed 15 seconds)</li><li>Write html code to call new marquee class</li></ol><h2 style="text-align: left;">Change default images</h2><hr style="text-align: left;" /><p style="text-align: left;">Default images of the folder F\sinequa\website\images (icons,...) can be replaced by new ones. You just have to create the new images with the same name in the folderF\sinequa\website\images2</p><p style="text-align: left;">This folder is never overwritten by new upgrade of the software.</p><p style="text-align: left;">With this method we changed the default bookmark (basket) icon (basket.gif) and the new bookmark (basket) icon (new11.gif).</p><p style="text-align: left;">If you add new files in the folder images2 you need to restart IIS.</p><h2 style="text-align: left;">Specific settings</h2><hr style="text-align: left;" /><h3 style="text-align: left;">SolvayOne: Excluding indexation of the text "Google Translate" and "<span style="color: rgb(0,0,0);">For a better display of Solvay ONE, please switch to Chrome browser</span>"<span> </span><span style="color: rgb(255,0,0);">(no longer used)</span></h3><hr style="text-align: left;" /><h4 style="text-align: left;">Excluding the text "Google Translate"</h4><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="245" width="448" src="https://wiki.solvay.com/download/attachments/6030248/image2016-8-1%2011%3A25%3A5.png?version=1&modificationDate=1470021906717&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2016-8-1%2011%3A25%3A5.png?version=1&modificationDate=1470021906717&api=v2"></p><p style="text-align: left;">Exclude the indexation of the SolvayOne by indicating the div in the XPath setting in the<span> </span><strong>Collection</strong><span> </span>><span> </span><strong>Mappings</strong><span> </span>><span> </span><strong>XPath</strong> </p><table class="wysiwyg-macro" data-macro-name="info" data-macro-id="c2f1f77f-f999-4070-a835-097ec5468d49" aria-label="info macro" data-macro-parameters="title=Collection > Mappings > XPath" data-macro-schema-version="1" style="background-image: url(https://wiki.syensqo.com/plugins/servlet/confluence/placeholder/macro-heading?definition=e2luZm86dGl0bGU9Q29sbGVjdGlvbiA-IE1hcHBpbmdzID4gWFBhdGh9&locale=en_GB&version=2); background-repeat: no-repeat;" data-macro-body-type="RICH_TEXT"><tr><td class="wysiwyg-macro-body"><p>//div[@class="labelTranslate"]</p></td></tr></table><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="418" width="877" src="https://wiki.solvay.com/download/attachments/6030248/image2016-8-1%2011%3A27%3A16.png?version=1&modificationDate=1470022037247&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2016-8-1%2011%3A27%3A16.png?version=1&modificationDate=1470022037247&api=v2"></p><h4 style="text-align: left;">Excluding the text "For a better display of Solvay ONE, please switch to Chrome browser"</h4><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="250" width="681" src="https://wiki.solvay.com/download/attachments/6030248/image2016-8-1%2011%3A31%3A10.png?version=1&modificationDate=1470022270831&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2016-8-1%2011%3A31%3A10.png?version=1&modificationDate=1470022270831&api=v2"></p><p style="text-align: left;">Exclude the indexation of the SolvayOne by performing the indexation with Chrome agent.</p><table class="wysiwyg-macro" data-macro-name="info" data-macro-id="3c6fa301-6ea4-43d1-a3a5-410926c718d9" aria-label="info macro" data-macro-parameters="title=Collection > Connection > User Agent" data-macro-schema-version="1" style="background-image: url(https://wiki.syensqo.com/plugins/servlet/confluence/placeholder/macro-heading?definition=e2luZm86dGl0bGU9Q29sbGVjdGlvbiA-IENvbm5lY3Rpb24gPiBVc2VyIEFnZW50fQ&locale=en_GB&version=2); background-repeat: no-repeat;" data-macro-body-type="RICH_TEXT"><tr><td class="wysiwyg-macro-body"><p><span style="color: rgb(0,0,0);">Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2228.0 Safari/537.36</span></p></td></tr></table><p style="text-align: left;"><br /></p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="250" width="945" src="https://wiki.solvay.com/download/attachments/6030248/image2016-8-1%2011%3A32%3A53.png?version=1&modificationDate=1470022374222&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2016-8-1%2011%3A32%3A53.png?version=1&modificationDate=1470022374222&api=v2"></p><p style="text-align: left;"><br /></p><p style="text-align: left;"><br /></p><h3 style="text-align: left;">QUALITY MODOPE: integration in the custom fulltext of the values of multivalued dictionaries <span style="color: rgb(255,0,0);">(no longer used)</span></h3><hr style="text-align: left;" /><p style="text-align: left;">For the project Quality modope the keyuser wants that the values of a multivalued dictionary are included in the custom fulltext.</p><p style="text-align: left;">To do this we modified the Method OnConnectorStart of the plugin connector documentum.cs:</p><p style="text-align: left;">For each dictionary a file is generated in the folder G$\sinequa\data\configuration\files\filemapping</p><p style="text-align: left;">Each file contains for each key a line of the list of values in each language and the key.</p><p style="text-align: left;">Example: First lines of the file DTC.csv.DIC QUALITE_MODOP Keywords.txt:</p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><p><em>2-DIMETHYLAMINOETHYLE METHACRYLATE 2-DIMETHYLAMINOETHYLE METHACRYLATE ;2-DIMETHYLAMINOETHYLE METHACRYLATE</em><br /><em>2-HYDROXYPROPYLE ACRYLATE 2-HYDROXYPROPYLE ACRYLATE ;2-HYDROXYPROPYLE ACRYLATE</em><br /><em>4-VINYLE GAÏACOL 4-VINYLE GAÏACOL ;4-VINYLE GAÏACOL</em><br /><em>5-ETHYL-EVA 5-ETHYL-EVA ;5-ETHYL-EVA</em><br /><em>ACETALDEHYDE ACETALDEHYDE ;ACETALDEHYDE</em><br /><em>ACETATE D'ETHYLE ETHYL ACETATE ;ACETATE D?ETHYLE</em><br /><em>Acetate de butyle BUTYL ACETATE ;Acetate de butyle</em><br /><em>ACETATE DE PROPYLE PROPYL ACETATE ;ACETATE DE PROPYLE</em><br /><em>ACIDE ACETIQUE ACETIC ACID ;ACIDE ACETIQUE</em><br /><em>ACETIQUE ANHYDRE ACETIC ANHYDRIDE ;ACETIC ANHYDRIDE</em></p></th></tr></tbody></table><p style="text-align: left;">In the plugin search.cs we created this new function:</p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><p>// Function MultiFileMapping used in the mapping section of a collection // Used for multi-valued fields<em><br /></em> public class MultiFileMapping : FunctionPlugin<em><br /></em> {<em><br /></em> public override string GetValue(IDocContext ctxt, params string[] values)<em><br /></em> {<em><br /></em> if (values.Length < 2) return "ERROR";<em><br /></em> string filemapping = values[0];<em><br /></em> ListStr l = ListStr.ListFromStr(values[1], ';');<em><br /></em> ListStr res = new ListStr();<em><br /></em> foreach (string val in l)<em><br /></em> {<em><br /></em> res.Add(CC.Current.FileMapping(filemapping, val));<em><br /></em> }<em><br /></em> return res.ToStr(';');<em><br /></em> }<em><br /></em> }</p></th></tr></tbody></table><p style="text-align: left;">In the section Custom Fulltext of the tab Mappings of the collection /Documentum/quality_modeop/ we added this expression:</p><p style="text-align: left;"><br /></p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><em>Replace(MultiFileMapping("DTC.csv.DIC QUALITE_MODOP Keywords",property.keywords),";"," ")</em></th></tr></tbody></table><h3 style="text-align: left;">Force language for Deeg Project <span style="color: rgb(255,0,0);">(no longer used)</span></h3><hr style="text-align: left;" /><p style="text-align: left;">For the interface Deeg (profile=DCT_QUALITY_DGI) , code in the plugin search.cs (OnPageStart() event) have been added to force the interface language to English if the language of the browser is different of French, German or English.</p><p style="text-align: left;"><em> if (Session.SessionUiLangStr != "fr" && Session.SessionUiLangStr != "de" && Session.SessionUiLangStr != "en" && (Session.Profile.Name == "DCT_QUALITY_DGI_TEST" || Session.Profile.Name == "DCT_QUALITY_DGI")) {</em><br /><em> Session.SetUiLanguage("en");</em><br /><em> Session.RecalculateSessionUiLang();</em><br /><em>}</em></p><h3 style="text-align: left;">EHS xECM interfaces </h3><hr style="text-align: left;" /><h4 style="text-align: left;">Add links in the menu with different color<span> </span><span style="color: rgb(255,0,0);">(no longer used)</span></h4><hr style="text-align: left;" /><h4 style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot260.png?version=1&modificationDate=1423467555369&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot260.png?version=1&modificationDate=1423467555369&api=v2"></h4><p style="text-align: left;">To do this:</p><p style="text-align: left;">In the profile we added the links:</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot267.png?version=1&modificationDate=1423467555862&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot267.png?version=1&modificationDate=1423467555862&api=v2"></p><p style="text-align: left;">In the associated skin we added the files skins/gecdoc.js and skins/rhodiainteractive/gecdoc.css</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot267.png?version=1&modificationDate=1423467555862&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot267.png?version=1&modificationDate=1423467555862&api=v2"></p><p style="text-align: left;">Content of the file skins/gecdoc.js</p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"><em>$(document).ready(function() {</em><br /><em> $("#dm0m0i2td td:contains('GECDOC Contents')").each(function () {</em><br /><em> $(this).addClass( "gecdocZone1" );</em><br /><em> });</em><br /><em> $("#dm0m0i3td td:contains('GECDOC Contents')").each(function () {</em><br /><em> $(this).addClass( "gecdocZone1" );</em><br /><em> });</em><br /><em> </em><br /><em> $("#dm0m0i3td td:contains('GECDOC training')").each(function () {</em><br /><em> $(this).addClass( "gecdocZone1" );</em><br /><em> });</em><br /><em> $("#dm0m0i4td td:contains('GECDOC training')").each(function () {</em><br /><em> $(this).addClass( "gecdocZone1" );</em><br /><em> });</em><br /><em> $("#dm0m0i4td td:contains('Intranet GEC')").each(function () {</em><br /><em> $(this).addClass( "gecdocZone2" );</em><br /><em> });</em><br /><em> $("#dm0m0i5td td:contains('Intranet GEC')").each(function () {</em><br /><em> $(this).addClass( "gecdocZone2" );</em><br /><em> });</em><br /><em> $("#dm0m0i6td td:contains('Industrial Intranet')").each(function () {</em><br /><em> $(this).addClass( "gecdocZone2" );</em><br /><em> });</em><br /><em> $("#dm0m0i5td td:contains('Industrial Intranet')").each(function () {</em><br /><em> $(this).addClass( "gecdocZone2" );</em><br /><em> });</em><br /><em> $("#dm0m0i7td td:contains('Material Code')").each(function () {</em><br /><em> $(this).addClass( "gecdocZone3" );</em><br /><em> });</em><br /><em> $("#dm0m0i6td td:contains('Material Code')").each(function () {</em><br /><em> $(this).addClass( "gecdocZone3" );</em><br /><em> });</em><br /><em>});</em></td></tr></tbody></table><p style="text-align: left;">Content of the file skins/rhodiainteractive/gecdoc.css:</p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"><em>.gecdocZone1 {</em><br /><em> </em><br /><em> background-color:#97BE0E!important;</em><br /><em> cursor:pointer;</em><br /><em>}</em><br /><br /><em>.gecdocZone2 {</em><br /><em> cursor:pointer;</em><br /><em> background-color:#9ACCE5!important; </em><br /><em>}</em><br /><br /><em>.gecdocZone3 {</em><br /><em> cursor:pointer;</em><br /><em> background-color:#FF7F27!important; </em><br /><em>}</em><br /><br /><em>#search-input{</em><br /><em> width:105px;</em><br /><em>}</em></td></tr></tbody></table><h4 style="text-align: left;">Box Process guide chapter <span style="color: rgb(255,0,0);">(no longer used)</span></h4><hr style="text-align: left;" /><p style="text-align: left;">The box Process guide chapter is displayed only if the user has chosen the item PROCESS ENGINEERING in the box Discipline.</p><p style="text-align: left;">Setting of the box DCT_GEC_rho_dgi_process_guide (Process guide chapter):</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot256.png?version=1&modificationDate=1423467554878&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot256.png?version=1&modificationDate=1423467554878&api=v2"></p><h4 style="text-align: left;">CSV export</h4><hr style="text-align: left;" /><p style="text-align: left;">The export CSV is activated:</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot268.png?version=1&modificationDate=1423467556357&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot268.png?version=1&modificationDate=1423467556357&api=v2"></p><p style="text-align: left;">The fields that are exported is listed in the tab Export CSV of the profile:</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot269.png?version=1&modificationDate=1423467556862&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot269.png?version=1&modificationDate=1423467556862&api=v2"></p><h4 style="text-align: left;">Search on title in Advanced search (Issue with diacritical) <span style="color: rgb(255,0,0);">(no longer used)</span></h4><hr style="text-align: left;" /><p style="text-align: left;">In the advanced search users can make search on title through a suggestion:</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot270.png?version=1&modificationDate=1423467557870&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot270.png?version=1&modificationDate=1423467557870&api=v2"></p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot272.png?version=1&modificationDate=1423467559522&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot272.png?version=1&modificationDate=1423467559522&api=v2"></p><p style="text-align: left;">The title is stored in the field sourcestr19.</p><p style="text-align: left;">In the method GetSqlOverride we added this code:</p><table style="text-align: left;" class="confluenceTable"><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><em> else if (Str.EQNC(Session.Profile.Name, "DCT_QUALITY_GECDOC")){</em><br /><em> //and sourcestr4 contains</em><br /><em> </em><br /><em> colls = Regex.Matches(sql, "sourcestr([\\w]+) contains '([^']+)'");</em><br /><em> foreach (Match m in colls)</em><br /><em> {</em><br /><em> if (Str.Contains(m.Value, "sourcestr10"))</em><br /><em> {</em><br /><em> sql = Str.Replace(sql, m.Value,"sourcestr" + m.Groups[1].Value + " regexp '" + m.Groups[2].Value + ".*'");</em><br /><em> }</em><br /><em> if (Str.Contains(m.Value, "sourcestr18"))</em><br /><em> {</em><br /><em> sql = Str.Replace(sql, m.Value,"sourcestr" + m.Groups[1].Value + " regexp '" + m.Groups[2].Value + ".*'");</em><br /><em> }</em><br /><em> if (Str.Contains(m.Value, "sourcestr19"))</em><br /><em> {</em><br /><em> string valuegroup = RemoveDiacritics(m.Groups[2].Value);</em><br /><em> sql = Str.Replace(sql, m.Value,"sourcestr" + m.Groups[1].Value + " regexp '" + valuegroup + ".*' 'd'");</em><br /><em> }</em><br /><em> </em><br /><em> }</em><br /><em> </em><br /><em> }</em></th></tr></tbody></table><p style="text-align: left;">We created the function <em>RemoveDiacritics</em> to replace diacritics to fix issue<em> :</em></p><p style="text-align: left;"><br /></p><table style="text-align: left;" class="confluenceTable"><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><em>// Remove Diacritics for regexp function</em><br /><em> private string RemoveDiacritics(string result) </em><br /><em> {</em><br /><em> result = result.Replace('à', 'a');</em><br /><em> result = result.Replace('á', 'a');</em><br /><em> result = result.Replace('ä', 'a');</em><br /><em> result = result.Replace('â', 'a');</em><br /><em> result = result.Replace('ã', 'a');</em><br /><em> result = result.Replace('å', 'a');</em><br /><em> result = result.Replace('é', 'e');</em><br /><em> result = result.Replace('è', 'e');</em><br /><em> result = result.Replace('ê', 'e');</em><br /><em> result = result.Replace('ë', 'e');</em><br /><em> result = result.Replace('ì', 'i');</em><br /><em> result = result.Replace('í', 'i');</em><br /><em> result = result.Replace('ï', 'i');</em><br /><em> result = result.Replace('î', 'i');</em><br /><em> result = result.Replace('ò', 'o');</em><br /><em> result = result.Replace('ó', 'o');</em><br /><em> result = result.Replace('ô', 'o');</em><br /><em> result = result.Replace('ö', 'o');</em><br /><em> result = result.Replace('û', 'u');</em><br /><em> result = result.Replace('ü', 'u');</em><br /><em> result = result.Replace('ù', 'u');</em><br /><em> result = result.Replace('ú', 'u');</em><br /><em> result = result.Replace('ý', 'y');</em><br /><em> result = result.Replace('ÿ', 'y');</em><br /><em> result = result.Replace('ç', 'c');</em><br /><em> result = result.Replace('ñ', 'n'); </em><br /><em> return result;</em><br /><em> }</em></th></tr></tbody></table><h4 style="text-align: left;"><u>Multiple treesource1 value for GECDoc <span> </span></u><span style="color: rgb(255,0,0);">(no longer used)</span></h4><p style="text-align: left;">In order for the document type for the same documents in GECDoc to appear in both tree source "2. DISCIPLINE DOCUMENT" and "3. RELATED DOCUMENTS" branch "TEMPLATE", special configuration is required.<br /><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="119" width="277" src="https://wiki.solvay.com/download/attachments/6030248/image2016-1-13%2010%3A44%3A11.png?version=1&modificationDate=1452653078863&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2016-1-13%2010%3A44%3A11.png?version=1&modificationDate=1452653078863&api=v2"> </p><p style="text-align: left;">In the filemapping/GEC.DocumentType, Documentum value "TEMPLATE" will map to "/2. DISCIPLINE DOCUMENT/TEMPLATE~/3. RELATED DOCUMENTS/TEMPLATE". As the multiFileMapping function cannot support retrieving value which contains ";", "~" is used to replace the special character ";". </p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="250" width="502" src="https://wiki.solvay.com/download/attachments/6030248/image2016-1-13%2010%3A45%3A2.png?version=1&modificationDate=1452653131790&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2016-1-13%2010%3A45%3A2.png?version=1&modificationDate=1452653131790&api=v2"></p><p style="text-align: left;">In the Collection's mapping, using the replace function to replace "~" with ";" so as to store the value as a multi-value source tree.</p><table class="wysiwyg-macro" data-macro-name="code" data-macro-id="763fb834-1619-47ea-9351-a40ca1918bf5" aria-label="code macro" data-macro-parameters="language=c#|theme=Eclipse" data-macro-schema-version="1" style="background-image: url(https://wiki.syensqo.com/plugins/servlet/confluence/placeholder/macro-heading?definition=e2NvZGU6bGFuZ3VhZ2U9YyN8dGhlbWU9RWNsaXBzZX0&locale=en_GB&version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>Replace(MultiFileMapping("GEC.DocumentType",property.rho_doctype),"~",";")</pre></td></tr></table><p style="text-align: left;"><br /></p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="250" width="492" src="https://wiki.solvay.com/download/attachments/6030248/image2016-1-13%2010%3A49%3A42.png?version=1&modificationDate=1452653416074&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2016-1-13%2010%3A49%3A42.png?version=1&modificationDate=1452653416074&api=v2"></p><h3 style="text-align: left;">Force language for Qualité R&D project (DCT_QUALITY_QRD) <span style="color: rgb(255,0,0);">(no longer used)</span></h3><hr style="text-align: left;" /><p style="text-align: left;">For the interface Qualité (profile=DCT_QUALITY_DGI) , code in the plugin search.cs (OnPageStart() event) have been added to force the interface language to French if the language of the browser is different of French.</p><p style="text-align: left;"><em> if (Session.SessionUiLangStr != "fr" && Session.Profile.Name == "DCT_QUALITY_QRD") {<br /> Session.SetUiLanguage("fr");<br /> Session.RecalculateSessionUiLang();<br /> }</em></p><h3 style="text-align: left;">Linked documents for Qualité R&D project (DCT_QUALITY_QRD) <span style="color: rgb(255,0,0);">(no longer used)</span></h3><hr style="text-align: left;" /><p style="text-align: left;">In the results list linked documents can be displayed (in French Documents associés):</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot067.png?version=1&modificationDate=1423467542716&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot067.png?version=1&modificationDate=1423467542716&api=v2"></p><p style="text-align: left;">During the indexation the content of the property rrd_q_linked_documents is set in the field sourcecsv4 and the content of the property property.rrd_q_i_linked_id is set in the fieldsourcecsv5.</p><p style="text-align: left;">The property rrd_q_linked_documents contents the list (label) of the linked documents (ex: 4SREAMO003;4SREAMO002).</p><p style="text-align: left;">The property rrd_q_i_linked_id contents the list (id) of the linked documents (ex: 090166358004807a;0901663580048079).</p><p style="text-align: left;">In the search.cs plugin we added a code for the display (OnWriteDocBeforeResultLinks<em>)</em>:</p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><em>public override void OnWriteDocBeforeResultLinks(Doc doc){</em><br /><em> </em><br /><em> if (Str.EQNC(Session.Profile.Name, "DCT_QUALITY_QRD")){</em><br /><em> Hm.Write("<br>");</em><br /><em> Hm.Write("<span style=\"color:#000;\" >Document(s) associé(s) : </span>");</em><br /><em> </em><br /><em> int i,numberofdocsassoc;</em><br /><em> string[] turl;</em><br /><em> </em><br /><em> turl = doc.Url1.Split('=');</em><br /><em> </em><br /><em> ListStr listLibelle = ListStr.ListFromStr(doc.SourceCsv4, ';');</em><br /><em> ListStr listId = ListStr.ListFromStr(doc.SourceCsv5, ';');</em><br /><em> </em><br /><em> numberofdocsassoc = listLibelle.Count;</em><br /><em> </em><br /><em> if (listId.Count < numberofdocsassoc) numberofdocsassoc = listId.Count;</em><br /><em> </em><br /><em> if (listLibelle.Count > 0 && listId.Count > 0 && numberofdocsassoc > 0) {</em><br /><em> for (i = 0; i < numberofdocsassoc; i++)</em><br /><em> { </em><br /><em> if(Str.EQNC(listId[i],"0000000000000000")){</em><br /><em> Hm.Write(Ht.Text(listLibelle[i])," ");</em><br /><em> }</em><br /><em> else {</em><br /><em> Hm.Write("<a target=\"_blank\" href=\"",turl[0],"=", Ht.Text(listId[i]) ,"\" style=\"color:#0095D8;\">",Ht.Text(listLibelle[i]),"</a> ");</em><br /><em> }</em><br /><em> } </em><br /><em> }</em><br /><em> } </em><br /><em>}</em></th></tr></tbody></table><h3 style="text-align: left;">Rewritings : allow search on synonym</h3><p style="text-align: left;">With Sinequa it's possible to manage a list of synoms on which you can search.</p><p style="text-align: left;">An how-to page explains how yo implent it: <a href="https://acew1tsinesin01.eua.solvay.com/doc/en/Content/en.sinequa-es.how-to.rewritings.html?Highlight=rewriting" style="">https://acew1tsinesin01.eua.solvay.com/doc/en/Content/en.sinequa-es.how-to.rewritings.html?Highlight=rewriting</a></p><p style="text-align: left;">We implement it for two search interfaces : </p><ul style="text-align: left;"><li><a href="http://ehs-search.solvay.com/" style="">http://ehs-search.solvay.com</a></li><li><a href="http://aroma-commercialproductinformation-search.solvay.com/" style="">http://aroma-commercialproductinformation-search.solvay.com</a></li></ul><p style="text-align: left;">Example:</p><p style="text-align: left;">In <a href="http://ehs-search.solvay.com/" style="">http://ehs-search.solvay.com</a> if you search the word<span> </span><strong>PDMB</strong><span> </span>you will find documents that contains <strong>PARADIMETHOXYBENZENE:</strong></p><p style="text-align: left;"><strong><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="465" width="1249" src="https://wiki.solvay.com/download/attachments/6030248/image2018-3-21%2016%3A43%3A56.png?version=1&modificationDate=1521647036391&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2018-3-21%2016%3A43%3A56.png?version=1&modificationDate=1521647036391&api=v2"></strong></p><p style="text-align: left;">rewriting expression for thie example:</p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><p><span style="color: rgb(56,56,56);"><</span><span style="color: rgb(128,0,0);">rewriting</span><span> </span><span style="color: rgb(255,0,0);">lang</span><span style="color: rgb(56,56,56);">=</span><span style="color: rgb(0,0,255);">"en,fr"</span><span style="color: rgb(56,56,56);">></span><br /><span style="color: rgb(56,56,56);"><</span><span style="color: rgb(128,0,0);">patterns</span><span style="color: rgb(56,56,56);">></span><br /><span style="color: rgb(56,56,56);"><</span><span style="color: rgb(128,0,0);">form</span><span style="color: rgb(56,56,56);">></span>Paradimethoxybenzene<span style="color: rgb(56,56,56);"></</span><span style="color: rgb(128,0,0);">form</span><span style="color: rgb(56,56,56);">></span><br /><span style="color: rgb(56,56,56);"><</span><span style="color: rgb(128,0,0);">form</span><span style="color: rgb(56,56,56);">></span>PDMB<span style="color: rgb(56,56,56);"></</span><span style="color: rgb(128,0,0);">form</span><span style="color: rgb(56,56,56);">></span><br /><span style="color: rgb(56,56,56);"></</span><span style="color: rgb(128,0,0);">patterns</span><span style="color: rgb(56,56,56);">></span><br /><span style="color: rgb(56,56,56);"><</span><span style="color: rgb(128,0,0);">actions</span><span style="color: rgb(56,56,56);">></span><br /><span style="color: rgb(56,56,56);"><</span><span style="color: rgb(128,0,0);">erase</span><span> </span><span style="color: rgb(255,0,0);">when</span><span style="color: rgb(56,56,56);">=</span><span style="color: rgb(0,0,255);">"q"</span><span style="color: rgb(56,56,56);">></</span><span style="color: rgb(128,0,0);">erase</span><span style="color: rgb(56,56,56);">></span><br /><span style="color: rgb(56,56,56);"><</span><span style="color: rgb(128,0,0);">gen</span><span style="color: rgb(56,56,56);">></span>%Paradimethoxybenzene%<span style="color: rgb(56,56,56);"></</span><span style="color: rgb(128,0,0);">gen</span><span style="color: rgb(56,56,56);">></span><br /><span style="color: rgb(56,56,56);"></</span><span style="color: rgb(128,0,0);">actions</span><span style="color: rgb(56,56,56);">></span><br /><span style="color: rgb(56,56,56);"></</span><span style="color: rgb(128,0,0);">rewriting</span><span style="color: rgb(56,56,56);">></span></p></th></tr></tbody></table><p style="text-align: left;"><br /></p><p style="text-align: left;">Il you add new entries in a rewriting files you will have:</p><ul style="text-align: left;"><li>reload the tagger of the indexer: select '<strong>More actions</strong>' > '<strong>Reload tagger</strong>' menu of indexer </li><li><strong>Reload dictionaries if the Engine: </strong>select the '<strong>More actions</strong>' > '<strong>Reload dictionaries</strong>' menu of Engine</li><li>Reindex impacted documents (not sure ??)</li></ul><p style="text-align: left;">Storage of the rewrtings expressions : Indexing > Files > Rewritings</p><h3 style="text-align: left;">Public documents access for Documentum EHS application</h3><hr style="text-align: left;" /><p style="text-align: left;">We put in place a specific rule for "public" documents in Documentum: anybody of the AD can see documents that can be seen by the Documentum account intranet_generic_user. This account is member of the Documentum group ehs_intranet_users.<br />Access permissions are set by the import batch in Documemtum according to a security matrix. <br />If a document can be seen by the members of the group group ehs_intranet_users in Documentum it could be seen in Sinequa. <br />Note that users can open documents via Sinequa because no Documentum account is needed for this operation.</p><p style="text-align: left;">This rule was done in the domain mapping section:<br /> <img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot088.gif?version=1&modificationDate=1423467543605&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot088.gif?version=1&modificationDate=1423467543605&api=v2"></p><h3 style="text-align: left;">External Website for Carechem (not used now, replaced by new app Sachem)</h3><hr style="text-align: left;" /><p style="text-align: left;">For Carechem (new name <span style="color: rgb(34,34,34);"><span> </span><strong>NCEC</strong>)</span>, we gave an access to Sinequa for users outside the Rhodia network.</p><p style="text-align: left;">Users can access to the profile <a href="http://carechem-search.solvay.com/" style="">http://carechem-search.solvay.com</a> (<a href="http://wdcsqap21.eua.solvay.com/" style="">http://acew1psinesin01.eua.solvay.com/</a><span> </span><a href="http://wdcsqap21.eua.solvay.com/search?profile=FdsCarechem" style="">search?profile=FdsCarechem</a>) by this url:</p><p style="text-align: left;"><a href="https://fds-carechem-search.solvay.com/SnqCarechem/search" style="">https://fds-carechem-search.solvay.com/SnqCarechem/search</a></p><p style="text-align: left;">They need an AD account. Login / password: eua\carechem / tHHv871@zQ3</p><p style="text-align: left;">The reverse proxy had been configured to map connections.</p><p style="text-align: left;">To do this, in IIS we created the WebSite Extranet on the port 8081:</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot045.png?version=1&modificationDate=1423467539108&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot045.png?version=1&modificationDate=1423467539108&api=v2"></p><p style="text-align: left;">The security settings:</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot046.png?version=1&modificationDate=1423467539951&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030077/ScreenShot046.png?version=1&modificationDate=1423467539951&api=v2"></p><p style="text-align: left;">In the website Extranet where created an application SDS:</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" height="250" src="https://wiki.solvay.com/download/attachments/6030248/image2018-7-31%2017%3A51%3A13.png?version=1&modificationDate=1533052273955&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2018-7-31%2017%3A51%3A13.png?version=1&modificationDate=1533052273955&api=v2"></p><p style="text-align: left;"><br /></p><p style="text-align: left;">In the file F:/sinequa/sinequa.xml we added this section:</p><p style="text-align: left;"><em> <WebAppInfo></em><br /><em> <Name>WebAppVirtualSiteacew1psinesin01</Name></em><br /><em> <Path>F:\Sinequa\local-data-8081</Path></em><br /><em> <URLPaterns>http://*/Sinequa/*</URLPaterns></em><br /><em> </WebAppInfo></em></p><p style="text-align: left;"><em> </em></p><p style="text-align: left;"><strong>Content of F:/sinequa/sinequa.xml on 03.08.2017: </strong></p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><p><?xml version="1.0" encoding="utf-8"?><br /><Sinequa><br /><DataPath>G:\Sinequa\data</DataPath><br /><WebAppName>WebAppacew1psinesin01</WebAppName><br /><NodeName>Nodeacew1psinesin01</NodeName><br /><NodeData><br /><Identities><br /><Identity><br /><Number>0</Number><br /><User>SINEQUA_SVC_PRD</User><br /><Domain>EUA</Domain><br /></Identity><br /><Identity><br /><Number>1</Number><br /><User>SINEQUA_SVC_PRD</User><br /><Domain>EUA</Domain><br /></Identity><br /></Identities><br /></NodeData><br /><WebAppInfo><br /><Name>WebAppAutoCompletionacew1psinesin01</Name><br /><Path>F:\Sinequa\local-data-8089</Path><br /><URLPatterns>http://*/SnqAutoCompletion/*</URLPatterns><br /></WebAppInfo><br /><WebAppInfo><br /><Name>WebAppSnqChemtrecacew1psinesin01</Name><br /><Path>F:\Sinequa\local-data-8080</Path><br /><URLPatterns>http://*/SnqChemtrec/*</URLPatterns><br /></WebAppInfo><br /><WebAppInfo><br /><Name>WebAppSnqCarechemacew1psinesin01</Name><br /><Path>F:\Sinequa\local-data-8081</Path><br /><URLPatterns>http://*/SnqCarechem/*</URLPatterns><br /></WebAppInfo><br /><WebAppInfo><br /><Name>WebAppSnqNrccacew1psinesin01</Name><br /><Path>F:\Sinequa\local-data-8082</Path><br /><URLPatterns>http://*/SnqNrcc/*</URLPatterns><br /></WebAppInfo><br /><WebAppInfo><br /><Name>WebAppSnqNrccacew1psinesin01</Name><br /><Path>F:\Sinequa\local-data-8083</Path><br /><URLPatterns>http://*/SnqDivestitures/*</URLPatterns><br /></WebAppInfo><br /></Sinequa></p></th></tr></tbody></table><p style="text-align: left;"><em> </em></p><p style="text-align: left;">We created the file F:\sinequa\website\bin\sinequa_filter.cfg containing these data:</p><p style="text-align: left;"><em>//configuration for subsite 'sinequa' (<a href="http://localhost/sinequa/" style="">http://localhost/sinequa/</a>)</em><br /><em>+sinequa</em></p><p style="text-align: left;"><strong>Content of the file F:\sinequa\website\bin\sinequa_filter.cfg on 03.08.2017:</strong></p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><p>//configuration for subsite 'sinequa' (<a href="http://localhost/SnqSuggestions/" style="">http://localhost/SnqSuggestions/</a>)<br />+Sinequa<br />+SnqNrcc<br />+SnqCarechem<br />+SnqChemtrec<br />+SnqAutoCompletion<br />+SnqDivestitures</p></th></tr></tbody></table><p style="text-align: left;"><em> </em></p><p style="text-align: left;">We created the folder F:\sinequa\local-data-8081 by duplicating the folder F:\sinequa\local-data and after deleting the folders F:\sinequa\locla-data-8081\configuration and F:\sinequa\local-data-8081\status</p><p style="text-align: left;">In the Sinequa administration we created the WebApp WebAppVirtualSiteacew1psinesin01 (section Grid/WebApps)</p><p style="text-align: left;">The URL for the viewing of the document is change in the profile.</p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /><col class="" /><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><br /></th><th style="text-align: left;vertical-align: top;" class="confluenceTh">TEST</th><th style="text-align: left;vertical-align: top;" class="confluenceTh">PRODUCTION</th></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"> External URL</td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><s><a href="http://qa-carechem-search.solvay.com/carechem-sinequa" style="">http://qa-carechem-search.solvay.com/carechem-sinequa</a></s></p><p>NOT DISPONIBLE ON INTERNET</p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><a href="https://fds-carechem-search.solvay.com/SnqCarechem/" style="">https://fds-carechem-search.solvay.com/SnqCarechem/</a></td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"> Internal URL</td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><a href="http://carechem-search-test.solvay.com:8080/sinequa/" style="">http://carechem-search-test.solvay.com:8080/sinequa/</a></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><a href="http://carechem-search.solvay.com:8081/sinequa/" style="">http://carechem-search.solvay.com:8081/sinequa/</a></td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"> Expression for the URL display</td><td style="text-align: left;vertical-align: top;" class="confluenceTd"> Concat("<a style="">http://qa-carechem-search.solvay.com/FetchDoc/component/internetdrl?objectId=",SubStringFromEnd(id,0,16))</a></td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Concat("<a style="">http://fds-ecm.solvay.com/FetchDoc/drl.html?objectId=",SubStringFromEnd(id,0,16))</a></td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"> URL display</td><td style="text-align: left;vertical-align: top;" class="confluenceTd"> <a href="http://qa-carechem-search.solvay.com/FetchDoc/component/internetdrl?objectId=XXX" style="">http://qa-carechem-search.solvay.com/FetchDoc/component/internetdrl?objectId=XXX</a></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><a href="https://fds-ecm.solvay.com/FetchDoc/drl.html?objectId=" style="">https://fds-ecm.solvay.com/FetchDoc/drl.html?objectId=XXX</a></td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"> Reverse proxy associated</td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><a href="http://frlbiswt01.ema.priv.rhodia.com/" style="">frlbiswt01.ema.priv.rhodia.com</a><br />(FRPARIST07 & FRPARIST06)</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">WDCISP<span style="color: rgb(38,50,56);">04</span></td></tr></tbody></table><p style="text-align: left;"><ins>Note:</ins></p><p style="text-align: left;">If the configuration of Sinequa is changed, the changes will take effect on the WebSite Extranet (8081) after the restart of IIS or after a change by the admin:<br /><a href="http://wdcsqap21.eua.solvay.com/" style="">http://acew1psinesin01.eua.solvay.com:8081/</a><span> </span><a href="http://wdcsqap21.eua.solvay.com:8080/sinequa/admin" style="">sinequa/admin</a></p><p style="text-align: left;">(Login: eua\dtc_xxx )</p><h4 style="text-align: left;">Note #1</h4><p style="text-align: left;">We are waiting for agreement (Documentum team) to add 2 new external access:</p><p style="text-align: left;">Study information : <img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e2dkb2N1bWVudDpkb2NpZD0xWWJ2N3dzeDRDZG5QRHZxQ3JLWlhfdkU1ZnNzVThlOW9qUkl6ci00X3hiSX0&locale=en_GB&version=2" data-macro-name="gdocument" data-macro-id="ccbd1e0b-2b92-4161-ba2f-a227b2e97de9" role="button" tabindex="0" aria-haspopup="true" aria-label="gdocument macro" data-macro-parameters="docid=1Ybv7wsx4CdnPDvqCrKZX_vE5fssU8e9ojRIzr-4_xbI" data-macro-schema-version="1"></p><h4 style="text-align: left;">Note #2 added the 23.01.2017 by LR</h4><p style="text-align: left;"><span style="color: rgb(0,0,0);">After the removal of the prefix<span> </span><strong>eua</strong><span> </span>in all domains (operation done week 3-2017) the Carechem interface was not working.</span></p><p style="text-align: left;"><span style="color: rgb(0,0,0);">Operations done to fix the issue by LR:</span></p><ul style="text-align: left;"><li><span style="color: rgb(0,0,0);">Creation of the partition <strong>/Solvay_External_EHS/eua.solvay.external/</strong><span> </span> with name prefix equal to<span> </span><strong>eua\</strong>:</span></li><li><span style="color: rgb(0,0,0);"><img class="confluence-embedded-image confluence-external-resource" draggable="false" height="400" src="https://wiki.solvay.com/download/attachments/6030248/image2017-1-23%2016%3A14%3A37.png?version=1&modificationDate=1485184477809&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2017-1-23%2016%3A14%3A37.png?version=1&modificationDate=1485184477809&api=v2"></span></li><li><span style="color: rgb(0,0,0);">Creation of the domain mapping record:</span></li><li><span style="color: rgb(0,0,0);"><img class="confluence-embedded-image confluence-external-resource" draggable="false" height="400" src="https://wiki.solvay.com/download/attachments/6030248/image2017-1-23%2016%3A13%3A46.png?version=1&modificationDate=1485184426403&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2017-1-23%2016%3A13%3A46.png?version=1&modificationDate=1485184426403&api=v2"></span></li><li><span style="color: rgb(0,0,0);">Change of the security domain of the WebApp <strong>WebAppSnqCarechemacew1psinesin01</strong></span></li><li><span style="color: rgb(0,0,0);"><img class="confluence-embedded-image confluence-external-resource" draggable="false" height="250" src="https://wiki.solvay.com/download/attachments/6030248/image2017-1-23%2016%3A16%3A8.png?version=1&modificationDate=1485184568281&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2017-1-23%2016%3A16%3A8.png?version=1&modificationDate=1485184568281&api=v2"></span></li></ul><p style="text-align: left;"><span style="color: rgb(255,0,0);"> </span></p><p style="text-align: left;"><span style="color: rgb(255,0,0);"> </span></p><h3 style="text-align: left;">SILICA ROCS - display the contact of a site (no longer used now)</h3><hr style="text-align: left;" /><p style="text-align: left;">For the interface <a href="http://silica-search.solvay.com/search" style="">http://silica-search.solvay.com/search</a> when a user selects a site in the box PRODUCTION SITE the contact associated to the site will be displayed in the box SITE CONTACT.</p><p style="text-align: left;">We created the file (Files/File Mappings) Sites_Contacts_SILICA_ROCS (<a class="form-table-link" href="http://frparsqap01.ema.priv.rhodia.com/form?form=file&datatype=file&dataname=%2Ffilemapping%2FSites_Contacts_SILICA_ROCS%2F" style="">G:\sinequa\data\configuration\files\filemapping\Sites_Contacts_SILICA_ROCS.txt</a>) :</p><table style="text-align: left;" class="confluenceTable"><tbody class=""><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">DELPORTE Isabelle;Collonges<br />PALHARES Luciana;Paulinia<br />ARCE Jesus;Barquisimeto<br />SHI Feng;Qingdao Chengyang<br />STRICKLER Rachel;Chicago Heights<br />PARENTI Matteo;Livorno<br />SHI Feng;Qingdao Licang<br />LEE Sung-Ho;Incheon</td></tr></tbody></table><p style="text-align: left;">This file contains the list of contacts for each sites.</p><p style="text-align: left;">For the collection /Documentum/silica_rocs/ in the Mapping tab we added this entry:</p><table style="text-align: left;" class="confluenceTable"><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh">sourcestr26</th><th style="text-align: left;vertical-align: top;" class="confluenceTh"><p>FileMapping("Sites_Contacts_FAST_SILICA_ROCS",property.sol_doc_site)</p></th></tr></tbody></table><p style="text-align: left;">For the box DCT_FAST_site_contact we added this line:</p><p style="text-align: left;"><br /></p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="75" width="364" src="https://wiki.solvay.com/download/attachments/6030248/image2016-5-10%2011%3A2%3A54.png?version=1&modificationDate=1462870974999&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2016-5-10%2011%3A2%3A54.png?version=1&modificationDate=1462870974999&api=v2"></p><p style="text-align: left;"><br /></p><p style="text-align: left;">In the plugin search.cs we modified the function IsUsed :</p><p style="text-align: left;"><br /></p><table class="relative-table confluenceTable" style="width: 241.925px;"><colgroup class=""><col class="" style="width: 241.125px;" /></colgroup><tbody class=""><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"><em>public bool IsUsed(Result result, string boxname, string comp_operator, string value)</em><br /><em> {</em><br /><em> bool bok = false;</em><br /><em> int c = result.Query.GetSelectionCount();</em><br /><em> int i = 0;</em><br /><em> for (i = 0; i < c; i++)</em><br /><em> {</em><br /><em> Selection sel = result.Query.GetSelection;</em><br /><em> if (sel.Type == SelectionType.Simple)</em><br /><em> {</em><br /><em> SelectionSimple simple = (SelectionSimple)sel;</em><br /><em> if (Str.EQNC(simple.BoxName, boxname))</em><br /><em> {</em><br /><em> if (Str.EQ(comp_operator, "="))</em><br /><em> {</em><br /><em> if (Str.EQNC(simple.Value, value)) return true;</em><br /><em> }</em><br /><em> else if (Str.EQ(comp_operator, "notempty"))</em><br /><em> {</em><br /><em> </em><br /><em> //Sys.Log2(1, "BINGO " + simple.Value );</em><br /><em> //if (!Str.IsEmpty(simple.Value)) Sys.Log2(1, "BINGO2 " + simple.Value );</em><br /><em> </em><br /><em> if (!Str.IsEmpty(simple.Value)) return true;</em><br /><em> }</em><br /><em> else</em><br /><em> {</em><br /><em> if (Str.IndexOfNoCase(simple.Value, value) > -1) return true;</em><br /><em> }</em><br /><em> }</em><br /><em> }</em><br /><em> }</em><br /><br /><em> return bok;</em><br /><em> }</em></td></tr></tbody></table><p style="text-align: left;"><br /></p><h3 style="text-align: left;">Synonym - Searching for similar words</h3><hr style="text-align: left;" /><p style="text-align: left;">In order to include search words with the similar meaning, in Sinequa, we used the "synonyme" in the "Synonyms" under the "Advanced" → "Files".</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="599" width="241" src="https://wiki.solvay.com/download/attachments/6030248/image2016-5-10%2013%3A31%3A33.png?version=1&modificationDate=1462858294806&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2016-5-10%2013%3A31%3A33.png?version=1&modificationDate=1462858294806&api=v2"></p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh">Synonym words</th></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">america;americas</td></tr></tbody></table><h3 style="text-align: left;">Implement Info Box in RCSEHS skin</h3><hr style="text-align: left;" /><p style="text-align: left;">User request to add a special note in RCSEHS search profile:</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" height="400" src="https://wiki.solvay.com/download/attachments/6030248/image2018-6-12%2011%3A36%3A13.png?version=1&modificationDate=1528774573982&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2018-6-12%2011%3A36%3A13.png?version=1&modificationDate=1528774573982&api=v2"></p><p style="text-align: left;">Related CSS is implemented in F:\Sinequa\website\skins\rhodiainteractive\rhodia.css</p><table class="relative-table confluenceTable" style="width: 671.162px;"><colgroup class=""><col class="" style="width: 670.362px;" /></colgroup><tbody class=""><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p>.confluence-information-macro {background:#fcfcfc;border:1px solid #ccc;-moz-border-radius:5px;-webkit-border-radius:5px;border-radius:5px;color:#333;margin:10px 0 1em 0;min-height:20px;padding:10px 10px 10px 36px;position:relative}</p><p>.confluence-information-macro-tip {background-color:#f3f9f4;border-color:#91c89c}<br />.confluence-information-macro .confluence-information-macro-icon.aui-iconfont-approve {color:#14892c}<br />.confluence-information-macro>.confluence-information-macro-body>p:empty{display:none}<br />.aui-icon-small {line-height: 0;position: relative;vertical-align: text-top;}<br />.aui-icon-small:before {<br />color: inherit;<br />font-family: "Atlassian Icons";<br />font-weight: normal;<br />-webkit-font-smoothing: antialiased; /* Improves the rendering of icons */<br />font-style: normal;<br />left: -30;<br />line-height: 1;<br />position: absolute;<br />text-indent: 0;<br />speak: none; /* This prevents screen readers from pronouncing the pseudo element text content used to trigger the icon font */<br />top: 8;<br />}<br />.aui-iconfont-approve:before{content:url("tips.gif")}</p></td></tr></tbody></table><p style="text-align: left;"><br /></p><p style="text-align: left;">A new image is introduced in F:\Sinequa\website\skins\rhodiainteractive\tips.gif</p><p style="text-align: left;">A new javascript is implemented in F:\Sinequa\website\skins\rhodiainteractive\config_rcsehs2_only.js</p><table class="relative-table confluenceTable" style="width: 1633.0px;"><colgroup class=""><col class="" style="width: 0.0px;" /></colgroup><tbody class=""><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p>// Create a flashing banner based on user request</p><p>var txt = "For some countries we have to use a dedicated SDS variant to comply with local regulations. For the others, we rely on the more generic \"United Nations\" variant (\"SDS_UN\"). to consult which variant is appropriate for which country, click on the button \"List of SDS variants by country\" above";</p><p>// create elements <table> and a <tbody></p><p>var body = document.getElementById("search-table");</p><p>var tr = body.insertRow(1); var td = tr.insertCell(0);</p><p>var td2 = tr.insertCell(1);</p><p>td2.innerHTML = ("<div class=\"confluence-information-macro confluence-information-macro-tip\"><span class=\"aui-icon aui-icon-small aui-iconfont-approve confluence-information-macro-icon\"></span><div class=\"confluence-information-macro-body\"><p>" + txt.fontsize(2) + "</p></div></div>");</p></td></tr></tbody></table><p style="text-align: left;"><br /></p><h3 style="text-align: left;"><span style="color: rgb(0,51,102);">RegWatch</span></h3><p style="text-align: left;"><span style="color: rgb(0,51,102);">The search interface RegWatch is based on a AoDocs library. Some documents have several files attached. When Sinequa indexes documents having several files it creates a record for each files in the index. The key user wanted to group files to the document.</span></p><p style="text-align: left;"><span style="color: rgb(0,51,102);">Display for a document having 3 files attached:</span></p><p style="text-align: left;"><span style="color: rgb(0,51,102);"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="233" width="938" src="https://wiki.solvay.com/download/attachments/6030248/image-2024-2-12_17-42-12.png?version=1&modificationDate=1707756132515&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image-2024-2-12_17-42-12.png?version=1&modificationDate=1707756132515&api=v2"></span></p><p style="text-align: left;"><br /></p><p style="text-align: left;">To implement this feature, we created a script executed after the indexation. ( \\acew1tsinesin01\works\regwatch_ECO\regwatch.cmd )</p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh">echo %date% %time% ++ Start of regwatch.cmd >> F:\works\regwatch_ECO\regwatch.log<br />call F:\works\regwatch_ECO\export_sourcestr22.cmd <br />PowerShell -File F:\works\regwatch_ECO\updatesinequa.ps1<br />call F:\Sinequa\website\bin\scmd.exe execsql @F:\works\regwatch_ECO\update_main_doc.sql localhost 10300 > F:\works\regwatch_ECO\update_main_doc.sql.log<br />echo %date% %time% ++ End of regwatch.cmd >> F:\works\regwatch_ECO\regwatch.log</th></tr></tbody></table><p style="text-align: left;"><br /></p><p style="text-align: left;"><span style="color: rgb(0,51,102);">F:\works\regwatch_ECO\export_sourcestr22.cmd :</span></p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh">F:\Sinequa\website\bin\scmd.exe ExecSqlCsv "select sourcestr22 from idx_AoDOcs where collection='/AoDocs/RegWatch Database/' and sourcestr22 <> '' group by sourcestr22 order by sourcestr22 asc" F:\works\regwatch_ECO\export_sourcestr22.csv ";" localhost 10300 </th></tr></tbody></table><p style="text-align: left;"><br /></p><p style="text-align: left;"><span style="color: rgb(0,51,102);">export_sourcestr22.sql :</span></p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><p>sourcestr22;cachehit;rowfetchtime;processingtime;matchingrowcount;postgroupbymatchingrowcount<br /><a href="https://ao-docs.appspot.com/?aodocs-domain=solvay.com&#Menu_libraryHome/LibraryId_SyHKCxq19n8V1Rw9Ij;0;1.44" style="">https://ao-docs.appspot.com/?aodocs-domain=solvay.com&#Menu_libraryHome/LibraryId_SyHKCxq19n8V1Rw9Ij;0;1.44</a><span> </span>ms;53.31 ms;12487;7202<br /><a href="https://ao-docs.appspot.com/?aodocs-domain=solvay.com&#Menu_viewDoc/LibraryId_SyHKCxq19n8V1Rw9Ij/DocumentId_TdlqFys0RfK94j8csS" style="">https://ao-docs.appspot.com/?aodocs-domain=solvay.com&#Menu_viewDoc/LibraryId_SyHKCxq19n8V1Rw9Ij/DocumentId_TdlqFys0RfK94j8csS</a><br /><a href="https://ao-docs.appspot.com/?aodocs-domain=solvay.com&#Menu_viewDoc/LibraryId_SyHKCxq19n8V1Rw9Ij/DocumentId_Tdq2zYdsZ2PUJ0vvMw" style="">https://ao-docs.appspot.com/?aodocs-domain=solvay.com&#Menu_viewDoc/LibraryId_SyHKCxq19n8V1Rw9Ij/DocumentId_Tdq2zYdsZ2PUJ0vvMw</a><br /><a href="https://ao-docs.appspot.com/?aodocs-domain=solvay.com&#Menu_viewDoc/LibraryId_SyHKCxq19n8V1Rw9Ij/DocumentId_Te2OU2TuK3CWdKodUY" style="">https://ao-docs.appspot.com/?aodocs-domain=solvay.com&#Menu_viewDoc/LibraryId_SyHKCxq19n8V1Rw9Ij/DocumentId_Te2OU2TuK3CWdKodUY</a><br /><a href="https://ao-docs.appspot.com/?aodocs-domain=solvay.com&#Menu_viewDoc/LibraryId_SyHKCxq19n8V1Rw9Ij/DocumentId_TezgeKmuWVtgRYhyvX" style="">https://ao-docs.appspot.com/?aodocs-domain=solvay.com&#Menu_viewDoc/LibraryId_SyHKCxq19n8V1Rw9Ij/DocumentId_TezgeKmuWVtgRYhyvX</a><br /><a href="https://ao-docs.appspot.com/?aodocs-domain=solvay.com&#Menu_viewDoc/LibraryId_SyHKCxq19n8V1Rw9Ij/DocumentId_Tf4UYKd7BtJ4lOXSNl" style="">https://ao-docs.appspot.com/?aodocs-domain=solvay.com&#Menu_viewDoc/LibraryId_SyHKCxq19n8V1Rw9Ij/DocumentId_Tf4UYKd7BtJ4lOXSNl</a></p><p>....</p></th></tr></tbody></table><p style="text-align: left;"><br /></p><p style="text-align: left;"><span style="color: rgb(0,51,102);">This file contains the list of documents in AoDocs (not the files).</span></p><p style="text-align: left;"><br /></p><p style="text-align: left;"><span style="color: rgb(0,51,102);">The script updatesinequa.ps1 genrates a file like this wich is executed:</span></p><table class="relative-table confluenceTable" style="width: 788.8px;"><colgroup class=""><col class="" style="width: 788.0px;" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><p>update idx_AoDocs set sourcestr23 = 'Main',sourcecsv6='' where collection ='/AoDocs/RegWatch Database/' and id='/AoDocs/RegWatch Database/|document/TdlqFys0RfK94j8csS/1nsOoz7nVPRx_SoPdxbLsL_LsulauCTXntHHUW6Os3wc' ;</p><p><br />update idx_AoDocs set sourcestr23 = 'Main',sourcecsv6='<a href="https://docs.google.com/document/d/17c49izfceHzbct_TzFkqSeAfht_LNVUBn_GuVeBS43M/edit?usp=drivesdk;https://docs.google.com/document/d/1ptLzdVsOqgZ0rkblIgPuS5L6E_BA81tpsQzi7NlDP2E/edit?usp=drivesdk;https://docs.google.com/spreadsheets/d/1WLoZN2yJjwC9An41WyzOOVn9w13RBIUZJKj2AaP-UrM/edit?usp=drivesdk" style="">https://docs.google.com/document/d/17c49izfceHzbct_TzFkqSeAfht_LNVUBn_GuVeBS43M/edit?usp=drivesdk;https://docs.google.com/document/d/1ptLzdVsOqgZ0rkblIgPuS5L6E_BA81tpsQzi7NlDP2E/edit?usp=drivesdk;https://docs.google.com/spreadsheets/d/1WLoZN2yJjwC9An41WyzOOVn9w13RBIUZJKj2AaP-UrM/edit?usp=drivesdk</a>' where collection ='/AoDocs/RegWatch Database/' and id='/AoDocs/RegWatch Database/|document/Tdq2zYdsZ2PUJ0vvMw/1F52JwGoon5Um9w_tDrUlLx8mq1RhRNAUfYZirAspZdM' ;</p><p><br />update idx_AoDocs set sourcestr23 = 'Main',sourcecsv6='' where collection ='/AoDocs/RegWatch Database/' and id='/AoDocs/RegWatch Database/|document/Te2OU2TuK3CWdKodUY/1vE2Lhek6F281jjta1F4ITIgQn6rfj1RV' ;</p><p><br />update idx_AoDocs set sourcestr23 = 'Main',sourcecsv6='' where collection ='/AoDocs/RegWatch Database/' and id='/AoDocs/RegWatch Database/|document/TezgeKmuWVtgRYhyvX/1GNXpDm_NkJN08LZ3MoOj0FSuYcL64P_7' ;</p><p><br />update idx_AoDocs set sourcestr23 = 'Main',sourcecsv6='<a href="https://drive.google.com/file/d/1UCFuweka0BKNpCfgB576zlaH0_QPpeHy/view?usp=drivesdk;https://drive.google.com/file/d/1oHhF9HFBH8xvKhFag2q5lmDUZcSh6V52/view?usp=drivesdk;https://drive.google.com/file/d/10_04bLyjYIkeew582ac_xQyaEJWKebCz/view?usp=drivesdk;https://drive.google.com/file/d/1o6FeYipl98Tus3776JaCl84LIjRJqaVy/view?usp=drivesdk;https://drive.google.com/file/d/1ehNkXIUgzDSe1uq9iHA9U0Ukr3zfPhWg/view?usp=drivesdk;https://drive.google.com/file/d/1LHv24BDdG74XhHpxrm8-mk-GCEVYIr8S/view?usp=drivesdk;https://drive.google.com/file/d/1JkdKCqug2m-fUXHDrC-JbzpoTnrcMFLc/view?usp=drivesdk" style="">https://drive.google.com/file/d/1UCFuweka0BKNpCfgB576zlaH0_QPpeHy/view?usp=drivesdk;https://drive.google.com/file/d/1oHhF9HFBH8xvKhFag2q5lmDUZcSh6V52/view?usp=drivesdk;https://drive.google.com/file/d/10_04bLyjYIkeew582ac_xQyaEJWKebCz/view?usp=drivesdk;https://drive.google.com/file/d/1o6FeYipl98Tus3776JaCl84LIjRJqaVy/view?usp=drivesdk;https://drive.google.com/file/d/1ehNkXIUgzDSe1uq9iHA9U0Ukr3zfPhWg/view?usp=drivesdk;https://drive.google.com/file/d/1LHv24BDdG74XhHpxrm8-mk-GCEVYIr8S/view?usp=drivesdk;https://drive.google.com/file/d/1JkdKCqug2m-fUXHDrC-JbzpoTnrcMFLc/view?usp=drivesdk</a>' where collection ='/AoDocs/RegWatch Database/' and id='/AoDocs/RegWatch Database/|document/Tf4UYKd7BtJ4lOXSNl/1IKKnR1gq3NvrHdIgmHAvAUY7AlsjXEuH' ;</p><p>...</p></th></tr></tbody></table><p style="text-align: left;"><br /></p><h3 style="text-align: left;"><span style="color: rgb(0,51,102);">Salesforce integration in MySolvayPortal</span></h3><p style="text-align: left;">MySolvayPortal (previously CEP) is a customer portal developed in Salesforce environment. Customers and distributors can search for documents (SDS, TDS,...) and download them.</p><p style="text-align: left;">Documentation Salesforce developer done during the project:</p><p style="text-align: left;"><a href="https://docs.google.com/document/d/1QvJ2vPCAw2rI-fWyeqiYDuTrdEDYHIgKsxZ-ZgYUFio/edit?usp=drivesdk" style="">MySolvayPortal - Sinequa : technical specifications to search documents in Sinequa with rest API</a></p><p style="text-align: left;"><a href="https://docs.google.com/document/d/15ZdgGR-1r0jQn2KE-yku5hOzmum4ieBMsU-4K6HNzRM/edit?usp=drivesdk" style="">MySolvayPortal - Documentum: get and display content of a document stored in Documentum (SDS, RDS & TDS)</a></p><p style="text-align: left;"><br /></p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="250" width="642" src="https://wiki.solvay.com/download/attachments/6030248/image2019-8-5_16-27-26.png?version=1&modificationDate=1565015247082&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2019-8-5_16-27-26.png?version=1&modificationDate=1565015247082&api=v2"></p><p style="text-align: left;"><br /></p><p style="text-align: left;">Salesforce is able to make search with Sinequa API Rest.</p><p style="text-align: left;">Example of query:</p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><p><span style="color: rgb(0,0,0);">{ <br /></span><span style="color: rgb(0,0,0);"> "method": "search.profile",<br /></span><span style="color: rgb(0,0,0);"> "profile": "DCT_RCSEHS_SDS_CEP",<br /></span><span style="color: rgb(0,0,0);"> "responseType": "SearchResult",</span></p><p><span style="color: rgb(0,0,0);"> "query": { "text": "oxygen" ,</span></p><p><span style="color: rgb(0,0,0);"> "advanced": [{"type": "simple",<br /></span><span style="color: rgb(0,0,0);"> "name": "sourcestr41",</span></p><p><span style="color: rgb(0,0,0);"> "op": "eq",<br /></span><span style="color: rgb(0,0,0);"> "value": "EN"</span></p><p><span style="color: rgb(0,0,0);"> },</span></p><p><span style="color: rgb(0,0,0);">{"type": "simple",</span></p><p><span style="color: rgb(0,0,0);"> "name": "sourcestr26",<br /></span><span style="color: rgb(0,0,0);"> "op": "eq",<br /></span><span style="color: rgb(0,0,0);"> "value": "USA"</span></p><p><span style="color: rgb(0,0,0);"> },</span></p><p><span style="color: rgb(0,0,0);"> {"type": "multi",<br /></span><span style="color: rgb(0,0,0);"> "name": "sourcestr2", <br /></span><span style="color: rgb(0,0,0);"> "op": "eq", <br /></span><span style="color: rgb(0,0,0);"> "Values": [ "P00000021959 ", "P00000019931", "P00000033143", "P00000028144", "P00000015289", "P00000000334", "P00000031407", "P00000031406" </span></p><p><span style="color: rgb(0,0,0);">]} </span></p><p><span style="color: rgb(0,0,0);"> ]</span></p><p><span style="color: rgb(0,0,0);"> } </span><span style="color: rgb(0,0,0);"> </span></p><p><span style="color: rgb(0,0,0);">}</span></p></th></tr><tr class=""><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><br /></td></tr></tbody></table><p style="text-align: left;"><br /></p><h4 style="text-align: left;">URLs and accounts</h4><table class="relative-table confluenceTable" style="width: 1950.16px;"><colgroup class=""><col class="" style="width: 101.6px;" /><col class="" style="width: 613.45px;" /><col class="" style="width: 613.45px;" /><col class="" style="width: 592.062px;" /><col class="" style="width: 28.8px;" /></colgroup><tbody class=""><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"><br /></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p style="text-align: center;"><span style="color: rgb(0,0,0);">INTEGRATION</span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p style="text-align: center;"><span style="color: rgb(0,0,0);">TEST (=UAT = PRE-PRODUCTION)</span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p style="text-align: center;"><span style="color: rgb(0,0,0);">PRODUCTION</span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><br /></td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">Sinequa URL Rest</span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(80,80,80);"><a href="http://product-documentation-search-test.solvay.com:8088/xrest" style="">http://product-documentation-search-test.solvay.com:8088/xrest</a></span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(80,80,80);"><a href="http://product-documentation-search-test.solvay.com:8088/xrest" style="">http://product-documentation-search-test.solvay.com:8088/xrest</a></span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(80,80,80);"><a href="http://product-documentation-search.solvay.com:8088/xrest" style="">http://product-documentation-search.solvay.com:8088/xrest</a></span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><br /></td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">URL for test display (html)</span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);"><a href="http://product-documentation-search-test.solvay.com:8088/search?profile=XXXX" style="">http://product-documentation-search-test.solvay.com:8088/search?profile=XXX</a></span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);"><a href="http://product-documentation-search-test.solvay.com:8088/search?profile=XXX" style="">http://product-documentation-search-test.solvay.com:8088/search?profile=XXX</a></span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);"><a href="http://product-documentation-search.solvay.com:8088/search?profile=XXX" style="">http://product-documentation-search.solvay.com:8088/search?profile=XXX</a></span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><br /></td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">login</span></p><p><span style="color: rgb(0,0,0);">(used by Webmethod)</span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">EUA\Wsinequa</span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">EUA\Wsinequa</span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">EUA\Wsinequa (used by Webmethod) </span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><br /></td></tr><tr class=""><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd">Webmethod</td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><span><a href="https://b2bsim.solvay.com/rest/SolvayDocumentation/output/webservice/searchDocuments" style=""><span style="color: rgb(17,85,204);">https://b2bsim.solvay.com:443/rest/SolvayDocumentation/output/webservice/searchDocuments</span></a></span></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><span><a href="https://b2bsim.solvay.com/rest/SolvayDocumentation/output/webservice/searchDocuments" style=""><span style="color: rgb(17,85,204);">https://b2bsim.solvay.com:443/rest/SolvayDocumentation/output/webservice/searchDocuments</span></a></span></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><span><a href="https://b2b.solvay.com/rest/SolvayDocumentation/output/webservice/searchDocuments" style=""><span style="color: rgb(17,85,204);">https://b2b.solvay.com:443/rest/SolvayDocumentation/output/webservice/searchDocuments</span></a></span></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><br /></td></tr><tr class=""><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd">Login Webmethod (used by salesforce)</td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><span><span style="color: rgb(0,0,0);">salesforcecrm / salesforcecrm</span></span></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><span style="color: rgb(0,0,0);">salesforcecrm /<span> </span></span><span style="color: rgb(0,0,0);">salesforcecrm</span></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><span style="color: rgb(0,0,0);">salesforcecrm / ****** (ask password to Webmethod team or salesforce team)</span></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><br /></td></tr></tbody></table><h4 style="text-align: left;">Profiles created for Salesforce</h4><p style="text-align: left;"><span> </span></p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" style="width: 313.0px;" /><col class="" style="width: 250.0px;" /><col class="" style="width: 258.0px;" /><col class="" style="width: 222.0px;" /><col class="" style="width: 116.0px;" /></colgroup><tbody class=""><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"><strong>Use</strong></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p style="text-align: center;"><strong><span style="color: rgb(0,0,0);">INTEGRATION</span></strong></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p style="text-align: center;"><strong><span style="color: rgb(0,0,0);">TEST</span></strong></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p style="text-align: center;"><strong><span style="color: rgb(0,0,0);">PRODUCTION</span></strong></p></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><strong>Comment</strong></td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><strong><span style="color: rgb(0,0,0);">get SDS (docbase RCSEHS)</span></strong></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_RCSEHS_SDS_CEP_INT</span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_RCSEHS_SDS_CEP_TEST</span></p></td><td style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_RCSEHS_SDS_CEP</span></p></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><br /></td></tr><tr class=""><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><strong>get certificates (docbase RCSEHS)</strong></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_RCSEHS_CERTIFICATES_CEP_INT</span></p></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_RCSEHS_CERTIFICATES_CEP_TEST</span></p></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_RCSEHS_CERTIFICATES_CEP</span></p></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><br /></td></tr><tr class=""><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><strong>get RDS (docbase RCSEHS)</strong></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_RCSEHS_RDS_CEP_INT</span></p></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_RCSEHS_RDS_CEP_TEST</span></p></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_RCSEHS_RDS_CEP</span></p></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><span>Only Novecare</span></td></tr><tr class=""><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><strong>get TDS (docbase RCSDOC)</strong></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_RCSDOC_TDS_CEP_INT</span></p></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_RCSDOC_TDS_CEP_TEST</span></p></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_RCSDOC_TDS_CEP</span></p></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span>Only Novecare</span></p><p><span>Not used ?</span></p></td></tr><tr class=""><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><strong>get TDS, Statement & Brochure (docbase FAST)</strong></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_FAST_PRODOC_CEP_INT</span></p></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_FAST_PRODOC_CEP_TEST</span></p></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><p><span style="color: rgb(0,0,0);">DCT_FAST_PRODOC_CEP</span></p></td><td colspan="1" style="text-align: left;vertical-align: top;" class="confluenceTd"><br /></td></tr></tbody></table><h4 style="text-align: left;">Postman configuration example</h4><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="250" width="1077" src="https://wiki.solvay.com/download/attachments/6030248/image2019-8-5_17-3-17.png?version=1&modificationDate=1565017397396&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2019-8-5_17-3-17.png?version=1&modificationDate=1565017397396&api=v2"></p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="250" width="1037" src="https://wiki.solvay.com/download/attachments/6030248/image2019-8-5_17-3-49.png?version=1&modificationDate=1565017429080&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2019-8-5_17-3-49.png?version=1&modificationDate=1565017429080&api=v2"></p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="637" width="1243" src="https://wiki.solvay.com/download/attachments/6030248/image2019-8-5_17-7-23.png?version=1&modificationDate=1565017643161&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2019-8-5_17-7-23.png?version=1&modificationDate=1565017643161&api=v2"></p><h2 style="text-align: left;">SSL for Sinequa's IIS</h2><table class="wysiwyg-macro" data-macro-name="info" data-macro-id="6dfff148-cab3-49ca-b6df-a868056869b4" aria-label="info macro" data-macro-parameters="title=Folder for SSL generated" data-macro-schema-version="1" style="background-image: url(https://wiki.syensqo.com/plugins/servlet/confluence/placeholder/macro-heading?definition=e2luZm86dGl0bGU9Rm9sZGVyIGZvciBTU0wgZ2VuZXJhdGVkfQ&locale=en_GB&version=2); background-repeat: no-repeat;" data-macro-body-type="RICH_TEXT"><tr><td class="wysiwyg-macro-body"><p><a href="https://drive.google.com/drive/folders/1PBbRI28FrcGwe2hTZKl7OqbaiUhVuON6" style="">https://drive.google.com/drive/folders/1PBbRI28FrcGwe2hTZKl7OqbaiUhVuON6</a></p></td></tr></table><h3 style="text-align: left;">Pre-<span style="color: rgb(34,34,34);">requisite</span>:</h3><ul style="text-align: left;"><li>Make sure your computer has OpenSSL installed or go to WDCISWD21 server.</li><li>Get the files generated previously from the link provided "Folder for SSL generated" above.</li><li>Read up on the article - <a href="https://wiki.solvay.com/display/TECHWEB/Setup+a+SAN+SSL+Certificate+for+Intranet+Application">Setup a SAN SSL Certificate for Intranet Application</a>.</li></ul><h3 style="text-align: left;">Adding/Removing domains from the SSL</h3><ol style="text-align: left;"><li>Update the "[ alt_names ]" within sinequa-test.cnf or sinequa-prod.cnf file.<br /><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030248/image2020-8-25_12-32-19.png?version=1&modificationDate=1598329940747&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2020-8-25_12-32-19.png?version=1&modificationDate=1598329940747&api=v2"></li><li>Execute the "generateCSR.bat" to generate the sinequa-test/prod.csr</li><li>Send the CSR to <a href="mailto:ad.operations@solvay.com" style="">ad.operations@solvay.com</a> team to get the signed CSR.</li><li>You will receive the signed CSR as .cer file.</li><li>Execute the "convertCERtoPFX.bat" to convert the .cer to .pfx file.<br />You will be asked to enter the password for encoding the key into this .pfx. Use "Solvay".</li><li>Install the pfx into the IIS and bind the port 443 and 8085 with this cert.</li><li>No need to restart the IIS.</li></ol><table class="wysiwyg-macro" data-macro-name="info" data-macro-id="db379944-ea63-414b-9c40-9ac2115fd1f7" aria-label="info macro" data-macro-parameters="title=Test Environment SSL Location" data-macro-schema-version="1" style="background-image: url(https://wiki.syensqo.com/plugins/servlet/confluence/placeholder/macro-heading?definition=e2luZm86dGl0bGU9VGVzdCBFbnZpcm9ubWVudCBTU0wgTG9jYXRpb259&locale=en_GB&version=2); background-repeat: no-repeat;" data-macro-body-type="RICH_TEXT"><tr><td class="wysiwyg-macro-body"><p>I:\SSL\</p></td></tr></table><table class="wysiwyg-macro" data-macro-name="info" data-macro-id="f5e937e1-a86e-4947-94e8-e28471aa35ed" aria-label="info macro" data-macro-parameters="title=Prod Environment SSL Location" data-macro-schema-version="1" style="background-image: url(https://wiki.syensqo.com/plugins/servlet/confluence/placeholder/macro-heading?definition=e2luZm86dGl0bGU9UHJvZCBFbnZpcm9ubWVudCBTU0wgTG9jYXRpb259&locale=en_GB&version=2); background-repeat: no-repeat;" data-macro-body-type="RICH_TEXT"><tr><td class="wysiwyg-macro-body"><p><TBD></p></td></tr></table><p style="text-align: left;"><br /></p><h2 style="text-align: left;">WERCS</h2><p style="text-align: left;">In the AWS FSX folder<span> </span><span style="color: rgb(0,0,0);">\\<a href="http://amznfsxv6cy69eg.eua.solvay.com/" style="">amznfsxv6cy69eg.eua.solvay.com</a>\share\WERCS, 182362 SDS are stored for archive purpose. These files were indexed one time and can be search in the<span> </span><a class="" href="https://ehs-all-search.solvay.com/" style="">https://ehs-all-search.solvay.com/</a><span> </span>interface.</span></p><p style="text-align: left;"><span style="color: rgb(0,0,0);"><img class="confluence-embedded-image confluence-external-resource" draggable="false" height="150" src="https://wiki.solvay.com/download/attachments/6030248/image-2024-1-11_15-36-10.png?version=1&modificationDate=1704983770232&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image-2024-1-11_15-36-10.png?version=1&modificationDate=1704983770232&api=v2"></span></p><p style="text-align: left;"><br /></p><p style="text-align: left;"><span style="color: rgb(0,0,0);">The files must be kept in the index. No need to reindex them.</span></p><p style="text-align: left;">If you want to reindex them (after Syensqo migration), you need to start the connector of the the collection<span> </span><span style="color: rgb(0,0,0);">/AWS FSX/WERCS/</span></p><p style="text-align: left;"><span style="color: rgb(0,0,0);">Then you have to run the script F:\works\wercs\sql\execute.bat in order to update metaproperties.</span></p><h1 style="text-align: left;">Redirection page redirect.aspx</h1><hr style="text-align: left;" /><p style="text-align: left;">The redirect page redirect.aspx has been created in the folder F:\sinequa\website\</p><p style="text-align: left;">The page is used to search and open directly the document if there is only one document found. This page can be inserted in the intranet to avoid to manage internal id of the Documentum documents (EHS interface).</p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"><em> </em><%@ Page Language="VB" Debug="true" %><p> <%</p><p>'<a href="http://ehs-search.solvay.com/redirect.aspx?text=&advanced=1&precision=&strategy=&sort=globalrelevance.desc&sourcestr2=W7&sourcecsv2=P00000000477&sourcestr22=FR&sourcestr23=SDS_FR" style="">http://ehs-search.solvay.com/redirect.aspx?text=&advanced=1&precision=&strategy=&sort=globalrelevance.desc&sourcestr2=W7&sourcecsv2=P00000000477&sourcestr22=FR&sourcestr23=SDS_FR</a></p><p>Dim UrlIfNotfound </p><p><br /></p><p>if("ACEW1PSINESIN01" = HttpContext.Current.Server.MachineName) then<br /> UrlIfNotfound = "<a href="https://ehs-search.solvay.com/" style="">https://ehs-search.solvay.com</a>"<br />else<br /> UrlIfNotfound = "<a href="https://ehs-fp-search-test.solvay.com/" style="">https://ehs-fp-search-test.solvay.com/</a>"<br />end if</p><p>Dim DomainName = "" </p><p><br />DomainName = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority)</p><p>Dim rho_sds_dh_repstatus = ""<br />if (Request.QueryString("sourcestr2") IsNot Nothing ) then<br /> rho_sds_dh_repstatus = Request.QueryString("sourcestr2")<br />end if<br />if rho_sds_dh_repstatus = "W7" then rho_sds_dh_repstatus = "Released"</p><p>Dim rho_sds_rh_specification = ""<br />if (Request.QueryString("sourcecsv2") IsNot Nothing ) then<br /> rho_sds_rh_specification = Request.QueryString("sourcecsv2")<br />end if</p><p> <br />Dim rho_sds_dh_sbgvid = ""<br />if (Request.QueryString("sourcestr23") IsNot Nothing ) then<br /> rho_sds_dh_sbgvid = Request.QueryString("sourcestr23")<br />end if</p><p>Dim language = ""<br />if (Request.QueryString("sourcestr22") IsNot Nothing ) then<br /> language = Request.QueryString("sourcestr22")<br />end if</p><p>Dim profile = ""<br />if (Request.QueryString("profile") IsNot Nothing ) then<br /> profile = Request.QueryString("profile")<br />else<br /> profile = "xECM_SDS_REDIRECTASPX"<br />end if</p><p><br /></p><p>Dim URLSinequa = DomainName + "/search?text=&advanced=1&precision=&strategy=&sort=globalrelevance.desc"</p><p>URLSinequa = URLSinequa + "&sourcestr13=" + rho_sds_dh_repstatus</p><p>URLSinequa = URLSinequa + "&sourcestr2=" + rho_sds_rh_specification</p><p>URLSinequa = URLSinequa + "&sourcestr31=" + rho_sds_dh_sbgvid </p><p>URLSinequa = URLSinequa + "&sourcestr41=" + language </p><p>URLSinequa = URLSinequa + "&profile=" + profile </p><p><br />'response.write (URLSinequa)<br />'response.end</p><p><br /> %><br /> <br /><html lang="en"><br /><head><br /> <meta charset="utf-8"><br /> <meta http-equiv="cache-control" content="max-age=0" /><br /><meta http-equiv="cache-control" content="no-cache" /><br /><meta http-equiv="expires" content="0" /><br /><meta http-equiv="expires" content="Tue, 01 Jan 1980 1:00:00 GMT" /><br /><meta http-equiv="pragma" content="no-cache" /> <br /> <title>Redirect page from Sinequa to Documentum</title><br /> <script src="<a style="">https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script</a>><br /> <br /> <style><br /> .loader { border: 16px solid #f3f3f3; border-top: 16px solid #3498db; border-radius: 50%; width: 280px; height: 280px; animation: spin 1s linear infinite; position: fixed; top: 40%; left: 40%; }<br /> @keyframes spin { 0% { transform: rotate(0deg); } 100% { transform: rotate(360deg); } }<br /> </style><br /> <br /></head><br /><body> </p><p><div class="loader" id="sk-loader"></div></p><p><p style="text-align:center;"><br />Sinequa opener. Close this page after the opening of the document.<br><br><br /> <br /><b>Total Count:</b><br /><span id="idTotalCount"></span><br> </p><br /><script> <br />$(document).ready(function() { <br /> <br />var UrlOrigine = '<%response.write(URLSinequa)%>';<br /> <br />UrlXml = UrlOrigine + '&type=rest';</p><p>console.log('<% response.write(URLSinequa)%>');<br />console.log(UrlXml);<br /> </p><p>$.ajax({<br /> type: "GET",<br /> url: UrlXml,<br /> dataType: "xml",<br /> success : function(data) {<br /> var xml = data;</p><p> var TotalCount = $(xml).find( "TotalCount" ).text();<br /> <br /> $('#idTotalCount').html(TotalCount);</p><p> if (TotalCount=="1" ) { <br /> $( ".loader" ).hide();<br /> var UrlDocumentum = $(xml).find( "Url" ).first().text();<br /> //alert(UrlDocumentum);<br /> window.location.href = UrlDocumentum;<br /> //window.close();<br /> //window.open(UrlDocumentum); <br /> }<br /> else {<br /> window.location.href = '<% response.write(UrlIfNotfound)%>';<br /> }<br /> }<br />});<br />});</p><p></script><br /> <br /></body><br /></html></p></th></tr></tbody></table><p style="text-align: left;">From the following link:</p><p><a href="http://ehs-search.solvay.com/search?text=&advanced=1&precision=&strategy=&sort=globalrelevance.desc&after=&before=&docformat=&phonetics=1&fuzzysearch=1&sourcestr4=&sourcestr12=sds+for+france&sourcescsv3=&sourcecsv2=&sourcestr7=&sourcecsv1-0=fr+%28french%29&sourcecsv1-1=&sourcestr8=&sourcestr9=&sourcestr10=&sourcestr15=&sourcecsv20=81770" style="">http://ehs-search.solvay.com/search?text=&advanced=1&precision=&strategy=&sort=globalrelevance.desc&after=&before=&docformat=&phonetics=1&fuzzysearch=1&sourcestr4=&sourcestr12=sds+for+france&sourcescsv3=&sourcecsv2=&sourcestr7=&sourcecsv1-0=fr+%28french%29&sourcecsv1-1=&sourcestr8=&sourcestr9=&sourcestr10=&sourcestr15=&sourcecsv20=81770</a></p><p><a href="http://ehs-search.solvay.com/search?text=&advanced=1&precision=&strategy=&sort=globalrelevance.desc&after=&before=&docformat=&phonetics=1&fuzzysearch=1&sourcestr4=&sourcestr12=sds+for+france&sourcescsv3=&sourcecsv2=&sourcestr7=&sourcecsv1-0=fr+%28french%29&sourcecsv1-1=&sourcestr8=&sourcestr9=&sourcestr10=&sourcestr15=&sourcecsv20=81770" style="">http://ehs-search.solvay.com/search?text=&advanced=1&precision=&strategy=&sort=globalrelevance.desc&after=&before=&docformat=&phonetics=1&fuzzysearch=1&sourcestr4=&sourcestr12=sds+for+france&sourcescsv3=&sourcecsv2=&sourcestr7=&sourcecsv1-0=fr+%28french%29&sourcecsv1-1=&sourcestr8=&sourcestr9=&sourcestr10=&sourcestr15=&sourcecsv20=81770</a></p><p>you can create the following link:</p><p><a href="http://ehs-search.solvay.com/" style="">http://ehs-search.solvay.com</a>/redirect.aspx?text=&advanced=1&precision=&strategy=&sort=globalrelevance.desc&after=&before=&docformat=&phonetics=1&fuzzysearch=1&sourcestr4=&sourcestr12=sds+for+france&sourcescsv3=&sourcecsv2=&sourcestr7=&sourcecsv1-0=fr+%28french%29&sourcecsv1-1=&sourcestr8=&sourcestr9=&sourcestr10=&sourcestr15=&sourcecsv20=81770</p><h1 style="text-align: left;">Anti-virus</h1><hr style="text-align: left;" /><p style="text-align: left;">It's important that the directory of the indexes (G:\Sinequa\indexes) and the temp folder ( F:\Sinequa\Temp ) are excluded of the scope of the anti-virus.</p><h1 style="text-align: left;">Tips</h1><hr style="text-align: left;" /><h2 style="text-align: left;">Add email in the target link</h2><hr style="text-align: left;" /><p style="text-align: left;">To add the email in the target link to the document change this line in this Profile / Display:</p><h2 style="text-align: left;">Force reindexation for all documents in a collection</h2><hr style="text-align: left;" /><table class="wysiwyg-macro" data-macro-name="warning" data-macro-id="133e862e-11e1-4dc7-abe8-083ab4305d65" aria-label="warning macro" data-macro-parameters="title=Force Indexing on the whole Collections" data-macro-schema-version="1" style="background-image: url(https://wiki.syensqo.com/plugins/servlet/confluence/placeholder/macro-heading?definition=e3dhcm5pbmc6dGl0bGU9Rm9yY2UgSW5kZXhpbmcgb24gdGhlIHdob2xlIENvbGxlY3Rpb25zfQ&locale=en_GB&version=2); background-repeat: no-repeat;" data-macro-body-type="RICH_TEXT"><tr><td class="wysiwyg-macro-body"><p>If the collection has a lot of documents (like EHS), the reindexation process will take days to complete. If possible, don't reindex the whole collection if there are many documents to be reindexed.</p><p>Remember to uncheck the box "Force re-indexing" after usage.</p></td></tr></table><p style="text-align: left;">You can force the reindexation for all documents in a collection by checking on the "Force re-indexing" in the Collection setting.</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource confluence-content-image-border" draggable="false" height="480" width="912" src="https://wiki.solvay.com/download/attachments/6030248/image2016-6-3%2015%3A3%3A56.png?version=1&modificationDate=1464937436845&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2016-6-3%2015%3A3%3A56.png?version=1&modificationDate=1464937436845&api=v2"></p><h2 style="text-align: left;">Force reindexation for some documents (for not forced reindexation)</h2><hr style="text-align: left;" /><p style="text-align: left;">You can force the reindexation by changing the value of the field version (backdate the document):</p><p style="text-align: left;"><em>update idx_documentum set version = '1980-01-01'</em><br /><em>where collection = '/Documentum/rcsehs/'</em><br /><em>and (</em><br /><em>filename = 'BBE23952BED08A59E10000000A8F7698.doc'</em><br /><em>or filename = '10E53952BED08A59E10000000A8F7698.doc' )</em></p><p style="text-align: left;">During the next indexation the documents will be processed.</p><h1 style="text-align: left;">Known issues</h1><hr style="text-align: left;" /><h2 style="text-align: left;">2 profiles affected to the same sub-domain</h2><hr style="text-align: left;" /><p style="text-align: left;">It's important that a sub-domain (ex: <a href="http://magda-search.solvay.com/" style="">magda-search.solvay.com</a>) is affected to only one profile. If not, when you will access to the sub-domain the interface displayed will be randomly one of the tow profiles.</p><p style="text-align: left;">This problem can happen easily when you make a copy of an existing profile to create a new one.</p><h2 style="text-align: left;">Engine can not start</h2><hr style="text-align: left;" /><p style="text-align: left;">If the engine can not start open the engine log.</p><p style="text-align: left;">If there is a message like this FATAL: index 'idx_XXX' was not cleanly stopped it means that the index is corrupted.</p><p style="text-align: left;">The only solution is to delete the index (G$\Sinequa\indexes\idx_XXX.hdb) and restart the engine.</p><p style="text-align: left;">You need to create the index and index the collections linked to this index.</p><p style="text-align: left;">This issue can occur if the engine is not correctly stopped (crash server).</p><p style="text-align: left;"><br /></p><p style="text-align: left;"><br /></p><h2 style="text-align: left;">Files in "F:\sinequa\temp" folder are not cleared.</h2><hr style="text-align: left;" /><p style="text-align: left;">The files in the temp folder is cleared at a regular interval set in the node page. If no value is set, the files will only be cleared in 3 hours interval.</p><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" src="https://wiki.solvay.com/download/attachments/6030248/image2017-3-31%2017%3A48%3A46.png?version=1&modificationDate=1490953726749&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2017-3-31%2017%3A48%3A46.png?version=1&modificationDate=1490953726749&api=v2"></p><h1 style="text-align: left;">Diagnostic a problem</h1><hr style="text-align: left;" /><p style="text-align: left;">The main issue is that an user call the support to say that he can't see a particular document in Sinequa. For this issue there is two explications: the document was not indexed or the user don't have right to see the document.</p><p style="text-align: left;">Here's the way to diagnostic the problem:</p><p style="text-align: left;">Get from the user the id, the title of the document and its treepath (the Sinequa folder where the document should be) .</p><p style="text-align: left;">Determine in which index it should be (idx_Documentum,...).</p><p style="text-align: left;">Make a request with the ConsoleEngine tool.</p><p style="text-align: left;">For example:</p><p style="text-align: left;"><br /></p><p style="text-align: left;"><br /></p><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"> Request</th><th style="text-align: left;vertical-align: top;" class="confluenceTh"> Description</th></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">select * from idx_Documentum<br /> where treepath contains '/Documentum/RCSEHS/EHS/SDS/BU-01/R&D/*'<br /> limit 30</td><td style="text-align: left;vertical-align: top;" class="confluenceTd"> List the 30th documents of the treepath /Documentum/RCSEHS/EHS/SDS/BU-01/R&D/ if the index idx_Documentum</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd">select * from idx_Documentum<br />where filename = 'B9F9414D78DB3226E10000000A8F7697.doc'</td><td style="text-align: left;vertical-align: top;" class="confluenceTd"> List the document wich has a filename equal to B9F9414D78DB3226E10000000A8F7697.doc</td></tr></tbody></table><p style="text-align: left;"><br /></p><p style="text-align: left;"><br /></p><p style="text-align: left;">If the document have not been found it can be be explained by these reasons:</p><p style="text-align: left;"> - the document was not in the original application => check in the application</p><p style="text-align: left;"> - the document was not indexed by Sinequa because an exclusion rules => check in the collection configuration the tab General (last section)</p><h2 style="text-align: left;">Identify the right of the users on Sinequa:</h2><p style="text-align: left;">If the document is in the index you have to check the access.</p><p style="text-align: left;">Get the AD id of the user in the file G:\sinequa\data\configuration\domains\Rhodia_AD\<AD name>\content.xml</p><p style="text-align: left;"><AD name> can be one of these values: br-spo, fr-rhodia, sg_rhodia or us-crn</p><p style="text-align: left;">Use this URL to see the effective rights of the user:</p><p style="text-align: left;"><a href="http://wdcsqap21.eua.solvay.com/" style="">http://acew1psinesin01.eua.solvay.com/</a><span> </span><a style="">custompage?action=userrights&id=Rhodia_AD|</a><span> </span><a style=""><AD ID></a></p><p style="text-align: left;">(The Rhodia ID is like that S-1-5-21-2074683374-75502006-538272213-79994)</p><p style="text-align: left;">Compare the date of ACL change in the indexed application with the last date of importation of accounts in Sinequa. If the change have been made after the import start the job of importation of accounts (domain).</p><p style="text-align: left;">Check if the user is in the file of the domain associated to the collection. Open the file G:\sinequa\data\configuration\domains\<domain name>\content.xmland look at his name.</p><p style="text-align: left;">You must find the user and the groups that he belongs. Compare with the ACL of the application => make a request to get the fields accesslist1, accesslist2 and deniedlist1 and compare with the ACL of the user.</p><h2 style="text-align: left;">See the debug variables of Sinequa:</h2><p style="text-align: left;">Sinequa provide a page to see all the variables for debugging purposes.</p><p style="text-align: left;"><a href="https://acew1psinesin01.eua.solvay.com/requestdebug" style="">https://acew1psinesin01.eua.solvay.com/requestdebug</a></p><p style="text-align: left;"><a href="http://acew1tsinesin01.eua.solvay.com/requestdebug" style="">http://acew1tsinesin01.eua.solvay.com/requestdebug</a></p><h3 style="text-align: left;">Enable RequestDebug feature:</h3><p style="text-align: left;"><img class="confluence-embedded-image confluence-external-resource" draggable="false" height="250" src="https://wiki.solvay.com/download/attachments/6030248/image2019-9-12_10-18-33.png?version=1&modificationDate=1568254713527&api=v2" data-image-src="https://wiki.solvay.com/download/attachments/6030248/image2019-9-12_10-18-33.png?version=1&modificationDate=1568254713527&api=v2"></p><h1 style="text-align: left;">Maintenance</h1><hr style="text-align: left;" /><h2 style="text-align: left;">Stop the application on the Sinequa server</h2><hr style="text-align: left;" /><ul style="text-align: left;"><li>stop the WWW Publishing service</li><li>stop the Sinequa.identity1 service</li><li>stop the Sinequa.service service</li></ul><h2 style="text-align: left;">Start the application on the Sinequa server</h2><hr style="text-align: left;" /><ul style="text-align: left;"><li>start the Sinequa.identity1 service</li><li>start the Sinequa.service service</li><li>start the WWW Publishing service</li></ul><h2 style="text-align: left;">Issues</h2><hr style="text-align: left;" /><h3 style="text-align: left;">Tasks are not launched (scheduler)</h3><hr style="text-align: left;" /><p style="text-align: left;">Stop Sinequa services (not IIS)</p><p style="text-align: left;">Delete the content of the folders F:\sinequa\locla-data & F:\sinequa\locla-data-8080</p><p style="text-align: left;">Restart the Sinequa services</p><h3 style="text-align: left;">Not able to access Sinequa with Windows (NTLM / KERBEROS)<span> </span><span style="color: rgb(255,102,0);">(no longer used)</span></h3><hr style="text-align: left;" /><p style="text-align: left;">Symptoms:</p><ul style="text-align: left;"><li>When accessing the administration page, you are redirected to login page.</li><li>When searching on the search page, no result are return.</li></ul><p style="text-align: left;">What to do:</p><ol style="text-align: left;"><li>Stop IIS service.</li><li>Start IIS service.</li></ol><p style="text-align: left;">Cause:</p><ol style="text-align: left;"><li>The scheduled recycling of the application pool in IIS will occasionally caused the Sinequa to use another WebApp (due to the load-balancing). </li><li>The swapped WebApp does not support NTLM authentication. Resulted to user being redirected to the login page.</li></ol><p style="text-align: left;">Resolution:</p><ol style="text-align: left;"><li>Introduced a script to monitor on the "Sinequa WebApp Name" displayed on the /requestdebug page.</li><li>To know more about the script, you can read this<span> </span><a href="https://wiki.solvay.com/display/TECHWEB/Monitoring+Sinequa+Recycling+Application+Pool">wiki</a>.</li></ol><h2 style="text-align: left;">Logs</h2><hr style="text-align: left;" /><p style="text-align: left;">The directories of the logs is cleaned automatically by an Infra script. Only the last 10 days are kept.</p><p style="text-align: left;">In case the infra script is not running, perform the following:</p><ol style="text-align: left;"><li>Inform Infra (Data centre team) to investigate on the issue.</li><li><p>Manually run the cmd which can clear 7 days of log files.</p><table class="wysiwyg-macro" data-macro-name="code" data-macro-id="b5f81ae3-a85b-4272-ad3d-e4e9b93c5725" aria-label="code macro" data-macro-parameters="language=powershell|title=Command to clear the log files" data-macro-schema-version="1" style="background-image: url(https://wiki.syensqo.com/plugins/servlet/confluence/placeholder/macro-heading?definition=e2NvZGU6bGFuZ3VhZ2U9cG93ZXJzaGVsbHx0aXRsZT1Db21tYW5kIHRvIGNsZWFyIHRoZSBsb2cgZmlsZXN9&locale=en_GB&version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>forfiles -p "H:\SinequaLog" -s -m *.log -D -7 /C "cmd /c del @path"</pre></td></tr></table></li></ol><h2 style="text-align: left;">Shrink of the indexes</h2><hr style="text-align: left;" /><p style="text-align: left;">Every week the index files have to be reorganize (shrink).</p><p style="text-align: left;">A command is scheduled. </p><h2 style="text-align: left;">Jobs control</h2><hr style="text-align: left;" /><h3 style="text-align: left;">Tasks status</h3><hr style="text-align: left;" /><p style="text-align: left;">In the Tasks Status you can see the list of all scheduled tasks with the status (Column Result). The link Log show you the report of the job. </p><h2 style="text-align: left;">Backup & restoration of the indexes</h2><hr style="text-align: left;" /><p style="text-align: left;">The files of the servers Sinequa are saved every day like all Rhodia's servers.</p><p style="text-align: left;">To have a valid backup of the folder of the indexes G:\sinequa\indexes the service Sinequa must be stopped during the backup.</p><p style="text-align: left;">However, the Sinequa command Backup can create a valid copy of the index.</p><p style="text-align: left;">Every night, the scheduled command backup (Job Backup indexes) copies the folder of the indexes in the folder G:\sinequa_indexes_dump</p><p style="text-align: left;">There is one subfolder for each index (<name of the index> + ".hdb").</p><p style="text-align: left;">To restore one index you must :</p><p style="text-align: left;"> - check that the folder G:\sinequa_indexes_dump\<name of the folder>.hdb exists </p><p style="text-align: left;"> - stop the Sinequa services</p><p style="text-align: left;"> - delete the folder G:\sinequa\indexes\<name of the folder>.hdb</p><p style="text-align: left;"> - copy the folder G:\sinequa_indexes_dump\<name of the folder>.hdb into the folder G:\sinequa\indexes\<name of the folder>.hdb</p><p style="text-align: left;"> - start the Sinequa services</p><p style="text-align: left;">After, you can restart the indexation to have fresh data.</p><h1 style="text-align: left;">Tasks</h1><hr style="text-align: left;" /><table style="text-align: left;" class="confluenceTable"><colgroup class=""><col class="" /><col class="" /><col class="" /></colgroup><tbody class=""><tr class=""><th style="text-align: left;vertical-align: top;" class="confluenceTh"> Task</th><th style="text-align: left;vertical-align: top;" class="confluenceTh">Who can do it</th><th style="text-align: left;vertical-align: top;" class="confluenceTh"> Comment</th></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"> Check the indexation</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Sinequa administrator</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Check the log files every day </td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"> Create a new collection</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Sinequa administrator</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Configure a new collection and a new partition</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"> Update the software</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Sinequa administrator</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Make it the test server first and test<br />If test ok make it on the production server</td></tr><tr class=""><td style="text-align: left;vertical-align: top;" class="confluenceTd"> Diagnostic a problem</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">Sinequa administrator</td><td style="text-align: left;vertical-align: top;" class="confluenceTd">See the diagram</td></tr></tbody></table><h1 style="text-align: left;">Deployment from test server to production server</h1><hr style="text-align: left;" /><p style="text-align: left;">All configuration settings are stored in xml files (G:\Sinequa \data\configuration).</p><p style="text-align: left;">There are different ways to apply changes on the production server.</p><ul style="text-align: left;"><li>Use the administration interface only</li><li>Copy the xml files from test to production and change data in files</li><li>Copy the xml files from test to production and change data with the administration interface</li></ul><p style="text-align: left;"><span style="color: rgb(255,0,0);">Note that if you change or add an xml files you will not see the change in the administration interface. To see them you have to make pseudo change (like a Unix touch) in the administration interface. For example go to menu Global options, click on the button and click on the Save button.</span></p><p style="text-align: left;"><br /></p><p style="text-align: left;"><br /></p><p style="text-align: left;"><br /></p>
Edit
Preview
Save
Close
{"serverDuration": 263, "requestCorrelationId": "b80ef7848c72070e"}