Encoding failure when importing csv in shotgun

ShotGrid
1

When importing my csv to shotgun I have a text field. If in this test field there are certain letters or symbols such as “ñ” shotgun does not read it correctly and displays it incorrectly. Is there any way I can encode the csv or get shotgun to read it correctly.

Thanks in advance

2

I’d probably look at some way to pre-process the csv before uploading it.

If you can save it from your sheets application with CSV UTF-8 encoding it might work?

Alternatively you could do it with some python code like the example below. (Untested so run at your own risk and uses the unidecode lib that will need to be pip installed)

import csv
from unidecode import unidecode

input_file = 'input.csv'  # Path to your input CSV file
output_file = 'output.csv'  # Path to save the modified CSV file

with open(input_file, 'r', encoding='utf-8') as file_in, open(output_file, 'w', encoding='utf-8', newline='') as file_out:
    reader = csv.reader(file_in)
    writer = csv.writer(file_out)
    
    for row in reader:
        modified_row = [unidecode(cell) for cell in row]
        writer.writerow(modified_row)

Cheers
Justin

1 Like
3

Hi Justin,

Thanks for the answer. The thing is that we are already uploading to shotgun a UTF-8 encoded CSV. But we don’t know why shotgun doesn’t process good that letters. Sorry if i didn’t explain it properly before :sweat_smile: :sweat_smile:

Thanks again!