Page 1 of 1

Automatic update of a workfile based on Excel files

Posted: Fri Feb 02, 2024 2:57 am
by CecileBF
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

Re: Automatic update of a workfile based on Excel files

Posted: Fri Feb 02, 2024 8:53 am
by EViews Gareth
Could you provide the file?

Re: Automatic update of a workfile based on Excel files

Posted: Wed Feb 07, 2024 8:14 am
by CecileBF
The file is based on data from IHS Markit (for information).
Regards,
Cecile

Re: Automatic update of a workfile based on Excel files

Posted: Wed Feb 07, 2024 10:41 am
by EViews Gareth
Appears to work ok for me. Is there something else you're doing?

Re: Automatic update of a workfile based on Excel files

Posted: Wed Feb 14, 2024 3:34 am
by CecileBF
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