If you purchased PHPRunner or ASPRunner.NET less than 12 months ago, proceed to the control panel<\/a> and download the registered version 10.7 there under ‘My purchases’. Use ‘Reg info’ link next to your latest purchase.<\/p>\n This new version features the following improvements: Let’s dig into new functionality. <\/p>\n When you set ‘Edit as’ type of the field to File\/Image you now have an option to choose one of the cloud storage options. <\/p>\n Refer to this article<\/a> that explains how to create an app in Google Cloud Console and get OAuth Client ID<\/strong> and OAuth Client Secret<\/strong>. Folder ID<\/strong> is optional. If you do not specify it, files will be uploaded to the root folder. <\/p>\n To find the folder id proceed to that folder in Google Drive in your web browser. The URL may look like this:<\/p>\n Here 0B-9X707clcqJMmI4OTI4MWEtMDBmNS00OGIwLThiZmYtOWJhMDdiNTc3ZmU3<\/strong> is your folder id.<\/p>\n Make sure to read the Important<\/strong> note below.<\/p>\n Proceed to Azure -> App registrations -> New registrations<\/a><\/p>\n Name:<\/strong> Redirect URI:<\/strong> – you can change this parameter later PHPRunner:<\/strong> ASPRunner.NET:<\/strong> Press Register<\/strong> to create the application. <\/p>\n App registrations -> Your app, Proceed to Overview<\/strong> Proceed to Certificates & secrets, click ‘New client secret’ Proceed to API Permissions<\/strong> Proceed to Authentication<\/strong> Proceed to OneDrive<\/a>. You are all set. Now you can run your application. <\/p>\n This applies to both Google Drive and Microsoft OneDrive. After the project is built and published, open it in the web browser and proceed to any page of a table where cloud storage is used. You will be redirected to Google or Microsoft site to log in. The credentials are saved in You need to specify Access Key ID, Secret Access Key, S3 Bucket name, Region and optional path. <\/p>\n 1. Logon to AWS Console<\/a> as a root user. <\/p>\n 2. In the navigation bar on the upper right, choose your account name or number and then choose My Security Credentials.<\/p>\n 3. Expand the Access keys (access key ID and secret access key)<\/strong> section.<\/p>\n 4. To create an access key, choose Create New Access Key<\/strong>. If you already have two access keys, this button is disabled and you must delete an access key before you can create a new one. When prompted, choose either Show Access Key<\/strong> or Download Key File<\/strong>. This is your only opportunity to save your secret access key. After you’ve saved your secret access key in a secure location, choose Close<\/strong>.<\/p>\n 5. Go back to the account home page, select S3 from the list of Services. Create a new bucket or select an existing one. This is where you can see the Bucket Name<\/strong> and Region<\/strong>. <\/p>\n 6. Important:<\/strong> in bucket properties, under Permissions<\/strong>, scroll down to Cross-origin resource sharing (CORS)<\/strong> and paste the following JSON there. It is required for Amazon S3 Javascript library to work. <\/p>\n To enable Notification API, proceed to Miscellaneous screen, click ‘Notification API’ button, enable this feature and create a new table to store notifications. Now, since this is an API, we need to write some code to make it work. Let’s start with something simple. When someone adds a new record to the Categories table we also want to create a notification. <\/p>\n For this purpose, we will add the following code to the Categories table AfterAdd event:<\/p>\n PHP<\/strong><\/p>\n C#<\/strong><\/p>\n If everything worked as expected, we will see a new notification added after each new record in the Categories<\/strong> table. And if we click on any notification, it will take us to that new Category view page. <\/p>\n Let’s take a closer look at this function’s parameters. <\/p>\n PHP<\/strong> C#<\/strong> Parameters:<\/strong><\/p>\n $message<\/strong> – notification text<\/p>\n $title<\/strong> – optional notification title<\/p>\n $icon<\/strong> – optional icon, can be in one of three formats:<\/p>\n URL – “https:\/\/website.com\/path\/image.png” or “images\/file.gif”<\/p>\n Bootstrap icon: “glyphicon-film”, “glyphicon-hand-right” Font Awesome icon: “fa-envelope”, “fa-user” $url<\/strong> – optional URL. When specified, a click on notification sends the user to the specified address. See makePageLink function<\/p>\n $expire<\/strong> – optional expiration date and time for the message. Can be either datetime in “YYYY-MM-DD hh:mm:ss” format, or a number of minutes the notification should be visible. After the expiration date\/time the notification will be deleted from the notifications table.<\/p>\n Examples: $user<\/strong> – username the message should be visible to. If not specified, all users and guests will see the notification.<\/p>\n $provider<\/strong> – when $user is a database user, whose username and password are stored in a database table, this parameter must be empty. When the user is from Active Directory, OpenID, Google etc, then put the two-letter security provider code here. You can find it on the ‘Security screen’ under the provider settings dialog.<\/p>\n PHP<\/strong> C#<\/strong> $params – array of notification parameters You can use a helper function makePageLink<\/strong> to quickly create links to any application page.<\/p>\n PHP<\/strong> C#<\/strong> Parameters:<\/strong> $page<\/strong> – page type like “list”, “add”, “edit”<\/p>\n $keys<\/strong> – when creating a link to edit or view page, specify record keys here. This can be either simple array of values, like $additionalParams<\/strong> – any additional params you want to add to the URL. Examples:<\/strong><\/p>\n PHP<\/strong><\/p>\n C#<\/strong><\/p>\n The code above will produce a link “cars_list.php?page=list1”, which points to the additional List page called list1<\/strong>.<\/p>\n PHP<\/strong><\/p>\n C#<\/strong><\/p>\n When called from the ‘After Record Added’ event returns a link to the View page of the newly added record.<\/p>\n Enjoy!<\/p>\n","protected":false},"excerpt":{"rendered":" Version 10.7 of PHPRunner and ASPRunner.NET is here! Trial version download links If you purchased PHPRunner or ASPRunner.NET less than 12 months ago, proceed to the control panel and download the registered version 10.7 there under ‘My purchases’. Use ‘Reg info’ link next to your latest purchase. This new version features the following improvements: 1. Files upload to cloud providers: Google Drive, OneDrive, Amazon S3, Dropbox 2. Notification API Let’s dig into new functionality. Files upload to cloud providers When you set ‘Edit as’ type…<\/span>Continue Reading “Version 10.7”<\/span>
\n1. Files upload to cloud providers: Google Drive, OneDrive, Amazon S3, Dropbox
\n2. Notification API<\/p>\nFiles upload to cloud providers<\/h2>\n
![\"\"](\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2021\/12\/google_drive-600x246.png\")
<\/a>
\n<\/p>\nGoogle Drive<\/h3>\n
https:\/\/drive.google.com\/drive\/u\/3\/folders\/0B-9X707clcqJMmI4OTI4MWEtMDBmNS00OGIwLThiZmYtOWJhMDdiNTc3ZmU3?resourcekey=0-z0sQH4Jjn_-nLn64zuPDvg<\/pre>\n
Microsoft OneDrive<\/h3>\n
Create a new app registration<\/h4>\n
\nSupported account types:<\/strong> This parameter can not be changed later.
\nIf you plan to use your personal OneDrive account, choose Personal Accounts only<\/p>\n
\nPlatform:<\/strong> Web<\/p>\n
\n
\nFor example
\nhttps:\/\/my.site\/app\/oauthcallback.php
\nor
\nhttp:\/\/localhost:8086\/oauthcallback.php<\/p>\n
\n
\nFor example
\nhttps:\/\/my.site\/app\/oauthcallback
\nor
\nhttp:\/\/localhost:8086\/oauthcallback<\/p>\nConfigure app registration<\/h4>\n
![\"\"](\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2021\/12\/azure_portal-1-600x335.png\")
<\/a><\/p>\n
\nApplication (client) ID<\/strong> – copy to PHPRunner\/ASPRunner.NET as Client ID<\/p>\n
\nAfter the secret is created copy its Value (not the Secret ID!) to the Client Secret field in PHPRunner\/ASPRunner.NET<\/p>\n
\nClick Microsoft Graph and add permissions.
\nUse the search tool.
\nThe following permissions need to be added:
\noffline_access
\nFiles.ReadWrite<\/strong><\/p>\n
\nAdd the Redirect URL if you didn’t do that before or need to add a new one.
\nPress Add platform, choose Web.
\nSee above which Redirect URL to enter.<\/p>\n
\nNote the URL in browser’s address box. It should be something like this
\nhttps:\/\/onedrive.live.com\/?id=root&cid=7FD32AC638D2A7
\nCopy the cid parameter value to Drive field in PHPRunner
\nFor example:
\n7FD32AC638D2A7<\/strong><\/p>\nImportant<\/h3>\n
\nLog in under the account that should be used to store the files. Then the application will save the credentials, and no further login will be needed.<\/p>\nAmazon S3<\/h3>\n
![\"\"](\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2021\/12\/amazon_s3-600x268.png\")
<\/a><\/p>\n\r\n[\r\n {\r\n \"AllowedHeaders\": [\r\n \"*\"\r\n ],\r\n \"AllowedMethods\": [\r\n \"HEAD\",\r\n \"GET\",\r\n \"PUT\",\r\n \"POST\",\r\n \"DELETE\"\r\n ],\r\n \"AllowedOrigins\": [\r\n \"*\"\r\n ],\r\n \"ExposeHeaders\": [\r\n \"ETag\"\r\n ]\r\n }\r\n]\r\n<\/pre>\nNotification API<\/h2>\n
\r\naddNotification( \"New category added: \".$values[\"CategoryName\"] , \"New category\", \"fa-envelope\", makePageLink( \"categories\", \"view\", $keys) );\r\n<\/pre>\n
\r\nCommonFunctions.addNotification( \"New category added: \" + values[\"CategoryName\"].ToString() , \"New category\", \"fa-envelope\", makePageLink( \"categories\", \"view\", keys) );\r\n<\/pre>\n
![\"\"](\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2021\/12\/scr_notifications.png\")
<\/a><\/p>\n
\nfunction addNotification<\/strong>( $message, $title = null, $icon = null, $url = null, $expire = null, $user = null, $provider = null )<\/p>\n
\nfunction CommonFunctions.addNotification<\/strong>(dynamic _param_message, dynamic _param_title = null, dynamic _param_icon = null, dynamic _param_url = null, dynamic _param_expire = null, dynamic _param_user = null, dynamic _param_provider = null)<\/p>\n
\nThe full list of available Bootstrap icons<\/a>.<\/p>\n
\nThe full list of available Font Awesome icons<\/a>.<\/p>\n
\n“2022-01-10 00:00:00” or 1440 for 24-hour period<\/p>\nAlternative syntax<\/h4>\n
\nfunction createNotification<\/strong>( $params )<\/p>\n
\nfunction CommonFunctions.createNotification<\/strong>( dynamic params )<\/p>\n
\n$params[“message”] – corresponds to $message parameter in addMessage()
\n$params[“title”] – notification title
\n$params[“icon”] – icon
\n$params[“url”] – URL
\n$params[“expire”] – expiration datetime or time in minutes
\n$params[“user”] – user
\n$params[“provider”] – security provider<\/p>\nCreating a link to an application page<\/h4>\n
\nfunction makePageLink<\/strong>( $table, $pageType, $keys = null, $additionalParams = array() )<\/p>\n
\nfunction makePageLink<\/strong>(dynamic table, dynamic pageType, dynamic keys = null, dynamic additionalParams = null)<\/p>\n
\n$table<\/strong> – name of the table the page belongs to. Specify empty string for pages like login, menu etc.<\/p>\n
\narray( 10, “JOHN”)
\nor associative array with field names as keys:
\narray( “department” => 10, “last_name” => “JOHN”)
\nWhen used in ‘After record updated’ or ‘After record added’ event, pass the $keys<\/strong> parameter of the event as is. <\/p>\n
\narray( “page” => “list1” ) will create a URL to the additional list page named “list1”<\/p>\nmakePageLink( \"cars\", \"list\", null, array( \"page\" => \"list1\" ))<\/pre>\n
CommonFunctions.makePageLink( \"cars\", \"list\", null, new XVar(\"page\", \"list1\"))<\/pre>\n
makePageLink( \"cars\", \"view\", $keys )\r\n<\/pre>\n
CommonFunctions.makePageLink( \"cars\", \"view\", keys )\r\n<\/pre>\n