Illegal Characters in an ofbiz URL

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

Illegal Characters in an ofbiz URL

SkipDever
I am importing an existing database with partyIds like P&G#1 and BEN+JERRIES

I assumed that the standard URL symbols would be illegal, so I converted '&'
to a '+' and most other punction to '_'.  However, the '+' sign gets passed
to the bash script as a space.  In other words, "P+G" gets passed as "P G"
which causes obvious problems.

Is there a list somewhere of what characters are legal (or illegal) so I
don't have to make guesses about it?

Thanks in advance if this is a stupid newbee question.

Skip
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
2:12 PM

Reply | Threaded
Open this post in threaded view
|

RE: Illegal Characters in an ofbiz URL

SkipDever
From the RFC:

"The characters ";", "/", "?", ":", "@", "=" and "&" are the characters
which may be reserved for special meaning within a scheme."

and

"Thus, only alphanumerics, the special characters "$-_.+!*'(),", and
reserved characters used for their reserved purposes may be used unencoded
within a URL."

However, Ofbiz is converting the '+' sign to a space.  Can someone tell me
where this conversion is happening so I can look for other possible
exceptions?  This is important to me because I am importing hundreds of
thousands of entries and I need to handle these characters during import.

Skip

-----Original Message-----
From: skip@thedevers [mailto:[hidden email]]
Sent: Thursday, May 08, 2008 10:14 AM
To: OfbizUser
Subject: Illegal Characters in an ofbiz URL


I am importing an existing database with partyIds like P&G#1 and BEN+JERRIES

I assumed that the standard URL symbols would be illegal, so I converted '&'
to a '+' and most other punction to '_'.  However, the '+' sign gets passed
to the bash script as a space.  In other words, "P+G" gets passed as "P G"
which causes obvious problems.

Is there a list somewhere of what characters are legal (or illegal) so I
don't have to make guesses about it?

Thanks in advance if this is a stupid newbee question.

Skip
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
2:12 PM


No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
2:12 PM

No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
2:12 PM

Reply | Threaded
Open this post in threaded view
|

Re: Illegal Characters in an ofbiz URL

Scott Gray
url encoding converts spaces to pluses, try doing a google search for "plus
sign" then look at the query in the url.  Tomcat decodes the url parameters
not OFBiz but this might help:
http://java.sun.com/j2se/1.5.0/docs/api/java/net/URLDecoder.html

Regards
Scott

2008/5/9 skip@thedevers <[hidden email]>:

> From the RFC:
>
> "The characters ";", "/", "?", ":", "@", "=" and "&" are the characters
> which may be reserved for special meaning within a scheme."
>
> and
>
> "Thus, only alphanumerics, the special characters "$-_.+!*'(),", and
> reserved characters used for their reserved purposes may be used unencoded
> within a URL."
>
> However, Ofbiz is converting the '+' sign to a space.  Can someone tell me
> where this conversion is happening so I can look for other possible
> exceptions?  This is important to me because I am importing hundreds of
> thousands of entries and I need to handle these characters during import.
>
> Skip
>
> -----Original Message-----
> From: skip@thedevers [mailto:[hidden email]]
> Sent: Thursday, May 08, 2008 10:14 AM
> To: OfbizUser
> Subject: Illegal Characters in an ofbiz URL
>
>
> I am importing an existing database with partyIds like P&G#1 and
> BEN+JERRIES
>
> I assumed that the standard URL symbols would be illegal, so I converted
> '&'
> to a '+' and most other punction to '_'.  However, the '+' sign gets passed
> to the bash script as a space.  In other words, "P+G" gets passed as "P G"
> which causes obvious problems.
>
> Is there a list somewhere of what characters are legal (or illegal) so I
> don't have to make guesses about it?
>
> Thanks in advance if this is a stupid newbee question.
>
> Skip
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
> 2:12 PM
>
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
> 2:12 PM
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
> 2:12 PM
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Illegal Characters in an ofbiz URL

Jacques Le Roux
Administrator
From: "Scott Gray" <[hidden email]>
> url encoding converts spaces to pluses,

Actually, reading the link Scoot provided, I suppose Scoot meaned <<The plus sign "+" is converted into a space character " " .>>

Jacques

>try doing a google search for "plus
> sign" then look at the query in the url.  Tomcat decodes the url parameters
> not OFBiz but this might help:
> http://java.sun.com/j2se/1.5.0/docs/api/java/net/URLDecoder.html
>
> Regards
> Scott
>
> 2008/5/9 skip@thedevers <[hidden email]>:
>
>> From the RFC:
>>
>> "The characters ";", "/", "?", ":", "@", "=" and "&" are the characters
>> which may be reserved for special meaning within a scheme."
>>
>> and
>>
>> "Thus, only alphanumerics, the special characters "$-_.+!*'(),", and
>> reserved characters used for their reserved purposes may be used unencoded
>> within a URL."
>>
>> However, Ofbiz is converting the '+' sign to a space.  Can someone tell me
>> where this conversion is happening so I can look for other possible
>> exceptions?  This is important to me because I am importing hundreds of
>> thousands of entries and I need to handle these characters during import.
>>
>> Skip
>>
>> -----Original Message-----
>> From: skip@thedevers [mailto:[hidden email]]
>> Sent: Thursday, May 08, 2008 10:14 AM
>> To: OfbizUser
>> Subject: Illegal Characters in an ofbiz URL
>>
>>
>> I am importing an existing database with partyIds like P&G#1 and
>> BEN+JERRIES
>>
>> I assumed that the standard URL symbols would be illegal, so I converted
>> '&'
>> to a '+' and most other punction to '_'.  However, the '+' sign gets passed
>> to the bash script as a space.  In other words, "P+G" gets passed as "P G"
>> which causes obvious problems.
>>
>> Is there a list somewhere of what characters are legal (or illegal) so I
>> don't have to make guesses about it?
>>
>> Thanks in advance if this is a stupid newbee question.
>>
>> Skip
>> No virus found in this outgoing message.
>> Checked by AVG.
>> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
>> 2:12 PM
>>
>>
>> No virus found in this incoming message.
>> Checked by AVG.
>> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
>> 2:12 PM
>>
>> No virus found in this outgoing message.
>> Checked by AVG.
>> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
>> 2:12 PM
>>
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: Illegal Characters in an ofbiz URL

BJ Freeman
In reply to this post by SkipDever
Have you thought about escaping the characters.
http://www.theukwebdesigncompany.com/articles/entity-escape-characters.php

skip@thedevers sent the following on 5/8/2008 1:37 PM:

>>From the RFC:
>
> "The characters ";", "/", "?", ":", "@", "=" and "&" are the characters
> which may be reserved for special meaning within a scheme."
>
> and
>
> "Thus, only alphanumerics, the special characters "$-_.+!*'(),", and
> reserved characters used for their reserved purposes may be used unencoded
> within a URL."
>
> However, Ofbiz is converting the '+' sign to a space.  Can someone tell me
> where this conversion is happening so I can look for other possible
> exceptions?  This is important to me because I am importing hundreds of
> thousands of entries and I need to handle these characters during import.
>
> Skip
>
> -----Original Message-----
> From: skip@thedevers [mailto:[hidden email]]
> Sent: Thursday, May 08, 2008 10:14 AM
> To: OfbizUser
> Subject: Illegal Characters in an ofbiz URL
>
>
> I am importing an existing database with partyIds like P&G#1 and BEN+JERRIES
>
> I assumed that the standard URL symbols would be illegal, so I converted '&'
> to a '+' and most other punction to '_'.  However, the '+' sign gets passed
> to the bash script as a space.  In other words, "P+G" gets passed as "P G"
> which causes obvious problems.
>
> Is there a list somewhere of what characters are legal (or illegal) so I
> don't have to make guesses about it?
>
> Thanks in advance if this is a stupid newbee question.
>
> Skip
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
> 2:12 PM
>
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
> 2:12 PM
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
> 2:12 PM
>
>
>
>

Reply | Threaded
Open this post in threaded view
|

Re: Illegal Characters in an ofbiz URL

BJ Freeman
however Db have there own particularities handling special characters.
and the + along with 's.
I have this when doing direct imports to some DB's
so i think that there a few levels to consider.

BJ Freeman sent the following on 5/9/2008 7:09 AM:

> Have you thought about escaping the characters.
> http://www.theukwebdesigncompany.com/articles/entity-escape-characters.php
>
> skip@thedevers sent the following on 5/8/2008 1:37 PM:
>> >From the RFC:
>>
>> "The characters ";", "/", "?", ":", "@", "=" and "&" are the characters
>> which may be reserved for special meaning within a scheme."
>>
>> and
>>
>> "Thus, only alphanumerics, the special characters "$-_.+!*'(),", and
>> reserved characters used for their reserved purposes may be used unencoded
>> within a URL."
>>
>> However, Ofbiz is converting the '+' sign to a space.  Can someone tell me
>> where this conversion is happening so I can look for other possible
>> exceptions?  This is important to me because I am importing hundreds of
>> thousands of entries and I need to handle these characters during import.
>>
>> Skip
>>
>> -----Original Message-----
>> From: skip@thedevers [mailto:[hidden email]]
>> Sent: Thursday, May 08, 2008 10:14 AM
>> To: OfbizUser
>> Subject: Illegal Characters in an ofbiz URL
>>
>>
>> I am importing an existing database with partyIds like P&G#1 and BEN+JERRIES
>>
>> I assumed that the standard URL symbols would be illegal, so I converted '&'
>> to a '+' and most other punction to '_'.  However, the '+' sign gets passed
>> to the bash script as a space.  In other words, "P+G" gets passed as "P G"
>> which causes obvious problems.
>>
>> Is there a list somewhere of what characters are legal (or illegal) so I
>> don't have to make guesses about it?
>>
>> Thanks in advance if this is a stupid newbee question.
>>
>> Skip
>> No virus found in this outgoing message.
>> Checked by AVG.
>> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
>> 2:12 PM
>>
>>
>> No virus found in this incoming message.
>> Checked by AVG.
>> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
>> 2:12 PM
>>
>> No virus found in this outgoing message.
>> Checked by AVG.
>> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
>> 2:12 PM
>>
>>
>>
>>
>
>
>
>

Reply | Threaded
Open this post in threaded view
|

RE: Illegal Characters in an ofbiz URL

SkipDever
In reply to this post by Scott Gray
Thanks Scott

I was worried that I missed some other ones.  I'll have a look at the linked
doc.

Skip

-----Original Message-----
From: Scott Gray [mailto:[hidden email]]
Sent: Thursday, May 08, 2008 11:44 PM
To: [hidden email]
Subject: Re: Illegal Characters in an ofbiz URL


url encoding converts spaces to pluses, try doing a google search for "plus
sign" then look at the query in the url.  Tomcat decodes the url parameters
not OFBiz but this might help:
http://java.sun.com/j2se/1.5.0/docs/api/java/net/URLDecoder.html

Regards
Scott

2008/5/9 skip@thedevers <[hidden email]>:

> From the RFC:
>
> "The characters ";", "/", "?", ":", "@", "=" and "&" are the characters
> which may be reserved for special meaning within a scheme."
>
> and
>
> "Thus, only alphanumerics, the special characters "$-_.+!*'(),", and
> reserved characters used for their reserved purposes may be used unencoded
> within a URL."
>
> However, Ofbiz is converting the '+' sign to a space.  Can someone tell me
> where this conversion is happening so I can look for other possible
> exceptions?  This is important to me because I am importing hundreds of
> thousands of entries and I need to handle these characters during import.
>
> Skip
>
> -----Original Message-----
> From: skip@thedevers [mailto:[hidden email]]
> Sent: Thursday, May 08, 2008 10:14 AM
> To: OfbizUser
> Subject: Illegal Characters in an ofbiz URL
>
>
> I am importing an existing database with partyIds like P&G#1 and
> BEN+JERRIES
>
> I assumed that the standard URL symbols would be illegal, so I converted
> '&'
> to a '+' and most other punction to '_'.  However, the '+' sign gets
passed

> to the bash script as a space.  In other words, "P+G" gets passed as "P G"
> which causes obvious problems.
>
> Is there a list somewhere of what characters are legal (or illegal) so I
> don't have to make guesses about it?
>
> Thanks in advance if this is a stupid newbee question.
>
> Skip
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
> 2:12 PM
>
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
> 2:12 PM
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008
> 2:12 PM
>
>

No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.10/1421 - Release Date: 5/7/2008
5:23 PM

No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.10/1421 - Release Date: 5/7/2008
5:23 PM