Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Request for a contact list Mod

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
texanman Posted - 19 August 2008 : 09:21:09
I am looking for a mod that creates a list with fields such as:
Name, Address, Phone Number, Profession, etc and be exportable to excel and normal user have the ability to add and edit entries.
Any help will be appreciated.
Thanks<
15   L A T E S T    R E P L I E S    (Newest First)
Carefree Posted - 14 February 2009 : 04:23:19
99% probability, yes. About the only thing you can do to guarantee write access (without setting up a new folder and getting the host to grant write access to that folder) is to change the path to match that of your forum DB - but you cannot use "strConnString" as a variable, it'll have to be hard-coded.<
texanman Posted - 13 February 2009 : 19:33:08
Still gives me the same error. Would this be write access issue?<
Carefree Posted - 13 February 2009 : 18:55:34
quote:
Originally posted by texanman

Thanks again Carefree
Everything seems to be working fine except exporting to txt file. I get this error:

Scripting.FileSystemObject error '80040401'
Permission Denied
/Details.asp, line 911



Sorry, I never saw the error message post. Look on line 909, a text file is created (which I placed on the root directory of c:). If your site is hosted elsewhere, that file address will have to change. Simply strip off the c:\ to leave it as MbrList.txt and it should function fine.<
AnonJr Posted - 13 February 2009 : 17:30:50
Depending on what is on line 911, its likely to be a server permission issue.<
texanman Posted - 13 February 2009 : 14:31:28
I am feeling shy now to push for this. <
texanman Posted - 16 December 2008 : 13:58:59
Thanks again Carefree
Everything seems to be working fine except exporting to txt file. I get this error:

Scripting.FileSystemObject error '80040401'
Permission Denied
/Details.asp, line 911
<
texanman Posted - 15 December 2008 : 10:54:51
Carefree:
Thank you so much. Very much appreciated. I will look at tonight.<
Carefree Posted - 13 December 2008 : 22:54:02
Email sent.

The first time you run it, it'll automatically create the required table and fields.

Users can only see/edit their own information, administrators can see/edit all. For an administrator to access an existing record, simply input the user's ID (from the displayed list) and hit submit.

Exporting to a comma-separated text file for importing into Excel is a one-button click. The file name and path for the text file are set in line 909.
<
Classicmotorcycling Posted - 13 December 2008 : 22:37:51
Want to send it to me please, so I can look at it? I may have a need for it.
quote:
Originally posted by Carefree

Done, email sent. Scratch one more off my list of forgotten things.
<
Carefree Posted - 13 December 2008 : 19:56:37
Done, email sent. Scratch one more off my list of forgotten things.<
Carefree Posted - 13 December 2008 : 15:23:41
OK - it's 99% done. I have one final error to eliminate (only because I cannot see anything wrong) and then Tex can have it.

Here's the bit of code causing my problem
	strSQL = strSQL & " TEXANMAN SET " & _
		"ID=" & intID
	if trim(strPW) <> "" then
		strSQL = strSQL & ", PW='" & strPW & "'"
	end if
	if trim(strLName) <> "" then
		strSQL = strSQL & ", NAME_L='" & strLName & "'"
	end if
	if trim(strFName) <> "" then
		strSQL = strSQL & ", NAME_F='" & strFName & "'"
	end if
	if trim(strStreet) <> "" then
		strSQL = strSQL & ", STREET='" & strStreet & "'"
	end if
	if trim(strCity) <> "" then
		strSQL = strSQL & ", CITY='" & strCity & "'"
	end if
	if trim(strState) <> "" then
		strSQL = strSQL & ", STATE='" & strState & "'"
	end if
	if trim(strZip) <> "" then
		strSQL = strSQL & ", ZIP='" & strZip & "'"
	end if
	if trim(strEMail) <> "" then
		strSQL = strSQL & ", EMAIL='" & strEMail & "'"
	end if
	if trim(strPhone1) <> "" then
		strSQL = strSQL & ", PHONE_1='" & strPhone1 & "'"
	end if
	if trim(strPhone2) <> "" then
		strSQL = strSQL & ", PHONE_2='" & strPhone2 & "'"
	end if
	if trim(strProfession) <> "" then
		strSQL = strSQL & ", PROFESSION='" & strProfession & "'"
	end if
	if trim(strJob) <> "" then
		strSQL = strSQL & ", JOB='" & strJob & "'"
	end if
	if trim(strTitle) <> "" then
		strSQL = strSQL & ", TITLE='" & strTitle & "'"
	end if
	if trim(strPositions) <> "" then
		strSQL = strSQL & ", POSITIONS='" & strPositions & "'"
	end if
	if trim(strTBD1) <> "" then
		strSQL = strSQL & ", TBD_1='" & strTBD1 & "'"
	end if
	if trim(strTBD2) <> "" then
		strSQL = strSQL & ", TBD_2='" & strTBD2 & "'"
	end if
and here's a sample response output
quote:
INSERT INTO TEXANMAN SET ID=1, NAME_L='Last', NAME_F='First', EMAIL='email@net.com'


The first four fields are all that are required, but I cut the PW (64 char) out of the output as uninformative. Without the response output, I get a "syntax error in insert into statement".

Never mind. I figured it out.<
Classicmotorcycling Posted - 12 December 2008 : 22:40:16
Thanks carefree. Been a bit under the pump and I forgot about it after that, and again I am busy so I can go on leave from work after 4 years.<
Carefree Posted - 12 December 2008 : 20:25:44
I'll go ahead and write this for you, I'd forgotten about it. Sorry.<
texanman Posted - 12 December 2008 : 11:30:08
David,
Still need this if you have some free time.
Regards<
texanman Posted - 23 August 2008 : 13:31:09
Thank you so much carefree and David. I really appreciate this. The fields are: Name, address, e-mail, phone1, phone2, ID, Profession, Job, title, party positions held, and may be a couple of more fields, as TBD1, TBD2.
Andy, for my prupose I am not worried about privacy issues.
Thank you all.<

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000 Version 3.4.07