Uploading a csv source file in eazyBi

Questions & Answers
,
1

Hello eazyBI community,

I’m trying to import a CSV file to enrich existing JIRA issue data, but I’m having trouble with the correct configuration.

Context:

-JIRA issues have a custom field called “Coda Project ID”

Coda Project Name (corresponding project names)
The Goal is to display project names instead of IDs in reports

What I’ve tried:

-Uploaded CSV to Source Files in Issues cube
-Various dimension configurations but getting validation errors
-Different mapping approaches suggested by ChatGPT
-Result: Shows “10 rows imported” but data isn’t linked to Issues

Questions:

  1. What should I enter for each column’s:
    Dimension field?
    Level or Measure field?
    Advanced options?
  2. How do I ensure the CSV “Coda Project ID” column maps to the JIRA field “Coda Project ID”?
  3. Should I use “Skip missing” option for issues without Coda Project IDs?

I’ve attached a screenshot showing the configuration screen. Any guidance on the correct setup would be greatly appreciated.

Environment: JIRA Data Center with eazyBI

Thank you!
Stefania

2

I’ve verified:

-CSV header is exactly ‘Coda Project ID,Coda Project Name’
-JIRA field name is exactly ‘Coda Project ID’
-The CSV contains matching values (e.g., P1819)
It seems that import completes without errors

But Issue Coda Project Name shows ‘(none)’ for all issues, I cannot understand why

Setup_csv
Setup_csv1059×854 29.9 KB

3

It seems that Import completes successfully but data doesn’t link to Issues

Details:

  • JIRA field: “Coda Project ID” (confirmed exact name)
  • CSV header: “Coda Project ID” (exact match)
  • Import settings: Both columns set to Issue dimension
  • Import result: Success, no errors
  • Problem: Issue Coda Project Name property is not created
  • The Coda Project ID values exist in both JIRA (P1979, etc.) and CSV

Question: How can I force eazyBI to map the CSV column to the existing JIRA custom field?

image
image486×794 6.35 KB