LMS Collaborator knowledge base

Home/Users/User management/How to change the import file

How to change the import file

The import file should be generated automatically by the personnel accounting system installed in the company. This is the best way to avoid errors and subsequent troubles that can occur if a data error is made.

But sometimes it is necessary to make a "manual" change in the data to import employees.

Here's how to do it.

Working with a cp1251 encoded file #

cp1251 is a standard Windows encoding for Russian, Ukrainian, Belarusian languages. Therefore, cp1251 encoding file is correctly opened by any version of MS Excel and is displayed as a table, the data of which can be changed.

2015-04-14_155539.jpg

This file can also be opened for editing in Libre Calc .

Working with a UTF-8 w/o BOM encoding #

It is not possible to open a file in this encoding in MS Excel. To be able to read and edit it, it is necessary to import this file into MS Excel.

This software works directly with this kind of file Libre Calc.

Importing file data into MS Excel is done in 7 steps:

c1ed.jpg

c2ed.jpg

c3ed.jpg

After that you can not only see the data in a convenient tabular form, but also change.

In order to save the result, you need to run the "Save as..." command in Excel and specify "CSV" as the file type. After that you will get a new file for import, it will be in cp1251 encoding and then it will be opened and edited in MS Excel directly.

c4ed.jpg

Still have questions?
Our technical support team is always happy to help!
Write to us at technical support [email protected]. If you are registered on our Helpdesk - send request button below.
Send request