Newsgroup: it.comp.appl.access
Titolo: FE - causale documento non valida ???

Mi dicono che un campo
 
<FatturaElettronicaBody>
<DatiGenerali>
<DatiGeneraliDocumento>
<Causale>
 
di questo tipo
 
<Causale>Cessione NON IMPONIBILE IVA art.8 1 C. lettera C del D.P.R. 
633/1972, come da Vs. Dichiarazione d&amp;amp;apos;Intento n.  27  del 
07/01/2019  da noi annotata al n.    in data  07/01/2019  valida per 
l&amp;amp;apos;anno  2019</Causale>
 
non sia valido per
"..caratteri strani nel campo Causale Documento.."
 
Mi aiutereste a trovare i caratteri 'strani'?
 
 


che apostrofo hai messo su d'intento? e su per l'anno?
apice o simboli strani?
 
ciao
BFS
 


L'apice singolo classico
Su tastiera italiana in alto a destra a fianco dello 0
 


fai una sorta di replace di caratteri particolari quando scrivi il file xml?
 
sta schifezza chi l'ha aggiunta?
d&amp;amp;apos;


Io
uso questa routine per 'ripulire' codice articolo, descrizione articolo, 
causale documento, routine che evidentemente non funziona a dovere
Vedo pero' che molti caratteri, altri sistemi, non li convertono nel 
senso che ad esempio il Ø sulla descrizione articolo viene mantenuto 
cosi' com'e' e pure tutte le accentate
Quindi sto convertendo molti piu' caratteri del necessario
Le domande sono:
1 quali caratteri devono essere convertiti?
2 esattamente quali campi 'devono' essere ripuliti?
 
Pure indirizzi, ragione sociale, ed altri?
 
--------------------------------------
Private Function carNoXML(ByVal strOriginal As String) As String
     Dim strTemp As String
     strTemp = strOriginal
 
     strTemp = Replace(strTemp, "&", "&amp;")
     strTemp = Replace(strTemp, "’", "'")
     strTemp = Replace(strTemp, """", "&quot;")
 
     strTemp = Replace(strTemp, "'", "&apos;")
     strTemp = Replace(strTemp, "<", "&lt;")
     strTemp = Replace(strTemp, ">", "&gt;")
     strTemp = Replace(strTemp, "", "&nbsp;")
 
     strTemp = Replace(strTemp, "ó", "&oacute;")
     strTemp = Replace(strTemp, "á", "&aacute;")
     strTemp = Replace(strTemp, "é", "&eacute;")
     strTemp = Replace(strTemp, "í", "&iacute;")
     strTemp = Replace(strTemp, "ú", "&uacute;")
 
     strTemp = Replace(strTemp, "¡", "&iexcl;")
     strTemp = Replace(strTemp, "¢", "&cent;")
     strTemp = Replace(strTemp, "£", "&pound;")
     strTemp = Replace(strTemp, "¤", "&curren;")
     strTemp = Replace(strTemp, "¥", "&yen;")
     strTemp = Replace(strTemp, "¦", "&brvbar;")
     strTemp = Replace(strTemp, "§", "&sect;")
     strTemp = Replace(strTemp, "¨", "&uml;")
     strTemp = Replace(strTemp, "©", "&copy;")
     strTemp = Replace(strTemp, "ª", "&ordf;")
     strTemp = Replace(strTemp, "«", "&laquo;")
     strTemp = Replace(strTemp, "¬", "&not;")
 
     strTemp = Replace(strTemp, "®", "&reg;")
     strTemp = Replace(strTemp, "¯", "&macr;")
     strTemp = Replace(strTemp, "°", "&deg;")
     strTemp = Replace(strTemp, "±", "&plusmn;")
     strTemp = Replace(strTemp, "²", "&sup2;")
     strTemp = Replace(strTemp, "³", "&sup3;")
     strTemp = Replace(strTemp, "´", "&acute;")
     strTemp = Replace(strTemp, "µ", "&micro;")
     strTemp = Replace(strTemp, "¶", "&para;")
     strTemp = Replace(strTemp, "·", "&middot;")
     strTemp = Replace(strTemp, "¸", "&cedil;")
     strTemp = Replace(strTemp, "¹", "&sup1;")
     strTemp = Replace(strTemp, "º", "&ordm;")
     strTemp = Replace(strTemp, "»", "&raquo;")
     strTemp = Replace(strTemp, "¼", "&frac14;")
     strTemp = Replace(strTemp, "½", "&frac12;")
     strTemp = Replace(strTemp, "¾", "&frac34;")
     strTemp = Replace(strTemp, "¿", "&iquest;")
 
     strTemp = Replace(strTemp, "×", "&times;")
     strTemp = Replace(strTemp, "÷", "&divide;")
 
     strTemp = Replace(strTemp, "à", "&agrave;")
     strTemp = Replace(strTemp, "â", "&acirc;")
     strTemp = Replace(strTemp, "ã", "&atilde;")
     strTemp = Replace(strTemp, "ä", "&auml;")
     strTemp = Replace(strTemp, "å", "&aring;")
     strTemp = Replace(strTemp, "æ", "&aelig;")
 
     strTemp = Replace(strTemp, "ç", "&ccedil;")
     strTemp = Replace(strTemp, "è", "&egrave;")
     strTemp = Replace(strTemp, "ê", "&ecirc;")
     strTemp = Replace(strTemp, "ë", "&euml;")
     strTemp = Replace(strTemp, "ì", "&igrave;")
     strTemp = Replace(strTemp, "î", "&icirc;")
     strTemp = Replace(strTemp, "ï", "&iuml;")
     strTemp = Replace(strTemp, "ð", "&eth;")
     strTemp = Replace(strTemp, "ñ", "&ntilde;")
     strTemp = Replace(strTemp, "ò", "&ograve;")
     strTemp = Replace(strTemp, "ô", "&ocirc;")
     strTemp = Replace(strTemp, "õ", "&otilde;")
     strTemp = Replace(strTemp, "ö", "&ouml;")
     strTemp = Replace(strTemp, "ø", "&oslash;")
     strTemp = Replace(strTemp, "ù", "&ugrave;")
     strTemp = Replace(strTemp, "û", "&ucirc;")
     strTemp = Replace(strTemp, "ü", "&uuml;")
     strTemp = Replace(strTemp, "ý", "&yacute;")
     strTemp = Replace(strTemp, "þ", "&thorn;")
     strTemp = Replace(strTemp, "ÿ", "&yuml;")
 
     strTemp = Replace(strTemp, "À", "&Agrave;")
     strTemp = Replace(strTemp, "Á", "&Aacute;")
     strTemp = Replace(strTemp, "Â", "&Acirc;")
     strTemp = Replace(strTemp, "Ã", "&Atilde;")
     strTemp = Replace(strTemp, "Ä", "&Auml;")
     strTemp = Replace(strTemp, "Å", "&Aring;")
     strTemp = Replace(strTemp, "Æ", "&AElig;")
 
     strTemp = Replace(strTemp, "Ç", "&Ccedil;")
     strTemp = Replace(strTemp, "È", "&Egrave;")
     strTemp = Replace(strTemp, "É", "&Eacute;")
     strTemp = Replace(strTemp, "Ê", "&Ecirc;")
     strTemp = Replace(strTemp, "Ë", "&Euml;")
 
     strTemp = Replace(strTemp, "Ì", "&Igrave;")
     strTemp = Replace(strTemp, "Í", "&Iacute;")
     strTemp = Replace(strTemp, "Î", "&Icirc;")
     strTemp = Replace(strTemp, "Ï", "&Iuml;")
 
     strTemp = Replace(strTemp, "Ð", "&ETH;")
     strTemp = Replace(strTemp, "Ñ", "&Ntilde;")
 
     strTemp = Replace(strTemp, "Ò", "&Ograve;")
     strTemp = Replace(strTemp, "Ó", "&Oacute;")
     strTemp = Replace(strTemp, "Ô", "&Ocirc;")
     strTemp = Replace(strTemp, "Õ", "&Otilde;")
     strTemp = Replace(strTemp, "Ö", "&Ouml;")
     strTemp = Replace(strTemp, "Ø", "&Oslash;")
 
     strTemp = Replace(strTemp, "Ù", "&Ugrave;")
     strTemp = Replace(strTemp, "Ú", "&Uacute;")
     strTemp = Replace(strTemp, "Û", "&Ucirc;")
     strTemp = Replace(strTemp, "Ü", "&Uuml;")
     strTemp = Replace(strTemp, "Ý", "&Yacute;")
     strTemp = Replace(strTemp, "Þ", "&THORN;")
     strTemp = Replace(strTemp, "ß", "&szlig;")
 
     strTemp = Replace(strTemp, "Œ", "&OElig;")
     strTemp = Replace(strTemp, "œ", "&oelig;")
     strTemp = Replace(strTemp, "Š", "&Scaron;")
     strTemp = Replace(strTemp, "š", "&scaron;")
     strTemp = Replace(strTemp, "Ÿ", "&Yuml;")
     strTemp = Replace(strTemp, "ƒ", "&fnof;")
     strTemp = Replace(strTemp, "ˆ", "&circ;")
 
     strTemp = Replace(strTemp, "–", "&ndash;")
     strTemp = Replace(strTemp, "—", "&mdash;")
     strTemp = Replace(strTemp, "‘", "&lsquo;")
     strTemp = Replace(strTemp, "’", "&rsquo;")
     strTemp = Replace(strTemp, "‚", "&sbquo;")
     strTemp = Replace(strTemp, "“", "&ldquo;")
     strTemp = Replace(strTemp, "”", "&rdquo;")
     strTemp = Replace(strTemp, "„", "&bdquo;")
     strTemp = Replace(strTemp, "†", "&dagger;")
     strTemp = Replace(strTemp, "‡", "&Dagger;")
     strTemp = Replace(strTemp, "•", "&bull;")
     strTemp = Replace(strTemp, "…", "&hellip;")
     strTemp = Replace(strTemp, "‰", "&permil;")
     strTemp = Replace(strTemp, "‹", "&lsaquo;")
     strTemp = Replace(strTemp, "›", "&rsaquo;")
     strTemp = Replace(strTemp, "€", "&euro;")
     strTemp = Replace(strTemp, "™", "&trade;")
     carNoXML = strTemp
End Function
--------------------------------------