{"code":-1,"error":"com.keplerrominfo.sil.lang.SILException","message":"SIL program '[inline source]', parse exception: Missing ';' separator in line 1 column 12 ?\nEncountered [ ([) at line 14, column 3. Was expecting: \n","causes":["com.keplerrominfo.sil.lang.SILException- SIL program '[inline source]', parse exception: Missing ';' separator in line 1 column 12 ?\nEncountered [ ([) at line 14, column 3. Was expecting: \n","com.keplerrominfo.refapp.sil.impl.AbstractSimpleLanguageService.interpret(AbstractSimpleLanguageService.java:184)","..........","com.keplerrominfo.sil.lang.grammar.SilParseException- Missing ';' separator in line 1 column 12 ?\nEncountered [ ([) at line 14, column 3. Was expecting: \n","com.keplerrominfo.sil.lang.executors.DirectInterpreterExecutor.createParseError(DirectInterpreterExecutor.java:205)",".........."],"fieldErrors":{}}

Hi @Gaurav Kumar , As I understand from your requirement, you want to activate the users when the ticket(jira issue) moves to "in progress" state. to activate the user , you will first need to get the user details. in our previous example, we were using the csv file to get the user details. now that you want to automate the process, I assume that the user details is somewhere available in the ticket. custom field can be of many types, description is a system field. We can read the description field with the sil script and but there could many other values with the user details in the description field. if your description field only has the user value it will be easy to read the field and then activate the user. else it will be very difficult for the script to understand the username from all the values which is mentioned in the description. I suppose your ticket contains user details in the description, therefore it could be difficult to get the user details. can you answer the below: 1) Does user details which you want to activate is stored in any other field other than description? if yes, please share the type of field. 2) If the user details are mentioned in the description field, Does the description field has a predefined format where the user details are entered? can you share the sample data of description field and which value you want to activate.

Hi @Neel Mohapatra _Appfire_ Any thoughts on it?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

While executing SIL Script for reactivation of users in jira i am getting the below error

Gaurav Kumar_86edda

{"code":-1,"error":"com.keplerrominfo.sil.lang.SILException","message":"SIL program '[inline source]', parse exception: Missing ';' separator in line 1 column 12 ?\nEncountered [ ([) at line 14, column 3. Was expecting: <EOF>\n","causes":["com.keplerrominfo.sil.lang.SILException- SIL program '[inline source]', parse exception: Missing ';' separator in line 1 column 12 ?\nEncountered [ ([) at line 14, column 3. Was expecting: <EOF>\n","com.keplerrominfo.refapp.sil.impl.AbstractSimpleLanguageService.interpret(AbstractSimpleLanguageService.java:184)","..........","com.keplerrominfo.sil.lang.grammar.SilParseException- Missing ';' separator in line 1 column 12 ?\nEncountered [ ([) at line 14, column 3. Was expecting: <EOF>\n","com.keplerrominfo.sil.lang.executors.DirectInterpreterExecutor.createParseError(DirectInterpreterExecutor.java:205)",".........."],"fieldErrors":{}}

Accepted answers

All comments

Neel Mohapatra _Appfire_

Hi @Gaurav Kumar

the error says

Missing ';' separator

which could mean that some line of code is not ending properly and you may need to add ; at the end.

If you can share the code that you are trying to execute, that would help to understand the issue better.

Gaurav Kumar_86edda

Hi @Neel Mohapatra _Appfire_ Please find the details below. Please help with the execution of the below code

import com.atlassian.jira.component.ComponentAccessor
import com.onresolve.scriptrunner.runner.util.userMessageutil

def userManager = ComponentAccessor.userManager

//Read the username from the file

def username = new File (".../.../.../.../inputfile.csv").test.trim()

//Find the user by username

def user = UserManager.getuserbyName(username)

if(user) {

//Reactivate the user
user.setActive(true)
usermanager.updateuser(user)

return "User ${username} has been reactivated."
} else {

return "user${username} not found."

}

Amelie Winkler _Appfire_

Hi @Gaurav Kumar , @Neel Mohapatra _Appfire_ is correct – it seems like you're missing the ";" symbol after reactivated.".

Try the following:

return "User ${username} has been reactivated.";
} else {

Gaurav Kumar_86edda

Hi @Amelie Winkler _Appfire_ tried to execute the script still getting the below error-

SIL program '[inline source]', parse exception: Missing ';' separator in line 1 column 12 ? Encountered ( (() at line 14, column 3. Was expecting: <EOF>

Neel Mohapatra _Appfire_

Hi @Gaurav Kumar

Looks like you are trying to execute the groovy code in sil manager.

Kindly make use of below routine to activate users from csv file.

https://appfire.atlassian.net/wiki/spaces/PSJ/pages/15481241/admActivateUser

https://appfire.atlassian.net/wiki/spaces/PSJ/pages/15489831/readFromCSVFile

below is the sample code that you can use.

eg:

string [] fileContent = readFromCSVFile("users.csv", true);

for (string usr in fileContent ) {
boolean s = admActivateUser(usr); //activating users, if sucessfully activated returns tru else false
runnerLog("user " + usr +" activation status is : "+ s); //showing result in editor console

}

if you have latest version of power script installed you will be able to upload the csv file into the silprograms folder, just by right clicking on it.
else you can manually move the file under silprograms.

it should look something like this.

then you can use the code i shared above and make sure to check the script before clicking on green play button. if there are any errors it will show it to you .

once the code does not have any error, you can click on play button to run the script and you should see the result in the editor console.

eg:

you can also use printInfile routine instead of runner log, if you want to save the output in a file.
https://appfire.atlassian.net/wiki/spaces/PSJ/pages/15489159/printInFile

Let me know if it helped!

Gaurav Kumar_86edda

Hi @Neel Mohapatra _Appfire_ thank you for the detailed steps. However post checking for syntax error it was successful but while running the script it it showing below error in editor console-

Exception while executing SIL program '[inline source]': [SIL Error on line: 1, column: 25] File >>users.csv<< cannot be found!

the user.csv file contains the below details-

issue key,
ahmed.khan2,

Neel Mohapatra _Appfire_

Hi @Gaurav Kumar ,

Looks like the script is not able to find the CSV file.

Did you make sure you have a users.csv file under silprograms folder?

the csv file should contains the user names, just to let you know key word "issue key" is not needed.

Did you try to upload the csv file? or did you place the CSV file manually into the silprograms folder?

you can also use the complete path of the file.

It is advised to use the file inside silprograms folder so that there is no permission issue.

to check the full path of sil programs you can go to power app config and look for sil storage as shown below.

then you can use the complete path of the file.
eg:

note:
please check if the csv file has at least read permission.
please check if you have moved the file inside the silprograms folder.

You are very close to get the script working, let me know if it helped.

Gaurav Kumar_86edda

Hi @Neel Mohapatra _Appfire_

i have tried executing the script and see that the user is getting reactivated successfully.

Thanks you for all your efforts in helping me with the script creation.

Thanks-

Gaurav

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-software

unknown-hosting-type