SERP Hacker support forum - serposcope

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

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

serphacker

Administrator

Registered: 2014-06-13

Posts: 419

Re: Export CSV in UTF-8 encoding?

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

Shimon

Member

Registered: 2017-12-21

Posts: 3

Re: Export CSV in UTF-8 encoding?

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)

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.

Shimon

Member

Registered: 2017-12-21

Posts: 3

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.

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?