Hello,
I think the best way is to use a CPS ZODB Directory (although it depends on
your requirements).
The steps to do are:
1. Create schema and layout.
2. Create directory and configure it to use the new schema and layout.
3. Create a python script that is able to read the file and detach each field
of a contact (say name, address or whatever).
4. There are two options for the output of the script created in step 3 may be:
4.1 Push entries to the portal using remote controller
4.2 Create xml file and use an import step for directory entries.
In my view, the easier way is 4.1 for which the steps are:
4.1.1. Add a new method to the class
Products.RemoteController.RemoteControllerTool.RemoteControllerTool
The method should look like this:
security.declareProtected(View, 'createDirectoryEntry')
def createDirectoryEntry(self, directory, entry):
""" Add a new entry to a directory
param directory: The id of the directory
param entry: The new entry (python dictionary)
"""
dirtool = getToolByName(self, 'portal_directories')
dir = dirtool[str(directory)]
try:
dir.createEntry(entry)
except:
pass
4.1.2. Modify your script to push entries through remote controller like this:
user = 'zopeadmin' ## Assumed that your credentials are zopeadmin/zopeadmin
directory = 'contacts' ## The identifier of the directory created in step 2.
constr = 'http://%s:[EMAIL
PROTECTED]/location:8080/iav_portalmir/portal_remote_controller' % \
(user, user, user, )
proxy = ServerProxy(constr)
### In this point you should have a list of entries (list of python dictionaries)
for entry in entries:
proxy.createDirectoryEntry(directory, entry)
4.1.3. Running the script from a console should work.
I hope to have give you some hints. Good luck.
Cheers.
P.D. The python code in this mail was written by my colleague Miguel Sánchez.
JoseLuis de la Rosa Triviño
Técnico de Desarrollo Software
FUNDACIÓN IAVANTE
[EMAIL PROTECTED]
Tel. 951 015 300
Este correo electrónico y, en su caso, cualquier fichero anexo, contiene
información confidencial exclusivamente dirigida a su(s) destinatario(s). Toda
copia o divulgación deberá ser autorizada por IAVANTE.
This e-mail and any attachments are confidential and exclusively directed to
its adressee(s). Any copy or distribution will have to be authorized by IAVANTE.
-----Mensaje original-----
De: Mário Valente [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 17 de enero de 2007 14:50
Para: Lennart Regebro
CC: [email protected]
Asunto: RE: [CPS-users] Adding contacts database
On 1/12/07, Mário Valente <[EMAIL PROTECTED]> wrote:
>> Right. Why should I need an aditional piece of software to manage?
>
>Well, if you want to store it in an SQL database, then you need an SQL
database to store it in.
>
Thats why I'm using Gadfly. Within Zope.
>> What happens with the next table of stuff? Should a programmer be
>> needed to do this kind of basic stuff?
>It is "basic" in the sense that it's simple to do, but at the same time is very non-basic, as it's >quite unusual. After five years in the CMS world this is the first case I've seen of somebody wanting >>to import an excel sheet of contacts.
>>
I wont even comment. In 5 years in the CMS world there's never
been a need to bulk load formatted data? Of any kind? Be it contacts
or address lists or people lists? You do it by hand every time? I was
expecting a more credible answer than this.
>> I'm trying to resist the RoR pull.. but with the Zope "complicate
>> as much as possible strategy"
>Well, if what you want is a HTML interface to a bunch of SQL tables, I don't think
you should resist >it. If you want a CMS, then you should resist it. CPS and RoR
don't compete with each other. They >are quite different technologies solving what is
essentially very different problems.
>
I want a CMS. I am resisting it. I just want a better way to
define a new content type (be it CPSSchema or Archetype) and
load previous data automatically, instead of inserting thousands
of records by hand just because "a CMS is not na HTML interface
to a bunch of SQL tables". I know its not, I dont want it to be; I
just need to migrate thousands of records into a CMS and cant seem
to find a simple (not even automatic) way to do it. I've even looked
at Zope's export/import XML formats but I'm not even going into that
mess....
-- MV
_______________________________________________
cps-users mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/cps-users
_______________________________________________
cps-users mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/cps-users
