I am trying to load budget data (which contains the 12 amounts in a single record, in multiple columns) from Excel using the import template, but unable to figure out the syntax for the column headers for the amounts.

[OSAdmin]

Originally posted by Matthew DeCarlo

1/10/2020

I am trying to load budget data (which contains the 12 amounts in a single record, in multiple columns) from Excel using the import template, but unable to figure out the syntax for the column headers for the amounts. I have tried various formats but no luck. The latest version that I tried was: AMT#::[T#2019M1] AMT#::[T#2019M2]... I received an error indicating that there was no business rule [T#2019M1] . Any help would be appreciated.

[OSAdmin]

Originally posted by Chul Smith

Needed to insert a blank column for AMT#