Service Desk Practitioners Forum
cancel

Date field in Service Desk import

Highlighted
Raj_72
Honored Contributor.

Date field in Service Desk import

Hi,

I am trying to import date field for a CI record from excel sheet,during the ecw wizard its giving the error.

How can i overcome this and in which format sd understands the date field.

Regards,
Raj
4 REPLIES
Mahmood Khan_1
Super Contributor.

Re: Date field in Service Desk import

Raj -
Make sure that the date format is selected a date in the s/sheet. When you generate what specific error do you get ?
Mahmood Khan_1
Super Contributor.

Re: Date field in Service Desk import

Raj -
Make sure that the date format is selected a date in the s/sheet. When you generate XML what specific error do you get ?
Raj_72
Honored Contributor.

Re: Date field in Service Desk import

thx guys,

its not giving any specific errors,it simply hangs ,when i try to close tht generate xml wizard its shwoing the error no. 1092...as i remember.

do u have any sample sheet from which u have successfully imported date field,if yes plz send me.

regards,
Ganesha Sridhar
Outstanding Contributor.

Re: Date field in Service Desk import

Hello Raj,

The Date in OVSD is given the the MM/DD/YYYY format. In the DSN the type for PD (purchase date column in the CSV file) is either Date or Char.

The sample CSV content is:
CIS , STATUS, CITY , PD
GANESHA, AVAILABLE , SHIMOGA , "12/16/2005"

HTH

Regards
Ganesha Sridhara