Worksite saving document into a folder under a workspace with a script (flat filing enabled)
Hi There
I have a script that saves emails into worksite based on what is in the subject line of the email.
It works well but I would like it to now save into a folder under the case workspace and I can't quite figure out the code for it.
I know the CheckIn part needs to change quite a bit but I can't figure out what to exactly.
Is anyone able to help?
Thank you
Below is the script I currently use:
Sub CADEmails(Item As Outlook.MailItem)
On Error GoTo ErrorHappened
Dim itemSubject As String
itemSubject = Item.Subject
Dim SubPos As Integer
SubPos = InStr(1, itemSubject, "Case Number", vbTextCompare)
Dim casenoPosStart As Integer
Dim casenoPosEnd As Integer
casenoPosStart = InStr(1, itemSubject, "Case Number", vbTextCompare) + 12
casenoPosEnd = InStr(casenoPosStart + 7, itemSubject, "", vbTextCompare)
Dim strDatabase As String
strDatabase = "Wellington"
Dim strDocType As String
strDocType = "MIME"
Dim strClass As String
strClass = "E-MAIL"
Dim strSubType As String
strSubType = ""
Dim strCaseNo As String
strCaseNo = LTrim(RTrim(Mid(itemSubject, casenoPosStart, casenoPosEnd - casenoPosStart)))
Dim strDescription As String
strDescription = Item.Subject
Dim strSender As String
strSender = Item.SenderName
Dim strTo As String
strTo = Item.To
Dim strCC As String
strCC = Item.CC
Dim strReceivedTime As Date
strReceivedTime = Item.ReceivedTime
Dim strClient As String
strClient = ""
Dim strRecipient As String
strRecipient = ""
Dim strAuthor As String
strAuthor = ""
Dim strOperator As String
strOperator = "CAD"
Dim strIRN As String
strIRN = LTrim(RTrim(Mid(itemSubject, casenoPosStart, casenoPosEnd - casenoPosStart)))
Set oConn = CreateObject("ADODB.Connection")
oConn.Open "Provider=SQLOLEDB.1;Data Source=****;Initial Catalog=****;User Id=FileSiteUser;Password=****;"
Set oCmd = CreateObject("ADODB.Command")
Set oCmd.ActiveConnection = oConn
oCmd.CommandType = adCmdStoredProc
oCmd.CommandText = "upFileSiteIPONZEmails"
oCmd.Parameters.Refresh
oCmd.Parameters("@IRN").Value = strIRN
Set oRS = oCmd.Execute
Do While Not oRS.EOF
strClient = oRS.Fields.Item("NAMECODE").Value
strAuthor = oRS.Fields.Item("AUTHOR").Value
oRS.MoveNext
Loop
Set pNRTDMS = CreateObject("IManage.NRTDMS")
Set sess = pNRTDMS.Sessions.Add("server")
Call sess.TrustedLogin
Set db = sess.Databases.ItemByName("database")
Dim IMDoc As IManage.NRTDocument
Set IMDoc = pNRTDMS.Sessions(1).Databases(strDatabase).CreateDocument
IMDoc.SetAttributeValueByID nrType, strDocType
IMDoc.SetAttributeValueByID nrClass, strClass
IMDoc.SetAttributeValueByID nrSubClass, strSubType
IMDoc.SetAttributeValueByID nrCustom2, strCaseNo
IMDoc.SetAttributeValueByID nrDescription, strDescription
IMDoc.SetAttributeValueByID nrCustom1, strClient
IMDoc.SetAttributeValueByID nrCustom4, strRecipient
IMDoc.SetAttributeValueByID nrAuthor, strAuthor
IMDoc.SetAttributeValueByID nrOperator, strOperator
IMDoc.SetAttributeValueByID nrCustom22, strReceivedTime
IMDoc.SetAttributeValueByID nrCustom13, strSender
IMDoc.SetAttributeValueByID nrCustom14, strTo
IMDoc.SetAttributeValueByID nrCustom15, strCC
Dim strPath As String
strPath = "c:\temp\temp1.msg"
If FileOrFolderExists(strPath) Then
Kill strPath
End If
Call Item.SaveAs(strPath, 3) 'OIMsg
Dim fname As String
fname = strPath
Dim errs As String
IMDoc.CheckIn fname, nrReplaceOriginal, nrDontKeepCheckedOut, errs
Item.UnRead = False
Dim myOlApp As New Outlook.Application
Dim myNameSpace As Outlook.NameSpace
Dim myInbox As Outlook.MAPIFolder
Dim myDestFolder As Outlook.MAPIFolder
Dim myItems As Outlook.Items
Dim myItem As Object
Set myNameSpace = myOlApp.GetNamespace("MAPI")
Set myInbox = myNameSpace.GetDefaultFolder(olFolderInbox)
Set myItems = myInbox.Items
Set myDestFolder = myInbox.Folders("Processed_CAD")
'Item.Delete
Item.Move myDestFolder
Exit Sub
ErrorHappened:
'Call MsgBox(Err.Description)
End Sub
Categories
- All Categories
- 109 Developer Announcements
- 49 Articles
- 100 General Questions
- 122 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 122 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- Docker Automation
- LiveSite Content Services (LSCS) REST API
- Single Page Application (SPA) Modules
- TeamSite Add-ons
If you are interested in gaining full access to the content, you can register for a My Support account here.