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.
By Anko
#2999
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
By Anko
#3006
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

Discover Women Seeking Casual Encounters Tonight […]

Discover Women Looking for Spontaneous Nights Out[…]

okay - strange as disk is cheap! However if you wa[…]

Can anyone assist me? Much appreciated.