[Building Sakai] EntityBroker. Spaces in custom action entity ids

[Mark Norton]

  On a related note, does that mean that periods cannot be used in user 
account names?

- Mark Norton

On 8/2/2010 4:29 PM, Sam Ottenhoff wrote:
>    Yes, it worked.  We did it because we found site_ids containing
> periods.   The period is used as a prefix separator and is inappropriate
> as a separator.  Full process:
>
> 1) mysqldump database_name>  database.sql
> 2) load up all site ids into excel column A  (SELECT SITE_ID FROM
> SAKAI_SITE WHERE SITE_ID LIKE '% %')
> 3) copy all site ids into column B, search and replace the bad character
> with replacement "-"
> 4) column C: write a concatenate function to produce a regular
> expression for each site id
>
>       perl -pi -e 's/24705.201002/24705-201002/g' database.sql
>
> 5) copy and paste all commands from column C into site-id-corrector.sh
> 6) run site-id-corrector.sh
> 7) mysql database_name<  database.sql
>
> --Sam
>
> On 8/2/2010 4:19 PM, Adrian Fish wrote:
>> Nice idea. I like it. Did it work?
>>
>> Sam Ottenhoff wrote:
>>>> Does anybody have experience of changing site ids programmatically,
>>>> without breaking everything?
>>> Yes, I've done this by doing a database dump, running perl regular
>>> expressions over the database dump, and re-importing the database.
>>>
>>> --Sam
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>
>>> TO UNSUBSCRIBE: send email to
>>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>>> "unsubscribe"
>>>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>
>
>
>
> =======
> Email scanned by PC Tools - No viruses or spyware found.
> (Email Guard: 7.0.0.18, Virus/Spyware Database: 6.15560)
> http://www.pctools.com/
> =======
>





=======
Email scanned by PC Tools - No viruses or spyware found.
(Email Guard: 7.0.0.18, Virus/Spyware Database: 6.15560)
http://www.pctools.com/
=======