R

151

Solutions

342

Contributors

R is a programming language and environment used primarily for statistical data analysis.

Share tech news, updates, or what's on your mind.

Sign up to Post

The idea is to be able to right click on a shortcut and be able to select an option to "copyaspath", which will store the Target URL in memory so that it will be available for pasting.

The command line would need to be placed in Reg Key: HKey_Classes_Root\InternetShortcut\shell\copyaspath\command
Use the Default String Type to add command line.

This works:

cmd.exe /c FINDSTR "URL=" "%1"|clip

Results:
BASEURL=http://site/index.cfm
URL=http://site/index.cfm

But we only need the URL line without "URL="

I was thinking this but not working:
cmd.exe /c For /F "tokens=2 delims==" %1 IN ('FINDSTR "URL"') DO (%1|Clip)

Any help would be appreciated.
0
Hello,
In asking my question about the Java EE 5,6,7, documentation; another question came up.
The Eclipse Mars was suggested, yet I had installed Neon2 because that was what I was using before.  I see that Neon 3 is released.
Last night I installed Neon 3 and the documentation options did not come up at all, like in Neon2.
The question that I now have is; with, let's say Neon3,  which now I have installed Neon2 and Neon3.  And I have downloaded Jdk 1.8.111/121, and Goldfish4/java_ee_sdk-7u2-web.  If I wanted to use Jdk 1.8.121 with Neon2 and Goldfish4 with Neon3; how would I configure the "Environmental System Variable "Path?"  
Is it that Eclipse has a setting that I could set up which Java version to use?
I apologize that I have not gone to check whether Eclipse Neon has such a setting.
Thank you for your answer.
0
Hello,
I have a couple of "unresolved" issues.  I tried fixing my problems using the options within Eclipse, but nothing works.
I know that I have in import/install the org.opeqa.selenium API, yet can't find the API at org.openqa, and I know that my Selenium API needs to be installed as well.  I thought I did have it via Selinity - Selenium plugin, but I guess not.
These are my issues;
import org.openqa...cannot be resolved
FirefoxDriver cannot be resolved to a type
Method undined for WebDriver

This is the code;
import org.junit.Test;

import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;

public class MyFirstWebdriverTest<WebDriver> {
      @Test
      public void checkSeleniumHQinFirefox(){
        WebDriver driver = new FirefoxDriver();
        driver.get("http://seleniumhq.org");
        driver.quit();
      }
}
0
I am in an Exchange admin with about 15 years experience, starting off in Helpdesk.

I recall the days when every company, regardless of size, had an on-site technical crew to manage their Exchange servers and everything else.

Then the smaller ones opted for the cloud, and the larger organisations kept dedicated technical teams

Now the larger ones are moving to the cloud too, and the only ones left with on-prem infrastructure are the ones with separate teams for exchange, storage, and so on.

Once these move to the cloud, I wonder what is next? So my question is, for someone in IT would it make sense to focus on software development rather than infrastructure skills?
0
We currently have an application called "Support" for mobile devices (runs on iOS/Android). The end user types their issue into the a form and it goes off to the helpdesk, who log a ticket.

To me, this seems somewhat pre-historic.

I was thinking of utilising bots, so that the user could interface with some level of AI which would then at least be able to present solutions

Is this possible? Are chatbots available to understand that the user has written and then point them to a Knowledge Base?

Any way to make this even better?
0
I am not trained in SQL. I'm trained in other programming languages, so explain this slowly for me.

I've been beating my head against the wall with this query. I spent a couple of days on it and got the results that I wanted, but noticed today that I had duplicates rows. Essentially, it's a list of clergy members. The clergy members have multiple addresses. What I'm most concerned about is the address types 'Main\Home Address' and the 'Parsonage Address'. I was able to figure out a join statement that gets me only these two address types, but I didn't plan on some of the clergy having both, so they both show up causing my duplicates.

Essentially, if both address types are listed for a clergy member, then I only want 'Main\Home Address to appear'. Otherwise, I want those clergy that have 'Main\Home Address' and those clergy members that have 'Parsonage Address' to appear in the query. The code is below. It's an awful database, so I'm hoping that what I've typed makes sense. Again, I'm not trained in SQL, but I've tried to comment within the code so things are clear. I really hope for some ideas on what to do. Thanks for the help.

SELECT DISTINCT
OtherPersonalInformation_GCFA203.int_value AS Id,
P.first_name AS FirstName,
P.last_name AS LastName,
P.nick_name AS PreferredName,
P.middle_name AS MiddleName,
ISNULL(tb_person_suffix.lookup_value, '') AS person_suffix,
ISNULL(tb_person_title.lookup_value, '') AS person_title,

0
Hello,
I'm looking for a website that gives a much deeper explanation about the Selenium api.

I found this site, yet it is not enough to fully understand; for what and how to use the api;
https://seleniumhq.github.io/selenium/docs/api/java/index.html?overview-summary.html

Could you suggest a better site?
0
Hi,

I'm starting a project to integrate a third party add-in from SagePay to our in-house Access database and unsure on some of the basics. I've completed the following steps but not clear on where the initial problem lies. Any assistance appreciated..

1. Discovered that I need a type library (tlb file) for the dll so I generated file using regasm (have .net framework 4.5 installed which is a listed minimum requirement)

(regasm.exe in c:\windows\microsoft.net\framework\v4.0.30319 = v4.5 folder after upgrade by all accounts)
regasm c:\sagepay\guardian\bin\Integral.Library.GuardianClient.dll /tlb

Open in new window


2. Added a reference to the add-in to vba project
VBA reference to SagePay dll
3. Declared function call for the add-in using documentation:

Public Declare Function Process Lib "c:\sagepay\guardian\bin" ( _
        ByVal transactionType As TRANSACTIONHOOK_TRANSACTIONTYPE, _
        ByVal transactionAmount As Integer, _
        ByRef tillInfo As TillInformation, _
        ByRef transInfo As TransactionInfo) _
As Boolean

Open in new window


4. This is where my knowledge gets a bit sketchy; I assumed the add-in would include the tillinformation type definition which I checked in the object browser but this is not the case as it shows no members?

VBA object view of TillInformation class
Hence, declared a VBA type as shown to match the documentation although documentation does not specify actual data types. I've tried varying strings / integers for some of the type declarations with no effect.
Public Type TillInformation
    merchantname As String
    address1 As String
    address2 As String
    address3 As String
    address4 As String
    phonenumber As String
    sitenumber As String
    tillnumber As String
    receiptnumber As String
    operatorid As String
End Type

Open in new window


5. Now when I try to call the function fro a test form, I get a type mismatch with 'tillinformation' parameter so it’s obviously not happy with the declaration..

Runtime / compile error with Process function
I don't know if the issue is with the add-in registration or the way I'm trying to declare the necessary types etc. so desperately in need of some guidance please! Thanks
0
Is there a formula for showing return on investment for training?

I'm thinking something like this.

(Salary per Year) / (Minutes Worked Per Year) = Employee Cost per Minute

(Cost of Training) / (Employee Cost per Minute) = (Number of minutes necessary for employee to be more productive to pay for course)

I guess you need to also factor in lost time due to course attendance and cost salary.

Has anyone seen anything similar to this?
0
i often need to backup data from different disk drives, and Windows OS'es - so
i would like to make a backup program that offers me :
choice of multiple source folders to copy
choice of destination folder

preferably with robocopy to speed up the copying

if possible, using editable source code;a windows interface like Gui would be nice, but not necessary

of course free
if you know some that do this - they're welcome too
0
Hello,

Is there a way to run an AutoHotkey (AHK) script directly from Notepad++?

I recently began editing my AutoHotkey scripts in Notepad++ rather than in Notepad. Now I'm wondering if, after making changes to a file, I can run it directly from Notepad++.

With regular Notepad, you must first save the edited file then go to Explorer (or wherever you have a shortcut) and run the file from there. It would save several keystrokes if the file could be run directly from Notepad++.

I do see a "Run" menu but after clicking, a box comes up asking you to enter the file you'd like to run. It would be quicker of course if there's a way to simply run the code in the currently active tab.

Thanks
0
I am just getting into a little php and programming and I would like to know what something like
If ($sMap != "") what does !="" mean and what does "" and " " on its own generally mean?

Thank you.
0
Before doing a linear regression on a data-set one needs to find out a few things about the data:

  • is there is a linear relation between the dependent and independent variables
  • are the variables normally distributed (if not, do a Data Transformation)

Questions:

  1. Book1.xlsx
  2. In Excel, do I simply use the CORREL() function to determine a linear relation between the dependent and independent variables?
  3. How do I interpret these results (i.e. low value = low correlation, high value = high correlation)?
  4. To test normality, can I simply use the QQ Plot test or should I use other tests, like the K-S Test as well?
  5. How do I interpret the K-S Test results?
  6. How do I go about doing a "Data Transformation" and how do I know whether I should do it?
  7. Please do not confuse things with only Statistics talk when giving an answer because I might not understand what you're saying. I've uploaded a sample of a data-set.

Thank you!
0
i got this code from internet, i want to run a test on this.  where i can get a good software where i can run tests like this that can support more than just one language. i mean if it can have plug-ins for other languages?

what i need something that i can run as portable, i do not want MS visual studio .

thanks

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace euler1 {
    class Problem7 {

        public static void Main(string[] args) {
            new Problem7().BruteForce();
            new Problem7().Smart();
        }

        public void BruteForce() {
            DateTime startTime = DateTime.Now;
            
            int numPrimes = 1;
            int numm = 1;

            while (numPrimes < 10001) {
                numm = numm + 2;

                if (isPrime(numm)) {
                    numPrimes++;
                }
            }

            DateTime stopTime = DateTime.Now;
            TimeSpan duration = stopTime - startTime;
            Console.WriteLine("Prime number {0} is {1} ", numPrimes, numm);
            Console.WriteLine("Solution took {0} ms", duration.TotalMilliseconds);
        }

        private bool isPrime(int numm) {

            if (numm <= 1) {
                return false;
            }

            if (numm == 2) {
                return true;
            }

            if (numm % 2 == 0) {
                return false;
            }

            int counter = 3;     

   

Open in new window

0
I have a table

 OrderDetail

 PK                                      FK                            
 OrderDetailID                OrderID           LineNo          
 8238                                7780                  1
 8239                                7780                  2
 8240                                7781                  1

 How do I create the column LineNo based of OrderID to increment starting with one?  So once the FK OrderID changes it starts back to 1 for the next orderid.  The lineno field must autogenerate and needs to be stored.
0
Hello,

What type of codes are the following and how do you enter them using a standard PC keyboard?

asc 225
U+03B4

Open in new window


I thought the technique was to hold down the ALT key while entering the characters in the number pad. However, for the first one, I've tried each of the following entries and only get clubs (♣♣♣).

ALT+225
ALT+0225
ALT+{NumpadAdd}225

I found them in an AutoHotkey script in which case they code for ß & Δ respectively.

b::Send {ASC 225}
+c::Send {U+03B4}

Open in new window


Thanks
0
Good Afternoon.

our IT team has changed the Office programs from 32bit of Excel to 64bit, now our finance department has a lot of files with macros in them, like around 598 of those files have codes that use the window API by using the Declare statement.
i would need to convert a bunch of 32bit API calls in these files to 64bit compliant calls while preserving 32bit compatibility as well.

i created the attached template. where i can put the directory, then file names and then two box for searching code and replacing it with code.

so, ideally , the code to loop through all files in the referred directory and its subfolders and if the files listed in Column C found then initiate search on those files by finding the codes listed in column D and replace them with code in column E.

i search the whole day and i could not find anything or any help on google or in any other forum, which brings me here to EE VBA gurus and i am hoping someone would be able to help me here.

thank you in advance.
2017-02-14-12_49_34-template.xlsb---.pngtemplate.xlsb
0
Hello Experts,
Need this.
Data(changed data)
Keycol data
1      O1
1      O2
1      O3
2      O4
3      O5
3      O5
7      O2
7      O1
Output I need below

Keycol data       LineNo
1      O1,O2,O3    1
2      O4          2
3      O5          3
7      O1,O2       4
possible in sql query? I need to generate  sequential number for a new column.
DO i need a loop or cursor forthis?
Thank you
0
Thanks in advance to all. ( I am a novice VBA user)

I trying to right a script that will import appointments in into Outlook 2016 from excel 2016. I have add some lines to the follow, but still no Joy.

What I would like to do is use the headings ,  to import, update the group calendar.

Subject      Categories            Location                        Start Date      Start Time      End Date      End Time      Description      Required Attendees      Show Time As      Reminder Set      Remind Beforehand      



Sub RegisterAppointmentList()
    ‘ adds a list of appontments to the Calendar in Outlook
    Dim olApp As Outlook.Application
    Dim olAppItem As Outlook.AppointmentItem
    Dim r As Long
   
    On Error Resume Next
    Worksheets("Schedule").Activate

    Set olApp = GetObject("", "Outlook.Application")
    On Error GoTo 0
    If olApp Is Nothing Then
        On Error Resume Next
        Set olApp = CreateObject("Outlook.Application")
        On Error GoTo 0
        If olApp Is Nothing Then
            MsgBox "Outlook is not available!"
            Exit Sub
        End If
    End If
    r = 6 ‘ first row with appointment data in the active worksheet
    Dim mysub, myStart, myEnd
    While Len(Cells(r, 2).Text) <> 0
        mysub = Cells(r, 2) & ", " & Cells(r, 3)
        myStart = DateValue(Cells(r, 5).Value) + Cells(r, 6).Value
        myEnd = DateValue(Cells(r, 5).Value) + Cells(r, 7).Value
        ‘DeleteTestAppointments mysub, myStart, myEnd
        Set olAppItem = …
0
EE,

I want to NOT pass objects or references in the constructor.  I think the instantiated object should know who instantiated it, and it should be able to scope the instantiator's  objects.  
Object A instantiates Object B.  Can Object B access Object A's  properties, members, etc?

Below is actual sample showing real example.  Advice please?

Kind Regards
Sam

Line 13, I want to NOT pass these objects in the constructor.   Delete lines 13 - 17.
using System;
using System.Web;
using System.Web.SessionState;
using System.Web.UI.WebControls;

namespace prjLogDebug.Utilities
{
    public class Log
    {
        HiddenField _hdnLogDebugChild;
        string _SessionItem;

        public Log(HiddenField hdnLogDebugChild, HttpSessionState Session)
        {
            _hdnLogDebugChild = hdnLogDebugChild;
            _SessionItem = Session["skPost"].ToString();
        }

        public void Append(string message)
        {
            string UrlAbsolute = HttpContext.Current.Request.Url.AbsolutePath;
            DateTimeOffset dt = DateTimeOffset.Now;

            _hdnLogDebugChild.Value = dt.ToString("HH:mm:ss")
            + "-->" + _SessionItem.ToString()
            + ">" + UrlAbsolute
            + "-->" + message
            + "\r\n"
            + _hdnLogDebugChild.Value;
        }
    }
}

Open in new window

One of many webforms:
using prjLogDebug.Utilities;
using System;

namespace prjLogDebug.Site
{
    public partial class wfChild_1 : System.Web.UI.Page
    {
        Log Log;
        
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["skPost"] != null)
            {
                Session["skPost"] = (int)Session["skPost"] + 1;
            }
            else
            {
                //Throw err
            }

            hdnLogDebugChild.Value = ""; //clear persisted data from prior post
            Log = new Log(hdnLogDebugChild, Session);

            Log.Append("Child_1 PageLoad()");
        }

        protected void btnLog_Click(object sender, EventArgs e)
        {
            string s = "Text to add from wfChild_1";

            Log.Append(s);

            string result = hdnLogDebugChild.Value; // to view with debugger
        }
    }
}

Open in new window

0
Hello:

Although I have many skills outlined on my resume, I want to add another practical skill, in case my current skills become obsolete.

So, I have been toying with the idea of teaching myself Swift or some other iOS programming language in order to be able to create apps for the iPhone.

Out of the many new business skills a professional could learn, would this be the best?  

If so, how long does it take to learn and is it extraordinarily difficult?  Are there are good and free tutorials online that will successfully teach the lay person such a programming language?

Thanks!

John
0
Hi there,

It's been a while since I've seen this type of equation, not sure what to do here:
2017-02-03.png
I am not sure this even makes sense, because if i = 1 then why not just say X subscript 1, instead of X subscript i? Also, "n-1" implies that we're considering a sample set of "n" numbers, which implies that the value of "i" changes "n" amount of times.

I don't know for sure though.

Hope you will help.
Thanks!
0
Need email sent automatically when date is entered in any independent cell in column E3:E45.

Option Explicit

Sub email()

 Dim r As Range
    Dim cell As Range

    Set r = Range("E3:E45")

    For Each cell In r

        If cell.Value = Date Then

            Dim Email_Subject, Email_Send_From, Email_Send_To, _
            Email_Cc, Email_Bcc, Email_Body As String
            Dim Mail_Object, Mail_Single As Variant

            Email_Subject = "Trucks Due for B Service"
            Email_Send_From = ".com"
            Email_Send_To = ".com"
            Email_Cc = ""
            Email_Bcc = ""
            Email_Body = "body"

            On Error GoTo debugs
            Set Mail_Object = CreateObject("Outlook.Application")
            Set Mail_Single = Mail_Object.CreateItem(0)
            With Mail_Single
            .Subject = Email_Subject
            .To = Email_Send_To
            .cc = Email_Cc
            .BCC = Email_Bcc
            .Body = Email_Body
            .send
            End With

        End If

    Next


    Exit Sub

debugs:
        If Err.Description <> "" Then MsgBox Err.Description
End Sub

Open in new window

(Edit: Added CODE tags)
Nestle-Water-B-Service-Master-Testi.xlsm
0
I am trying to execute external script in SQL server 2016. For that the following script executed

sp_configure 'external scripts enabled', 1;
GO
reconfigure;
GO

Then I restarted the service.

However, after executing following script run_value is still 0

code trying to run is..

EXEC sp_execute_external_script
      @language = N'R'
     ,@script = N'      res <-quantile(InputDataSet$Ages);
                  print(res)'
     ,@input_data_1 = N'SELECT Ages = DATEDIFF(YEAR,[BirthDate],GETDATE())
                        FROM [AdventureWorksDW2016CTP3].[dbo].[DimCustomer];'
;

Please help!
0
Greetings,
I have a situation where the data in my database is to be analysed and results are to be published on the web page, i built a web-form through which required data can be selected by the user, now this data should be send to R for some  analysis and results are needed to be published back on the  webpage,i have no idea how this can be done, i built the web app in PHP, with MySQL as database, any help will be appreciated,thanks in advance.
0

R

151

Solutions

342

Contributors

R is a programming language and environment used primarily for statistical data analysis.

Top Experts In
R
<
Monthly
>