Import Project in Closed Status using XML Import

[AbdulMajeed_1]

Hi,

Is it possible to import projects in 'Closed' status using XML Import utility?

Kindly response.

Thanks,
Abdul.

[Mahen M]

You want to create a new project with XML Import and its status should be 'Closed' as soon as you import it? Am I getting it clearly?
Please advice.

[AbdulMajeed_1]

Hi Mahen,

Yes. We need to import the projects using xml import and it should be closed as soon as it imported.

Thanks,
Abdul.

[Mahen M]

Try to import it with the request Status_id=6. Have you tried it? If it gives some errors, Let me know what the error actually is.

[AbdulMajeed_1]

Hi,

I have already tried with Status_id 93 and 6. When I added REQ.P.STATUS_ID field at end of excel sheet, there's no effect at all. when i add the token feild at somewhere middle of the excel sheet, it throws validtion error of other token fields which actually have correct values.

Did anyone implement this kind of import?

Thanks,
Abdul.

[Mahen M]

What is the 'initial request status' which you have set up in 'Request Status' Tab in Request Type?

I don't have XML importer to check up. Why can't you update the Status after all the project is created in one shot by running the update Query?

[Varun Singh]

Hi All,

I am facing a wierd problem. I generated the XML for project and received the error that one of the column for which values are not as per the validation for that column. I have removed those names from the xls sheet and created a new XML file with the new data.

When I am doing an XML upload, i am getting the same error for those names in the field even though I have deleted those data from the sheet as well as generated xml doesn't have those names listed at all.

Any idea, if ppm saved it somewhere or i need to restart the machine. or
not able to understand then doing a new upload, it still refers to the old values which no more exists in the XML document.

Could you please help??

Thanks
Varun

[kerimkilic]

for creating projects with different status than project creation; you can create a custom field to show current status of the project and make an initial execution step with move_flow command; then u can send necessary data to command, hope this helps