[SOLVED] Data import errors

General discussion of OpenCATS

Moderators: RussH, cptr13

Forum rules
Just remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but keep comments directed to the topic at hand.
Post Reply
Anko
Posts: 2
Joined: 18 May 2017, 15:45
what is two(2) plus three(3) ?: 5

[SOLVED] Data import errors

Post by Anko » 18 May 2017, 16:06

Hi everyone,
I am having errors trying to import excel tabs into openCATS.
I'm importing candidates using Settings => Administration => Data Import, as tab delimited files.
But OpenCATS does not seem to be able to decrypt the files, in the fields detection fiels, I got this only strange caracters like this:
���%��rZY�@1__�f��q��R4D�AJ�h

I am using the latest version of excel, I save my files as .xlsx, although I have tried nearly every format including csv, with the same results.
I was only able to import files I exported from OpenCATS.

My excel files are encoded as Occidental Alphabet (Windows), I don't have the option for UTF-8 encoding while saving them, only occidental and arab alphabets, tell me if you think that this is an issue.

I am new to OpenCATS, but don't hesitate to ask for any further information.

Thanks for youre help

Anko
Posts: 2
Joined: 18 May 2017, 15:45
what is two(2) plus three(3) ?: 5

Re: Data import errors

Post by Anko » 22 May 2017, 16:05

Ok I solved my problem

I saved the files as .csv, delimited by comas.
But it was indeed delimited by semicolons.
So I opened the .csv with a text editor and I replaced the semicolons by comas.
It worked

User avatar
alexukie
Posts: 26
Joined: 12 Apr 2008, 13:51

Re: [SOLVED] Data import errors

Post by alexukie » 07 Dec 2018, 02:24

Cool - what was the format of your CSV file that you have used?

Post Reply