Import Scenario for Closed Historical Service Orders

Hi @jaymarzian - Can you share the solution you came up with? Thank you!

Hey Chris,
I can give it a try.   

Part 1
Open Service Orders Import Scenario
I first had to figure out the Import Scenario for Open orders.  Attached is the Data Sheet I created to create my Data Provider. It refers to the External Reference Number as opposed to the actual Service order Nbr, So it is important that the import contains a External reference Nbr (Can be the work order number from the legacy system), and that the number is used on every line in the data sheet that represents Detail line items.  

Also attached is my Import Scenario.  It looks like this:

With this, I was able to create the Open Service Orders.

Part 2

Complete Line Items Import Scenario
Next, I had to find a way to complete the Detail line items in order to close the order. I used the same data sheet for this but created a different Import Scenario (attached).  It also refers to the External reference Number as opposed to the actual Service Order Nbr.  This is what that looked like.  
 

Thank you for sharing your solution with the community @jaymarzian!

Part 3

Last but not least, I completed and closed the Service Orders using another Import Scenario (attached).

This one also uses the same data provider as above.  It also refers to the External Reference Number as opposed to the actual Service order Nbr to pull up the imported record,