virtual-ldap/bin/csv2yaml.pl

#!/usr/bin/perl

use warnings;
use strict;

# cvs2dbi.pl
#
# 03/15/2009 05:06:53 PM CET Dobrica Pavlinusic <dpavlin@rot13.org>

use Data::Dump qw/dump/;
use File::Slurp;
use YAML qw/DumpFile/;
use Text::CSV;
use Encode qw/decode/;

my $debug = 0;

my $path = shift @ARGV || die "usage: $0 file.csv\n";

my $csv = read_file( $path );
$csv = decode('utf-16', $csv);

my @columns;

foreach my $line ( split(/\r?\n/, $csv) ) {

        warn "## $line\n";

        my @fields = split(/;/, $line);
        if ( ! @columns ) {
                @columns = @fields;
                warn "# columns = ",dump( @columns ) if $debug;
                next;
        }

        my $hash;

        warn "# fields = ",dump( @fields ) if $debug;

        $hash->{ $columns[$_] } = $fields[$_] foreach ( 0 .. $#fields );

        warn dump( $hash ) if $debug;

        my $uuid = $fields[0];

        DumpFile( "yaml/$uuid.yaml", $hash );
}
1	#!/usr/bin/perl
2
3	use warnings;
4	use strict;
5
6	# cvs2dbi.pl
7	#
8	# 03/15/2009 05:06:53 PM CET Dobrica Pavlinusic <dpavlin@rot13.org>
9
10	use Data::Dump qw/dump/;
11	use File::Slurp;
12	use YAML qw/DumpFile/;
13	use Text::CSV;
14	use Encode qw/decode/;
15
16	my $debug = 0;
17
18	my $path = shift @ARGV \|\| die "usage: $0 file.csv\n";
19
20	my $csv = read_file( $path );
21	$csv = decode('utf-16', $csv);
22
23	my @columns;
24
25	foreach my $line ( split(/\r?\n/, $csv) ) {
26
27	warn "## $line\n";
28
29	my @fields = split(/;/, $line);
30	if ( ! @columns ) {
31	@columns = @fields;
32	warn "# columns = ",dump( @columns ) if $debug;
33	next;
34	}
35
36	my $hash;
37
38	warn "# fields = ",dump( @fields ) if $debug;
39
40	$hash->{ $columns[$_] } = $fields[$_] foreach ( 0 .. $#fields );
41
42	warn dump( $hash ) if $debug;
43
44	my $uuid = $fields[0];
45
46	DumpFile( "yaml/$uuid.yaml", $hash );
47	}