|
Position
|
This is a random number between 1 and 1000 that will change each time you open the Memlist.xlsx file. This is also the default order for the online directory and any time you update the directory, another member will be first so that no member is gauranteed first spot., this can be changed if desired
|
|
ID
|
just an ID that increases by 1 any time a member is added
|
|
Category
|
1st category for the member
|
|
Category2
|
Additional Category
|
|
Category3
|
Additional Category
|
|
Category4
|
Additional Category
|
|
Category5
|
Additional Category
|
|
Organization
|
Member Name
|
|
MailAddr
|
Member Address
|
|
MailCity
|
Member City
|
|
MailState
|
Member State
|
|
MailZip
|
Member Zip
|
|
OrgFax
|
Member Fax
|
|
OrgPhone
|
Member Phone
|
|
OrgEmail
|
Member Email
|
|
WebSite
|
Member website
|
|
BusinessDescrip
|
Member Business Description, we suggest limiting to 50 words but you can have many more but this will increase the size of the members listing
|
|
PriContact
|
Member's Primary Contact
|
|
ContactEmailAddr
|
Primary Contact's email address
|
|
Picture
|
This is the actual picture file name (i.e. 123.jpg). A Picture the member would like in their description cell, this file if first time adding, needs to be sent with this file to rono@pstcorp.com so it can be formatted and uploaded
|
|
Contact2
|
Additional Contact, you can put a comma after name and add their job title
|
|
Contact3
|
Additional Contact, you can put a comma after name and add their job title
|
|
Contact4
|
Additional Contact, you can put a comma after name and add their job title
|
|
Contact5
|
Additional Contact, you can put a comma after name and add their job title
|
|
Map
|
True or False (if True and link for Map/Directions appears and uses the posted address
|
|
MapURL
|
This is a url you can enter that overrides the default address in the event it is not exact or is a PO Box
|
|
MemberSince
|
Enter just the year they became a member
|
|
webpicurl
|
this is a url that when a visitor clicks the picture, if there is one, it will go to that url
|
|
HomeOrg
|
this is the name of your organization
|
|
FaceBookURL
|
url that will take them to the facebook page, the Facebook Icon will appear
|
|
TwitterURL
|
url that will take them to the twitter page, the Facebook Icon will appear
|
|
LinkedInURL
|
url that will take them to the LinkedIn page, the Facebook Icon will appear
|
|
BlogURL
|
url that will take them to the facebook page, the Facebook Icon will appear
|
|
PicAlign
|
a "0" is put on left of description cell, a "1" will put on the right side
|
|
TextWrap
|
a "0" is do not wrap and business description is below the picture if present, a "1" will wrap the text around the picture
|
|
YouTubeURL
|
this is a link to youtube video your member may have that can be advertising
|
|
EmbeddedCode
|
when viewing this video you can get the actual embedded code and copy and paste here for the YouTube url
|