Re: Can I use Publisher to create our University Catalog?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mac Townsend (mactno_at_spamadcomgraphics.com)
Date: 01/10/05


Date: Mon, 10 Jan 2005 11:47:08 -0800

Very realistic. ANd with the proper tools and skill set, quite easy.

IMHO, a project of this sort is best handled via what's called "Database
Publishing" where the content is in a database (such as Access, or
FoxPro, or Approach, or Filemaker, etc) and one uses the dtp/dbp
application to write a "recipe" for going out into the database and
extracting, sorting, and importing the information in formatted
conmdition. A "mail merge" kind of thing but vastly more powerful and
specifically oriented.

Each content item would be a different field in a course record.

Think of a record as a single index card and the fields as lines on the
cards. Each card would have the same exact lines, (but it woould not be
necessary for each record to have all fields completed)

As a made up example:

field Name: Desktop Publishing

field Number: DTP102

field description: Blah blah, blah

field credits: 2

field meets: Tue-Thurs 8AM Rm 237

and so on.

Hundreds of different records, even thousands, could be accommodated in
the database. At any given time one can open the data base and very
quickly go to the specific cour record and make changes.

Once properly done, all up-dates are made to the database and a new
"published" copy can be acheived in minutes. *That's right, minutes.*

I have several 100+ page photo directories containing names, addresses,
and photos of some 800-900 organization members. After annual edits for
the yearbook, it takes less than 15 minutes to generate the pages
complete with photos in position.

Getting it set up correctly can be quite a chore but it needs be done
only once (keep notes while doing it in case you need to edit it later).

Keeping everything in a large Word file (large Word docs are very
susceptible to corruption and data loss) is risky and very labor
intensive. In effect, you are keeping a copy of the piublication then
scrolling around to edit entries and add new ones. You could edit 5 data
base records in the time it takes you to find and edit one on a Word
file.

Publisher has a module that can do this--sort of. Depending on how
simple your layout it, it could do the job...but I would seriously test
it before copmmitting the job to it.

Ventura Publisher (from Corel Corporation) has a module specifically for
this and it works great--I've used it for 10 years. One can buy add-ons
for Quark and InDesign to do essentiially the same thing.

Such a project will be a serious learning experience. You will not be
able to do it in an afternoon. There are no pre-figured "templates" that
will do the work for you.

In <84D99F74-2FB6-4B1A-A7CC-0C66681E1DF8@microsoft.com> Robert wrote:
> I am researching different products and would like to know if
> Publisher can handle this - I think I may be asking too much of it...
>
> We have a "master file" of all the information that goes into our 200+
> page University Catalog. We would like to update the master file as
> the months go by and at any time be able to generate two versions (
> one for print and one for web).
>
> How realistic is this?
>
> Thanks,
> Robert
>



Relevant Pages

  • Re: One more (maybe stupid) database question
    ... AlwaysShowEditor just automatically enables Edit when a record is selected, ... This makes sense for a database with a single file, ... database that you can run queries against. ... of TechIDs, for instance, but I write updates directly to the tables. ...
    (comp.lang.pascal.delphi.misc)
  • Re: Can a lone computer have Access db problems?
    ... His current problem was that he was not able to edit the data ... nor was his permissions changed). ... certain computers to misbehave). ... When you say he is "authorized", that sounds as if the database is ...
    (comp.databases.ms-access)
  • Re: Many Instances
    ... Data in the database is from importing many excel files. ... It can be tough to make sure that 2 people aren't editing the same record. ... someone attempts to edit a record ... ... power button, or loses network connectivity, etc) since this will leave the flag field set to True even if no one is ...
    (microsoft.public.access.modulesdaovba)
  • Re: does textpattern have a forum for discussing issues?
    ... I moved the files and the database but I'm still ... getting an error message: ... I rebuilt a site that once ran on Textpattern. ... To find a page (in order to edit it) they had to negotiate a series ...
    (comp.lang.php)
  • Re: Putting database on a network drive
    ... I have built my 1st database and it is ready to go on a shared network ... You can apply user level security to an mdb file. ... the database but only let myself edit the database. ... search through the form that opens but then have a password for me or ...
    (comp.databases.ms-access)