Skip to main content
Participant
August 20, 2011
Question

Trying to develop Access-Illustrator application to help catalogue .eps files

  • August 20, 2011
  • 1 reply
  • 527 views

Hi everyone.

I was looking on the web and couldn't find any application that would allow fairly easily to catalogue by hierarchy and rename a whole bunch of .eps files i.e. home-kitchen-utensils or home-kitchen-appliances, etc.

I'm fairly proficient in VBA Excel and Access so I thought that I could develop the actual database in one of those and then using VBA I could pass a parameter with the file name and directory to Illustrator then Illustrator could open the file allowing me to preview it and I would be able to work on the Access database while having a preview of the file in Illustrator. Later VBA could command Illustrator to either save the file under the new name or just close it and rename it using VBA to be consistent with the hierarchy.

Ideally what I am looking for are 3 things:

1. An existing piece of vba code that would allow Excel/Access to pass parameters and start a script in Illustrator

2. A script in Illustrator that would open a specific file based on the parameters sent from the vba code.

3. A script that would save the open file based on new set hierarchy or just simply closes the file.

.....4. Software that already allows to preview .eps files, categorize, rename them and export information to a txt or cvs file...

Thanks,

Roland

This topic has been closed for replies.

1 reply

Inspiring
August 21, 2011

This sounds to me like you should really be looking at some Asset Management Software… Im not a PC user so I can't help you with VB. I would however look at doing this kind of thing in Adobe Bridge… Im almost certain this will preview your eps's on the PC (the mac has no problems with this at OS level) it is pretty good at dealing with all the file metadata, renaming or moving of files… There are a couple of examples about for using CSV… The draw back is going to be that it's scriptable in ExtendScript only… are you familiar with this at all?

Edit…

Forgot to ask but any particular reason for *.eps files? Why not change format to *.ai or *.pdf with AI compatibility… Should get previews with those and they should be smaller too…