# Export Accounts

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.