cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

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

Encrypted Multiple File Import with XML Settings Troubles (JMP 18)

XML Settings and Encryption don't seem to work well together. I repeatedly get the error: 
"The XML Settings must begin with XMLSettings(...). Multiple File Import stopped.
JSL Encrypted"

Guessing Tall would work except there's metadata I need from a different section in the XML document

Is there any way to get around this error? I am not sure why it cannot pull the XML settings when encrypted, but unencrypted is fine. Any help would be appreciated.

1 REPLY 1
DaveB
Staff

Re: Encrypted Multiple File Import with XML Settings Troubles (JMP 18)

That is a bug that we will look into fixing.  A possible work around is it to turn the multiple file import statement into a string and then parse and eval it.  For example, try encrypting this script and then running it.

eval(parse(jslquote(Multiple File Import(
	<<Set Folder( "$sample_import_data" ),
	<<Set Name Filter( "book.xml; " ),
	<<Set Name Enable( 1 ),
	<<Set XML Method( "XML Settings" ),
	<<Set XML Settings(
		XML Settings(
			Stack( 0 ),
			Row( "/book/story/chapter/para" ),
			Col(
				"/book/story/chapter/para",
				Column Name( "story.chapter.para" ),
				Fill( "Use Once" ),
				Type( "Numeric" ),
				Format( {"Best"} ),
				Modeling Type( "Continuous" )
			),
			Col(
				"/book/story/chapter/para/price",
				Column Name( "story.chapter.para.price" ),
				Fill( "Use Once" ),
				Type( "Numeric" ),
				Format( {"Best"} ),
				Modeling Type( "Continuous" )
			),
			Col(
				"/book/story/chapter/para/quantity",
				Column Name( "story.chapter.para.quantity" ),
				Fill( "Use Once" ),
				Type( "Numeric" ),
				Format( {"Best"} ),
				Modeling Type( "Continuous" )
			)
		)
	)
) << Import Data;)));

Recommended Articles