Database Publishing

Database Publishing® was already significantly invented and developed by VIVA (or VIVA employees) at the end of the 1980’s. One of the first products with a Database Publishing interface was the typesetting and layout program “LinoPage” (1989-1991) and later “VivaPress” (1992-1994), “VivaPress Professional” (1994-2005) and with effect from 2005 “VivaDesigner” and “VivaNWP Designer”.

What is “Database Publishing”?

“Database Publishing®” is a technology for linking a layout program to a data source. Graphic documents can be created automatically using Database Publishing based on this connection. Instead of creating content such as text or images manually and placing them on a page, the content of a database is placed on the page using a set of rules. These rules define which content is placed in which position on the page or which typographic attributes or formatting a text should have.

What technical solutions are there for “Database Publishing”?

“Database Publishing” is not always “Database Publishing”. There are huge differences between the various solutions. VIVA distinguishes between the following „Database Publishing“ variations and solutions:

1. Manual “Database Publishing”
The manual (classical) automatic creation of documents with a desktop application, which is driven by graphic designer/expert. Manual means in this case that the graphic designer/expert must start the creation manually.

2. Semi-automatic “Database Publishing”:
Creation of documents with a desktop application. Semi-automatic means in this case that
a) content (text, images) is placed on a page in existing elements and may be assigned with attributes and collated automatically.
b) predefined elements and combinations of elements are placed on a page. This technology can be used to place ready-made page sections that could not be produced automatically on a page.

3. Fully automatic “Database Publishing”
Fully automatic creation of documents based on a template and a data source, bnut based on a server application.

With VIVA products you can of course apply all the “Database Publishing” solutions and technologies described.

What legal aspects are there for “Database Publishing”?

The term “Database Publishing®” is a registered trademark of VIVA GmbH and not a general term as is sometimes erroneously assumed. If you use the term “Database Publishing” (e.g. in brochures, on Web pages, in advertising, etc.) you must add a footnote containing the following trademark information: “Database Publishing®” is a registered trademark of VIVA GmbH. On Websites you must include a link to our Website (“http://www.viva.us”).

General Workflows and Processes with VIVA Publishing Solutions

VIVA Publishing Solutions offer you many possibilities for creating documents:

  • You can create and edit documents in the same quality on the desktop or in the web.
  • You can create and edit documents manually (“Creative Process”) or with individual limitations (“Limited Creative Process”).
  • You can create and edit documents manually in a team (“Creative Team Process”) or with individual limitations (“Limited Team Process”).
  • You can create and edit documents manually using a database (“Database Publishing” Process by Drag & Drop) or with individual limitations (“Limited Database Publishing” Process by Drag & Drop).
  • You can create and edit documents semi-automatically using a database (“Database Publishing” Process with “creative” or “intelligent” forms).
  • You can create documents fully automatically using a database or forms.
  • You can edit all documents that were created semi-automatically or fully automatically, with or without limitations.
  • With ALL processes/workflows, you can edit the documents created with VIVA in third-party programs (e.g. Adobe® InDesign®).

Thus completely new possibilities arise for the structuring of processes/workflows for the creation, editing and management of documents. In all cases, VIVA documents can be saved as PDF, JPG, XML or IDML files for InDesign®.

1. “Creative” Process
In the creative process, a user has all the functionalities of a professional typesetting and layout program, irrelevant of whether he uses the program on the desktop or in the Web. With this process, the user constructs the document completely on his own, uses existing VIVA documents or imports templates from third party programs (e.g. Adobe® InDesign®). As an additional option, you can edit the documents created with VIVA in third party programs (e.g. Adobe® InDesign®).

This process is suitable for the manual production of all print documents for which no automation is necessary.

Product: VivaDesigner (Desktop and Web Edition)

2. Limited “Creative” Process
In the limited creative process, a user has reduced editing functions, irrelevant of whether he uses the program on the desktop or in the Web. This process is useful if users should only edit certain parts of a document. In this process, a user can for example only edit the image crop, edit text and only assign predefined style sheets. The limitations can be defined individually for each document, and in the Web Edition they can also be assigned to specific roles. The creation of a suitable template takes just a few minutes.

This process is suitable for the manual editing of documents where the Corporate Design must be adhered to and when the users don’t want to learn any new software.

Product: VivaDesigner (Desktop and Web Edition)
Product: Distributed Publishing with VivaDesigner

3. Creative “Team” Process
In the creative “team” process, many users can work simultaneously on “one” document on the desktop or in the Web, without a special database or management software being necessary. For this purpose, appropriate tasks are created, whereby each task is represented by a separate file. a task file contains all the objects that a user must edit. He can however also insert his own objects.

This process is suitable for the production of complex documents like magazines, newspapers or business reports.

Product: VivaDesigner (Desktop and Web Edition)
Product: Team Publishing with VivaDesigner

4.Limited “Team” Process
With the limited “team” process, the editing functions are reduced in the same way as with the limited creative process.

Product: VivaDesigner (Desktop and Web Edition)
Product: Distributed Publishing with VivaDesigner
Product: Team Publishing with VivaDesigner

5. Database Publishing Process by Drag & Drop
With the Database Publishing Process by Drag & Drop (“Easy Publishing”, “EP” for short), a document is linked to a data source (database, CSV file, etc.). On the basis of this data source and predefined layout rules, the user can create documents semi-automatically on the desktop or in the Web by Drag & Drop. A layout rule consists of a series of instructions as to how for example images and text should be displayed or formatted. Here the user drags the content from the data source to the required text or image objects in the document to which a layout rules has been assigned. The images and text are displayed automatically according to the layout rules. The user can also add his own content that is not part of the data source.

This process is suitable for semi-automatic production of very individual catalogs based on a database, whereby the layout of the data may be freely chosen by the user.

Product: VivaNWP Designer (EP Edition)

6. Limited Database Publishing Process by Drag & Drop
With the limited Database Publishing Process by Drag & Drop, the editing functions are reduced in the same way as with the limited creative process. In this case, the user can for example only drag the database content to existing objects and not add his own content.

Product: VivaNWP Designer (EP-Edition)
Product: Distributed Publishing with VivaDesigner

7. Database Publishing Process with “creative” forms
With the Database Publishing Process with “creative” forms (“Creative Publishing”, “CP” for short), a graphic template is created on a special page. These pages are called “Forms”, the document is called a “Template”. For setting up the template and the forms, the user has all the functions of a layout and typesetting program at his disposal. Forms can also be combined with master pages as backgrounds. The master pages may be assigned either manually or by using a rule. Picture objects are linked to the database via appropriate settings. In the text objects, variables for database fields are inserted.

The user can test the data source with the form on the desktop. Here the content from the database is linked automatically to the objects in the forms. an extensive set of rules enables the manipulation of data. In this way, content may be adapted based on the rules or typographic decisions may be taken as to how the content should be displayed, depending on certain parameters.

The templates created can also be linked with content from a database fully automatically by using a server process.

Since templates with creative forms generally have no clear layout rules, this process is suitable for semi-automatic and fully automatic production of very individual catalogs on the basis of a database, which also defines the order of the data.

Product: VivaNWP Designer (CP Edition)
Product: VivaNWP Server

8. Database Publishing Process with “intelligent” forms
With the Database Publishing Process with “intelligent” forms (“Intelligent Publishing”, “IP” for short), a schematic template is created on a special page. These pages are also called “Forms”, the document is called a “Template”. While in the process with creative forms the objects have fixed positions, objects in the process with intelligent forms may be positioned dynamically. This means that the position of an object may change in connection with another object. If for example an image and text share the same area, an image must become larger or smaller if the amount of text becomes smaller or larger. Intelligent forms can consist of a whole page or also part of a page (e.g. 1/2, 1/4 page, etc. In this case, pages my be built dynamically with several different forms and combined in any way. As well as text and picture objects, complex tables, charts/graphs and bar codes can be created dynamically.

The user can test the data source with the form on the desktop. Here the content from the database is linked automatically to the objects in the forms. an extensive set of rules enables the manipulation of data. In this way, content may be adapted based on the rules or typographic decisions may be taken as to how the content should be displayed, depending on certain parameters.

The templates created can also be linked with content from a database fully automatically by using a server process.

Since templates with schematic forms have very clear layout rules, this process is suitable for semi-automatic and fully automatic production of price lists or catalogs on the basis of a database.

Product: VivaNWP Designer (IP Edition)
Product: ViivaNWP Server

9. Form-based Process
In every VIVA document, you can store manual or automated XML data in XMP format, which can be imported or analysed from another desktop or Web application. This technology is frequently used to apply individual and freely definable Meta data to documents. This can for example be Meta data for further editing such as information about the paper type to be used, the binding type or a pricing structure.

With a VIVA template with creative and/or schematic forms, the XML data may for example define a form that is analysed and displayed by a Web application. In this way a VIVA template with creative and/or schematic forms may be created not only on the basis of a separate data source, but also for individual entry.

This process is particularly suited for automated production of business cards, invitations and other printed matter that are not produced from a database.

General Production Types with VIVA Publishing Solutions

VIVA is one of the leading technology companies worldwide in optimizing marketing processes. Hardly any other manufacturer of standard software offers more options for optimizing marketing processes. VIVA offers four different types of publishing productions:

  • Fully automatic production,
  • Semi-automatic production,
  • Manual production, or
  • Combined production

Option 1: Fully automatic production

With a fully automatic production using VIVA publishing servers, the employees normally don‘t have to learn any new software: The VIVA publishing servers can be integrated into every workflow, so that many users create the marketing documents with a keystroke straight from SAP, MS Navision or other applications such as Excel, Access or Web portals.

For this reason too, the installation of special software on the employee’s workstation is usually unnecessary.

Since the documents are produced in real time, long delays have become a thing of the past. The employee receives the results within just a few seconds. Therefore a document can generally be produced much more cheaply, since with this method all manual tasks become superfluous. A positive side effect: Thanks to the integrated rule system, sources for errors are reduced considerably. The cleft between print and databases or enterprise resource planning (ERP) is closed. Incorrect information such as article numbers, prices or descriptions and technical data in printed matter is finally brought to an end.

Option 2: Semi-automatic production

Even with semi-automatic production, the employees don’t have to learn any new software: With Database Publishing® tools from VIVA, your employees will, after a brief training, create documents that conform to your CD by Drag and Drop. The software can be used on the desktop or even in the Web.

Option 3: Manual production

Even with manual production using VivaDesigner, the employees don’t have to learn any new software: With this software, your employees will immediately create documents that conform to your CD. With the “Distributed Publishing” technology, the program functionality can be steered or reduced in individual stages for every single document. Therefore an employee with basic knowledge of word processing or photo books can work with a complex layout program without training. The company decides the extent of the layout functions that the employee will receive. Furthermore: VIVA is the only supplier worldwide to offer a professional layout program with the same functionality both on the desktop and also in the Web. Through the unique functionality of embedding fonts in an open document, no fonts need to be installed on the employee’s computer. Last but not least: With the “Team Publishing” technology, several employees can even work simultaneously on one document. Even the graphic designer doesn’t need to learn any new software or create documents from scratch, as VIVA products can exchange documents with Adobe InDesign in an excellent quality.

Option 4: Combined production

All types of production can also be combined with one another. Thus a document that has been produced fully automatically can be edited in a manual process at any time.

Publishing solutions and concepts for software developers, IT and service companies

Easily integrate VIVA Publishing applications into your desktop, server or Web application and design/create perfect PDFs, VIVA, XML, or InDesign® documents manually or even fully automatically.

VIVA Publishing applications are the perfect solution for all Web-to-Print, Shop, PIM, CRM, ERP, MIS, MAM, DAM developers, IT consultants, SAAS & Cloud providers, System Houses, etc.

It doesn´t matter if you are a beginner or already work with other libraries to create open documents or PDFs: The VIVA Publishing products and technologies considerably reduce your developer workload and at the same time provide an open system, which offers you and your customers completely new workflows and technical possibilities.

Design manually or create fully automatically:

Optimize your publishing and marketing processes according to your requirements: Design manually, with full or even restricted editing rights, with the desktop or Web edition of VivaDesigner directly in your application. Create documents fully automtically based on templates from databases or other data sources directly in your application.

Manage documents in your application:

VivaDesigner can open and save documents in all supported formats (VIVA, IDML, XML, etc.) directly in databases, Intranet or Internet applications. Thus you can for example ensure that users cannot save your documents locally on their own computers.

Read your parameters from the documents:

VIVA programs support the XMP format for standard information (page preview, document information, etc.) and enables the individual extension of user information in XMP format.

Write or read VIVA documents:

Write or read parts or complete documents in your application, as VivaDesigner documents can be saved completely in XML format.

Transform text into any designs:

With a simple XSL transformation you convert formatted text to HTML on the basis of a “CSS”.

Work with Adobe® InDesign® documents:

With the IDML support module, you can edit and save Adobe® InDesign® documents (from CS4) in your applications.

Any questions?

Call us today or send us a message with our contact form.

If you want more information about VIVA publishing processes click here.