Re: [GAM] Update users by CSV file without change password

[Eduardo Fernandez]

Hi Ross,

I already changed my CSV file to UTF-8. I got this message:

I don't know what happened.

On Tue, Nov 15, 2022 at 4:07 PM Ross Scroggs <ross.s...@gmail.com> wrote:

Eduardo,

Your CSV file is not UTF-8, add this after UpdateUsers.csv: charset latin1

Ross

On Tue, Nov 15, 2022 at 1:55 PM 'Eduardo Fernandez' via GAM for Google Workspace <google-ap...@googlegroups.com> wrote:

It is done. However I still have this message:

On Tue, Nov 15, 2022 at 3:49 PM Ross Scroggs <ross.s...@gmail.com> wrote:

Eduardo,

You do have a whitespace after the word manager in the header row.

The error message shows it:

ERROR: Header "manager" not found in CSV headers of "primaryemail,jobtitle,manager ,department".

There is a space after the word manager; edit your CSV file and delete the space.

Ross

On Tue, Nov 15, 2022 at 1:42 PM 'Eduardo Fernandez' via GAM for Google Workspace <google-ap...@googlegroups.com> wrote:

Hi Chad,

Thanks for your reply. I already checked my csv file. I don't have whitespaces. I got the same error message. There are 456 accounts . Is that the issue maybe?

Thanks

On Tue, Nov 15, 2022 at 2:54 PM Chad Frerichs <chadfr...@amplifiedit.com> wrote:

Your first command was correct, but the header in your CSV has whitespace before or after the word manager.

Chad Frerichs

On Tuesday, November 15, 2022 at 1:42:05 PM UTC-6 eduardo....@jokr.it wrote:

Got this: 

Thanks Ross!

On Tue, Nov 15, 2022 at 1:28 PM Ross Scroggs <ross.s...@gmail.com> wrote:

You have a space after the word manager in the header row; delete it.

Ross

On Tue, Nov 15, 2022 at 11:25 AM 'Eduardo Fernandez' via GAM for Google Workspace <google-ap...@googlegroups.com> wrote:

Hi Ross,

Thanks for your help. I already have my CSV with these fields : primaryEmail,department,jobtitle,manager

I ran the command and got this message:

Any ideas?

Best!

On Tue, Nov 15, 2022 at 12:28 PM Ross Scroggs <ross.s...@gmail.com> wrote:

Eduardo,

By role do you mean jobtitle? If so you could do this.

Make a CSV file UpdateUsers.csv

primaryEmail,department,jobtitle,manager

gam csv UpdateUsers.csv gam update user "~primaryEmail" relation manager "~manager" organization title "~jobtitle" department "~department" primary

Ross

On Tue, Nov 15, 2022 at 7:46 AM 'Eduardo Fernandez' via GAM for Google Workspace <google-ap...@googlegroups.com> wrote:

Hello guys,

I´m trying to add information in every user as: Role, manager email and department with a CSV file. I don't want to change the passwords of my accounts . Is there a way to do this ? password field is mandatory in the CSV file.

Thanks

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/59ce616f-b055-4f8a-baee-971bd5c39830n%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com

--
You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/585Qjy-XFqE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS_R1sLQRTLWxbpzXTb8j-NLQqhornXtT60CgyvXeAOLQQ%40mail.gmail.com.

--

Eduardo Fernández Global Systems Administrator eduardo....@jokr.it GMT - 5 jokr.com

INFORMACION CONFIDENCIAL: Este mensaje (incluyendo adjuntos) es confidencial.

CONFIDENTIALITY NOTICE: This message (including any attachments) is confidential.

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAPcGyDLMjWWMTU1dfX1eXH7FHuDqpGnD90kMrnkyX8Ac1GK_4w%40mail.gmail.com.

--

Ross Scroggs

ross.s...@gmail.com

--
You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/585Qjy-XFqE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS8Ok1WTkM7Lb%3DOmJpP2Ax1cQpksGT00sYx6cLb%3DF_4oAg%40mail.gmail.com.

--

Eduardo Fernández Global Systems Administrator eduardo....@jokr.it GMT - 5 jokr.com

INFORMACION CONFIDENCIAL: Este mensaje (incluyendo adjuntos) es confidencial.

CONFIDENTIALITY NOTICE: This message (including any attachments) is confidential.

--
You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/585Qjy-XFqE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/763503d9-475a-456d-aee0-daf5fb8f0591n%40googlegroups.com.

--

Eduardo Fernández Global Systems Administrator eduardo....@jokr.it GMT - 5 jokr.com

INFORMACION CONFIDENCIAL: Este mensaje (incluyendo adjuntos) es confidencial.

CONFIDENTIALITY NOTICE: This message (including any attachments) is confidential.

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAPcGyDKLQG5H7jePCS7%2B4Bac3F0jELmQ_q8PRb%2BUGj-MmvnvVA%40mail.gmail.com.

--

Ross Scroggs

ross.s...@gmail.com

--
You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/585Qjy-XFqE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS8OOtq8wLbXx%3De5dSo%3DAior8nm%3DObTJvt0y_ig8_8D5Qw%40mail.gmail.com.

--

Eduardo Fernández Global Systems Administrator eduardo....@jokr.it GMT - 5 jokr.com

INFORMACION CONFIDENCIAL: Este mensaje (incluyendo adjuntos) es confidencial.

CONFIDENTIALITY NOTICE: This message (including any attachments) is confidential.

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAPcGyDJF-76cP-8%2BrwXq4sSHSNbWxu%3Dfx3XwzmjAegjbk_6ubA%40mail.gmail.com.

--

Ross Scroggs

ross.s...@gmail.com

--
You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/585Qjy-XFqE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS99VPiF0wvo7dqs2MYanEbKJyVpYFirzRY0tmrKf74dcw%40mail.gmail.com.

--

Eduardo Fernández Global Systems Administrator eduardo....@jokr.it GMT - 5 jokr.com

INFORMACION CONFIDENCIAL: Este mensaje (incluyendo adjuntos) es confidencial.

CONFIDENTIALITY NOTICE: This message (including any attachments) is confidential.

[Sergio Alvarez]

Hi Eduardo, 

The error states that the file was not found, what you can do is specify the location of the file by using this:

gam csv C:\Gam\Enterprise.csv blah blah blah 

You want to be careful with your name, it is case-sensitive so, if the file has caps, you do need to match it 100%

[Maj Marshall Giguere]

Gam is saying it can't locate your CSV file.  Try: csv ./UpdateUsers.csv, or the full path to the CSV file, and definitely check the spelling of the filename, case matters.

Maj Marshall E Giguere
NH Wing Director of IT
Civil Air Patrol, U.S. Air Force Auxiliary
GoCivilAirPatrol.com
nhwg.cap.gov
Volunteers serving America's communities, saving lives, and shaping futures.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAPcGyDLYX%3DtMsovz2knZ%2B7xc-uELDUJrJh9Ay_Lk4acWH3sO0g%40mail.gmail.com.