Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Request for a contact list Mod		  New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

texanman
Junior Member

United States
410 Posts
Posted - 19 August 2008 :  09:21:09  Show Profile  Reply with Quote
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<

AnonJr
Moderator

United States
5768 Posts
Posted - 19 August 2008 :  10:05:34  Show Profile  Visit AnonJr's Homepage  Reply with Quote
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.<
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 19 August 2008 :  10:28:06  Show Profile  Reply with Quote
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 :-)<
Go to Top of Page

Carefree
Advanced Member

Philippines
4212 Posts
Posted - 19 August 2008 :  10:33:28  Show Profile  Reply with Quote
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.<
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 19 August 2008 :  10:53:55  Show Profile  Reply with Quote
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.<
Go to Top of Page

Carefree
Advanced Member

Philippines
4212 Posts
Posted - 22 August 2008 :  15:27:30  Show Profile  Reply with Quote
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.<
Edited by - Carefree on 22 August 2008 15:28:06
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2085 Posts
Posted - 22 August 2008 :  18:06:09  Show Profile  Reply with Quote
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.
quote:
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.<
Cheers,

David Greening
Go to Top of Page

Andy Humm
Average Member

United Kingdom
908 Posts
Posted - 23 August 2008 :  03:09:28  Show Profile  Reply with Quote
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<
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 23 August 2008 :  13:31:09  Show Profile  Reply with Quote
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.<
Edited by - texanman on 22 September 2008 10:32:23
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 12 December 2008 :  11:30:08  Show Profile  Reply with Quote
David,
Still need this if you have some free time.
Regards<
Go to Top of Page

Carefree
Advanced Member

Philippines
4212 Posts
Posted - 12 December 2008 :  20:25:44  Show Profile  Reply with Quote
I'll go ahead and write this for you, I'd forgotten about it. Sorry.<
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2085 Posts
Posted - 12 December 2008 :  22:40:16  Show Profile  Reply with Quote
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.<
Cheers,

David Greening
Go to Top of Page

Carefree
Advanced Member

Philippines
4212 Posts
Posted - 13 December 2008 :  15:23:41  Show Profile  Reply with Quote
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.<
Edited by - Carefree on 13 December 2008 19:54:21
Go to Top of Page

Carefree
Advanced Member

Philippines
4212 Posts
Posted - 13 December 2008 :  19:56:37  Show Profile  Reply with Quote
Done, email sent. Scratch one more off my list of forgotten things.<
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2085 Posts
Posted - 13 December 2008 :  22:37:51  Show Profile  Reply with Quote
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.
<
Cheers,

David Greening
Go to Top of Page

Carefree
Advanced Member

Philippines
4212 Posts
Posted - 13 December 2008 :  22:54:02  Show Profile  Reply with Quote
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.
<
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07