[prev in list] [next in list] [prev in thread] [next in thread]
List: wsas-java-dev
Subject: Re: [Dev] [APIM] Error when setting up Geo Location Based Statistics with APIM 2.0
From: Megala Uthayakumar <megala () wso2 ! com>
Date: 2017-05-29 6:46:57
Message-ID: CAFz1Xz9UE_1-AZKGvDW_0FRKCo5fJTFLGUtPoU_L_U_em-_FFQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/related)]
[Attachment #4 (multipart/alternative)]
Thanks Nuwan. I was able import it using CLI.
On Mon, May 29, 2017 at 11:21 AM, Nuwan Dias <nuwand@wso2.com> wrote:
> Can you try importing through the CLI please? I've done it through the CLI
> a few times and not had any issues. Faced a few problems with the MySQL
> Workbench though.
>
> On Mon, May 29, 2017 at 10:04 AM, Megala Uthayakumar <megala@wso2.com>
> wrote:
>
>> Hi All,
>>
>> I am trying to configure, Geo location bases statistics as per the
>> documentation at [1]. After creating the tables, when I try to import the
>> csv files through mysql work-bench as per the step 4, it fails with the
>> following error,
>>
>>
>> Am I missing something there? Seems like, in the csv file we are giving
>> empty value for the relevant column (*represented_country_geoname_id*)
>> and in the mysql bench it takes it as non-integer value. If this is already
>> fixed, can I get the new CSV files please?
>>
>> [1] https://docs.wso2.com/display/AM200/Configuring+Geolocat
>> ion+Based+Statistics
>>
>> Thanks.
>>
>> Regards,
>> Megala
>> --
>> Megala Uthayakumar
>>
>> Software Engineer
>> Mobile : 0779967122
>>
>
>
>
> --
> Nuwan Dias
>
> Software Architect - WSO2, Inc. http://wso2.com
> email : nuwand@wso2.com
> Phone : +94 777 775 729 <+94%2077%20777%205729>
>
--
Megala Uthayakumar
Software Engineer
Mobile : 0779967122
[Attachment #7 (text/html)]
<div dir="ltr">Thanks Nuwan. I was able import it using CLI.</div><div \
class="gmail_extra"><br><div class="gmail_quote">On Mon, May 29, 2017 at 11:21 AM, \
Nuwan Dias <span dir="ltr"><<a href="mailto:nuwand@wso2.com" \
target="_blank">nuwand@wso2.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">Can you try importing through the CLI please? \
I've done it through the CLI a few times and not had any issues. Faced a few \
problems with the MySQL Workbench though.</div><div class="gmail_extra"><div><div \
class="h5"><br><div class="gmail_quote">On Mon, May 29, 2017 at 10:04 AM, Megala \
Uthayakumar <span dir="ltr"><<a href="mailto:megala@wso2.com" \
target="_blank">megala@wso2.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div>Hi All,</div><div><br></div><div>I am \
trying to configure, Geo location bases statistics as per the documentation at [1]. \
After creating the tables, when I try to import the csv files through mysql \
work-bench as per the step 4, it fails with the following error,</div><div><img \
src="cid:ii_j39mooqi0_15c52711f3093abe" width="508" \
height="286"><br><br></div><div>Am I missing something there? Seems like, in the \
csv file we are giving empty value for the relevant column \
(<b>represented_country_ge<wbr>oname_id</b>) and in the mysql bench it takes it as \
non-integer value. If this is already fixed, can I get the new CSV files \
please?</div><div><br></div><div>[1] <a \
href="https://docs.wso2.com/display/AM200/Configuring+Geolocation+Based+Statistics" \
target="_blank">https://docs.wso2.com/disp<wbr>lay/AM200/Configuring+Geolocat<wbr>ion+ \
Based+Statistics</a></div><div><br></div><div>Thanks.</div><div><br></div><div>Regards,</div><div>Megala</div><span \
class="m_-4550266501442710582HOEnZb"><font color="#888888">-- <br><div \
class="m_-4550266501442710582m_-293921216182073924gmail_signature"><div \
dir="ltr">Megala Uthayakumar<div><br><div>Software Engineer</div><div>Mobile : \
0779967122</div></div></div></div> </font></span></div>
</blockquote></div><br><br clear="all"><div><br></div></div></div><span \
class="HOEnZb"><font color="#888888">-- <br><div \
class="m_-4550266501442710582gmail_signature" data-smartmail="gmail_signature"><div \
dir="ltr"><div><div dir="ltr"><div><div dir="ltr">Nuwan \
Dias<div><br></div><div><div>Software Architect - WSO2, Inc. <a \
href="http://wso2.com" target="_blank">http://wso2.com</a></div><div>email : <a \
href="mailto:nuwand@wso2.com" target="_blank">nuwand@wso2.com</a></div><div>Phone : \
<a href="tel:+94%2077%20777%205729" value="+94777775729" target="_blank">+94 777 775 \
729</a></div></div></div></div></div></div></div></div> </font></span></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div \
class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">Megala \
Uthayakumar<div><br><div>Software Engineer</div><div>Mobile : \
0779967122</div></div></div></div> </div>
--001a11467a5ebfaa300550a3e2a9--
["Screenshot from 2017-05-29 09-42-52.png" (image/png)]
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic