p.mapper

On 29/01/2009 09:02, SeUr2000 wrote:
> I all,
> on version 3.1 I have modified function submitSearch
> on pmquery.js for to open a list of options for research.
> 
> on version 4.1 I have tried to replicate the function submitSearch in
> pm.search.js but this is not no sign of response and the alert() not
> function.
> 
> perhaps there is another place where I have to watch?
> 
> thanks
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
> 

To directly modify the JS sources (not recommended though...) you have 
to define the path to your javascript directory in config.xml as 
'javascript/src', otherwise the 'compressed' files are used (pm_cjs.js).

The call to this function from most places would probably also have to 
be PM.Query.submitSearch() since in v4 nearly all JS functions are valid 
only in their namespace context.

If you want to replace the default function with your own I'd recommend 
placing it in custom.js under your config and put it inside the PM.Query 
namespace, like


$.extend(PM.Query,
     submitSearch: function() {
	... your code ...
     }
);	


armin

PS: p.mapper is currently not that advanced, just 4.0 beta and not yet 
at 4.1 ;-)

Hi,

I have solved the problem by using UCASE instead of UPPER in search.php 
(in getSearchParamsXY_DB function). It works fine, only it is not a 
generic solution that could identify if odbc is being used or not

regards, dejan

Dejan.Gambin@... wrote on 28.01.2009 08:02:09:

> Hi,
> 
> I am using p.mapper version 3.2 on Windows XP machine.
> 
> I have successfully displayed points coming from MS Access with two 
> "spatial" columns, using XY layer. Attributes from the same table are 
> correctly displayed too, using Info button.
> 
> The problem is the attribute query that somehow doesn't work because of 
> incorrect sql code. 
> 
> The map file part is:
> 
> LAYER 
>   NAME  "krk"
>   TYPE         POINT
>   METADATA 
>     "DESCRIPTION" "KC"
>     "LAYER_ENCODING" "WINDOWS-1250"
>     "XYLAYER_PROPERTIES"  "odbc://'':''/localhost@...>" 
>     "RESULT_FIELDS" "PREZIME,IME"
>     "RESULT_HEADERS" "Prezime, Ime"
>   END  # Metadata 
>   CLASS
>     Name 'Kc broj'
>     COLOR 0 0 0
>     SYMBOL 'circle'
>     SIZE 10
>     TEMPLATE void
>   END 
> END
> 
> The search.xml part is:
> 
>     <searchitem name="ime" description="Ime">
>         <layer type="xy" name="krk">
>             <field type="s" name="IME" description="Ime"  wildcard="0" 
/>
>         </layer>
>     </searchitem>
> 
> And the error.log is:
> 
> [28-Jan-2009 07:52:03] ===== P.MAPPER: DB ERROR =====
> Standard Message:   DB Error: syntax error
> DBMS/Debug Message: SELECT x, y, PREZIME,IME FROM baza  WHERE UPPER(IME) 

> LIKE '%ROB%'  [nativecode=37000 [Microsoft][ODBC Microsoft Access 
Driver] 
> Undefined function 'UPPER' in expression.]
> 
> I have seen a similar post and I suppose I have to somehow change the 
> UPPER to UCASE. 
> 
> Can it be done in a simple way?
> 
> thanks and regards
> 
> dejan
> 
------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users

It's not a question to identify if ODBC is used or not, but if *MS
Access* is the backend ODBC source. Real databases understand correct
SQL via ODBC and not the crude SQL/VBA mix MS defines ;-)

armin

On Wed, Jan 28, 2009 at 8:33 AM,  <Dejan.Gambin@...> wrote:
> Hi,
>
> I have solved the problem by using UCASE instead of UPPER in search.php
> (in getSearchParamsXY_DB function). It works fine, only it is not a
> generic solution that could identify if odbc is being used or not
>
> regards, dejan
>
> Dejan.Gambin@... wrote on 28.01.2009 08:02:09:
>
>> Hi,
>>
>> I am using p.mapper version 3.2 on Windows XP machine.
>>
>> I have successfully displayed points coming from MS Access with two
>> "spatial" columns, using XY layer. Attributes from the same table are
>> correctly displayed too, using Info button.
>>
>> The problem is the attribute query that somehow doesn't work because of
>> incorrect sql code.
>>
>> The map file part is:
>>
>> LAYER
>>   NAME  "krk"
>>   TYPE         POINT
>>   METADATA
>>     "DESCRIPTION" "KC"
>>     "LAYER_ENCODING" "WINDOWS-1250"
>>     "XYLAYER_PROPERTIES"  "odbc://'':''/localhost@...>"
>>     "RESULT_FIELDS" "PREZIME,IME"
>>     "RESULT_HEADERS" "Prezime, Ime"
>>   END  # Metadata
>>   CLASS
>>     Name 'Kc broj'
>>     COLOR 0 0 0
>>     SYMBOL 'circle'
>>     SIZE 10
>>     TEMPLATE void
>>   END
>> END
>>
>> The search.xml part is:
>>
>>     <searchitem name="ime" description="Ime">
>>         <layer type="xy" name="krk">
>>             <field type="s" name="IME" description="Ime"  wildcard="0"
> />
>>         </layer>
>>     </searchitem>
>>
>> And the error.log is:
>>
>> [28-Jan-2009 07:52:03] ===== P.MAPPER: DB ERROR =====
>> Standard Message:   DB Error: syntax error
>> DBMS/Debug Message: SELECT x, y, PREZIME,IME FROM baza  WHERE UPPER(IME)
>
>> LIKE '%ROB%'  [nativecode=37000 [Microsoft][ODBC Microsoft Access
> Driver]
>> Undefined function 'UPPER' in expression.]
>>
>> I have seen a similar post and I suppose I have to somehow change the
>> UPPER to UCASE.
>>
>> Can it be done in a simple way?
>>
>> thanks and regards
>>
>> dejan
>>
> ------------------------------------------------------------------------------
>> This SF.net email is sponsored by:
>> SourcForge Community
>> SourceForge wants to tell your story.
>> http://p.sf.net/sfu/sf-spreadtheword
>> _______________________________________________
>> pmapper-users mailing list
>> pmapper-users@...
>> https://lists.sourceforge.net/lists/listinfo/pmapper-users
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>

You are absolutely right :-)

Armin Burger <armin.burger@...> wrote on 28.01.2009 18:28:13:

> It's not a question to identify if ODBC is used or not, but if *MS
> Access* is the backend ODBC source. Real databases understand correct
> SQL via ODBC and not the crude SQL/VBA mix MS defines ;-)
> 
> armin
> 
> On Wed, Jan 28, 2009 at 8:33 AM,  <Dejan.Gambin@...> wrote:
> > Hi,
> >
> > I have solved the problem by using UCASE instead of UPPER in 
search.php
> > (in getSearchParamsXY_DB function). It works fine, only it is not a
> > generic solution that could identify if odbc is being used or not
> >
> > regards, dejan
> >
> > Dejan.Gambin@... wrote on 28.01.2009 08:02:09:
> >
> >> Hi,
> >>
> >> I am using p.mapper version 3.2 on Windows XP machine.
> >>
> >> I have successfully displayed points coming from MS Access with two
> >> "spatial" columns, using XY layer. Attributes from the same table are
> >> correctly displayed too, using Info button.
> >>
> >> The problem is the attribute query that somehow doesn't work because 
of
> >> incorrect sql code.
> >>
> >> The map file part is:
> >>
> >> LAYER
> >>   NAME  "krk"
> >>   TYPE         POINT
> >>   METADATA
> >>     "DESCRIPTION" "KC"
> >>     "LAYER_ENCODING" "WINDOWS-1250"
> >>     "XYLAYER_PROPERTIES"  "odbc://'':''/localhost@...>"
> >>     "RESULT_FIELDS" "PREZIME,IME"
> >>     "RESULT_HEADERS" "Prezime, Ime"
> >>   END  # Metadata
> >>   CLASS
> >>     Name 'Kc broj'
> >>     COLOR 0 0 0
> >>     SYMBOL 'circle'
> >>     SIZE 10
> >>     TEMPLATE void
> >>   END
> >> END
> >>
> >> The search.xml part is:
> >>
> >>     <searchitem name="ime" description="Ime">
> >>         <layer type="xy" name="krk">
> >>             <field type="s" name="IME" description="Ime" wildcard="0"
> > />
> >>         </layer>
> >>     </searchitem>
> >>
> >> And the error.log is:
> >>
> >> [28-Jan-2009 07:52:03] ===== P.MAPPER: DB ERROR =====
> >> Standard Message:   DB Error: syntax error
> >> DBMS/Debug Message: SELECT x, y, PREZIME,IME FROM baza  WHERE 
UPPER(IME)
> >
> >> LIKE '%ROB%'  [nativecode=37000 [Microsoft][ODBC Microsoft Access
> > Driver]
> >> Undefined function 'UPPER' in expression.]
> >>
> >> I have seen a similar post and I suppose I have to somehow change the
> >> UPPER to UCASE.
> >>
> >> Can it be done in a simple way?
> >>
> >> thanks and regards
> >>
> >> dejan
> >>
> > 
> 
------------------------------------------------------------------------------
> >> This SF.net email is sponsored by:
> >> SourcForge Community
> >> SourceForge wants to tell your story.
> >> http://p.sf.net/sfu/sf-spreadtheword
> >> _______________________________________________
> >> pmapper-users mailing list
> >> pmapper-users@...
> >> https://lists.sourceforge.net/lists/listinfo/pmapper-users
> > 
> 
------------------------------------------------------------------------------
> > This SF.net email is sponsored by:
> > SourcForge Community
> > SourceForge wants to tell your story.
> > http://p.sf.net/sfu/sf-spreadtheword
> > _______________________________________________
> > pmapper-users mailing list
> > pmapper-users@...
> > https://lists.sourceforge.net/lists/listinfo/pmapper-users
> >

and whats's the problem with your settings? does your listed search 
config not work with map info files? do you get errors, no results? I 
converted the cities10000eu shapefile from the demo data to tab format 
and everything works fine as with it in shapefile format.

armin

On 27/01/2009 12:36, Juliano Agostinho wrote:
> 
> Hi,
> 
> I have many layers with OGR connection but i dont know how config the search file.
> 
> MAPFILE :
> 
>     LAYER
>         NAME "City"
>         MAXSCALE 8000
>              TYPE POLYGON
>              STATUS ON
>              CONNECTIONTYPE OGR
>              CONNECTION "City.TAB"
>              STYLEITEM "AUTO"
>             CLASS
>             Name "City"
>             END
>                 METADATA
>                      "DESCRIPTION" "City"
>                      "RESULT_FIELDS" "NAME"
>                      "RESULT_HEADERS" "Name"
>                      "RESULT_HYPERLINK" "Name"
>                      "LAYER_ENCODING" "UTF-8"
>                      "ows_title"      "City"
>                 END
>         END
> 
> Search file (XML):
> 
> <searchitem name="City" description="City">
>         <layer type="shape" name="City">
>             <field type="s" name="NAME" description="Name"  wildcard="0" />
>         </layer>
>     </searchitem>
> 
> I want search in OGR LAYER.
> I dont want convert TAB to SHP, anyone have one suggestion ?
> THX
> 
> _________________________________________________________________
> Receba GRÁTIS as mensagens do Messenger no seu celular quando você estiver offline. Conheça  o MSN Mobile!
> http://mobile.live.com/signup/signup2.aspx?lc=pt-br
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>

Hi Armin,

Thxs

I found the problem, in the LAYER CLASS I forgot the sintaxe "TEMPLATE void".

 
 



> Date: Tue, 27 Jan 2009 19:47:03 +0100
> From: armin.burger@...
> To: julianocpa@...
> CC: pmapper-users@...
> Subject: Re: [pmapper-users] Search OGR layer
> 
> and whats's the problem with your settings? does your listed search 
> config not work with map info files? do you get errors, no results? I 
> converted the cities10000eu shapefile from the demo data to tab format 
> and everything works fine as with it in shapefile format.
> 
> armin
> 
> On 27/01/2009 12:36, Juliano Agostinho wrote:
> > 
> > Hi,
> > 
> > I have many layers with OGR connection but i dont know how config the search file.
> > 
> > MAPFILE :
> > 
> >     LAYER
> >         NAME "City"
> >         MAXSCALE 8000
> >              TYPE POLYGON
> >              STATUS ON
> >              CONNECTIONTYPE OGR
> >              CONNECTION "City.TAB"
> >              STYLEITEM "AUTO"
> >             CLASS
> >             Name "City"
> >             END
> >                 METADATA
> >                      "DESCRIPTION" "City"
> >                      "RESULT_FIELDS" "NAME"
> >                      "RESULT_HEADERS" "Name"
> >                      "RESULT_HYPERLINK" "Name"
> >                      "LAYER_ENCODING" "UTF-8"
> >                      "ows_title"      "City"
> >                 END
> >         END
> > 
> > Search file (XML):
> > 
> > <searchitem name="City" description="City">
> >         <layer type="shape" name="City">
> >             <field type="s" name="NAME" description="Name"  wildcard="0" />
> >         </layer>
> >     </searchitem>
> > 
> > I want search in OGR LAYER.
> > I dont want convert TAB to SHP, anyone have one suggestion ?
> > THX
> > 
> > _________________________________________________________________
> > Receba GRÁTIS as mensagens do Messenger no seu celular quando você estiver offline. Conheça  o MSN Mobile!
> > http://mobile.live.com/signup/signup2.aspx?lc=pt-br
> > ------------------------------------------------------------------------------
> > This SF.net email is sponsored by:
> > SourcForge Community
> > SourceForge wants to tell your story.
> > http://p.sf.net/sfu/sf-spreadtheword
> > _______________________________________________
> > pmapper-users mailing list
> > pmapper-users@...
> > https://lists.sourceforge.net/lists/listinfo/pmapper-users
> > 
> 

_________________________________________________________________
Conheça o Windows Live Spaces, a rede de relacionamentos do Messenger!
http://www.amigosdomessenger.com.br/

Hi,


there is a long existing patch (which never got in the PEAR package
itself) for the UTF-8 XLS files somewhere.
You have to patch slightly the Workbook.php of the package.

This should help:
http://research.elabs.govt.nz/generating-excel-spreadsheets-with-maori-macrons-in-php/
http://pear.php.net/bugs/bug.php?id=1572

For more, google with something like: "workbook.php UTF-8 bug Spreadsheet"

frequens


On Tue, Jan 27, 2009 at 6:19 PM, Aigars V <aigarsv@...> wrote:
>  hi.
>
> I have a problems with my UTF-8 data export to excel and csv. Can't get it
> to work. Help me, please. Thanks.
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>

Although I have used the default TOC.CSS, I am getting double sets of
scroll bars on my layers box.  I have a copy of this on :
http://members.iinet.net.au/~jjrogers/SNAG-0011.gif .  Has any one else
had this problem, and in which case, how did they manage to fix it.

Regards,
Janet Rogers

SKM is committed to working with its clients to deliver a sustainable future for all. Please consider the environment before printing this e-mail.
Notice - This message contains confidential information intended only for the exclusive use of the addressee named above. No confidentiality is waived or lost by any mistaken transmission to you. If you have received this message in error please delete the document and notify us immediately. 
Any opinion, text, documentation or attachment received is valid as at the date of issue only. The recipient is responsible for reviewing the status of the transferred information and should advise us immediately upon receipt of any discrepancy.  
All email sent to SKM will be intercepted, screened and filtered by SKM or its approved Service Providers.

On 13/01/2009 09:23, Jamie wrote:
> Hello list,
> I have about 150 layers (SHP) in my mapfile. The basic layer is a cadastral map. The others are technical infrastructure, environmental thematic and so on. Now I would like to make a spatial query, where input should be a number of parcel from cadastral layer and result will give a list of all entities from all 149 layers which intersects the selected parcel.
> Is it at all possible? 
> Any idea? 
> Jamie
> 
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
> 

It's technically possible if you programm the logic for it. There is a 
Mapscript method queryByShape or so (and some GEOS related stuff too). 
If it's really feasible I don't know, depends how long you can wait for 
a result to be returned...  How you achieve to have 150 thematic layers 
is a mystery for me. ;-)

armin

On 10/01/2009 17:47, Aigars V wrote:
> Hi.
> 
> I'm new with p.mapper.
> 
> I add my own layer in pmapper_demodata, I get it to appear in TOC and map
> window, so far all is great.
> 
> 
> Now I want to get my hyperlink to work in Result window with my layer,
> 
> I add "RESULT_HYPERLINK" "ID2" to pmapper_demo.map file.
> 
> I tried to change custom.js for my layer and hyperlik, but it doesn't work.
>  I  notice that even if I remove custom.js from javascript folder demodata
> hyperlink works without any problem it means that custom.js dont work and it
> gets
> this wikipedia script from another file (pm_cjs.js).
> 
> how to get custom.js to work ?
> ------------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It is the best place to buy or sell services for
> just about anything Open Source.
> http://p.sf.net/sfu/Xq1LFB
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
> 

Place the custom.js file eith your modifications in your config 
directory. Check the source output of map.phtml in your browser 
(right-click/'View Page Source' in FF) and you can see which JS files 
are loaded.

armin

The result is as you noticed transfered as JSON string. The description 
of the format and a better eradable sample output is available from the file

incphp/query/json_query_doc.txt

This should allow you to structure the code in the way you want by 
defining you custom Javascript function for it. Have a look at the the 
jQuery site and the available plugins. There are for sure various tab 
plugins available from small/simple to big/fully-featured.

When I will find some time I might have a quick look how to achieve 
this, shouldn't be too complicated. You could create a ticket on the pm 
Trac as enhancement request, so it will not get lost and I can remember it.

Armin

On 09/01/2009 22:05, Nahum Castro wrote:
> I Want to format the results from a query presented on a dynwin.
> 
> What I want to achive is a result page with tabs for every layer and
> pagination on the results, i have found thar x_info.php produces the
> results in the form:
> 
> 
> {'mode':'query', 'queryResult':[ [
> 
> {"name": "regiones", "description": "regiones", "header":
> ["@","gid","regsdsh","count"], "values": [ [{"shplink":
> ["regiones","2","220882.68718598+2290308.2647369+348680.86685145+2418184.0280652"]},
> "2", "2", "5"]]} ,
> 
> {"name": "municipios", "description": "municipios", "header":
> ["@","gid","mun","nombre","marginacion","region"], "values": [
> [{"shplink": ["municipios","17","221306.16622011+2338173.7855666+311003.62288478+2417760.5489982"]},
> "17", "030", "San Felipe", "A", "2"]]} ,
> 
> {"name": "localidades", "description": "localidades", "header":
> ["@","gid","nombre","municipio","poblacion_total","poblacion_60_an_mas","hablantes_l_indigena","hacinamiento","promedio_escolar","marginacion"],
> "values": [ [{"shplink":
> ["localidades","6292","242716.49211654+2341280.6411738+262716.49211654+2361280.6411738"]},
> "6292", "Las Avispas", "San Felipe", "57", "1", "0", "2.04", "3.1",
> "Muy alto"]]}
> 
> What I need to know to modify the code so i can show regiones,
> municipios and localidades layers on diferent tabs and paginate the
> results?
> I think this code uses json
> 
> Some times i get a lot of rows and the result page becomes very large.
> 
> Thanks.
> 
> --
> Nahum Castro González
> León, Guanajuato, México
> 
> ------------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It is the best place to buy or sell services for
> just about anything Open Source.
> http://p.sf.net/sfu/Xq1LFB
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>