GRLOADER - How to Empty/Null already filled date field

Document ID : KB000095802
Last Modified Date : 15/05/2018
Show Technical Document Details
Question:
I need to know how I can set an date field in the database to the value EMPTY via the GRLoader.
Environment:
CA Service Desk Manager 14.1
CA Service Desk Manager 17.0
CA Service Desk Manager 17.1
Answer:
Please follow these steps:

1) create a XML file: 

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?> 
<GRLoader> 
<ci> 
<name>test</name> 
<serial_number>4711</serial_number> 
<class>Bridge</class> 
</ci> 
</GRLoader> 

and run the GRLoader which creates the CI "test" with a creation_date = 1234567890

where 123456789 is the current date in Unix format.

2) 
Then change the XML to: 

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?> 
<GRLoader> 
<ci> 
<name>test</name> 
<serial_number>4711</serial_number> 
<class>Bridge</class> 
<creation_date>EMPTY</creation_date> 
</ci>