ReadColumnFromFile

Definition:

ReadColumnFromFile(filename, datasource, column)

 

Description:

Insert the contents of a file into a specified column of the current record of a specified Data Source table.

 

Platforms:

Universal Windows, Windows Desktop

 

Parameters:

filename - required

Specify one of the following values:

"" - Specify an empty string to allow the user to browse for and select the file to read from at runtime.

<filename> - Specify a file name without a path, e.g. MyFile.txt, to read a file located within the default folder (see Notes below).

 

Documents\<subfolderpath>\<filename> - Specify the path and file name of a file located in the device's Documents library, or one of its subfolders, using this special format, e.g. Documents\MyApp\DataFiles\MyData.xlsx. This option requires permission to directly access the device's Documents library (see Notes below).

 

Specify the name of the file to read.

If you include a fully qualified path name with the file name, the Client will look in the specified folder, otherwise it will use a default folder (see Notes below).

 

 

datasource - required

Specifies the Data Source to which the file will be written – click here for the format of this parameter.

 

column - required

Name of the column to which the file will be written.

 

Returns:

nothing

 

Notes:

  • The entire contents of the file will be written as a continuous string into the specified column. If the column already contains data, the existing data will be overwritten.

  • The column can contain any type of data including pictures.

  • If the file specified can't be found, an error message to this effect will be displayed.

Note the following:

  • If you specify an empty string as the parameter to this Method, the operating system controls which files the user can select and read.

  • If you specify just a file name as the parameter to this Method, you can read any file from the default folder. The default folder varies depending upon whether you are running the app within the Universal Windows Client or as a Standalone App:

    Digitise Apps Client:

    C:\Users\<user>\AppData\Local\Packages\<appGUID>\LocalCache\Applications\<appname>\docs

    Standalone App:

    C:\Users\<user>\AppData\Local\Packages\<appGUID>\LocalCache\<appname>\Applications\<appname>\docs

    where appGUID is a unique identifier assigned to an app by the operating system. You can recognise the relevant GUID for your app or Digitise Apps Client by looking for the app name within the GUID or, in the case of a Digitise Apps Client, the GUID will contain 'MXUniversalClient' within it, e.g. a Digitise Apps Client GUID will look something like: com.ndl.mx.MxUniversalClient_1a2b3c4e5f6g7.

  • If you are creating a Standalone App and you want to directly access files in the device's Document library using this Method, you will need to turn on this capability within the build request to the Digitise Apps Build System. You do this by selecting the Access Documents Library option under the Permissions tab when configuring the Standalone App build request in App Studio. If you select Access Documents Library, you then need to create a list of file extensions determining which files in the Documents library the Scripting Methods are allowed to operate on.

    Note that when creating a store version of a Standalone App, selecting Access Documents Library affects the process by which you submit the app to the Store and requires you to justify your use of this option to Microsoft.

    For a pre-configured version of the Universal Windows Client, Access Documents Library is always selected and you only need to specify a list of file extensions, determining which files in the Documents library the Scripting Methods are allowed to operate on, under the File Extensions tab in the build request.

    You can only specify a file using the Documents\<subfolderpath>\<filename> format as a parameter to this Method if Access Documents Library is selected.

    However, the file specified can only be read if its file extension is included in your list of file extensions in the build request. If you specify a file with an unlisted file extension the Method will fail silently.

    The standard NDL-signed Digitise Apps Client supplied in the Digitise Apps Product Download, has Access Documents Library disabled and cannot directly access files and folders in the Documents library.

 

If you omit the path from the file name specified in the filename parameter, the Method will use a default folder. The default folder varies depending upon whether you are running the app within the Windows Desktop Client or as a Standalone App:

Digitise Apps Client:

C:\Users\<user>\AppData\Roaming\ndl-metascybe\MXClient.2013\Applications\<appname>\docs

 

Standalone App:

C:\Users\<user>\AppData\Roaming\ndl-metascybe\MXClient.<appname>\Applications\<appname>\docs