From owner-freebsd-ports-bugs@FreeBSD.ORG Sat Jun 25 01:10:18 2005 Return-Path: X-Original-To: freebsd-ports-bugs@hub.freebsd.org Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A58CE16A41C for ; Sat, 25 Jun 2005 01:10:18 +0000 (GMT) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6960043D55 for ; Sat, 25 Jun 2005 01:10:18 +0000 (GMT) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.13.3/8.13.3) with ESMTP id j5P1AGVe007881 for ; Sat, 25 Jun 2005 01:10:16 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.13.3/8.13.1/Submit) id j5P1AGtg007880; Sat, 25 Jun 2005 01:10:16 GMT (envelope-from gnats) Resent-Date: Sat, 25 Jun 2005 01:10:16 GMT Resent-Message-Id: <200506250110.j5P1AGtg007880@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Emanuel Haupt Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id AFBFC16A41C for ; Sat, 25 Jun 2005 01:01:56 +0000 (GMT) (envelope-from ehaupt@beaver.critical.ch) Received: from beaver.critical.ch (217-162-251-247.dclient.hispeed.ch [217.162.251.247]) by mx1.FreeBSD.org (Postfix) with ESMTP id 31D2C43D48 for ; Sat, 25 Jun 2005 01:01:56 +0000 (GMT) (envelope-from ehaupt@beaver.critical.ch) Received: from beaver.critical.ch (localhost [127.0.0.1]) by beaver.critical.ch (8.13.3/8.13.1) with ESMTP id j5P11ptm031117 for ; Sat, 25 Jun 2005 03:01:51 +0200 (CEST) (envelope-from ehaupt@beaver.critical.ch) Received: (from ehaupt@localhost) by beaver.critical.ch (8.13.3/8.13.1/Submit) id j5P11pbN031116; Sat, 25 Jun 2005 03:01:51 +0200 (CEST) (envelope-from ehaupt) Message-Id: <200506250101.j5P11pbN031116@beaver.critical.ch> Date: Sat, 25 Jun 2005 03:01:51 +0200 (CEST) From: Emanuel Haupt To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Cc: Subject: ports/82629: new port: textproc/xlreader - Convert .xls spread sheets to tab delimited CSV or SQL inserts X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Emanuel Haupt List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 25 Jun 2005 01:10:18 -0000 >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@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 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@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 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@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: