08-28-2015 08:15 AM
I made project in SAS EG 5.1, but today when i am opening this i am not able to open and error is displayed as:
" Unable to delete Data Imported from EVERUEX STOCK DATA-COPY.xlsx, SHORTCUT, it is not in the project"
Can you guide me , if i click OK in the error then project does not open. This is very important as i am sitting on client side and have to finish this.
08-28-2015 08:24 AM
You're getting this message when you open the project? No other action taken?
The element named ("Data imported from...") is an output data set resulting from the Import Data task, apparently from the named XLSX file. Is the XLSX file available on the system, in the expected location?
08-28-2015 08:36 AM
I suggest you work with Tech Support to resolve, since it's urgent. Was this project migrated from another version of EG? This could be an artifact from that process.
The resolution might require some minor surgery on your EGP file as Kurt suggests. But always work from a backup, as it's easy to damage the file so that EG won't read it. Tech Support could lead you through that process.
08-28-2015 08:39 AM
Thanks for the revert. This is not migrated from another Version. It was build in the same version and till yesterday it was working fine but today its not opening.
08-28-2015 08:48 AM
Here are some basic steps you can try. Without the project in hand, I cannot promise it will work. But you seem motivated to resolve this soon so it might be worth a try. NOTE: do this in a BACKUP copy of the file. Any mistakes can render the project unusable by EG!
1. Change .egp extension to .zip
2. RMB .zip and choose "Open With Winzip" (or other zip tool you might have)
3. RMB project.xml and choose "Open with Notepad" (or other text editor)
4. Search for
<Label>Data Imported from EVERUEX STOCK DATA-COPY.xlsx</Label> <---------
which refers to the SHORTCUT mentioned in the error thrown in EG: EVERUEX STOCK DATA-COPY.xlsx
5. Delete the above text
6. Save the changes to the project.xml file (back into the ZIP file)
7. Save the changes to the zip file.
8. Rename .zip to .egp.
9. Open the file in EG
08-28-2015 09:27 AM
I Changed the extension directly to .xml (I tried with .zip but when i extract and open the original files open). When i open the xml in notepad it was dispalayed in other language.
Can u assist in details how to open the xml in english language.
08-28-2015 09:45 AM
The EGP file is not XML, it's a ZIP format. So you won't be able to open that in notepad -- it's binary, compressed.
The project.XML is utf-8 encoded, so it should open in notepad and be generally readable. I provided those instructions in case you felt comfortable enough operating on the file with those tools. If that's not something you're comfortable with, I suggest working with Tech Support.
08-28-2015 11:15 AM
I got the solution.
Right click on the project and go to Properties. There we can find the restore versions of the last saved project. From there you can restore.
Its working fine for me now.
08-28-2015 08:28 AM
This may be a problem within the Microsoft interface to Office files, as a google search for the error phrase "Unable to delete Data Imported from" reveals quite some posts about that.
If everything else fails, remember that a project file is a zip archive containing XML and other files from which you can glean what you need.