EleExxel - price list calculator and database publishing in one
EleExxel generates well-formatted
MS Excel sheets from the data in Elestore and it is therefore the easiest form of database publishing suitable for every average PC user.
EleExxel also calculates customer specific prices for use in the generated product and price lists so that customer specific price lists become a snap.
Basic knowledge of MS Excel is all you need!
- Generate well formatted MS Excel sheets from Elestore content
- Offers the simplest form of database publishing
- Generate nicely formatted and individually calculated product
and price lists in MS Excel
- Generate product lists in HTML with links to detailed product
pages in HTML and/or to the EleAIS web server database.
EleExxel is available in different forms:
- As stand-alone product incorporating a basic version of
the Elestore content database
- As an optional module extending Elestore
- As a combined product together with Elecalc, Elequote and/or
other members of EleFamily
- Or as an integral part of ElePricelist, which always comprises
of the full EleExxel product.
EleExxel automates MS Excel
MS Excel has excellent formatting and printing as well as very
comprehensive exporting capabilities with support for many different
data formats. Almost everybody knows how to use MS Excel and
this software is available on most computers anyway.
EleExxel "drives" MS Excel as a slave turning MS Excel into a database publishing engine.
EleExxel feeds data from Elestore automatically into an MS Excel sheet. The cells of this sheet are formatted by EleExxel depending on a user-defined template and on many user-defined settings.
EleExxel acts on the Elestore data as an
output and print generator as well as an export manager supporting
most physical data formats in use today.
The standard Elestore software already fully embeds MS Excel
both as a QuickEditing tool as well as an export target for
data from the Elestore database. This has been available since
one of the first Elestore releases way back in early 2004. And it's the fastest and simplest way of editing data.
EleExxel now extends this by providing even far more comprehensive
capabilities in using MS Excel especially for formatting multi-line
data output from the Elestore database. EleExxel provides simple,
quick, yet very powerful features for using MS Excel as an universal
output and print generator and a product and price list generator
for data in Elestore.
Everybody who has basic MS Excel knowledge can create individually formatted EleExxel
templates or extend those template files that come with the
Three types of output and templates
There are three different types of templates and forms of output,
which can be generated by EleExxel:
EleExxel with repeatable templates
When using "repeatable templates" one MS Excel template
sheet is duplicated as many times as there are article objects
to generate. Each of these repeated copies will be filled with
the data of one article object. As a consequence, each of these
copies of the template file looks fairly identical in their
layout although each of them contains different data.
This one repeatable template sheet therefore defines the layout
and the formatting of all exported data objects although the
number of generated rows can vary depending on the existence
or absence of data content. This template type contains links
to data fields but no references to data objects whose data
is generated, because they are defined by searches, selections
or externally by the operator.
This form of using EleExxel is the preferred one when a relatively
large amount of data objects is to be generated fully automatically
in a fairly uniform layout. Creating this one repeatable template
is much simpler and quicker compared to the two other template
types, which allow much more individual and varying layouts.
Any MS Excel user can handle this.
EleExxel with predefined, non-repeatable template pages
This type of EleExxel template sheet allows much more individual
and flexible layout and formatting structures. The fundamental
difference to the repeatable template is in the fact that the
pages exist preformatted in the template file but yet without
content, of course, because no automatic duplication of the
template is performed in this case.
This type of EleExxel template contains links to data fields
as well as to data objects while the repeatable template type
only contains references to data fields and the objects whose
data is generated are defined by searches, selections or externally
by the operator.
The automation offered by this template type is in the fact
that the template sheet is fully automatically filled with varying
data by EleExxel. However, every page must already be contained
in the template file, because no automatic duplication of repeated
layouts takes place in this case.
The great advantage of this template type is in the very much
higher flexibility of individually designing pages, which are
then automatically filled by EleExxel with up-to-date content
from the database. This template type is ideally suit-able for
very differently formatted product or price lists where many
or even each page can look different from the rest.
EleExxel generating one mother article per page primarily
The third type of EleExxel template sheet allows generating
one page for every article object. This is primarily used for
generating HTML pages from Elestore content. In these cases
one generated page typically consists of one article object
and its variants, in other words one-page consist of one mother
article and some or all of its children (variants).
This template type is the preferred solution when generating
HTML pages with EleExxel but it is only rarely suitable for
output to PDF or the printer.