AppSuite (Additional)

Connection Settings

Connection settings are information for connecting to AppSuite.

Example

url=http://sample/dneo.cgi basic_auth_userid=sampleid basic_auth_password=samplepass proxy_host=samplehost proxy_port=1234 proxy_auth_userid=proxyid proxy_auth_password=proxypass

Enter the following information in the key=value format.

Key	The specified value	Description
url	[URL of desknet's NEO]	Be sure to specify it. Describe the URL of desknet's NEO.
basic_auth_userid	[Basic authentication user ID]	Specify when using Basic authentication when logging in to desknet's NEO. This item is not required if Basic authentication is not performed.
basic_auth_password	[Basic authentication password]
proxy_host	[Proxy server host name]	Specify when using a proxy server at desknet's NEO. If you do not use a proxy server, this item is not required.
proxy_port	[Proxy server port number]
proxy_auth_userid	[Proxy Authentication User ID]	Specify when using proxy authentication at desknet's NEO. If you do not use proxy authentication, this item is not required.
proxy_auth_password	[Proxy Authentication Password]

Parts Setting

Set the parts to be processed and the order.

Example

[   { "field_name": “Responsible"},   { "field_name": ""},   { "field_name": “Client"}  ]

Enter the following information in json format (key and value pairs enclosed in {}).

Key	The specified value	Description
field_name	[Target part name]	Be sure to specify it.” Describe the target part name in "field_name".

Narrowing Conditions

Example

{  "item": [   {"field_id": "101", "operator": ">=", "value": "1"},   {"field_id": "102", "operator": "is_null"},   {"field_id": "103", "operator": "contains", "value": " 1\t2 ", "type":" id"}  ] } }

Please specify the search condition array in "item".
If there are multiple specified search conditions, AND search is executed.
The information to be entered in the search conditions is as follows.

Key	The specified value	Description
field_id	[Part ID to search]	Be sure to specify it. Specify the ID of the part to be searched. You can check the component ID in [Application Settings> Component Management].
operator	[= | ! = | &gt | &gt= | &lt | &lt= | includes | not_includes | starts_with | ends_with | contains | not_contains | is_null | is_not_null | matches]	Be sure to specify it. Specify the search method.
value	[Value to search for]	Specify the value to search for. If the value to be searched includes the following characters, please convert and enter as follows. (Tabs are used as delimiters when specifying multiple conditions.) (タブ) → \t \ → \\ " → \"
type	[id | textbox | number | date | datetime | interval | field_id]	Specifies the type of value to search for.

[List of search condition combinations]
The combination of "operator", "value" and "type" of the component specified by "field_id" is described below.
In order to specify the search conditions, it is necessary to combine the values of "operator", "value", and "type" for each component type specified in "field_id". The combinations that can be specified are as follows.

Part type	operator	value	type
[Data ID]	= (equal to)	Any integer greater than or equal to 1	(no input)
Text (1 Line)	= (match)	Any character	(no input)
	! = (does not match)
	includes (includes | includes either)	Arbitrary characters (multiple delimited by tab delimiters)
	not_includes (does not include | neither)
	starts_with	Any character
	ends_with (finished)
	is_null (not entered)	(no input)
Text (Multi Line) Rich Text	includes (includes | includes either)	Arbitrary characters (multiple delimited by tab delimiters)	(no input)
	not_includes (does not include | neither)
	is_null (not entered)	(no input)
Radio Button Pull Down	= (matches either)	Choice value (multiple values can be specified by separating with tab)	(no input)
	! = (neither match)
	is_null (not entered)	(no input)
Checkbox list box	contains (contains either)	Choice value (multiple values can be specified by separating with tab)	(no input)
	not_contains (neither is included)
	is_null (not entered)	(no input)
Number	= (equal to)	Numerical values that can be entered in number parts	(no input)
	! = (not equal)
	<(less than)
	<= (less than)
	> (greater than)
	>= (or more)
	is_null (not entered)	(no input)
Date	= (equal to)	-"Yyyy", "yyyy-MM", or "yyyy-MM-dd" format Example: " 2018 ", " 2018-01 ", " 2018-01-10 " ・"[+|-]n days", "[+|-]n months: [*|1-31|e]", "[+|-]n years: [ 1-12 ]: One of the formats [*|1-31|e]" Example: " +3 days" (3 days after today) Example: " -1 months:10" (10th of last month) Example: " +1 months:*" (any day in the next month) Example: " -2 years:3:e" (the end of March two years ago)	(no input)
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	= (equal to)	ID of the part to compare	field_id
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	is_null (not entered)	(no input)	(no input)
[Date/Time Added] [Date/Time Updated] Date and time	= (equal to)	-"Yyyy", "yyyy-MM", "yyyy-MM-dd", "yyyy-MM-ddThh", "yyyy-MM-ddThh:mm" format Example: " 2018", "2018-01", "2018-01-10", "2018-01-10T09","2018-01-10T09:30" ・"[+|-]n days", "[+|-]n months: [*|1-31|e]", "[+|-]n years: [ 1-12 ]: One of the formats [*|1-31|e]" Example: " +3 days" (3 days after today) Example: " -1 months:10" (10th of last month) Example: " +1 months:*" (any day in the next month) Example: " -2 years:3:e" (the end of March two years ago)	(no input)
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	= (equal to)	ID of the part to compare	field_id
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	is_null (not entered)	(no input)	(no input)
Times of Day	= (equal to)	"hh:mm"の形式	(no input)
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	is_null (not entered)	(no input)
Attachment Files	includes (include in file name)	Any character	(no input)
	matches (included in text in file name/attachment)
	is_not_null (file exists)	(no input)
	is_null (file does not exist)
Auto Calculation	= (match)	Any character	textbox
	! = (does not match)
	includes (includes | includes either)	Arbitrary characters (multiple delimited by tab delimiters)
	not_includes (does not include | neither)
	starts_with	Any character
	ends_with (finished)
	= (equal to)	Numerical values that can be entered in number parts	number
	! = (not equal)
	<(less than)
	<= (less than)
	> (greater than)
	>= (or more)
	includes	Any character
	= (equal to)	-"Yyyy", "yyyy-MM", or "yyyy-MM-dd" format Example: " 2018 ", " 2018-01 ", " 2018-01-10 " ・"[+|-]n days", "[+|-]n months: [*|1-31|e]", "[+|-]n years: [ 1-12 ]: One of the formats [*|1-31|e]" Example: " +3 days" (3 days after today) Example: " -1 months:10" (10th of last month) Example: " +1 months:*" (any day in the next month) Example: " -2 years:3:e" (the end of March two years ago)	date
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	includes (including)	Any character
	= (equal to)	-"Yyyy", "yyyy-MM", "yyyy-MM-dd", "yyyy-MM-ddThh", "yyyy-MM-ddThh:mm" format Example: " 2018", "2018-01", "2018-01-10", "2018-01-10T09","2018-01-10T09:30" ・"[+|-]n days", "[+|-]n months: [*|1-31|e]", "[+|-]n years: [ 1-12 ]: One of the formats [*|1-31|e]" Example: " +3 days" (3 days after today) Example: " -1 months:10" (10th of last month) Example: " +1 months:*" (any day in the next month) Example: " -2 years:3:e" (the end of March two years ago)	datetime
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	includes (including)	Any character
	= (equal to)	Any integer (converted to seconds)	interval
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	includes (including)	Any character
	is_null (not entered)	(no input)	(no input)
[Added By] [Updated By] Select User	contains (contains either)	User system ID (You can specify multiple tab-delimited)	id
	not_contains (neither is included)
	is_null (not entered)	(no input)	(no input)
Select Group	contains (contains either)	Group system ID (Multiple can be specified by separating with tab)	id
	not_contains (neither is included)
	is_null (not entered)	(no input)	(no input)

Sample 1

Search conditions that include "Installation cost" or "Cloud" in the total evaluation and the number of minimum contract months is less than "12"

{  "filter": {   "item": [    {"field_id": "101", "operator": "includes", "value": "Installation cost\t cloud"},    {"field_id": "102", "operator": ">", "value": " 12 "}   ]  } }

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Text (Multi Line)	総評
102	Number	Minimum contract months

Sample 2

Search condition in which the department system ID of the department in charge is "3" or "4" and the number of sales results (auto calculation) is "1000000" or more

{  "filter": {   "item": [    {"field_id": "101", "operator": "contains", "value": " 3\t4 ", "type": "id"},    {"field_id": "102", "operator": ">", "value": " 1000000 ", "type": "number"}   ]  } }

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Select Group	Department in charge
102	Auto Calculation	Sales results

Sample 3

Search conditions that include "Chiyoda-ku, Tokyo" in the address and last visited before "20 days 3 months ago"

{  "filter": {   "item": [    {"field_id": "101", "operator": "includes", "value": "Chiyoda ward, Tokyo"},    {"field_id": "102", "operator": "<", "value": "-3 months:20"}   ]  } }

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Text (1 Line)	address
102	Date	Last visit date

Sample 4

Search conditions when the contract status is other than "Termination" and "Contract Expiration" and the contract start date is "2017/04/01" or later

{  "filter": {   "item": [    {"field_id": "101", "operator": "! =", "value": "Contract Delete \tContract Expired"},    { field_id ": "102", "operator": ">=", "value": " 2017-04-01 "}   ]  } }

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Pull Down	Contract status
102	Date	Contract start date

Sample 5

Search conditions when the equipment rental date is "2017/04/01 09:00" and the equipment return date has not been entered.

{  "filter": {   "item": [    {"field_id": "101", "operator": ">=", "value": "2017-04-01T09:00"},    {"field_id": "102", "operator": "is_null"}   ]  } }

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Date/Time	Equipment rental date and time
102	Date/Time	Equipment return date and time

Sample 6

Search conditions when the employee's user system ID is "10" and the leaving time is "22:00" or later

{  "filter": {   "item": [    {"field_id": "101", "operator": "contains", "value": "10", "type": "id"},    {"field_id": "102", "operator": ">=", "value": "22:00"}   ]  } }

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Select User	Employee
102	Time	Leave time

Sample 7

Search conditions that have the same start and end dates

{  "filter": {   "item": [    {"field_id": "101", "operator": "=", "value": "102", "type": "field_id"}   ]  } }

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Date	Start Date
102	Date	End Date

Sample 8

Search conditions that include "quote" in the file name of the sent document

{  "filter": {   "item": [    {"field_id": "101", "operator": "includes", "value": "Estimates"}   ]  } }

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Attachment Files	Documents to be sent

Sample 9

Search conditions with a travel time (auto calculation) of "1 hour and a half (5400 seconds)" or more

{  "filter": {   "item": [    {"field_id": "101", "operator": ">=", "value": " 5400 ", "type": "interval"}   ]  } }

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Auto Calculation	Travel time

Sample 10

Search conditions for which the correctable date (auto calculation) is before "the end of this month"

{  "filter": {   "item": [    {"field_id": "101", "operator": "<", "value": "+0 months:e", "type": "date"}   ]  } }

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Auto Calculation	Correctable date

Sample 11

Search conditions before the estimated arrival date and time (auto calculation) "2017/04/01 17:00"

{  "filter": {   "item": [    {"field_id": "101", "operator": "<=", "value": "2017-04-01T17:00", "type": "datetime"}   ]  } }

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Auto Calculation	Estimated arrival date and time

Sample 12

Search conditions that include "Heisei" or "Showa" in the Western calendar conversion (auto calculation)

{  "filter": {   "item": [    {"field_id": "101", "operator": "includes", "value": "Heisei\t Showa", "type": "textbox"}   ]  } }

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Auto Calculation	Western calendar conversion

Import File

You can add/update data to app with a Excel worksheet (xlsx, 5MB or less) or a text file which is separeted with comma/tab in (csv).
Value formats for each type are the following.

Part Type	Description
Number	Specify number without unit. But number which formatted with Excel worksheet can be imported even if it has unit.
Date	Specify string which is formatted with "YYYY/MM/DD","YYYY-MM-DD" or "YYYYMMDD". But date which is formatted with Excel worksheet can be imported.
Time	Specify string which is formatted with "HH:MM" or "HHMM". But time which is formatted with Excel worksheet can be imported.
Date/Time	Specify string which is formatted with "YYYY/MM/DD HH:MM", "YYYY-MM-DD HH:MM" or "YYYYMMDDHHMM". But date/time which is formatted with Excel worksheet can be imported.
Check Box	Specify new line separeted chosen values.
List Box	Specify new line separeted chosen values.
Select User	Specify new line separete user system ID, login ID or name. "* (Asterisk)" + "User System ID" (e.g. *246) "@ (At mark)" + "Login ID" (e.g. @john0001) "Name" (e.g. John Smith)
Select Group	Specify new line separete group system ID, internal organization code or group name. "* (Asterisk)" + "Group ystem ID" (e.g. *246) "@ (At mark)" + "Internal Organization Code" (e.g. @NEO0001) "Group Name" (e.g. Information System)
Attachment Files	Data Import Batch   Specify relative path from working directory or absolute path. Separate with new line to specify multiple files. Import Tool   Specify relative path from the directory which is specified with "-attach_dir". Files in the subdirectories can be specified with relative path. Separate with new line to specify multiple files. * Attachment files can be imported only with data import batch and import tool. * When a file has too long name, the file can fail to be imported.   In the following case, a file with name with 149 characters (with bytes) can be imported. The directory which is specified with "-attach_dir" is within 59 characters. Desknet's NEO has been installed to within 59 characters path.

[Import Attachment Files]

Example of data import batch with a CSV file on Windows

Name, Photo John Smith,"C:\tmp\image\1\file.png" Chris Doe,"C:\tmp\image\2\file1.png C:\tmp\image\2\file2.png"

Example of data import batch with a CSV file on Linux

Name, Photo John Smith,"/tmp/image/1/file.png" Chris Doe,"/tmp/image/2/file1.png /tmp/image/2/file2.png"

Example of import tool with a CSV file(Specify "C:\tmp\image" to "-attach_dir")

Name, Photo John Smith,"1/file.png" Chris Doe,"2/file1.png 2/file2.png"

Imported data

Name	Photo
John Smith	file.png
Chris Doe	file1.png file2.png