RobotFramework :CSV Library : Error while writing into CSV

Question

I am using Robotframework and CSVLibrary to write randomly generated strings. Error while writing into CSV . The following is the code,

${datalist}   CREATE LIST
${list}=        getmandatory              test.xml     testInfo
        : FOR    ${a}    IN  @{list}
                \   ${random}=    String.Generate Random String     ${a.maxlength}      [UPPER]${a.format}
                \   append to list    ${datalist}      ${random}
        log to console   ${datalist}
        append to csv file      data.csv     ${datalist}

The getmandatory is a python pgm wshich returns me a list of all mandatory fields in a given xml. The list values are randomly generated strings , ['BDSVRtZEISBGItUtUMYHBULtUEZQTtDOCBFUGJAPWHXtIeYKTUAWOLSPFBXQCDWLtTIPtOJFTBXSUAYMMNtPRRFMQZGXKBUAtIFD', 'DHeSR']

I am getting an error ,

TypeError: a bytes-like object is required, not 'str'

I am not sure what I am doing wrong here . Please help !

Please don't post a link to a picture of code. Take the time to copy, paste, and format the code in your question. — Bryan Oakley
– Bryan Oakley, Commented Apr 15, 2018 at 1:17
Which line is the error occurring? I usually prefer to write Robot keywords just as high level sentences in English, and leaving fors for Python code — Henrique Jung
– Henrique Jung, Commented Apr 15, 2018 at 19:14

Eddy Pronk · Accepted Answer · 2018-04-16 13:30:12Z

2

I could reproduce the issue with CSVLibrary and python3.

In CSVLibrary/init.py you'll find the following function.

@staticmethod
def _open_csv_file_for_write(filename, data, csv_writer=csv.writer, **kwargs):
    with open(filename, 'ab') as csv_handler:
        writer = csv_writer(csv_handler, **kwargs)

Change this to: ('a' instead of 'ab')

@staticmethod
def _open_csv_file_for_write(filename, data, csv_writer=csv.writer, **kwargs):
    with open(filename, 'a') as csv_handler:
        writer = csv_writer(csv_handler, **kwargs)

In Python 3 unicode strings are the default and you can't write them in binary mode.

See TypeError: a bytes-like object is required, not 'str' in python and CSV

edited Apr 16, 2018 at 13:30

answered Apr 16, 2018 at 12:50

Eddy Pronk

6,6645 gold badges37 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mac Over a year ago

I did the change as suggested and the data got appended to the csv file. Thank you so much.

mac Over a year ago

The problem right now is, each character in a list value is getting written in to each column. G|O|D| instead of GOD in one single column

Collectives™ on Stack Overflow

RobotFramework :CSV Library : Error while writing into CSV

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related