Read IMD File from Python
Forums
Hi all,
I tried to access one my IMD files directly from Python using this code:
import pyodbc
import pandas as pd
# Define your connection string (this is a generic example and would need to be adjusted)
conn_str = (
"DRIVER={CaseWare IDEA Driver};"
"DSN=NSSO2018;"
"DBQ=D:/2018 database;"
)
# Establish the connection
conn = pyodbc.connect(conn_str)
but cannot make it work as i get:
Traceback (most recent call last)
Untitled-2 in line 12
6 conn_str = (
7 "DRIVER={CaseWare IDEA Driver};"
8 "DSN=NSSO2018;"
9 "DBQ=D:/2018 database;"
10 )
11 # Establish the connection
---> 13 conn = pyodbc.connect(conn_str)
OperationalError: ('08001', '[08001] [Simba][SimbaClient] (72) Missing required setting: SERVERLIST. (72) (SQLDriverConnect)'
DSN and Driver correctly installed as I can get access to file using Power Bi or Excel query.
Cannot access via Idea itself nor load in excel as it is too big even for a csv file.
Would you be so kind as to steer me in right direction?
Thanks
Hi Vitopiepoli,
Hi Vitopiepoli,
I have attached a jupyter notebook and a python script (both are the same) on how to use the IDEALib.py to import IDEA files to python and vice versa. I also put together a video on how to use it https://www.youtube.com/watch?v=4-vfJsZrE20
Are you trying to put an IDEA
Are you trying to put an IDEA imd file into a panda dataframe? It is possible, let me know the output and I will put something together to show you how to do this.