Hi ,anybody can help me on how to add email alias in bulk via CSV or batch file
--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-apps-manager@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/dda1c0f5-4502-4b7f-a3c8-c63f65edb140%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Good afternoon. GAM can be used to add aliases. The command for this is the following:gam create alias <alias> user <username>If you create a CSV file with the username and alias needed, then you can do a bulk add alias with GAM. You can format the file as follows:ALIAS_ADD.CSVuser,aliasuser_one,alia...@domain.comuser_one,alia...@domain.com
user_two,alias_three@domain.comuser_three,alias_four@domain.com
You can then use the following command to use the CSV for the batch update.gam csv ALIAS_ADD.CSV gam create alias ~alias user ~user
On Fri, Feb 10, 2017 at 1:51 PM, Mearaj Shaikh <mea...@shivaami.com> wrote:
Hi ,anybody can help me on how to add email alias in bulk via CSV or batch file
--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsubscribe...@googlegroups.com.
To post to this group, send email to google-apps-manager@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/dda1c0f5-4502-4b7f-a3c8-c63f65edb140%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--Kevin MelilloElectronic Communications AnalystInformation Technology445 Hoes LanePiscataway, NJ 08854Phone:732-465-6609 | Mobile: 732-609-4331E-mail: k.me...@ieee.org
--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-apps-manager@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAKM%3DboZ6rtmUe0cK6yorzVEzH06g0i1w3OSrEg2zKvcnP1NRAQ%40mail.gmail.com.
DisplayName | PrimarySmtpAddress | EmailAddresses |
company_name_Technical_Architecture | _Technical_A...@domain.com | company_name_Technical_Architecture | _Technical_Architecture | _CTA_GRP | CPN_Technical_Architecture |
Mearaj/Kevin,I would suggest putting the column names in quotes if you are on a platform other than Windows (although it is OK on Windows.)Some shells look at ~xyz and may transform it if there is a user named xyz on the system; the quotes eliminate this behavior.gam csv ALIAS_ADD.CSV gam create alias "~alias" user "~user"Ross
On Fri, Feb 10, 2017 at 11:50 AM, Kevin Melillo <k.me...@ieee.org> wrote:
Good afternoon. GAM can be used to add aliases. The command for this is the following:gam create alias <alias> user <username>If you create a CSV file with the username and alias needed, then you can do a bulk add alias with GAM. You can format the file as follows:ALIAS_ADD.CSVuser,aliasuser_one,alia...@domain.comuser_one,alia...@domain.com
user_two,alias...@domain.comuser_three,alias...@domain.com
You can then use the following command to use the CSV for the batch update.gam csv ALIAS_ADD.CSV gam create alias ~alias user ~user
On Fri, Feb 10, 2017 at 1:51 PM, Mearaj Shaikh <mea...@shivaami.com> wrote:
Hi ,anybody can help me on how to add email alias in bulk via CSV or batch file
--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/dda1c0f5-4502-4b7f-a3c8-c63f65edb140%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--Kevin MelilloElectronic Communications AnalystInformation Technology445 Hoes LanePiscataway, NJ 08854Phone:732-465-6609 | Mobile: 732-609-4331E-mail: k.me...@ieee.org
--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAKM%3DboZ6rtmUe0cK6yorzVEzH06g0i1w3OSrEg2zKvcnP1NRAQ%40mail.gmail.com.
Does anyone have a script to pull an easy list of aliases into a CSV for use by the GAM command? I have been editing the data manually after extracting from EMC but the aliases are in a string and not overly handy to separate. I am able to do it by removing quotes in Notepad then replacing spaces in the addresses column with commas. This allowed me to import into Excel with each once in separate column but now I have to pull the data from each row to make x rows in GAM CSV for each user/group with each alias.so from
DisplayName PrimarySmtpAddress EmailAddresses
company_name_Technical_Architecture _Technical_Architecture@domain.com company_name_Technical_Architecture _Technical_Architecture _CTA_GRP CPN_Technical_Architecture
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsubscribe...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/dda1c0f5-4502-4b7f-a3c8-c63f65edb140%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--Kevin MelilloElectronic Communications AnalystInformation Technology445 Hoes LanePiscataway, NJ 08854Phone:732-465-6609 | Mobile: 732-609-4331E-mail: k.me...@ieee.org
--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsubscribe...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAKM%3DboZ6rtmUe0cK6yorzVEzH06g0i1w3OSrEg2zKvcnP1NRAQ%40mail.gmail.com.
--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-apps-manager@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/e47feab4-3054-40b3-aa20-9450511ed2ca%40googlegroups.com.
#!/usr/bin/env python
"""
# Purpose: Create a CSV file with columns: User, Alias; from EMC exported data with columns: DisplayName, PrimarySmtpAddress, EmailAddresses.
# For each alias email address in the space separated list "EmailAddresses", output a row with PrimarySmtpAddress in the User column and the alias email address in the Alias column.
# Usage:
# 1: Export EMC data to EMCData.csv
# 2: python GetEMCAliases.py EMCData.csv EMCAliases.csv
# 3: Inspect EMCAliases.csv to make sure that it is reasonable
# 4: Create the aliases in Gam
# $ gam csv EMCAliases.csv gam create alias "~Alias" user "~User"
"""
import csv
import sys
if (len(sys.argv) > 2) and (sys.argv[2] != '-'):
outputFile = open(sys.argv[2], 'wb')
else:
outputFile = sys.stdout
outputFile.write('User,Alias\n')
if (len(sys.argv) > 1) and (sys.argv[1] != '-'):
inputFile = open(sys.argv[1], 'rb')
else:
inputFile = sys.stdin
for row in csv.DictReader(inputFile):
for alias in row['EmailAddresses'].split():
outputFile.write('{0},{1}\n'.format(row['PrimarySmtpAddress'], alias))
inputFile.close()
outputFile.close()
To post to this group, send email to google-apps-manager@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/e47feab4-3054-40b3-aa20-9450511ed2ca%40googlegroups.com.
To post to this group, send email to google-apps-manager@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/e47feab4-3054-40b3-aa20-9450511ed2ca%40googlegroups.com.
--
You received this message because you are subscribed to a topic in the Google Groups "GAM for G Suite" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/OhHtWXl0s7E/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-apps-manager@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS-S2jRBh-VoZfXjGYM%2BrnXfZxYOaqzd7nvTSrF_5xZ0%3DQ%40mail.gmail.com.
You received this message because you are subscribed to a topic in the Google Groups "GAM for G Suite" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/OhHtWXl0s7E/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-apps-manager@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS8rHuMQ1yMUfNs90K-DfUrr_ZgQeZ8su7K%2BO%2BWLDghp4Q%40mail.gmail.com.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CANTrq9fU6JjKp0MENKZGGUvXj5oaVMb4A-n0Kv_y6WGO4xHM2w%40mail.gmail.com.
DisplayName PrimarySmtpAddress EmailAddresses
company_name_Technical_Architecture _Technical_A...@domain.com company_name_Technical_Architecture _Technical_Architecture _CTA_GRP CPN_Technical_Architecture
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/dda1c0f5-4502-4b7f-a3c8-c63f65edb140%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--Kevin MelilloElectronic Communications AnalystInformation Technology445 Hoes LanePiscataway, NJ 08854Phone:732-465-6609 | Mobile: 732-609-4331E-mail: k.me...@ieee.org
--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAKM%3DboZ6rtmUe0cK6yorzVEzH06g0i1w3OSrEg2zKvcnP1NRAQ%40mail.gmail.com.
--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/e47feab4-3054-40b3-aa20-9450511ed2ca%40googlegroups.com.
--
You received this message because you are subscribed to a topic in the Google Groups "GAM for G Suite" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/OhHtWXl0s7E/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS8rHuMQ1yMUfNs90K-DfUrr_ZgQeZ8su7K%2BO%2BWLDghp4Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
Good afternoon. GAM can be used to add aliases. The command for this is the following:gam create alias <alias> user <username>If you create a CSV file with the username and alias needed, then you can do a bulk add alias with GAM. You can format the file as follows:ALIAS_ADD.CSVuser,aliasuser_one,alia...@domain.comuser_one,alia...@domain.comuser_two,alias...@domain.comuser_three,alias...@domain.comYou can then use the following command to use the CSV for the batch update.gam csv ALIAS_ADD.CSV gam create alias ~alias user ~user
On Fri, Feb 10, 2017 at 1:51 PM, Mearaj Shaikh <mea...@shivaami.com> wrote:
Hi ,anybody can help me on how to add email alias in bulk via CSV or batch file
--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/dda1c0f5-4502-4b7f-a3c8-c63f65edb140%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.