External File Import and Updating Issues

[Steven Jaeger]

I run an import every month to set hours worked for billing purpose.  I use a simple CSV file with columns Issue Key, Summary, Hours Current and Hours Billed.  The issue key and summary come directly from a Jira export and we update the Hours columns before the import.  Every month it works fine and updates the records needed.  This month it is not updating any records.

This is a screenshot of my configuration:

 I get this text in the detailed log:

2018-03-05 19:47:25,562 INFO - Only new items will be imported
2018-03-05 19:47:25,570 INFO - Importing issue: [externalId='autoid-8081498445976267595', summary='1064-Member Portal Setup Request']
2018-03-05 19:47:25,615 INFO - Importing issue: [externalId='autoid-5299756487598622726', summary='1081-OPS/Chubb Daily Sales Report/Change']
2018-03-05 19:47:25,631 INFO - Importing issue: [externalId='autoid-5655641690937420107', summary='1081-OPS/Setup New Eligibility File/CHUBB']

2018-03-05 19:47:30,775 INFO - 0 out of 206 issues successfully created

Is there something that was updated that is causing my existing process to no longer work?  I can not see why it would not update the records when I am including the Issue Key in the mappings.

[Ryan Kearney]

Hmm can you post a screenshot of the CSV?

[Steven Jaeger]

For sure.  Here are the first several rows.

Issue key,Summary,New Billed,New Hours
SUPPORT-7033,1064-Member Portal Setup Request,0,1
SUPPORT-7062,1081-OPS/Chubb Daily Sales Report/Change,0,0.5
SUPPORT-7012,1081-OPS/Setup New Eligibility File/CHUBB,0,4
SUPPORT-6901,1081-OPS/Unified LM IIS Eligibility File/Changes,0,0.25
SUPPORT-7013,1081-OPS/Update Fulfillment/Chubb Elite Select,0,0.25
SUPPORT-7076,1140-OPS/AFS ProCare/New Eligibility File,0,3.5
SUPPORT-7163,1140>1081-OPS/NCE RX Premier>Chubb RX Eligibility/Move Product 17770,0,0.5
SUPPORT-6839,1154-Checkout/Confirm Email Address Verbiage Updates,0,1
SUPPORT-7182,1154-OPS/NAPP CHUBB Fulfillment File/Policy ID,0,0.25
SUPPORT-7074,1154-OPS/NAPP CHUBB/New Eligibility File,0,4.5
SUPPORT-6667,1161-OPS/Setup Eligibility File/MEC Advantage,0,3
SUPPORT-7145,Add Processor from Corp 1081 to Corp # 1237 - Benefits Center,0,0.5
SUPPORT-6877,1092 - New ID Card,0,10
SUPPORT-7272,1092-OPS/IHC file/Paid Thru Date,0,1
SUPPORT-7078,1092-OPS/Legal Club Eligibility/Add Product IDs,0,1.25
SUPPORT-6834,1092-OPS/Stat Doctors/New Requirements,0,2
SUPPORT-6262,1114-Advance Commission Report with detailed advanced but not yet earned amounts,0,6
SUPPORT-5901,1114-Agents/Agent Search/add search by Tax ID,0,1
SUPPORT-6950,1114-Agents/User/Permissions to Download Member Lists,0,0.5

[Steven Jaeger]

Right, i have tried it both ways.  The checkbox just allows me to change a value before it is imported.  When I used this I did not change the values, just continued the import.  Either way I get the message:

Only new items will be imported

It used to work unless I am missing a step somewhere.