Vault General Discussion

Vault General Discussion

Reply
Employee
632 Posts
58 Kudos
96 Solutions
Post 21 of 28

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.
AUTODESK EXPERT ELITE
4724 Posts
770 Kudos
147 Solutions
Post 22 of 28

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
632 Posts
58 Kudos
96 Solutions
Post 23 of 28

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.
AUTODESK EXPERT ELITE
4724 Posts
770 Kudos
147 Solutions
Post 24 of 28

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
632 Posts
58 Kudos
96 Solutions
Post 25 of 28

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
123 Posts
208 Kudos
20 Solutions
Post 26 of 28

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.

AUTODESK EXPERT ELITE
4724 Posts
770 Kudos
147 Solutions
Post 27 of 28

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.

AUTODESK EXPERT ELITE
4724 Posts
770 Kudos
147 Solutions
Post 28 of 28

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

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
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.