Vault General

Reply
Employee
minkd
Posts: 451
Registered: ‎06-07-2010
Message 21 of 28 (205 Views)

Re: Opening Reference Repair Utility .xml file in Excel

01-30-2013 08:28 AM in reply to: Senthil-Autodesk

Is it possible that you pasted the command line from somewhere and the "-" isn't really a dash.  I've seen editors change the "-" into a long dash, which is not the same thing.

 

-Dave



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

Re: Opening Reference Repair Utility .xml file in Excel

01-30-2013 08:40 AM in reply to: Senthil-Autodesk

Thanks,  That got the import to work.

 

After the import, I ran the RRU again. Now my .xml only has ??? in the "Matching Ref In Vault" column. To correct them, I have to browse to the file and open, save and check into vault from Inventor.  I have several hundred of these to do. It will be very time consuming.

 

I know this is a stretch, but would there be anyway (macro or ilogic) to automate this?  All that it has to do is take the files in the "Parent Missing Ref" column and open each of them in Inventor.

Employee
minkd
Posts: 451
Registered: ‎06-07-2010
Message 23 of 28 (198 Views)

Re: Opening Reference Repair Utility .xml file in Excel

01-30-2013 12:28 PM in reply to: karthur1

Hmm, I'm really not sure ... but if there was a way, it would likely involve Inventor Task Scheduler (which unfortunately, I know little about).

 

Hopefully, someone else reading this knows if there is a way to create a task given a list of vault pathnames that can checkout/checkin each one.

 

Meanwhile, I'll find someone who knows task scheduler and ask them.

 

-Dave



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

Re: Opening Reference Repair Utility .xml file in Excel

02-04-2013 01:25 PM in reply to: minkd

Dave,

 

Any luck on reading in an excel list of files using Task Scheduler.... or other method?  Any other suggestions how to get the files corrected other than manually browsing and opening each one?

 

 

Thanks

Employee
minkd
Posts: 451
Registered: ‎06-07-2010
Message 25 of 28 (173 Views)

Re: Opening Reference Repair Utility .xml file in Excel

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

I was not envisioning the Inventor Task Scheduler reading directly from the XML file.  I was thinking along the lines of opening the XML file in Excel, selecting the column with the parent pathnames and pasting that either into Task Scheduler or a 1 line per pathname text file and giving that to Task Scheduler.

 

However, the sum of my knowledge of Task Scheduler is that it exists and that it can do some vault things - I don't know if it can take a list of vault pathnames and make sense of them (they are not workspace pathnames).  I asked an internal expert the question, but have not received a response yet - I assume he is busy with other things so I'll ping him again.

 

-Dave

 



Dave Mink
Data Management
Autodesk, Inc.
Employee
dan.szymanski
Posts: 112
Registered: ‎08-08-2006
Message 26 of 28 (147 Views)

Re: Opening Reference Repair Utility .xml file in Excel

02-26-2013 01:37 PM in reply to: minkd

Hello Kirk,

 

There is a way to feed a .csv file into Task Scheduler by using a custom task (accompanied with some iLogic).

An article about how to create a sample custom task is outlined on our PS Being Inventive Blog here.

 

The article does not cover a complete sequential, check out, save, check in task, however it gives you the concept (and might allow you to get what you need - however no assurances here considering you are dealing with some variances - sorry).  So this may be something worth looking into?

 

Best of luck.

Dan



Dan Szymanski
Sr. Software QA Engineer
Inventor Quality Assurance Team
Autodesk, Inc.

*Expert Elite*
karthur1
Posts: 4,149
Registered: ‎04-27-2005
Message 27 of 28 (135 Views)

Re: Opening Reference Repair Utility .xml file in Excel

02-27-2013 07:34 AM in reply to: dan.szymanski

Dan,

I'll give that a try.  I ran the Repair Ref Utility on a segment of my vault and there are over 500 files that have the  ??? in the "Matching Ref In Vault" column.  In order to repair them, I would have to open them all in Inventor, save and check-in.

Not sure how the task scheduler will handle the errors when opening especially if it cant find the files it needs to open an iam or idw.  Will try it and see.

*Expert Elite*
karthur1
Posts: 4,149
Registered: ‎04-27-2005
Message 28 of 28 (127 Views)

Re: Opening Reference Repair Utility .xml file in Excel

02-27-2013 12:44 PM in reply to: dan.szymanski

Dan,

I tried using a cusom task, but I couldnt get it to work.

 

So I have a list of files.  The first hurdle was getting a way to check-out the list of files from Vault. I could never do it.  I would then need to have a ilogic rule (or other code) to migrate the file, then check them back into vault. I could run them as seperate tasks, but I could not find any iLogic code that does Vault file operations.

 

I could get the example from the blog to work perfectly, but that was not using Vault.

 

Thanks

 

Kirk A.

Windows 7 x64 -12 GB Ram
Intel i7-930 @ 3.60ghz
nVidia GTS 250 -1GB (Driver 301.42)
INV Pro R2013, SP1.1 (update1)
Vault Basic 2013

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

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 to get help installing your software.

Ask the Community