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

[Steve Swinsburg]

Periods/fullstops work ok, as do commas, some other characters don't work though ($), even though they are valid according to the sites tool, eg a siteId with a $ in it gives this:

INFO Could not process entity: /site/$123/pages.json (400)[null]: Could not parse entity path (/site/$123/pages.json): input must consist of the following chars only (not counting []): [A-Za-z0-9\\(\\)\+\*\.\-_=,:;!~@% /]

I've filed a JIRA at: http://jira.sakaiproject.org/browse/SAK-18893

cheers,
Steve


On 03/08/2010, at 6:38 AM, Mark Norton wrote:

>  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/
> =======
> _______________________________________________
> 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"