Scripting - Revision history

WikiSysopdi at 12:21, 21 October 2022

2022-10-21T12:21:11Z

← Older revision		Revision as of 12:21, 21 October 2022
Line 22:		Line 22:

	push arcuslist</blockquote>dcdc		push arcuslist</blockquote>dcdc
	~~USERNAME = Data Islands acocunt username~~

	USERNAME = Data Islands acocunt username		USERNAME = Data Islands acocunt username

WikiSysopdi at 13:41, 3 August 2022

2022-08-03T13:41:05Z

← Older revision		Revision as of 13:41, 3 August 2022
Line 21:		Line 21:
	querydb "SELECT NAMECUST,NAMECTAC,TEXTPHON1,TEXTPHON2,EMAIL1,EMAIL2 FROM ARCUS WHERE PRICLIST='WHS'"		querydb "SELECT NAMECUST,NAMECTAC,TEXTPHON1,TEXTPHON2,EMAIL1,EMAIL2 FROM ARCUS WHERE PRICLIST='WHS'"

	push arcuslist</blockquote>		push arcuslist</blockquote>dcdc
			USERNAME = Data Islands acocunt username

	~~dcdc~~
	USERNAME = Data Islands acocunt username		USERNAME = Data Islands acocunt username

WikiSysopdi at 13:48, 10 December 2021

2021-12-10T13:48:15Z

← Older revision		Revision as of 13:48, 10 December 2021
Line 56:		Line 56:
	EG		EG

	TSDataIslands.exe "demopush.tsd"		TSDataIslands.exe "c:\myscripts\demopush.tsd"

89.101.25.209 at 13:41, 10 December 2021

2021-12-10T13:41:08Z

← Older revision		Revision as of 13:41, 10 December 2021
Line 23:		Line 23:
	push arcuslist</blockquote>		push arcuslist</blockquote>

			dcdc
	USERNAME = Data Islands acocunt username		USERNAME = Data Islands acocunt username

89.101.25.209 at 13:38, 10 December 2021

2021-12-10T13:38:02Z

← Older revision		Revision as of 13:38, 10 December 2021
Line 35:		Line 35:


	This creates the region "Sage300Marketing" and an island "arcuslist" with the data from the querydb SQL.
			This creates the region "Sage300Marketing" (or switches to it if it already exists) and an island "arcuslist" (we delete this and recreate in fact) with the data from the querydb SQL.

	This is hosted on the Data Islands cloud.		This is hosted on the Data Islands cloud.

WikiSysopdi at 13:36, 10 December 2021

2021-12-10T13:36:15Z

@@ Line 37: / Line 37: @@
 This creates the region "Sage300Marketing" and an island "arcuslist" with the data from the querydb SQL.
 This is hosted on the Data Islands cloud.
 Using windows taskmanager you can run the dataislands app and pass in the "demopush.tsd" as a parameter. The app will then run the script.

WikiSysopdi: initial write

2021-12-10T13:21:44Z

initial write

New page

To automate Data Islands flows you can write a script and run this

First we will create a PUSH script.

Here is an example that connects and queries a Sage 300 ERP databse on MSSQL server.

The scenario here is one where you want some customer data (from table ARCUS) to provide to a sales rep. You only want to provide contact information and exclude financial information.

Open notepad and copy the contents below into it (replacing the items in CAPS with your credentials) and save as "demopush.tsd"

<blockquote>connect USERNAME PASSWORD

addserver sql SERVERNAME SQLUSER SQLPASSWORD

usedb saminc

addregion Sage300Marketing

deleteisland arcuslist

querydb "SELECT NAMECUST,NAMECTAC,TEXTPHON1,TEXTPHON2,EMAIL1,EMAIL2 FROM ARCUS WHERE PRICLIST='WHS'"

push arcuslist</blockquote>

USERNAME = Data Islands acocunt username

PASSWORD = Data Islands acocunt password

SERVERNAME = Your SQL server name

SQLUSER = Your SQL server user

SQLPASSWORD= Your SQL server password

This creates the region "Sage300Marketing" and an island "arcuslist" with the data from the querydb SQL.

This is hosted on the Data Islands cloud.

Using windows taskmanager you can run the dataislands app and pass in the "demopush.tsd" as a parameter. The app will then run the script.