Jump to content

User Status via Importer


Recommended Posts

Hi all,

I've recently updated to the new Importer and whilst attempting to configure the conf.json I keep running into an issue where the value of 'status' that we're passing over is not being accepted.  

 

Here is the relevant line from the SQL query: 

THEN 'active' ELSE 'archived' END AS [status] 

Here is the entry in conf.json:

    "Status":{
        "Action":"Both",
        "Value":"{{.status}}"
    },

 

The error states:

Error: The value '{{.status}}' for element <accountStatus> is not an allowable value at location '/methodCall/params/accountStatus'

 

Can anyone advise what I've done wrong?

Link to comment
Share on other sites

@Steve Giller No luck with that either I'm afraid. Here's the snippet from the documentation on the wiki:

   "Status":{
     "Action":"Both", /* options : Create/Update/Both ; on what action to change the User Account Status */
     "Value":"active" /* options : active/suspended/archived */
   },
Link to comment
Share on other sites

@Drew Davies Sorry, my mistake - I think I misread the error.

2 hours ago, Drew Davies said:

The value '{{.status}}' for element <accountStatus> is not an allowable value

It's the {{.status}} that's not being accepted. The Tool translates the active/suspended/archived to the correct numeric value.

Can I check that you're using the SQL User Import tool? If so which version are you using, and what is your Data Source?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...