CookBook

How to specific cell of screen item "spreadsheet" to search target of IM-ContentsSearch

Posting Date:

Is introduced how to specific cell of screen item "spreadsheet" to search target of IM-ContentsSearch.

In this lesson, personal information on the spreadsheet or contents you do not want to share a document with external excluded from the search target introduces contents that can be utilized when only specific cells specified you want to the search target.

※IM-Workflow linkage application is the search target. is not supported standard application of IM-FormaDesigner.

Completion Image

In the sample, the field "name applicant" on the spreadsheet is set to search target of IM-ContentsSearch.
Also search for other contents, it will not be displayed in search results.


1. Apply for a matter.
2. Search by IM-ContentsSearch.

  • Application screen

  • IM-ContentsSearch

    • "name applicant" Search
    • "applicant address" Search

Finished Example

Are required settings for when using sample.

  • Please configure the following settings from IM-Juggling.
    • Please include the "IM-ContentsSearch for IM-Spreadsheet" module "IM-BIS/IM-Spreadsheet Option connector" under from the module configuration of the application.
      Above is a module that has been added to the 2019 Spring.
    • Add "IM-ContentsSearch for IM-Spreadsheet on IM-Knowledge" (im_spreadsheet_contents_search-8.0.x.imm) module in the user module.
      Above is a module that has been added to the 2018 Summer.
  • Please state in which the setup of Apache Solr has been completed.

Take advantage download and the following and it will be complete. sample.

When you use Completion sample, import the sample data in a tenant environment setup, please set "BIS in-charge" to the user to be used by the role.

Recipe

  1. To create BIS workflow.
  2. Setting the search target items.
  3. To run the job.

1. To create BIS workflow.

Is created BIS workflow that can be application and approval.

BIS name
158668_Cookbook
  • Please place screen item "spreadsheet" and "button (registration) ".

  • "spreadsheet" Open workbook editor of property from, and then import the file below.
    158668_Cookbook.xlsx

To control the scroll in the spreadsheet on the screen set, can be performed by setting ⇒ scroll bar of the workbook editor.
This, in order to prevent unnecessary scroll and check the "bar according to the last row and column".

  • Now, you will make bindings for the data.

Move to advanced settings tab check the binding settings, you will be able to select the field definitions tab.

Select the cell on the spreadsheet, you can do bindings by clicking "add cell of the selected".

This are as follows:

Bind destination Field ID Type
Application date apply_date Date
Name applicant applicant_name Character string
Department belonging department Character string
Applicant address applicant_address Character string
Nearest station nearby_station Character string

To move to the table definition tab, in a state in which the table 1 is selected, and then click "set definitions".

Subsequently, and do the settings shown below.

Table ID: transport_expense_table

Bind destination Field ID Type
Transportation facility Character string
Ride section (from) section_from Character string
Ride section (to) section_to Character string
3 months (regular) three_month_pass Numerical value
1 months (regular) one_month_pass Numerical value
1 days (round trip) day_fare Numerical value

2. Setting the search target items.

Field "name applicant" on the spreadsheet is set as the search target items.

  • Select the application of "158668 _ Cookbook" from "forma full-text search management screen" for the site map.
  • Move to spreadsheet tab, "name applicant" applicant_name should be set to search target items.

3. To run the job.

Finally, please execute job to create the index for the search.

  • Move to "job Net Setting" from "tenant Management" for the site map.
  • Select "should be created again crawling" of "IM-ContentsSearch crawler" from the job net list.
  • Press "immediate execution" button to run the job is at the bottom of the screen.

To see the execution result of job can be checked by "jobnet monitor list" at the top of the screen.

Please refer to the following document for details of workflow crawler.
[IM-ContentsSearch for IM-Workflow Specifications] - [Types and specifications of the crawler]

Thus, now specific cell in the spreadsheet can be searched in IM-ContentsSearch.

-CookBook
-, , ,

Author:


comment

Field that does not mail address is published. * is attached is required item

Related article

no image

How to global navigation to hide after page transition

In this lesson, we will explain how to global navigation to hide after page transition. Please use if you want to hide global navigation after page transition in a special reason. In addition, iframe…

no image

Using example of event calendar in the workspace function

In this lesson is introduced for use example of event calendar in "intra-mart Accel Collaboration" workspace function. intra-mart Accel…

no image

Example of working with date data in calculation formula of ViewCreator

By using "ViewCreator can be easily are displayed on the screen data that are stored in the database, etc. About ViewCreator -- intra-mart Accel Platform V…

no image

Linkage with workspace and file library function

In this lesson, vailla of the workspace and "intra-mart Accel Collaboration" is one of the function of "intra-mart Accel Collaboration"…

By using the Protect Sheet in the spreadsheet, controls the input cell for each node

Control In this lesson, so that the by using the Protect Sheet in the spreadsheet and provides information on how to control the input cell for each node. In Excel, can be entered only specific cell by using the Protect Sheet…

There is no data yet.

RSSRSSRSSRSS