For the latest version of JMP Help, visit JMP.com/help.


JSL Syntax Reference > JSL Messages > PI Server Import Messages
Publication date: 07/24/2024

PI Server Import Messages

PI Server Messages

obj<<Authentication Method("none"|"kerberos"|"basic")

Description

Specifies the authentication method.

obj<<Importer(AF Path(Asset Framework path), <Series(string)>, <Start Time(PI time string)>, <End Time(PI time string)>, <UTC(boolean)>, <Boundary Type(string)>, <Max Count(integer)>, <Filter(string)>, <Retrieve Attribute Status(boolean)>, <Intervals(integer)>, <Sync Time(PI time string)>, <Sync Time Boundary Type(string)>, <Interval(duration in PI AFTimeSpan format)>, <Timeout(integer)>)

Description

Creates a new raw importer instance.

Example

Names Default To Here( 1 );
/* Import raw data with attribute status */
client = New PI Client(
	URL( "https://myserver.com/piwebapi" ),
	Authentication Method( "basic" ),
	Username( "myuserid" ),
	Password( "mypassword" )
);
importer = client << Importer(
	AF Path(				 /* Asset Framework paths */
		"\\myserver\PIData\Atlanta Data Center\Server Rack1\ION 6200 Power Meter1|I A",
		"\\myserver\PIData\Atlanta Data Center\Server Rack1\ION 6200 Power Meter1|I B",
		"\\myserver\PIData\Atlanta Data Center\Server Rack1\ION 6200 Power Meter1|I C"
	),
	Series( "raw" ),
	Start Time( "*-1d" ), /* PI time string */
	End Time( "*" ),      /* PI time string */
	UTC( 0 ), /* Whether specified start/end times are based on UTC - default is zero */
	Boundary Type( "inside" ), /* Choices are "inside", "outside", "interpolated" */
	Max Count( 5000 ), /* Max. number of values to fetch - default is 5000 */
	Filter( "" ), /* Optional filter */
	Retrieve Attribute Status( 1 ), /* retrieve attribute status for each imported column, into corresponding columns "I A status", "I B status", and "I C status" */
	Timeout( 120 ) /* add extra time for the server to respond */
);
importer << Run;

obj<<Modify

Description

Invokes the import window, using the provided parameters as a starting point, to create an interactive session where new tables can be imported.

obj<<Password(text)

Description

Only used when authentication method is "basic".

obj<<Run

Description

Runs the importer to create the table.

obj<<URL(text)

Description

URL of the PI server REST API endpoint.

obj<<Username(text)

Description

Required when authentication method is "basic".

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).