Traceback error

[Rhys Andrews]

Hi!
I've been using GAM for menial commands for a while now, but I've been working on an automated system for applying email signatures to staff.

I am using this command:

gam csv <path-to-csv> gam user ~Email signature file ~SigFile

The CSV looks like this:

Email,SigFile

rh...@domain.com,rhysSig.txt

b...@domain.com,bobSig.txt

The text files contain HTML code with personalised email signatures and are stored in the same directory as the CSV.

I had tested doing this individually without CSV (but with a text file), and it worked no problem.

But with the CSV file, I get:

Traceback (most recent call last):

  File "/Applications/GAM/gam.py", line 9159, in <module>

    for row in input_file:

  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/csv.py", line 107, in next

    self.fieldnames

  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/csv.py", line 90, in fieldnames

    self._fieldnames = self.reader.next()

_csv.Error: new-line character seen in unquoted field - do you need to open the file in universal-newline mode?

Hoping somebody can help!

Thanks

Rhys

[Jay Lee]

Error indicates a formatting issue with your CSV. Make sure all CSV lines have the proper number of columns.

Jay

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" 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/87c6067d-1302-450d-9191-21340efc66fd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Jay

[Rhys Andrews]

Hi Jay,

I've triple checked the CSV and it's such a simple CSV that I can't see how I have got it wrong.

With SigFile referencing filenames, which directory does GAM look for those files?

Rhys

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/87c6067d-1302-450d-9191-21340efc66fd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Jay

[Ross Scroggs]

Rhys,

Check this out: http://stackoverflow.com/questions/17315635/csv-new-line-character-seen-in-unquoted-field-error

Ross

--

ross.s...@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/22d58a25-2e6d-4962-9288-82fffb9c6172%40googlegroups.com.

[Rhys Andrews]

Thanks so much Ross.

This fixed the problem - I just opened the CSV in TextWrangler, copied & pasted it into a new text file, then saved that as CSV, so that Excel didn't have its dirty hands on it.

I also needed to change the file columns to the absolute terminal path... but it's working now!

Cheers,

Rhys

Ross

--

ross.s...@gmail.com