[CPS-users] Adding contacts database

[Mário Valente]

  Problem: adding a contact database to CPS. The data
 is in na Excel/CSV file.

  Solutions:

  1) Create a new type using CPSTypeMaker. Worked great.
     Couldnt find where items were stored and as such no
     way to do a bulk load

  2) Create a Gadfly table. No easy way to create insert
     and display screens/forms. Couldnt find an easy way
     to publish ZSQL queries.

  3) Create a new SQL based CPSDirectory, interfacing to
     the previous Gadfly table. Works fine for search. It
     doesnt work for insert. No way to bulk upload

  4) Create a portal_schema, portal_layout, portal_type
     and setup workspace filters and workflow. Worked fine,
     similar to 1). Was able to add items through the CPS
     interface and to search and display. No way to bulk
     upload.

  Any hints? Whats the best way to bring in a table (SQL
 type of table, even if spreadsheet/csv stored) into CPS,
 with CRUD interface (preferably the CPS-based workspaces)
 *and* do a bulk upload?

   -- MV