Export Accounts

Markdown

View as Markdown

Export Accounts is the best way to produce a report in csv (Excel) format to view all of the accounts in your organization's registry.

Export Accounts filters

  • Account number (From / Thru): Leave both blank to include all accounts. Enter a range to limit the export by account number.

  • Created date (From / Thru): Enter a date range to include accounts created during that period. Leave both blank to ignore creation date and include accounts regardless of when they were created.

  • Last update date (From / Thru): Enter a date range to limit the export to accounts with activity during that period. Leave both blank to include accounts regardless of last update date.

  • Scripts: Turn Yes on to include script question-and-answer details in the report. Turn it off if you don’t need that detail.

  • Script Answered: Your note says Yes includes unanswered questions, but the control is labeled Script Answered. Please confirm what Yes should do before relying on this setting.

  • Include Questions Not Answered: Turn On to include script questions even when they have no answer.

  • Include Inactive Accounts: Leave Off to exclude inactive accounts; turn On to include them.

  • Filter Scripts: Leave blank for all Scripts to be included. Enter list of scripts whose detail to include in the export. Only valid when "Scripts" is Yes.

  • Format: No functional at this time

To produce an Excel report of all of the active accounts for your organizations registry:

Below are the columns reported:

Acct#,Active,Allow First Resp,Affiliated Organization,Createdt Dt,Last Updated Dt,First,Last,Suffix,Address,Apt,City,State,Zip,HomePhone,CellPhone,Email,DateOfBirth,Gender,Passport#,Passport Expr Dt,Notes,PC Relationship,PC Email,PC Cell Phone,PC Day Phone,PC Address,PC City,PC State,PC Zip,PC Legal Guardian,PC First,SC Relationship,SC Email,SC Cell Phone,SC Day Phone,SC Address,SC City,SC State,SC Zip,SC Legal Guardian,SC Last

PC = Primary Contact SC = Secondary Contact

Sample spreadsheet:

Show accounts along with their script questions and answers. Do not include questions that weren't answered.

Show accounts along with their script questions and answers. Include questions that weren't answered.

Show accounts along with their script questions and answers. Include questions that weren't answered. Only show questions and answers from the Anxiety Test script.

Was this article helpful?

Still need help?

Contact us