Archer-to-Archer data feed question
To start with, I am just starting to experiment with Data Feed Manager in Archer. Here's what I am trying to achieve:
We have two questionnaires. Each questionnaire has 100 questions. We want to consolidate answers from each questionnaire records into an on-demand application.
E.g. Assume that there are 10 records in one questionnaire and since we have two such questionnaires with 100 questions each, we can get a maximum of 100x10 = 1000 answers and from the second 50x10 = 500. These 1500 answers need to become 1500 records with "Question Name" as the key field. Next year, possibly another 1500 records will get added and so on.
Currently we have to take a CSV export out of the questionnaires, transpose the data to convert rows to columns, and manually import the answers for all the questions from all questionnaires into the on-demand application.
I heard that modifying the default XML schema will achieve this, but I have no idea how to do this. Has anyone done this in the past? Any guidance will be tremendously helpful.
I appreciate your help.
You would have to dig into some XML. I don't know about editing the default transform (I'm assuming that's what you mean by "schema"), but below is psudo code for a custom transform:
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output indent="yes" media-type="xml"/>
<xsl:for-each select="APP_LEVEL[@levelGuid = 'LEVEL_GUID']">
<xsl:value-of select="TAG_ATTRIBUTE[@guid = 'LEVEL_GUID']"/>
You can get the reports/records being used in XML form by calling them with the API. This is where you would find the app level guids, field guids, attributes, and everything else needed to make the transform bring in the fields you want in whatever format you want. But again, its best to read up on XML because I don't even know if I used the correct terminology.