topic Problem: XML tag value not right in Alfresco Archive

Problem: XML tag value not right

valfontanette — Wed, 25 Jun 2014 14:06:37 GMT

HII am having trouble to get the right content of a XML file. Just because the value of initial tags are not right.Here is what I mean.<?xml version="1.0" encoding="UTF-8"?><nfeProc xmlns="http://www.portalfiscal.inf.br/nfe" versao="2.00"> <NFe xmlns="http://www.portalfiscal.inf.br/

Re: Problem: XML tag value not right

mitpatoliya — Wed, 25 Jun 2014 14:13:50 GMT

may be you need to use

document.content.content= document.content.content.replaceAll("(?s)<\\?infNFe Id .*?\\?>\\s*", "<infNFe>");
document.save();

and also remember to save the document.

Re: Problem: XML tag value not right

kaynezhang — Wed, 25 Jun 2014 16:16:40 GMT

Why not just operate your xml using e4x? you can remove xml attribute using delete command.


var content = new xml(fileContent);
delete content.@xmlns; //delete nfeProc xmlns attribute
delete content.infNFe.@versao // delete infNFe versao attribte
‍‍‍‍‍

Re: Problem: XML tag value not right

valfontanette — Wed, 25 Jun 2014 22:30:00 GMT

Hi,

Thanks for your attention!
I tried out what you suggested, but I got some errors so I don't know if I did it right.

I tried this.


document.content.replaceAll("(?s)<\\?xml .*?\\?>\\s*", "");
document.content.content= document.content.content.replaceAll("(?s)\\s*", "");
document.save();

‍‍‍‍‍‍

It returns TypeError: Cannot call method "replaceAll" of undefined

I tried this.


document.content.replaceAll("(?s)<\\?xml .*?\\?>\\s*", "");
document.content.content.replaceAll("(?s)\\s*", "");
document.save();

‍‍‍‍‍‍

It returns TypeError: Cannot call method "replaceAll" of undefined

I tried this.


document.content.replaceAll("(?s)<\\?xml .*?\\?>\\s*", "");
document.content.content= document.content.content.replaceAll("(?s)\\s*", "");
document.save();
var fileContent = new XML(document);

‍‍‍‍‍‍‍

It returns TypeError: Cannot call method "replaceAll" of undefined

I tried this


var fileContent = new XML(document.content.replaceAll("(?s)<\\?xml .*?\\?>\\s*", ""));
var fileContent2 = new XML(fileContent.content.content.replaceAll("(?s)\\s*", ""));
‍‍‍‍

It returns: TypeError: Cannot find function replaceAll.

Am I doing wrong?

Thanks,

Re: Problem: XML tag value not right

valfontanette — Wed, 25 Jun 2014 22:43:36 GMT

Hi,

Thanks for you attention.

I've tried this, but it returns the same result I had before. It deletes xmls, but do not delete versao.

I got this:



<nfeProc versao="2.00">
   <NFe>
     <infNFe Id="NFe35140404108518000102550020000957691354988086" versao="2.00">

‍‍‍‍‍‍‍

But I need to get to this:



<nfeProc>
   <NFe>
     <infNFe>

‍‍‍‍‍‍‍

It deletes only xmls. Why doesn't work okay with "versao" and "Id"???
I've tried so many ways and nothing works.

I am attaching my xml file.

Any clues?

Re: Problem: XML tag value not right

kaynezhang — Thu, 26 Jun 2014 02:48:31 GMT

Try this


var fileContent = document.content;
var xml = new XML(fileContent);
var nfe = xml.child(0);
var infNFe= nfe.child(0);

delete infNFe.@versao; // delete infNFe versao attribte
delete infNFe.@Id;

delete nfe.@xmlns;

delete xml.@versao; //delete nfeProc  versao attribute
delete xml.@xmlns; //delete nfeProc  xmlns attribute
‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Problem: XML tag value not right

valfontanette — Thu, 26 Jun 2014 15:44:07 GMT

Hi kaynezhang, Thanks for your help!

I tried it and got the same result. It didn't take of versao and Id.

I am sending a picture with it.

I don't know whatelse to try. I have the documentation e4X but I can't make it works.

Thanks again.

Re: Problem: XML tag value not right

kaynezhang — Fri, 27 Jun 2014 00:10:43 GMT

I have just tested in my environmenet.
It is surprising that versao and Id attribute had been removed correctly,but xmls not,the result is opposite to yours ,I'll check why.

Re: Problem: XML tag value not right

valfontanette — Thu, 03 Jul 2014 13:25:37 GMT

Hi kaynezhang,

I think I am doing something wrong on trying this.

I just figured out that: If

I set up this script on a folder;
I upload a xml file to that folder and that runs the script;
So, to see if it worked I opened the uploaded xml file;
But, I figured that the xml file is always the same. Is has no xmlns and has versao and Id even If my code didn't tell to take it of.

So, I tried to print the xml content and a specifc tag. But it prints the complete xml file (with xml (first line) xmlns, versao and Id).

I did like this:


var fileContent = document.content;

var xml = new XML(fileContent);

var nfe = xml.child(0);

var infNFe= nfe.child(0);

 
delete infNFe.@versao; // delete infNFe versao attribte

delete infNFe.@Id;


delete nfe.@xmlns;

delete xml.@versao; //delete nfeProc  versao attribute

delete xml.@xmlns; //delete nfeProc  xmlns attribute



logger.getSystem().out("#### XML CONTENT  #####  " + xml);

var cnpj = xml.NFe.infNFe.dest.CNPJ;

logger.getSystem().out("#### CNPJ value is ####  " +cnpj);


‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Am I doing something wrong to see if it works? How did you do it?

Thanks a lot!

Re: Problem: XML tag value not right

valfontanette — Fri, 11 Jul 2014 19:10:46 GMT

Any clues???

I coudn't make this work. I have no idea whatelse to try.

Anyone?!?

Thanks,

Re: Problem: XML tag value not right

valfontanette — Tue, 22 Jul 2014 18:04:01 GMT

Hi,

I finally got it right.
I find out some of my xml files have a problem and because of that my code didn't work before.

My right code is now like this:



logger.getSystem().out("####BEGIN  #####  ");
var xml = new XML(document.content.replaceAll("(?s)<\\?xml .*?\\?>\\s*", ""));

default xml namespace="http://www.portalfiscal.inf.br/nfe"; //to solve xmls parameter
var nfe = xml.child(0);
var infNFe= nfe.child(0);

delete infNFe.@versao; // delete infNFe versao attribte
delete infNFe.@Id;
delete nfe.@xmlns;
delete xml.@versao;
delete xml.@xmlns; 

logger.getSystem().out("#### XML CONTENT  #####  " + xml);

var cnpj= xml.NFe.infNFe.dest.CNPJ;
var empresa= xml.NFe.infNFe.dest.xNome;
var competencia = xml.NFe.infNFe.ide.dEmi;
var cnpj_fornecedor = xml.NFe.infNFe.emit.CNPJ;
var fornecedor = xml.NFe.infNFe.emit.xNome;

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍