Import long, lat for geo layouts

[rezmont]

Hi,

I am fairly familiar with gephi and have no problem importing different attributes from my Mysql DB. I need to import long, lat coordinates and color. however, and gephi is giving me a hard time with this.

select router_ip id, size, label, x, y, '255,0,0' color from ip_nodes;

router_ip is an int, size is a double, x y are also doubles, and lastly label is a varchar. color as you can see is static and I just want to be sure I can change it as well. The problem is that when data is imported it is displayed right, i.e., each node is where it is supposed to be. the data lab tab however, does not have x, y, properties tho. which makes it impossible to apply a geo layout. Any ideas how to fix this?