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 |
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 |
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 > > |
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 >> >> > |
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 > > > > |
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 >> >> >> >> > > > > |
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 > 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 |
Free forum by Nabble | Edit this page |