CSV import

[Stephan Gruzinski]

I have tried to import a CSV file i created from MS Project task list and keep running into an issue with dates.

I was originally having issue with the date format until i looked at the text version of csv.  The format in the CSV file dd-MMM-YYYY

Once i was able to clear the errors form the import.  I looked at the task and the dates are not correct.

I mapped the Submitted dated date to Date Created and Due Date to Due Date.

I did not use Custom Fields. 

Here is an image of date section in the task, it is making everything 27/DEC/20 and screen shot of the dates from the csv file.  I know the dates are in the past but it is putting the same date for all even the ones in the future.

  

[MatthewC · Accepted solution]

Ahhh! Now that I know what you are doing , there is possibly another way, depending on the type of testing you are doing. Jira won't send notifications to non jira users. I'm pretty sure that includes subscriptions but as I'm not at a PC I can't double check. So if you go to the global permissions and remove the jira-users group from the use permission. Leave jira administrators in so your team can stil test but I think. It should work and be better than wiping out parts of the database!

[srinivasp]

But i had written groovy script to send emails explictily to component leads who are jira-users. Will it work?

[srinivasp]

This is probably a better way of handling notifications. Even i shuld remove jira administrators group also as there are around 25 users under it. Thanks for the answer.

[MatthewC]

I don't use the Groovy scripts so I can't say but it depends on how explicit it is, if it uses the Jira mail system then it should be ok, if it sends it directly them it may have problems. Maybe ask Jamie Echlin as he's the expert in groovy

[MatthewC]

You could possibly use SQL & manually delete them. You'd have to shut Jira down, run SQL & restore but make sure it's tested and you have the backups on standby!

Have a look here for an idea of how to find the filters in the database, it lists the subscriptions by filter. I'd imagine you'd also have to get rid of the subscriptions and all the references to shared filters otherwise Jira is doing to have problems.

http://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-ListFilterSubscriptions

http://confluence.atlassian.com/display/JIRA041/Database+Schema

It would also not be supported by Atlassian so it's only a suggestion of last resort. How many filters do you have? The SQL is "select count(*) from searchrequest"

If there aren't many, maybe you could just remove them manually, it would be a lot safer.

Can I ask why you want to do it?

[srinivasp]

Thanks for your answer.

We have around 5000 filters and most of them are subscribed with auto email notifications. Now we want to test some scenarios from our test instance and we want to enable the mail server for that. But if we do so, emails will be sent to all the users who subscribed thru the filters. So in order to block sending emails automatically, we have to remove all the filters. Please suggest if there is any other easy way for doing this.

[Dieter]

Please also check filter references in table gadgetuserpreference, column userprefvalue. Filters there are named filter-xxxxxx. If you delete filters without modifying or dropping the gadgets referring to them (by displayimg the dashboard containing them) this may clutter your logfile with stacktraces .. But it still works!

[srinivasp]

Hi Dieter,

Thanks for your suggestion. I am deleting both the tables.

-Srini

[Vishnukumar Vasudevan]

I don't think this is possible from GUI.

From jira 4.4.1 own wards, admins can remove other users filters.