If
you have a question on how to do something in Perl, or
you need a Perl solution to an actual real-life problem, or
you're unsure why something you've tried just isn't working...
then this section is the place to ask.
However, you might consider asking in the chatterbox first (if you're a
registered user). The response time tends to be quicker, and if it turns
out that the problem/solutions are too much for the cb to handle, the
kind monks will be sure to direct you here.
If it is called as get_ids( 'format' => 'json' ); it works fine but asking it to return a text string returns undef and warns Useless use of string in void context at line 229. The way I think it should work is that if $result{'message'} evaluates as true, that will get returned but if it evaluates as false then "$result{'api-key'}:$result{'session'}" wil be returned instead.
Can you explain why this is not behaving as expected?
As an aside, in searching for an answer I found this post -> Useless use of string in void context
There it is suggested that Perl reports the wrong line number for this warning so it is quite possible that I'm actually looking in the wrong place!
I'm perplexed. Can you tell me what is wrong with this script?
#!/usr/bin/perl -w
use strict; use warnings; use diagnostics;
use File::Find;
open (my $t, '>', '/home/myuser/myfilename.sql') or die $!;
print $t "blah blah\n";
find( { preprocess => \&hi, wanted => \&work, postprocess => \&bye, fo
+llow_skip => 1 }, ".");
sub hi { print $t "hi\n"; return;} # works correctly
sub bye { print $t "bye\n"; return;} # works correctly
sub work { print "my name is: ", $File::Find::name;
print $t "I'm a file!";
return;}
close $t;
Searching CPAN I was rather surprised that the only general modules for connecting to LinkedIn seem to be WWW::LinkedIn and Net::Linkedin::OAuth2 - both of these date from before Microsoft acquired LinkedIn 5 years ago...unbelievable that it is that long ago!
Since the 5th April, Hootsuite have reduced the number of scheduled posts permitted on free accounts down to just 5 and we don't use the other features to warrant the paid price tag. We already have an automated Twitter scheduler and I want to add LinkedIn to it so just need something to authenticate, read the timestamp of the latest post and be able to create a post containing media.
Before I write something to do this, are there any modules available or should I try out the modules above despite their age?
Hi. I need feedback on this... In order to run a Perl program, I must check for the availability of another program (i.e. it's in the PATH). So I've created a subroutine for this (which returns 0 for "not found" and 1 for "found"), and I'm not sure if this is the best option. Here's the code:
sub available {
my $program = shift;
for my $pathdir (split /:/, $ENV{PATH}) {
return 1 if -x "$pathdir/$program";
}
return 0;
}
I hope you are all well. I am very novice Perl user, in fact I have only used sendEmail.exe by Brandon Zehm, which is a packed Windows executable based on Perl.
I have used Par::Packer (installed via cpan)to pack this updated Perl script into an executable, but no matter what I do, the executable keeps asking for Net::SSLeay and IO::Socket::SSL if Perl is not installed. (It works fine if Perl is installed or if I run the .pl script)
Below is the error message from sendEmail.
sendEmail.exe: ERROR => No TLS support! SendEmail can't load required libraries. (try installing Net::SSLeay and IO::Socket::SSL)
Things that I tried:
I have used pp with -M Net::SSLeay -M IO::Socket::SSL.
I have installed Strawberry Perl 32 bit and 64 bit. (v5.32.1.1)
I have used Perl Portable instead. (v5.32.1.1)
I have used an older version of Perl. (v5.26.3.1 32 bit Portable)
I have made sure the needed packages are installed and up to date.
I have tried to use Dependency Walker, but it seems to hang on my workstation (Windows 10 20H2 x64).
pp -x sendEmail.pl fails with this error message: SYSTEM ERROR in executing sendEmail.pl : 256 at C:/Perl/perl/site/lib/Module/ScanDeps.pm line 1503.
I do not understand why the generated executable is not finding or loading the required libraries.
Hi all. I have some tweets in Russla/Ukrainian/Bulgarian in a database on another machine. I have extracted ones I want to translate using google cloud translate, which is installed on another machine. I loaded them into an array of hashes, dumped them into a Storable file, and moved that to the other machine. I am now trying to load these into a MySQL database and an getting an error I can't figure out on the other machine. Here is the code (I set the die on $sth->execute to print the error and offending values):
use DBI;
use Storable qw(retrieve);
$| = 1;
my $j = retrieve("/mnt/c/temp/to-translate.sto");
my $dbh = connectdb('****','****','****','****','****');
foreach my $i (0..@$j-1) {
my $r;
$r->{tid} = $j->[$i]->{id};
$r->{orig} = $j->[$i]->{text};
#print "$r->{tid}\t$r->{orig}\n";
insertsql($dbh,'translate',$r);
}
sub connectdb { # connects to mysql or PgPP
my ($database,$user,$password,$driver,$server) = @_;
unless ($driver) {
$driver = "mysql";
}
unless ($server) {
$server = "hdshcresearch.asu.edu";
}
my $url = "DBI:$driver:$database:$server";
unless ($user) {
$user = "root";
$password = "research.HDSHC.mysql";
}
my $dbh = DBI->connect( $url, $user, $password ) or die "connectdb
+ can't connect to mysql: $!\n";
return $dbh;
}
sub insertsql {
my ($dbh,$table,$data,$ignore) = @_;
my @qm;
my @keys;
my @values;
my $i = -1;
foreach my $k (keys %$data) {
if (defined($data->{$k})) {
$i++;
$keys[$i] = $k;
$values[$i] = $data->{$k};
$qm[$i] = '?';
}
}
my $keylist = join(",",@keys);
my $qlist = join(",",@qm);
my $sqlstatement = "insert into $table ($keylist) values ($qlist)"
+;
if ($ignore) {
my $sqlstatement = "insert ignore into $table ($keylist) value
+s ($qlist)";
}
my $sth = $dbh->prepare($sqlstatement);
#$sth->execute(@values) || die "putsql could not execute MySQL sta
+tement: $sqlstatement $sth->errstr";
$sth->execute(@values) || die $sth->errstr. " ".join(" ",@values);
$sth->finish();
return $dbh->{'mysql_insertid'};
}
The encoding on the original db is utf8, and so are the table and columns on the target db. When it gets to one particular item it croaks:
Incorrect string value: '\xF0\x9F\x98\x84 "...' for column 'orig' at row 1 530248086468063232 Нужно срочно брать на роботу. Цель для него есть 😄 "Рассекречена личность морпеха застрелившего бин Ладена" at /home/steve/load-tweets.pl line 61.
Is the problem the emoticon? If so, how can I filter these out?
I am trying to add the filename to the end of each line in my files. I tried a few solutions but none seem to work and this is what I have.
I am not sure what I am missing or what is wrong.
#!/usr/bin/perl -w
use strict;
use warnings;
use Text::ParseWords;
opendir IN, 'Master';
my @in = grep { /\.txt$/ } readdir IN; # read all file names form dir
+except names started with dot
closedir IN;
for my $in (@in) {
open IN, '<', "Master/$in" || next;
open OUT, '>', "Update/$in" || die "can't open file Update/$in";
my @file = @in
while (my $file = <IN>) {
my $line = $_;
$updateline = $line . $file;
print OUT "$updateline";
}
close OUT;
close IN;
}
I'm new to PerlMonks and fairly new to PERL. Long story short, I'm trying to clean up and speed up code and am struggling with Find::File::Rule. I read other posts here and on StackOverflow that helped, but I can't get to that last little bit.
The story: I want to build a list of directories or files, but exclude some based on patterns.
It started with:
find ( {
no_chdir => 0,
wanted => sub {
return unless -d; # skip files; we're tagging folders
return if $File::Find::name =~ /\/\./;
return if $File::Find::name =~ /\./;
return if $File::Find::name =~ /\.store$/i;
return if $File::Find::name =~ /\/LOG(\/|$)/i;
return if $File::Find::name =~ /\.go\./i;
return if $File::Find::name =~ /\/cache(\/|$)/i;
return if $File::Find::name =~ /\.store$/i;
return if $File::Find::name =~ /\/AVCHD(\/|$)/i;
push ( @fileList, $File::Find::name ); # get name with path
}},
$tagLocation );
Much better, and I get the benefit from qr//. Life is good. Now I want to make it more readable and perhaps faster with "File::Find::Rule" and ->name()->prune. So:
This version doesn't return anything. I'll spare you the variants of putting qr inside @dirExclusions, using q() instead of qw(),
taking off the '\/' (on the assumption File::Find::Rule wasn't matching on the full path), and such.
Next attempt: use a string, as in @fileList3 above.
