Camp

i working on google sheets system shows has item. have never worked google apps script before, want check value of c2, make sheet copy of data (d2, e2, g2) here (it trying copy 2nd column) , move here (in different sheet same document) next corresponding name on each particular section i think want rotate data columns becomes rows, , rows become columns, right? what need [transpose][1] function. for example, in a2, if put =transpose('sheet 2'!c1:1) , google sheets automatically fill column values of first row of 'sheet 2', starting @ c1 position. updated answer: here working example here steps: get filtered list of timestamp matched equipment sort list it's reverse order get first item sorted list ("last date") get position of "last date" in timestamp list get item in action list @ same position "last date" if item "check out" it's not available. note: might want store result of index() ...

select distribution ratio : ratio of rows each partition should insert proportion of total possible rows partition (as defined clustering distribution columns). default fixed(1)/1 can explain means? , why called select distribution ration when under insert distribution? http://www.datastax.com/dev/blog/improved-cassandra-2-1-stress-tool-benchmark-any-schema in cassandra, data assigned given node partition key, , stored sorted on disk based on clustering key within partition. the 'distribution ratio' allows define: 1) how many rows stress tool create in each partition, 2) how many rows stress tool read each partition (they'll ordered, it's fast grab more one) in case of fixed(), means each partition have fixed number of rows - if choose of other options, you'll end variable number of rows. edit explain multiple rows per partition: for example, if had data model gathered weather information different cities: create table sensor_readings ...

i have jquery variable of array of radio elements. want further select specific element based on value. below idea of have i'm still not sure how accomplish this. var gender = 1; var radiobuttons = $('[name=\'gender\']'); //should contain 2 radio elements radiobuttons.find('[value=\'' + gender + '\']').prop('checked', true); html <label>female<input type="radio" name="gender" value="0"></label> <label>male<input type="radio" name="gender" value="1"></label> the .find() method attempt select descendant elements. since input element self-closed , doesn't contain descendant elements, nothing selected. it seems want .filter() method instead: var gender = 1; var radiobuttons = $("[name='gender']"); radiobuttons.filter(function () { return this.value === gender.tostring(); }).prop('checke...

i have function geocodes address. don't want function die trying catch error , return tuple instead. want differentiate between errors, use try/except in multiple places. is there such thing many try/except? how optimize function? here code: def geocode(address): js = '' try: urlq = urllib.urlencode({'address':address, 'sensor':'false'}) except exception, e: return (false, "error url-encoding address. error:%s" % e, js, 'failed') try: f = urllib2.urlopen(geo_url + urlq) d = f.read() except exception, e: return (false, "error making connection. error:%s" % e, js, 'failed') # try: js = json.loads(d) except exception, e: return (false, "error converting json. error:%s" % e, js, 'failed') return (true, '', js, 'ok') catching exception bad idea. want specify error want catch. ...

i trying run "nuget restore" on server not have visual studio installation. nuget.exe fails immediately. else needs installed nuget run? c:\users\kevin>nuget not load file or assembly 'system.net.http, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a' or 1 of dependencies. system cannot find file specified. not load type 'system.runtime.compilerservices.iasyncstatemachine' assembly 'mscorlib, version=4.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089'. not load file or assembly 'system.net.http.webrequest, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a' or 1 of dependencies. system cannot find file specified. had issue well. newer versions of nuget requires .net 4.5 . installing .net 4.5.2 resolved issue me.

i have dataset consisting of around 10000 samples 2 features. use elki run lsdbc algorithm , cluster dataset. however, have not been able elki work. after running elki-0.7.0.jar , inputing desired settings gui, regardless of settings pick, long stream of error messages in console input @ bottom of gui (i have yet able enter of desired settings). me indicates missing dependency, missed installation step, or somehow not using software correctly. unfortunately, there doesn't seem lot of documentation on elki, has 1 of implementations of lsdbc have been able find. i'm looking step step, eli5, instructions install , run algorithm on dataset (which in arff file created weka) , output results csv file; namely output file indicating cluster assignment of each sample. additionally able perform grid search optimal k , alpha values (that is, run algorithm several values of k , alpha , save each of results; afterwards determine optimal values). using mac os x yosemite. i fee...

i have 15k rows each has 3 column similar following structure. id title description 0 short title long description column i want capitalize every single word in title column appear as: a short title is there way achieve this? =proper(b2) the formula can capitalize every 1st character of every word in string. edit: if want manually, copy formula across column that. can goto cell containing formula. on bottom right corner, see + sign when hover on cell - double click bottom right corner when see that. this copy formula rows underneath current one, till finds there data in column preceding it. edit2: using code option explicit sub changeallcellsinthiscolumntopropercase(byval startcell range) dim lastcell range set lastcell = startcell.end(xldown) dim data dim rangetocover range set rangetocover = range(startcell.address & ":" & lastcell.address) data = rangetocover.value dim countofcells long countofcells = rangetocover.cells.cou...

i’d security rule lets list of users , read names, allows logged in users view own email. here’s example data structure: "user" : { "abc123" : { "name" : "bob", "email" : "bob@hotmail.com" } } a naive approach security rule might following: "user" : { "$user" : { "name" : { ".read" : true }, "email" : { ".read” : "auth.uid === $user" } } } however because there no read rule @ user level, requests read list denied. adding read rule @ user level override email rule, , make every child node readable (see rules cascade in firebase's security guide). the security guide point out rules not filters , doesn’t offer guidance it. should split user entity privateuser , publicuser? to let list of users , read names. , allow logged in ...

i'm looking solution load data sqlite in cordova bootstrap, more in $ionicplatform.ready until here don't have solution. see piece of code (i'm using ionic $cordovasqlite): app.js file ... app.run(function($db, $log, params...){ $ionicplatform.ready(function() { ... $db.init().then(function(res){ // here need load user $rootscope.user = res; $log.debug('1 step = user loaded'); }); $rootscope.$on('$statechangestart', function(event, tostate, toparams){ $log.debug('2 step = use user loaded!'); var _requireauth = tostate.data.requireauth; if(_requireauth && !$rootscope.user){ event.preventdefault(); $state.go('login'); } }); }); ... db.js file app.factory('$db', function($q, $cordovasqlite, params...){ ... _self.init = function(){ ...

i'm looking @ moving vanilla backbone marionette and, backbone, first concern make sure don't have memory leaks since i'm building 1 page application. using backbone debugger, can see when change view displayed in layoutview region, html indeed destroyed model and/or collection remain in memory forever. first, here's postcontroller code: var postcontroller = marionette.object.extend({ showone: function(post_cd){ // layoutview var postview = new postview(); // create data containers var comments = new comments(); // backbone.collection var post = new post(); // backbone.model // create subviews (compositeview) var commentsview = new commentsview({collection: comments, model: post}); // render compositeview in layoutview when displaying layoutview postview.on('before:show', function(region, view, options){ this.showchildview('comments', commentsview); ...

i save transaction : {code: "a", total: 250000, timestamp: isodate("2016-01-20t23:57:05.771z")}, {code: "b", total: 300000, timestamp: isodate("2016-01-20t05:57:05.771z")} each of transaction has timestamp field under utc timezone in it. since live in jakarta (utc+7) timezone, need add 7 hours timestamp before aggregation. here's mongo syntax: db.transaction.aggregate( [ { $project: { year: { $year: "$timestamp" }, month: { $month: "$timestamp" }, day: { $dayofmonth: "$timestamp" } } } ]) it returns: { "_id" : objectid("56a01ed143f2fd071793d63b"), "year" : 2016, "month" : 1, "day" : 20 }, { "_id" : objectid("56a01ed143f2fd071793d63b"), "year" : 2016, "month" : 1, "day" : 20 } which wr...

in problem detecting empty request_uri apache mod_rewrite , mentioned can use rewritecond %{request_uri} ^.$ or rewritecond %{request_uri} "^/$" i need check if not empty, redirect empty one(ignore string after http_host). i tried rewritecond %{request_uri} !"^/$" rewriterule .* http://%{http_host} [l,r=301] but not work. caused endless loop. also tried rewritecond %{request_uri} !^/$ rewritecond %{request_uri} !^\/$ rewritecond %{request_uri} "!^/$" rewritecond %{request_uri} "!^\/$" how just: rewriterule ^/.+$ http://% {http_host} [l,r=301]

i have scatter chart demonstrate load servers 2 dimensions , x , y. and define 2 plot lines show if point overload, demo shows(just quick demo , copy link): "http://codepen.io/anon/pen/xzprwa" while, need demonstrate generated quadrant means labels like: but can't find methods/options api achieve this, there simple method this? find position , put label absolute position? you can define plotlines per x , y axis , catch load event. inside function, should extract position of lines , use renderer print labels. last step calculate osition proper quarter (by comparing plotlines , checking width of label - getbbox - function). chart: { events: { load: function() { var chart = this, r = chart.renderer, each = highcharts.each, left = chart.plotleft, top = chart.plottop, h = chart.plotheight, w = chart.plotwidth, xaxis = chart.xaxis[0], yaxis = chart.yaxis[0], labels = [...

question: yikyak.com returns sort of "browser not supported" landing page when try view source code in chrome (even page i'm logged in on) or when write out python terminal. why , can around it? edit clarification: i'm using chrome webdriver. can navigate around yik yak website clicking on fine. whenever try see html on page, html page "browser not reported" page. background: i'm trying access yikyak.com selenium python download yaks , fun things them. know little web programming. thanks! secondary, less important question: if you're here, there particularly great free resources super-quick intro certification knowledge need store logins , stuff use logged in account? awesome. i figured out. being dumb. saved off html file , opened file chrome , displayed normal page. didn't see fact normal page looking @ directly. 15 people time.

need regex periods that's not between 2 numbers it should match happy1... hello, world. but should not match: 1.2 holiday this work you: ((?<!\d)\.|\.(?!\d)) it matches period isn't preceded digit ( (?<!\d)\. ) or ( | ) isn't followed 1 ( \.(?!\d) ). actual python code: import re p = re.compile(ur'((?<!\d)\.|\.(?!\d))') test_str = u"happy1...\nhello, world.\n1.2\nholiday" re.findall(p, test_str) demo please note: in future, should post have tried , why isn't working. questions seeking debugging (" why isn't code working? ") must include desired behavior, specific problem or error , the shortest code necessary reproduce in question itself . questions without a clear problem statement not useful other readers. see: how create minimal, complete, , verifiable example.

all, hello! doesn't work change css attribute. help, please! $('#container_logo p').hover( function(){ $(this).animate( { text-shadow: "#363535 10px 10px 10px" }, 5000); }, function(){ $(this).animate( { text-shadow: "#363535 1px 1px 1px" }, 5000); }); here http://jsfiddle.net/pznwx/3/ you try css #container_logo p { -webkit-transition:text-shadow 5s ease-in-out; -moz-transition:text-shadow 5s ease-in-out; -o-transition:text-shadow 5s ease-in-out; -ms-transition:text-shadow 5s ease-in-out; transition:text-shadow 5s ease-in-out; text-shadow:#363535 1px 1px 1px; } #container_logo p:hover { text-shadow:#363535 10px 10px 10px; }

i'm having problem assert_select in users_login_test in 8.3 of michael hartl's ruby on rails tutorial. this test: test "login valid information followed logout" login_path post login_path, session: { email: @user.email, password: 'password' } assert is_logged_in? assert_redirected_to @user follow_redirect! assert_template 'users/show' assert_select "a[href=?]", login_path, count: 0 assert_select "a[href=?]", logout_path assert_select "a[href=?]", user_path(@user) delete logout_path assert_not is_logged_in? assert_redirected_to root_url follow_redirect! assert_select "a[href=?]", login_path assert_select "a[href=?]", logout_path, count: 0 assert_select "a[href=?]", user_path(@user), count: 0 end when run test 1 failure: fail["test_login_with_valid_information_followed_by_logout", userslogintest, 2016-01-20 09:51:41 +0...

i want upload excel file wordpress outside php file script .i tried search not got. can 1 me in this? if ( !function_exists('media_handle_upload') ) { require_once(abspath . "wp-admin" . '/includes/image.php'); require_once(abspath . "wp-admin" . '/includes/file.php'); require_once(abspath . "wp-admin" . '/includes/media.php'); } $url = "http://example.com/demo.xls"; $tmp = download_url( $url ); if( is_wp_error( $tmp ) ){ // download failed, handle error } $post_id = 1; $desc = "description"; $file_array = array(); // set variables storage // fix file filename query strings preg_match('/[^\?]+\.(jpg|jpe|jpeg|xls|png)/i', $url, $matches); $file_array['name'] = basename($matches[0]); $file_array['tmp_name'] = $tmp; // if error storing temporarily, unlink if ( is_wp_error( $tmp...

firstly, english skill poor i`m sorry that i made code hide private functions & vars other db_obj.js module.exports = (function() { var _mysql = require('mysql'); var _self = null; var _connflag = false; var _mysqlconfig = { host: "127.0.0.1", port: 3306, user: "tester", password: "*****", database: "*****" }; var _conn = null; var _init = function(){ _conn = _mysql.createconnection(_mysqlconfig); _conn.connect(function(err) { if (err) { console.log(err); } _connflag = true; }); }; var db_obj = function (args) { _self = this; if (args) { _mysqlconfig.host = (args["host"]) ? args["host"] : "127.0.0.1"; _mysqlconfig.port = (args["port"]) ? args["port"] : "3306"; _mysqlconfig.user = (args["user"]) ? args["user"] : "...

in model have start , end date , need compare start , end dates.i added validation rules format , custom validation rules compare [['start_date','end_date'], 'date', 'format' => 'yyyy-m-d'], ['start_date','validatedates'], public function validatedates(){ if(strtotime($this->end_date) <= strtotime($this->start_date)){ $this->adderror('start_date','please give correct start , end dates'); $this->adderror('end_date','please give correct start , end dates'); } } i tried format validation [['start_date','end_date'], 'date', 'format' => 'php:y-m-d'], in view file customized start , end date design <?= $form->field($quote, 'start_date',['template' => '{label}{input}<p class="help-block help-block-error">{hin...

this question has answer here: find current directory , file's directory 15 answers i have python script reads input file supposed in same directory of script: with open('./input1.txt') file: f = file.readlines() do_stuff(f) i run script other directories (not directory script , input files reside), raises ioerror can't find input file (as not in current working directory). don't prefer putting full path input file since want portable- both script , input files have in same directory. is there way indicate script in location directory not directory launching from? __file__ path of script, albeit relative path. use: import os.path scriptdir = os.path.dirname(os.path.abspath(__file__)) to create absolute path directory, use os.path.join() open file: with open(os.path.join(scriptdir, './input1.txt')) openfile: ...

i using xcode 7.2 today notice strange behavior in simulator. whenever opening uialertviewcontroller actionsheet or default type simulator slow-motion animations on ( ⌘ + t ) mode on simulator after app not responding time can not able user activity few second (around 20 second). issue of using swift reference can create demo using following code uialertviewcontroller @ibaction func alertshow(){ let alertcontroller = uialertcontroller(title: "title", message: "message", preferredstyle: .alert) alertcontroller.addaction(uialertaction(title: "ok", style: .default, handler: nil)) self.presentviewcontroller(alertcontroller, animated: true, completion: nil) } try allocating uialertcontroller earlier let in viewdidload, use object in ibaction function, works fine me

i need mail xml validation reports html content mail. how keep below detailed information(derived parent class)as html body using java mail api. //exact requirement: title : car validation report //background color : orange //font color : black 1.total no of errors : 12 2.total no of warnings : 150 car validation successful. my java code mail: mimemessage message = new mimemessage(session); m_toterr=validatexml.total_err; message.setfrom(new internetaddress(from)); message.addrecipient(message.recipienttype.to, new internetaddress(to1)); //message.addrecipient(message.recipienttype.cc, new internetaddress(to2)); //message.addrecipient(message.recipienttype.bcc, new internetaddress(to3)); //message.addrecipient(message.recipienttype.bcc, new internetaddress(to4)); message.setsubject("re : car ...

i have list of services extend abstractservice class. abstractservice holds dao (you can call "repository") , has getter/setter dao: /** * @param <t> entity type * @param <k> entity id type * @param <s> dao type */ public abstract class abstractservice<t, k extends serializable, s extends basedao<t, k>> implements baseservice<t, k> { private s dao; public s getdao() { return dao; } public void setdao(s dao) { this.dao = dao; } // common methods services, using dao, instance @override public optional<t> findone(k key) throws dataexception { return optional.ofnullable(dao.findone(key)); } } a service example: @service public class employeeserviceimpl extends abstractservice<employee, integer, employeedao> implements employeeservice { // specific methods service } the related dao (i use spring data jpa): public interface employeedao extends basedao<employee, integer...

i trying query data orientdb while ignoring edges. my query has form: select expand(dijkstra(#12:15,#12:20,'property','both')) but mentioned want ignore edges of graph. are there suggestions? edit here graph structure . station vertex image click path edge image click thank @ivan mainetti answer have try testing main() here main() string nomedb = "demo2"; try { system.out.println("before connect oserveradmin"); oserveradmin serveradmin = new oserveradmin("remote:128.199.xxx.xxx/"+nomedb).connect("admin","password"); system.out.println("after connect"); if(serveradmin.existsdatabase()){ // il db esiste system.out.println("in if"); //connessione db orientgraph g = new orientgraph("remote:128.199.xxx.xxx/"+nomedb); dijkstraexcl d = new dijkstraexcl(g, "path", "distance...

when minimal osx application has nothing else plain (unconfigured) nsoutlineview in storyboard, heavily leak memory. view controller implementation the view controller implemented following: import cocoa class section { let title: string let items: [string] init(title: string, items: [string]) { self.title = title self.items = items } } class viewcontroller: nsviewcontroller, nsoutlineviewdatasource, nsoutlineviewdelegate { //mark: nsoutlineviewdatasource let items = [ section(title: "alpha", items: ["anton", "anita"]), section(title: "beta", items: ["bernd", "barbara"]), section(title: "gamma", items: ["gustav", "gesine"])] func outlineview(outlineview: nsoutlineview, numberofchildrenofitem item: anyobject?) -> int { switch item { case nil: return items.count case section: ret...

i have ajax post method if success alert "account created". problem when it's not created should alert account exists, problem still alert same. script code: $(document).ready(function(){ $("#btn-register").click(function(){ var regaccount = $("#regaccount").val(); var regpass = $("#regpass").val(); if((regaccount == "") || (regpass == "")){ alert("information required!"); }else { $.ajax({ type: "post", url: "register.php", data: "regaccount="+regaccount+"&regpass="+regpass, success: function(data){ alert("account created!"); }, error:function(){ alert("account exists"); } }); } $("#regaccount").val(''); $("#...

i trying set image imageview item in listview. listview contains items has imageviews in them. trying change imageview of first item in list. crop_donebtn.setonclicklistener(new view.onclicklistener() { @override public void onclick(view v) { final bitmap croppedimage = cropimageview.getcroppedimage(); //instance of adapter profileadapter adapter = new profileadapter(eyewerprofile.this, listdata) { @override public view getview(int position, view convertview, viewgroup parent) { view view = super.getview(position, convertview, parent); //the imageview need imageview userpic = (imageview) view.findviewbyid(r.id.userpic); userpic.setimagebitmap(croppedimage); ...

i have piece of code in jsp show map using osm (openstreetmap, collaborative project create free editable map of world) see white lines in map <div class="windowcontentmap" > <div id="map" style="width: 97%; height: 94%"></div> <script src="http://www.openlayers.org/api/openlayers.js"></script> <script> var lat = '${lat}'; var lon = '${lng}'; var zoom = 9; var fromprojection = new openlayers.projection("epsg:4326"); // transform wgs 1984 var toprojection = new openlayers.projection("epsg:900913"); // spherical mercator projection var position = new openlayers.lonlat(lon, lat).transform( fromprojection, toprojec...

i have webpage generated same div according categories in database using simple query. in case there 2 categories. each div has button when clicked should change text of current divs titletext. <body> <div class="domparent" style="width: 100%; border: 1px solid #ff0000; margin: 10px; padding:10px;"> <div class="title"> <div class="titletext">category 1</div> <button id="btn">id="btn" click me</button> </div> </div> <div class="domparent" style="width: 100%; border: 1px solid #ff0000; margin: 10px; padding:10px;"> <div class="title"> <div class="titletext">category 2</div> <button id="btn">id="btn" click me</button> </div> </div> <script> dp("#btn").click(function(){ dp(".title...

i wondering if possible submit same app in regular itunes store in custom b2b store? we've got app general public pay give free people purchased product of ours... the simple answer no. once app custom b2b, it's custom b2b. but: you can create new app different name , submit app appstore. example: custom b2b app name: com.yourcompany.appname new app in appstore: com.yourcompany.app-name i'm not sure how different names need can experiment until find name appstore take.

i have 1 text box allow user key in value decimal value. how set in text box can enter 2 decimal places . now, user can key in more 2 decimal places. below code text box: <td><b>payment amount:</b></td> <td colspan="2"> <asp:textbox id="txtpayment" runat="server" enabled="true" cssclass="form-control"/> <asp:requiredfieldvalidator id="rfvpayment" runat="server" controltovalidate="txtpayment" validationgroup="submitgroup" display="dynamic" errormessage="* please fill in section" /> <asp:rangevalidator id="rgpayment" runat="server" controltovalidate="txtpayment" display="dynamic" type="double"/> </td> for text box, on id...

i have recursive java method builds binary tree: bt build() { return(a[++k] == 0 ? null : new bt(build(), build())); } bt class looks this: class bt { bt l; bt r; bt(bt l, bt r) { l = l; r = r; } } how build class work? if wanted build tree n nodes, how many times build function called in terms of n? each call of build function either creates node or returns null. there n+1 null pointers in binary tree n nodes. because each node has 2 outgoing edges , each node, except root, has 1 incoming edge. this gives 2*n+1 calls of build create tree n nodes.

i doing dashboard live update, after $http call when db returns null object want assign default value zero $scope.sap=0; $http({ method: 'get', url: 'gettilesdataforprjectreport.do', }).then(function(response){ if(response.data.proj==='sap'){ $scope.sap=response.data; } } }); <div style="height:20%; background-color:#ff9e97;"> <p id="colorpalletdashboardtilered"> {{sap.red}}</p> <p id="colorpalletdashboardtileamber">{{sap.amber}}</p> <p id="colorpalletdashboardtilegreen">{{sap.green}}</p> </div> <div style="height:18%; background-color:#ff8a81;"> <p> total projects : {{sap.totalproj}} </p> </div> if sap not in response data, need display 0 in sap bindings, if assign 0 $scope.sap, it's not reflecting in html. know done ng-hide <p> tag, what's simple...

i have javafx 2 gui includes hbox filling 1 of cells of gridpane . of components dynamically sized. displays fine, no problems. first question: i'd clip contents of hbox @ edge of gridpane cell they're in, none of overflow displayed, can't work out how. i've tried setting clip hbox rectangle of same size doesn't work. guess because it's using dimensions used layout, rather dimensions of what's displayed. should instead clipping on gridpane itself, or @ least using properties? second question (for bonus point): how clipping interact translation , scaling of node ? thanks help. i tried couple of short program attempts clip nodes within gridpane. none of clip attempt implementations liked well, though of them worked in fashion or other depending on requirements. the clip attempt closely seemed fit description last wraps clipped node in region it's own size specifiers, layout of clipped region matches size of clip node applied node...