Gossamer Forum
Home : Products : DBMan : Customization :

Excel Export Mod Probs...

Quote Reply
Excel Export Mod Probs...
I'm getting....
Code:
Error Message : fatal error: Unable to open CSV file location (>/csv/admin.95695234499131.csv). at ./time_html_new.pl line 1152.
I made sure I created the csv dir outside of cgi-bin and it's 755.
Here's the db.cgi value:-
$db_csv_path = "csv/";
It's straight of my root.
What gives?? (please)
Rob
Quote Reply
Re: Excel Export Mod Probs... In reply to
I haven't used this mod, but the instructions say to use:

$db_csv_path = "/mywebdir/cgi-bin/dbman/csv/";

I'm assuming that it can not locate the file the way you it setup using:

$db_csv_path = "csv/";

The other example using the full url without the trailing /:

$db_csv_url = "http://www.mydomain.com/cgi-bin/dbman/csv";
Try using the full url and see if that helps.
To use a relative path you try this:

$db_csv_url = "../csv";

Hope this helps Smile
Quote Reply
Re: Excel Export Mod Probs... In reply to
Here is the offending line:-
Code:
# Open temporary csv file
my ($csvfilename) = "$db_uid" . ".csv";
my ($csvfileloc) = ">$db_csv_path$csvfilename";
open(CSVFILE, $csvfileloc) | | die "Unable to open CSV file location ($csvfileloc).";

&csv_header();
I've moved the dir around but to no avail.
Quote Reply
Re: Excel Export Mod Probs... In reply to
I have used this mod and had the same problem.

Instead of using '/csv'

Type in your full path (i.e.)

/home/deprise/deprise-www/csv/

But after that. I had another problem. The csv file it makes is empty! (except for the header info)

Any suggestions?
Quote Reply
Re: Excel Export Mod Probs... In reply to
The only thing I can think of is to talk to the developer of the mod. He knows what he was thinking of when he wrote it and might be able to come up with the solution. He also should know about the problems you're having so he can change the mod.


------------------
JPD






Quote Reply
Re: Excel Export Mod Probs... In reply to
I would love to contact the author but I don't have an e-mail address.

The source says : Written by D Mitchinson

Help!
Quote Reply
Re: Excel Export Mod Probs... In reply to
He really should have his email address in the mod.

Do a search in the DBMan discussion forum for "mitch." That's his username here. You'll be able to click the email link on his posts to write to him.


------------------
JPD






Quote Reply
Re: Excel Export Mod Probs... In reply to
Thanks for the suggestions peeps but I have tried all of the various path variants to no avail. Hey-ho Frown
Quote Reply
Re: Excel Export Mod Probs... In reply to
Mitch's email is mitchind@cuug.ab.ca .


------------------
JPD






Quote Reply
Re: Excel Export Mod Probs... In reply to
Thanks JPD. I'll post any replies/updates.
Rob
Quote Reply
Re: Excel Export Mod Probs... In reply to
I emailed Mitch but no reply as yet. Anyone else faired any better?