cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

ACL's Extraction and Loading from Windchill 9.1 to Windchill 10.2 System

aachanta
15-Moonstone

ACL's Extraction and Loading from Windchill 9.1 to Windchill 10.2 System

Hi All,

If we want to migrate ACL's from the source system Windchill 9.1 M010 to target system Windchill 10.2 M020. How would we do that ? Can you please answer the below questions

1. ) Do we need to write a custom utility for extracting ACL's from the source system ? If yes, can anyone please share a sample code related to the same.

2. ) As and when we migrate data from the source system to that of target system using Windchill Bulk Migrator the extracted data first loads into the staging database and from the staging database the data gets extracted into the target Windchill system. So upon extracting ACL's from the source system will they also be stored in the staging database. If yes where ?

3. ) Upon saying retrieving or extracting ACL's what is it are we extracting ? What is the output going to be like ? Is it an xml file or something else ? What is ACL's extracted output ? Say for suppose if we are extracting WTPart or WTDocument object types we can see all the object related data in the staging database and upon loading in target system and its database. So where will the ACL's be stored in the system ? Is it in the staging database or anything else ? Can anyone tell the name of the table ?

4. ) Upon creating an ACL in Policy Administrator will it make an entry in the Windchill folder. If yes which particular file will be internally modified and how to see that ?

Please answer these questions so that I can get some idea on ACL extraction and loading into target system.

Thanks and Regards,

Aditya Achanta

ACCEPTED SOLUTION

Accepted Solutions
asingh
12-Amethyst
(To:aachanta)

Hi Aditya,

 

Please refer to my comment in the link below for import :-

 

https://community.ptc.com/t5/Windchill/Tool-to-export-and-import-ACL-from-Policy-Administrator/td-p/379980#444828

 

Export could be a pain, you might have to massage alot of data:-

 

Either refer to link below :-

 

https://www.ptc.com/en/support/article/CS57440?&source=search

https://www.ptc.com/en/support/article/CS220509?&source=search

 

 

Thanks,

Aditya

View solution in original post

4 REPLIES 4
aachanta
15-Moonstone
(To:aachanta)

Hi all,

If anyone is aware of the above questions. Please share your inputs.

Thanks in advance.

Best Regards,

Aditya Achanta

asingh
12-Amethyst
(To:aachanta)

asingh
12-Amethyst
(To:aachanta)

Hi Aditya,

 

Please refer to my comment in the link below for import :-

 

https://community.ptc.com/t5/Windchill/Tool-to-export-and-import-ACL-from-Policy-Administrator/td-p/379980#444828

 

Export could be a pain, you might have to massage alot of data:-

 

Either refer to link below :-

 

https://www.ptc.com/en/support/article/CS57440?&source=search

https://www.ptc.com/en/support/article/CS220509?&source=search

 

 

Thanks,

Aditya

aachanta
15-Moonstone
(To:aachanta)

Hi Aditya.

To get the XML file can we develop a java program or a utility ?

Can you please let me know about it once ?

If there are any sample utilities of that sort can you please attach the same for my reference.

Thanks and Regards,

Aditya achanta

Announcements


Top Tags