Hey Kevin, I have been trying to figure out how to upload xml and display its data in fields, could you make a quick demo if that is not too much to ask? I have tried everything I could find.kev1n wrote: ↑Tue Mar 21, 2023 8:56 am To upload a file, you can use the File object.
This Tutorial should help you get startet to parse an XML file: https://www.w3schools.com/xml/default.asp
Code: Select all
<CommonTemplate Version="2.0">
<TerminalTemplate>
<MasterTerminalID>TBCPOSQRPAY</MasterTerminalID>
<TerminalId>320761243</TerminalId>
<Address>Sample Address</Address>
<SerialNo>320761243</SerialNo>
<VirtualPOSID>SH039915</VirtualPOSID>
<WKeyTPK>EDE4A04E2ED78E2532A5D18B934E6721</WKeyTPK>
<SSLClientCertificate></SSLClientCertificate>
<SSLPrivateKey></SSLPrivateKey>
<ReconciliationTime>21:00:00</ReconciliationTime>
<Caption>11111111-433651960</Caption>
</TerminalTemplate>
<PossessorTemplate>
<Name>Sample Name</Name>
<MerchantId>7913637_1</MerchantId>
<FsINN>400342429</FsINN>
<FsRsStatementNum>12087082</FsRsStatementNum>
<FsSamID>27051465</FsSamID>
<FsCashPayLimit>0</FsCashPayLimit>
</PossessorTemplate>
</CommonTemplate>
Code: Select all
<input type="file" id="file-input">
<br><br>
Terminal ID: <span id="terminal-id"></span><br>
Address: <span id="address"></span><br>
FsRsStatementNum: <span id="statement-num"></span>
<script>
// Get references to HTML elements
var fileInput = document.getElementById('file-input');
var terminalId = document.getElementById('terminal-id');
var address = document.getElementById('address');
var statementNum = document.getElementById('statement-num');
// Function to handle file upload
function handleFileUpload() {
// Get the uploaded file
const file = fileInput.files[0];
// Create a new FileReader
const reader = new FileReader();
// When the FileReader finishes loading the file
reader.onload = function(event) {
// Get the contents of the file as a string
const fileContents = event.target.result;
// Create a new DOMParser
const parser = new DOMParser();
// Parse the file contents as XML
const xmlDoc = parser.parseFromString(fileContents, "text/xml");
// Get the TerminalId, Address, and FsRsStatementNum elements
const terminalIdElement = xmlDoc.getElementsByTagName("TerminalId")[0];
const addressElement = xmlDoc.getElementsByTagName("Address")[0];
const statementNumElement = xmlDoc.getElementsByTagName("FsRsStatementNum")[0];
// Set the values of the HTML elements
terminalId.textContent = terminalIdElement.textContent;
address.textContent = addressElement.textContent;
statementNum.textContent = statementNumElement.textContent;
};
// Read the file as text
reader.readAsText(file);
}
// Add an event listener to the file input
fileInput.addEventListener('change', handleFileUpload);
</script>Code: Select all
nuSetValue('terminalId', terminalIdElement.textContent);Code: Select all
terminalId.textContent = terminalIdElement.textContent;Code: Select all
<input type="file" id="file-input">
<br><br>
<script>
// Get references to HTML elements
var fileInput = document.getElementById('file-input');
// Function to handle file upload
function handleFileUpload() {
// Get the uploaded file
const file = fileInput.files[0];
// Create a new FileReader
const reader = new FileReader();
// When the FileReader finishes loading the file
reader.onload = function(event) {
// Get the contents of the file as a string
const fileContents = event.target.result;
// Create a new DOMParser
const parser = new DOMParser();
// Parse the file contents as XML
const xmlDoc = parser.parseFromString(fileContents, "text/xml");
// Get the TerminalId, Address, and FsRsStatementNum elements
const terminalIdElement = xmlDoc.getElementsByTagName("TerminalId")[0];
const posIdElement = xmlDoc.getElementsByTagName("VirtualPOSID")[0];
const addressIdElement = xmlDoc.getElementsByTagName("Address")[0];
const reconcilationIdElement = xmlDoc.getElementsByTagName("ReconciliationTime")[0];
const nameIdElement = xmlDoc.getElementsByTagName("Name")[0];
const merchantIdElement = xmlDoc.getElementsByTagName("MerchantId")[0];
const INNIdElement = xmlDoc.getElementsByTagName("FsINN")[0];
const AppNumberIdElement = xmlDoc.getElementsByTagName("FsRsStatementNum")[0];
nuSetValue('SerialNumber', terminalIdElement.textContent);
nuSetValue('TerminalID', posIdElement.textContent);
nuSetValue('Address', addressIdElement.textContent);
nuSetValue('Reconcilation', reconcilationIdElement.textContent);
nuSetValue('MerchantName', nameIdElement.textContent);
nuSetValue('MerchantID', merchantIdElement.textContent);
nuSetValue('INN', INNIdElement.textContent);
nuSetValue('InstallAppNumber', AppNumberIdElement.textContent);
};
// Read the file as text
reader.readAsText(file);
}
// Add an event listener to the file input
fileInput.addEventListener('change', handleFileUpload);
</script>