Switch First and Last name

204 views
Skip to first unread message

Јован Сандић

unread,
Sep 13, 2018, 6:20:57 AM9/13/18
to GAM for G Suite
I need to switch values for first and last name for all users, emails should remain the same as it is now. 

Switching is needed because we need to sort users by lastname (school practice...)  I could do that manually, but that is more than 2000 manual copy/paste... 

Is it possible to accomplish that with GAM?

Sam Woodhouse

unread,
Sep 13, 2018, 6:40:08 AM9/13/18
to GAM for G Suite
Something along the lines of the following should do what you need:

gam print users firstname lastname | gam csv - gam update user ~primaryEmail firstname ~name.familyName lastname ~name.givenName

This will update ALL accounts though, you might need to mess with some query in the print command to only do a subset of users.

Jay Lee

unread,
Sep 13, 2018, 6:42:46 AM9/13/18
to google-ap...@googlegroups.com
Instead of swapping name locations, you can just change one setting in the admin console:


Jay

--
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-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/e4ec426d-2f67-41e6-9caa-d051278f06f5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Јован Сандић

unread,
Sep 17, 2018, 12:41:50 PM9/17/18
to GAM for G Suite
This changes how name is written in Gmail inbox. It is useful, but I need to sort users by Lastname in Admin console/Users

Sorry, I was not accurate...


четвртак, 13. септембар 2018. 12.42.46 UTC+2, Jay Lee је написао/ла:
Instead of swapping name locations, you can just change one setting in the admin console:


Jay

On Thu, Sep 13, 2018, 6:20 AM Јован Сандић <jovan....@ekosmile.edu.rs> wrote:
I need to switch values for first and last name for all users, emails should remain the same as it is now. 

Switching is needed because we need to sort users by lastname (school practice...)  I could do that manually, but that is more than 2000 manual copy/paste... 

Is it possible to accomplish that with GAM?

--
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.

+KimNilsson

unread,
Sep 18, 2018, 3:51:31 AM9/18/18
to GAM for G Suite
Still don't see why this is necessary.
Any list you export from the system can be sorted by last name.
Any person you want to find in the console, can be searched by last name.

Why would anyone ever want to scroll through a list of users, instead of just searching for the one you are looking for?

Сандић, Јован

unread,
Sep 19, 2018, 6:13:29 AM9/19/18
to google-ap...@googlegroups.com
You are right that it is not necessary.  Everything you said is correct. 

If you ask me why, iI would answer that It will be easier (and maybe even faster) for us if we could sort users it directly in admin console/ users without download users, sorting,...

Each class has its own organization. There are up to 30 pupils per class.  Usually, if users are sorted by last name I will spend less time to find someone in the of 30 names then searching those name in 3000 users.  

Pupils names in paper grade books (official documents we use in school) are sorted by last name. Everything (comparing, reset passwords,...)  will be easier if we have the same order in papers and in the admin console. 

I would like to see Sot by LastName implemented as option in GAFE in future. That would be the only correct solution for our needs.

Tnx,



--
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.

For more options, visit https://groups.google.com/d/optout.



--

Jован Сандић, наставник Рачунарства и информатике
Средња школа "Светозар Милетић", Нови Сад

+KimNilsson

unread,
Sep 19, 2018, 7:34:49 AM9/19/18
to GAM for G Suite
Well, search only takes as long as typing the person's name in the search window.

No need to first click all the way to that specific class' OU and find the person in the visible list.

✉ Kevin Melillo

unread,
Sep 19, 2018, 8:18:27 AM9/19/18
to google-ap...@googlegroups.com
Quick comment here: You can also sort by email address at the top..  so if you were able to create the accounts as lastname.first_initial or something similar..  then you could sort by that, and find your users easier.  

On Wed, Sep 19, 2018 at 7:34 AM +KimNilsson <there.is.no...@gmail.com> wrote:
Well, search only takes as long as typing the person's name in the search window.

No need to first click all the way to that specific class' OU and find the person in the visible list.

--
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-man...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.


--
Kevin Melillo
Electronic Communications Analyst
Information Technology
445 Hoes Lane
Piscataway, NJ 08854

Phone:732-465-6609 | Mobile: 732-609-4331

Сандић, Јован

unread,
Sep 19, 2018, 10:37:33 AM9/19/18
to google-ap...@googlegroups.com
Thank you for your comment, 

Unfortunately our language is Cyrillic, and we are obligated to use pupils First name and Last name written in Serbian Cyrillic. 

For example My name  in Serbian is Јован Сандић, in latin it is Jovan Sandić so my email is created as following: jovan....@schoolname.edu.rs

Rules for sorting are different for Serbian Latin, English and Serbian Cyrillic, so we can't use emails for sorting :(

Regards, Jovan


2018-09-19 14:18 GMT+02:00 ✉ Kevin Melillo <k.me...@ieee.org>:
Quick comment here: You can also sort by email address at the top..  so if you were able to create the accounts as lastname.first_initial or something similar..  then you could sort by that, and find your users easier.  
On Wed, Sep 19, 2018 at 7:34 AM +KimNilsson <there.is.no.substitute@gmail.com> wrote:
Well, search only takes as long as typing the person's name in the search window.

No need to first click all the way to that specific class' OU and find the person in the visible list.

--
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.
--
Kevin Melillo
Electronic Communications Analyst
Information Technology

Phone:732-465-6609 | Mobile: 732-609-4331

--
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.

For more options, visit https://groups.google.com/d/optout.



--
Reply all
Reply to author
Forward
0 new messages