Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleClick here for a guide to making a valid CSV file...

  • The first row should contain the field headers that are required:
    CustomerCode, EmailAddress, BudgetAmount, BudgetPeriod, BudgetPeriodEndDate, NotificationEmailAddress, EmailFrequency

  • BudgetPeriod and EmailFrequency fields have special codes that must be used:

    BudgetPeriod: Y=Annually, HY=Biannually, M=Monthly, Q=Quarterly, F=Fortnightly, W=Weekly
    EmailFrequency: Y=Annually, HY=Biannually, M=Monthly, Q=Quarterly, F=Fortnightly, W=Weekly, D=Daily
    BudgetPeriodEndDate format: mm/dd/yy

...



Tip
titleLooking for a copy of the CSV file?

The template CSV file is available for download in the 'User Import Function' screen (see below).   

To set or update budgets for multiple users, 

  1. Navigate to UsersWebsite Users.

  2. Hover over Options at the top right corner of the screen to display the 'Export' and 'Import' budget functions. retest


  3. To access the 'User Import Function' screen, click Import Budgets.

  4. In the File Upload section, for Import Type, select either Append or Overwrite.
    Append: only users with no existing budgets will be added
    Overwrite: adds budgets to users that do not have budgets set up and overwrites any pre-existing budgets   

  5. Click Select Files and upload the prepared CSV file. The system will automatically import the file. 

  6. If there is an error notification message 'Import Failed', check the Import Log for specific issues with the upload.
    Image Added 


3. Schedule Budget Notification Emails to Users

Budget remaining and Budget Expiry emails can be scheduled so users can keep track of the amount used and remaining in their allocated budgets and expiry date. 

Scheduling these notification emails are completed as website functions by the administrator. 






Related help

Content by Label
showLabelsfalse
max5
spacesDRAFT
showSpacefalse
sortmodified
reversetrue
typepage
excludeCurrenttrue
cqllabel = "user" and type = "page"
labelskb-how-to-article

...