Our customers use more than 500 applications, and we would like to integrate these applications with ours. What is the best way to do this? These applications are time recording applications and are common to most of them, so that they can export to csv or similar, some of them are actually Excel home sheets where time is registered.
The best idea so far is to create our own excel sheet, which you can use to integrate with all of these applications. Integrations can be in the form of cells containing something like = '[c: \ export.csv] rawdata'! $ A $ 3, where export.csv is the csv file exported from time logging applications. Can you see a better way to integrate with all these applications? It should be noted that almost all of our customers have Microsoft Office.
Edit: Answers great questions from Pontus Gagge:
How similar is the data in different applications? I assume that since they accept the applications for registration, they will have some similarities, but I assume that some will register how long the whole work lasts for a whole month, while others will work for each day. If Excel is selected, I believe that many differences can be eliminated using basic formulas.
What is the quality of the data? The quality of the data may vary, therefore, it is necessary to conduct a basic check, as well as make it transparent to customers, as our application understands their contribution, therefore they are responsible.
How much data are you talking about? There will be information on the working hours of up to 50 employees.
Is integration only one-way? Yes
How often should information be transmitted? Once a month (when they need to pay a salary).
?
Excel, , (, - -). , , , , .
?
, , . , , , , , 30 , .
-, ?
, . . , , - ..
" " - ...?
-, .