Best way to: Add 3000+ unique codes to a field on each profile, or PM?

[socceronly]

We need to get over 3000 unique codes, one to each user in a specific user group.   They will be in a CSV or spreadsheet

We could put this in a field, or send a PM.

Our site is in CIC.

What suggestions would you have for doing this?  

Direct DB access?  Get a plug in made? 

Manual is out, even with ten of us because the codes need to go up with timing to online sales. 

Thanks
JM




 

[Randy Calvert]

CiC does not include direct database access. Your best bet would be to have some sort of plugin created or to leverage the REST API to script the work. 

[socceronly]

3 minutes ago, Randy Calvert said:

CiC does not include direct database access. Your best bet would be to have some sort of plugin created or to leverage the REST API to script the work. 

I think a plug in would be best too. 

I thought there was a way to get DB access in CIC. It's not obvious, but thought it was there.   Perhaps they (understandably) don't want to make it easy.

[IveLeft...]

43 minutes ago, socceronly said:

I thought there was a way to get DB access in CIC. It's not obvious, but thought it was there.   Perhaps they (understandably) don't want to make it easy.

CiC = No DB Access - No FTP Access - No File Access.........All you get is the front end and ACP.......

[Randy Calvert]

There used to be access to the SQL tool in the Support area of the ACP.  But that was removed awhile back.  As @Muddy Bootsnoted...  there is not any sort of direct access to the files or data.  Think of it like working in Gmail.