Close Cases Via Import (Solution)

(0) Share

Report

Posted on by Community Member

Hi,

I have been finding ways of closing cases that I have recently imported (new system) and I seem to have found a way. Just wanted someone to let me know if this procedure was acceptible.

I created an excel file with the following fields:

Case reference (this field is a Unique identifier in the case table, custom field)
Status Reason (Closed)
Staus (Completed)
Time Spent (this is a whole number)
Reason (I have inserted an std statement ‘Legacy Case closed while import’
Company (link to Identify the customer)

I create an import to the ‘Case Resolution’ table, mapping the relevant fields (Case and Customer were lookup fields).

I run the import and the cases were resolved.

Note:

- In my real scenario there were no open activities, so no issues were encountered.

- In a test case, I created some activates and did not complete it and ran the import, after the import all open activities were flagged as cancelled.

COOL?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

ashlega 34,477 on at

Like (1)

Report

That's what excel imports are for:)

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Can someone double check and verify the proposed solution

Was this reply helpful? Yes No
Darshik 295 on at

Like (0)

Report

Hi,

Create one custom entity while creating the record on the custom entity write workflow to resolve the case which will fire on record creation. import data on the custom entity through excel.

Was this reply helpful? Yes No