cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
BenBaecker
Level I

MFI from a selectable location

Hi, I'm quite new to the JSL world, or coding in general. With a few simple scripts I would like to spare some recurring work. As in this case, I would like to automate the MFI. To do this, I copied the script below from the MFI dialog and expanded it to include the "Pick Directory" command. My only problem is that the "Select a directory" dialog appears twice every time. After I have selected the storage location 2x, the rest of the script and also the following commands after the MFI works without problems.

 

Multiple File Import(
	<<Set Folder( Pick Directory( "Select a directory.", "$Desktop" ) ),
	<<Set Subfolders( 0 ),
	<<Set Name Filter( "*.meas9206;" ),
	<<Set Name Enable( 1 ),
	<<Set Size Enable( 0 ),
	<<Set Date Enable( 0 ),
	<<Set Add File Name Column( 1 ),
	<<Set Add File Size Column( 0 ),
	<<Set Add File Date Column( 0 ),
	<<Set Import Mode( "CSVData" ),
	<<Set Charset( "Vermutete Codierung" ),
	<<Set Stack Mode( "Stack Similar" ),
	<<Set CSV Has Headers( 0 ),
	<<Set CSV Allow Numeric( 1 ),
	<<Set CSV First Header Line( 1 ),
	<<Set CSV Number Of Header Lines( 1 ),
	<<Set CSV First Data Line( 25 ),
	<<Set CSV EOF Other( ";" ), 

) << Import Data;

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: MFI from a selectable location

It might be enough if you move Pick Directory() outside << Set Folder

Names Default To Here(1);

sel_dir = Pick Directory("Select a directory.", "$Desktop");
Multiple File Import(
	<<Set Folder(sel_dir),
	<<Set Subfolders(0),
	<<Set Name Filter("*.meas9206;"),
	<<Set Name Enable(1),
	<<Set Size Enable(0),
	<<Set Date Enable(0),
	<<Set Add File Name Column(1),
	<<Set Add File Size Column(0),
	<<Set Add File Date Column(0),
	<<Set Import Mode("CSVData"),
	<<Set Charset("Vermutete Codierung"),
	<<Set Stack Mode("Stack Similar"),
	<<Set CSV Has Headers(0),
	<<Set CSV Allow Numeric(1),
	<<Set CSV First Header Line(1),
	<<Set CSV Number Of Header Lines(1),
	<<Set CSV First Data Line(25),
	<<Set CSV EOF Other(";"), 

) << Import Data;
-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

Re: MFI from a selectable location

It might be enough if you move Pick Directory() outside << Set Folder

Names Default To Here(1);

sel_dir = Pick Directory("Select a directory.", "$Desktop");
Multiple File Import(
	<<Set Folder(sel_dir),
	<<Set Subfolders(0),
	<<Set Name Filter("*.meas9206;"),
	<<Set Name Enable(1),
	<<Set Size Enable(0),
	<<Set Date Enable(0),
	<<Set Add File Name Column(1),
	<<Set Add File Size Column(0),
	<<Set Add File Date Column(0),
	<<Set Import Mode("CSVData"),
	<<Set Charset("Vermutete Codierung"),
	<<Set Stack Mode("Stack Similar"),
	<<Set CSV Has Headers(0),
	<<Set CSV Allow Numeric(1),
	<<Set CSV First Header Line(1),
	<<Set CSV Number Of Header Lines(1),
	<<Set CSV First Data Line(25),
	<<Set CSV EOF Other(";"), 

) << Import Data;
-Jarmo
BenBaecker
Level I

Re: MFI from a selectable location

Thanks. i its works for me. I tried some similiar, with "dir" instead of "sel_dir, but that doesent worked well. Maybe i had Synthax Failure.

Recommended Articles