/ 
FTN-Database-0.13
River stage one • 2 direct dependents • 2 total dependents
/ nl2ftndb

NAME

nl2ftndb - Load information to a Nodelist table in an Fidonet/FTN SQL database.

VERSION

Version 0.13

DESCRIPTION

Initial load of a particular Fidonet/FTN St. Louis Format Nodelist into an SQL Database for Fidonet/FTN processing. The SQL Database engine is one for which a DBD module exists, defaulting to SQLite.

SYNOPSIS

nl2ftndb -n nodelist_directory [-t tablename] [-T db_type] [-D db_name] [-u db_user] [-p db_password] [-f nodelist_file] [-l log_file] [-d domain] [-e] [-v] [-x] [-z zonenum]

nl2ftndb [-h | --help]

OPTIONS

-l

This would be the filename and path of a log file, with the default being ftnpldb.log in the current directory.

-v

Verbose option.

-x

Debug option.

-T

Database type. This needs to be a database type for which a DBD module exists, the type being the name as used in the DBD module. The default type is SQLite.

-D

Database name. For an SQLite databse; this needs to be at least the filename and can also include a path, and defaults to the file name ftndbtst.

-u

Database user. For an SQLite database, this defaults to an empty string as it does not need it.

-p

Database password. For an SQLite database, this defaults to an empty string as it does not need it.

-n

The nodelist directory being used. This is required, so if it is not set the program will exit displaying a help message.

-f

The nodelist file. If the -e option is also set, then his is an exact file name. If -e is not set, then this is the basename of the nodelist files.

-e

If set, then the -f option must be exact file name. If not set, then the -f option is basename of nodelist file.

-t

The nodelist table name to be used. Note that if there is a period in the name, that period will be changed to an underscore.

-z

If defined; is the only zone to be loaded

-d

If defined, this is the domain of the nodelist being loaded. Defaults to fidonet.

EXAMPLES

Given that $NLDIR is the directory where the nodelist files can be found and that $NLFILE is a base filename like NODELIST and that $DBFILE is existing SQLite database file, the following command line can be used to load a nodelist from set of the set of nodelist files all with the same basename:

nl2ftndb -D $DBNAME -n $NLDIR -f NODELIST -d fidonet -v

Given that $NLDIR is the directory where the nodelist files can be found and that $DBFILE is an existing SQLite database file, the following command line can be used to load a specified zone from a specified nodelist:

nl2ftndb -D $DBFILE -n $NLDIR -f nodelist.197 -d fidonet -z 1 -e -v

AUTHOR

Robert James Clay, <jame at rocasa.us>

BUGS

Please report any bugs or feature requests to bug-ftn-database at rt.cpan.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=FTN-Database. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.

SUPPORT

You can find documentation for this module with the perldoc command.

perldoc nl2ftndb

You can also look for information at:

SEE ALSO

L<FTN::Database>, L<FTN::Database::Nodelist>, L<ftndbadm>,
L<ftndbadm>, and L<listftndb>

COPYRIGHT & LICENSE

Copyright 2010 Robert James Clay, all rights reserved.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.