Video Screencast Help

SSIM v4.6 - Importing assets

Created: 11 Dec 2008 • Updated: 21 May 2010 | 4 comments

Hi,

 

I am trying to import assets from a pre-existing asset spreadsheet and I am continually getting an error when trying the import.

 

The process I have tried is as follows:

 

1) Export current asset entries to CSV (only a couple of entries exist)

2) Paste in new information (hostnames / IP addresses)

3) Save file and re-import

4) FAIL!

 

Any hints or suggestions would be much appreciated as we have 450 devices to import!

 

I have seen another article suggesting adding "" to each entry but that would be extremely time consuming.

 

When opening the CSV in notepad+ and manually adding a line before saving it can be re-imported.

Comments 4 CommentsJump to latest comment

Rob Pecor's picture

What error are you seeing?

 

I would guess that when you are editing that file, the format is not exactly correct.

 

What I would suggest is to create one Asset in SSIM 4.6 that has all information filled out, including hostname, IP addresses, etc.  Then export that.  Then use that file as a template to edit other Asset export files.

olaf's picture

You will need the exact nuber of field in each line.

 

Adding the "" for each field at the end of a line isn't that time consuming with the right tool.

 

Let's say you have a file with a list of 400 machines with hostname,IP-address in a file and you want to ad the "" for the missing field you can run the command sed on a Linux machine.

 

You assetfile looks like that:

testhost1, 1.1.1.1

testhost2, 2.2.2.2

 

sed s/$/, \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \" \", \"\"/g assetfile > newassetfile

 

 

olaf's picture

Correction to my last post.

 

The command to run is the following:

 

sed "s/$/, \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \" \", \"\"/g" assetfile > newassetfile

 

This will add the 10 missing fields to each line.

Crowe99's picture

Thanks both for your replies and suggestions.  I had hoped there would be an easy way of adding the extra info / fields.  My feeling is that it is using Microsoft Windows / Office that is causing most of the problem!

 

I'll give sed a go!