Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By mainebob on
I have installed CCK and started playing with creating new content type and I am not sure that
this system fits....
I have an old offline database of past customers and prospects with Contact info and some info
of previous purchases, dates, locations etc. Most contacts do not have email addresses so I can't use the regular drupal user tables....
I thought that creating a database/table using CCK and then importing the data from my current CSV.txt
files would be easy.
Now, I'm having some doubts that this is the best method.
The ideal is to have all the customers/prospects in one database.
We can have an option to make them drupal users once we have their
email address with a simple "click to add" link.
The important things are to be able to export some subsets of this data
so that we can print labels, and customized letters, "Dear [John], you bought [bla bla] from us...." etc.
We'd like to have the ability to sort in many different ways to get lists to use for labels / letters / email broadcasts etc. As you can see, we have our OFFLINE people and our ONLINE people, our Customers
who have bought different categories of products and our Prospects....
Looking forward to hints, tips, tricks, and methods from anyone that has already done what appears to be a common business practice AND made it part of the Drupal World.
Looking forward to how to "bridge the gap" between our offline and online world so that
we can do BOTH really well!
Thank you!
-MaineBob
