Copy link to clipboard
Copied
Hi
We have some books with imported zapcodes png images.
I make one excel table or txt list where is in first column image name (image.png) and in second web link where is hyperlink destination.
12728_Allegro_5_1.png | https://www.some-link/1649ab4e-b145-4a11-9e04-905083736891/ |
12728_Allegro_5_2.png | https://www.some-link/dodatni-digitalni-sadrzaji/36f8f8bb-aeb9-4b30-9daa-4e465c790da5/ |
12728_Allegro_5_3.png | https://www.some-link/dodatni-digitalni-sadrzaji/d7c7b933-63d4-4ac1-99d9-0a35c120ce91/ |
12728_Allegro_5_4.png | https://www.some-link/dodatni-digitalni-sadrzaji/f44de7b6-c0e6-4bc2-b9ef-ffe0e437ac84/ |
Need script which can make hyperlink for this link/images in the list.
Thanks
A while ago I wrote a function which gets data directly from Excel which is, in my opinion, unfairly ignored by the scripting community.
And here I wrote a quick & dirty script that does what you want (at least, as far as I understood your requirements).
Here I posted the package:
The starting point: PNGes are placed, no hyperlinks created yet.
The data in Excel file
I used some links to my site because yours don't work.
Run the scri
...Copy link to clipboard
Copied
> Need script which can make hyperlink for this link/images in the list.
This forum is not a place where you ask people to write scripts for you -- not for free, anyway. So if you need a script, hire somebody.
Copy link to clipboard
Copied
https://forums.adobe.com/people/Peter+Kahrel wrote
> Need script which can make hyperlink for this link/images in the list.
This forum is not a place where you ask people to write scripts for you -- not for free, anyway. So if you need a script, hire somebody.
Oops! Sorry, Peter. It won't happen again. I just wanted to write something simple for fun. Going on vacation in a couple of days so won't get to computer for about a month.
— Kasyan
Copy link to clipboard
Copied
Peter, many of my custom script is here...when I have some script this script go here...
Copy link to clipboard
Copied
But that does not make it okay to post just any request to have a fully custom script written for you.
The Illustrator Scripting Forum has a banner at the top that explains it much better: the forum is to help people writing scripts, not help them by writing scripts for free. Of course there just may be someone who has the time to help you out, but bluntly posting a request and then sitting back and waiting for the cash free work to roll in is not the intention of this forum.
- This forum is a place for getting help and sharing information about scripting in Adobe Illustrator.
- Please avoid questions like: "I want to develop this workflow via script. How could I do this?"
- Instead, try to create your scripts, share your experiences and then ask for help regarding your scripts.
Copy link to clipboard
Copied
A while ago I wrote a function which gets data directly from Excel which is, in my opinion, unfairly ignored by the scripting community.
And here I wrote a quick & dirty script that does what you want (at least, as far as I understood your requirements).
Here I posted the package:
The starting point: PNGes are placed, no hyperlinks created yet.
The data in Excel file
I used some links to my site because yours don't work.
Run the script and select the xlsx-file
For long spreadsheets the progress bar is useful
The script completed
Hyperlinks have been created and are working
Finally, if you don't like the result, you can 'Undo' the whole script
Hope it helps!
Kasyan
P.S. Warning: this script illustrates -- in the simplest possible form -- the approaches I use for automating common tasks such as mass-production of hyperlinks and using existing data in Excel. I don't promise it would for everyone on all occasions.
Copy link to clipboard
Copied
> which is, in my opinion, unfairly ignored by the scripting community
Maybe you didn't advertise it enough. Looks great!
Copy link to clipboard
Copied
Maybe you didn't advertise it enough. Looks great!
I advertised (mentioned) it many times here and on the neighbouring InDesign forum, but almost didn't get any feedback.
Here I gave a practical example of its usage. My main idea which I want to advertise is we can combine InDesign scripts (including JS) with other scriptable apps -- for example, Excel, Access, Word, Outlook, etc. -- written in VB and AppleScript.
— Kas
Copy link to clipboard
Copied
Thanks thanks thanks Kasyan. Your solution work like charm
Copy link to clipboard
Copied
Hi Kasyan,
You wouldn't still happen to have this very helpful package lying around anywhere would you? Or at least the "quick and dirty script" you provided? I have pretty much the exact same need and this seems like it was a great solution!