RE: Illegal Characters in an ofbiz URL
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:[EMAIL PROTECTED] Sent: Thursday, May 08, 2008 11:44 PM To: user@ofbiz.apache.org 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 [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > 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
Re: Illegal Characters in an ofbiz URL
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 > > [EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> 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 >> >> >> >> > > > >
Re: Illegal Characters in an ofbiz URL
Have you thought about escaping the characters. http://www.theukwebdesigncompany.com/articles/entity-escape-characters.php [EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > 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 > > > >
Re: Illegal Characters in an ofbiz URL
From: "Scott Gray" <[EMAIL PROTECTED]> url encoding converts spaces to pluses, Actually, reading the link Scoot provided, I suppose Scoot meaned <> 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 [EMAIL PROTECTED] <[EMAIL PROTECTED]>: 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
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 [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > 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 > >
RE: Illegal Characters in an ofbiz URL
>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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
