Script for Linking Images with Url's from a Spreadsheet

I think the Auto hyperlink script (by Nobrainer Scripting) may come in handy to you. You can save the csv-file as txt leaving only product names and URLs separated by tabs.

Hello here is a code that I started to regroup because I will also be led to do the same

Bonjour voici un code que j'ai commence à regroupé car je serai aussi amené à faire la même chose

var imgs = app.activeDocument.allGraphics;   
 


 $.writeln (imgs.length);

 for (var i = 0; i < imgs.length; i++) {
       
// imgs[i].verticalScale = 92;
        
//imgs[i].horizontalScale = 92;
        
//imgs[i].fit(FitOptions.FRAME_TO_CONTENT);
       
// imgs[0].parent.appliedObjectStyle = "LeStyle";
       
// imgs[0].parent.applyObjectStyle( "LeStyle" );
       
$.writeln(imgs[i].parent.appliedObjectStyle.name);
       
$.writeln(imgs[i].itemLink.filePath);//  = app.activeDocument.objectStyles.itemByName("LeStyle"); // Faire controle
       
$.writeln(imgs[i].itemLink.name);//  = app.activeDocument.objectStyles.itemByName("LeStyle"); // Faire controle
    
try{
    
myHyperlinkURL = app.activeDocument.hyperlinkURLDestinations.add('http://www.apple.com');
    
myHyperlinkSource = app.activeDocument.hyperlinkPageItemSources.add(imgs[i].parent);
    
myHyperlink= app.activeDocument.hyperlinks.add(myHyperlinkSource,myHyperlinkURL);
    
myHyperlink.visible=false;
    
}
        
catch(myError){

}

    
      
 

   }//

Hi Kasyan,
This script sounds perfect for the project I'm working on! I'm having some issues making it work though and was hoping you could help. If I'm keeping the txt filed named the exact same do I need to change anything in the script?
Thanks!
Monica

Hi Monica,

No, you don't have to interfere in the script; the user is supposed to edit the txt-file only.

However, if your project has some specific requirements, the script may need some adjustments.

Regards,
Kasyan

Hi Kasyan,

I'm getting the above error when I try and run the script... any ideas?

Thanks,
Monica

I guess you don't have the character style named "hyperlink" in the document.

— Kas

I do but I've had to manually put it in (it wasn't automatically in my character styles)

Monica

I got it! Just had to make the hyperlinks character style all lower case! Thanks for the help!!

Monica

The script doesn't add it automatically. I'm not the author of the script so that's the way Nobrainer Scripting designed it.

— Kas

Hi Kas sorry hopefully last question!

So I've gotten the script to work on one of my indesign documents and was hoping to use it on another one but when I do I'm getting an error message saying "This name is already in use by another object" I have tried making a copy and changing the name of the jsx file as well as the txt file but am still getting the same error!

Monica

Hi Monica,

I remember I encountered and solved this problem in the past, but at the moment I can't recreate it.

Probably the document already has hyperlinks (e.g. you already run the script on it) and it attempts to use the found text (source) which is already taken by another hyperlink. You can't do this manually so it's impossible to do by script as well. The screenshot illustrates the situation:

But this is only my guess. I can't give you a more definite answer without seeing the document.

— Kas