This is the exact code I have in my user-defined job, with *successfully authenticated username and password*:
<IODATA loginguid="[!guid_login]" session="[!key!]"> <PROJECT guid="29BAB7B9616F403984E75B8986751B4B" sessionkey=""> <PAGE guid="952FCC4EB60747E898825B6DB8848370"> <EXPORTJOB action="save" email="" toppriority="0" generatenextpages="1" generaterelativepages="0" reddotserver="" application="" generatedate="" startgenerationat=""> <LANGUAGEVARIANTS action="checkassigning"> <LANGUAGEVARIANT guid="B4F85DFF85A849778D39A452F783FA35" checked="1"/> </LANGUAGEVARIANTS> <PROJECTVARIANTS action="checkassigning"> <PROJECTVARIANT guid="3527E359BBB44C69B959368DDE7F36F5" checked="1"/> <PROJECTVARIANT guid="AFF9FD1C578D45D7AD83C868CA2CD710" checked="0"/> </PROJECTVARIANTS> </EXPORTJOB> </PAGE> </PROJECT> </IODATA> I re-tried it with entering sessionkey="[!key!]" in the PROJECT node. Both times I get a login error. I tried the above code in the RQLConsole and unchecked "Automatically pad RQL with <IODATA>". I get the login error. In the console, I remove the IODATA node and in the PROJECT node have sessionkey="" (empty quotes) -- this successfully runs and publishes my page. On Wednesday, July 18, 2012 11:18:25 AM UTC-7, Jian Huang wrote: > > 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/-/hRZnD2eLSScJ. 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.
