Using CSV Account Upload To Add Accounts and Credentials In Bulk

Introduction

The CSV Account Upload feature allows users to import multiple accounts and credentials in bulk to make account creation easier, faster, and reduce the potential for error that may occur when accounts are added manually.

To successfully add multiple accounts and credentials in bulk, follow these steps in order:

  • create AWS credentials using IAM access keys
  • upload accounts using a comma-separated values (CSV) file
  • register new AWS accounts within the application
  • add credentials for registered accounts


Create AWS Credentials

In order to use the CSV Account Upload feature in CloudCheckr, you must create AWS credentials using the IAM access key and secret key in the AWS Management Console.

Perform the steps in the procedure, Creating AWS Credentials Using IAM Access Keys, which shows you how to create a user and export a .CSV file that contains their IAM access key and secret key.


Upload Accounts Using CSV

To add multiple accounts and credentials in bulk, you must provide a .CSV file that contains a complete list of the users and their associated accounts, IAM access keys, and secret keys.

  1. For each user, copy the IAM access key, secret key, and account name from the separate .CSV files you exported earlier and paste them into one .CSV file.  To donwload a template, click CSV Template.

    Note: Incorrect formatting or empty fields may cause the upload to fail. In this case, the application does not provide an error message. To ensure your upload is successful, remove column headers before you upload the file.

  2. Save the .CSV file that contains all of your IAM access keys, secret keys, and account names on your PC.
  3. Launch CloudCheckr.
  4. From the header bar, click the Admin Functions icon and select CSV Account Upload from the menu.
  5. The CSV Upload dialog box opens.

  6. Click Choose File to navigate to the .CSV file that contains the list of accounts you want to configure.
  7. Click Upload.

  8. All accounts listed in the .CSV file now contain credentials.


Register New AWS Accounts Within the Application

  1. From the landing page, select the payer account.
  2. From the left navigation pane, choose Account Settings > Detailed Billing Bucket.

  3. The Edit Detailed Billing Bucket screen opens.


  4. Select the Register AWS accounts for new payees check box and click Update.

  5. Once the bill collector runs (it runs once every hour), the application will create a separate project for each linked account in the consolidated billing family.


Add Credentials for the Registered Accounts

Once the accounts are in the application, you can add credentials manually using the CloudFormation templates in the AWS Management Console.