EViews.com

Ok i did some quick testing in a brand-new Anaconda environment using the following: Conda 23.11.0 Python 3.9.18 64-bit pyeviews 1.0.5 numpy 1.26.3 pandas 2.1.4 comtypes 1.1.14 EViews 13 build date Jan 8, 2024 Windows 11 Pro x64 and my call to GetWFAsPython works as expected. If you're comfortable s...

Sorry, I didn't see this until now. I'll take a quick look to see if I can replicate it.

By the way, do you also have any other older versions of EViews (such as 12 or 11) on your machine?

13 patch with this fix has been released.

Yes, I was aware of the nature of this bug. I probably should've provided more details on what was happening before suggesting a workaround.

The new 13 patch has just been released, so please try your program again after updating.

Yes, it was a bug for when multiple windows are grouped together into a parent tabbed frame (like your two workfiles). It'll be fixed in the next 13 patch.

Steve

Thanks for your files... I was able to duplicate the error and figure out the issue. This will be fixed in the next 13 patch. In the meantime, you can prevent the duplicate workfile window from being opened by asking EViews 13 to prevent duplicate workfiles from being opened. To do this, go to the O...

I created a workfile with linked data to an Excel spreadsheet on a network drive, and ran a program that simply calls WFOPEN on it, and then WFREFRESH -- and the issue doesn't happen for me. Please send your workfile directly to me at steve@eviews.com. If you can, please send me your program as well...

13 patch with this fix has been released.

I just tested this in 13 and it doesn't seem to happen for me. Can you send me the tracker.wf1 file? What kind of database link does it have?

Also, make sure you have the latest 13 patch installed before trying again. The current build date is: Nov 28, 2023.

Probably early next week.

Understood. I took a closer look at the changes in 13 that was causing this, and it appears that our logic behind the COPY command (when the source file isn't already open) changed last year. This was because someone noticed that the COPY operation (in this scenario) didn't actually get all series p...

Just tested this. It has something to do with copying a series from a workfile that is not already open. If you open the source workfile before performing the COPY operations, you should see negligible performance difference. And honestly, this is probably preferable to do in your program otherwise ...

I don't know what your Oracle date values are based on, but wouldn't something like this work? This example also just calculates the "2023.11" date based on the current date. The only thing hard-coded is the oracle base date values since I don't know where this value comes from: logmode l ...

If your DSN file is at a certain path, just specify that path in the command: pageload(type=odbc) C:\Users\username\Desktop\OracleConnection.dsn " SQL code to pull the data I want here" @keep * Or maybe even put the DSN on the local network somewhere so it's available to everyone... pagelo...

Thanks for the report. I've been able to confirm that that method was deprecated and removed by Python 3.12. A fix will be released in next week's 13 patch.

Steve