4. Select Database Group ID

Select Database Group ID


  • What I did to solve this in the past is one of two ways,

    • Creating a new table inside the database with "Name" (String) | "ID" (String) and adding the group's name & id when ver it's created. Calling them into a List, Object, etc at the OnApplicationStart (readfile "firstrun.txt" with value of "true/false" if true create all groups that are needed else read database to variable) No point in reading the Database each time for the ID unless you plan on changing it.

    • Creating a config file that's read using the project_path() function.
      To change a [[GLOBAL:JSON_OBJECT]] value you need to call the JSON outside of BAS variable change the value, then back to BAS & save the [[GLOBAL:JSON_OBJECT]] to file. Like so..

    var obj = [[GLOBAL:JSON_GROUPINFO]];
obj[([[GROUP_NAME]])] = {"ID": [[GROUP_ID]]};
PSet("basglobal", "JSON_GROUPINFO", JSON.stringify(obj));

    You can change the value easy on local variables

    [[JSON_OBJECT]][([[GROUPNAME]])] = {"ID": [[GROUP_ID]]} // Creating the ID Object
// 3 below is to CHANGE (not create)
[[JSON_OBJECT]][([[GROUPNAME]])].ID = [[NEW_ID]] // (For variables as the name since [[VAR1]][[[VAR2]]] gives a JSON error (x3 [[[ & ]]] )
[[JSON_OBJECT]].MyGroupName.ID = [[NEW_ID]]
[[JSON_OBJECT]]["MyGroupName"]["ID"] = [[NEW_ID]]

    To get the project_path it will return the .xml file too. Here's a snippet to take that out.
    Value AS Expression
    (project_path()).match(/(.*)[/\]/)[1]||''
    Can add more Regex to allow the path be outside the AppData just encase you update the bot with a new BAS Studio Version.

    Let me know if this helps!

    Allister ☯

    0 Replies: 1
  • C

    @Allister I definitely am a bit confused on how to do this from reading your post. So the only way to get the "Insert record" feature to work is to do some unintuitive methods?

    I was trying to follow tutorial #3 but got stuck at the insert record part. Just want my data to be moved to the correct group and I have the rest of the script working.

    So let me see if I have this right based off of what you said.

    1. Make a new table in my current database.
    2. Name the columns in the new table "Name"(String) and "ID"(string)? Or is that supposed to be the name of the table itself?
    3. Adding the groups name and id somewhere (What is a ver?) (Im really not getting this part)

    Im not seeing how making a new table will allow me to write the data to my previous table I am trying to write to

    1 Replies: 1

  • @cleez said in Select Database Group ID:

    @Allister I definitely am a bit confused on how to do this from reading your post. So the only way to get the "Insert record" feature to work is to do some unintuitive methods?

    Sorry, for the lack of explanation. I've created a example for you & everyone else who needs it. I threw this together real fast so it's not that neat but it gets the job done. :)

    Make sure not to run it with "first run = true" more then once. (why I set default to false). This can be fixed with simple checks on the Group Table. Select --> if (groupname exist).. etc and then you can drop the resource bool.

    @cleez said in Select Database Group ID:

    Im not seeing how making a new table will allow me to write the data to my previous table I am trying to write to

    on the "Show Database" you'll need to manually create the table. After that, the script will create the groups that's need (hard coded, or resourced friendly). If you have any questions about the example let me know! :)

    Allister ☯

    0_1506976172410_cleez-database-example.xml

    1 Replies: 1
  • C

    @Allister Okay I think I am getting what you are saying about the program making the groups as needed and putting the apprioprate data in there. This will only make the groups on the first run correct? Afterwards it will just put the data in the groups?

    Also is it possible to copy and paste this script into one I have already created?

    0 Replies: 1

  • @cleez said in Select Database Group ID:

    This will only make the groups on the first run correct? Afterwards it will just put the data in the groups?

    Correct, or like I said you can have it check if the groups already exist, if they don't create them else it will create a Global Json Object. One thing I forgot to mention, when creating Global Json Object at run time, you'll need to change the spaces (if any) to "_" or "-" or completely remove them. This can be done with a split or regex or a replace.

    @cleez said in Select Database Group ID:

    Also is it possible to copy and paste this script into one I have already created?

    Yes just open the project in a new BAS studio and you can copy the commands over. You'll need to edit each Database command and change the values & table since the scripts database ID's might be off. (Database Schema in the .xml at the bottom)

    Allister ☯

    1 Replies: 1
  • C

    @Allister Alright cool, I tried to run it just to test and its saying

    TypeError: Result of expression 'JSON.parse(P("basglobal", "JSON_GROUPINFO") || '""').ActiveAccounts' [undefined] is not an object. Line number:2 During execution of script { _sa(44666115); var group = (JSON.parse(P("basglobal", "JSON_GROUPINFO") || '""').ActiveAccounts.ID) if(group.length == 0) group = P("_bas_table_" + (1), "_last_group") VAR_NEW_RECORD_ID = _db_add_record(group, [2,VAR_USERNAME,3,VAR_PASSWORD], 1) _next_or_section(123113051,function(){ })}
    0 Replies: 1

  • @cleez

    Doesn't look like you created the Object for ActiveAccounts
    Look on the example. OnApplicationStart ---> (close to bottom) ----> Foreach (GROUP_LIST)

    var obj = [[GLOBAL:JSON_GROUPINFO]];
obj[([[GROUP_NAME]])] = {"ID": [[GROUP_ID]]};
PSet("basglobal", "JSON_GROUPINFO", JSON.stringify(obj));

    In the example it selects all the groups in Group Table, then loops through them, parsing the line and "creating" the object for each group.

    Allister ☯

    0 Replies: 1
  • C

    @Allister Weird enough i was using the example without changing anything just to try it. IS it possible I didnt set the table up correctly? Should I just delete all this and start over fresh

    picture of the code
    http://prntscr.com/gshryu

    0 Replies: 1

  • @cleez

    Hmmm. I downloaded and ran it. Worked for me. Did you run it fully with "First Run?" set to true?
    https://i.imgur.com/XbyhOWK.gifv

    0 Replies: 1
  • C

    @Allister Yea I set it to true, its goes as far as making the groups before it stops. Should I be manually making the database and table before I run the script(Thats what I did before I ran it the first time)

    Screenshot
    http://prntscr.com/gshvc7

    0 Replies: 1

  • @cleez
    On the Data Manager ----> File ---> Delete All Data
    Then run it like I did in the gif I added. to the post above.

    The script will create the Groups & add the groups with the ID's to the "Group" table if First Run? = true. After, it will selected all records in the Group Table, create the Global Object & then add each Group to the Global Object as an Object.

    There should be no need to manually create anything in the database since the script has the Database Name & Schema in the xml file. Try closing the BAS Studio & deleting the database in C:\Users\{YOURPCNAME}\AppData\Local\BasDatabases\Database.19545. Then restart BAS.

    1 Replies: 1
  • C

    @Allister I think I figured out what I did wrong. The first time i ran it i didnt open the database so it could restart after opening the XML file. Then I ran the script for first time user etc and restarted the database. Im pretty sure somewhere in there I screwed something up for that profile.

    I redownloaded your example and deleted the old database and reran it and it all worked this time around.

    Thank you for all the help, im going to play around with this for the next few hours and if i run into trouble ill @ you

    1 Replies: 1

  • @cleez

    Oh yes, if you open a new project with a database you need to restart that certain Studio (when having multiple BAS Studio's running). ^_^ I forget that sometimes too. In-fact I spent 2 hours on a project debugging the sucker only to find out that was the cause of all my problems.

    1 Replies: 1
  • C

    @Allister Haha that sounds annoying, last night I spent a few hours wondering why my database wasnt using both columns until i realized you need to add text to the description part of the column string

    1
  • C

    @andykaufseo I found an easier way

    0
  • A

    @cleez please share with us...

    0 Replies: 1
  • C

    @andykaufseo Make a new function, inside that turn on http://wiki.bablosoft.com/doku.php?id=i_want_to_run_some_actions_on_start_one_time

    inside of that you will use the "Create group" feature. That feature will create a group with an id with a variable called something like " new group id". Use the log feature and put in that new group id variable to capture that groups id.

    Run it once and in the output on the bottom you will see the group id. From there copy and paste it into the "insert record" feature and you will be good to go.

    0
  • A

    Really appreciate it but damn, this is not what i had in mind - too complicated to select a group ID. i think someone who built BAS should answer this question - it should be a simple thing and the Group ID should be listed somewhere - it seems like a big design error of BAS to have things like this missing...

    0 Replies: 1
  • C

    @andykaufseo I agree it is a design error imo but my suggestion is simple, after you get the id you can delete the create group stuff. Well its a temp solution until they make it simpler.

    0
  • administrators

    @andykaufseo I didn't read all thread, but here is answer for original question.
    You can insert only to new group, which is created with Create Group action.
    Create Group returns group id, which can be used later inside Insert Record action.

    There will be interface to search/edit/delete groups but later.

    1
Log in to reply
 

Looks like your connection to Bablosoft was lost, please wait while we try to reconnect.