Just found out about ChromeLook today, looks like an awesome tool. I have had some trouble getting data imported into the program though. I have GAM-ADV-XTD3 installed (version 7.01.03 the latest).
I'll run the command listed within the program "gam config csv_output_column_delimiter "\t" print cros fields activetimeranges,annotatedassetid,annotatedlocation,annotateduser,bootmode,deviceid,ethernetmacaddress,firmwareversion,lastenrollmenttime,lastsync,macaddress,model,notes,ordernumber,orgunitpath,osversion,platformversion,recentusers,serialnumber,status > cros.txt" which generates me a large txt file (275MB for about 12000 devices) that appears to be tab delimited properly.
Then I'll go and import that txt file within ChromeLook, it'll stay on "Cleaning CROS data" for about 700s then continues on with nothing at all imported. I've checked the "Skipped Log" under edit, and that's empty as well.
Any ideas what I'm doing wrong? Look forward to hearing back from you.
EDIT: Figured this out. What I ended up doing was copying and pasting the information from the exported text file into a new text file. Then it imported fine. I opened each of these up side by side in Notepad++ and noticed that GAM exported the text file in UTF-16 encoding. I changed this to UTF-8 and then the original file imported. I believe this has to do with me running GAM within a PowerShell window.
Anyways, thank you very much for the awesome tool! Look forward to using it.
I need to study up working with different encodings for this. At our district, we have a Task Scheduler task launch a batch script (.cmd) every hour to get fresh data, so I'm always getting UTF-8.
Hey Bill,
Just found out about ChromeLook today, looks like an awesome tool. I have had some trouble getting data imported into the program though. I have GAM-ADV-XTD3 installed (version 7.01.03 the latest).
I'll run the command listed within the program "gam config csv_output_column_delimiter "\t" print cros fields activetimeranges,annotatedassetid,annotatedlocation,annotateduser,bootmode,deviceid,ethernetmacaddress,firmwareversion,lastenrollmenttime,lastsync,macaddress,model,notes,ordernumber,orgunitpath,osversion,platformversion,recentusers,serialnumber,status > cros.txt" which generates me a large txt file (275MB for about 12000 devices) that appears to be tab delimited properly.
Then I'll go and import that txt file within ChromeLook, it'll stay on "Cleaning CROS data" for about 700s then continues on with nothing at all imported. I've checked the "Skipped Log" under edit, and that's empty as well.
Any ideas what I'm doing wrong? Look forward to hearing back from you.
EDIT: Figured this out. What I ended up doing was copying and pasting the information from the exported text file into a new text file. Then it imported fine. I opened each of these up side by side in Notepad++ and noticed that GAM exported the text file in UTF-16 encoding. I changed this to UTF-8 and then the original file imported. I believe this has to do with me running GAM within a PowerShell window.
Anyways, thank you very much for the awesome tool! Look forward to using it.
Thanks!
Jim
Thanks for sharing that fix Jim!
I need to study up working with different encodings for this. At our district, we have a Task Scheduler task launch a batch script (.cmd) every hour to get fresh data, so I'm always getting UTF-8.
No problem Bill, thanks for taking your time to make this program! Have a great holiday season.