...
After the onboarding phase, contacts can be updated or new contacts can be imported
Data import process
...
- At the internal project kick-off, the project leader announces which data will be migrate (Individuals contact, structures, selling history as indicators)
- The team leader inform the customer and give the links to the documentation in Concluence to the customer
- The customer fills the files and gives the data in the SecuTix format to the project leader
- No later than two weeks before milestone J, the project leader creates a kayako data import with the data
- If the customer is not able to give the data in the SecuTix format, The customer delivers his format and a special price is communicated to the customer (Ask FLO)
- CSVN verifies the data and transforms the data by scripts or excel formulas. There is no individual modification. Every modification is reproducible with the scripts or excel formulas. Only entire columns are modify. No individual modification is done on a line
- CSVN imports the data in a development environment to validate the import process. VN correct the scripts and formulas to solve the imports problems.
- The quality gate in CSVN verify the log file and the protocol used (scripts and excel formulas applied to transform the data) Actions are taken in CSVN if corrections are necessary
- No later than one week before milestone J, CSVN import the data into the pre production environment (pre condition: The copy of data Institution and basic configuration) from prod – to preprod is done before.
- CSVN update the kayako with the list of non-imported data (Log file), set the kayako to “final validation” and set the owner to the project leader
- J-2: The customer validate the data import in pre-production
- Optionally, to import recent data, the customer has the possibility to give a second full data extraction at J-1 in the same format than the first data extraction. VN execute the same scripts on the data.
- J : CSVN imports the data in production
- CSVN update the kayako with the list of non-imported data (Log file), set the kayako to “final validation” and set the owner to the project leader
- The project leader validates the import, transmits to the customer and set the kayako to “solved”.
Data import planning
J-14: The customer deliver delivers the cleaned data in SecuTix format
...
J-2 : The customer validate the data import in the pre production nenvironment
J: : CSVN import the data in the production environment
...