cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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