topic Re: I am not able to open project in SAS EG5.1 in SAS Enterprise Guide

I am not able to open project in SAS EG5.1

SanchitArora — Fri, 28 Aug 2015 12:15:32 GMT

Hi All,

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.

KR,

Sanchit

Re: I am not able to open project in SAS EG5.1

ChrisHemedinger — Fri, 28 Aug 2015 12:24:09 GMT

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?

Chris

Re: I am not able to open project in SAS EG5.1

SanchitArora — Fri, 28 Aug 2015 12:25:30 GMT

Hi Chris,

Yes the excel file is available and is in the same location.

Re: I am not able to open project in SAS EG5.1

Kurt_Bremser — Fri, 28 Aug 2015 12:28:32 GMT

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.

Re: I am not able to open project in SAS EG5.1

SanchitArora — Fri, 28 Aug 2015 12:31:47 GMT

Hey, I ddnt get what you want to say here. How can i open the project. Can you help in that...

Re: I am not able to open project in SAS EG5.1

ChrisHemedinger — Fri, 28 Aug 2015 12:36:49 GMT

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.

Chris

Re: I am not able to open project in SAS EG5.1

SanchitArora — Fri, 28 Aug 2015 12:39:07 GMT

Hi Chris,

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.

Sanchit

Re: I am not able to open project in SAS EG5.1

ChrisHemedinger — Fri, 28 Aug 2015 12:48:52 GMT

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

</Element>

<Label>Data Imported from EVERUEX STOCK DATA-COPY.xlsx</Label> <---------

<Type>SHORTCUT</Type>

<Container>nnnnn</Container>

<ModifiedByEGID>userid</ModifiedByEGID>

<HasSerializationError>False</HasSerializationError>

</Element>

</INPUTLIST>

</SHORTCUT>

</Element>

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

Re: I am not able to open project in SAS EG5.1

SanchitArora — Fri, 28 Aug 2015 12:59:13 GMT

Hey thanks.

Will try for that and let you know.

Re: I am not able to open project in SAS EG5.1

SanchitArora — Fri, 28 Aug 2015 13:27:00 GMT

Hi Chris,

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.

Sanchit

Re: I am not able to open project in SAS EG5.1

ChrisHemedinger — Fri, 28 Aug 2015 13:45:35 GMT

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.

Chris

Re: I am not able to open project in SAS EG5.1

SanchitArora — Fri, 28 Aug 2015 15:15:05 GMT

Hi Chris,

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.

Thanks

Sanchit