Adam H

1

votes
1

answer
51

views

Speeding Up a User Defined Function

I have user defined function that is tied to 2 other user defined functions and when I update the cell it can take several minutes (5-10) as the file has up to 400k cells, and it is is running through 2 other custom functions to create a date format we use at my work. It seems to be looping through...
Adam H
1

votes
4

answer
1k

views

A little advice on C# - Excel interoperation

Good Afternoon Fellas, A little advice would be appreciated, I'm approaching a problem by which I need to write an agent which will go to a particular file directory, open an Excel Workbook (which already exists) and will then change the value of two cells (which are always the same cells) to be the...
Adam H
1

votes
1

answer
470

views

Android Studio and Gradle Living Together?

I'm poking around with the new Android Studio. I have had no problem building (via an export/import) my project, but I have a question concerning how I can do things via the command line. I do not see a packaged stand-alone executable of gradle with Android Studio. What is the correct approach to ru...
Adam H
1

votes
1

answer
282

views

Google sheets return a string of concatenated values from a range based on value

I appreciate this question might be on the incorrect Stackexchange website but this is the one I frequent most often and wasn't sure of a more appropriate one - so feel free to move it mods if required. Basically I have the following scenario: What I'm trying to do in Google sheets is write a formul...
Adam H
1

votes
1

answer
393

views

How to query an XML field with a date filter

I have an XML field that I'm trying to query. I figured out how to return the first item, second, etc. I need to figure out how to return the item based on a date filter. A date is included in the XML field but I can't figure out the format. Here is an example of the XML field called [AMOUNT]. I can...
Adam H
1

votes
1

answer
312

views

Django Rest - “<ClientProfile: [email protected]>” needs to have a value for field “clientprofile” before this many-to-many relationship can be used

I'm trying to implement an API where I can: Return all ClientProfile objects, with a nested ManytoMany field containing a list of Location objects (I don't really care if it's PK or actual object, actual object would be nice.) Be able to POST a ClientProfile object, and specify which Location object...
Adam H
1

votes
1

answer
66

views

Unit Testing Class That Wraps HttpClient

I am in the process of writing unit tests for a new project we've created and one of the issues I've come across is how to properly unit test something that effectively wraps HttpClient. In this case, I have written a RestfulService class that exposes basic methods for calling a REST service from C#...
Adam H
1

votes
1

answer
0

views

VueJS - View models, children and updating values

I am attempting to learn VueJS and have come across what seems to be a very basic problem. I have lots of experience with Knockout and Mustache and I think that might be what is causing me problems. I am attempting to build a simple checkbox list to play around with the binding but my model isn't up...
Adam H
1

votes
1

answer
0

views

UIAlertView button option to open new view

I’m creating a tab based application. One of the tabs is test, and another of these tabs is results. When the user has completed all the questions a UIAlertView message box pops up saying “Test Finished” and displays a “Ok” button to dismiss this message. I’m wanting to change the title...
Adam H
1

votes
1

answer
0

views

Passing client data to server to create Excel or CSV File

I think what I have may actually be a design issue rather than a technical issue, but either way I've seem to a hit a wall in both my ability and understanding to get past this problem. I'm creating a reporting web page as part of a standard VB.NET web application. The page is data driven, with jque...
Adam H
1

votes
2

answer
5.3k

views

Connection between IIS App Pool Identity and SQL Server

I've developed a very basic WCF service (WCF 4.0) in VS 2012. I have the AdventureWorks2012 database hosted in SQL Server 2012 and I am using IIS 7 with .Net 4.0 framework installed. When I run the service in the local development IIS with VS 2012, everything works fine (I assume because the connect...
Adam H
1

votes
2

answer
874

views

Move UIBarButtonItem few pixels down?

I have created a custom UINavigationBar which is a tiny bit taller than Apples default navigation bar. I can’t seem to find a way to move the UIBarButtonItem down to be directly centered between the two dashed lines. Is there an easy way to do this? I’ve tried creating a custom button but had n...
Adam H
1

votes
0

answer
58

views

How to properly use slot inside of vue js web component and apply styles

I have come across an issue where the implementation of slots in a webcomponent is not functioning as expected. My understanding of Web Components, Custom Elements and Slots is that elements rendered in a slot should inherit their style from the document and not the Shadow DOM however the element in...
Adam H
1

votes
1

answer
254

views

AWS Redshift: Load data from many buckets on S3

I am trying to load data from two different buckets on S3 to Redshift table. In each bucket, there are directories with dates in their names and each of directories contains many files, but there are not manifest. Example S3 structure: # Bucket 1 s3://bucket1/20170201/part-01 s3://bucket1/20170201/p...
Adam H
1

votes
1

answer
121

views

Trouble deserialising xml file using DataContractSerializer

It's been awhile since i've used DataContractSerializer and i'm having a little trouble deserializing a xml file. The error i'm getting is: {'Error in line 1 position 117. Expecting element 'SoftwareLicense' from namespace 'http://schemas.datacontract.org/2004/07/Solentim.Modules.Licensing.Activatio...
Adam H
1

votes
3

answer
40

views

Anchor tags in HTML with scroll transitions do not correctly link to each other

So I have this fixed menu bar: I have all of these sections on one long webpage, with each link connecting to somewhere else on the page. I also have the following JavaScript, which is used to make the links scroll to their locations instead of jumping to them: However, when a user clicks a link, in...
Adam H
1

votes
1

answer
1.6k

views

React not using proxy server

I have added the proxy to the package.json in my react app, I have the proxy server up and running on port 3001 - I can hit it with my browser. I have tried using both axios and fetch, it doesn't seem to matter. Here's a link to the repo if you want to check it out. Otherwise, here is the package....
Adam H
1

votes
1

answer
99

views

Vue - Load External Components From Another Site

I am trying to retrieve a vue component from an external site and load it in my app and cannot for the life of me figure this out. Here is the full scenario; Site A (Internally Hosted Site) loads a VueJS application Site A requests a VueJS component from Site B (Internally Hosted Site, different sub...
Adam H
1

votes
1

answer
1.7k

views

CSS Animation on load and before redirect

I'm currently working on a HTML5 mobile platform and I have a landing page for my application which is tiled and is laid out as four equally sized tiles (divs) on the screen I've been messing around with CSS3 animation all afternoon and I've found something which I think can be of use if I can figur...
Adam H
1

votes
2

answer
1.9k

views

Unity3D stream audio file from disk

I'm building an audio player that needs to be able to play files from disk which aren't available at build time (so users can put their own music in). OGG/WAV files are fine and I need to support both Windows and OSX. I've tried using the WWW class as such: using UnityEngine; using System.Collection...
Adam H
16

votes
4

answer
47.5k

views

Making a control transparent

I am currently developing a simple image editing tool using Winforms and .NET 3.5 (work environment). I have a requirement that when the user clicks a select tool button, a square (rectangle in C#) will appear that they can scale between 100x100 and 400x400. I have this bit fixed - the issue comes w...
Adam H
17

votes
3

answer
15.4k

views

Variable as a column name in data frame

Is there any way to use string stored in variable as a column name in a new data frame? The expected result should be: col.name
Adam H
1

votes
1

answer
1.3k

views

Reading and Writing to a HTTP Header

Currently I've got a web application with two pages, Login and Default. I've been tirelessly trying to write 2x GUID's which are returned into a HTTP header when a login procedure is executed in the code behind on the login page. I then want to read these out in the page load of the default page. I'...
Adam H
6

votes
2

answer
10.9k

views

SSIS Package Not Running as 32bit in SQL Server 2012

I have a package that I developed in VS2012 (using the SQL Data Tools component) which collects data from a DBF file using the VFPOLEDB provider, and puts it into a database on a SQL Server 2012 X64 server. The project containing the package has the DebugOption of Run64BitRuntime set to false. I hav...
Adam H
4

votes
1

answer
2.4k

views

Scala - tuple3 - syntactic sugar

What is the syntactic sugar equivalent of following syntax: List[Tuple2[String, Int]] // Base List[String Tuple2 Int] // Syntactic sugar for Tuple3? E.g.: List[Tuple3[String, Float, Int]] // Base
Adam H
2

votes
1

answer
1.7k

views

web essentials browser link not working in asp mvc 6 project

I'm trying to get browser link working so I can use web essentials toolbar in the browser. I'd expect to see some code injected at the bottom of the page source for browser link like in ASP.NET 4 projects but this doesnt seem to be the case with ASP.NET 5. Has anyone else managed to get this workin...
Adam H
2

votes
1

answer
4.3k

views

Alignment of control widgets on fluidPage in shiny R

I am working on a shiny app, but ran into a problem with the placement of widgets depending on the size of the browser window. I am using nested column and fluidRow to place my widgets (see code below). I want the left side of widgets B and D aligned, and the right side of B and E (see Fig 1), but w...
Adam H
2

votes
2

answer
2.7k

views

Uploading xcode project to app store

I’ve been going around in circles. Any help will be appreciated. I have submitted all the application details to iTunes connect - Thats not a problem. As I went to upload my binary version I got a message telling me this is no longer possible and it needs to be uploaded through xcode? I’ve sear...
Adam H
2

votes
1

answer
142

views

Different icons?

May be a easily solvable problem but I cant seem to find a solution. I understand that you need different icon sizes for different devices as explained here ( http://developer.apple.com/library/ios/#documentation/UserExperience/Conceptual/MobileHIG/IconsImages/IconsImages.html ) But how will my app...
Adam H
2

votes
1

answer
7.4k

views

Initializing a Google Map With jQuery

I am just starting out with Google Maps API v3 and jQuery. I have made maps before with the v2 API, but it didn't use jQuery. This way will hopefully help me learn some more jQuery on the way. I am following the example on the Google Maps API Tutorial and trying to get their most basic hello world w...
Adam H
2

votes
2

answer
718

views

C# - Force Excel to ReCalc before Save

Good Morning Overflow-ers! I have been writing an agent which will open an Excel file, modify two cells and then save the workbook as well as a copy of this workbook. What I really need is for just before the save, my agent to force a recalc on the whole workbook, so that all of my queries (which ar...
Adam H
1

votes
2

answer
1.7k

views

Converting Multi-Dimensional Array to Single, with nullable Values

I am using ExcelDNA/C#/Excel primarily. What I am essentially trying to do is convert a multi-dimensional array (namely a range of cells) to a singular dimensional array, using the following code: private static string[] MultiToSingle(object[,] multiArray) { List tempList; string[] returnArray; temp...
Adam H
6

votes
4

answer
22k

views

Get the current Workbook Object in C#

I've been writing an application in C# which creates Custom Document properties in an Excel spreadsheet, I have a function for this which takes in a Workbook Object... However, actually getting the current Workbook object is proving to be quite annoying, I am using ExcelDNA to add functionality, how...
Adam H
4

votes
4

answer
4k

views

Execute code when app reopens

I have a Single View Application. When I hit the home button and ‘minimise’ the application I want to be able to execute code when the user reopens it. For some reason viewDidAppear and viewWillAppear do not execute when I minimise and reopen the application. Any suggestions? Thanks in advance...
Adam H
13

votes
6

answer
8k

views

<Error>: FT_Open_Face failed: error 85

I am trying to install a custom font into my iPhone application. When I add the 'Fonts provided by application’ key into my info.plist file I get the following error ': FT_Open_Face failed: error 85.’ I am not sure what the problem is as I have successfully been able to use custom fonts in the p...
Adam H
1

votes
2

answer
5.3k

views

Current road's speed limit

Is it possible to get the current speed limit of a road? I’m not sure if this would be done using the ‘Maps' app as I don’t think its holds speed limit data. Is anyone able to point me in the right direction?
Adam H
7

votes
2

answer
4.5k

views

Alternative to “Display:-webkit-flex” for Chrome Mobile

Lately I've been working on a mobile optimised web platform utilising HTML5/CSS3. This application has a landing page which consists of four equally sized tiles with an Icon in the middle (some other styles like a bit of padding in between them and border radius etc). These tiles are sized based on...
Adam H
7

votes
1

answer
5.6k

views

How to speed up matplotlib when plotting and saving lots of figures?

I am processing observing data from many antenna baseline. Currently what I am working is to plot ~ 40 figures, each of which has 4x5 subplot region. I found it slow when plotting and saving figures with matplotlib in loops. Here are my codes: import numpy as np import matplotlib.pyplot as plt impor...
Adam.H.Liu
2

votes
1

answer
357

views

HiveMQ RESTful Authentication Plugin

I am in the process of interfacing to a RESTful API for a proprietary server running internal to my organization. We are using HiveMQ and I have created a simple plugin based on the incredibly useful documentation over at the HiveMQ website. I have also reviewed the Caching and Non-Blocking philosop...
Adam H
2

votes
1

answer
464

views

Bundle Identifier Problem

I’m having issues generating new bundle identifiers through the provisioning profile. When I click new New App Id and enter the required details it keeps generating the same bundle id. This is what I am entering: Description: “My app name” Bundle Seed ID: “Use Team ID” Bundle Identifier:...
Adam H

View additional