[Zope-PTK] CMF Advise in migrating existing PHP - MySQL site to Zope CMF and MySQL

[Norman Khine]

This is a multi-part message in MIME format.

------=_NextPart_000_0010_01C0B090.CB3D5F30
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello ALL,
Having build my site using PHP and MySQL, I feel that what is needed would
MOST probably suffice with CMF. The site can be found at
www.buildersmerchants.co.uk/alpha/

It is not much to look at as there is no content, but I think the
functionality is there ie registration of user, able to browse news items
and link to manufacturers' pages

If you use username: adv1 password: adv1, you would be loged in. And be able
to navigate arround. This is the "front-end" where the users can see their
entries etc etc, to go to the back-office where a particular user can access
their data and update, modify etc is at
www.buildersmerchants.co.uk/alpha/adadmin/, again you can use adv1 for
username and password.

Once there the user is able to add company datails, products, logo's and so
on.

This application is written in PHP and MySQL, but I feel it will be better
suited to CMF, this is why I am currently building a copy of the site using
Zope and CMF, but being a novice in zope and python, I would like your help
in transferring this site to Zope/CMF.

The idea of the portal would be for Manufacturers to be able to add their
company details and products the provide, while the Merchants would be able
to view them and make enquiries and so on for a particular product.

My questions would be:

1.	When the user registers, using the current registration form, how
can I add the additional PROFILE data required within the CMF. Will it be
better to include this after the user has loged in? One thing though is that
what I am trying to achieve is to be able for the user to specify the type
of user they are, this will determine the type of account they end up being
ie Merchant, Manufacturer

If I recreate the user registration form in the PREFERENCES link, so that if
the user wishes to be listed they would be able to select yes and be able to
enter the PROFILE data about themselves. 

How can I put the user details into the db?

Would I need to use a different login/authentication procedure?

Do you think, speaking from previous experience of course, that this is the
correct way to proceed?

Or should I leave authentication entirely to Zope/CMF?

2.	In the adamin module the manufacturer is able to update their
company profile and ADD products with further breakdowns for each particular
product ie product pic, description, the difficulty here is being able to
link Product Group and Product Type that this particular "object" belongs
to, from the CMF?

An E-R schema of the database can be found at
http://www.buildersmerchants.co.uk:8080/BMPub/Dezign/ 

The way I am thinkg of going through this is to create a "GLOBAL"  portal
where ALL users login, then depending on the BuisnessFunction to direct them
to a sub-portal, then within this sub-portal the user is able to do whatever
they need to do, but is then reflected back into the GLOBAL portal?!?!

OR should it be the other way around, where I would create an individual
portal for each type of user, and then "pull" all their bits and pieces into
a "global" sub-portal - can this be done?

Portal A and Portal B to "talk" to Portal C?


Thanks for being so patient and reading thus far, and thanks to Zope for
providing an os that truly is pure objects ;^)

Norman



------=_NextPart_000_0010_01C0B090.CB3D5F30
Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="winmail.dat"

eJ8+Ih0QAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANEHAwATABAAFgAAAAEAFQEB
A5AGAIAMAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
AAAASAAAAENNRiBBZHZpc2UgaW4gbWlncmF0aW5nIGV4aXN0aW5nIFBIUCAtIE15U1FMIHNpdGUg
dG8gWm9wZSBDTUYgYW5kIE15U1FMAAIBcQABAAAAFgAAAAHAsJDDl05wdNccTBHVmg4AYJcWaGAA
AAIBHQwBAAAAGgAAAFNNVFA6S0hJTkVAQlRJTlRFUk5FVC5DT00AAAALAAEOAAAAAEAABg4ABHu5
kLDAAQIBCg4BAAAAGAAAAAAAAAA0hwT1KT3UEZkMAAAc1gQjwoAAAAsAHw4BAAAAAgEJEAEAAAAG
CAAAAggAAAQOAABMWkZ1eWJiMwMACgByY3BnMTI1FjIA+Atgbg4QMDMzTwH3AqQD4wIAY2gKwHOw
ZXQwIAcTAoB9CoGSdgiQd2sLgGQ0DGAOYwBQCwMLtSBIZWxjCQARYExMLAqiCoBIRmESIA8gIGJ1
AxBkECBteSAAkHRlIIZ1AJAVEVBIUCAAcCEVgE15U1EUUCBJbCBmCeADIHQQ8AVAd3MX8gQAIG4J
4AEAFYB3AwhgFXFNT1NUIHDVA2BiAaBsFbF1ASAN4AcWAAPwF+AgQ01GLlggVGgWABXTYwORYrsW
AAIQdRbRGAIdEC4VQzUEkHMHgHIQ4QIwcy6hBaAudWsvB0BwEPBWLxR0FHRJGGRvBUBtmxLAGxB0
FBAJAG9rHNL+YQQgF+AEkBYAICMcAAIh/QnwdBdQFUAFQBdwF+ALgI8hQCHBF4AcoGN0aQIgfwdA
FeAVsBiBIcUWAAlwZxkEAHRyGAAkYSBvZr8WEQSQF1AaERYAIOFiA2C+dxEgGKEnwBhwFfBtBCB/
FsIkoCOiFBADgRpwANB0ywhwHaEnGcBhZweQHzt9JpB5CGAmoiajJIAHgDrxFrBkdjEqUQQQGSAL
IP8spBdQK6IZJBxRCQAqgBWA+wuAG2BBFtEcUScWJIASIPZnGAAv0XIDYByhG2IYgVkk9CAiA1EC
MC0J8GT+IhghIeIj0iayBCAcEhEgfTNTaQXAIsEIgQQgETBj9zViF1Ag4WcUECDhI9IaALhjay0m
gBqUIdNhKlH/ACAN4BlACsEmshwDANAasDsEETSUZBgAN/AWwnVw/TohZRdQBGEGkBWwNXIYgV8c
7x3/HwEswCzAbQuAL/8m8TCwC4ArkxwSK+IswwIQrzikLGIWsy0WLh86TyQwfzNTM0k70yclLMAV
gAWgbd0KsG4VsDoiAxBzF1AZ0Z5kEsAeQBdQLuFvJyiUnnMUEAIgQgsxk2FwC1D3DeAmJBiBdwUQ
AkAJ8C8x/xZ+IxQXkxXgGtET8BxCHFD/SfEFwBpgFeEVgCDhGzE14f8xpRgwFbAXcCxwHAAIcAlw
vwIwGjEVQxUCN/AFoHAVsPcmgSPSFdlaUJBBJE3TIxK/HFBQJCBQEiAasT8xelIGv1CgF+ACIBdS
GSQkoGsWAP8roQXAG5Ae4EoyJgEAgBeQvzEQFQJOIxXTIOFR8i8bMt9HzCIBAQA38FDVcAkRB0D7
LkhAck0piidTL9hEwjSU/0UHETBFskE0RiVahANgEiDfAQAXUBgwAxAzVE09Fi5I/ycWEiIhsk8Q
FsIAwFXhCfD+cRVQNSNHJ0BjN/tGFUILvRcAIGSwB5AkUmI4Oh865jFCAAGRIFcbkFbBQ5b/JbQ8
0RdQFiQj0k81JaxAcf5tF1BU8AfgHBJO4V3kRLIHFeAkYxZwUk9GSUz+RToUCXBkshjyGvFWshuR
fRszV0xSTBFMmCDhC4Bj9wpAAQBOFGEBgHOyQ5YQ8PMEIC7mPyBC0HRzV4MIYL5nGxAk8xgGTuMm
AHlXc/dEoRDgCJB2IgNc+UByQ4f1IOFzUhBjO2Ij0iTAUhH/JoUhshWwCsA7AU4jTENe8f8EkD6h
M1R8pjlRHJEFQH1z/zLBOqFTBSWBYbYXUFwaKr3/F3AJcAUAWjBYImscbclWoyMbkXBgRUZFhxBO
Q/5FBfAo8hdQR2EX4waQQ3j/A/EbkFzWJKBr0V3zFbBiX/8RICcwJEArkGUFL8kiwXUV/3BrAaAI
YIBzKIAT4HnQHlDrCuMfdkhup3CPRDi0XvajC4A2ZWRiPx86Vxkz/xdwGLIg0j/jOhAGkFcxbSL7
LuE+sWEjIGrBOEEmJBnR7xqwRkAJcJObRBQQK6Ijc/+IAVIQZFAVAgNSGcF5wCRg+xYgNOB4UhAI
gULiJoGAMf8REU4CGAFOJmyjBbCEURgRvmF8QRQQl7MJgJObT00R/3dhlJMnMBTgL9GW3JcCCXDX
GjFYWZObMmpUSWrkPmH/PqE7IhlAM1QpekQKOrReDY8Z0RqQJzEWwkFERF+ovxrjJBAAICHRJ4Ga
EWQnsP8GMUByWjAgsWY/GGFgY61z/nAN4BdQAQAE9CRhTgKTUX+V0ThSJMEh1lMVJyUo81C9rVVH
MSFWkBbCsjZUfLLrnMg4GSIZ8GqMMTLwHFD/CQAPIFzSF1Cag3I1k5svgPAgRS1SFcAQ4ChwWkcv
OiIaACfRHB5oAkBwOowvLzxPPVg6ODC9YAAvQk1QdWIvRPxlejCgPsCQKxuCnlJ4lP8jghUgJoE2
MFd0MSF3kZ0XByJhhIQ38CJHTE9C/xQwMvBaxyHTFDEzpZZjr3N/A6ABAFIQEoAVAiZRI9JC7RVQ
cxiwBBBGJCUg0jtQz54DY7NEkhpRYi1a1MVF/3HHV9LJJ0N/x8MUEBgyecH/fVWU5qugIvQk9AOg
CXAO8D+MMRjxNtKS2ML0WsU/If/RsEIbuKGgRHMUI9IgYKsS/55SCsAckmDyIeJVRsJWSiL7O1Bg
sXVbEVrVrAd8qibx+xbRxWMikZAT8DLwB0DLc/00wWIV4F9VCJA5cZLUwsHeZwkAGgDZ8crpLboj
TiOvHFGroBiwk5tQWuRBswTVWuRCINIiWwFrMvAg4d3fZUOTm0gmAHBrq+RTFP9HYQqwJFBtIhbC
hIFQExfg/5sxKbDY9+NjWFVAY2CEUCP/JmF31SYAGUAk05GQIfG1hNEEIDteKR86Tm5BAHAV4i8K
EeEA7TAAAAsAAYAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwADgAggBgAAAAAAwAAAAAAA
AEYAAAAAEIUAAAAAAAALABSACCAGAAAAAADAAAAAAAAARgAAAACChQAAAQAAAAMAHIAIIAYAAAAA
AMAAAAAAAABGAAAAAFKFAAAnagEAHgAdgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAA
OS4wAAsAHoAIIAYAAAAAAMAAAAAAAABGAAAAAAaFAAAAAAAAAwAfgAggBgAAAAAAwAAAAAAAAEYA
AAAAAYUAAAAAAAALACiACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAKYAIIAYAAAAAAMAA
AAAAAABGAAAAABGFAAAAAAAAAwArgAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeADqACCAG
AAAAAADAAAAAAAAARgAAAAA2hQAAAQAAAAEAAAAAAAAAHgA7gAggBgAAAAAAwAAAAAAAAEYAAAAA
N4UAAAEAAAABAAAAAAAAAB4APIAIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAAC
AfgPAQAAABAAAAA0hwT1KT3UEZkMAAAc1gQjAgH6DwEAAAAQAAAANIcE9Sk91BGZDAAAHNYEIwIB
+w8BAAAAdwAAAAAAAAA4obsQBeUQGqG7CAArKlbCAABQU1RQUlguRExMAAAAAAAAAABOSVRB+b+4
AQCqADfZbgAAAEM6XFByb2dyYW0gRmlsZXNcQ29tbW9uIEZpbGVzXFN5c3RlbVxNYXBpXDEwMzNc
TlRcb3V0bG9vay5wc3QAAAMA/g8FAAAAAwANNP03AAACAX8AAQAAADQAAAA8TkVCQkpKQU1ERUlI
QklDRENOQk9DRUxPQ0dBQS5raGluZUBidGludGVybmV0LmNvbT4AAwAGEEj1ldQDAAcQQQoAAAMA
EBAAAAAAAwAREAAAAAAeAAgQAQAAAGUAAABIRUxMT0FMTCxIQVZJTkdCVUlMRE1ZU0lURVVTSU5H
UEhQQU5ETVlTUUwsSUZFRUxUSEFUV0hBVElTTkVFREVEV09VTERNT1NUUFJPQkFCTFlTVUZGSUNF
V0lUSENNRlRIRVNJAAAAADqP

------=_NextPart_000_0010_01C0B090.CB3D5F30--