LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 03-13-2004, 10:41 PM   #1
JaseP
Senior Member
 
Registered: Jun 2002
Location: Eastern PA, USA
Distribution: K/Ubuntu 12.04/14.04, Scientific Linux 6.3/6.4, Android-x86, Pretty much all distros at one point...
Posts: 1,791

Rep: Reputation: 157Reputation: 157
Document Automation in Linux???


Here's the story:

I teach martial arts (as an avocation). My instructor has a school about 80 miles away. Back when I was practicing Law, I used HotDocs to generate some of my legal documents. What it is, is essentially a front end to manage macros that create documents...

Long story to short (you might not think so, but really it is the short version), I used this software to create templates that generate the rank certificates (name, rank, and date fields are filled in on fancy pre-printed certificate stock by a laser printer), and promotion lists that get put up on the school's bulletin board. This software works in Windoze. No Linux version.

My instructor's children and staff (mid-teens and early twenties) are intent on bogging down his Windoze network with mp3 downloading stuff, etc. The systems end up crawling every few months and need to be flushed of the crap they are putting on them. There is software that runs the seperate workout gym part of his business. It runs on Windoze, and so at least one Windoze workstation is necessary. That machine sits out as a kind of kiosk that the gym users use to sign in. The martial arts school machines are used just to surf the web and for word-processing, and online banking. They can be switched to Linux, which will prevent the kids from mucking them up, and allow him to do his business. I can't set up the Windoze machine that runs the gym software to be the one that also runs the document automation stuff. That has to run on one of the other systems. To convince him to switch to Linux (and maintain his sanity where it comes to computers), I need to be able to show him that he can do everything he currently does on Windoze, on Linux.

Does anyone know of a way that the mail-merge function in Open-Office can be used in a nice, user-friendly way to generate the certificates???
 
Old 03-14-2004, 08:31 PM   #2
JaseP
Senior Member
 
Registered: Jun 2002
Location: Eastern PA, USA
Distribution: K/Ubuntu 12.04/14.04, Scientific Linux 6.3/6.4, Android-x86, Pretty much all distros at one point...
Posts: 1,791

Original Poster
Rep: Reputation: 157Reputation: 157
Ok,...

It's been about 24 hrs,...

Anyone???
 
Old 04-03-2004, 04:24 PM   #3
JaseP
Senior Member
 
Registered: Jun 2002
Location: Eastern PA, USA
Distribution: K/Ubuntu 12.04/14.04, Scientific Linux 6.3/6.4, Android-x86, Pretty much all distros at one point...
Posts: 1,791

Original Poster
Rep: Reputation: 157Reputation: 157
Hmmm,


I was thinking of using knoda to do this, in conjunction with OpenOffice.org. Has anyone tried anything like this??? I'm not really up on how to get knoda working and would appreciate any input.
 
Old 04-03-2004, 04:48 PM   #4
kev82
Senior Member
 
Registered: Apr 2003
Location: Lancaster, England
Distribution: Debian Etch, OS X 10.4
Posts: 1,263

Rep: Reputation: 50
i answered a similar question to this a while ago, see if this is any good to you

http://www.linuxquestions.org/questi...threadid=81366
 
Old 04-04-2004, 06:24 PM   #5
JaseP
Senior Member
 
Registered: Jun 2002
Location: Eastern PA, USA
Distribution: K/Ubuntu 12.04/14.04, Scientific Linux 6.3/6.4, Android-x86, Pretty much all distros at one point...
Posts: 1,791

Original Poster
Rep: Reputation: 157Reputation: 157
Close, but not quite...

The problem is that I need a relational database set of data that can give me a multiple choice field in the inputs so I can change the rank of each student as they progress, and add new ones, plus change the date of the test and the school from which the students are training in. The database then has to sort them first by rank and then by student (or black belt) number. Then, the mail-merge must assemble a promotion list and individual certificates, which fill in the empy fields on pre-printed certificate card stock (a little bigger than 8.5x11 inch paper, and much denser).

If I could find a spreadsheet that could allow for multiple choice text fields for one column, then be available for a mail merge,... I'd be 1/2 way there...
 
Old 04-04-2004, 07:23 PM   #6
kev82
Senior Member
 
Registered: Apr 2003
Location: Lancaster, England
Distribution: Debian Etch, OS X 10.4
Posts: 1,263

Rep: Reputation: 50
if you can program then id suggest grabbing a small sql server/library like sqllite and write a simple front end for it, then for your printing get it to produce a TeX input file.

ive just had a quick play with gnumeric and in format->cells->validation theres an option to choose cell values from a list, and according to google you can do mailmerge but it wont be as functional or as easy to use as my first suggestion.

have you tried posting to an open office or star office newsgroup? im sure they have ways to do stuff like this.
 
Old 04-05-2004, 12:10 AM   #7
jschiwal
LQ Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 670Reputation: 670Reputation: 670Reputation: 670Reputation: 670Reputation: 670
Open Office put out a Resource Kit, which should be available in the book stores. Chapter 36 covers "Creating and Using Forms, Controls, and Events.

You can get sample forms and templates at: www.getopenoffice.org/templates.html

Using OpenOffice may be advantageous because it is also available in windows, if the instructor would rather learn one thing at a time.
 
Old 04-07-2004, 01:23 PM   #8
JaseP
Senior Member
 
Registered: Jun 2002
Location: Eastern PA, USA
Distribution: K/Ubuntu 12.04/14.04, Scientific Linux 6.3/6.4, Android-x86, Pretty much all distros at one point...
Posts: 1,791

Original Poster
Rep: Reputation: 157Reputation: 157
I'll take a look at that.

I DL'd some of the templates and will see if I can do something similar to create the effect I want...
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i create a document, then a directory and save the document in it. jtdodge Linux - Newbie 9 06-15-2005 12:03 PM
Linux and Document and Settings Folder Ionmag Linux - Newbie 2 03-10-2005 11:20 PM
Convert openoffice document into ms document through cli? bruno buys Linux - Software 0 07-05-2004 10:59 AM
Linux ate my document and I want it back Rundi Linux - General 5 03-16-2004 06:29 AM
How do I compile a *.cpp Document in linux? njbrain Linux - Software 9 01-29-2004 08:43 PM


All times are GMT -5. The time now is 09:16 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration