Is data export to Excel supported in Vantage?

Question

Can I export data to Excel?

Answer

Excel is only supported for full-text export. It can be enabled in the Process Skill editor > Output activity > Exported Data Settings > Text tab:

 




For fields, only JSON format is supported.

Have more questions? Submit a request

Comments

4 comments

  • Avatar

    Veerish Uppin

    Can I write in the script to export the data in CSV or JSON file ? If yes, what is the syntax I need follow. 

    0
  • Avatar

    Dmytro Bezus

    Hello Veerish,

    The export script could be written in the custom activity. You may find the samples in the guide:

    EU instance - https://vantage-eu.abbyy.com/help/English/SkillDesigner/?topic=process_custom_samplescripts

    AU instance - https://vantage-au.abbyy.com/help/English/SkillDesigner/?topic=process_custom_samplescripts

    US instance - https://vantage-us.abbyy.com/help/English/SkillDesigner/?topic=process_custom_samplescripts

     

    For JSON:

    // Get the document export result
    var exports = Context.Transaction.Documents[0].Exports;
    var extractedDataExportResult = exports.find(element => element.ExportFormat === ExportFormat.Json);

    Kind regards,

    Dmytro

    0
  • Avatar

    Veerish Uppin

    Dmytro Bezus 

    I have used the below script but when I try to append the file it give me an error saying that extractedDataExportResult is null and it cannot be null. 

    Command used to append file: 
    httpRequest.AppendFileContent(extractedDataExportResult,"electronicDocument");

    I have also tried 
    // add extracted data to the export result
    multiPartRequest.AppendStringContent(extractedDataExportResult.ToJson(), "jsonData");

    var exports = Context.Transaction.Documents[0].Exports;
    var extractedDataExportResult = exports.find(element => element.ExportFormat === ExportFormat.Json);
    0
  • Avatar

    Dmytro Bezus

    Hello Veerish,

    Did you check the "Send export data to an external service" script sample? You could use:

    httpRequest.SetFileContent(extractedDataExportResult, "application/octet-stream");

    In addition, you could use Context.LogMessage() method for debugging via the transaction log.

    Kind regards,

    Dmytro

    0

Please sign in to leave a comment.