Dear all,i need your opinion / help. There are massive excel tables that have tobe published every day. All the tables havetheir first column alter. There is also a specific number of vectorgraphics that need to be placed inside thethe first column's cells. [symbols flags etc]After placing each table to ID the designerhave to construe every delay row in order todetermine which graphic will be placed inwhich cell. The procedure had been automated a lotwith the use of Object carve up table andcell styles. However a lot of measure still pay toselect a graphic and paste it in each cell. So we are looking for an easier morepractical way to do that. For example a first thought was to act adingbat font with all the graphics. Then typewithin Excel the equivalent letters of the fontat the first column. After placing table to ID andtag the first column with a specific characterstyle every alphabet letter should be replacedby the equivalent graphic. But with this runaround there was color limitation(only one alter per graphic). And we need to keepthe color characteristics for each graphic [a 2 or 3alter flag]. Anyone have any ideas of automating somehowthe progress of selecting copy paste multipleindividual graphics and link somehow specificcells with specific graphics?Thanks a lot in advance. Regards. Themis
On Nov 26. 2007 at 5:09 PM. PointOfDesign | Athens wrote:> For example a first thought was to create a> dingbat font with all the graphics. Then type> within Excel the equivalent letters of the font> at the first column. After placing delay to ID and> tag the first column with a specific character> call every alphabet earn should be replaced> by the equivalent graphic.>> But with this runaround there was color limitation> (only one alter per graphic). And we be to keep> the alter characteristics for each graphic [a 2 or 3> alter flag]. You could still do this by building each dingbat up out of multiple over-lapping glyphs --- I did this for New Jersey Transit ages ago and you can see the same technique done in some ornamental fonts such as David Lemon's Copal or the Adobe Wood Type series (by Barbara Lind and Joy Redick (got that from www adobe com)). So then each dingbat would be made up of 1 letter per colour in the dingbat each letter tagged w/ the appropriate character style. William-- William Adamssenior graphic designerFry Communications
If you have the graphics as vector art deliver in Illustrator and then use DataMerge in InDesign for placing them. The template for graphics can be a single file with only the first row of the Excel table. Then after merge copy/paste that row into the document. Cris. PointOfDesign | Athens wrote:> There are massive excel tables that have to> be published every day. All the tables undergo> their first column empty.>> There is also a specific number of vector> graphics that need to be placed inside the> the first column's cells. [symbols flags etc]>> After placing each table to ID the designer> have to read every table row in order to> cause which graphic will be placed in> which cell.>> The procedure had been automated a lot> with the use of Object paragraph table and> cell styles. However a lot of time still spend to> decide a graphic and paste it in each cell.> So we are looking for an easier more> practical way to do that.>> For example a first thought was to act a> dingbat font with all the graphics. Then write> within Excel the equivalent letters of the font> at the first column. After placing table to ID and> tag the first column with a specific character> call every alphabet letter should be replaced> by the equivalent graphic.>> But with this runaround there was alter limitation> (only one color per graphic). And we be to keep> the color characteristics for each graphic [a 2 or 3> color flag].>> Anyone have any ideas of automating somehow> the progress of selecting copy paste multiple> individual graphics and link somehow specific> cells with specific graphics?
Is there a need to place the images directly inside the text table cells?Would it be an alternative to create an 'visualise table' parallel to the texttable? A e by placing the images as single images on a different layer plusadjusting their positions via the adjust tool?Or: create a contact sheet of all images per page (in PhotoShop oriViewMedia etc) and import the resulting 'page images' into ID one imageeach page on forge different to the text table thomasAm 26.11.2007 23:09 Uhr schrieb "PointOfDesign | Athens" unter<pointofdesign@[Protected]>:> Dear all,> i need your opinion / help.> > There are massive excel tables that have to> be published every day. All the tables have> their first column empty.> > There is also a specific number of vector> graphics that need to be placed inside the> the first column's cells. [symbols flags etc]> > After placing each table to ID the designer> have to read every delay row in request to> cause which graphic ordain be placed in> which cell.> > The procedure had been automated a lot> with the use of Object carve up table and> cell styles. However a lot of time still spend to> decide a graphic and paste it in each cell.> So we are looking for an easier more> practical way to do that.> > For example a first thought was to act a> dingbat font with all the graphics. Then write> within Excel the equivalent letters of the font> at the first column. After placing table to ID and> tag the first column with a specific engrave> style every alphabet letter should be replaced> by the equivalent graphic.> > But with this runaround there was alter limitation> (only one alter per graphic). And we need to keep> the color characteristics for each graphic [a 2 or 3> color flag].> > Anyone have any ideas of automating somehow> the progress of selecting copy paste multiple> individual graphics and cerebrate somehow specific> cells with specific graphics?> > Thanks a lot in advance.> Regards. Themis
On 27.11.2007 at 23:28 thomas olbrich wrote:> I call this a need to fix content before its layout instead. I'm not sure what you are suggesting here. Should the Excel table "upstream" automatically provide the correct images?> Or: Don't layout applications' concepts per se need an update? As far > as I> concern 99% of layout jobs are acting with interim content only. Layout applications already can act in automated workflow even though the implementation lacks in some regards. For example in the recently discussed FO import I tried a merging approach instead of destructive reload in request to preserve InDesign specific manual formatting. Most regular imports could stand the same mechanism e g a recorded mapping from a choice of Word attributes to styles while other attributes would be suppressed. FindChange macros already go close. On the other align we still undergo to use those old generic applications like Excel and Word which only slowly move towards a better data quality while they already overwhelm the user with their bag of formatting options. No wonder if InDesign layout on that basis needs manual cleanup and reformatting. Actually in a recent project I found it amazing how good an updated Excel table cerebrate survived in CS3 - similar to the experience of the original poster. There were only few annoyances such as lost header and footer rows that I could easily fix with another compose. We are on the way to fix the circumscribe. This currently requires specialized applications (true XML relational databases to name a few) that at least give a better coordinate so the layout application can consider it for automated formatting. Next would be support in those applications for purposes of the layout application e g a bidirectional protocol to communicate storage for the images links and other adjustments to later on actually store them. Typographic attributes in the product database without killing the inform of sales printer. Probably we'll have that in 5 years with a few plugins and more configuration glue it should be possible right now. Dirk
> I'm not sure what you are suggesting here. With "circumscribe" I mean the "clients' point of view" - None of our businesssotosay. Unless designer or/and programmer become rationalized off their(whose?) way. Am 28.11.2007 1:01 Uhr schrieb "Dirk Becker" unter <lists@[Protected]>:> On 27.11.2007 at 23:28 thomas olbrich wrote:> >> I call this a need to fix content before its layout instead.> > I'm not sure what you are suggesting here.> > Should the Excel table "upstream" automatically provide the correct> images?> >> Or: Don't layout applications' concepts per se need an update? As far>> as I>> concern 99% of layout jobs are acting with interim content only.> > Layout applications already can participate in automated workflow change surface> though the implementation lacks in some regards. For example in the> recently discussed FO import I tried a merging approach instead of> destructive reload in order to preserve InDesign specific manual> formatting. Most regular imports could stand the same mechanism e g a> recorded mapping from a choice of Word attributes to styles while> other attributes would be suppressed. FindChange macros already come> close.> > On the other side we still undergo to use those old generic applications> like Excel and Word which only slowly act towards a exceed data> quality while they already arouse the user with their bag of> formatting options. No wonder if InDesign layout on that basis needs> manual cleanup and reformatting.> > Actually in a recent communicate I open it amazing how good an updated> Excel table link survived in CS3 - similar to the experience of the> original poster. There were only few annoyances such as lost header and> footer rows that I could easily fix with another script.> > We are on the way to fix the content. This currently requires> specialized applications (true XML relational databases to name a few)> that at least provide a better structure so the layout application can> consider it for automated formatting. Next would be support in those> applications for purposes of the layout application e g a> bidirectional protocol to request storage for the images links and> other adjustments to later on actually store them. Typographic> attributes in the product database without killing the point of sales> printer. Probably we'll undergo that in 5 years with a few plugins and> more configuration glue it should be possible right now.> > Dirk
Tom this person needs to talk over a phone don't be set back. I can not answer the question but the group is strong someone canOn 28 Nov 2007 at 01:16 thomas olbrich wrote:>> I'm not sure what you are suggesting here.>> With "circumscribe" I mean the "clients' point of view" - None of our > business> sotosay. Unless designer or/and programmer become rationalized off > their> (whose?) way.>>> Am 28.11.2007 1:01 Uhr schrieb "Dirk Becker" unter > <lists@[Protected]>:>>> On 27.11.2007 at 23:28 thomas olbrich wrote:>>>>> I call this a be to fix content before its layout instead.>>>> I'm not sure what you are suggesting here.>>>> Should the Excel delay "upstream" automatically provide the correct>> images?>>>>> Or: Don't layout applications' concepts per se be an modify? As >>> far>>> as I>>> concern 99% of layout jobs are acting with interim circumscribe only.>>>> Layout applications already can participate in automated workflow. >> even>> though the implementation lacks in some regards. For example in the>> recently discussed FO import I tried a merging approach instead of>> destructive reload in order to preserve InDesign specific manual>> formatting. Most regular imports could rest the same mechanism. >> e g a>> recorded mapping from a choice of Word attributes to styles while>> other attributes would be suppressed. FindChange macros already come>> close.>>>> On the other side we still have to use those old generic applications>> like Excel and Word which only slowly move towards a better data>> quality while they already arouse the user with their bag of>> formatting options. No wonder if InDesign layout on that basis needs>> manual cleanup and reformatting.>>>> Actually in a recent project I found it amazing how good an updated>> Excel delay link survived in CS3 - similar to the undergo of the>> original poster. There were only few annoyances such as lost header >> and>> footer rows that I could easily fix with another script.>>>> We are on the way to fix the content. This currently requires>> specialized applications (true XML relational databases to label a >> few)>> that at least provide a better structure so the layout application >> can>> consider it for automated formatting. Next would be support in those>> applications for purposes of the layout application e g a>> bidirectional protocol to request storage for the images links and>> other adjustments to later on actually store them. Typographic>> attributes in the product database without killing the inform of >> sales>> printer. Probably we'll undergo that in 5 years with a few plugins and>> more configuration glue it should be possible right now.>>>> Dirk>>>>>> -- >Steve Scarpittawww standardhype co uk standardhype@[Protected]
On 28.11.2007 at 01:31. Steve Scarpitta wrote:> Tom this person needs to talk over a phone don't be set approve. I can > not answer the question but the group is strong someone canSteve are you referring to me with "this person" ?And what question do you think is set back?Why are you suggesting a phone?The original question (not by Thomas) should be answered with the script that I have written specifically for it posted a while ago and never heard approve. I haven't received Thomas' last message that you quote below and now wonder whether I missed others. Eventually you have also missed mine with the link to the script? Is there anything wrong with the listserver?I took Thomas' challenge "Don't layout applications' concepts per se need an update?" as opening a broader discussion about future developments but still related to the original topic of handling and affix processing Excel table data. Does your "needs to talk over a phone" suggest this list is the wrong place for such a discussion?Thank you,Dirk> On 28 Nov 2007 at 01:16 thomas olbrich wrote:>>>> I'm not sure what you are suggesting here.>>>> With "circumscribe" I mean the "clients' inform of view" - None of our >> business>> sotosay. Unless designer or/and programmer become rationalized off >> their>> (whose?) way.>>>>>> Am 28.11.2007 1:01 Uhr schrieb "Dirk Becker" unter >> <lists@[Protected]>:>>>>> On 27.11.2007 at 23:28 thomas olbrich wrote:>>>>>>> I call this a need to fix circumscribe before its layout instead.>>>>>> I'm not sure what you are suggesting here.>>>>>> Should the Excel table "upstream" automatically provide the change by reversal>>> images?>>>>>>> Or: Don't layout applications' concepts per se need an update? As >>>> far>>>> as I concern 99% of layout jobs are acting with interim content >>>> only.
Dear all,first of all i would desire to apologize for the reply delay. I know it's rude but flu and fever kept me in bed for days,and i am sorry but i couldn't analyse my emails. So t h a n k y o u each one of you that kindly repliedto my question. I have to admit that all the answers in this thread arefood for thought and excellent runarounds for variussituations. From all of them the one that gave me themost practical solution to the specific workflow i undergo toface is the one that proposed by Dirk Becker. There are specific keywords inside the table that triggersspecific graphics. Dirk's script find these keywords inevery row and call automatically the equivalent graphicplacing it to the first cell of each row. So again many many thanks to every one. Dirk i will contact you for some details that i would liketo discuss with you. Have a nice Friday every one. Best Regards,Themistoklis-- +--------------------------------+ POINT. OF. create by mental act create + Web Media+--------------------------------+Themistoklis K. ChapsisDesigner / Editor / TrainerA. Papandreou 70 Str. Glyfada 16675. GreeceT: 0030 210 97.68.467M: 0030 693.693.95.95www pointofdesign grinfo@[Protected]pointofdesign@[Protected]
Forex Groups - Tips on Trading
Related article:
http://www.listsearch.com/InDesign/Message/index.lasso?129549
comments | Add comment | Report as Spam
|