SERP Hacker support forum - serposcope

Support forum for open-source softwares built by serphacker.com : serposcope the rank checker.

You are not logged in.

#1 2017-12-21 07:46:09

Shimon
Member
Registered: 2017-12-21
Posts: 3

Export CSV in UTF-8 encoding?

Hello,
Can I export the data in UTF-8 encoding?
Because currently when I exported, I got the keywords on Gibberish.


I would like your help,
Thank you.
Shimon

Offline

#2 2018-01-01 12:22:45

PromoteSolution
Member
Registered: 2018-01-01
Posts: 9

Re: Export CSV in UTF-8 encoding?

Any help here would be great. I am using php / mysql but my java skills aren't that great. This is as far as I have gotten

I see where he is compressing the results on line 47 of GoogleSerpDB.java  with this function  SerialBlob(compress(serp.getSerializedEntries()))

https://github.com/serphacker/serposcop … erpDB.java

The GoogleSerpEntry.java with some url functions

https://github.com/serphacker/serposcop … Entry.java

Offline

#3 2018-01-06 09:54:59

serphacker
Administrator
Registered: 2014-06-13
Posts: 411

Re: Export CSV in UTF-8 encoding?

The data are already UTF8 encoded, try to adjust your browser settings ?

Offline

#4 2018-01-07 08:09:49

Shimon
Member
Registered: 2017-12-21
Posts: 3

Re: Export CSV in UTF-8 encoding?

serphacker wrote:

The data are already UTF8 encoded, try to adjust your browser settings ?

The browser settings is set to UTF8, I tried another browser too and I still see the keywords like these:
׳¢׳œ׳™ ׳׳§׳¡׳₪׳¨׳¡ ׳‘׳¢׳‘׳¨׳™׳×
׳׳œ׳™ ׳׳§׳¡׳₪׳¨׳¡ ׳‘׳¢׳‘׳¨׳™׳×
׳׳×׳¨ ׳׳™׳‘׳™׳™ ׳‘׳¢׳‘׳¨׳™׳×
׳§׳ ׳™׳•׳× ׳‘׳׳™׳‘׳™׳™

Last edited by Shimon (2018-01-07 08:10:19)

Offline

#5 2018-01-07 09:21:32

PromoteSolution
Member
Registered: 2018-01-01
Posts: 9

Re: Export CSV in UTF-8 encoding?

Shimon,
Are you trying to get the data from the database or from the export button inside the serposcope application? I only get binary data from the database, if I export csv from inside serposcope I get a regular usable text csv.

Offline

#6 2018-01-07 09:30:02

Shimon
Member
Registered: 2017-12-21
Posts: 3

Re: Export CSV in UTF-8 encoding?

PromoteSolution wrote:

Shimon,
Are you trying to get the data from the database or from the export button inside the serposcope application? I only get binary data from the database, if I export csv from inside serposcope I get a regular usable text csv.

Yes, I talking about the export button, when I export then the keywords are unreadable. In this case the keywords are in Hebrew- could that be the reason?

Offline

Board footer