Request for a contact list Mod

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/67632?pagenum=1
05 November 2025, 03:52

Topic

texanman
Request for a contact list Mod
19 August 2008, 09:21


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<

 

Replies ...

AnonJr
19 August 2008, 10:05


There used to be a phone directory MOD (or something along those lines) for 3.4.03 (or thereabouts). I think its still on www.snitzbitz.com - it can probably be updated for the latest version without too much trouble.<
texanman
19 August 2008, 10:28


Yes, i saw that before. It converts the member Table into phone directory. The trouble with the mod, it requires replacing my existing files, which are heavily changed already. I wanted this list mod to be stand alone rather using the members Table :-)<
Carefree
19 August 2008, 10:33


If you create it as a stand-alone mod which doesn't use the Member Table, one or the other will always be out-of-date. Members will edit one & think it's fixing both, that's virtually guaranteed.
However, if you want to live with always having to compare one against the other, it wouldn't be too difficult. It could be created to originally pull the data from the Member table & afterward allow each member to edit their own data only.
As far as being exportable to Excel, it need only create the data in columnar format that could be saved to a txt file or even copied from the screen.<
texanman
19 August 2008, 10:53


Thanks Carefree. May be I did not clarify what I am looking for. The list will be used for a specific purpose outside the forum. I want to gather information on certain kinds of people with similar interests. They could be members and they could be non-members. A member can list someone who is not a member with their permission of course. This really has nothing to do with the members Table. A column format is great. Yahoo groups have something similar under database, where you can create a list and specify the fields you want to include in the list.<
Carefree
22 August 2008, 15:27


If you have a copy of Excel 2003 (this option went away in 2007's release) available, you can create an interactive spreadsheet which can be exported to the web. Then, simply give the users the address and let them complete their own info. That approach will allow all members to see everyone's data, though - may not match your/their needs.
From within the board, can make a new table with all the fields that you want to include; let each user (not necessarily associated with the board) add their own information without having access to everyone else's. Do an if/then check on whether a name has been submitted already, if so, allow edit, if not, prompt to provide other info.

If you want something like the second option, I can write it up for you.<
Classicmotorcycling
22 August 2008, 18:06


If you let me know what fields you would like to see in the mod, I might be able to put something together for you over the next few weeks.
Originally posted by texanman
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
The only thing I would suggest is to only allow users to edit their own entry and the requirement of approval before being shown to the public.

The other thing is, the display of entries address and phone numbers could be an issue, unless it is for a "Business Directory" type listing, but I would not put private users in there as there could be privacy laws to look at.<
Andy Humm
23 August 2008, 03:09


David,
Quote: "The other thing is, the display of entries address and phone numbers could be an issue, unless it is for a "Business Directory" type listing, but I would not put private users in there as there could be privacy laws to look at."
Knowing this could be an issue, some people are more than happy to display these type of contact detail, if you are kindly considering developing the code, as a suggestion, could you put an option box or checkbox for the user to allow certain details to be openly displayed, like the email pulldown we currently have on snitz profile.. Thank you andy<
texanman
23 August 2008, 13:31


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.<
texanman
12 December 2008, 11:30


David,
Still need this if you have some free time. Regards<
Carefree
12 December 2008, 20:25


I'll go ahead and write this for you, I'd forgotten about it. Sorry.<
Classicmotorcycling
12 December 2008, 22:40


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
13 December 2008, 15:23


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
Code:
	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
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.<
Carefree
13 December 2008, 19:56


Done, email sent. Scratch one more off my list of forgotten things.<
Classicmotorcycling
13 December 2008, 22:37


Want to send it to me please, so I can look at it? I may have a need for it. bigsmile
Originally posted by Carefree
Done, email sent. Scratch one more off my list of forgotten things.
<
Carefree
13 December 2008, 22:54


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. <
texanman
15 December 2008, 10:54


Carefree:
Thank you so much. Very much appreciated. I will look at tonight.<
texanman
16 December 2008, 13:58


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
13 February 2009, 14:31


I am feeling shy now to push for this. tonguewink<
AnonJr
13 February 2009, 17:30


Depending on what is on line 911, its likely to be a server permission issue.<
Carefree
13 February 2009, 18:55


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.<
texanman
13 February 2009, 19:33


Still gives me the same error. Would this be write access issue?<
Carefree
14 February 2009, 04:23


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.<
© 2000-2021 Snitz™ Communications