[Windows] To Notify Users' Birthday
This batch displays information on Neotwi's Announcements about who have a birthday in the current week, getting Birthday information from each user's Profile.
It finds those who have a birthday within a week (seven days) since the batch processing.
* We assume that desknet's NEO has been installed to "C:\Inetpub\Scripts\dneo" and provide commands below, so please replace the installation path to fit your environment.
-
To Get the Batch Script
You can use the batch file (zbatopt.bat) placed in the option batch installation folder.
The command in the batch file has the following activation parameters.
Execution parameters:
| -h | [desknet's NEO installation path] (Required) |
| -s | [The path to save the status file created by the batch module.] (Required) |
| -command | [bd] (Birthday notify command) (Required.) |
The zbatopt.bat file has the command below.
"C:\inetpub\scripts\dneoopt\zbatopt.exe" -h "C:\inetpub\scripts\dneo" -s "C:\inetpub\scripts\dneoopt\sts" -command bd
Change the command to fit your environment, using Notepad (a Windows accessory application) or other text editor.
-
Automatic birthday notification batch settings
You can use Task Scheduler of Windows system tools to execute birthday notification batch regularly.
Set the execute date and time for the created zbatopt.bat.
We recommend to set the batch to be executed once a week to announce information
about those who have a birthday within the next one week period.
-
Confirming the execution
A notification of "X people have birthday this week" is displayed on Announcements of Neotwi.
* The notification will be displayed after the birthday notification batch is executed.
[Windows] To Export Access Log Summary
This batch exports the results of [Setup]-[Log]-[Access Log Summary] to a csv file, using the command line.
* We assume that desknet's NEO has been installed to "C:\Inetpub\Scripts\dneo" and provide commands below, so please replace the installation path to fit your environment.
-
To Get the Batch Script
You can use the batch file (zbatoptacntexp.bat) placed in the option batch installation folder.
The command in the batch file has the following activation parameters.
Execution parameters:
| -h | [desknet's NEO installation path] (Required) |
| -s | [The path to save the status file created by the batch module.] (Required) |
| -f | [The full file path to export.] (Required) |
| -l | [The path to save the error logs created by the batch module.] |
| -c | [sjis | utf8n | utf8] (Character encoding used for exporting the file. If not specified, sjis will be used.) |
| -m | [comma | tab] (Delimiter character used for exporting the file. If not specified, comma will be used.) If not specified, sjis will be used.) |
The zbatoptacntexp.bat file has the command below.
"C:\inetpub\scripts\dneoopt\zbatoptacntexp.exe" -h "C:\inetpub\scripts\dneo" -s "C:\inetpub\scripts\dneoopt\sts" -f "C:\inetpub\scripts\dneoopt\csv\acccntexport.csv"
Change the command to fit your environment, using Notepad (a Windows accessory application) or other text editor.
-
Execute the Batch File
Using Window's Command Prompt, execute the export.
2-1. Click [Start]-[Programs]-[Accessories]-[Command Prompt] and open the Command Prompt on the server.
2-2. Execute the batch file on the command prompt.
|
> C:\Inetpub\Scripts\dneoopt\zbatoptacntexp.bat
|
[Windows] To Export Access Logs
This batch exports the results of [Setup]-[Log]-[Access Log Settings] to a csv file, using the command line.
* We assume that desknet's NEO has been installed to "C:\Inetpub\Scripts\dneo" and provide commands below, so please replace the installation path to fit your environment.
-
To Get the Batch Script
You can use the batch file (zbatoptalogexp.bat) placed in the option batch installation folder.
The command in the batch file has the following activation parameters.
Execution parameters:
| -h | [desknet's NEO installation path] (Required) |
| -s | [The path to save the status file created by the batch module.] (Required) |
| -f | [The full file path to export.] (Required) |
| -l | [The path to save the error logs created by the batch module.] |
| -c | [sjis | utf8n | utf8] (Character encoding used for exporting the file. If not specified, sjis will be used.) |
| -m | [comma | tab] (Delimiter character used for exporting the file. If not specified, comma will be used.) If not specified, sjis will be used.) |
| -r | [1] (If 1 is specified, exported logs will be deleted from the server.) |
| -sdt | [YYYYMMDD[hhmm]] (Start date and time of logs to be exported.) |
| -edt | [YYYYMMDD[hhmm]] (End date and time of logs to be exported.) |
| -timeout | [seconds] (Maximum value of timeout on the database connection.) |
The zbatoptalogexp.bat file has the command below.
"C:\inetpub\scripts\dneoopt\zbatoptalogexp.exe" -h "C:\inetpub\scripts\dneo" -s "C:\inetpub\scripts\dneoopt\sts" -f "C:\inetpub\scripts\dneoopt\csv\acclogexport.csv"
Change the command to fit your environment, using Notepad (a Windows accessory application) or other text editor.
-
Execute the Batch File
Using Window's Command Prompt, execute the export.
2-1. Click [Start]-[Programs]-[Accessories]-[Command Prompt] and open the Command Prompt on the server.
2-2. Execute the batch file on the command prompt.
|
> C:\Inetpub\Scripts\dneoopt\zbatoptalogexp.bat
|
[Windows] To Delete Data Exceeding Its Storage Period
This batch deletes old data, ignoring the specified period of [Setup]-[Basic Settings]-[Data Retention Settings].
* You cannot manually execute this batch script anymore, because the script is now automatically executed by a standard module since desknet's NEO V2.0R1.0.
* We assume that desknet's NEO has been installed to "C:\Inetpub\Scripts\dneo" and provide commands below, so please replace the installation path to fit your environment.
-
To Get the Batch Script
You can use the batch file (zbatoptsavedel.bat) placed in the option batch installation folder.
The command in the batch file has the following activation parameters.
Execution parameters:
| -h | [desknet's NEO installation path] (Required) |
| -s | [The path to save the status file created by the batch module.] (Required) |
| -m | [sch | todo | memo | tcard | flow | creport | agenda | info | koubai | pay | stock | enq | log] (Specify either one application.) (Required.) |
| -save | [1-36] (Choose a period of months from 1 to 36. The old data over the specified month(s) ago will be deleted.) (Required.) |
Each choice of the -m option indicates:
| sch | : Schedule and Facility Reservation |
| todo | : ToDo |
| memo | : Whereabouts |
| tcard | : Time Card |
| flow | : Workflow |
| creport | : Circulation/Report |
| agenda | : Minutes |
| info | : Information |
| koubai | : Store |
| pay | : Expense Claim |
| stock | : Inventory |
| enq | : Questionnaire |
| log | : Access Logs |
The zbatoptsavedel.bat file has the command below.
"c:\Inetpub\Scripts\dneoopt\zbatoptsavedel.exe" -h "c:\Inetpub\Scripts\dneo" -s "c:\Inetpub\Scripts\dneoopt\sts" -m sch -save 24
Change the command to fit your environment, using Notepad (a Windows accessory application) or other text editor.
-
Execute the Batch File
Using Window's Command Prompt, execute the export.
2-1. Click [Start]-[Programs]-[Accessories]-[Command Prompt] and open the Command Prompt on the server.
2-2. Execute the batch file on the command prompt.
|
> C:\Inetpub\Scripts\dneoopt\zbatoptsavedel.bat
|
[Windows] To Add (Import) Masses of Email Accounts to WebMail IMAP
This batch adds masses of email accounts from files, which the users are to use in the WebMail IMAP application.
* We assume that desknet's NEO has been installed to "C:\Inetpub\Scripts\dneo" and provide commands below, so please replace the installation path to fit your environment.
-
Editing CSV File To Import
* You can refer the CSV file format by exporting an email account.
* From V6.1R1.0, Authenticaion Method and OAuth Authorization server has been added.
If you are importing CSV file for Webmail IMAP from the previous version, please set Authentication method to "Standard(APOP)" and OAuth Authentication Method to empty value.
Format of data in a CSV file
Delete flag, user system ID, username, account system ID, display name, email address, user ID, password, Authentication Method, OAuth Authentication server, SMTP authentication ID. SMTP authentication password and usage
| To delete an existing user, set "D" or "d" to Delete Flag. |
* Specify the user's "System User ID" in the "System User ID"
(You can check the user system ID of an existing user by exporting the user.) |
| * To add a new account data, specify "0" in the Account System ID. |
To overwrite an existing account data, set its Account System ID .
(You can check the account system ID of an existing account by exporting the account.) |
| * User Name is not be imported. |
| * User System ID and Email Address are mandatory. |
| * Specify any number of "*" if you do not want to change a password. |
| * Specify "APOP" or "Standard(APOP)" in the Authentication Method when the server requires it. |
* Specify "XOAUTH2" in the Authentication Method when the server requires it.
Please copy the "Authorization Server's System ID" in [Administrator Settings > System Settings > OAuth Authorization Server Settings] and paste it to the "OAuth Authorization Server" field. |
| * Not to change the password in SMTP Authentication Password, specify any number of "*". |
* To allow the usage of WebMail IMAP, specify "Use" to Usage.
Specify Do not use if you wish to now allow the usage of WebMail IMAP. |
-
To Get the Batch Script
You can use the batch file (zbatmailimapaccimp.bat) placed in the dneoopt folder, which runs the batch program (desknet's NEO installation path\zbatmailimapaccimp.exe).
The command in the batch file has the following activation parameters.
Execution parameters:
| -h | [desknet's NEO installation path] (Required) |
| -s | [The path to save the status file created by the batch module.] (Required) |
| -f | [The full file path to import.] (Required) |
| -l | [The path to save the error logs created by the batch module.] |
| -c | [sjis | utf8n | utf8] (Character encoding used for importing the file. If not specified, sjis will be used.) |
| -m | [comma | tab] (Delimiter character used for importing the file. If not specified, comma will be used.) If not specified, sjis will be used.) |
| -t | [ignore] (Ignore the first line of the import file. If not specified, the first line will be read.) |
The zbatmailimapaccimp.bat file has the command below.
"C:\inetpub\scripts\dneoopt\zbatmailimapaccimp.exe" -h "C:\inetpub\scripts\dneo" -s "C:\inetpub\scripts\dneoopt\sts" -f "C:\inetpub\scripts\dneoopt\csv\imapaccimp.csv"
Change the command to fit your environment, using Notepad (a Windows accessory application) or other text editor.
-
Execute the Batch File
Using Window's Command Prompt, execute the import.
2-1. Click [Start]-[Programs]-[Accessories]-[Command Prompt] and open the Command Prompt on the server.
2-2. Execute the batch file on the command prompt.
|
> C:\Inetpub\Scripts\dneoopt\zbatmailimapaccimp.bat
|
-
Check to be Sure the Batch has Run
Open desknet's NEO's WebMail IMAP > Application Management > Account Settings screen,
and check if the users have been added.
[Windows] To Save (Export) WebMail IMAP Email Accounts to File
This batch saves information to a file about the email accounts used in the WebMail IMAP application.
* We assume that desknet's NEO has been installed to "C:\Inetpub\Scripts\dneo" and provide commands below, so please replace the installation path to fit your environment.
-
To Get the Batch Script
You can use the batch file (zbatmailimapaccexp.bat) placed in the dneoopt folder, which runs the batch program (desknet's NEO installation path\zbatmailimapaccexp.exe).
The command in the batch file has the following activation parameters.
Execution parameters:
| -h | [desknet's NEO installation path] (Required) |
| -s | [The path to save the status file created by the batch module.] (Required) |
| -f | [The full file path to export.] (Required) |
| -l | [The path to save the error logs created by the batch module.] |
| -c | [sjis | utf8n | utf8] (Character encoding used for exporting the file. If not specified, sjis will be used.) |
| -m | [comma | tab] (Delimiter character used for exporting the file. If not specified, comma will be used.) If not specified, sjis will be used.) |
| -g | [Group system ID] (Group system ID of the user to be exported to a file.) |
The zbatmailimapaccexp.sh file has the command below.
"C:\inetpub\scripts\dneoopt\zbatmailimapaccexp.exe" -h "C:\inetpub\scripts\dneo" -s "C:\inetpub\scripts\dneoopt\sts" -f "C:\inetpub\scripts\dneoopt\csv\imapaccexp.csv"
Change the command to fit your environment, using Notepad (a Windows accessory application) or other text editor.
-
Execute the Batch File
Using Window's Command Prompt, execute the export.
2-1. Click [Start]-[Programs]-[Accessories]-[Command Prompt] and open the Command Prompt on the server.
2-2. Execute the batch file on the command prompt.
|
> C:\Inetpub\Scripts\dneoopt\zbatmailimapaccexp.bat
|
[Windows] To Specify Range of Users and Sync with Outlook Calendar
This batch is for specifying range of users and sync their desknet's NEO Schedule with their Outlook Calendar.
There are cases which the integrated users or the events to sync are too many, so running usual automatic sync will take a lot of time.
You can specify ranges of users to sync and divide the job to multiple parallelly running batch.
* In the explanation, the command example is described assuming that the installation destination of desknet's NEO is "C:\Inetpub\Scripts\dneo", and it may be different from your environment.
* If you plan to use this batch, please turn off automatic sync by setting "Automatic Sync" to "No" and "Individual Setting" to "Disallow" in System Management > General Setting for Microsoft 365 Integration.
(For more information, please refer to
Microsoft 365 Integration > General Settings in System Management Manual.)
-
Edit Batch File to Set User Range and Sync Between desknet's NEO Schedule and Outlook Calendar
You can use the batch file located inside dneoopt folder to set user range and sync events (zbato354schusers.bat), which run the batch program (desknet's NEO installation path\zbato365schusers.exe).
The command in the user range sync batch file has the following activation parameters.
Execution parameters:
| -h | [desknet's NEO installation path] (Required) |
| -s | [The path to save the status file created by the batch module.] (Required) |
| -fromuid | [User ID (Lower limit)] (Required) |
| -touid | [User ID (Upper limit)] (Required) |
* Please ensure the ID range does not overlap.
The zbato365schusers.bat file has the command below.
"C:\inetpub\scripts\dneoopt\zbato365schusers.exe" -h "C:\inetpub\scripts\dneo" -s "C:\inetpub\scripts\dneoopt\sts" -fromuid 1 -touid 1"
Change the command to fit your environment, using Notepad (a Windows accessory application) or other text editor.
If you plan to run the batch parallelly, please refer to the example below:
Batch 1 : "C:\inetpub\scripts\dneoopt\zbato365schusers.exe" -h "C:\inetpub\scripts\dneo" -s "C:\inetpub\scripts\dneoopt\sts1" -fromuid 1 -touid 100
Batch 2 : "C:\inetpub\scripts\dneoopt\zbato365schusers.exe" -h "C:\inetpub\scripts\dneo" -s "C:\inetpub\scripts\dneoopt\sts2" -fromuid 101 -touid 200
* If you plan to run the batch parallelly, please make sure the status file path is different from each other.
-
Execute the Batch File
Execute the sync batch file using Window's Command Prompt.
2-1. Click [Start]-[Programs]-[Accessories]-[Command Prompt] and open the Command Prompt on the server.
2-2. Execute the batch file on the command prompt.
|
> C:\Inetpub\Scripts\dneoopt\zbato365schusers.bat
|
-
Run the batch file automatically
You can use Task Scheduler from Windows system tools to execute this batch regularly.
* Click [Control Panel]-[Administrative Tools]-[Task Scheduler] to open Task Scheduler from the Control Panel.
Set the execute date and time for the created zbato365schusers.bat.
-
Confirming the execution
Check if desknet's NEO Schedule with Outlook Calendar has synchronized.
