Update and add customers

[kodeoneuankenobi]

Hi to everyone!

I've a question. Is there any way to update through a CSV a bunch of customers and furthermore add new customers? I was searching on the internet but didn't see nothing relevant.

The OTRS version is 3.2.9

Thanks in advance!!

[crythias]

viewtopic.php?f=62&t=12410

[kodeoneuankenobi]

Thanks, but on that topic I can't see anything about updating the current customers that exists on the database... The question is that I have something like 3000 customers and I have to update some of them, also, I have to introduce a bunch of new customers...

If you can help me I would be very grateful to you

[crythias]

The best bet is don't do this. Link to the source data. Unless OTRS is an endpoint (but it isn't. you're constantly updating the source, or else you wouldn't have this question.)

[kodeoneuankenobi]

What are you saying, is that I can add new customers but it's better that I don't update the existents one? :/

[crythias]

I am saying that it's better to link to and read/query the source data directly than to do the extract-update-add that you're doing now, unless you're only going to do this one time, or it's prohibitive to connect to the source data directly.

[kodeoneuankenobi]

I guess that it's prohibitive to connect to the source data directly because it's a CSV, not something like an AD. The OTRS is running on a CentOs 5. (Sorry if I misunderstand something or write something wrong, I'm from Spain).

I'm going to try to explain better my situation:

-We've this OTRS running on a Centos 5.
-Currently we've a lot of customers on the mysql of the OTRS
-One of our workers said that we've to update a lot of the customers that already exist and, furthermore, add a bunch of new customers

Is there any way that I can do that without crashing the OTRS?

Thanks a lot in advance!

[crythias]

-Currently we've a lot of customers on the mysql of the OTRS

OK.

One of our workers said that we've to update a lot of the customers that already exist and, furthermore, add a bunch of new customers

where is the source of this data? (who populated the .csv? With what data source/database? Was it typed in a big csv by a human or did you extract the data from a database?)
If you could grab the information from the source to make a csv, it's theoretically possible that OTRS could query the same source of information directly, without using csv as sneakernet.

[kodeoneuankenobi]

where is the source of this data? (who populated the .csv? With what data source/database? Was it typed in a big csv by a human or did you extract the data from a database?)
If you could grab the information from the source to make a csv, it's theoretically possible that OTRS could query the same source of information directly, without using csv as sneakernet.

The data comes from a MySQL. The worker connects through a website and downloads an .CSV. If i don't misunderstood you, you are saying that there's a way to synchronize the MySQL with the "customer_user" table of the OTRS MySQL, isn't it?

Where I can find how to do that? And, if the "customer_user" table was synchronized with the table containing the info of the other MySQL, if we add more customers to the MySQL the data will synchronize automatically and add the new info to the "customer_user" table?

Thanks for your patience!

[jojo]

http://otrs.github.io/doc/manual/admin/ ... kends.html

[kodeoneuankenobi]

But this works with an external MySQL outside the centOs that hosts the OTRS?

[crythias]

It is not a synchronization. It is a direct query of the other MySQL table at the other mysql database location. You can have multiple backends.

[kodeoneuankenobi]

Sorry for responding 4 days later. I will try to use that solution and in a few days I'll be back to share what I've done and if it has worked.