[mkns]

Hi,

I hope I have not missed the obvious, but am I correct in observing that the "Support->Case" import for the CSV Import feature does not allow for Message detail importing?

In other words, if I want to import 10,000 cases, each of which have ~3-5 messages, with at least a few each having attachments, am I correct in observing that the CSV Import feature would not support importing the details of these messages or properly link the attachments?

It seems I CAN import multiple Messages using Add/Update and making sure to use an ExternalID to key multiple rows differing only by the "Message" field together, but there seems to only be that single "Message" field available to me. I do not see a way to map things such as "Date", "Author", "Recipient", "Subject", "Files" etc. for each Message.

Does anyone know if I am missing an obvious option here? Do I need to split all messages into a separate Message import after keying them to the newly-imported InternalID of my cases? I would think SOAP import would be just as easy in that case, but I have been wondering why NetSuite would have a CSV wizard for Cases yet not allow Messages or Files attachments to be directly imported since it seems to defeat the purpose…

Many thanks for any input!
This is a cached copy. Click here to see the original post.

[OniNoKami]

There is a messages import in CSV. It is under the Communications import type. To attach the message record to CSV, you will need to map the NS internal id/external id or the Subject of the Case to the Activity field.

[mkns]

Hi,

Thank you for the response. Unfortunately this method (importing Support Cases with an ExternalID in one CSV, and then importing Messages with the same ExternalID as their Case in another CSV) was not scalable enough for me, even though it is possible to do multiple Messages per Case. Your answer is good for a small number of cases (i.e. not tens of thousands).

Instead I am using SOAP (SuiteTalk) C# to loop through my Case information rows, add the Cases (and return back the Case internalID) and then add the Messages for each Case by referring to the Case internalID.

This way is superior right now, as far as I can tell, both because it is MUCH faster, but also because it gives access to fields which are simply not accessible using CSV import (such as the Message "From" and "To" fields).

I haven't perfected a way to associate attachments with each Message, but at the very least I will be able to script something this way (as opposed to CSV import which has no ability whatsoever to map uploaded files to ANYTHING, let alone specific Messages).

[mkns]

As I have come to realize (I believe this is correct), I can indeed use C# to add attachments to Messages BUT this is NOT the same as adding attachments to the SupportCase record itself. It should be good enough for my purposes though to just attach files to e-mails.

The way to do this, which is really not well documented, is by using mediaItemList when adding the Messages via SOAP. I originally thought I could not do this due to several errors I received on my first attempts (now in the double digits of attempts).

See: http://usergroup.netsuite.com/users/…ad.php?t=20915

[mkns]

RE: Import Multiple Cases and Multiple Messages

I have discovered that it is also possible to associate Message Attachments on Messages on a Case ALSO as Files for each case (so that the files tab TRULY shows ALL files), but these are indeed "separate" classifications.

To get the Attachments to show as "Files" see:

https://usergroup.netsuite.com/users…d.php?p=144340

[Author]

Posts