The topic you requested could not be found.
Related topics are listed below.

SharePoint PnP Provisioning

PowerShell Documentation » SharePoint PnP Provisioning

Site/List/Library provisioning made easy! - With optional immediate file & data upload. Effectively enabling you to do all the steps involved in provisioning of complete SharePoint Sites or individual Lists/Libraries and transfer files/data without complex and…

SharePoint PnP PowerShell Resources

PowerShell Documentation » SharePoint PnP PowerShell Resources

Requirements PowerShell ExecutionPolicy set to Unrestricted and the PnP cmdlets installed Start ISE or PowerShell.exe as administrator and run the following Commands. Set-ExecutionPolicy -ExecutionPolicy Unrestricted Install-Module SharePointPnPPowerShellOnline *…

PowerShell Documentation

PowerShell Documentation

Call PowerShell from within Fusion

Fusion PowerShell Commands

PowerShell Documentation » Run PowerShell from Fusion » Fusion PowerShell Commands

PowerShell cmdlets Description Get-xParameter Read the value from a Fusion Parameter INTO a PowerShell variable. Set-xParameter Assign a Fusion Parameter the value FROM a PowerShell variable. Add-xJobLog Add a…

PowerShell Code Snippets

PowerShell Documentation » Run PowerShell from Fusion » Fusion PowerShell Commands » PowerShell Code Snippets

Get Site Title and write it to the Fusion Job Log $web = Get-PnPWeb Add-xJobLog -LogType "Information" -Message $web.Title Add-xJobLog -LogType "Information" -Message "Take a break :-)" Start-Sleep -Seconds 10 Add-xJobLog -LogType "Information" -Message…

Run PowerShell from Fusion

PowerShell Documentation » Run PowerShell from Fusion

Run PowerShell from Fusion Collection Component The PowerShell Script execution is handled from the Collection Component. From here script can run BEFORE and AFTER the referenced Components (if any), are executed. Special PowerShell commands are available to…

External automation from PowerShell

Use Cases » External automation from PowerShell

Automation Components can be dynamically invoked fro PowerShell. You have the option to use PowerShell to create advanced logic and let Fusion handle the bulk work of fast file an data replication. From PowerShell you can invoke saved components. Parameters like…

Changelog

Roadmap » Changelog

Download Fusion 11.85 Generally Available here.. Module Type Version 11.85 May 6, 2021 SharePoint Enhancement Connection: When updating password for at user then the password is updated for all connections having the same…

Sync for Clients & Employees

Miscellaneous » Citrix ShareFile and Fusion » Sync for Clients & Employees

“Sync Window” pops up when you click on the Fusion System tray Icon.

Check for Updates/New version

FAQ & How to » Check for Updates/New version

Fusion will automatically check for updates every 2 weeks. You can manually do it this way:

For Each Row – Run Component

Component reference » Data Transport » For Each Row – Run Component

This Data Transport Target, forms a “For Each” loop around the data set retrieved, and executes a linked Component. The column values for each row are represented as parameters and can be assigned directly to target columns in the linked component and…

Considerations for using Web Login

Fusion Control Panel » Considerations for using Web Login

When using the Web Login Fusion retrieves the connection to SharePoint from your browser session. Advantages: Simple and secure and the only choice for users configured for MFA and not having access to an AppId Support for Multi Factor Authentication (MFA) Support…

For security reasons DTD is prohibited in this XML document

For security reasons DTD is prohibited in this XML document

Network issue when connecting to SharePoint Online. Error; For security reasons DTD is prohibited in this XML document. To enable DTD processing set the DtdProcessing property on XmlReaderSettings to Parse and pass the settings into XmlReader.Create method. The…

Whats new

Roadmap » Whats new

Download Fusion 11.85 Generally Available here.. Module Type Version 11.85 May 6, 2021 SharePoint Enhancement Connection: When updating password for at user then the password is updated for all connections having the same…

Use Cases

Use Cases

ProductLogo SAVE TIME – GET DATA & FILES MOVING! With Fusion you can significantly reduce the economic investment as well as risk and complexity of PowerShell development for SharePoint. Less or no Programming. Faster results for all your SharePoint…

Business Logic and Application examples

Business Logic and Application examples

Data Driven Automation – No Coding required. FileShares and SharePoint Document Libraries (Interactive, Scheduled or Test-Run) FileShare migration/replication to SharePoint at high speed. Incremental/full. Folders 1:1 or flattening…

Data Driven Automation Enviroment

Use Cases » Data Driven Automation Enviroment

Allows you to automatically run tasks multiple times with different input data/parameters. (Data Driven Automation – one by one) No Programming Skills Required. (The profound difference in productivity.) Perform tasks For Each instance in input Data…

Get-xParameter

PowerShell Documentation » Run PowerShell from Fusion » Fusion PowerShell Commands » Get-xParameter

Get-xParameter -Name “String” Get the value from a Fusion Parameter and assign it to a PowerShell variable. *Passwords: Notice that the Cmdlet writes the retrieved value to the Console when running in PowerShell ISE but not for Parameters of type…

Script before (Collection)

Component reference » Collection » Script before (Collection)

Script can run BEFORE any of the referenced Components executes. Language Features PowerShell The embedded script is invoked using the PowerShell.exe. The ISE can be used to developing and testing the script. Special PowerShell commands are…

Add-xJobLog

PowerShell Documentation » Run PowerShell from Fusion » Fusion PowerShell Commands » Add-xJobLog

Add-xJobLog -LogType “String” -Message “String” Add a message to the Fusion Job Log. The command works asynchronously so you can use the Fusion Job Log to monitor the progress of your script as it executes. -LogType Argument…

Script after (Collection)

Component reference » Collection » Script after (Collection)

Script can run AFTER the referenced Components have been executed. Language Features PowerShell The embedded script is invoked using the PowerShell.exe. The ISE can be used to developing and testing the script. Special PowerShell commands…

Job Monitor

Fusion Control Panel » Job Monitor

Controls and monitors Components that runs on a scheduled basis or is invoked from PowerShell. Jobs modes: Que – sequentially, one after another. Parallel – multiple jobs runs simultaneously. PowerShell – Jobs initiated using the function…

Set-xParameter

PowerShell Documentation » Run PowerShell from Fusion » Fusion PowerShell Commands » Set-xParameter

Set-xParameter -Name “String” -Value “String” Transfer/assign the value from a PowerShell variable to a Fusion Parameter *Parameters of type Password cannot be assigned. Example: Set-xParameter -Name "[]" -Value $MyVariable

Collection

Component reference » Collection

Work with multiple Components and integrate PowerShell/SQL Combine multiple Components into one job Set conditions for Component calls Call PowerShell and execute SQL with parameters Collection Components can contain other Collection Components Use the…

Error: The operation has timed out

FAQ & How to » Error conditions… » Error: The operation has timed out

SharePoint Platform: 2010, 2013 On-Premises This is often coursed by a server side settings in SPWebApplication.ClientCallableSettings It is default set to 00:01:30 and this is often to low. To check the setting: To change the setting to 5 minutes: PowerShell…

Data Movement – in & out of SharePoint

Use Cases » Data Movement – in & out of SharePoint

Conditionally take action on List & Document Items You configure Fusion components and visually test/verify the actions step-by-step. The components are stored in the repository and can also be called from batch jobs or PowerShell Data Movement in…

New Collection

In-app help » new componnet dialog box » New Collection

Automation: Combine multiple Components and integrate PowerShell/SQL Group components into composite parameterized jobs Set conditions for Component calls Run PowerShell and SQL with parameters Use nested calls to other…

Run external program (API)

Component reference » Collection » Run external program (API)

To run an external program use the RunProgram() function. The external program will run and any return value is returned to Fusion. *Any windows program can be called. This is useful in many scenarios including: Custom logic in FileTransport components for…

SharePoint Subsites List

Component reference » Data Transport » SharePoint Subsites List

This List is managed and maintained virtually by Fusion and it does npt exists within SharePoint. When you retrieve the List, Fusion is generating the Site Hierarchy relative to the Connection URL. Each Item in the List is equal to one site in the Site…

Legacy ECM data to SharePoint

Use Cases » Legacy ECM data to SharePoint

By combining File Transport with Data Transport components you can migrate or synchronize Enterprise Content Management Systems (ECM) with SharePoint. With the Data Transport component you can apply the metadata after files are uploaded. You can do it in multiple…

Delete items or documents from SharePoint

Use Cases » Delete items or documents from SharePoint

VideoDeleteSelectively Delete items from document library based on criteria just like WHERE clause in SQL statement but without programming. Key features Test-run allows jobs to run and log all actions, without committing them Jobs…

Run Excel from Job Server Service

Fusion Control Panel » Job Monitor » Job Server » Run Excel from Job Server Service

When running Excel jobs from the Job Server installed as a Windows Service you might run into different errors where Excel cannot function. The issue is a limitation imposed by Microsoft and it is not specific to Fusion. This applies to any program type including c#,…

Master Data Management

Use Cases » Master Data Management

Collect and stage data in the built-in XRM database. The included Master Data Management allows you to merge and manage many different Data Sets from SharePoint, Databases, Excel, CSV etc. You can analyze, aggregate and create dynamically selected sub sets of…

Connectors to ERP/CRM and Databases

Use Cases » Connectors to ERP/CRM and Databases

You get 2-way access to more than 40 Data Source Drivers. *Simple connection set-up and streamlined command execution. No complex API calls and no programming. Further more, connectors give you automatic error recovery, retry and audit/reporting. A Data Source…

CSV Importer/Exporter with powerful filters

Use Cases » CSV Importer/Exporter with powerful filters

Read CSV file and update SharePoint, Database, LOB systems or the Internal XRM data store. Write CSV file with data sets retrieved from more than 40 data sources. SELECT data set with powerful criteria from CSV file. Then use it to CREATE or UPDATE Items in…

Add/Update SharePoint List Items from external data source

Use Cases » Add/Update SharePoint List Items from external data source

Data “travel” from Source to Target via the Data Transport component Key features Create / Update Items with data from databases or applications like MS Dynamics, SAP. Create / Update Items using Items from same list or…

Fusion Feature List

Fusion Feature List

ONE-STOP TOOL for getting data IN/OUT and AROUND SharePoint Visual and interactive jobs with previewing of what is going to happen. Perform test-runs to analyze outcome before committing changes Automate tasks with parameters. Run one-off jobs or scheduled on the…

Conditional replication of Documents from Site to Site at high speed.

Use Cases » Conditional replication of Documents from Site to Site at high speed.

Documents and metadata can be replicated between locations. The selection criteria dynamically limits the files that gets replicated Metadata can, in-stream, be transformed or converted into Managed Metadata. And even enriched from external data source.) …

Replicate/Migrate FileShare to SharePoint Library at high speed

Use Cases » Replicate/Migrate FileShare to SharePoint Library at high speed

. Source (your FileShare) and target (your SharePoint Library) is specified in the File Transport component. You give the component a name and run it visually step-by-step or schedule it as a batch job on the built-in batch server. With Bidirectional support you can…

Query any SharePoint List & Library

Use Cases » Query any SharePoint List & Library

No 5k Threshold Limit. No column indexing. No Special views. No Coding. No CAML syntax. Simple to use! Save your parametrized Queries as Componets, and reuse ad hoc or in automated tasks. Transfer Query result set to: Screen – interactive…

SharePointSiteTempalte

Component reference » Function reference » SharePoint » SharePointSiteTempalte

Function reference Make the information needed to create a target site if it does not already exist. This is used by the FileTransport component when called from DataTransport/For-Each-Row.* SharePointSiteTempalte(TemplateID, SiteTitle, SiteDescription) …

Component reference

Component reference

FileTransport for copying/moving files. DataTransport for interacting with SharePoint Items and database rows. Collection for combining multiple components into a composite job etc

Replace file content on during upload to SharePoint

FAQ & How to » Replace file content on during upload to SharePoint

How to replace the content of the target file with the content from a different file. This technique can for be used for uploading a file to SharePoint and making the actual file a dummy, by dynamically replacing the content uploaded. (Anonymize file content or…

String()

Component reference » Function reference » Text » String()

Function reference Converts data to a string formated according to a specified format mask. You can convert and format date, DateTime, numeric, and time data. String ( data {, format } ) Argument Description data The data you want…

DataValidationWarnings

Component reference » Parameters » System Parameters » DataValidationWarnings

The System Parameter [] returns all column Warnings for each SharePoint Item Updated/Created. Use this Parameter to assign a List Column of choice for data quality analysis and bad data findability. The information returned includes: Unresolved Content…

SharePoint retrieve only distinct Items

Component reference » Data Transport » SharePoint retrieve only distinct Items

You can specify to retrieve only 1 Item for each distinct value based on 1 column or all columns Notice that you can use the Sort option below, so that the distinct value chosen is based on the sort order. This is useful when the sorted columns have multiple values…

Case()

Component reference » Function reference » Logical » Case()

Function reference Tests the values of a column or expression and returns values based on the results of the test. Case ( column WHEN value1 THEN result1 { WHEN value2 THEN result2 { … } } { ELSE resultelse } ) Argument Description …

Microsoft Text ODBC Driver

Fusion Control Panel » Database connections » Microsoft Text ODBC Driver

Here are a few nice tips for working with the Microsoft Text ODBC Driver encapsulated in Fusion Working with dates: When comparing dates it is useful to hint the driver about the format. Consider the below sample fragment of a WHERE clause: WHERE ('2017-02-08'…

SharePoint connections

Fusion Control Panel » SharePoint connections

Connections stores URL, User/AppID for connecting to SharePoint Sites The connection caches Information about the site artifacts like Lists & Libraries. This information is used for setting up column mappings etc. Important about Office 365 – Microsoft…

RunProgram()

Component reference » Function reference » Miscellaneous » RunProgram()

Function reference Runs an external program and wait for it to complete. A return value can optionally be communicated using a dynamically generated Registry Key. RunProgram ( ‘Exe ‘ , ‘Argument’ , ‘Timeout’ , …

Pause()

Component reference » Function reference » Miscellaneous » Pause()

Function reference Pause program execution for the specified number of seconds. Pause( ‘seconds’ ) Argument Description seconds The number of seconds to pause. (suspend execution) Example 1 This example will pause for 5…

GetJobSessionComponentID()

Component reference » Function reference » Miscellaneous » GetJobSessionComponentID()

Function reference Returns the id for the current top-level component. GetJobSessionComponentID() Example 1 This example will output the id for the top-level component in the current session to the debug window. Debug( GetJobSessionComponentID()…

SharePointSourceURL

Component reference » Function reference » SharePoint » SharePointSourceURL

Function reference Make the combined Site URL for interpretation in the FileTransport component when called from DataTransport/For-Each-Row. SharePointSourceURL(Site, DocumentLibrary, FolderAndWildcard) Argument Description Site The URL to…

Introduction & Specifications

Self Service File Migration & Sync » Introduction & Specifications

Use SharePoint List to configure and schedule File Migration & Sync Jobs Empowering Users and Workflows to run recurring or onetime File Migration & Sync jobs Just create a simple SharePoint List Item for each job – That’s it! Production ready in 15…

New Data Transport

In-app help » new componnet dialog box » New Data Transport

High performance data migration to/from/within SharePoint, Excel, CSV and Databases Actions on List & Library items with Automation (Features) Create new SharePoint List from Excel, CSV, SQL, other SharePoint List. Then Sync data Read,…

Time()

Component reference » Function reference » Date & Time » Time()

Function reference Converts a string to a time datatype. Time ( string ) Argument Description string A string containing a valid time (such as 8 am or 10:25) that you want returned as a time datatype. Only the hour is required; you do not…

SharePointTargetURL

Component reference » Function reference » SharePoint » SharePointTargetURL

Function reference Make the combined Site URL for interpretation in the FileTransport component when called from DataTransport/For-Each-Row. SharePointTargetURL(Site, DocumentLibrary, Folder, ContentType) Argument Description Site The URL…

Conditionally copy files or folders to different SharePoint sites

Use Cases » Conditionally copy files or folders to different SharePoint sites

Calculate target “Site URL” dynamically for each File or Folder. Use cases: (They all use the Run Component for each row feature in Data Transport) FileShare upload to SharePoint Site where each top level folder represents a Customer…

Next version

Roadmap » Next version

Features implemented for next GA release August 1, 2021 Module Type Version 12.00 August 1, 2021 SharePoint Enhancement Emoji support (❤️, copy paste emoji ). Item properties, including file and folder names can now contain…

Data Transport

Component reference » Data Transport

h3.Work with SharePoint List & Library Items and data from CSV, Database and Excel Excel Perform actions bidirectionally : • Read • Create • Update • Delete/Recycle • Looping (For-Each .. do this and that) Read/Write data bidirectionally : •…

DayName()

Component reference » Function reference » Date & Time » DayName()

Function reference Obtains the day of the week in a date value and returns the weekday’s name. DayName ( date ) Argument Description string date The date for which you want the name of the day Data type: String Returns a string…

FirstDayOfWeekISO()

Component reference » Function reference » Date & Time » FirstDayOfWeekISO()

Function reference Get the first day of the week as a date data type. (ISO standard) FirstDayOfWeekISO( year , week ) Argument Description year a numeric value for the year week a numeric value for the week number…

Tuning SharePoint O365 performance

Component reference » File Transport » Tuning SharePoint O365 performance

Microsoft recommendations for best Office 365 performance: When uploading high volume of file content, the best performance is accomplished outside normal business hours (night time or weekends). Use AppID/Secret as the authentication model, NOT user accounts, when…

File Migration & Sync

In-app help » File Migration & Sync

Use SharePoint List to configure and schedule File Migration & Sync Jobs Empowering Users and Workflows to run recurring or onetime File Migration & Sync jobs Just create a simple SharePoint List Item for each job – That’s it! Production ready in 15…

LastDayOfWeekUS()

Component reference » Function reference » Date & Time » LastDayOfWeekUS()

Function reference Return the last day of the week as a date data type. (US standard) LastDayOfWeekUS( year , week ) Argument Description year a numeric value for the year week a numeric value for the week number…

FirstDayOfWeekUS()

Component reference » Function reference » Date & Time » FirstDayOfWeekUS()

Function reference Get the first day of the week as a date data type. (US standard) FirstDayOfWeekUS( year , week ) Argument Description year a numeric value for the year week a numeric value for the week number…

LastDayOfWeekISO()

Component reference » Function reference » Date & Time » LastDayOfWeekISO()

Function reference Get the last day of the week as a date data type. (ISO standard) LastDayOfWeekISO( year , week ) Argument Description year a numeric value for the year week a numeric value for the week number…

New File Transport

In-app help » new componnet dialog box » New File Transport

High Performance File and metadata Migration to/from/within SharePoint and FileShares File actions in any direction with Automation (features) Copy, Move, Delete, Recycle, Print, E-Mail Synchronize (1-way or 2-way) Enrich…

Fusion random crash “BEX”

FAQ & How to » Fusion random crash “BEX”

On some systems Fusion can crash with a Windows “BEX” error This problem is registered on Windows Server 2008 The solution can be to run Fusion in compatibility mode with Windows 7 Procedure: In the Fusion program folder: (C:\Program Files…

DayNameLocal()

Component reference » Function reference » Date & Time » DayNameLocal()

Function reference Gets the day of the week in a date value and returns the weekday’s name in localized language. DayNameLocal ( string date ) Argument Description string date The date represented as a string for which you want the…

Job log viewer

Component reference » Job log viewer

All Automation Components generate a job log each time they run. Multiple components can be grouped together in a Collection to form a composite job with many steps. In this case log entries are hierarchy referenced for each component in the collection so that the…

Excel Workbook – Refresh/Push/Pull

Use Cases » Excel Workbook – Refresh/Push/Pull

BULK Generate Client specific Excel reports and Push to individual shared folders. Table & Named Cell Retrieval/Update. (Bidirectional) Use existing workbooks or new-from-template with dynamic “Save As”. Refresh Data Tables. Push data sets or single…

Bulk Update SharePoint Items

FAQ & How to » Bulk Update SharePoint Items

Recommendations for updating List items with data from any data source General background: SharePoint Architecture for List Item Update To programmatically update Items in SharePoint Lists and Libraries the only way SharePoint allows that is by specifying the unique…

WordCap()

Component reference » Function reference » Text » WordCap()

Function reference Sets the first letter of each word in a string to a capital letter and all other letters to lowercase (for example, ROBERT E. LEE would be Robert E. Lee). WordCap ( string ) Argument Description string A string or…

Database connections

Fusion Control Panel » Database connections

Connections stores properties like Server name, User/Password etc. necessary to connect to a given database. Connectors to ERP/CRM and Databases *A connection can be referenced from multiple Components and user/password can include parameters. In SQL statements the…

Excel BULK generator

Use Cases » Excel BULK generator

BULK Generate Client specific Excel Reports and push to individual Sites Use existing workbooks or new-from-template with dynamic “Save As”. Refresh Data Tables. Push data sets or single values. Iterate same workbook and perform multiple operations as 1…

MS Flow – Notification

In-app help » MS Flow – Notification

Optional. Skip this step if you don’t want to use Microsoft PowerAutomate for Job Notification Users can get notified on job start and completion by installing the per-packaged Microsoft Flow template. The flow is invoked if the Migration Job signals a warning…

Dynamic FileTransport Target

Component reference » File Transport » Dynamic FileTransport URL/UNC » Dynamic FileTransport Target

You can call the same File Transport component for each row in a data set, and dynamically use different Source/Target URL or UNC path. Note: URL/UNC path values can be dynamically constructed using calculations that references other parameters of database…

Error retrieving Items: [11004] Valid name, no data record (Check DNS setup)

FAQ & How to » Error conditions… » Error retrieving Items: [11004] Valid name, no data record (Check DNS setup)

This error is a WinSock error that is being returned by the system socket. According to the MSDN list of WinSock Error Codes WSANO_DATA 11004 The requested name is valid and was found in the database, but it does not have the correct associated data…

Date()

Component reference » Function reference » Date & Time » Date()

Function reference Converts a string whose value is a valid date to a value of datatype date. Date ( string ) Argument Description string A string containing a valid date (such as Jan 1, 2004, or 12-31-99) that you want returned as a date…

Assigning SharePoint metadata

Component reference » File Transport » Assigning SharePoint metadata

Dynamically calculated value, a source file field reference, or a constant can be assigned to a SharePoint column. A constant can be typed in or a field related to the source file can be selected in the DropDown next to the SP column. The special fields [Folder01],…

System Parameters

Component reference » Parameters » System Parameters

[] Returns all column Warnings for each SharePoint Item Updated/Created.

2 Factor authentication not supported

Fusion Control Panel » 2 Factor authentication not supported

SharePoint Online limitation Multi-Factor-Authentication cannot work when using classic authentication to SharePoint (user name and password) In Fusion, you can instead use Web Login. Microsoft recommends to use AppID/AppSecret authentication at all times for high…

System requirements

Sales information » System requirements

Performance is greatly dependent on available Memory & CPU power Microsoft .Net Framework requirements .Net Framework 4.6.2 .Net Framework 3.5.x for access to SharePoint 2010 Minimum hardware requirements Monitor: Screen resolution of minimum 1280 ×…

Diagnostics

Miscellaneous » Diagnostics

Activating Diagnostics can help troubleshooting error conditions. This feature is mostly for support cases

GetJobSessionID()

Component reference » Function reference » Miscellaneous » GetJobSessionID()

Function reference Returns the unique id for the current component session. GetJobSessionID() Example 1 This example will output the current SessionID to the debug window. Debug( GetJobSessionID() )

Office 365 “Service Applications”

No-Code Service Application Framework » Office 365 “Service Applications”

Say HELLO to No-Code O365 “Service Applications” running unattended client-side on any machine locally or in your private cloud. Design your own “No-Code O365 Service Applications” in the most powerful framework ever created for SharePoint and data…

Custom Repository

In-app help » Custom Repository

Install a Custom Repository pre-configured for specific tasks. Select or download the custom Repository .XDS file to install. *You can crate your own template simply by creating a backup of your Repository to an .XDS file

Links to external articles

FAQ & How to » Links to external articles

External links *WeTransfer: Quick and easy file transfer service. SharePoint Server 2010 capacity management: Software boundaries and limits Plan for performance and capacity management in SharePoint Server 2013 Firebird database reference Firebird database…

SharePoint column types and data validation

Component reference » SharePoint column types and data validation

Before a value is updated on SharePoint, it is validated. The validation is also performed when “Test-Run” is executed. InvalidData.txt Report is embedded in the Job Log Fusion supports the following SharePoint column types: Type Validation…

MonthName()

Component reference » Function reference » Date & Time » MonthName()

Function reference Obtains the month of a date value and returns the month’s name. MonthName ( ‘string date’ ) Argument Description string date The date for which you want the name of the month Data type:…

Error: Access to the path ‘xyz’ is is denied.

FAQ & How to » Error conditions… » Error: Access to the path ‘xyz’ is is denied.

If you get the error Access to the path ‘xyz’ is is denied. during file copy from a File Share then check that you have the proper rights to access the files. Google c# Access to the path for details.

WeekNumberUS()

Component reference » Function reference » Date & Time » WeekNumberUS()

Function reference Return the week number of a date value. (US standard) WeekNumberUS ( ‘string date’ ) Argument Description string date The date for which you want the week number Data type:…

WeekNumberISO()

Component reference » Function reference » Date & Time » WeekNumberISO()

Function reference Return the week number of a date value. (ISO standard) WeekNumberISO ( ‘string date’ ) Argument Description string date The date, represented as a string, for which you want the week number Data type:…

Year()

Component reference » Function reference » Date & Time » Year()

Function reference Obtains the year portion of date. Years from 1000 to 3000 inclusive are handled. Year ( date ) Argument Description date The date value from which you want the year Data type: Integer Returns an integer whose value…

Len()

Component reference » Function reference » Text » Len()

Function reference Reports the length of a string in characters. Len ( string ) Argument Description string The string for which you want the length Data type: Long Returns a long containing the length of string in…

Parameters in File Transport

Component reference » Parameters » Parameters in File Transport

Parameters can be used in the file specification to point to system folders like the Desktop and Documents folder, or to a user defined location. A parameter can also be used in the SharePoint Folder specification…

Day()

Component reference » Function reference » Date & Time » Day()

Function reference Obtains the day number of the month in a date value. Day ( date ) Argument Description date The date for which yhu want the day Data type: Integer Returns an integer representing the day of the month in a…

Parameters

Component reference » Parameters

Parameters are basically variables that holds data values and returns them when referenced from Components or calculations However the concept of variables is extended with an optional expression/rule set that evaluates each time the parameter is referenced. The…

SharePoint Document Set

Component reference » File Transport » SharePoint Document Set

Working with Document Sets using FileTransport and DataTransport SharePoint Document Set is basically a “Special Folder” having multiple columns for metadata that applies to all files within the Set. The metadata columns available are defined by the…