Import CSV via Script

This is something I thought would be extremely easy, yet I'm getting no where.

I've tried PartProgram.Import("C:\file\location.csv") as well as PartProgram.Import2("C:\file\location.csv", true)

PartProgram.Import("C:\file\location.step") works as it should for importing CAD.

What am I missing? I've going through the object library and there is no mention of importing a csv but the Import() and Import2() do mention importing another format into the measurement routine.

thanks in advance

vpt.se over 1 year ago

Import

This function imports CAD or part data from the indicated file to the measurement routine. The file format is determined by the file name extension of Name.

Import2

Imports from another format into the measurement routine. The parameter indicates if the input should be merged

It is not clear what Import2 is really importing. Is it measurement commands or something else...?

What are you trying to accomplish?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Brad Hughes over 1 year ago

Import2() will import a .dms file no problem.

I'm trying to import csv data without having to do it manually. There is a lot going on before and after in the script and everything works except this one part. If I can get it to work I simply type the part number in and it builds the entire program.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
vpt.se over 1 year ago

You could code the import yourself, I mean do the program "know" what to do with the CSV file automagically or what? If the CSV is used to populate variables for features in your program, you'd need to define what value goes where, no?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Brad Hughes over 1 year ago

I want it to import just like it does if I go File->Import->csv. The file works perfectly and generates the points just as expected when done manually. I just wants to be able to do it via a script.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
vpt.se over 1 year ago

Ping neil.challinor -> is this possible through scripting?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Neil Challinor over 1 year ago in reply to vpt.se

Import2 does the same thing as Import1 except that it allows additional control over whether to merge or replace existing CAD.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Neil Challinor over 1 year ago in reply to vpt.se

I just had one of the developers check and the Import / Import2 methods do not support .csv. I think that's because the csv import tool was probably added at some point after those automation methods were created and whichever developer added .csv neglected to add automation support. We could maybe consider adding it in a future version (2024.1 would be the earliest possible). Until then, you would have to add scripting to parse the csv file yourself and use the other available automation tools to populate the routine.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
SABarber over 1 year ago in reply to vpt.se

I've never tried this but maybe the script could send/post a command message (273, 1061) to perform what the File/Import does.
273 = WM_COMMAND
1016 = ID_FILE_IMPORT_CSV

Not sure how well pcmdis will do with this as I think part of the process also saves the current PRG which is running the script.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
SABarber over 1 year ago in reply to vpt.se

Never mind.....
I realize that would only bring up the dialog
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Brad Hughes over 1 year ago in reply to vpt.se

Thanks for the info, guys.

SABarber, any idea how I can get a handle on the window? I'll need that for Call SendMessage. I assume I can use FindWindow if I knew the class name and caption?

edit: just saw your last response. I'll just write a parser for the csv file. should be easy enough.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel