This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need to bulk upload data into AgileCraft, which only takes XML files or XLS files (but I've found this file type to be inconsistent). These are xml files configured as microsoft excel. The ability to write to these directly would be a big productivity driver as we could pre-populate most of the data and upload directly to AgileCraft; however, Alteryx doesn't output as an XML file.
I've tried some problem solving on my own and found that simply outputting to an XLSX file and then saving it as an XML file doesn't work for the bulk upload process. I need the ability to address specific cells due to the formatting. Thanks in advance.
See attached for a sample template. The sample template has many tabs even though I only use two. "Sheet1", which I'm trying to output my data into, and "Stories", which using formulas, will copy the data from Sheet1. I know there are Macros out there that convert CSV files into XML files, but I can't seem to wrap my head around them as I am still fairly new to Alteryx. Does anyone have any ideas to output as an XML file?
Any ideas would be appreciated!
(I had to zip the file as I kept getting the error "The contents of the attachment doesn't match its file type.")
I have a workflow, but it only transforms and formats data from another excel spreadsheet and outputs it to the template I gave. It's the not particular workflow that I'm having problems with, it's the ability to output to an XML file.
I tired the wizard, but my data doesn't seem to load. I try opening the output file and I get a blank screen. If I try opening it in excel I get a XML parse error. The reason being "Missing equals sign between attribute and attribute value."
Here is an example of the tabular data that I am trying to load, and the output that I am getting.