By dproger on
Hi
I want to import users from my application (MS Access) to drupal site. In drupal I have a Content Profile module. Can somebody show me queries or any other information of how can I import users from MS Access to Drupal. Which tables I have to affect (only `users` and ???) Problem is that import will happens from MS Access programm! (not from drupal site).
Regards
Comments
First of all try to export
First of all try to export your users data on a single table under mysql.
Then try to fill manually couple of fake users. Queries depend on how many content profile you did, so you have to study the db.
Anyway I think you are going to lose the passwords... but I'm not sure of that. I did it once transfering from Joomla to Drupal and unfortunately I had to ask users to confirm the password.
Waiting for more infos.
Patrizio
Elicos Drupal Service Provider, based in Macerata (Italy)
Look like password stored as
Look like password stored as md5-hash in drupal. So it should not be a problem.
Question is: how can I insert information into Content Profile? Which entries I have to create, in which tables? One is clear, that information is stored in table `content_type_profile`. But where I have to create a 'vid' and 'nid' values?
At the moment I have no
At the moment I have no websites with that module! I'm going to install content profile tonight so that I can help u! Sorry...
Patrizio
Elicos Drupal Service Provider, based in Macerata (Italy)
Hi, Content profile uses a
Hi,
Content profile uses a node as your profile, you need to import entries in the node and its related tables.
You need to first create a node of content profile and then where all entries are going. If you have any content taxonomy or taxonomies you need to these into consideration.
Hope this helps.
Regards
Sagar
Acquia certified Developer, Back end and Front specialist
Need help? Please use my contact form
Looks like needed tables are:
Looks like needed tables are: users, node, content_type_profile.
I think also node_revisions
I think also node_revisions and be carfull to assign in every table the right UID.
Check also if it has been created a contet_field_something, it is a table for each cck field you created.
I think you will need a php script to do that.
Patrizio
Elicos Drupal Service Provider, based in Macerata (Italy)
You can achieve this through
You can achieve this through node import module also...and manually through phpmyadmin.. i would recommend if you want it fast use node import and user import module.
Acquia certified Developer, Back end and Front specialist
Need help? Please use my contact form