cancel
Showing results for 
Search instead for 
Did you mean: 

Export PST / Import PST Resulted in Normal Calendar and Sent Items Folder Icons for User

Stu_Packett
Level 4

I'm in the process of moving archives from one Vault store to another on the same server.  I was having trouble with the Move Archive feature, so I decided to use the "export to PST / import from PST" method.  Everything seemed to work except the folder icons in Archive Explorer for Calendar and Sent Items are normal folder icons, not the special ones like in Outlook.  The big issue is that the user cannot see who she sent an email to in Sent Items unless she opens each email up.  Any suggestions to correct this?

EV 9.0.1 in Windows 2008 R2

Article used:
http://www.symantec.com/business/support/index?page=content&id=TECH35696&key=50996&actp=LIST

1 ACCEPTED SOLUTION

Accepted Solutions

Stu_Packett
Level 4

I did a search for FOLDERICON and found this tech article.  I'm hardly work with SQL, but this looks similar to what you guys mentioned, correct?  The goal is to change the FOLDERICON field to their correct settings (9 for Sent Items, 1 for Inbox, 2 for Calendar, and 4 for Deleted Items). 

http://www.symantec.com/business/support/index?page=content&id=TECH35709&key=50996&actp=LIST

View solution in original post

8 REPLIES 8

JesusWept3
Level 6
Partner Accredited Certified

are the items actually in the \sent items folder or are they in a different folder like \PST Import\Sent Items?

https://www.linkedin.com/in/alex-allen-turl-07370146

Stu_Packett
Level 4

They are in the regular root of Sent Items.  I just noticed that the Inbox icon is also normal.  I believe I'm running something similar to this.  I ran the SQL statement in SQL 2008, but I can't edit the field from 0.  How do I do this in SQL 2008?

http://www.symantec.com/business/support/index?page=content&id=TECH52763

GCSPT
Level 5
Employee Accredited Certified

The TN you have reference is focused towards an issue with the 'top of the infomation store' and the overall structure of your Archive.

The icons for calender or sent items are directly managed by, surprisingly, the value of the 'foldericon' field. so you need to confirm the correct 'rootidentity' then find the correct folderid, then run an 'update' script to change the specific value for the exact folder in the exact archive that needs changing.

There  are probably quicker ways through SQL, for example if you return all rows with a foldername = 'calender' which have a foldericon value of < 2. that will show you how many archive calenders are affected.

I say this but I would seriously think about opening a support call if you are questioning how to change a value in SQL.

The icon issue has been seen in very few cases where, mail migrations or where other mass mail movement has occured, the migration process seems to affect the trigger that we look at to assign the correct folder icon to the folder when running the archive.

End story, if you are good with SQL you want to find the correcct folderid which is having the issue, using the archiveid and rootidentity.

Or if you want to blanket job it, something akin too

use enterprisevaultdirectory
Update dbo.ArchiveFolder
Set FolderIcon =2
Where FolderName = 'Calendar'
AND FolderIcon = 0

As always, before making manual edits to your EV SQL configuration, stop any archiving procedures, backup your db and system , committ the changes, test it works, then start archiving again.
 

JesusWept3
Level 6
Partner Accredited Certified

gIn SQL Server 2008 you have to run SQL Querys if its past the 200 rows, because to edit a SQL database directly like you would have in 2005 or 2000, you would right click the table and press Edit Top 200 Rows, but the chances of your entries being in the top 200 are slim to none

Updating the foldericon won't make a bit of difference at all.
The query you would use would be the following though



UPDATE ArchiveFolderView
SET   FolderIcon = 9
WHERE FolderName = 'Sent Items'
  AND FolderIcon = 0
  AND ArchiveVEID = 
(SELECT AFV.ArchiveVEID 
  FROM  ArchiveFolderView AFV, Archive A, Root R
  WHERE AFV.ArchiveVEID = R.VaultEntryID
    AND R.RootIdentity = A.RootIdentity
    AND A.ArchiveName = 'your Archive Name'
  GROUP BY AFV.ArchiveVEID)

  

However, can you run the following query and post a screenshot for us?

 

SELECT A.ArchiveName, 
       AFV.FolderName,
       AFV.FolderPath,
       AFV.ParentFolderRootPathIdentity,
       AFV.FolderIcon
FROM   Archive A, Root R, ArchiveFolderView AFV
WHERE  AFV.ArchiveVEID = R.VaultEntryId
  AND  R.RootIdentity = A.RootIdentity
  AND  A.ArchiveName = 'your Archive Name'
  AND  AFV.FolderName IN ('Top Of Information Store', 'Sent Items')
https://www.linkedin.com/in/alex-allen-turl-07370146

Stu_Packett
Level 4

I did a search for FOLDERICON and found this tech article.  I'm hardly work with SQL, but this looks similar to what you guys mentioned, correct?  The goal is to change the FOLDERICON field to their correct settings (9 for Sent Items, 1 for Inbox, 2 for Calendar, and 4 for Deleted Items). 

http://www.symantec.com/business/support/index?page=content&id=TECH35709&key=50996&actp=LIST

JesusWept3
Level 6
Partner Accredited Certified

huh fair play, if thats how it does it then fine! run the query i gave you above

The query they give you in that article is wreckless to say the least

https://www.linkedin.com/in/alex-allen-turl-07370146

JesusWept3
Level 6
Partner Accredited Certified

I just tested it in my lab and you are correct, if you change the folder icon to 9, it will represent the Sent Items and display the To field instead of the From field, good job

https://www.linkedin.com/in/alex-allen-turl-07370146

GCSPT
Level 5
Employee Accredited Certified

If you not really up to speed on SQL, I woulud open a support case. As mentioned in my initial post