Versions Compared

Version Old Version 30 New Version 31
Changes made by

Denise McGettigan

Denise McGettigan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
maxLevel3

Info
iconfalse
titleRelated articles
Specifying parameters that can be used in SQL queries, connection strings and file paths allows you to use a single Sync file for multiple 'organisations' in Phocas. These

When you are adding a file, directory or SQL data item to Sync, you can specify parameters to use the Sync file for multiple organizations in Phocas. The parameters are passed to Sync

, with the result that the

and as a result, the information structure is sent to other

organisations

organizations. 

The following data item types reference parameters:

  • SQL
  • File
  • Directory.

Defining parameters

Select

  1. In Sync, select the Parameters tab

in Sync

  1. .

Select Add button to create a new parameter

  1. Click Add.

  2. Enter the parameter name

and a value into the table, noting that:

  1. . Parameter names are alphanumeric only. Special characters

can not

  1. cannot be used.

  2. Enter a value. Values can not contain parameters.

  1. Double quotes

can not

  1. cannot be used

in values

  1. .

 Image Removed
  1. Image Added

Using parameters as values in supported types

Example of use: Connection

string 

string 

Image Removed
Image Added

Example of use: SQL

Image Removed
Image Added

Parameter substitution in scheduled Syncs

You can substitute different values for defined

parameter

parameters via scheduled Syncs (SyncCLI).

To substitute a parameter value, the “-p” switch is used, followed by the parameter name and quoted value. The quoted value is only used for the duration of the session, i.e. the original value defined in Sync remains unchanged.

-p:parameterName “newValue”

-p:server ”localhost“

*

Note if a parameter name contains spaces, it must also be quoted:

“-p:My Server” “localhost”

“-p:Test Database” “Testing”

Examples-

Example format for

substituted

substituted parameters:

-p:server: “DatabaseServer“

-p:database "Sales2016"

-"p:db table" "Sales Customers"

-p:columns "ID, Address"

Multiple parameters

You can substitute

a number of

several parameters for a range of data items.

Example

Image Removed
Image Added

These multiple parameters can be entered in the Arguments field in a scheduled task:

Code Block
themeMidnight
-r "c:\temp\new sync\multipleparameters.sync" -user "John User" -password "myPassword" -service "http://company.example.com" -source "Sales" -p:server "DatabaseServer" -p:database "Sales2016" "-p:db table" "Sales Customers" -p:columns "ID, Address" "-p:sales directory" "C:\temp\Sales" -p:filePath "C:\temp\Customers.txt"

On this page

Table of Contents
maxLevel3