At work, I've written some Python scripts to pull a bunch of data from our database, save it as a CSV, open it in JMP, and run a JSL script on it to create some graphs and other junk. The problem I'm running into is that I cannot find a way to get the full path to the CSV file within the JSL script. The Python script creates the directory, moves the CSV into it, and then opens the CSV in JMP and immediately runs the JSL script on it. In th Python script, this looks something like: os.chdir(sJMPLoc) // move to the JMP install dir subprocess.Popen(sCmdOpen) // execute the command to open the CSV file in JMP subprocess.Popen(sCmdScript) // execute the command to run the JSL script In the JSL: dt = Current Data Table(); dt << Save(); This didn't appear to work, so I started digging to see where it thought the file was stored and added this to my script: dir = dt << getpath; show(dir); Results of that: dir = "POWER_CORRELATIONS_YESTERDAY_09_08_15__15_36_57.jmp"; Turns out JMP is converting the .CSV into a .JMP file and storing it in some temp directory, or at least the dt << getpath function isn't aware of the original path. How can I get the path to the CSV where the CSV was when it was opened? Thanks, Chip
... View more