Step    Action

  1.      Select {Settings} and then select {Budgets} under Customer

  2.      Select the Imports tab.

  3.      Select {Choose File}. 


         A modal window will open.

 

  3.     Locate file on computer to be imported and select {Open}. The name of the file to

          be imported will appear next to {Choose File} button.



  4.     Select {Import}. A results window will pop-up to confirm the records imported successfully.



Tips for Formatting Budgets .CSV for Import


The following guidelines should be noted when creating your Budgets .CSV file for import:


Notes:

  • Column header names must follow the exact same naming scheme as provided or the import upload will fail. 

  • Blank rows are considered empty and skipped by the importer. 

  • It is possible to successfully upload 0 rows of information, as long as all required columns are present, the importer will still succeed. 

  • Data will not be overwritten if duplicate rows are uploaded, instead another row will be created.

  • Every row uploaded to the importer is assigned a unique ID.
  • Currently there is no way to export this information directly.


FieldIs Field Required?Additional DetailsField Value FormatMax Characters/Values
Active
Yes
  • Must be Yes or No
  • Bit/Boolean

Budget CodeYes
  • Doesn’t have to be unique
  • String/NVarChar
4000
Budget NameYes
  • Doesn’t have to be unique
  • String/NVarChar
4000
AmountYes
  • Only two decimal places allowed
  • Decimal
  • Max value is 99,999,999.99
TaxesYes
  • Must be Yes or No
  • Bit/Boolean

ShippingYes
  • Must be Yes or No
  • Bit/Boolean

PostageYes
  • Must be Yes or No
  • Bit/Boolean

Start DateYes
  • Can be any valid date
  • Must match the format that is set in the configuration options
  • Accepted formats:
    • MM-DD-YYYY

    • MM.DD.YYYY

    • MM/DD/YYYY

    • DD-MM-YYYY

    • DD.MM.YYYY

    • DD/MM/YYYY

    • Will be converted from Local time

  • DateTime object

End DateYes
  • Can be any valid date

  • Must match the format that is set in the configuration options

  • Accepted formats:

    • MM-DD-YYYY

    • MM.DD.YYYY

    • MM/DD/YYYY

    • DD-MM-YYYY

    • DD.MM.YYYY

    • DD/MM/YYYY

    • Will be converted from Local time


  • DateTime object

FrequencyYes
  • Must match one of the following exactly:
    • One Time
    • Weekly
    • Monthly
    • Quarterly
    • Yearly
  • Bit/Boolean

Custom Days



RolloverYes
  • Must be Yes or No
  • Bit/Boolean