Search found 536 matches

by EViews Steve
Thu Apr 11, 2019 7:33 am
Forum: Bug Reports
Topic: Command explorer window
Replies: 3
Views: 69

Re: Command explorer window

I would suppose our "Reset Window Layout" menu option under the Window menu should reset this Command Explorer window as well.
by EViews Steve
Thu Apr 11, 2019 7:07 am
Forum: Data Manipulation
Topic: SQL code in separate file when reading data from an ODBC source?
Replies: 4
Views: 140

Re: SQL code in separate file when reading data from an ODBC source?

The WFOPEN command doesn't have a way of reading parameters from a text file, but you can always read the text file into a variable first, and then use the variable in place of the actual sql string, like this: 'load all sql text files into mysql workfile as tables wfcreate(wf=mysql) u 1 'repeat nex...
by EViews Steve
Tue Apr 09, 2019 8:29 pm
Forum: Programming
Topic: EViews COM Automation Server- Example Code ?
Replies: 4
Views: 180

Re: EViews COM Automation Server- Example Code ?

If you haven't already, look at our python code written in the pyeviews python 2 package (see the /pypeviews/__init__.py file located inside the download zip file). Specifically, look at the functions PutPythonAsWF and GetWFAsPython. It uses COM to launch and send data to EViews, run EViews commands...
by EViews Steve
Thu Mar 14, 2019 10:59 am
Forum: Data Manipulation
Topic: Problem: EViews becoming the default viewer of xlsx files
Replies: 9
Views: 3605

Re: Problem: EViews becoming the default viewer of xlsx files

EViews associates itself as a "secondary" handler for Excel files. This means when you right-click an Excel file, EViews shows up under the "Open With" dialog as an available handler. Also, if you click on "Choose another app", EViews will appear under "Other optio...
by EViews Steve
Fri Mar 01, 2019 10:05 am
Forum: General Information and Tips and Tricks
Topic: Troubleshooting EViews Slowness
Replies: 0
Views: 90

Troubleshooting EViews Slowness

Just some common things to check for when you encounter unexpected slow EViews performance: Slowness encountered when opening or saving a workfile 1. If the file is not local, try copying the file locally first using it with EViews to rule out your connection to the file server. 2. Turn off Automati...
by EViews Steve
Mon Feb 25, 2019 8:44 am
Forum: Programming
Topic: COM Add-In: Close Instance?
Replies: 2
Views: 131

Re: COM Add-In: Close Instance?

Actually, running the EXIT command via COM can potentially cause problems with your COM objects in your application. You're asking EViews to shutdown, even though you still have an EViews Application object in your program and if you try to use that object again afterwards you'll most definitely get...
by EViews Steve
Thu Oct 04, 2018 6:54 am
Forum: Programming
Topic: MTOS
Replies: 18
Views: 2062

Re: MTOS

if %filename was originally a name with a .csv file extension, then the resulting new excel file will also have that name since you told EViews to use that name. The file is still an excelxml file format, but the extension is just wrong. If you rename the file to have an xlsx file extension, then yo...
by EViews Steve
Thu Oct 04, 2018 6:40 am
Forum: Programming
Topic: MTOS
Replies: 18
Views: 2062

Re: MTOS

Try creating a separate %path string value first:

Code: Select all

mtos(r1, g1, s1)
if @isobject("s1") then
    delete s1
endif
%path = "C:\Users\Dhitya\Desktop\test\" + %file
wfsave(type=excelxml) %path @keep date return g1
by EViews Steve
Thu Oct 04, 2018 6:10 am
Forum: Programming
Topic: MTOS
Replies: 18
Views: 2062

Re: MTOS

I don't see a filename specified in the WFSAVE call. I believe you always need a filename specified. Just use your %file variable.
by EViews Steve
Tue Oct 02, 2018 8:21 am
Forum: Programming
Topic: importattr command
Replies: 7
Views: 1105

Re: importattr command

You responded so quickly, I'm curious -- what did you do differently that made it work? I thought the import's overwrite mode would overwrite any previous description. Is that not working as expected? Oh, you're not writing to the description value... Well if you want to clear or set all description...
by EViews Steve
Tue Oct 02, 2018 8:00 am
Forum: Programming
Topic: importattr command
Replies: 7
Views: 1105

Re: importattr command

If you haven't updated to the latest patch, please do so and try again.

Otherwise, I'm not sure why you're seeing different behavior. Did you manually run the commands via the command window or did you run the program again?
by EViews Steve
Tue Oct 02, 2018 7:19 am
Forum: Programming
Topic: importattr command
Replies: 7
Views: 1105

Re: importattr command

I downloaded your workfile, switched to the annual page, then ran the following command in the command window: importattr(o) attributes and when I checked a series on the annual page, it had all the attributes: screenshot1.png Is this what you're looking for? By the way, IMPORT & WFOPEN commands...
by EViews Steve
Fri Sep 21, 2018 6:18 am
Forum: Bug Reports
Topic: Unknown Error 0x800A03EC
Replies: 1
Views: 2996

Re: Unknown Error 0x800A03EC

That looks like a COM error. WFSAVE would use COM to save to a spreadsheet only if it pre-existed and it is currently open & locked by Excel. I would try closing the Excel document (in Excel) and try running the WFSAVE command again. It can get a little tricky when EViews tries to update a docum...
by EViews Steve
Fri Aug 31, 2018 8:44 am
Forum: Bug Reports
Topic: Settings aren't stored
Replies: 2
Views: 1061

Re: Settings aren't stored

On networks where EViews is actually running on a remote server (e.g. the cloud) or is running inside a VM environment of any kind, it's possible that your user-specific INI file is getting lost, perhaps once a day or even upon each restart of EViews. In situations like this, you'll have to discuss ...

Go to advanced search