[Portfolio] Changing OSP form name via database

[Christian Aziz]

Thanks for the pointer, Chris!

It turns out the validation error was thrown because the owner of the form
was removed. I simply added my USER_ID to those forms' records in this
table and was able to update via the front end with no problems.




Christian V. Aziz
Project Manager - OIRT
Coadjutant Faculty - SC&I
Rutgers, The State University of New Jersey

101I Administrative Services Building Annex 1
56 Bevier Road, Piscataway, NJ 08854
Tel: 848-445-8732 | Fax: 732-445-5539


On Fri, Jun 13, 2014 at 8:46 AM, Maurer, Christopher Wayne <chmaurer at iu.edu>
wrote:

>  Try the metaobj_form_def table.  That’s where the form definitions are
> stored.
>
>  Chris
>
>   From: Christian Aziz <caziz at rutgers.edu>
> Date: Thursday, June 12, 2014 at 5:05 PM
> To: "portfolio at collab.sakaiproject.org" <portfolio at collab.sakaiproject.org
> >
> Subject: [Portfolio] Changing OSP form name via database
>
>   Hello portfolio folks,
>
>  I'm trying to change the name of an osp form (using the Forms tool) that
> is currently in use. After modifying the name in the text field and
> clicking 'Save changes', an error appears. The message reads "Validation
> errors exists. Read below for more detail." There is no detail below.
> Even without changing anything, an attempt to resave causes this error.
>
>
>
>  ​
>
>
>  I know there are no validation errors because the schema is the same one
> that has been in use for a couple years. The person who created these forms
> is no longer working here and must have removed the account under which the
> form was created. Under the Owner column, there is "(User not found)" where
> a name would normally appear. I wonder if that might be the reason for a
> validation error.
>
>  The bottom line is I would like to be able to change the name of the
> form and was wondering if there was a way through the database. I scoured
> the osp_ tables but can't find one that clearly lists a form id along with
> its name. Thanks for any insights.
>
>  Thanks,
> Chris
>
>
>
>  Christian V. Aziz
>  Project Manager - OIRT
> Coadjutant Faculty - SC&I
>  Rutgers, The State University of New Jersey
>
> 101I Administrative Services Building Annex 1
> 56 Bevier Road, Piscataway, NJ 08854
> Tel: 848-445-8732 | Fax: 732-445-5539
>   ᐧ
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/portfolio/attachments/20140613/d278a396/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2014-06-12 at 4.50.37 PM.png
Type: image/png
Size: 23459 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/portfolio/attachments/20140613/d278a396/attachment-0001.png