Skip to main content

Bulk import users and CSV

Answered
John Schoenstein

Hi,

I'm trying to script the import of users via powershell. I get requests 5-6 at a time that need to be created and added to a group. I have a PS script to get all the info I want to import from AD, but have run into problems.

1) are all the headers required to successfully create an account? Can I just specify the 6 fields that I need? Can I use a file with quotes around the fields?

2) even with all fields accounted for, the 'allow ftp' is off by one section.

(it won't let me paste the contents of my import file)

0

Comments

2 comments

Date Votes
  • Permanently deleted user
    Development

    Hi,

    It looks like you're using a PowerShell script to generate a CSV file and plan to import this file into Cerberus.

    If this is the approach you're taking, then:

    1a. Yes, all of the headers must be present and in the same order.

    1b. No, you cannot strip out columns only to the fields you need. CSV import will misread the columns and create incorrect user entries.

    1c. Yes, quotes around headers and around values should be handled correctly.

    It is best to export some existing users first and use the exported CSV as a guide, rather than trying to match the columns appearing in the 'import' dialog. There are a few columns added in later versions of 10.0.x that do not appear in the 'import' dialog.

    Also, CSV files are not compatible between Cerberus versions. 

    2. It's hard to say why the columns are not aligned correctly. Cerberus version 10.0.8 and later have an additional column immediately before the "Allow FTP" column which controls whether the the group settings should be overridden by user settings. Export users and examine the resulting CSV columns very carefully.

    You may want to consider using Cerberus SOAP API to make changes to native users. The SOAP API should be a more stable way of scripting user changes than the CSV formatting. You may also set only the user attributes you prefer in your PowerShell code. Guides are available here:

    https://support.cerberusftp.com/hc/en-us/articles/360005036860-What-is-SOAP-and-How-Does-Cerberus-Use-It

    0
  • John Schoenstein

    Hi,

     The import_test.csv we got from the Cerberus website doesn't include the extra column. The one from the Import page within the server has it.

    In our environment, the FTP server is in a DMZ and Network engineers won't open the ports required for SOAP, so I'm stuck with CSV import.

    Once I added the field, it shows correctly in the import preview window.

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post