ports/82629: new port: textproc/xlreader - Convert .xls spread sheets to tab delimited CSV or SQL inserts

[Emanuel Haupt]

>Number:         82629
>Category:       ports
>Synopsis:       new port: textproc/xlreader - Convert .xls spread sheets to tab delimited CSV or SQL inserts
>Confidential:   no
>Severity:       non-critical
>Priority:       medium
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          maintainer-update
>Submitter-Id:   current-users
>Arrival-Date:   Sat Jun 25 01:10:16 GMT 2005
>Closed-Date:
>Last-Modified:
>Originator:     Emanuel Haupt
>Release:        FreeBSD 5.4-RELEASE-p2 i386
>Organization:
>Environment:
System: FreeBSD beaver.critical.ch 5.4-RELEASE-p2 FreeBSD 5.4-RELEASE-p2 #0: Fri Jun 10 23:25:47 CEST 2005 root at beaver.critical.ch:/usr/obj/usr/src-release/src/sys/BEAVER i386


	
>Description:
new port: textproc/xlreader - Convert .xls spread sheets to tab delimited CSV or SQL inserts

Read data from Excel spread sheets without Microsoft! Provides an API to allow
any application to read Excel documents. The xlreader tool converts Excel data
to tab delimited, CSV or SQL inserts. Written in C. Based on the the Java
version by Andrew Khan.

This project was designed out frustration.

>How-To-Repeat:
	
>Fix:

	



--- xlreader.shar begins here ---
# This is a shell archive.  Save it in a file, remove anything before
# this line, and then unpack it by entering "sh file".  Note, it may
# create directories; files and directories will be owned by you and
# have default permissions.
#
# This archive contains:
#
#	xlreader
#	xlreader/Makefile
#	xlreader/pkg-descr
#	xlreader/distinfo
#	xlreader/files
#	xlreader/files/patch-Makefile
#
echo c - xlreader
mkdir -p xlreader > /dev/null 2>&1
echo x - xlreader/Makefile
sed 's/^X//' >xlreader/Makefile << 'END-of-xlreader/Makefile'
X# New ports collection makefile for:	xlreader
X# Date created:				25 Jun 2005
X# Whom:					Emanuel Haupt <ehaupt at critical.ch>
X#
X# $FreeBSD$
X#
X
XPORTNAME=	xlreader
XDISTVERSION=	0.9.0
XCATEGORIES=	textproc
XMASTER_SITES=	http://www.giffin.org/download/
XEXTRACT_SUFX=	.tgz
X
XMAINTAINER=	ehaupt at critical.ch
XCOMMENT=	Convert .xls spread sheets to tab delimited CSV or SQL inserts
X
XMAKE_ENV+=	LDFLAGS="${LDFLAGS}"
X
XPLIST_FILES=	bin/xlreader
X
Xdo-install:
X	${INSTALL_PROGRAM} ${WRKSRC}/${PORTNAME} ${PREFIX}/bin
X
X.include <bsd.port.mk>
END-of-xlreader/Makefile
echo x - xlreader/pkg-descr
sed 's/^X//' >xlreader/pkg-descr << 'END-of-xlreader/pkg-descr'
XRead data from Excel spread sheets without Microsoft! Provides an API to allow
Xany application to read Excel documents. The xlreader tool converts Excel data
Xto tab delimited, CSV or SQL inserts. Written in C. Based on the the Java
Xversion by Andrew Khan.
X
XThis project was designed out frustration.
X
XWWW: http://www.giffin.org/xlreader.php
X
X- ehaupt
Xehaupt at critical.ch
END-of-xlreader/pkg-descr
echo x - xlreader/distinfo
sed 's/^X//' >xlreader/distinfo << 'END-of-xlreader/distinfo'
XMD5 (xlreader-0.9.0.tgz) = f09a5de0ce69d96a5ee0cff6bdbc043b
XSIZE (xlreader-0.9.0.tgz) = 45838
END-of-xlreader/distinfo
echo c - xlreader/files
mkdir -p xlreader/files > /dev/null 2>&1
echo x - xlreader/files/patch-Makefile
sed 's/^X//' >xlreader/files/patch-Makefile << 'END-of-xlreader/files/patch-Makefile'
X--- Makefile.orig	Mon Oct  1 05:18:22 2001
X+++ Makefile	Sat Jun 25 02:51:52 2005
X@@ -1,16 +1,13 @@
X-LDFLAGS=-L/usr/local/lib -lm
X-CFLAGS=-ggdb -Wall
X-CC=gcc
X OBJ=interger.o book.o record.o sheet.o handler.o cell.o sstlist.o format.o formatting.o
X HDR=biff.h interger.h record.h book.h sstlist.h format.h
X 
X all: xlreader
X 
X tester: test.o $(OBJ) $(HDR)
X-	$(CC) $(LDFLAGS) test.o $(OBJ) -o $@
X+	$(CC) $(CFLAGS) $(LDFLAGS) -lm test.o $(OBJ) -o $@
X 
X xlreader: main.o $(OBJ) $(HDR)
X-	$(CC) $(LDFLAGS) main.o $(OBJ) -o $@
X+	$(CC) $(CFLAGS) $(LDFLAGS) -lm main.o $(OBJ) -o $@
X 
X clean:
X 	rm -f *.o xlsreader
END-of-xlreader/files/patch-Makefile
exit
--- xlreader.shar ends here ---

>Release-Note:
>Audit-Trail:
>Unformatted: