Priority Cloud

Development on Priority Cloud is mostly identical to development for Priority Web on a local installation. However, there are some additional restrictions on working with files:

1. You cannot save files directly to the attachments directory (system/mail) or the cloud interface directory (system/sync). However, you can create the files first in the permitted folder, then use the COPYFILE program to copy it to the relevant directory. For example:

    /* Create a valid filename target in system/mail */
    SELECT NEWATTACH('aaa1', 'txt') INTO :FOUT FROM DUMMY;
    /* Create a temporary file to work with */
    SELECT SQL.TMPFILE INTO :F FROM DUMMY;
    /* OR */
    SELECT STRCAT(SYSPATH('LOAD', 1), 'myfile.txt') INTO :F FROM DUMMY;
    /* Create the file */
    SELECT * FROM DAYS WHERE DAYNUM BETWEEN 1 AND 4 TABS :F;
    SELECT * FROM DAYS WHERE DAYNUM > 4 TABS ADDTO :F;
    EXECUTE COPYFILE :F, :FOUT;
   

   The exception to this rule is the WINHTML program, which can save files to system/mail:

      :DOC = 100;
      SELECT NEWATTACH('document.pdf') INTO :PATH FROM DUMMY;
      EXECUTE WINHTML '-d', 'WWWSHOWORD', '', '', '-v', :DOC, '-pdf', :PATH;
   

2. Many programs cannot interact directly with files located in attachments directory (system/mail) or the cloud interface directory (system/sync). For example, you cannot run a FILTER or DBLOAD on files in the directories. Instead, you should copy the file into the temporary directory, make the required manipulations as necessary, then use COPYFILE to copy the new file over back to the protected folder.

   As an example, a scenario where we have an interface file in CSV format in system/sync. We FILTER it into a tab-separted file, then use DBLOAD to load it into the database.

  :RAWFILE = STRCAT(SYSPATH('SYNC', 1), 'csv_240915.txt')
  /* Create temporary files as copy and filter targets */
  :RAWTMPFILE = STRCAT(SYSPATH('TMP', 1), 'csv_240915.txt');
  :FILTEREDFILE =STRCAT(SYSPATH('TMP', 1), 'tsv_240915.txt');
  EXECUTE COPYFILE :RAWFILE, :RAWTMPFILE;
  EXECUTE FILTER ',', ',', '09' :RAWTMPFILE, :FILTEREDFILE;
  /* load with DBLOAD */
  EXECUTE DBLOAD '-L', 'EXAMPLE', -i, :FILTEREDFILE;
  /* save a copy of the filtered file as an archive in 
  system/sync */
  :ARCHIVEFILE = STRCAT(SYSPATH('SYNC', 1), 'archive/', 'tsv_240915_bak.txt')
  EXECUTE COPYFILE :FILTEREDFILE, :ARCHIVEFILE;

system/sync

The system/sync folder is a special folder available in Priority installations on the public cloud. It provides a location, accessible by SFTP, where users can upload files from an external source.

The folder behaves a bit differently than regular Priority folders. The following considerations should be taken into account when using it in code and uploading to it:

1. Priority expects all files and folders in this folder to be entirely in lowercase. If you upload files with capital letters, Priority cannot interact with them.
2. If you use COPYFILE to copy files to this folder, the name of the created file will automatically be changed to lowercase.
3. When using COPYFILE, you can specify a subdirectory as part of the name of the file. If necessary, a directory (in lowercase) with that name will be created. There is no need to use MAKEDIR beforehand to create the directory.