I am amazed by the complex solutions out on the internet to upper case the first letter of a word in SQL. Here is a way I think is nice and simple.
-- Test Data declare @word varchar(100) with good as (select 'good' as a union select 'nice' union select 'fine') select @word = (SELECT TOP 1 a FROM good ORDER BY NEWID()) -- Implementation select substring(Upper(@word),1,1) + substring(@word, 2, LEN(@word))
Hi,
The problem with Request.Browser.IsMobileDevice is that it will classify a tablet as a mobile device.
If you need to discern between mobile, tablet and desktop. Then use the following extension method.
public static class HttpBrowserCapabilitiesBaseExtensions
{
public static bool IsMobileNotTablet(this HttpBrowserCapabilitiesBase browser)
{
var userAgent = browser.Capabilities[""].ToString();
var r = new Regex("ipad|(android(?!.*mobile))|xoom|sch-i800|playbook|tablet|kindle|nexus|silk", RegexOptions.IgnoreCase);
var isTablet = r.IsMatch(userAgent) && browser.IsMobileDevice;
return !isTablet && browser.IsMobileDevice;
}
}
Then to use it is easy. Just import the namespace and reference the method.
using Web.Public.Helpers; ... if (Request.Browser.IsMobileNotTablet() && !User.IsSubscribed) ....
You can do a lot of cusomisation with JWPlayer via CSS skinning with V7, but it has it’s limitations…
Sometimes you need to show an image on a hosted JWPlayer.. It is especially important for mobile devices, as autoplay is disabled on phones, so an image is great feature to have:
<script>
function setupPlayer(container,jwFeedUrl, cameraImage) {
var xhttp = new XMLHttpRequest();
xhttp.open("GET", jwFeedUrl, true);
xhttp.send();
xhttp.onreadystatechange = function () {
if (xhttp.readyState == 4 && xhttp.status == 200) {
var list = JSON.parse(xhttp.responseText).playlist;
list[0].image = cameraImage;
var playerone = jwplayer(container);
playerone.setup({
playlist: list,
mute: 'true',
autostart: 'true'
});
} else if (xhttp.readyState == 4 && xhttp.status == 404) {
Console.log("Error loading player " + jwFeedUrl);
}
};
}
setupPlayer("myDivId","https://content.jwplatform.com/feeds/x12U4l67.json","http://assets.rangerrom.com/portrait/rangerrom.png");
</script>
If you ever see get a Setup Timout error from JWPlayer. A useful workaround if you do not have time to optimise the website asset pipeline is to load the JWPlayer only once the html document is ready.
document.addEventListener("DOMContentLoaded", function (event) {
setupPlayer(...);
or with JQuery
$(function() {
setupPlayer(...);
});
Hi,
I decided it was time to get a Kobo Touch 2.0 and get XCSoar installed on it, complete with GPS. I chose the Touch 2.0 (Amazon.de).
There are detailed instructions you can follow here.
http://blueflyvario.blogspot.com.au/2014/11/kobo-glo-install.html
The reason for this post, is to compliment the above article with some pictures.
Inventory
Solder Station
Kobo Touch 2.0 Serial Port
Important: The RX on the Kobo Port goes to TX on the BlueFly. I use the screw to ground the circuit (yellow wire). Green Wire goes to V. Black and Red is TX and RX on Kobo and switched around on BlueFly.
Soldered To Kobo 2.0
KoboRoot.tgz
Use a Linux Operating System to copy KoboRoot.tgz to the hidden .kobo folder and then reboot the Kobo. I just take out the SD Card, plug it into a machine with Linux or on Windows with a Virtual Machine running Linux (I use Kali Distro).
Customise XCSoar
Once rebooted and XCSoar is running, go to Nickle and then plug in the Kobo 2.0, then just copy additional files for XCSoar. E.g. Maps, Waypoints
Device Settings
Make sure you go into XCSoar Config -> Devices and set the device settings for the BlueFly Vario. Once done, use the monitor button to check feedback. (Ensure the Vario is turned on, by pushing the button. It will make an annoying sound continuously.)…it was music to my ears.
Events – BlueFly.xci
In XCSoar, register the BlyeFly.xci file as an Event in Language/Input. Ensure advance mode is on. This gives you a cool menu for BlueFly where you can set the volume of the beautiful sound it makes.
bluefly.xci
Go outside, and test your new navigation tool to compliment your flight deck. Happy flying with loads of battery time 🙂
Tips:
I made two holes on the bottom side of the Kobo, to get the 3mm Nuts in, so I could bolt down the cover. Maybe you can get it working with 2mm bolts and nuts….
Only remove the Circuit Board screws. Do not remove the screws that hold the screen in. Leave the screen in the device during the entire modification process. Keep all wires above the circuit board, else the screen will not function correctly as it relies on a certain amount of pressure around the perimeter of the device. Look carefully under the circuit board, you will see lots of connectors around it. I initially tried to solder from under the circuit board (Easier to solder), but this cause a lot of issues with the screen touch sensitivity.
Nickly and the E-Reader still work after the modifications. If yours does not. Restore the SD card from a backup you made and go through the software modification again. e.g. 1. Copy the koboroot file to .kobo -> Reboot -> Customise XCSoar -> Nickel should work again.
if you ever reset the device with a long press on the power button, it may break Nickel and you can only use XCSoar without the e-reader. The symptom is Nickel will show a black screen.
Hi,
We recently migrated all our content from Ooyala to JWPlayer Hosted Platform. We needed a .NET tool to perform the following:
Currently JWPlayer Management API only has a PHP and Python 2.7 Client as examples for Batch Migration.
To use in Visual Studio:
I have created an Open Source JWPlayer.NET library. Please feel free to improve on it e.g. Make it fluent.
Get Source Code (JWPlayer.NET)
Below is how you can use the API as at 29/06/2017.
var jw = new Jw(ApiKey, ApiSecret); var parameters = new Dictionary<string, string> { {"sourceurl", "http://www.sample-videos.com/video/mp4/720/big_buck_bunny_720p_1mb.mp4"}, {"sourceformat", "mp4"}, {"sourcetype", "url"}, {"title", "Test"}, {"description", "Test Video"}, {"tags", "foo, bar"}, {"custom.LegacyId", Guid.NewGuid().ToString()} }; var result = jw.CreateVideo(parameters);
var jw = new Jw(ApiKey, ApiSecret); var parameters = new Dictionary<string, string> { {"video_key", "QxbbRMMP"}, {"title", "Test Updated"}, {"tags", "foo, bar, updated"}, }; var result = jw.UpdateVideo(parameters);
var jw = new Jw(ApiKey, ApiSecret); var basicVideoSearch = new BasicVideoSearch {Search = "Foo", StartDate = DateTime.UtcNow.AddDays(-100)}; var result = jw.ListVideos(basicVideoSearch); var count = result.Videos.Count;
Ensure you stick to the Rate Limit of 60 calls per minute, or call your JWPlayer Account Manager to increase it.
for(var i = 0; i < lines.count; i++) { jw.CreateVideo(parameters); Thread.Sleep(TimeSpan.FromSeconds(1)); }
Wind Vectors have a U (Eastward) and V (Northward) Component.
Below is the code in C# to calculate the resultant wind
public struct Wind
{
public Wind(float speed, float direction)
{
Speed = speed;
Direction = direction;
}
public float Speed { get; set; }
public float Direction { get; set; }
}
public static Wind CalculateWindSpeedAndDirection(float u, float v)
{
if(Math.Abs(u) < 0.001 && Math.Abs(v) < 0.001)
return new Wind(0,0);
const double radianToDegree = (180 / Math.PI);
return new Wind(
Convert.ToSingle(Math.Sqrt(Math.Pow(u, 2) + Math.Pow(v, 2))),
Convert.ToSingle(Math.Atan2(u, v) * radianToDegree + 180));
}
Test Code
[TestCase(-8.748f, 7.157f, 11.303f, 129.29f)]
[TestCase(-4.641f, -3.049f, 5.553f, 56.696f)]
[TestCase(10f, 0f, 10f, 270f)]
[TestCase(-10f, 0f, 10f, 90)]
[TestCase(0f, 10f, 10f, 180f)]
[TestCase(0f, -10f, 10f, 360f)]
[TestCase(0f,0f,0f,0f)]
[TestCase(0.001f, 0.001f, 0.0014142f, 225f)]
public void CanConvertWindVectorComponents(float u, float v, float expectedWindSpeed, float expectedWindDirection)
{
var result = MetraWaveForecastLocationModel.CalculateWindSpeedAndDirection(u, v);
Assert.AreEqual(Math.Round(expectedWindDirection,2), Math.Round(result.Direction,2));
Assert.AreEqual(Math.Round(expectedWindSpeed,2), Math.Round(result.Speed,2));
}
You are running a Windows Forms application that runs as a System Tray. You have a few notifications that you would like to show the user.
However, what good is notifications, if the user is on the Loo? She will not see them.
Run a timer that detects when the user is active on the machine, and then show the notification or other task you would like to provide.
Below is the sample code that will do this for you. Of course for your production environment you would use a timer of some sort or event subscription service.
I have tested this by using other applications whilst the program monitors my input and it is safe to say it works across all my applications, even when the screen is locked.
So you might want to deal with an issue where the screen is locked but the user is moving the mouse. However such an issue is an edge case that is unlikely to happen.
I know the MSDN mentions that GetLastInputInfo is not system wide, however on my Windows 10 machine, it does seem to be the case that it is system wide.
using System;
using System.Runtime.InteropServices;
using System.Timers;
namespace MyMonitor
{
class Program
{
private static Timer _userActivityTimer;
static void Main()
{
_userActivityTimer = new Timer(500);
_userActivityTimer.Elapsed += OnTimerElapsed;
_userActivityTimer.AutoReset = true;
_userActivityTimer.Enabled = true;
Console.WriteLine("Press the Enter key to exit the program at any time... ");
Console.ReadLine();
}
private static void OnTimerElapsed(object sender, ElapsedEventArgs e)
{
Console.WriteLine($"Last Input: {LastInput.ToShortTimeString()}");
Console.WriteLine($"Idle for: {IdleTime.Seconds} Seconds");
}
[DllImport("user32.dll", SetLastError = false)]
private static extern bool GetLastInputInfo(ref Lastinputinfo plii);
private static readonly DateTime SystemStartup = DateTime.Now.AddMilliseconds(-Environment.TickCount);
[StructLayout(LayoutKind.Sequential)]
private struct Lastinputinfo
{
public uint cbSize;
public readonly int dwTime;
}
public static DateTime LastInput => SystemStartup.AddMilliseconds(LastInputTicks);
public static TimeSpan IdleTime => DateTime.Now.Subtract(LastInput);
private static int LastInputTicks
{
get
{
var lii = new Lastinputinfo {cbSize = (uint) Marshal.SizeOf(typeof(Lastinputinfo))};
GetLastInputInfo(ref lii);
return lii.dwTime;
}
}
}
}
Bootcamp with Windows on one partition and OSX on another.
A great way to manage your Windows Azure environment is to use a Docker Container, instead of powershell.
If you are new to automating your infrastructure and code, then this will be a great way to start on the right foot from day one.
Docker is an open platform for developing, shipping, and running applications. Docker enables you to separate your applications from your infrastructure so you can deliver software quickly. With Docker, you can manage your infrastructure in the same ways you manage your applications. By taking advantage of Docker’s methodologies for shipping, testing, and deploying code quickly, you can significantly reduce the delay between writing code and running it in production.
After Installing Docker
1. Use bootcamp to boot back into OSX.
2. In OSX restart the machine (warm restart)
3. Hold the Options key down to boot back into Windows
The above looks like a waste of time, However, this will enable Virtualisation in the Bios of the Macbook, since OSX does this by default and windows will not. So it is a small hack to get virtualisation working via a warm reboot from OSX back to Windows.
Run the following command:
docker run -it microsoft/azure-cli
The above command will connect to the Docker Repository and download the image to run in a container. This is basically a virtualized environment where you can now manage your windows environment from.
Run the following command:
Azure Help
Look carefully at the image below. Powershell was used to run Docker. However once I run Docker, look at my prompt (root@a28193f1320d:/#). We are now in a Linux virtual machine (a28193f1320d) and we now have total control over our Azure resources from the command line.
Docker in Windows
Now, the Linux guys will start having some respect for us Windows guys. We are now entering an age where we need to be agnostic to technology.
Below we are now running a full blown Kernel of Linux in a Windows Powerhsell prompt.
What is even cooler, we are using a Linux VM to manage the Azure environment, and so we get awesome tools for free.
Good Habits
By using docker with the Azure Command Line interface, you will put yourself into a good position by automating all your infrastructure and code requirements.
You will be using the portal less and less to manage and deploy your azure resources such as Virtual Machines, Blobs and Permissions.
Note, we are now using ARM – Azure Resource Management, some features in ARM will not be compatible with older Azure deployments. Read more about ARM.
Conclusion
You can deploy, update, or delete all the resources for your solution in a single, coordinated operation. You use a template for deployment and that template can work for different environments such as testing, staging, and production. Resource Manager provides security, auditing, and tagging features to help you manage your resources after deployment.
CLI Reference
help: Commands: help: account Commands to manage your account information and publish settings help: acs Commands to manage your container service. help: ad Commands to display Active Directory objects help: appserviceplan Commands to manage your Azure appserviceplans help: availset Commands to manage your availability sets. help: batch Commands to manage your Batch objects help: cdn Commands to manage Azure Content Delivery Network (CDN) help: config Commands to manage your local settings help: datalake Commands to manage your Data Lake objects help: feature Commands to manage your features help: group Commands to manage your resource groups help: hdinsight Commands to manage HDInsight clusters and jobs help: insights Commands related to monitoring Insights (events, alert rules, autoscale settings, metrics) help: iothub Commands to manage your Azure IoT hubs help: keyvault Commands to manage key vault instances in the Azure Key Vault service help: lab Commands to manage your DevTest Labs help: location Commands to get the available locations help: network Commands to manage network resources help: policy Commands to manage your policies on ARM Resources. help: powerbi Commands to manage your Azure Power BI Embedded Workspace Collections help: provider Commands to manage resource provider registrations help: quotas Command to view your aggregated Azure quotas help: rediscache Commands to manage your Azure Redis Cache(s) help: resource Commands to manage your resources help: role Commands to manage role definitions help: servermanagement Commands to manage Azure Server Managment resources help: storage Commands to manage your Storage objects help: tag Commands to manage your resource manager tags help: usage Command to view your aggregated Azure usage data help: vm Commands to manage your virtual machines help: vmss Commands to manage your virtual machine scale sets. help: vmssvm Commands to manage your virtual machine scale set vm. help: webapp Commands to manage your Azure webapps help: help: Options: help: -h, --help output usage information help: -v, --version output the application version help: help: Current Mode: arm (Azure Resource Management)
Hosting your code in AWS CodeCommit has several advantages, the main one being seamless integration with AWS CodeDeploy and AWS CodePipeline.
I use SourceTree as my repo tool of choice, with Git/Bitbucket as the back end.
If you have a team of many developers and want to slowly migrate your code to AWS CodeCommit Git repo, you can setup your SourceTree config to push to both repo’s.
1. You will need a SSH-2-RSA 2048 Public/Private keys, this is what AWS supports. So once you have generated/imported the keys to AWS, you can then import the same key to your gihub or bitbucket account. Then just add them to your pageant. Read Setting Up AWS CodeCommit
2. In AWS, when you import your SSH keys for a IAM User, it will give you a SSH Key ID. Write down this SSH Key ID and the password for it will be the private key password you generated with PuttyGen. Always use a password for your private key file.
AWS IAM User SSH Key
3. In SourceTree, go to Tools/Options and set the private key to your AWS SSH Key. Remember we added this to Bitbucket and Git, so we can now use the AWS SSH Key/Pairs for both repositories.
SourceTree Private Key
The last part, is to configure your local repo to post to both repositories, until you happy with the migration.
4. In SourceTree, select your repository, and go to Repository/Repository Settings. Then add a new origin. It will be in this format: ssh://git-codecommit.us-east-1.amazonaws.com/v1/repos/MyCoolApp
5. When it prompts for a username and password, enter your SSH Key ID and SSH private key password
Source Tree Remote
Once you happy with the migration, you can then set AWS CodeCommit as the default remote, by ticking the checkbox. You may need to first rename the original remote “origin” to “old” then set AWS as the default 🙂
My only gripe with CodeCommit is no built in hooks to deploy directly to S3. This would be great for static assets.
#CodeCommit #AWS
We are nearing an inflection point regarding technology and data. Data is basically gold. In the next 30 years you will basically have a life logger app and many connected/smart devices. You will be able to rewind back in time and listen/look at a conversation you had with a random guy you met at a party.
You will punch into the Amazon Life Timeline service “Go to when a met a man wearing a shirt with Sponge Bob on it”. You wait a few seconds and a video appears at the exact moment you met the guy at a party.
Our lives will be transparent, our ego will be lowered, because we as a species are happy to share and be transparent. We will tip towards transparency and away from privacy, why? Because if we do not, we create a stumbling block in our technological evolution. Data is king, and this is the fundamental reason why companies pay so much for apps.
Google is not a search engine, it is going to be the most powerful artificial intelligent service offering in the world. One day you will use Google’s AI to optimize your life. It will track how you drive, when you sleep, when you come home; and by doing so, will have enough data collection points to run AI routines on your data and provide you with awesome benefits.
Likewise, Amazon Machine Learning services will be our AI friend.
As programmers we going to need to store data about data or data about the bits that we send to the internet… Metadata.
One way to do so is by asynchronous messaging. You will of course have an App/Smart Device that needs to send data or metadata about user behavior.
Your app can send small data messages as a user is consuming your service to an Amazon Queue on the cloud.
using System;
using System.Collections;
using System.Collections.Generic;
using System.Web;
using Amazon;
using Amazon.Runtime;
using Amazon.SQS;
using Amazon.SQS.Model;
using Amazon.Util;
namespace Wangle.Queue.Client
{
public class AwsClient : IQueueClient
{
private AmazonSQSClient _client;
private string defaultQueueUrl;
public void Initialize(string url)
{
ProfileManager.RegisterProfile("Wangle", "myaccessKey","mysecretkey");
var amazonSqsConfig = new AmazonSQSConfig { ServiceURL = "http://sqs.us-east-1.amazonaws.com" };
_client = new AmazonSQSClient(ProfileManager.GetAWSCredentials("Wangle"), amazonSqsConfig);
defaultQueueUrl = url;
}
public void SendMessage(string message)
{
var sendMessageRequest = new SendMessageRequest
{
QueueUrl = defaultQueueUrl,
MessageBody = $"{message} + {DateTimeOffset.UtcNow}" //Unicode Only!
};
_client.SendMessageAsync(sendMessageRequest);
}
public IList&lt;string&gt; ReceiveMessage()
{
var data = new List&lt;string&gt;();
var receiveMessageRequest = new ReceiveMessageRequest
{
QueueUrl = defaultQueueUrl,
MaxNumberOfMessages = 10,
};
var receiveMessageResponse = _client.ReceiveMessage(receiveMessageRequest);
receiveMessageResponse.Messages.ForEach(m =&gt;
{
var receiptHandle = m.ReceiptHandle;
data.Add(m.Body);
_client.DeleteMessageAsync(defaultQueueUrl, receiptHandle);
});
return data;
}
}
}
Once the message is now in the message queue in the cloud, you will have a service in the cloud process this message and store it a Big Data Service. Below is the code to get the the message off the queue.
class Program
{
static void Main(string[] args)
{
//Fake a worker role service running in Amazon Cloud that processes data storage.
Console.WriteLine("Fetching data logs from queue to prepare for governance...");
var queueClient = new AwsClient();
queueClient.Initialize(Settings.Default.QueueURL);
while (true)
{
queueClient.ReceiveMessage().ToList().ForEach(m => Console.WriteLine(m));
//ToDo: Store the audit data in AmazonS3 or Big Data service: User, Url, DateTimeUtc, SourceIP, DestIP
Thread.Sleep(TimeSpan.FromSeconds(2));
}
}
}
So that is basically the code you need. Of course you will need to install the Amazon Service SDK from Nuget.
This should get you going in the right direction when you need to send data to the cloud over the wire for later processing.
I am sure Amazon SQS will be used to start sending data asynchronously for Fitbit information, how long you sleep for, how you drive your car and many more. Soon all our devices will be smart e.g. A cooking pot with a chip, your shirt with a chip …
See you soon in VR land…
