Hi, Similar to what Bonnie has done, I've implemented a user defined job to start a publish. I then call this job from within a workflow by using the "Start Job" reaction. However, the "Start Job" reaction seems to insist upon sending an email whenever it runs the job and won't let me save the reaction until I have specified an email recipient. Is there a way to avoid it sending an email? It seems odd that it's mandatory after all if I wanted to send an email I would have specified it in the job itself or as another workflow reaction....
Note: the reason I start the publish using a "start job" reaction is because we want to initiate 2 separate publishes at this point in the workflow and workflow will only allow a single "Start Publication" reaction at each level. thanks, Jonathan On Wednesday, July 18, 2012 2:23:59 PM UTC-7, Bonnie Cohen wrote: > > *Holy Moly! You are a life saver! It worked!!!!!!* I have been in contact > with someone at OpenText Support and he has not been able to help me. He > started resorting to asking me to try things I had already told him I > tried... like "CHECK the supplied user name credentials". > > Anyway, thank you very much again! You are awesome!!! > > Best Regards, > Bonnie > > On Wednesday, July 18, 2012 1:48:41 PM UTC-7, Jian Huang wrote: >> >> Hi Bonnie, >> >> In the user-defined job try to include this before your RQL >> >> <IODATA loginguid="[!guid_login!]"><ADMINISTRATION action="validate" >> guid="[!guid_login!]"> <PROJECT guid="###project guid###" /> >> </ADMINISTRATION> </IODATA> >> >> replace ###project guid### with actual project guid. >> >> On Wednesday, July 18, 2012 2:39:16 PM UTC-4, Bonnie Cohen wrote: >>> >>> 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] <javascript:>. >>>>>>>>>>>> To unsubscribe from this group, send email to >>>>>>>>>>>> [email protected] <javascript:>. >>>>>>>>>>>> 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/-/5D_z5QLrI6AJ. 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.
