Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
COURSE of the MONTH
9 days, 21 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Object to array
Posted on 2016-10-12
Is it possible to turn an object to an array in VB.net?
I have a object from outlook which is a mailitem, and I want to turn all the variables into an array to store in a file.
I know Ill loose the functionality of the object (such as move, copy etc) however i only want to store all the information in the object (in this case mailID, recipents etc).
Usually I could just count the elements and then copy the values one at a time, however the mailitem is a nested array inside a nested array inside a nested array so could be quite confusing.
Any ideas?
I have a object from outlook which is a mailitem, and I want to turn all the variables into an array to store in a file.
I know Ill loose the functionality of the object (such as move, copy etc) however i only want to store all the information in the object (in this case mailID, recipents etc).
Usually I could just count the elements and then copy the values one at a time, however the mailitem is a nested array inside a nested array inside a nested array so could be quite confusing.
Any ideas?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
3
7 Comments
Active 1 day ago
I have a object from outlook which is a mailitem, and I want to turn all the variables into an array to store in a file.
yes, that's possible. you may want to consider to store it in a List(Of T) or look into the ToArray() method
List(Of T) Class
https://msdn.microsoft.com/en-us/library/6sh2ey19(v=vs.110).aspx
(look for the possible constructors and click on it to see the examples)
List<T>.ToArray Method ()
https://msdn.microsoft.com/en-us/library/x303t819(v=vs.110).aspx?cs-save-lang=1&cs-lang=vb#code-snippet-1
Active today
Couldnt get these to work :-(
So my code at the moment is:-
Any ideas what Im doing wrong?
So my code at the moment is:-
Dim mail As Outlook.MailItem = item
Dim output() As String = mail.toarray()
Dim serializer As New JavaScriptSerializer()
Dim arrayJson As String = serializer.Serialize(output)
MsgBox(arrayJson)
Any ideas what Im doing wrong?
Active today
Problem is, I dont know yet :-S
The data to store in the database (to search) keeps changing, so my plan was to store all the information in a JSON text file, then when a request comes along to add xxx to the search I can simply write some code to look at the JSON file and pull the requested field into the database and build the indexes for searching.
Initially they only wanted the `Date Received` and the `Subject`. Now its the `recipient` and `sender`, and already I've heard rumours they want the `conversationID` and Ive had requests to add `attachments` into the search. Hence store everything in a JSON text file and pull as needed, instead of trying to upload from the PST files again (which takes ages).
The data to store in the database (to search) keeps changing, so my plan was to store all the information in a JSON text file, then when a request comes along to add xxx to the search I can simply write some code to look at the JSON file and pull the requested field into the database and build the indexes for searching.
Initially they only wanted the `Date Received` and the `Subject`. Now its the `recipient` and `sender`, and already I've heard rumours they want the `conversationID` and Ive had requests to add `attachments` into the search. Hence store everything in a JSON text file and pull as needed, instead of trying to upload from the PST files again (which takes ages).
Active today
So looking at the element for mail (which is a mailtem from outlook) I get the following elements:-
I did think I could loop through each element and store in an array via:-
But I cant figure a way of reading all the elements inside mail.
I did think I could loop through each element and store in an array via:-
Dim objElement As Object
For Each objElement in mail
Next
But I cant figure a way of reading all the elements inside mail.
Active 1 day ago
perhaps it doesn't make sense if we are looping through all the elements in mailtem since it's quite complex to read through all its content, as back to the basic, we only store useful info into database, and hence we only extract useful info from the source.
Active 1 day ago
I come out with something like this, not too sure if this is useful for you.
Private Sub Test()
Dim tempApp As Outlook.Application
Dim tempInbox As Outlook.MAPIFolder
Dim InboxItems As Outlook.Items
tempApp = CreateObject("Outlook.Application")
tempInbox = tempApp.GetNamespace("Mapi").GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox)
InboxItems = tempInbox.Items
Dim MailList As New List(Of MyMailItem)
'Dim newMail As Outlook.MailItem
For Each newMail In InboxItems
If TypeOf newMail Is Outlook.MailItem Then
'You may want to put some conditions here?
If newMail.Subject.IndexOf("whatever") > 0 Then
Dim itm As New MyMailItem
itm.Subject = newMail.Subject
itm.ReceivedTime = newMail.ReceivedTime
itm.SenderName = newMail.SenderName
itm.SenderEmailAddress = newMail.SenderEmailAddress
For Each x As Outlook.Recipient In newMail.Recipients
Dim y As New MyRecipient()
y.Name = x.Name
y.EmailAddress = x.Address
itm.Recipient.Add(y)
Next
MailList.Add(itm)
End If
End If
Next
Dim serializer As New JavaScriptSerializer()
Dim arrayJson As String = serializer.Serialize(MailList)
MsgBox(arrayJson)
End Sub
Class MyRecipient
Public Name As String
Public EmailAddress As String
End Class
Class MyMailItem
Public Subject As String
Public ReceivedTime As String
Public SenderName As String
Public SenderEmailAddress As String
Public Recipient As New List(Of MyRecipient)
End Class
Featured Post
Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex.
A simple solution to parsing a customized CSV fi…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity)
(CODE)
There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
Suggested Courses
Course of the Month9 days, 21 hours left to enroll
762 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.