Posts

internet explorer - Importing/scraping an website into excel -

i trying scrape data database, , have pretty set. in ie tab has me logged in database, , paste query link there through vba. how extract data returns ie tab , put excel cell or array. this code have opening query: sub import() dim row integer dim strtargetfile string dim wb workbook dim test string dim ie object call fill_array_cultivar row = 3 4 sheets.add.name = cultivar_array(row, 1) strtargetfile = "https://www3.wipo.int/pluto/user/jsp/select.jsp?fl=app_date%2cden_info%2cden_final&hl=false&json.nl=map&wt=json&type=upov&start=0&qi=3-nncxq6etevv184o9nnd5yg%3d%3d&q=cc%3ait%20and%20latin_name%3a(zea%20mays)%20and%20den_info%3a" & trim(cultivar_array(row, 1)) & "&facet=false" set ie = getie("https://www3.wipo.int" & "*") if not ie nothing ie.navigate (strtargetfile) else msgbox "ie not found!" end if next row end sub and appropriate fu...

ubuntu - There are problems and -y was used without --force-yes -

created directory 1) mkdir -p /root/dists/archives/ downloaded debians required installing few packages python-stdeb devscripts in /root/dists/archives/ 2) cd /root/dists/archives/ 3) dpkg-scanpackages . /dev/null | gzip -9c > packages.gz 4) added below entry in /etc/apt/sources.list deb file:/root/dists/archives/ ./ 5) apt-get update ign file: ./ inrelease ign file: ./ release.gpg ign file: ./ release ign file: ./ translation-en_us ign file: ./ translation-en reading package lists... done 6) when try install following packages python-stdeb devscripts. throwing below error apt-get install -y python-stdeb devscripts e: there problems , -y used without --force-yes create file in /etc/apt/apt.conf.d # cat /etc/apt/apt.conf.d/02allow-unsigned apt::get::allowunauthenticated 1; # apt-get update

Gradle build error in Android Studio -

i getting following error while building android project in android studio 1.2.2 (fresh instalation) error:(76, 0) not find property 'unittestvariants' on com.android.build.gradle.internal.dsl.testoptions_decorated@261be0aa. gradle version 2.4 android build gradle version 1.2.3 android-apt version 1.4 android sdk version 19. this triggered android apt plugin using unittestvariants property in 1.5 version available in android gradle plugin version 1.3 onwards (cf. bug report ). so either use android apt plugin version 1.4 , or android gradle plugin version 1.3 (see instructions below). note gradle version doesn't matter far bug concerned , use 2.4 2.2.1 . use android gradle plugin >= 1.3 make sure projects buildscript block references jcenter() (the beta versions aren't on maven) replace instances of 'com.android.tools.build:gradle:1.2.3' 'com.android.tools.build:gradle:1.3.0-beta4' re-sync gradle project wi...

.net - Automapper fails using a Generic Method - Event though the Generic Type is not used -

i trying make generic method map properties on similar classes. the following works: private shared sub createvaccessmap() each prop in gettype(workrecordheader).getproperties() mapper.createmap(of vaccess, workrecordheader)().formember(prop.name, sub(m) m.mapfrom(function(s) s.getfieldvalue(prop.name))) next mapper.createmap(of vaccess, workrecordheader)().formember(function(dest) dest.id, sub(opt) opt.ignore()) end sub but when add generic identifier fails ( argument types not match ) though not using generic type: private shared sub createvaccessmap(of t)() 'note change here each prop in gettype(workrecordheader).getproperties() ' following line fails on every property... mapper.createmap(of vaccess, workrecordheader)().formember(prop.name, sub(m) m.mapfrom(function(s) s.getfieldvalue(prop.name))) next mapper.createmap(of vaccess, work...

jQuery UI draggable not sticking to grid after scroll -

i'm using jquery ui's draggable functionality using set grid option. grid set use [x: 130, y: 110] constraints, , container grid height overflows own parent, allowing me scroll. when have draggable element, , start dragging it, , scroll bit down in container (while still hanging on draggable element), element no longer sticks grid. i have made barebone example shows error: you can see error in action in jsfiddle here - try start dragging, , scroll in container. if not enough of explanation; see gif of error here (it should stay in top left corner of grids). i have tried changing grid [x: 100, y: 100] , makes work in chrome , opera because scroll 100 pixels on each scroll, not firefox , ie since use soft-scroll. have tried "hacking" way through it, , moving element center of nearest grid when dragging done via jquery ui's droppable , did not seem usable solution. is there way ensure draggable element continue stick grid if scroll down while dragging ...

Pass variable to html frame -

i have django app having views.py //some code render(request, 'showmain.html',{"info": info}) and showmain.html <html> <frameset rows = "70%,*"> <frame src="showinfo.html"> </frameset> </html> i want pass data in info showinfo.html. how can done?

google tag manager - GTM V2 DataLayer button click tracking -

on webpage have 3 button ( ,average, bad). want track how many times particular button click. want use custom dimension , custom metric track in below format button name no.of time button click 5 average 10 bad 5 i have created custom dimension, datalayer variable (in gtm v2), custom metric. not able write datalayer code (datalayer creation & datalayer push method) code track counts how many time particular button clicked not developer or coder . can please me code of datalayer can paste/code on webpage click value button passed custom metric have created. datalayer name have created in gtm v2 bottonclicktotrack. need define event same. you don't need insert datalayer accomplish you're asking. can, believe there easier way. 1) set 3 triggers, 1 each button. make each button fire when respective button clicked 2) set 3 tags, 1 each button. make each tag send event ga account following information. category : button ...