Automatic update of a workfile based on Excel files

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

CecileBF
Posts: 9
Joined: Mon Mar 27, 2023 8:54 am

Automatic update of a workfile based on Excel files

Postby CecileBF » Fri Feb 02, 2024 2:57 am

Hi,

I created a program to import some series from an Excel file.
Basically, the import code is built that way:
import(link) \\intra\partages\FOLDER\PMI_ALL_manuf.xlsx range="Monthly PMIs" colhead=8 namepos=custom colheadnames=(,"Name","Geography","Major Sector","Sector","Last Updated","Index","Description") na="#N/A" @freq M @id @date(earliest_top) @destid @date @smpl @all
It works but when I open the workfile and refresh the series (automatic update), I get this error message: "EARLIEST_TOP is not defined in "IMPORT(MODE=UO)"
How can I solve this issue ?

Regards

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13286
Joined: Tue Sep 16, 2008 5:38 pm

Re: Automatic update of a workfile based on Excel files

Postby EViews Gareth » Fri Feb 02, 2024 8:53 am

Could you provide the file?
Follow us on Twitter @IHSEViews

CecileBF
Posts: 9
Joined: Mon Mar 27, 2023 8:54 am

Re: Automatic update of a workfile based on Excel files

Postby CecileBF » Wed Feb 07, 2024 8:14 am

The file is based on data from IHS Markit (for information).
Regards,
Cecile
Attachments
PMI_ALL_composite.xlsx
(586.72 KiB) Downloaded 9 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13286
Joined: Tue Sep 16, 2008 5:38 pm

Re: Automatic update of a workfile based on Excel files

Postby EViews Gareth » Wed Feb 07, 2024 10:41 am

Appears to work ok for me. Is there something else you're doing?
Attachments
pmi.gif
pmi.gif (3.59 MiB) Viewed 184 times
Follow us on Twitter @IHSEViews

CecileBF
Posts: 9
Joined: Mon Mar 27, 2023 8:54 am

Re: Automatic update of a workfile based on Excel files

Postby CecileBF » Wed Feb 14, 2024 3:34 am

Thank you! I tried and it works for me that way as well too.
But I create a workfile before this step and the problem re-appears now:
wfcreate(wf=TRANSITION\dbpmi, page=m) m 1992 2040


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 7 guests