cdbUsers table

[clarencemartin]

I was having problems loading the cdbUsers table using the cdb_load("cdbUsers") name. I found that the actual name had some information in parenthesis and I can't remember that information. I actually changed the name of the table and now I cannot access that table.
I thought that renaming the user table was supposed to be disabled, is this true?
I need some help with this.

[Linda Lu]

Hello,

Thank you for letting us know that the cdbUsers table can be renamed. You are correct that this should not happen and we will make an update to address this issue.

I have sent you a PM with some instructions that I would like you to try. Please let me know if you have further questions or are still experiencing issues accessing the table.

To retrieve the full name of the cdbUsers table, you can call cdb_userTableName with the name of your project as the parameter or cdb_tableName with the table ID of the cdbUsers table as the parameter.

[clarencemartin]

Thanks, Linda.
I remembered this fact too late. now that I messed things up by renaming the cdbUsers table, is there a way to correct it?
The system will not allow me to add a table with the cdbUsers name.

[Linda Lu]

Thanks, Linda.
I remembered this fact too late. now that I messed things up by renaming the cdbUsers table, is there a way to correct it?
The system will not allow me to add a table with the cdbUsers name.

I sent you a PM here on the forum with instructions to try and reverse the process. If you do not see that message, I can try and email them to you.

[clarencemartin]

Thanks, Linda everything worked.

[clarencemartin]

Linda,
The one problem that exists now is there is a hyphen in the cdbUsers table Name
if I do a answer cdb_tablename("dd07bc8c-1ec5-473b-aabb-5271c60a9bb6") in the message box it shows the table name as USMDdata-

[Linda Lu]

Linda,
The one problem that exists now is there is a hyphen in the cdbUsers table Name
if I do a   answer cdb_tablename("dd07bc8c-1ec5-473b-aabb-5271c60a9bb6") in the message box it shows the table name as USMDdata-

The full name of the cdbUsers table should be "cdbUsers-" + the project ID it belongs to. For example, if your project ID was "8fc03fe9-cd65-5358-hjk6-df85eb363984", the cdbUsers table name would be "cdbUsers-8fc03fe9-cd65-5358-hjk6-df85eb363984".

If you call cdb_userTableName() or cdb_tableName() on the cdbUsers table of another project, it should return in the same format but with that project's ID.

[clarencemartin]

the added tableID is not included in my table name.

this is the code that I used:
local tNewName, tOutputA, tProjectID, tTableID
put cdb_projectID(,USMDdata) into tProjectID
put "cdbUsers-" & "c1d46708-7c49-4183-99fa-3741ffa8ae5e" into tNewName
put "dd07bc8c-1ec5-473b-aabb-5271c60a9bb6" into tTableID
cdb_renameTable tTableID,tNewName
put cdb_tableName(tTableID) into tOutputA

---

what am I doing that is wrong?

[Linda Lu]

the added tableID is not included in my table name.

this is the code that I used:
local tNewName, tOutputA, tProjectID, tTableID
put cdb_projectID(,USMDdata) into tProjectID
put "cdbUsers-" & "c1d46708-7c49-4183-99fa-3741ffa8ae5e" into tNewName
put "dd07bc8c-1ec5-473b-aabb-5271c60a9bb6" into tTableID
cdb_renameTable tTableID,tNewName
put cdb_tableName(tTableID) into tOutputA

---

what am I doing that is wrong?

Try the code below:

Code:

local tNewName, tOutputA, tProjectID, tTableID
put cdb_projectID(,"USMDdata") into tProjectID
put "cdbUsers-" & tProjectID into tNewName
put "dd07bc8c-1ec5-473b-aabb-5271c60a9bb6" into tTableID
cdb_renameTable tTableID,tNewName
put cdb_tableName(tTableID) into tOutputA

The output should be "cdbUsers-" followed by the project ID of "USMDdata".

[clarencemartin]

OK, I think that I am just making massive mistakes here. I'll try again

---

ok, when id commit the following command in my script
code:
get cdb_auth(fld "Email-input" of grp "login",fld "Password-input" of grp "login","user")
put cdb_authStatus() into tAuthStatusA
I am not getting good results
the results are:
(2021-04-21 11:02:43.243): Local authentication passed: local data verified
(2021-04-21 11:02:43.368): TableName provided is not a valid tableName: cdbUsers-c1d46708-7c49-4183-99fa-3741ffa8ae5e
(2021-04-21 11:02:43.368): Missing critical data needed to write to cloud.
(2021-04-21 11:02:43.368): Error: Upload to Server Failed.
(2021-04-21 11:02:43.368): Error: Cloud authentication - it appears we are offline

---

also, using LCM, I cannot edit any user information.
I get "Missing critical data needed to write to the cloud.