CSV File not found

[SeanBassett]

I am using Python in Blender.
my code can not find the CSV file.
The file is in the same folder as the blender file and this did work when I was using blender Game Render.
But now I need it to work in Blender Render.

When I check the error it has added two folders to the actual path.

Traceback (most recent call last):
File "C:\Users\Owner\Desktop\Blender\Probot 2\ProbotPositions.blend\Untitled", line 12, in <module>
FileNotFoundError: [Errno 2] No such file or directory: 'Program.txt'

The actual location is "C:\Users\Owner\Desktop\Blender\Probot 2"

My code,

import csv

line = 1
column = 2
 
with open('Program.txt', "r") as file:
    mycsv = csv.reader(file)
    mycsv = list(mycsv)
    text = mycsv[line][column]
    print(text)
    rotate=int(text)

How do I point to the CSV File?

Thank you for any help

[wavic]

with open('/path/Program.txt', 'r') as in_file: # Python will handle / acording to the operating system
    # do something

[SeanBassett]

Thanks, but did not work

Traceback (most recent call last):
File "C:\Users\Owner\Desktop\Blender\Probot 2\ProbotPositions.blend\Untitled", line 11, in <module>
FileNotFoundError: [Errno 2] No such file or directory: '/path/Program.txt'

[wavic]

Replace 'path' with directory path to the file.

[SeanBassett]

Same error

location: <unknown location>:-1
Error: File "C:\Users\Owner\Desktop\Blender\Probot 2\ProbotPositions.blend\Untitled", line 17
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape

location: <unknown location>:-1

[Gribouillis]

Error: File "C:\Users\Owner\Desktop\Blender\Probot 2\ProbotPositions.blend\Untitled", line 17

Use a raw string with a leading r

r"C:\Users\Owner\Desktop\Blender\Probot 2\ProbotPositions.blend\Untitled"

Alternatively, use pathlib

from pathlib import Path
p = Path('C:')/'Users'/'Owner'/'Desktop'/'Blender'/'Probot'/'ProbotPositions.blend'/'Untitled'
print(str(p))

[SeanBassett]

Thank you for you advice but it still does not work.

from pathlib import Path
p = Path('C:')/'Users'/'Owner'/'Desktop'/'Blender'/'Probot 2'
print(str(p))
import csv

line = 1
column = 2
 
with open('Program.txt', "r") as file:
    mycsv = csv.reader(file)
    mycsv = list(mycsv)
    text = mycsv[line][column]
    print(text)
    rotate=int(text)

Error message

49.5
C:Users\Owner\Desktop\Blender\Probot 2
Traceback (most recent call last):
File "C:\Users\Owner\Desktop\Blender\Probot 2\ProbotPositions.blend\Untitled", line 21, in <module>
FileNotFoundError: [Errno 2] No such file or directory: 'Program.txt'
Error: Python script fail, look in the console for now...

[micseydel]

You define, but don't use, p. You need to incorporate it into the open call.

[SeanBassett]

Sorry but where do I add the p?

[Gribouillis]

Sorry but where do I add the p?

If your program is at position C:\ham\spam\eggs\program.txt in the file system, you can write

p = Path('C:')/'ham'/'spam'/'eggs'/'program.txt'
with p.open('r') as file:
    mycsv = csv.reader(file)
    etc