How to Delete Comment Records thru CIMLoad

[donaldhl]

I am using the MFG/PRO CIM add in for Excel. How would I format the spreadsheet to be able to create a .cim file to delete Comment with Comment Type = PO
This what I have so far and it is not working

Master Reference:	Type:	Language:	Page:	5
cd_ref	cd_type	cd_lang	cd_seq
1/1	1/2	1/3	1/4	2/1	2/2
BO020001	PO	-	1	-	X
BP2010	PO	-	1	-	X
CM001219	PO	-	1	-	X
CM001327	PO	-	1	-	X
CP001708	PO	-	1	-	X

 

[nineinch]

It should look like this:

[TABLE="width: 336"]
[TR]
[TD="class: xl63, width: 64, bgcolor: transparent"]cd_ref[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]cd_type[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]cd_lang[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]cd_seq[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]X[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]F1[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]Delete[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]1/1[/TD]
[TD="class: xl63, bgcolor: transparent"]1/2[/TD]
[TD="class: xl63, bgcolor: transparent"]1/3[/TD]
[TD="class: xl63, bgcolor: transparent"]1/4[/TD]
[TD="class: xl63, bgcolor: transparent"]1/5[/TD]
[TD="class: xl63, bgcolor: transparent"]2/1[/TD]
[TD="class: xl63, bgcolor: transparent"]3/1[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]BO02001[/TD]
[TD="class: xl63, bgcolor: transparent"]PO[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]1[/TD]
[TD="class: xl63, bgcolor: transparent"]X[/TD]
[TD="class: xl63, bgcolor: transparent"]-[/TD]
[TD="class: xl63, bgcolor: transparent"]Yes[/TD]
[/TR]
[/TABLE]