Collaborator http://smartbear.com/forums Template for SQL code only reviews Wondering if anyone has a template created specific for reviews of SQL code only.&nbsp;<br /> Template would have Checklist items specific to SQL and fileds with values identifying SQL defects etc.... a reviewer can select &nbsp; http://smartbear.com/forums/f71/t99077/Template-for-SQL-code-only-reviews 1/28/2015 5:01:57 PM Tony Scrocca 17fb35dc-c7e3-4eb4-8424-bd9a58a837e8 Migrating from Windows to Linux server We are using CodeReviewer (but this question my be good for other products), and when I initially installed the server, I did so on my Windows development machine with the self-contained database option.<br /> <br /> Now, a few months and many reviews later, we know we want to keep the tool, but it living on my dev machine is not a permanent option, so we want to install it on a virtual server like all of our other tools.<br /> <br /> So, is there a way to export ALL of our review data and settins from the self-contained Windows install, and import them into a Linux install using MySQL?<br /> <br /> If not, can I move from self-contained Windows to self-contained Linux?&nbsp; I can find a way to create a database dump/backup, but I don&#39;t see how to restore that backup or import data.<br /> <br /> Also, if we want to move to CodeReviewer Pro or Collaborator, will we be able to do this type of migration again and keep all of our data?<br /> <br /> <br /> Thanks!<br /> http://smartbear.com/forums/f71/t99073/Migrating-from-Windows-to-Linux-server 1/28/2015 1:50:42 PM Jon Bartosch a435cb0b-6906-4e47-bb4c-a43458afec87 Additional columns on the main Collaborator web user homepage Hi,<br /> just wondered if it&#39;s possible to have additional columns to the main user web page for Collaborator.<br /> At the moment there are Review, Progress, Author, My Role, and Deadline.<br /> <br /> Some users are in a fair number of groups, for instance, and would like the ability to sort their main views accordingly.<br /> <br /> And if there is a way, will it have to be system wide, or can it be user specific?<br /> <br /> thanks<br /> francois<br /> http://smartbear.com/forums/f70/t99022/Additional-columns-on-the-main-Collaborator-web 1/27/2015 7:52:55 AM Francois Roux 4f983cf2-37c6-450f-9a69-e4f5c4c616cf Is there a way to stop a poke from causing everyone to re-approve? Thanks. http://smartbear.com/forums/f71/t98995/Is-there-a-way-to-stop-a-poke-from-causing-ever 1/26/2015 8:37:51 AM Jay Cohen ee9afe32-f480-4547-b9fd-83e2d86983ff Git Diff&#39;ing Topic Branch against Master and adding/removing files. <div> <div> 1---3---6---8 master</div> <div> &nbsp;\ &nbsp; &nbsp; &nbsp; \</div> <div> &nbsp; 2--4-5--7 topic</div> <div> &nbsp;</div> <div> I create the review with &quot;ccollab addgitdiffs new master...topic&quot; because I want to review the work in the &quot;topic&quot; branch.</div> <div> &nbsp;</div> <div> Now suppose I make some changes to topic based on the review and my repo now looks like this:</div> <div> &nbsp;</div> <div> 1---3---6---8 master</div> <div> &nbsp;\ &nbsp; &nbsp; &nbsp; \ &nbsp; \</div> <div> &nbsp; 2--4-5--7---9 topic</div> <div> &nbsp;</div> <div> Suppose in commit 5 I added two new files: fileA and fileB. &nbsp;Also suppose that in commit 9 I deleted fileB.</div> <div> &nbsp;</div> <div> I now want to get the changes in commit 9 into the review so I do &quot;ccollab addgitdiffs &lt;review_number&gt; master...topic&quot;.</div> <div> &nbsp;</div> <div> There are a few problems with the resulting review:</div> <ul> <li> When I examine fileA, it doesn&#39;t show that the file has all new lines, instead, showing the difference between the first upload and the second upload. &nbsp;Since the file hasn&#39;t changed since it was created, the view hides the majority of the file&#39;s contents. &nbsp;This makes it hard to review new files.</li> <li> fileB still shows up in the review even though it&#39;s been deleted.</li> </ul> <div> &nbsp;</div> <div> What is the best way to generate the diffs for code collaborator with the above workflow?</div> </div> <br /> http://smartbear.com/forums/f70/t98904/Git-Diff-39;ing-Topic-Branch-against-Master-an 1/21/2015 12:57:28 PM Mike M 179ee576-7cfd-4ce7-9d1a-7eedb786b463 RE: Client GUI - upload only files that have changed since last upload <p> Thanks for your reply and explanation. I&#39;m using TortoiseSVN.</p> <p> My question concerns what happens when you say &quot;<em>uploading all the changed files won&#39;t affect the review because we exclude them automatically for the user</em>&quot;.</p> <p> Are you saying these files do not get uploaded (and will not appear in the Web UI) at all? That would be ideal.</p> <p> In my case files that have not changed since the last upload are still uploaded and their upload number is updated. To me uploading all changes is inconvenient because users can&#39;t tell what files are modified or not between uploads, forcing them to look at files they shouldn&#39;t need to.&nbsp;</p> <p> Is this the expected interaction/behaviour? I was hoping this could be configured in some way to avoid this problem.</p> http://smartbear.com/forums/f70/t98668/RE-Client-GUI-upload-only-files-that-have-ch 1/16/2015 11:14:55 AM Michael M 80372f06-afeb-420f-8500-1ec996e8a88d RE: Client GUI - upload only files that have changed since last upload Hi,&nbsp;<br /> <br /> Thank you for your post. I am not sure what SCM you are using but I will explain how &quot;upload changes&quot; works in Collaborator. When you upload changes, Collaborator communicates with the SCM to get the last changes against last commit. We upload the list of changed files against last commit.&nbsp;<br /> <br /> If you do a second round of changes without a commit, then you try to upload changes, collaborator gui will still display list of all changes against the last commit (not against the previous changes).<br /> <br /> The only visual difference you will see after the upload. When you open the review in the Web UI, you will see in the &quot;Material Section&quot;\ &quot;Status&quot; column, the number of upload. (number rounded with an arrow) 0 for first upload, 1 for second upload and so on.&nbsp;<br /> <br /> So technically, uploading all the changed files won&#39;t affect the review because we exclude them automatically for the user. If you are looking for separating those last changed files in a separate changeset/changelist in the Web UI, that can be resolved on the SCM side.&nbsp;<br /> <br /> Please feel free to write back should you have any further questions or you can send us email to support@smartbear.com<br /> <br /> Best,<br /> <br /> http://smartbear.com/forums/f70/t98668/RE-Client-GUI-upload-only-files-that-have-ch 1/16/2015 10:58:10 AM Sherif Sallam aff6de37-b247-4b14-a006-650d2fe1935b SVN Certificate issues with a trusted certificate This was working on Monday and now i finally get someone to try it out and i am back to this. &nbsp;It works fine from the cmd line.<br /> <br /> <div> notroot@RMDevTools01:~$ svn log https://subversion.routematch.com:8443/svn/RouteMatch -r 75412</div> <div> Authentication realm: &lt;https://subversion.routematch.com:8443&gt; VisualSVN Server</div> <div> Password for &#39;SVNRead&#39;: ***************</div> <div> &nbsp;</div> <div> &nbsp;</div> <div> -----------------------------------------------------------------------</div> <div> ATTENTION! &nbsp;Your password for authentication realm:</div> <div> &nbsp;</div> <div> &nbsp; &nbsp;&lt;https://subversion.routematch.com:8443&gt; VisualSVN Server</div> <div> &nbsp;</div> <div> can only be stored to disk unencrypted! &nbsp;You are advised to configure</div> <div> your system so that Subversion can store passwords encrypted, if</div> <div> possible. &nbsp;See the documentation for details.</div> <div> &nbsp;</div> <div> You can avoid future appearances of this warning by setting the value</div> <div> of the &#39;store-plaintext-passwords&#39; option to either &#39;yes&#39; or &#39;no&#39; in</div> <div> &#39;/home/notroot/.subversion/servers&#39;.</div> <div> -----------------------------------------------------------------------</div> <div> Store password unencrypted (yes/no)? no</div> <div> svn: E175002: Unexpected HTTP status 500 &#39;Internal Server Error&#39; on &#39;/svn/RouteMatch/!svn/rvr/62094&#39;</div> <div> &nbsp;</div> <div> svn: E160006: Additional errors:</div> <div> svn: E160006: No such revision 75412</div> <div> &nbsp;</div> Yet when configuring the SCM in the admini console i get this. &nbsp;I don&#39;t know how to troubleshoot. &nbsp;If it is configuration on the SVN server side, i need to know how to prove that. &nbsp;The Certificate is signed and installed.&nbsp;<br /> <br /> <h2 style="margin: 2ex 0px 0.5ex; padding: 0px; font-size: 14px; font-family: Arial, Helvetica, sans-serif; color: rgb(0, 0, 0);"> Error: Invalid input: Version control server configuration error: Could not create valid Subversion configuration based on configured repository url: svn: E230001: Unable to connect to a repository at URL &#39;<a href="https://subversion.routematch.com:8443/svn/RouteMatch" style="color: rgb(17, 17, 102);" target="_blank">https://subversion.routematch.com:8443/svn/RouteMatch</a>&#39;<br /> svn: E230001: Server SSL certificate verification failed: issuer is not trusted</h2> <br /> If i change the name of the server to the local name which doesn&#39;t match the certificate i get this error.<br /> <h2 style="margin: 2ex 0px 0.5ex; padding: 0px; font-size: 14px; font-family: Arial, Helvetica, sans-serif; color: rgb(0, 0, 0);"> Error: Invalid input: Version control server configuration error: Could not create valid Subversion configuration based on configured repository url: svn: E230001: Unable to connect to a repository at URL &#39;<a href="https://rmfile02.routematch.local:8443/svn/RouteMatch" style="color: rgb(17, 17, 102);" target="_blank">https://rmfile02.routematch.local:8443/svn/RouteMatch</a>&#39;<br /> svn: E230001: Server SSL certificate verification failed: certificate issued for a different hostname, issuer is not trusted</h2> http://smartbear.com/forums/f71/t98714/SVN-Certificate-issues-with-a-trusted-certifica 1/15/2015 12:40:12 PM dan holmes ca40fec1-1bac-4815-aa83-6f1861f93692 Client GUI - upload only files that have changed since last upload In the CodeCollab Client GUI, whenever I add changes to an Existing review, by default all modified changes are selected for upload. In many cases only some files have been changed since the review was originally created. Is there a way for the client to automatically recognize which files have actually changed since the last upload?<br /> <br /> Otherwise it can be very inconvenient to have to manually examine each file and remember which ones should actually be uploaded. I could, of course, always upload all files - but that is even more inconvenient because reviewers always need to roll up all changes, and they can&#39;t easily tell what&#39;s actually been changed between uploads.<br /> <br /> Thanks in advance! http://smartbear.com/forums/f70/t98668/Client-GUI-upload-only-files-that-have-change 1/14/2015 12:43:52 PM Michael M 9e718548-a5b6-48c6-8a6b-a90bd88b9623 RE: Upload by addp4diff removes reviewers &quot;Accepts&quot; Hi,&nbsp;<br /> <br /> Thank you for your forum post. I could reproduce the problem. I open a ticket for the development team to address this issue. Here&#39;s the bug ticket number collab-226.&nbsp;<br /> <br /> Thanks again. http://smartbear.com/forums/f70/t98379/RE-Upload-by-addp4diff-removes-reviewers-quot 1/12/2015 1:34:44 PM Sherif Sallam 772b36d9-f7cf-42a6-97ed-c9e1f36e5677 Code Collaborator 8.x Linux &quot;Hands Free&quot; installer My team is working on making a virtual environment for the company to do Linux development in. The idea is to automate most of this process so it&#39;s highly repeatable and quick to create new versions. One of the installaters that we don&#39;t have an automated install for yet is Code Collaborator. Is there a hands free installation method using the installer scripts? If not, is there a well defined list of changes the script makes? If I know exactly what files are added I can just grab them and create a package and make the necessary changes. http://smartbear.com/forums/f71/t98516/Code-Collaborator-8-x-Linux-quot;Hands-Free-qu 1/8/2015 9:47:49 AM Robby Pocase 6721fc12-b325-426f-b745-1d4c5bf7f89a How can admin enable &quot;Create New User&quot; to manually create user accounts when configured with LDAP? When Collabroator is configured with LDAP authentication, by default, the &quot;Create New User&quot; functions is disabled. So when a user logs in for the first time, a user account is created for them automatically in Collaborator to store their user preferences.<br /> <br /> But sometimes, the admin wants to control this process and manually create each user account instead. To enable the &quot;Create New User&quot; function.<br /> 1. Stop the Collaborator service (the service name is ccollab-server)<br /> 2. Edit &lt;collaborator-install-directory&gt;\tomcat\conf\catalina\localhost\ROOT.xml<br /> Note: I recommend you store a backup of the file before any changes.&nbsp;<br /> 3. Find the following line:<br /> <br /> <div> <pre class="ckeditor_codeblock" style="margin-top: 10px; margin-bottom: 10px; margin-left: 20px; padding: 8px; word-wrap: normal; border: 1px solid rgb(204, 204, 204); overflow-x: auto; color: rgb(0, 0, 0); background: rgb(239, 239, 239);"> &lt;Parameter description=&quot;Is the Code Collaborator database used for authentication?&quot; name=&quot;collaborator-authentication&quot; override=&quot;false&quot; value=&quot;false&quot;/&gt;</pre> </div> <br /> 4. Change value from false to true.&nbsp;<br /> 5. Save the file.&nbsp;<br /> 6. Start Collaborator service.<br /> <br /> Note:&nbsp;<br /> 1. Make sure that the folder locahost has just one ROOT.xml and any other backup files end by .bak extension.&nbsp;<br /> 2. Collaborator will not automatically create accounts when users login so the admin must create user accounts manually.&nbsp;<br /> 3- You can create users using Collaborator command line utility and run a batch file to create all the users at once, refer to our user manual to find more about the command line commands.&nbsp;<br /> 4- You will need to set the setting admin\General Setting\ &quot;Global Create User - to hide. this will hide the &quot;Create User&quot; button from the main login screen for all users.&nbsp;<br /> <br /> <br /> Thanks,&nbsp; http://smartbear.com/forums/f71/t98515/How-can-admin-enable-quot;Create-New-User-quot 1/8/2015 9:33:46 AM Sherif Sallam 992476db-cbb1-4424-8a9f-1e1841b3cfb4 How can admin enable &quot;Create New User&quot; to manually create user accounts when configured with LDAP? When Collabroator is configured with LDAP authentication, by default, the &quot;Create New User&quot; functions is disabled. So when a user logs in for the first time, a user account is created for them automatically in Collaborator to store their user preferences.<br /> <br /> But sometimes, the admin wants to control this process and manually create each user account instead. To enable the &quot;Create New User&quot; function.<br /> 1. Stop the Collaborator service (the service name is ccollab-server)<br /> 2. Edit &lt;collaborator-install-directory&gt;\tomcat\conf\catalina\localhost\ROOT.xml<br /> Note: I recommend you store a backup of the file before any changes.&nbsp;<br /> 3. Find the following line:<br /> <br /> <div> <pre class="ckeditor_codeblock" style="margin-top: 10px; margin-bottom: 10px; margin-left: 20px; padding: 8px; word-wrap: normal; border: 1px solid rgb(204, 204, 204); overflow-x: auto; color: rgb(0, 0, 0); background: rgb(239, 239, 239);"> &lt;Parameter description=&quot;Is the Code Collaborator database used for authentication?&quot; name=&quot;collaborator-authentication&quot; override=&quot;false&quot; value=&quot;false&quot;/&gt;</pre> </div> <br /> 4. Change value from false to true.&nbsp;<br /> 5. Save the file.&nbsp;<br /> 6. Start Collaborator service.<br /> <br /> Note:&nbsp;<br /> 1. Make sure that the folder locahost has just one ROOT.xml and any other backup files end by .bak extension.&nbsp;<br /> 2. Collaborator will not automatically create accounts when users login so the admin must create user accounts manually.&nbsp;<br /> 3- You can create users using Collaborator command line utility and run a batch file to create all the users at once, refer to our user manual to find more about the command line commands.&nbsp;<br /> 4- You will need to set the setting admin\General Setting\ &quot;Global Create User - to hide. this will hide the &quot;Create User&quot; button from the main login screen for all users.&nbsp;<br /> <br /> <br /> Thanks,&nbsp; http://smartbear.com/forums/f71/t98514/How-can-admin-enable-quot;Create-New-User-quot 1/8/2015 9:33:43 AM Sherif Sallam f95894ba-b498-45bf-8b4c-4e9f80a823c0 RE: Startup error with ccollab 7.3.x Hi,&nbsp;<br /> <br /> Collaborator doesn&#39;t support JDK version. Please try to install Oracle Java JRE version.&nbsp;<br /> <br /> Thanks,<br /> <br /> http://smartbear.com/forums/f70/t97825/RE-Startup-error-with-ccollab-7-3-x 1/8/2015 8:57:01 AM Sherif Sallam c561c928-69d9-43d2-95c4-3083a89ff202 RE: Google Chrome&#39;s connection attempt to 10.7.1.57 was rejected. The website may be down, or your network may not be properly configured. I am glad you got Collaborator up and running. Yes the service name is ccollab-server located under Collaborator directory. If you need any assistance or have any question, don&#39;t hesitate to send it to us. Good luck :)<br /> <br /> Sherif,&nbsp; http://smartbear.com/forums/f71/t98480/RE-Google-Chrome-39;s-connection-attempt-to-1 1/8/2015 8:16:34 AM Sherif Sallam f3cc5497-6df0-4994-ae23-eca656f9d843