Timesheet data from XML to PPM.

[rinuvarghese]

Hi,

While importing timesheet data from XML to PPM, We are facing an issue.

Getting an error saying that "System can not find the path specified" (Path and file already existing in SERVER)

Script: sh ./kTMDataConversion.sh -user X044705 -pwd welcome -xmlLocation D:/PPM_DEV/scripts/abcd.xml -testMode false

Can anyone help to address this issue.

Regards,
Rinu Varghese

+91 7829913547

[Celil · Accepted solution]

Hi Rinu,

The application define the log path wrongly. please use "logLocation" parameter.

PS: If the post resolves your issue, please click KUDOS star icon and mark it as Accepted Solution.

[rinuvarghese]

Hi Celil,

Thank you for the response.

Can you guide me how to set logLocation. Due to this the time data not converting to PPM.

Please help me

Thanks & Reogards,

Rinu Varghese

[Celil]

sh ./kTMDataConversion.sh -user X044705 -pwd welcome -xmlLocation D:/PPM_DEV/scripts/abcd.xml -logLocation D:/PPM_DEV/scripts/ -testMode false

[rinuvarghese]

Hi Celil, Its working fine and I have imported timesheet. Thank you for the help. I want to know, Is there any way we can convert Excel data to XML, As we are getting data in Excel format? If you have any idea about this please help me. Thanks & Regards, Rinu Varghese

[Celil]

Hi,

Please check enclosed attached.

PS: If the post resolves your issue, please click KUDOS star icon and mark it as Accepted Solution.

[KiranDubbaka]

Hi All,

Can anyone provide insight/source on how to convert the excel/csv data into the XML file (i.e. PPM timesheet importer XML file)? 

Highly appreciate your quick response in this regard.

Thanks,

Kiran