Vault General Discussion

Vault General Discussion

Reply
*Expert Elite*
karthur1
Posts: 4,197
Registered: ‎04-27-2005
Message 11 of 28 (419 Views)

Re: Opening Reference Repair Utility .xml file in Excel

12-21-2012 09:00 PM in reply to: minkd

Dave,

What are the "tips" you mention in your post?

 

Anil,

I finally got the command line correct.  I mean, I guess I did cause I did not get any error back.  How do I know when the command is complete?  Will I get a message or something?

 

In the wikihelp for the reference repair utility, it really needs to say that you have to change to the ..Autodesk\ADMS 2013\ADMS Console direcctory in order for the command to work.  I had to change to that directory anyway.

 

Kirk

 

 

Employee
achintam
Posts: 67
Registered: ‎06-08-2007
Message 12 of 28 (409 Views)

Re: Opening Reference Repair Utility .xml file in Excel

12-22-2012 03:26 PM in reply to: karthur1

Kirk,

 

By tips, Dave means tip versions of files.  By default, the Reference Repair utility scans tip versions, Released versions and versions associated with Released Items.  If you've checked the box "Process all versions of files" the utility scans all versions of files in the selected folder.

 

While importing references via the commandline, you will know that the command is done when the command prompt returns to input mode.  This operation is usually very fast, so you might notice that the command prompt returns to input mode immediately.

 

Commandline access to ADMS Console is not new and the related content can be found at the following location on the Wiki.  That is why, information about changing directories is not mentioned in the content for Reference Repair Utility.  We could have provided link to the content about commandline access to ADMS Console though.

 

http://wikihelp.autodesk.com/Vault/enu/Help/Help/0097-Administ97/0098-Autodesk98/0141-Command_141

 

 

Thanks

Anil Chintamaneni (Autodesk)



Anil Chintamaneni
User Experience Designer
Data Management
*Expert Elite*
karthur1
Posts: 4,197
Registered: ‎04-27-2005
Message 13 of 28 (378 Views)

Re: Opening Reference Repair Utility .xml file in Excel

01-28-2013 02:10 PM in reply to: achintam

Anil,

If I edit the .XML file in excel and change the filename in the "Matching_Ref_In_Vault", do I also have to change the "Ref_Version"?  If No, do I just remove the ??? in that column or just leave it there?

Employee
yingkit(Autodesk)
Posts: 101
Registered: ‎05-10-2006
Message 14 of 28 (369 Views)

Re: Opening Reference Repair Utility .xml file in Excel

01-28-2013 09:52 PM in reply to: karthur1

Hi Kirk,

 

Not sure if I understand what you are trying to do here, but it sounds like you are trying to change the missing reference to another file? Otherwise, the scan should return you a list of matching references for you to choose from and you should really be placing 'TRUE' in the Accept column against the reference that you would like to fix the reference to.

 

And in your case, if it's showing ???, I'm guessing no reference is found that matches the missing reference?

 

In any case, the equivalent version that you'd like to fix your missing reference to should be entered into the "Ref_Version" column. Even so, it also need to pass the criteria that the checked in date of the reference is older than that of its parent before it will be fixed.

 

But again, I strongly advice against tweaking any other values in the spreadsheet except the Accept column to fix your references.

 

Thanks

--

Kit



Ying Kit
*Expert Elite*
karthur1
Posts: 4,197
Registered: ‎04-27-2005
Message 15 of 28 (365 Views)

Re: Opening Reference Repair Utility .xml file in Excel

01-29-2013 05:21 AM in reply to: yingkit(Autodesk)

When I run the scan, here is a screen shot of what I am seeing when I open the file in excel.

 

2013-01-29_0715.png

 

I added the text in row 17 and 18 in the "Matching Ref In Vault" column.  In order for me to enter the "Ref Version", I will have to refer to the file via Vault Explorer to determine the current version... correct? I don't know of another way to find the current version.

 

Then I also have to enter "TRUE" for each entry that I edit?

 

These three columns are the ONLY ones that I am touching.  The others are left as-is.

Employee
yingkit(Autodesk)
Posts: 101
Registered: ‎05-10-2006
Message 16 of 28 (358 Views)

Re: Opening Reference Repair Utility .xml file in Excel

01-29-2013 07:22 AM in reply to: karthur1

Hi Kirk,

 

Here's my take on your situation...

 

First of all, I suppose you are referring to row 12 & 13 (rows with purple edits).

 

The fact that the Repair tool is returning ??? instead of what you manually entered in purple indicates that none of the versions of these files has a Checked In date earlier than the version of the parent that you are trying to fix, i.e. version 2 of both 732051.idw and 732132.idw, can you check this?

 

As mentioned in my earlier reply, the repair will only work for repairing a version of the reference whose Checked In date is earlier than the version of the parent file. And even if you you enter those purple inputs manually, upon attempting to run the manual healing, the relationship will still not be established.

 

If you are able to find a version of the reference whose Checked In date is earlier than the version of the parent file, then you are correct in entering the respective version of the references in the "Ref Version" column. However, if this is the case, then I wonder why the scan is unable to automatically populate the "Matching Ref In Vault" column.

 

Let me know your result to the above questions first. If it proves to be the last case, then I may need you to provide a few screen shots for further verification.

 

Thanks

--

Kit



Ying Kit
*Expert Elite*
karthur1
Posts: 4,197
Registered: ‎04-27-2005
Message 17 of 28 (353 Views)

Re: Opening Reference Repair Utility .xml file in Excel

01-29-2013 08:55 AM in reply to: yingkit(Autodesk)

yingkit(Autodesk) wrote:

....

 

The fact that the Repair tool is returning ??? instead of what you manually entered in purple indicates that none of the versions of these files has a Checked In date earlier than the version of the parent that you are trying to fix, i.e. version 2 of both 732051.idw and 732132.idw, can you check this?

 


Kit,

On the 732051.idw, From Vault Explorer, Uses tab, does not show it "using" any file, but I know that it does in fact use 732051.ipt. Checked in date on 732051.idw, version 2 is 12/6/2007. Version 1 of 732051.idw is dated 11/29/2007.

On the 732051.ipt, it has 6 versions (version 3 thru 8).  Ver 3 is dated 12/7/2007 and version 8 is 8/13/2012.

 

Since the earliest date on the ipt is later than the idw, it guess that is what you are saying is why it does not automatically fix the reference.

 

I want the latest version of 732051.ipt to be associated with the latest version of 732051.idw.  I am not trying to capture version history.

 

If you need some other screen captures, just tell me what you need.

 

Thanks

 

Kirk

 

 

Employee
minkd
Posts: 474
Registered: ‎06-07-2010
Message 18 of 28 (347 Views)

Re: Opening Reference Repair Utility .xml file in Excel

01-29-2013 09:54 AM in reply to: karthur1

Kirk, if all you care about is making sure the references are correct for the tip versions, and the tool is unable to restore a reference to existing child versions, then your best bet is to just checkout the parent and check it in via the Inventor add-in.  The new parent version will have correct references after that.

 

The repair utiilty is useful for finding missing references. Some of those can be restored (via the import) without creating new versions of anything. This is particularly important if you are using revisioning and want to avoid file resolution issues when you get a historical revision from vault.  But if it won't cause any issues with your process to simply checkout and checkin the parents, then by all means do that!

 

-Dave

 



Dave Mink
Data Management
Autodesk, Inc.
*Expert Elite*
karthur1
Posts: 4,197
Registered: ‎04-27-2005
Message 19 of 28 (330 Views)

Re: Opening Reference Repair Utility .xml file in Excel

01-29-2013 12:11 PM in reply to: minkd

I am trying to import in the .xml file and cant seem to get the command line correct.  When I tried this before, I had an extra space after the -FIN, but I corrected that.  After I import this, I will just use Inventor to correct the tips with the missing references.

 

I have checked and double checked the command line and it looks correct, but it still gives me an error when it runs.

 

See the attached screen shot.

 

Any suggestions?

 

Thanks

 

Employee
Senthil-Autodesk
Posts: 576
Registered: ‎10-12-2006
Message 20 of 28 (320 Views)

Re: Opening Reference Repair Utility .xml file in Excel

01-29-2013 05:27 PM in reply to: karthur1

It looks correct to me as well. Anyway I tried the same with a Batch file and I am attaching the Batch file as well.

 

1. Edit it to include the Password

2. Copy it to ADMS Exe location and trying running it

 

 



Senthil Kumar
Vault QA Team
Autodesk, Inc.


Be sure to check out the Vault Help!
Announcements
New button for Platinum & Gold Subscription customers
Gold & Platinum Subscription customers can alert Autodesk if they require assistance with their forum post

Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.