autstat Support

icon
Avatar
demianx
Posts: 12
I tried to install R through the following procedure but I failed. I would appreciate it if you could tell me how to install it correctly.

1. Install R-3.3.3-win.exe

2. start R(32-bit) as administrator and run following code :
options(install.packages.check.source = "no")
install.packages(c("rscproxy","rcom"),repos="http://www.autstat.com/download",lib=.Library,type="win.binary")
library(rcom)
comRegisterRegistry()
install.packages(c("Rcmdr","RcmdrPlugin.HH"),lib=.Library,dep=TRUE)
library(Rcmdr)

3. Install SExcel4Full1.0-0B1_HomeStudent_x86.exe which is downloaded from http://www.autstat.com/index.php/download-rexcel4-beta.html.



However, I cannot find statconn Excel in AddIn.

Also, when I started SetupTest.exe, following message is returned :


Application is not run as Administrator
Current R version is installed in <C:\Program Files\R\R-3.3.3> - OK
R version number is <3.3.3> - OK
Package <rscproxy>, version <2.1-3>, installed in <C:/Program Files/R/R-3.3.3/library> was built for R version <3.3.0> - OK
Package <rcom>, version <3.1-3>, installed in <C:/Program Files/R/R-3.3.3/library> was built for R version <3.3.0> - OK
Package <scExcel> information could not be retrieved, probably not installed



All files are installed by default.
My computer operating system is Windos 10 home.
Excel version is 2010.


I would appreciate it if you could tell me how to install it correctly.
Thank you.
2018-01-12 04:12
Avatar
Thomas Baier
Moderator
Posts: 222
Did you get any error/warning messages when installing scExcel?
If not, you should see a new ribbon "scExcel" or "SExcel".
The installer should have created log files on installation. Can you please have a look if you can find them and post them if you really don't see an SExcel ribbon
2018-01-12 08:05
Avatar
demianx
Posts: 12
I'm sorry, there was a mistake. I ran SExcel-AddIn-packed.xll and found the Add-In.
However, R could not be connected. license expired(error code : 2147745841).
How do I get a student license?
2018-01-14 07:33
Avatar
Thomas Baier
Moderator
Posts: 222
It seems, installation failed completely on your system. The statconnDCOM version installed with SExcel4Full1.0-0B1 has not expired yet. Please reinstall the program.
2018-01-14 08:58
Avatar
demianx
Posts: 12
I tried the reinstallation three times, but the result was the same.
Is there anything I missed during the installation process?
2018-01-14 23:53
Avatar
Thomas Baier
Moderator
Posts: 222
No-one can tell what went wrong if you do not share the log files as requested
2018-01-15 07:19
Avatar
demianx
Posts: 12
The following is a collection of logs as mentioned at the site
http://autstat.com/index.php/Support/topic/23.html.


1. Windows version

Microsoft Windows
version 1709(OS build 16299.192)




2. R version and version of the packages


> R.Version()$version.string
[1] "R version 3.3.3 (2017-03-06)"
> sessionInfo()
R version 3.3.3 (2017-03-06)
Platform: i386-w64-mingw32/i386 (32-bit)
Running under: Windows 10 x64 (build 16299)

locale:
[1] LC_COLLATE=Korean_Korea.949 LC_CTYPE=Korean_Korea.949
[3] LC_MONETARY=Korean_Korea.949 LC_NUMERIC=C
[5] LC_TIME=Korean_Korea.949

attached base packages:
[1] stats graphics grDevices utils datasets methods base
> installed.packages()["rscproxy",]
Package LibPath
"rscproxy" "C:/Program Files/R/R-3.3.3/library"
Version Priority
"2.1-3" NA
Depends Imports
NA NA
LinkingTo Suggests
NA NA
Enhances License
NA "statconnDCOM PUBLIC LICENSE"
License_is_FOSS License_restricts_use
NA NA
OS_type MD5sum
NA NA
NeedsCompilation Built
NA "3.3.0"
> installed.packages()["rcom",]
Package
"rcom"
LibPath
"C:/Program Files/R/R-3.3.3/library"
Version
"3.1-3"
Priority
NA
Depends
"R (>= 3.3.0), rscproxy (>= 2.1-1), utils"
Imports
NA
LinkingTo
"rscproxy"
Suggests
NA
Enhances
NA
License
"file LICENSE"
License_is_FOSS
NA
License_restricts_use
NA
OS_type
"windows"
MD5sum
NA
NeedsCompilation
NA
Built
"3.3.0"
>







3. SetupTest.exe

Application is not run as Administrator
Current R version is installed in <C:\Program Files\R\R-3.3.3> - OK
R version number is <3.3.3> - OK
Package <rscproxy>, version <2.1-3>, installed in <C:/Program Files/R/R-3.3.3/library> was built for R version <3.3.0> - OK
Package <rcom>, version <3.1-3>, installed in <C:/Program Files/R/R-3.3.3/library> was built for R version <3.3.0> - OK
Package <scExcel> information could not be retrieved, probably not installed







4. DbgView.exe and log

00000001 0.00000000 [11488] PBT_POWERSETTINGCHANGE
00000002 0.00013631 [11488] ************* GUID_BATTERY_PERCENTAGE_REMAINING **************
00000003 0.00024429 [11488] previous battery > current battery
00000004 14.43332577 [20440] statconnDCOM Installation path is "C:\Program Files (x86)\statconn\DCOM"
00000005 14.45060158 [20440] BDXImpl_init(licensee=Testing, connector=R, parameters=(null), objptr=02730FB4, installpath=C:\Program Files (x86)\statconn\DCOM, licensepath=C:\Program Files (x86)\statconn\DCOM
00000006 14.47693062 [20440] BDX_get_vtbl2: conn=R, licensee=Testing, objptr=0040B6A0, version=1, path=C:\Program Files (x86)\statconn\DCOM
00000007 14.48365784 [20440] BDX: DateTime enabled
00000008 14.48374844 [20440] BDX: Special .NET features enabled
00000009 14.48376656 [20440] BDX: x86 support (32bit) enabled
00000010 14.48379803 [20440] BDX: x64 support (64bit) enabled
00000011 46.26150131 [20440] H&S: Closing Splash Screen
00000012 46.26265335 [20440] ~SplashImpl
00000013 46.26465607 [20440] CStatConnector::initBDXForConnector() vtbl-object@1007B000
00000014 46.26639175 [20440] connector: R
00000015 46.27862549 [20440] DLL: rscproxy.dll
00000016 46.28527832 [20440] environment: R_HOME
00000017 46.29004288 [20440] registry key: Software\R-core\R
00000018 46.29442596 [20440] registry value: InstallPath
00000019 46.30123901 [20440] version key:
00000020 46.30603790 [20440] version value:
00000021 46.31007004 [20440] binary dir: bin/i386
00000022 46.31245422 [20440] connector: RPre2.12
00000023 46.31555557 [20440] DLL: rscproxy.dll
00000024 46.31756592 [20440] environment: R_HOME
00000025 46.31993866 [20440] registry key: Software\R-core\R
00000026 46.32200623 [20440] registry value: InstallPath
00000027 46.32440567 [20440] version key:
00000028 46.32581329 [20440] version value:
00000029 46.32716370 [20440] binary dir: bin
00000030 46.32862473 [20440] connector: Rold
00000031 46.32971954 [20440] DLL: rproxy.dll
00000032 46.33110809 [20440] environment: R_HOME
00000033 46.33223724 [20440] registry key: Software\R-core\R
00000034 46.33333588 [20440] registry value: InstallPath
00000035 46.33481216 [20440] version key:
00000036 46.33629608 [20440] version value:
00000037 46.33757019 [20440] binary dir: bin
00000038 46.33881760 [20440] connector: SciLab
00000039 46.34009552 [20440] DLL: sciproxy.dll
00000040 46.34162140 [20440] environment: SCILAB_HOME
00000041 46.34284592 [20440] registry key: Software\Scilab\%s
00000042 46.34418869 [20440] registry value: SCIPATH
00000043 46.34560394 [20440] version key: Software\Scilab
00000044 46.34677505 [20440] version value: LASTINSTALL
00000045 46.34793091 [20440] binary dir: bin
00000046 46.34904861 [20440] sc_proxy_find_connector: found "R"
00000047 46.35036087 [20440] sc_proxy_find_connector: found "R"
00000048 46.35189438 [20440] sc_proxy_load log follows!
00000049 46.36697006 [20440] sc_proxy_load: sc_proxy_find_connector(,<R>) done
00000050 46.37128067 [20440] sc_proxy_load: sc_proxy_find_connector(,<R>) done
00000051 46.37375259 [20440] Look up "R" in the registry
00000052 46.37730789 [20440] sc_proxy_load: use registry key "Software\R-core\R"
00000053 46.38131332 [20440] looking up registry key at "HKCU\Software\R-core\R\InstallPath"
00000054 46.38643265 [20440] looking up registry key at "HKLM\Software\R-core\R\InstallPath"
00000055 46.39038086 [20440] adding <C:\Program Files\R\R-3.3.3\bin/i386> to path <C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\usr\texlive\2017\bin\win32;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Users\samsung\AppData\Local\Microsoft\WindowsApps;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;>
00000056 46.39515305 [20440] new path is C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\usr\texlive\2017\bin\win32;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Users\samsung\AppData\Local\Microsoft\WindowsApps;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;;C:\Program Files\R\R-3.3.3\bin/i386
00000057 46.75836563 [20440] No Debugging of rproxy
00000058 46.76615906 [20440] CStatConnector::~CStatConnector()





Thank you.
2018-01-17 06:25
Avatar
Thomas Baier
Moderator
Posts: 222
What you posted looks as if everything is fine. The R connection itself is working.

Please use the "LicenseTest" application from the download area and use license key "SExcel4", then post the results from DebugView.
2018-01-17 09:35
Avatar
demianx
Posts: 12
The following is log when license key SExcel4 is used.


00000001 0.00000000 [1144] statconnDCOM Installation path is "C:\Program Files (x86)\statconn\DCOM"
00000002 0.02449481 [1144] BDXImpl_init(licensee=SExcel4, connector=R, parameters=(null), objptr=0274EACC, installpath=C:\Program Files (x86)\statconn\DCOM, licensepath=C:\Program Files (x86)\statconn\DCOM
00000003 0.32637641 [1144] BDX_get_vtbl2: conn=R, licensee=SExcel4, objptr=0040B6A0, version=1, path=C:\Program Files (x86)\statconn\DCOM
00000004 0.34970900 [1144] BDX: DateTime enabled
00000005 0.34977433 [1144] BDX: Special .NET features enabled
00000006 0.34983248 [1144] BDX: x86 support (32bit) enabled
00000007 0.34994274 [1144] BDX: #2/1514674800/1516345406
00000008 0.34998390 [1144] CStatConnector::initBDXForConnector() vtbl-object@00000000
00000009 12.50973320 [1144] CStatConnector::~CStatConnector()



In addition, the following error message is displayed as a result of the test.

Run-time error '-2147221455 (80040031)':
Method '~' of object '~' failed


Tank you.
2018-01-19 07:10
Avatar
Thomas Baier
Moderator
Posts: 222
Could you please send the file C:\Program Files (x86)\statconn\DCOM\SExcel4.lic to info AT autstat.com
2018-01-19 07:42
Avatar
demianx
Posts: 12
I sent the license file to info@autstat.com

My e-mail address is demianx@cau.ac.kr

Thank you.
2018-01-23 05:56
Avatar
Thomas Baier
Moderator
Posts: 222
Thanks. This license file really is out of date. Just uploaded a new file to the download page. Please use the Setup Maintenance Tool to install the license file after downloading.

Sorry for the inconveniences.
2018-01-23 07:58
Avatar
demianx
Posts: 12
Thank you, Thomas Baier.

I have successfully installed scExcel, thanks to you.

However, I could not find any fucntions that were available in previous versions of RExcel (ex, linear regression, stack variable, ...)

In order to use those functions, do I need to install previous version like RExcelInst3.2.16_HomeAndStudent.exe , or can I use them in scExcel?
2018-01-28 15:01
Avatar
Thomas Baier
Moderator
Posts: 222
You can use the functions in scExcel as well, but the RCommander-Menu is not yet implemented. You can instead use RCommander itself. If you need more help, please start a new topic
2018-01-28 17:56
icon