PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → WD21 xml ( audit file Holland )
WD21 xml ( audit file Holland )
Iniciado por guest, 13,ago. 2016 15:28 - 1 respuesta
Publicado el 13,agosto 2016 - 15:28
Hi

In version 20 I made an export for this file . For the one s that do not know what I mean . An audit file is an xml file that contains almoast everthing of the applicaion.

Now I want to make an import of this file in version 21. Al went great till the point where I get a bit stuck this is inthe transacions section

the nodes are as follows

transactions
journal
transaction
trLine

So I need All the trLine ( transactionlines )


This is what I did and for the journal and the transaction this works . Not for the lines:

IF bTransactiesimport = True THEN

j is int = 0
t is int = 0
l is int = 0
journal is an xmlNode = auditImport.auditfile.company.transactions.journal
transaction is an xmlNode = auditImport.auditfile.company.transactions.journal.transaction
transactionline is an xmlNode = auditImport.auditfile.company.transactions.journal.transaction.trLine
FOR EACH journal OF auditImport.auditfile.company.transactions on journal
j++
FOR EACH transaction OF journal on transaction
t++
FOR EACH transactionline OF transaction on transactionline
l++
Trace(t+ " "+ auditImport.auditfile.company.transactions.journal[j].transaction[t].trLine[l].amnt)
END
END

Trace(t+ " "+ auditImport.auditfile.company.transactions.journal[t].jrnTp)


END

END


Anyone an I dea whe the fault generated is : transactionline is not an xml node ?

regards
Allard
Publicado el 14,agosto 2016 - 13:06
Hi did some investigation and there is a function that seems to be doing what I need


journal is xpathResult = XMLExecuteXPath("/ root")

But what do I need to add for the "/ root"

if I use the path of the xml file it returns nothing

debugger gives empty xml array

journal is xpathResult = XMLExecuteXPath(auditImport,"auditImport.auditfile.company.transactions")

It doesnot matter if I add it in quotes like this:

"auditImport.auditfile.company.transactions"

or without quotes
auditImport.auditfile.company.transactions