Using the CSV import feature

re: Using the CSV import feature

Rob — Tue, 12 Mar 2013 03:55:14 GMT

Thanks. Where can I find the attributes for Service Requests?

re: Using the CSV import feature

Travis Wright MSFT — Mon, 04 Mar 2013 23:09:48 GMT

@Rob -

No, nothing special for service requests. It's just that at the time this document was created we didn't have service requests in SCSM yet.

re: Using the CSV import feature

Rob — Mon, 04 Mar 2013 22:50:43 GMT

I have successfully imported Incident and Problem data for a migration project. However the documentation does not seem to include any ProjectionType or class for Service Requests. Is there a restriction or a specific method for Service Requests?

re: Using the CSV import feature

Travis Wright MSFT — Mon, 05 Mar 2012 18:14:22 GMT

@Tom Pagel -

yes, this is one good way to get those types of objects in the database. Also check out the data management solution from Provance. It makes it easier to map the data instead of trying to figure out how to do it in XML.

re: Using the CSV import feature

Tom Pagel — Thu, 01 Mar 2012 18:53:54 GMT

Would this be a good method to import hardware that doesn't get tracked using Configuration Manager? I need to find a way to associate items like TV's, Computer Monitor Make\Model, desktop switches, some USB Devices, etc. I was thinking after importing these, then I can add the items using the configuration items in the "Related Items" tab in SCSM. Thanks

re: Using the CSV import feature

Travis Wright MSFT — Mon, 06 Feb 2012 23:58:52 GMT

@Greg -

Impressive! Nice work!

re: Using the CSV import feature

Greg — Mon, 06 Feb 2012 23:56:02 GMT

Disregard previous comment... I figured it all out and got it to work. Excellent Blog, thanks. I found the Appendix of Class Structure very useful dureing my adventure, but was able to load 800 Change Requests from a legacy system via this CSV import feature.

re: Using the CSV import feature

Greg — Mon, 06 Feb 2012 16:51:10 GMT

What about passing properties in the Change RequestProjection for class extensions? do you use something like:

CSVImportFormat>

<Seed>

</Seed>

<Seed>

</Seed>

</Projection>

</CSVImportFormat>

Then how about adding a Manual Activity to be created with each new CR work item? How would you go about including the XML for that? I want to create a series of CRs from CSV, but they need to include class extensions and also manual activities for each CR. Thanks

re: Using the CSV import feature

Dave — Tue, 31 Aug 2010 15:31:22 GMT

This will not start running. Am I missing something. I put 5 min and it never runs. I then tried 1 min and still nothing happens.

Thanks.

re: Using the CSV import feature

AKoptsov — Fri, 20 Aug 2010 08:21:18 GMT

About CSV import from the SCSM Console:

It does have some downsides at the moment, e.g.

- I didn't manage to change the delimiter character - that's not very convenient, especially considering that the commas in strings are still interpreted as column breaks by the parser

- When creating CSVImporter for a class which had enum "Category" with long entries(over 75 chars), the task failed unexpectedly. All the others enum fields imported just fine. I located the problem with that field by isolating the values which caused the import failure.

- When importing already existent objects to update them, they get completely overridden by the new set of values(most of them unspecified in my case). My intention is to only update several fields in each object, and to preserve the others. Am I doing something wrong or how do I do that?

Hope this will help with your work