Export Users to CSV

 

What it does?

This web application will export all the users on a specified account to a CSV file.  This can be handy if you need a CSV of all your users for updating another application or to edit your existing users so you can re-upload the users to Articulate Online.

What API commands does it use?

ListUsers

What are the requirements?

• An Articulate Online account with the AO API enabled (How to?)
• A server that supports and has PHP installed
• Nusoap (don’t be scared by this, it is free, and I’ll explain later)

How it works?

Here is basically what happens:

1. You go to login form (accountdetails.php)
2. Fill in the form and click “Export CSV”
3. The form data is sent to listusers.php
4. listusers.php takes the data from the form, connects to the AO API
5. listusers.php creates a CSV and prompts the user to save the CSV

Installation and Configuration Instructions:

Installation and configuration is meant to be pretty straight forward and as painless as possible.

Here is what you need to do:

1. Install nusoap  

Nusoap is basically just a set of files (PHP class files) that allow you to connect to the Articulate Online API via PHP.

1. Download nusoap from SourceForge
2. Unzip the files
3. Upload the folder to your webserver

That’s it. You now have access to nusoap.

2. Next, Install and Configure the application

There are 2 files included in this application:

accountdetails.php – is a straight forward HTML page that contains a form that asks for email, password, Customer ID, and Account URL.

listusers.php – is the meat of the application. It connects to the API and then creates a CSV of all the users on the specified account.

1. Download the source files here.
2. Unzip the files
3. Open the listusers.php file in notepad
4. Find this line:
   require_once(‘../../lib/nusoap.php’);
5. Change this section ‘../../lib/nusoap.php’ to point to your nusoap installation
6. Upload the application to your website

You are done, that is it.

Try the application

Now that you have installed and configured the application, point your browser to the accountdetails.php file. Fill in the options and test it out.

Sample in action

Now that I have explained the applicaiton, maybe you want to check it out. I have uploaded this sample to my website. You can try it here:

http://www.mozealous.com/samples/selfregister/accountdetails.php

This will create a CSV of all the users on your account.

That is it, hope this was all straight forward and easy to follow. Feel free to comment if you have any questions!