Closed

YouTrack Export (HTML, PDF, XLS, CSV) and JIRA Import

# YouTrack Export / Jira Import

## Introduction

We are a non-profit charity that provides accessibility consultancy. To this end, we make reports explaining to clients how accessible their websites are.

We have historically made these with Word. Due to the limitations of this, we are moving to an issue tracker—YouTrack.

A lot of our clients cannot access this issue tracker due to security concerns. Others have their own issue tracker, usually JIRA. We thus we need to export the issues.

We have a Python script sitting on a BlueOcean server that queries YouTrack database through the REST API (see [login to view URL]).

It then generates a HTML, PDF, CSV, and XLS from the YouTrack issues. It also snatches the attachments (images only, no videos, audio files), etc. and put them in the documents—e.g. as embedded images in the PDF or local file references in the CSV.

It's almost good to go. There is a handful out outstanding quality of life fixes. We would really appreciate some help, and you would be supporting a non-profit charity that tries to change people’s lives.

## Project Admin:

We have the code on a private GitHub project. It is only a few hundred lines code. It is well commented. It's all pretty simple.

The tool we are using include:

• YouTrack (see [login to view URL]).

• Python 2

• bottle

• Flask

• Jinja

• Markdown

• pdfkit

• requests

• urllib

• XlsxWriter

## Tasks:

### Jira Import Duplication

The main problem with our JIRA import / export is that it exports *everything*.

If we export and they import, that's fine. However, if we update the project, export again, and re-import, duplication occurs.

JIRA allows you to map our issues IDs, such that it does not create whole new issues. However, the way JIRA works with attachments and comments means that our comments and attachments are duplicated.

This is because JIRA just adds them to the "comment body" and "attachment body".

We need a way to selectively export from YouTrack. For example, only exporting any new information (e.g. new comments, new attachments, etc.

We are flexible with the solution. For example, the server could log the project slugs and date stamp and then filter issues that have been updated since then. YouTrack could have a custom field with options such as "Never Exported", "Exported", "Updates to Export", "Exported with Updated", etc.

### Conditional Logic for Information

We have some custom fields value that won’t be present on all exports. These are special values for certain projects.

We want the values of these to be exported *if* an issue has a certain custom field. The issues will otherwise have the same core custom fields.

But some issues may have one or two special ones. We want to add logic that checks for these

and adds them if / when it comes across them.

### Export Meta-data about the issue

We want to export information about the issue itself. Specifically, we want ot be able to log when an issue was raised.

### Bug Fix with attachments

We reference attachments on YouTrack in Markdown. YouTrack will do some legwork with attachments. Our export script currently does not. For example, if you upload "[login to view URL]” but reference "[login to view URL]", YouTrack will work it out.

The export tool does not work this out. A solution would be casting the files and references to lowercase.

Skills: Python, Web Scraping, Atlassian Jira, Jinja2, RESTful

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #21323824

10 freelancers are bidding on average £507 for this job

adeelpirzada

Hi, Allow Me to Introduce Myself i have done scrapping almost on Half of Worldwide web including eCommerce giants (Amazon, eBay, craigslist) News Feed, Social media websites, API's. I develop my own scrapers an More

£525 GBP in 7 days
(35 Reviews)
6.5
PeterLi0529

Hello I'm Peter. Very strong in python beautifulsoup,selenium,scrapy and excel worksheetbook development for complex web scrapping. No problem I guarantee 100% success webscrapping result. Please open chat and discuss More

£500 GBP in 7 days
(8 Reviews)
3.8
valiksoin

Dear , ** I am Valentin.S in Russa I am a expert in Web scrapping. I'm very interested in your project. I worked too many jobs before and have confidence in web scrapping. I have ever scrapped Gumtree, yelp, bet365, More

£500 GBP in 7 days
(5 Reviews)
3.5
limondteam

Hi. Please survey my reviews. I saw your description carefully and I am confident I can full fill your requirement. So I provide my skills in hopes of working with you. I am full-stack developer and I have 2+ years More

£250 GBP in 7 days
(4 Reviews)
2.6
codestar0714

Hey there, If you need to get information off the web in an automatic fashion, I can write you a special script to do so. Bear in mind, however, that I must stay within the terms of service of the target website I deve More

£500 GBP in 2 days
(2 Reviews)
0.6
unix515

Hi, employer. I read your post. As the python expert, I am interest in your project. I want to work with you. Please chat with me .. I will wait for you on chatting. Thanks. Zhongbo

£500 GBP in 7 days
(0 Reviews)
0.0
lewisexpert2

Hi, Thanks for posting !!! I have 12 years of experience in Python development. I have checked The requirement and understand that as well. I have created SIMILAR in past. Do you want to see the DEMO ??? Thanks.

£500 GBP in 7 days
(0 Reviews)
0.0
AntonKozel

***** Scraping Expert ***** Hello. I have read your job description carefully. I have full experience in Web Scraping with PHP and Python. So I can do your project perfectly. I can start just now and I can deliver good More

£750 GBP in 7 days
(0 Reviews)
0.0
Jinghu8315

Hello, How are you? I just saw your project description carefully. I am very interested in your project. I have rich experience in PHP, Java, Python, Django, Web Scraping. I can help you surely and complete in a shor More

£250 GBP in 10 days
(0 Reviews)
0.0
viniciuscunha3

Nice to meet you Hi I am automation expert If there is any website you need to scrape data from (no matter the format, what blocking tools there are). I can deliver the data. If you do the same thing on the internet More

£796 GBP in 11 days
(0 Reviews)
0.0