Hi Bonnie, When running the RQL from user-defined job, you need
<IODATA loginguid="[!guid_login]" session="[!key!]"> . . . </IODATA> just leave [!guid_login] and [!key] as it is because when the user defined job runs with the supplied user account, these variables will get replaced with actual guids. You may ask why you don't have to include <IODATA> in RQLConsole. Well, because I use RQLConsole a lot and I hate to type in IODATA a lot, so I have the plugin to add it in for me automatically. There is an option in RQL manage for it not to automatically add it in. Best, -Jian On Wednesday, July 18, 2012 12:25:35 PM UTC-4, Bonnie Cohen wrote: > > Hi Jian. I downloaded and had our sys admins install the plugin for me. > (Us developers are not allowed access to the servers.) Awesome! I was able > to test my RQL and get it working. I clicked the "i" information icon and > was able to get the correct session key... which was seems to have been the > issue. *By the way - " You are missing data with your IDATA tag." I'm > using the User-Defined job to run this RQL so, with hainv to enter the > login credentials there, I read that I don't need to enter any of the > IODATA.* > > So, now when I tried it today, that session key didn't work. I received > the "Please login" error, HOWEVER... it published! It took a little longer, > but it published the page I wanted. I checked the session key via the > console today, and tried the current one. Of course - no error. > > So, my question is... how do I code the session key so it's dynamic? > > Thank you for all your help. > > > On Tuesday, July 17, 2012 4:00:59 PM UTC-7, Jian Huang wrote: >> >> Hi Bonnie, >> >> You are missing data with your IDATA tag. >> >> <IODATA loginguid="[!guid_login]" session="[!key!]"> >> . >> . >> . >> </IODATA> >> >> Also, you don't need [! ] surrounding your user supplied guid. >> >> Lastly, ensure the user account you are using is assigned to the project, >> and use it to login into the project and then log out. >> >> I would suggest first testing out the RQL using RQLConsole within the >> project first (don't need IODATA tag as it is autoamtically supplied by the >> plugin). >> >> -Jian >> >> On Tuesday, July 17, 2012 6:50:37 PM UTC-4, Bonnie Cohen wrote: >>> >>> Thank you for your assistance. I downloaded the RQL manual and referred >>> to that page. Using bogus numbers, this is what I've tried: >>> >>> <PROJECT guid="[!29XXXXXXF403984E7XXXX861B4B!]" >>> sessionkey="[!29XXXXXXF403984E7XXXX861B4B!]"> >>> >>> <PROJECT guid="29XXXXXXF403984E7XXXX861B4B" >>> sessionkey="29XXXXXXF403984E7XXXX861B4B"> >>> >>> <PROJECT guid="[!29XXXXXXF403984E7XXXX861B4B]" >>> sessionkey="[!29XXXXXXF403984E7XXXX861B4B]"> >>> No matter what, I always get a login error... and I've checked the user >>> credentials numerous times. It checks "OK!" >>> >>> Do you know if there's something that needs to be changed on the server >>> to allow user-defined jobs to run? >>> >>> >>> On Tuesday, July 17, 2012 12:43:29 PM UTC-7, Jian Huang wrote: >>>> >>>> Hi Bonnie, >>>> >>>> The variable such as PROJECT_GUID, SESSION_KEY, etc are in the wrong >>>> format. >>>> >>>> They should be [!guid_project], [!key] >>>> >>>> For more information, you can check out this page within the RQL manual >>>> >>>> RQL/ENG/684.htm >>>> >>>> Best, >>>> >>>> -Jian >>>> >>>> On Tuesday, July 17, 2012 2:34:03 PM UTC-4, Bonnie Cohen wrote: >>>>> >>>>> <IODATA> >>>>> >>>>> <PROJECT guid="PROJECT_GUID" sessionkey="SESSION_KEY"> >>>>> >>>>> <PAGE guid="PAGE_GUID"> >>>>> >>>>> <EXPORTJOB action="save" email=" " toppriority="0" >>>>> generatenextpages="1" generaterelativepages="0" >>>>> reddotserver="#SESSION_KEY" >>>>> application="" generatedate="" startgenerationat=""> >>>>> >>>>> <LANGUAGEVARIANTS action="checkassigning"> >>>>> >>>>> <LANGUAGEVARIANT guid="LANG_VAR_GUID" checked="1" /> >>>>> >>>>> </LANGUAGEVARIANTS> >>>>> >>>>> <PROJECTVARIANTS action="checkassigning"> >>>>> >>>>> <PROJECTVARIANT guid="PROJECT_VAR_GUID" checked="1" /> >>>>> >>>>> </PROJECTVARIANTS> >>>>> >>>>> </EXPORTJOB> >>>>> >>>>> </PAGE> >>>>> >>>>> </PROJECT> >>>>> >>>>> </IODATA> >>>>> >>>>> I got the GUIDs and Session Key from the Common\RDCMS.log file after I >>>>> published out the page I want. >>>>> >>>>> On Tuesday, July 17, 2012 11:01:13 AM UTC-7, Jian Huang wrote: >>>>>> >>>>>> Hi Bonnie, >>>>>> >>>>>> Can you paste in the RQL you are using? I can double check the >>>>>> syntax for you. >>>>>> >>>>>> Best, >>>>>> >>>>>> -Jian >>>>>> >>>>>> On Tuesday, July 17, 2012 1:19:31 PM UTC-4, Bonnie Cohen wrote: >>>>>>> >>>>>>> I thought that might have been the case, so I tried using an Admin >>>>>>> login to set up the User-Defined Job. (It checked "OK!") I still >>>>>>> received >>>>>>> the "Please login" error. >>>>>>> >>>>>>> Is there anything else that can cause this? RedDot... I mean Open >>>>>>> Text, is not responding to my support emails. >>>>>>> >>>>>>> Thank you. >>>>>>> >>>>>>> >>>>>>> On Monday, July 16, 2012 5:58:48 PM UTC-7, Jian Huang wrote: >>>>>>>> >>>>>>>> Yes, if your login is set to have more than 1 session. If default, >>>>>>>> no >>>>>>>> >>>>>>>> Sent from my iPhone >>>>>>>> >>>>>>>> On Jul 16, 2012, at 6:44 PM, Bonnie Cohen wrote: >>>>>>>> >>>>>>>> OK... got an update. I had to clear out our log files via the >>>>>>>> Server Manager. It frozen my browser trying to get to the 1 file I >>>>>>>> needed. >>>>>>>> So, I was able to see the RQL for the force publish I did on the page >>>>>>>> I >>>>>>>> want. I got all the session keys, and the project GUID, which was >>>>>>>> different >>>>>>>> that the one I obtained via the project SmartTree. >>>>>>>> >>>>>>>> Anyway, I'm still getting a login error. If I'm using my log in to >>>>>>>> create this job, can I actually be logged in when it needs to run? Or, >>>>>>>> do I >>>>>>>> need to be logged out for this to run successfully? >>>>>>>> >>>>>>>> Thank you. >>>>>>>> >>>>>>>> On Monday, July 16, 2012 12:40:53 PM UTC-7, Bonnie Cohen wrote: >>>>>>>>> >>>>>>>>> Troy, thank you for your help. I was actually able to find some >>>>>>>>> code like what you shared, but I'm getting an error. Here's what I've >>>>>>>>> done: >>>>>>>>> >>>>>>>>> * In the Server Manager, I created a User-Defined Job that's Event >>>>>>>>> Controlled. >>>>>>>>> * I selected RQL command and entered the code below, entering all >>>>>>>>> my GUIDs. (My user name & password checked "OK!") >>>>>>>>> * To get the Session Key for the Project node, I created a Info >>>>>>>>> element, type Session Key, in a template and previewed the page to >>>>>>>>> see the >>>>>>>>> Session Key. (Not sure if that's the correct way?) >>>>>>>>> * I then went back into my project and created a workflow, and >>>>>>>>> added my User-Defined Job as a reaction. >>>>>>>>> >>>>>>>>> I ran a test of all this and received an error = "Please login" >>>>>>>>> Is this because of an incorrect Session Key? Also, I'm not sure >>>>>>>>> what do to with "reddotserver="#SESSION_KEY"". Does the same Session >>>>>>>>> Key go >>>>>>>>> in there, as in the Project Node? >>>>>>>>> >>>>>>>>> Thank you again for your help. >>>>>>>>> >>>>>>>>> >>>>>>>>> On Friday, July 13, 2012 9:40:13 AM UTC-7, Troy Landers wrote: >>>>>>>>>> >>>>>>>>>> The RQL manual is a little hard to follow on this, so here's some >>>>>>>>>> example RQL for publishing a page. As has already been suggested, >>>>>>>>>> publishing a few pages and looking at the RQL in the logs will help >>>>>>>>>> you >>>>>>>>>> understand all that is going on when publishing though. >>>>>>>>>> >>>>>>>>>> <PROJECT sessionkey="SESSION_KEY" guid="PROJECT_GUID"> >>>>>>>>>> <PAGE guid="PAGE_GUID"> >>>>>>>>>> <EXPORTJOB action="save" email="PUBLISH_USER_GUID" >>>>>>>>>> toppriority="0" generatenextpages="0" generaterelativepages="0" >>>>>>>>>> reddotserver="#SESSION_KEY" application="" generatedate="" >>>>>>>>>> startgenerationat=""> >>>>>>>>>> <LANGUAGEVARIANTS action="checkassigning"> >>>>>>>>>> <LANGUAGEVARIANT guid="LANG_VAR_GUID_1" checked="0"/> >>>>>>>>>> <LANGUAGEVARIANT guid="LANG_VAR_GUID_2" checked="1"/> >>>>>>>>>> <LANGUAGEVARIANT guid="LANG_VAR_GUID_3" checked="0"/> >>>>>>>>>> </LANGUAGEVARIANTS> >>>>>>>>>> <PROJECTVARIANTS action="checkassigning"> >>>>>>>>>> <PROJECTVARIANT guid="PROJECT_VAR_GUID_1" checked="1"/> >>>>>>>>>> <PROJECTVARIANT guid="PROJECT_VAR_GUID_2" checked="0"/> >>>>>>>>>> <PROJECTVARIANT guid="PROJECT_VAR_GUID_3" checked="0"/> >>>>>>>>>> <PROJECTVARIANT guid="PROJECT_VAR_GUID_4" checked="1"/> >>>>>>>>>> </PROJECTVARIANTS> >>>>>>>>>> </EXPORTJOB> >>>>>>>>>> </PAGE> >>>>>>>>>> </PROJECT> >>>>>>>>>> >>>>>>>>>> Set generatenextpages to 1 to publish following pages. >>>>>>>>>> Set generaterelativepages to 1 to publish related pages. >>>>>>>>>> >>>>>>>>>> Hope this solves your problem! >>>>>>>>>> Troy >>>>>>>>>> >>>>>>>>>> On Thursday, July 12, 2012 12:51:19 PM UTC-5, Bonnie Cohen wrote: >>>>>>>>>>> >>>>>>>>>>> For the first time, I am resorting to trying RQL. I have a page, >>>>>>>>>>> which references a container on another page. I want the 1st page >>>>>>>>>>> to >>>>>>>>>>> automatically publish when a new item is added the container of the >>>>>>>>>>> 2nd >>>>>>>>>>> page. Checking publish Related Pages is not working. >>>>>>>>>>> >>>>>>>>>>> Does anyone have an example of RQL to publish a specific page? >>>>>>>>>>> >>>>>>>>>>> Thank you for your assistance. >>>>>>>>>>> >>>>>>>>>> -- >>>>>>>> You received this message because you are subscribed to the Google >>>>>>>> Groups "RedDot CMS Users" group. >>>>>>>> To view this discussion on the web visit >>>>>>>> https://groups.google.com/d/msg/reddot-cms-users/-/EQpXj3tZdzAJ. >>>>>>>> To post to this group, send email to >>>>>>>> [email protected]. >>>>>>>> To unsubscribe from this group, send email to >>>>>>>> [email protected]. >>>>>>>> For more options, visit this group at >>>>>>>> http://groups.google.com/group/reddot-cms-users?hl=en. >>>>>>>> >>>>>>>> -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To view this discussion on the web visit https://groups.google.com/d/msg/reddot-cms-users/-/mqm0_LPRIoIJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/reddot-cms-users?hl=en.
