connecting Drupal with InCopy / XML?

Events happening in the community are now at Drupal community events on www.drupal.org.
velemiran's picture

Hey guys,

I'm the editor of a Harvard weekly called The Voice. Our online edition is based on Drupal, check it out at www.theHvoice.com
Anyhow, I was wondering if anyone has any idea how to connect InCopy with Drupal - in other words, to export XML to Drupal,
and use Drupal as a true newsroom CMS?

Best,
M.

Comments

InCopy - Drupal

Joe_Barron's picture

Hello,

I am working for several small newspapers in Kansas and we are using InDesign and are wondering the same thing. I am new to Drupal but have a dev server where we are developing our sites with Drupal 6 and would appreciate any help you may be able to provide as far as how you got your site looking the way it does right now such as themes, modules and what not.

Thanks,

Joe Barron

Joe Barron

XML

Paris_Finley's picture

http://en.wikipedia.org/wiki/XML_transformation_language may be what you're looking for...

We transform our XML to data first and then upload it to the MySql tables.

See the results at http://www.gazettenet.com

Hope that helps.--Paris

The truth, the whole truth, and nothing but the truth.

If you only want to use

stdbrouw@groups.drupal.org's picture

If you only want to use Drupal to display exports from InDesign, InCopy will still serve as the 'real' newsroom CMS, won't it?

InDesign - Drupal Import

Joe_Barron's picture

We design the newspapers in InDesign...Save as PDF's and print from those...I am trying to learn how to export the InDesign files into Drupal content

Joe Barron

Interesting...

talyia's picture

I am VERY interested in learning more about this approach for our own newspaper here.
Can one get by with just InDesign or does InCopy also need to be in the mix?

Christine

Script InDesign/InCopy styles to XML tags

geoffb's picture

One approach would be use JavaScript/AppleScript/VBScript which is built in to InDesign/InCopy to transform InDesign/InCopy styles to XML tags.

Then, as Paris_Finley above says, transform the XML and upload it to the MySql tables or maybe use XSLT.

Geoff

Transforming

Paris_Finley's picture

Yes, Geoff is correct. I suggest that anyone seeking to use XML sources consider this workflow:

Source application --> XML --> XSLT (XSL stylesheet with transformation info, aka "a transform") --> MySql db -- Drupal.

If the transformation part is unknown to you, go here: http://www.w3schools.com/xsl/xsl_transformation.asp
It's a free, online tutorial. I taught myself what I needed to know to get rolling in just a couple of hours, but I was already familiar with XPath. If you're not, spend an hour on that first. Don't be scared. This isn't bad at all.

There are other ways to effect the transformation, but the XSLT is certainly simple and easy (and can be automated).

The truth, the whole truth, and nothing but the truth.

Web to Print?

tfo's picture

What about the other direction? Is anyone using Drupal as the engine for a web-to-print scenario where material is prepared first for the Web and then output for use with InDesign or other print publishing solutions?

Web to Print instead (see comment above)

Paris_Finley's picture

By now, the importance of web should probably have us thinking web-to-print instead of the more widely practiced print-to-web workflow. The holdup seems to be a combination of the culture's resistance to change coupled with the fact that the demands of styling for print are generally more complex and more difficult to implement than the demands of styling for web.

The truth, the whole truth, and nothing but the truth.

Check out Printcasting

pachecod's picture

I agree 100%! That's partly what we're working on with Printcasting, which is being built in Drupal and will eventually be open-sourced. It's not only web-to-print, but distributed and CMS neutral. We're using RSS feeds instead of feeds from just one system. You can learn more about it at http://printcasting.com

Paris_Finley, You are

bvanderberg's picture

Paris_Finley,

You are absolutely right in regards to the print-to-web and web-to-print battles that we face today. A lot of companies who have had their workflows dependent on print for years have dependent on.

I believe that much of this comes from the fact that with print the final product was on paper, which is not editable, so it doesn't completely matter if the code might have been messy beforehand, if it looked right on paper, it didn't matter. Because the web is digital, people are more conscious of how the data is structured and make compromises to the design of things in order to maintain the accessibility to systems. These two philosophies clash and people often coming from the web world often simplify print, when in truth there is a lot of complexity.

-
Ben Vanderberg
DPCI

web2print

kpaul's picture

I'm doing web to print. It's just old fashioned cut and paste, though, as I'm forced to layout pages in Pshop at the moment. (No, I'm not kidding...) I'll hopefully have InDesign soon and will begin to experiment with that.

All the content for my free tab is from the website, though - http://www.andersonfreepress.net

Thanks,
kpaul

Photoshop? Seriously? Are

Garrett Albright's picture

Photoshop? Seriously? Are you sending giant bitmaps off to press?

Yes, I'm serious, unfortunately...

kpaul's picture

I'm a cash strapped 'grassroots journalism' start-up. Heh.

I export postscript which we run through distiller to get our PDFs...

It's not too bad, as long as I don't have to change things around too much. Heh.

There's a low res PDF version of the first issue on http://www.journalismhope.com somewhere.

Have you considered Scribus?

Garrett Albright's picture

Have you considered Scribus? It's an open-source page layout program. (They've got a Drupal-powered site, even.) I haven't tried it personally, but I know it's been around for a while.

Or, if you don't want to pay out the nose for InDesign, there's Apple Pages, which I have personally used. Those wanting a pro-level tool might be frustrated by it, but it's reasonable for mere mortals to use, and at $80 (along with the rest of the iWork suite) the price is fair.

I've tried Scribus. While I

bvanderberg's picture

I've tried Scribus. While I really would love to love Scribus, for a lot of traditional print guys it just isn't there. There isn't some of the control they would want, nor did I find in my testing the program to be particularly stable. It is a shame though, as I want it to succeed.

If you are strapped on cash, you might consider purchasing an older version of InDesign. For most of people's needs, they don't need the latest and greatest ID. Even if you want to dive into InDesign XML work, the engine hasn't changed much since CS3. The only thing you may be missing out on is if you are getting into the Adobe Digital Publishing Suite.

-
Ben Vanderberg
DPCI

Running xml-import

espenmoe's picture

At Journalisten.no we have created a xml-based workflow for Drupal.

http://groups.drupal.org/node/15543#comment-52790

Espen

Web2Print via Open Source Approach

onprintshop's picture

Hi,

We have developed web2print technology on open source platform. We have flash based designer studio which produces XML files for canvas. Further Engine written in php parse it and map it with PDFlib to export PDF files which are CMYK Compatible and print ready.

Solution we designed does not need Adobe or Other server to be installed. Good things is more then 30 customers are using it happily.

See live demo at http://www.onprintshop.com

Drupal and InDesign/InDesign Server (CS5, CS5.5, CS6)

joebachana's picture

Hi all,

Just a heads up that we've been working for the past 9 months on a bidirectional connection between InDesign and Drupal (7). The idea is you can search for a node within Drupal, then drag down a field into a frame on the InDesign page. Thereafter, we preserve the relationships on page such that edited text on the page can then be updated as a new Drupal node revision.

The integration is with services module right now, although we'll likely expand on that and create a submodule since this is obviously a very 'esoteric' integration. As for our go-forward plans, we'll probably concentrate all of our efforts on InDesign CS6 given the improved features.

As for Drupal to InDesign Server, years ago we built a web services layer around IDS -- in .NET I'm afraid, but we've got that fully integrated with Drupal (also v7). It would take us a huge amount of effort to convert the work over to PHP, so we're a bit stuck on that front. I think if we won some kind of project that might help fund the port.

Anyway, DM me if you want to learn more about what we're doing. As any of you who have tried this in the past know, this is a huge amount of work, so if anybody's interested in lending a hand, let me know.

Joe Bachana
First Employee at DPCI
1560 Broadway
NY, NY 10036
212.575.5609
www.dpci.com

Interesting

attiks's picture

Joe, I'm looking for something similar and just wondering on how much of it will be open sourced?

Newspapers on Drupal

Group organizers

Group categories

Topics - Newspaper on Drupal

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: