FAQ: Core BizApps

Table of Contents

Encryption

• Errors

  • Error: Could not execute command: Value to encrypt is empty

File Utilities

• How-To

  • How do you rename files in OneCloud?

  • How to filter out the first record of a file?

• General

  • Why are the File Utilities Commands not able to access a remote drive?

Handlebars

• How-To

  • What is the Handlebars BizApp and how do I use it?

  • How do I escape special characters with Handlebars?

  • What are Handlebars JSON Variables and how can I use them?

  • How do I set varying date formats using Handlebars?

• General

  • Where can I find some additional information related to Handlebars?

  • What's the difference between the Render File Template and Render Text Template Commands and which should I use?

JSON

• How-To

  • How to use the CSV to JSON Command and iterate over the results?

• Errors

  • Error finding the root array element, please check your path: path not found

• General

  • My JSON to Tabular indicates “conversion successful”, but I do not get any data.

Microsoft Excel

• How-To

  • How to use the Create Workbook Command of the OneCloud Excel BizApp?

• General

  • How does the OneCloud Excel BizApp handle the calculation of formulas in workbooks?

  • What is the support for Excel macros when using the OneCloud Excel BizApp?

Tabular Transformation

• How-To

  • How to fix the Advanced Query Command dropping of leading zeros?

  • How can the Advanced Query Command suppress records with duplicate unique IDs?

  • How do I add multiple columns to a file?

  • How do I use Advanced Query with spaces in the columns names?

  • What is the Smart Filter Rows Command and how do I use it?

  • How to sum values with a dollar sign?

  • How to Incorporate Multiple "Find and Replace" into a Single Command?

  • How to display numbers in their native form?

  • How to "Find and Replace" a single character (pattern)?

  • How can fields be concatenated?

• Errors

  • Find and Replace is not working with exact match.

• General

  • Can I use the UPDATE or INSERT statements with Advanced Query?