I've been assigned a task that requires me to use JIRA for duplicate assets in our inventory.

[argen mousesian]

Hey guys, I've just started an internship this week and I've been asked to work on their asset management program, and create a set of rules (?) for JIRA so that when we input a set of assets in our inventory using JIRA, it will check to see if the assets are duplicates, if they are, JIRA will either ask to replace the current one, or to create a new asset and keep both.

Our assets consists of many information such as serial #, asset #, manufacturer name, model, etc.. The way we put our assets in the system is by using an excel spreadsheet with all the information in it. JIRA will then read every cell and match the attribute of the cell with what is described in JIRA, like this.

I have never used JIRA or any asset management program before so I'm pretty lost.

What I need to do is to have JIRA check in spreadsheet and see if there is any matching cells with our current inventory and if there is a duplicate, ask the user if they want to replace it or create a new asset.

Any help will be greatly appreciated!

Thank you!

[Joe Pitt]

there isn't anything out of the box that would allow you to do that. 

[argen mousesian]

Maybe I'm not getting my point across correctly, I apologize for that. My boss is telling me that there is a way to do it but we just don't know how yet. Let me explain what we're doing exactly with pictures so that it's a bit more clear.

So what we do every week, is that we get new assets that need to be put in the inventory from a spreadsheet. Let's say this week we had 10 new assets. We upload the spreadsheet to JIRA and everything is fine. 

Next week, we have 7 new assets added to the same spreadsheet. What we want JIRA to do is to not upload the 10 assets from last week that are already in the system and only add the new 7 assets.

This is the section that I'm working on currently and trying to figure out if there is a way.

I am also receiving this error when I'm trying to synchronize. I don't know how to access the error logs to see what the problem is, would you know what could cause this?

Thanks again.

[Joe Pitt]

You can create issues from uploading csv files, I haven't done it, but I believe if you don't have an issue number in the field it will create an issue. If you do have an issue number it will update the issue. I believe you would have a problem with it skipping the ones you already put in. You could add the issue number, but then it would update the issue.

[argen mousesian]

So I guess I've misunderstood the whole program here. We are using Insight Asset Management which is a plugin for JIRA. Do I need to work on insight to do what i'm trying to do? Do you know if I can achieve the goal with Insight?

Sorry I know you're not obligated to answer my questions but I really appreciate it!!!

[Joe Pitt]

I'm not familiar with that plugin.  In the future any time you're using plugin for a function identify it in the question so the community will give you better answers.