Recover from a Snapshot vs Deleted Items - What's better?

Here's the situation:

I deleted rows from the Project Intake Sheet and it screwed up the linking of the Project ID to the Project Plan and Metadata sheets for all the projects. Then I went further and deleted the project folders for those rows I deleted. Now, I can't seem to re-establish the remaining ones.

I requested a Snapshot of the Intake Sheet from before I deleted the rows. It came as an Excel sheet.

The Deleted Items contains the project folders that I deleted.

Here are my questions:

How do I restore the Project Intake Sheet from the Excel file sent in the snapshot.
If that works, do I need to restore the project folders?
Any other related suggestions or cautions are appreciated.

Thank you!

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Kathy PPT

Thank you for clarifying! If anything like that happens again, you can "Report" a post to a Moderator using the flag icon and leave us a comment. We'll be happy to look into it for you 🙂

All comments

Kathy PPT

Scenario:

I deleted several rows from the Project Intake sheet (PMO Template format). Then went on to delete the associated project folders. Now the remaining projects are not properly linking to the Intake sheet. The Project Plan and Metadata sheets show the correct project id but has #REF for where the name (and other info) should be. Attempts at relinking the Project IDs didn't work. 😥

I requested a snapshot of the Intake Sheet. It came in the form of an Excel file.

Questions:

How do I bring the Snapshot into SS?
1. Update: I renamed the original Project Intake sheet then imported the Snapshot. Still not able to get a connection to the Metadata Project ID.
If that works, do I need to restore all the project folders I had deleted? I assume I'd do that through Deleted Items menu option.
Are there any cautions or suggestions?

Indebted to you for any help provided.

Paul Newcome

Are you using Control Center?

Kathy PPT

Hi Paul,

No I'm not. I figured out how to resolve and put my notes into the ticket but didn't save. I tried it twice.

I imported the Excel file sent by my request (renamed original Intake sheet) then had to reset all the references so they point to the new intake sheet. Did this for All my projects.

Genevieve P.

Hey @Kathy PPT

Just chiming in here to help clarify! It looks like there were two separate Questions (discussions) posted, but with similar content, so our Moderation team merged them into one post (this post) so that members in the Community could see your full context.

Are you missing other Community discussions or comments? Did you receive an error message when trying to post?

Kathy PPT

Hi @Genevieve P. ,
I don't recall the exact msg, something about needing to be logged in. Though I thought I was. At least I understand now that the team merged the data.

No further explanation is needed.

Thank you!

Genevieve P.

Hi @Kathy PPT

Thank you for clarifying! If anything like that happens again, you can "Report" a post to a Moderator using the flag icon and leave us a comment. We'll be happy to look into it for you 🙂

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.