I want to create accounts directly to my egroupware DB

[Matthew]

Hello,

I need to create many account. But I have their information which has name,ID,PW,etc… in other oracle DB.
If I create accounts at egroupware application, I think this is stupid and annoy me.

I have only one idea. The plan is that I will make a java file. The file will perform select certain information from oracle DB.
And these information which are chosen will insert to egroupware.

Any ideas? more than my plan?
If you have a good idea, Could you explain to me easily?
Because I am beginner and can`t speak English well.

And I have one more question.
Egroupware insert encrypted user password. So how can I insert already given password properly?

Thank you and have a good day!

[ngegw]

Hello,

I need to create many account. But I have their information which has
name,ID,PW,etc… in other oracle DB.
If I create accounts at egroupware application, I think this is stupid and
annoy me.

Use the import/export app.

1. Dump your info from oracle into a CSV.
2. Create the definition (Admin -> importexport -> Define
   imports>exports). User CSV import is under Admin
   app.
3. Use your definition to import into egroupware.

Nathan

---

Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[WLD]

I have to hold my hand up and say I’m a bit naughty for having updated a lot of egw+perp tables directly from external scripts when developing a migration path from previous legacy data in to an egw+perp setup. It was a pretty big learning curve to figure out so many table definitions and required vast amounts of SQL operation analysis and testing in a VM environment, but it can be done if you’re methodical and have an eye for detail.

Whilst I think defining import/exports are great, if you need something more technical achieving (importing several legacy systems data is one such valid requirement) then it pays to look at being able to do this directly, especially if it’s a one-off. I think the requirements of importing many accounts from an existing Oracle DB could be achieved in an easy PHP script not 20 lines long and negate the sorts of nastiness you get when dealing with CSV files. If passwords contain extended symbols etc. then you could be heading in to quite the nightmare.

Plus it’d be pretty easy to create default addressbook entries and confic options for all the accounts in a script too.

Paul

Hello,
I need to create many account. But I have their information which has
name,ID,PW,etc… in other oracle DB.
If I create accounts at egroupware application, I think this is stupid and
annoy me.
Use the import/export app.

1. Dump your info from oracle into a CSV.
2. Create the definition (Admin -> importexport -> Define
   imports>exports). User CSV import is under Admin
   app.
3. Use your definition to import into egroupware.
   Nathan

---

Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[Leithoff_Klaus]

sure it can be done.
Nathan was suggesting an “easy” way for people not having access to the database directly.
When you know what you are doing, you can achieve almost anything by doing it directly within the database.
Theare are always reasons for such actions - no doubt.
Have fun doing it.
Best regards
Klaus

[Matthew]

Thank you for help me everybody.
Nathans idea is good. But I cant import cvs file to user account just only for address book.
This is my screen shot.

I had solved creating user account directly egw DB. But have one more problem.
I cant insert encrypted password. If I create password 1234 at egroupware web-page, this accounts password
will insert encrypted password(e.g.ddderdfdf888aef92) to egw DB.
So my problem is that if I insert password 1234 to egw DB directly, I cant access the password(1234) to egroupware web-page. Because the password(1234) which insert DB directly encrypted for egroupware web-page view. Actually I dont want to encrypt for creating password. So I select do not use LDAP. I did not fill out LDAP host name, etc…
And delete mcrypt comment in header.inc.php. But didn`t any change.

Can I insert encrypted password to egw DB directly using some algorithm in Java?
Or can I insert same password between egw DB and egw web-page?

Thank you for reading.

[ngegw]

…
Nathans idea is good. But I cant import cvs file to user account just only
for address book.

Sorry about that, that feature is only available in trunk, not 1.8.

…
Can I insert encrypted password to egw DB directly using some algorithm in
Java?
Or can I insert same password between egw DB and egw web-page?

It’s not quite clear, your passwords are plain text in your Oracle DB?
Egroupware encrypts its passwords. You can choose which method of
encryption egw uses for passwords in setup.
When you go to insert the password, encrypt it using the associated function.

If they’re encrypted in your Oracle DB, match the egw encryption to
your Oracle encryption and copy literally.

Nathan

---

Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers