Import client in database

[Artis]

Hello  ,

I'm working on integration of my current system with blesta and I have issue with importing clients to blesta. Can you tell me when I manually import user (only user not package or any additional informations) what database tables I need to fill.

For now I find this tables:
clients
users

 

But I think that I'm missing few tables

[WebhostingNZ.com]

Are you importing directly into the database via mysql?  It would be much better I think to use the API and the following:

http://source-docs.blesta.com/class-Clients.html#_create

I think that is the one you want off the top of my head it was a long time ago I done it now.  If you get stuck shout out it's late here but I'll look more into it in the morning.

[Artis]

I have two applications on same server and I have access to database, so I want to use database connection and add new user (that is best way as I can see).

By my opinion this approach is better because I only have users and I want to add it to blesta that blesta can handle it later.

 

If there is better suggestion I'm open for discussion.

[Blesta Addons]

i can suggest a check a dev to code you a plugin that will import the user table to blesta .

 

[Artis]

  On 12/10/2016 at 10:56 PM, Blesta Addons said:

i can suggest a check a dev to code you a plugin that will import the user table to blesta .

 

Expand  

Can you explain advantage between plugin and direct inserting data in database ?

I can see few problems with plugin, I'll need to run cron every minute to run plugin. Without running plugin I can directly import user (first name, email address, password) and user will be able to login in Blesta.

  On 12/10/2016 at 10:08 AM, Artis said:

Hello  ,

I'm working on integration of my current system with blesta and I have issue with importing clients to blesta. Can you tell me when I manually import user (only user not package or any additional informations) what database tables I need to fill.

For now I find this tables:
clients
users

 

But I think that I'm missing few tables

Expand  

Answer to my questions, this 3 tables I need to edit:

Clients
Contacts
Users

[Blesta Addons]

the plugin will do the task for you 1 time . no cron is needed .

the plugin will use the blesta client model to add all the necessary fields and table out of the box . something like the importer plugin .