[Pmapper-users] join a mdb file with odbc
Hello everybody, i'm in troubles and i hope you can help me. I'm a beginner in pmapper and i have to solve a problem with a join to an external ms-access database: join doesn't work, more over are the explanations. I've read the whole newsletter but usually talks about problems with postgres and there are no useful examples for me. Even PEAR manual is too short. My machine (os: win xp) runs Mapserver for Windows (MS4W) v. 1.5.0 (the package as is) and I've installed pmapper v.1.2.0 following the instructions in the documentation -- This is the layer interested in the join (map file extract): # Start of Layer fabbricati # LAYER NAME "fabbricatiGBO" TYPE polygon DATA "fabbricatiGBO" METADATA "DESCRIPTION" "fabbricati" "RESULT_FIELDS" "IDF,FABBRI_N,FABBRI_T,FOGLIO_N,FOGLIO_T,ID1" "RESULT_HEADERS" "Idf,Fabbri_n,Fabbri_t,Foglio_n,Foglio_t,Id1" "RESULT_JOIN" "odbc://'':''/localhost at daticatastali||SITUAZIF at [EMAIL PROTECTED] at Cons||IDF||1" END # Metadata CLASS Name 'fabbricati' COLOR 252 205 104 OUTLINECOLOR 0 0 0 TEMPLATE void END # Class END # Layer -- Here is the error in the error log file: [27-Apr-2006 18:05:15] Could not connect to DB defined for Layer 'fabbricatiGBO'. Check map file entry for JOIN definition. -- What i did: I created a DSN file named 'daticatastali.dsn' pointing to the ms-access database, but i don't know where to put it and if it has the right content. Then I even created a user DSN. I checked if PEAR's DB module was installed and i found it in c:\ms4w\Apache\php\PEAR\DB I tried to change the syntax in many ways but unsuccessfully. I controlled that filed names were right. -- My questions: What's the right syntax for the "RESULT_JOIN" instruction? Am I in the correct way? Where i put the dsn file? Do I have to use username 'admin' or change slashes or paths? Thanks in advance Greetings, antonio
[Pmapper-users] R: join a mdb file with odbc
Dear Armin,
I made a SYSTEM DSN and some new error message appeared in the query result
window:
Warning: Cannot use a scalar value as an array in
C:\ms4w\Apache\htdocs\pmapper\incphp\query\squery.php on line 222
Warning: Invalid argument supplied for foreach() in
C:\ms4w\Apache\htdocs\pmapper\incphp\query\squery.php on line 222
In the previous mailing list is told this error is connected with one2many
joins. I tried with a one2one join but I have the same error result.
I tried with lower-case names of tables and fields but it's the same.
However I really need one2many join. Anybody made a patch for the squery.php
file? (I don't know PHP code)
Here is the new command lines in MAP file:
"RESULT_JOIN" "odbc://'':''/localhost a turbo||situazip a [EMAIL PROTECTED] a
qua||IDP||0"
"RESULT_JOIN" "odbc://'':''/localhost a turbo||situazif a [EMAIL PROTECTED] a
cons||IDF||1"
where 'turbo' is a SYSTEM DNS connected to a mdb file
Thanks again,
antonio
>- Original Message -
>From: Armin Burger
>To: toni
>Cc: pmapper-users a faunalia.it
>Sent: Thursday, April 27, 2006 9:41 PM
>Subject: Re: [Pmapper-users] join a mdb file with odbc
>
>
>did you try if the connection via pure PHP/PEAR to your ODBC connection
>is working correctly? And try best via a Web page, not just a command
>line run of the PHP script. Like
>
>$dsn = "odbc://'':''/localhost a daticatastali";
>$dbh = DB::connect($dsn);
>if (DB::isError($dbh)) {
> die ($dbh->getMessage());
>}
>
>That is the first step to check, since pmapper does not have lots of
>debugging to work with databases and joins. In your case it looks like a
>not correctly set definition of the connection parameters. It stems from
>the call
>
>$dbh = $this->dbConnect($dsn);
>if (!$dbh) error_log ...
>
>A DSN file is not required and I don't know what it should contain. As
>long as you have not set a password, user and password string remain
>empty ('').
>
>I have not used joins since some time, but 1-to-1 should work (1-to-many
>will not work corrcetly).
>
>I have an old definition that is
>
>"odbc://'':''/myserver a peartest||corine a [EMAIL PROTECTED] a
>landcover||CODE||0"
>
>where 'peartest' is the ODBC definition ('Data Source Name') defined in
>Windows ODBC Admin (I think it has to be a *SYSTEM* DSN). 'corine' is a
>table in the mdb file. 'code' is the join field in the ODBC table,
>'CODE' the join field in the shapefile dbf.
>
>armin
>
>toni wrote:
> Hello everybody,
> i'm in troubles and i hope you can help me.
>
> I'm a beginner in pmapper and i have to solve a problem with a join to an
> external ms-access database: join doesn't work, more over are the
> explanations.
> I've read the whole newsletter but usually talks about problems with
> postgres and there are no useful examples for me. Even PEAR manual is too
> short.
>
> My machine (os: win xp) runs Mapserver for Windows (MS4W) v. 1.5.0 (the
> package as is) and I've installed pmapper v.1.2.0 following the
instructions
> in the documentation
>
> --
> This is the layer interested in the join (map file extract):
>
> # Start of Layer fabbricati
> #
> LAYER
> NAME "fabbricatiGBO"
> TYPE polygon
> DATA "fabbricatiGBO"
> METADATA
> "DESCRIPTION" "fabbricati"
> "RESULT_FIELDS" "IDF,FABBRI_N,FABBRI_T,FOGLIO_N,FOGLIO_T,ID1"
> "RESULT_HEADERS" "Idf,Fabbri_n,Fabbri_t,Foglio_n,Foglio_t,Id1"
> "RESULT_JOIN"
> "odbc://'':''/localhost a daticatastali||SITUAZIF a [EMAIL PROTECTED] a
> Cons||IDF||1"
> END # Metadata
> CLASS
> Name 'fabbricati'
> COLOR 252 205 104
> OUTLINECOLOR 0 0 0
> TEMPLATE void
> END # Class
> END # Layer
>
> --
> Here is the error in the error log file:
>
> [27-Apr-2006 18:05:15] Could not connect to DB defined for Layer
> 'fabbricatiGBO'. Check map file entry for JOIN definition.
>
> --
> What i did:
>
> I created a DSN file named 'daticatastali.dsn' pointing to the ms-access
> database, but i don't know where to put it and if it has the right
content.
> Then I even created a user DSN.
> I checked if PEAR's DB module was installed and i found it in
> c:\ms4w\Apache\php\PEAR\DB
> I tried to change the syntax in many ways but unsuccessfully.
> I controlled that filed names were right.
>
> --
> My questions:
>
> What's the right syntax for the "RESULT_JOIN" instruction?
> Am I in the correct way?
> Where i put the dsn file?
> Do I have to use username 'admin' or change slashes or paths?
>
>
> Thanks in advance
> Greetings, antonio
>
>
> ___
> Pmapper-users mailing list
> Pmapper-users a faunalia.it
> http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users
>
>
[Pmapper-users] R: R: join a mdb file with odbc
Hi Armin and other pmapper users,
join with mdb file now works correctly, great. (but i've got a question, see
more over)
I text some little rules if anybody needs to join a SHAPE dbf file to an mdb
file
(tested on win xp, ms4w, and pmapper 1.2.0):
- DSN to mdb file must be a SYSTEM DSN, just enter control panel > admin
tools > ODBC to create it
- syntax for map file in the example of pmapper documentation is correct, if
it doesn't work must be something else (check DB connection, see the last
point)
- join doesn't work with one2many relation, ONLY with one2one relation
- join doesn't work with TEXT fields, i tried NUMERIC and it goes
- add the joined field headers in the "RESULT HEADERS" tag
- control error log file if connection is refused
- to check if PEAR connection works create this .phtml file and run it:
getMessage());
}
?>
result page must be white (otherwise some connection error message appears)
--
Question:
why join doesn't work with text fields?
Thanks and goodbye,
antonio
- Original Message -
From: Armin Burger
To: toni
Cc: pmapper-users a faunalia.it
Sent: Friday, April 28, 2006 8:31 AM
Subject: Re: [Pmapper-users] R: join a mdb file with odbc
I guess it is related to an empty query result. This might be a bug in
pmapper, in principal it should check if the returned array is really an
array and if it is not empty.
Try to modify line 220 to
if ($dbresCount > 0 && is_array($data)) {
and see if the problem remains. And try what you get if you write out the
$data with print_r() (the line should already be there, but commented out).
A 1-n join became a bit more complicated to implement when I changed the
whole query part. It would break some of the current logics and needs a
slightly deeper code modification. Since I do not use joins any more I will
not tackle this problem very soon, I guess.
Armin
> --- Urspr?ngliche Nachricht ---
> Von: "toni"
> An:
> Betreff: [Pmapper-users] R: join a mdb file with odbc
> Datum: Fri, 28 Apr 2006 00:00:16 +0200
>
> Dear Armin,
> I made a SYSTEM DSN and some new error message appeared in the query
> result
> window:
>
> Warning: Cannot use a scalar value as an array in
> C:\ms4w\Apache\htdocs\pmapper\incphp\query\squery.php on line 222
>
> Warning: Invalid argument supplied for foreach() in
> C:\ms4w\Apache\htdocs\pmapper\incphp\query\squery.php on line 222
>
> In the previous mailing list is told this error is connected with one2many
> joins. I tried with a one2one join but I have the same error result.
> I tried with lower-case names of tables and fields but it's the same.
>
> However I really need one2many join. Anybody made a patch for the
> squery.php
> file? (I don't know PHP code)
>
>
>
> Here is the new command lines in MAP file:
>
> "RESULT_JOIN" "odbc://'':''/localhost a turbo||situazip a [EMAIL PROTECTED] a
> qua||IDP||0"
>
> "RESULT_JOIN" "odbc://'':''/localhost a turbo||situazif a [EMAIL PROTECTED] a
> cons||IDF||1"
>
> where 'turbo' is a SYSTEM DNS connected to a mdb file
>
>
> Thanks again,
> antonio
>
>
>
> >- Original Message -
> >From: Armin Burger
> >To: toni
> >Cc: pmapper-users a faunalia.it
> >Sent: Thursday, April 27, 2006 9:41 PM
> >Subject: Re: [Pmapper-users] join a mdb file with odbc
> >
> >
> >did you try if the connection via pure PHP/PEAR to your ODBC connection
> >is working correctly? And try best via a Web page, not just a command
> >line run of the PHP script. Like
> >
> >$dsn = "odbc://'':''/localhost a daticatastali";
> >$dbh = DB::connect($dsn);
> >if (DB::isError($dbh)) {
> > die ($dbh->getMessage());
> >}
> >
> >That is the first step to check, since pmapper does not have lots of
> >debugging to work with databases and joins. In your case it looks like a
> >not correctly set definition of the connection parameters. It stems from
> >the call
> >
> >$dbh = $this->dbConnect($dsn);
> >if (!$dbh) error_log ...
> >
> >A DSN file is not required and I don't know what it should contain. As
> >long as you have not set a password, user and password string remain
> >empty ('').
> >
> >I have not used joins since some time, but 1-to-1 should work (1-to-many
> >will not work corrcetly).
> >
> >I have an old definition that is
> >
> >"odbc://'':''/myserver a peartest||corine a [EMAIL PROTECTED] a
> >landcover||CODE||0"
> >
>
[Pmapper-users] query result 'new line' character
Hello, another problem with pmapper... (my coordinates: win xp, ms4w v.1.5.0, pmapper 1.2.0, shape files for layers, mdb external join) Query result doesn't display the 'new line' ([ctrl+return] or [return] key) character: data stored in the shape dbf file (and in the mdb joined file) use this char. The content of a cell is e.g.: stringA stringB stringC where after the strings is placed the [return] character (new paragraph), but pmapper replaces it with a space. --- I tried to change the "layer encoding" unsuccesfully. I tried to press shift-ctrl-return or other substitutions but it's bad Any solution? Thanks in advance, toni
[Pmapper-users] news about p.mapper & MS4W
download p.mapper 2.0.0 package for MS4W at http://www.maptools.org/ms4w/index.phtml?page=downloads.html --- as soon as possible wiki quick guide
[Pmapper-users] R: pmapper 1.2.0 package for MS4W
Georges, I tested the pack on several machines and browsers here, and I don't think it's something related to p.mapper because everything is all right. Could be your java run-time environment, maybe it's not up to date. Infact if map and buttons are loaded, it means mapserver is working properly and paths for files are correct. However, take a fresh system and please try again, that's my suggestion bye - Original Message - From: geoseom To: pmapper-users a faunalia.it Sent: Monday, July 10, 2006 12:02 PM Subject: Re: [Pmapper-users] pmapper 1.2.0 package for MS4W OK, the map is now displayed with the ms4w 2.0, but the other problem stays the same. I see all the buttons, but they are not clickable. I can move the handle to change the scale, but nothing happens?? Greetings Georges -- View this message in context: http://www.nabble.com/pmapper-1.2.0-package-for-MS4W-tf1884448.html#a5249009 Sent from the Pmapper-users forum at Nabble.com. ___ Pmapper-users mailing list Pmapper-users a faunalia.it http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users
[Pmapper-users] R: R: pmapper 1.2.0 package for MS4W
Here is the final version of the pack: http://www.megaupload.com/?d=FANWLGQ5 (other link is unavailable) I added a detailed guide: "how to make a p.mapper project in 10 steps" and some other tricks
[Pmapper-users] error with "digitize" operation
Hello, I'm using p.mapper 1.9.5 (the latest "official" release downloaded from sourceforge) Everything is all right but when I use the "digitize" button (add points) I get some errors: I normally insert a label for the point but after clicking OK map doesn't load and "loading" animated gif remains visible. Browser warns: "visualization errors".
[Pmapper-users] widespreading p.mapper
Hello Armin and everybody. Look at http://www.maptools.org/ms4w/index.phtml?page=downloads.html p.mapper MS4W packages are now downloadable from maptools site. (other links here will be deactivated) I have a question for p.mapper 1.9.5 Reference map loaded is always /images/reference.png I think the reason is inside map.phtml in REFERENCE MAP SECTION: onMouseOver="startUpRef()"/> Which way can I insert the path declared in my mapfile?
[Pmapper-users] trying XY layer unsuccesfully
I'm trying p.mapper 2.0 with an XY layer from an mdb unsuccesfully. Please Armin, could you send here the mapfile extract for cities_xylayer? Toni
[Pmapper-users] R: trying XY layer unsuccesfully
Ok, I can now display the points but I get no query results. Php error log and apache error log without any message any suggestion? toni - Original Message - From: Armin Burger To: toni ; pmapper mailing list Sent: Tuesday, July 25, 2006 8:51 PM Subject: Re: [Pmapper-users] trying XY layer unsuccesfully LAYER NAME "cities_xylayer" TYPE point FEATURE POINTS 0 0 END END PROJECTION "init=epsg:3035" END METADATA "DESCRIPTION" "City XY" "RESULT_FIELDS" "city_name, admin_name" "RESULT_HEADERS" "CITY NAME, ADMIN NAME" "RESULT_HYPERLINK" "admin_name" "XYLAYER_PROPERTIES" "odbc://'':''/localhost a peartest||cities_cntrs||x,y,0" END # Metadata CLASS NAME "Cities" COLOR 0 255 0 SYMBOL 'circle' SIZE 6 TEMPLATE void END # Class END # Layer "XYLAYER_PROPERTIES" "odbc//..." in one line armin toni wrote: > I'm trying p.mapper 2.0 with an XY layer from an mdb unsuccesfully. > Please Armin, could you send here the mapfile extract for cities_xylayer? > > Toni > > > > ___ > Pmapper-users mailing list > Pmapper-users a faunalia.it > http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users > >
[Pmapper-users] R: R: trying XY layer unsuccesfully
Ok, just take it easy! All 3 query functions give the same result (the query result window opens but only the background is displayed, no such text; in the window HTML source var resultJSON writes the correct results). That's the reason I talked about "generic" query. Map file XY layer is the same as yours (I asked it some time ago) except for PROJECTION object that I commented out and for the connection line: "odbc://'':''/localhost a system_dsn||cities_cntrs||x,y,0"... what the last zero stand for? MS access db tied is composed by "cities_cntrs" table and lower case fields: x, y, city_name, admin_name. Respectevely double, double, text 50, text 50. My DSN is the same for the external joins. As I told you apache and php error logs don't warn anything, and pear connection is working surely because external joins are ok. What more? I don't know JS debugging, but, if this can be useful, my IE don't display any error message either in the main window and in the query window. Toni p.s. I think you need some holidays! - Original Message - From: Armin Burger To: toni-10 Cc: pmapper-users a faunalia.it Sent: Sunday, July 30, 2006 2:26 PM Subject: Re: [Pmapper-users] R: trying XY layer unsuccesfully The tests during development mainly used Postgres and SQLite for the xy layers, all 3 query types (identify, select, attribute search) are working for me, except the highlighting for the select. Attribute queries are not working correctly when the source is an MDB. The problem seems to be that even via ODBC MS Access does not understand standard SQL code. The query uses UPPER(searchfield) LIKE '%SEARCHSTRING%' and in case of Access it would probably need to be UCASE instead of UPPER. A satisfactory answer to your question is practically impossible because the problem description is again poor: no map file snippet, missing JS debugging info, 'query' is a term used for 3 different functions, etc. = I will just say this now and not every now and again that I will not any more reply to postings like this. There is a clear description in the Wiki FAQ how to describe a problem. But maybe no one has ever a look there... If folks don't take the time to investigate by themselves and write a decent description, they should not expect others doing this for providing support. Best regards armin toni-10 wrote: > more: > I checked the HTML source of the empty query result window (I can see only > the blue background) and I noticed that > var resultJSON it's correct: it contains everything (X Y and result fields) > > unfortunately nothing appears in the window >
[Pmapper-users] pmapper 1.2.0 package for MS4W
Hello pmapper users, I made the "pmapper 1.2.0 MS4W package". Download at http://www.megaupload.com/?d=HSRO96W0 Just unpack it to the root of the HDD where you previously installed MS4W. Run 'Apache_restart' and enjoy a ready to use pmapper with demodata. Very simple features added or modified (as map, symbol, fonts files... check documentation for details) Do you want to try it before I'll send it to maptools.org? bye
[Pmapper-users] pmapper package for MS4W
I'd like to build a pmapper package for MS4W with demodata included. This colud be useful for all the guys having troubles with first installation. write me for any suggestion
[Pmapper-users] other problems with characters
my coordinates: win xp, ms4w v.1.5.0, pmapper 1.2.0, shape files for layers
I have two problems with the attribute query.
1) Search doesn't work with slash character.
e.g.: "A/8" or "B/2" produces no result. These data are instead displayed
correctly with the identify query
2) Character "?" in the label texts makes the whole search object to
corrupt. It won't be displayed in the search frame,
e.g.: (see the last label)
searchList['particelleGBO'] = new Array('', 'FOGLIO_N&&#*PARTIC_T&&#DESCQUALIT', '','');
[Pmapper-users] R: query result 'new line' character
Problem solved! It's not related to a function of Mapserver/Mapscript. Query result are outputted in HTML, this is why carriage return doesn't work. Just use the HTML tag as separator and strings appear in multple lines. e.g.: if input data is: StringA StringB StringC output would be: StringA StringB StringC I suppose even other HTML tags work normally, so it's possible to add even images or whatsoever in query result! - Original Message - From: Armin Burger To: toni Cc: pmapper mailing list Sent: Sunday, April 30, 2006 8:36 PM Subject: Re: [Pmapper-users] query result 'new line' character I guess this is a function of Mapserver/Mapscript. pmapper just displays the result from the Mapscript function. armin toni wrote: > Hello, > another problem with pmapper... > (my coordinates: win xp, ms4w v.1.5.0, pmapper 1.2.0, shape files for > layers, mdb external join) > > Query result doesn't display the 'new line' ([ctrl+return] or [return] key) > character: > data stored in the shape dbf file (and in the mdb joined file) use this > char. > The content of a cell is e.g.: > > > stringA > stringB > stringC > > > where after the strings is placed the [return] character (new paragraph), > but pmapper replaces it with a space. > > --- > I tried to change the "layer encoding" unsuccesfully. > I tried to press shift-ctrl-return or other substitutions but it's bad > > Any solution? > > Thanks in advance, > toni > > > > ___ > Pmapper-users mailing list > Pmapper-users a faunalia.it > http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users > >
[Pmapper-users] R: other problems with characters
Problem 2 is solved (not the same with problem 1)
It's related to encoding. (Have to be in UTF? Something like this)
I replaced "?" with the 2 chars used in languageIT.php for this letter.
Now it's ok.
- Original Message -
From: toni
To: pmapper mailing list
Sent: Friday, May 05, 2006 5:41 PM
Subject: other problems with characters
my coordinates: win xp, ms4w v.1.5.0, pmapper 1.2.0, shape files for layers
I have two problems with the attribute query.
1) Search doesn't work with slash character.
e.g.: "A/8" or "B/2" produces no result. These data are instead displayed
correctly with the identify query
2) Character "?" in the label texts makes the whole search object to
corrupt. It won't be displayed in the search frame,
e.g.: (see the last label)
searchList['particelleGBO'] = new Array('', 'FOGLIO_N&&#*PARTIC_T&&#DESCQUALIT', '&&&&','');
[Pmapper-users] invert color image when printing
Hello everybody, I've set background color of the image (in map file) as black and I use white or light colors to display lines. There is a reason: raster orthophotos or satellite images are usually quite dark and so it's better to overlay layers with light colors. I ask if you know a method to invert color images when I send map to print, the best would be in this way: when R G B assume the same value (grey tone) then invert, else leave the color as it is. Thank you bye, toni
[Pmapper-users] attribute query and records with no geometry
Hi everybody, i'm using win xp, ms4w v.1.5.0, pmapper 1.2.0, shape files for layers. I've set as pmapper layer a shape file including records without geometry (let me explain: my shape .dbf file contains records not linked with the objects in the .shp file, these records do not have geographic localization). If I use the attribute query in the search frame looking for a record without geometry I get: "no data found", when instead data are stored. Does the attribute query work only if the geometry exists or not? I created a "conventional geometry" for these records just to make the query work, but it doesn't seem the most correct way to avoid the problem (bigger file for nothing, slow map loading) thanks toni
[Pmapper-users] R: attribute query and records with no geometry
I think we're misunderstanding... I don't have an external dbf file to tie. I'm talking about the *shape dbf* file (shp shx -->dbf<--): this file contains records not linked to the geometry in the related shp file. Infact all the geometries have their own data but there are plenty data without a geometry (these are no spatial data, not linkable to the geometries). Files are not corrupted because they're intentionally made in this way. No spatial data are useful for me because when you search for them you should have the answer: data + "unlocatable". Gail Long told me he added a search function to parse the shape dbf searching for records without geometry tie, then he migrated to postgis & postgres because search was faster. Any other suggestion? thanks in advance, bye - Original Message - From: Armin Burger To: Gail Long Cc: fiorenontaglio a libero.it ; pmapper-users a faunalia.it Sent: Wednesday, May 24, 2006 11:18 PM Subject: Re: [Pmapper-users] attribute query and records with no geometry Just a more general remark using dbf files and querying them with PHP: If for whatever reasons whatsoever you need to use them and not putting the data into a real DB, on Windows you can speed up things via ODBC. If you have MS Access, just define an MDB and link the dBase files to it as external data source. Then access the MDB via the ODBC driver. Works *much* faster than native dbf functions. Another remark for shapefiles and dbf: If you modify the dbf part of a shapefile with pure dBase functions/programs, and add or remove records, you might get into trouble sooner or later with a corrupt shapefile that is not readable any more. Armin Gail Long wrote: > Tony, > > A layer is made up of shape files for geometry and data in the dbf files for > attributes. If there is no tie to the geometry there are no records to be > returned. > > However, I had a similar need and know that what you want to do can be done. > I have several .dbf files that have lots of useful data in them. For the > most part I've been able to use a pmapper JOIN and tie the data uniquely to > a record in a shape file ( a feature) by adding a key field to the dbf > tables that links back to my Postgres tables. This should work the same way > with shape files and link back to an attribute. > > With two of the tables however, I don't have a clean way to join them to a > geographic feature. So, in order to get to that data I added an additional > search form to search.phtml, and copied info.phtml and called a dbase search > using php to return records from the table with no shapefile ties. After > using this method for awhile and finding it slow, I've converted the dbf > files to a postgres tables so that its easier to deal with them and I can > index them for MUCH better performance. > > This worked so well for me that I've extended this to do searches on a > couple of mysql dbs as well. > > As to mapping, I'm very close to finding a quick way to create point data in > a shape so that each of my featureless data records will now be able to be > mapped when I want them mapped. > > In order to do this you'll have to either write a new query class and a > couple of new print functions, or alter the ones that Armin has provided, so > that it will create a zoompoint link rather than zoomextent. Not trivial > but not too difficult either. Because I wasn't mapping these tables I just > encapsulated all of that functionality in my altered info_data.phtml. > > I do encourage you to setup Postgres with PostGIS if you are planning on > doing much pure data manipulation. The windows installer for Postgres and > PostGIS are very simple to use and you'll find that you gain lots of > advantages over using shape files and dbf files. > > Good luck! > -- > Things are only difficult while you don't understand them. > > > > >> From: "toni" >> To: "pmapper mailing list" >> Subject: [Pmapper-users] attribute query and records with no geometry >> Date: Tue, 23 May 2006 23:23:05 +0200 >> >> Hi everybody, >> >> i'm using win xp, ms4w v.1.5.0, pmapper 1.2.0, shape files for layers. >> >> I've set as pmapper layer a shape file including records without geometry >> (let me explain: my shape .dbf file contains records not linked with the >> objects in the .shp file, these records do not have geographic >> localization). >> If I use the attribute query in the search frame looking for a record >> without geometry I get: "no data found", when instead data are stored. >> >> Does the attribute query work only if the geometry exists or not? >> I created a "conventiona
[Pmapper-users] pmapper 1.2.0 package for MS4W
replace the content of /ms4w/apps/pmapper-1.2.0/index.html with this one,
it's more cute:
p.mapper start page
function openFrames(sizevals, gLanguage, config, startParameters){
var sizearray = sizevals.split('#');
var winwidth = parseInt(sizearray[0]);
var winheight = parseInt(sizearray[1]);
var winsize = sizearray[2];
myw=window.open("frameview.phtml?winsize=" + winsize + "&language=" +
gLanguage + "&config=" + config + startParameters, "MapServerTestSuite",
"width=" + winwidth + ",height=" + winheight +
",menubar=no,scrollbar=auto,resizable=yes,top=0,left=0,status=yes");
}
<!--
body {font-size: 12px;font-family: ARIAL,HELVETICA;SANS-SERIF;color:
#FF;background: #003366;cursor: default;}
a {color: #FF; text-align: left; text-decoration: none;}
a:hover {text-decoration: underline;}
a:visited {color: #FF;}
td {font-size: 12px; font-family: Arial, Helvetica, sans-serif; color:
#FF;}
-->
images/logo.gif
Welcome to p.mapper 1.2.0 (MS4W package)
P.mapper application offers broad functionality and multiple
configurations in order to facilitate the setup of a MapServer webmapping
tool based on PHP/MapScript.
Links below start the application demo loaded by default, check
documentation how to make your own projects. Enjoy!
please change session.use_trans_sid setting to 1 in your PHP.ini
file at section [session] before running
view demo
english
german
french
italian
p.mapper MS4W version packaged by toni
--
View this message in context:
http://www.nabble.com/pmapper-1.2.0-package-for-MS4W-tf1884448.html#a5156341
Sent from the Pmapper-users forum at Nabble.com.
[Pmapper-users] pmapper 1.2.0 package for MS4W
p.mapper start page images/logo.gif Welcome to p.mapper 1.2.0 (MS4W package) P.mapper application offers broad functionality and multiple configurations in order to facilitate the setup of a MapServer webmapping tool based on PHP/MapScript. Links below start the application demo loaded by default, check documentation how to make your own projects. Enjoy! please change session.use_trans_sid setting to 1 in your PHP.ini file at section [session] before running view demo english german french italian p.mapper MS4W version packaged by toni -- View this message in context: http://www.nabble.com/pmapper-1.2.0-package-for-MS4W-tf1884448.html#a5156404 Sent from the Pmapper-users forum at Nabble.com. -- parte successiva -- Un allegato HTML ? stato rimosso... URL: http://faunalia.it/pipermail/pmapper-users/attachments/20060703/f99298b0/attachment.htm
[Pmapper-users] pmapper 1.2.0 package for MS4W
Pagina normale senza titolo
<HTML>
<HEAD>
<TITLE>p.mapper start page</TITLE>
<SCRIPT LANGUAGE="JavaScript1.2">
function openFrames(sizevals, gLanguage, config,
startParameters){
var sizearray = sizevals.split('#');
var winwidth = parseInt(sizearray[0]);
var winheight = parseInt(sizearray[1]);
var winsize = sizearray[2];
myw=window.open("frameview.phtml?winsize=" + winsize +
"&language=" + gLanguage + "&config="
+ config + startParameters, "MapServerTestSuite",
"width=" + winwidth + ",height=" + winheight
+
",menubar=no,scrollbar=auto,resizable=yes,top=0,left=0,status=yes");
}
</SCRIPT>
<style type="text/css">
<!--
body {font-size: 12px;font-family:
ARIAL,HELVETICA;SANS-SERIF;color: #FF;background:
#003366;cursor: default;}
a {color: #FF; text-align: left; text-decoration: none;}
a:hover {text-decoration: underline;}
a:visited {color: #FF;}
td {font-size: 12px; font-family: Arial, Helvetica, sans-serif;
color: #FF;}
-->
</style>
</HEAD>
<BODY text="white">
<table width="100%" bgcolor="#FF">
<tr><td><img src="images/logo.gif"
border="0" alt=""></td></tr>
</table>
<table width="1%">
<tr><td NOWRAP><h2>Welcome to p.mapper 1.2.0
(MS4W package)</h2></td></tr>
<tr><td>P.mapper application offers broad
functionality and multiple configurations in order to facilitate
the setup of a MapServer webmapping tool based on
PHP/MapScript.<br>
Links below start the application demo loaded by default, check
documentation how to make your own projects.
Enjoy!<br><br>
<i>please change
</i><tt>session.use_trans_sid</tt><i>
setting to </i>1<i> in your
</i>PHP.ini<i> file at section
</i><tt>[session]</tt><i> before
running</i></tr></td>
<tr><td><br><br><br><br></tr></td>
<tr align="center"><td><h4>view
demo</h4>
<table cellspacing="6" style="border-style:
solid; border-width: 1px; padding-left: 4px; padding-right: 4px;
padding-top: 1px; padding-bottom: 1px">
<tr align="center"><td><a
href="javascript:openFrames('740#540#small', 'en', '',
'')">english</a></td>
<td><a href="javascript:openFrames('740#540#small',
'de', '', '')">german</a></td>
<tr align="center"><td><a
href="javascript:openFrames('740#540#small', 'fr', '',
'')">french</a></td>
<td><a href="javascript:openFrames('740#540#small',
'it', '', '')">italian</a></td></table>
</tr></td>
</table>
<br><br><br><br><br><br><br><br><br><br><hr>
<font size="1">p.mapper MS4W version packaged by
toni
</BODY>
</HTML>
--
View this message in context:
http://www.nabble.com/pmapper-1.2.0-package-for-MS4W-tf1884448.html#a5156463
Sent from the Pmapper-users forum at Nabble.com.
-- parte successiva --
Un allegato HTML ? stato rimosso...
URL:
http://faunalia.it/pipermail/pmapper-users/attachments/20060703/8c1059d1/attachment.htm
[Pmapper-users] pmapper 1.2.0 package for MS4W
I solved the problem with ms4w_2.0 change "short_open_tag" to On in the php.ini and everything should be allright, let me know... i will add this hint surely -- View this message in context: http://www.nabble.com/pmapper-1.2.0-package-for-MS4W-tf1884448.html#a5197590 Sent from the Pmapper-users forum at Nabble.com.
[Pmapper-users] R: R: pmapper 1.2.0 package for MS4W
Ok, but i have to make some modifies to the quick guide because it's fit to the MS4W environment. I'll work it out however -- View this message in context: http://www.nabble.com/pmapper-1.2.0-package-for-MS4W-tf1884448.html#a5375387 Sent from the Pmapper-users forum at Nabble.com.
[Pmapper-users] error with "digitize" operation
I found it. It was a MapServer error: Verdana fonts are required to display new labels Must be loaded -- View this message in context: http://www.nabble.com/error-with-%22digitize%22-operation-tf1959616.html#a5381874 Sent from the Pmapper-users forum at Nabble.com.
[Pmapper-users] Join Mysql
If you find some new tricks about joins please update the wiki entry -- View this message in context: http://www.nabble.com/Join-Mysql-tf2012479.html#a5544118 Sent from the Pmapper-users forum at Nabble.com.
[Pmapper-users] R: trying XY layer unsuccesfully
more: I checked the HTML source of the empty query result window (I can see only the blue background) and I noticed that var resultJSON it's correct: it contains everything (X Y and result fields) unfortunately nothing appears in the window -- View this message in context: http://www.nabble.com/trying-XY-layer-unsuccesfully-tf1997560.html#a5548995 Sent from the Pmapper-users forum at Nabble.com.
[Pmapper-users] P.mapper 2 windows installation
ciao giovanni, are you using the ms4w package downloaded from maptools? I've tested it with 2.1 and everything was ok However you can use a previous ver of ms4w ciao, stammi bene toni Giovanni Rizzato wrote: > > Hi everyone! > I'trying to install pmapper 2.0.0 on ms4w 2.1 (in windows Xp) > When I try to load the demodata i see > the reference map and the loading gif in the middle... > but nothing in the main map window.with p.mapper 1.2.0, ms4w 1.5.0 i don't > have any problemi have this error in the php log:PHP Warning: PHP > Startup: SVWj: Unable to initialize moduleModule compiled with module > API=20020429, debug=0, thread-safety=1PHPcompiled with module > API=20050922, debug=0, thread-safety=1These options need to match in > Unknown on line 0Any idea???best regardsGiovanni > ___ > Pmapper-users mailing list > Pmapper-users a faunalia.it > http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users > > -- View this message in context: http://www.nabble.com/P.mapper-2-windows-installation-tf2383225.html#a6656690 Sent from the Pmapper-users mailing list archive at Nabble.com.
Re: [pmapper-users] firefox, iexplorer
You have to remove it from js_locales.php (the frist line) The same for google chrome Armin Burger-2 wrote: > > if you'd check your Javascript error log you could see an error > > [Break on this error] // ARRAY FOR ANNOTATIONS\n > js_custom.php?PHP... (line 4) > > remove it and it should be ok also with FF, if you don't see the  > characters swap the encoding (UTF <-> Latin1). > > armin > > On 14/07/2008 23:24, Cesar Raul Villalba wrote: >> I install pmapper 3.2 in www.ecologiasig.misiones.gov.ar with firefox >> only show upper bar in blue, in iexplorer is ok. help me please >> Cesar R. Villalba >> Ministerio de Ecologia >> Provincia de Misiones >> Argentina >> >> > > - > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source project, > along with a healthy diet, reduces your potential for chronic lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > ___ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > > -- View this message in context: http://www.nabble.com/firefox%2C-iexplorer-tp18453551p19429536.html Sent from the pmapper users mailing list archive at Nabble.com. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] hyperlinks tip
Pmapper documentation says: >The hyperlinks are defined in the METADATA tag for every layer like the following example: >"RESULT_HYPERLINK" "FIELD1||Link on Detail, FIELD2" >In between the quotes separate the hyperlink fields with commas. If you don't want to have the field >value being displayed as the hyperlink text, you can add an ALIAS name after the field name separated >with a double pipe sign like set for FIELD1 in the example above. I noticed that if you need more than one layer aliased you have to break the lines like this: "RESULT_HYPERLINK" "FIELD1||Link on Detail, FIELD2||alias2" FIELD2||alias3" -- View this message in context: http://www.nabble.com/hyperlinks-tip-tp20598650p20598650.html Sent from the pmapper users mailing list archive at Nabble.com. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] hyperlinks tip
"RESULT_HYPERLINK" "FIELD1||Link on Detail, FIELD2||alias2, FIELD3||alias3" -- View this message in context: http://www.nabble.com/hyperlinks-tip-tp20598650p20598688.html Sent from the pmapper users mailing list archive at Nabble.com. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] css problem ie7: how to enlarge width of searchitem select box
Hello, I'm using pmapper 3.2.0.
My problem is in the search bar.
I have a searchitem with options setted in the search.xml file like this:
pgsql: ..etc..
SELECT indirizzo,indirizzo_completo FROM
indirizzi
I have set a small width for the select element in query css on:
.searchitem select {
width:70px;
}
The problem in IE7 is that the option values in the pulldown menu are 70px
large as the select searchitem element. So I cannot see the entire option
strings.
This not happens in firefox.
Can you help me to enalrge the menu leaving the searchitem element 70px
width?
Thank you
--
View this message in context:
http://www.nabble.com/css-problem-ie7%3A-how-to-enlarge-width-of-searchitem-select-box-tp21088548p21088548.html
Sent from the pmapper users mailing list archive at Nabble.com.
--
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] css problem ie7: how to enlarge width of searchitem select box
Thank you for the hint...
In search.js I noticed that is possible to set var events.
function json2Select(jsonObj, fo) {
var html = ' 0) html += ' size="' + size +'" multiple="multiple" ';
if (events) {
/*for (var e in events) {
html += e + '="' + events[e] + '" ';
}*/
html += events;
}
html += '>';
I think this should be setted in the search.xml because I can see the
string:
in the xsd schema
But how?
I'd like to add something like:
onfocus="expandSELECT(this);" onblur="contractSELECT(this);"
thank you
--
View this message in context:
http://www.nabble.com/css-problem-ie7%3A-how-to-enlarge-width-of-searchitem-select-box-tp21088548p21128852.html
Sent from the pmapper users mailing list archive at Nabble.com.
--
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] css problem ie7: how to enlarge width of searchitem select box
was done as in examples... onfocus="expandSELECT(this);" onchange="contractSELECT(this);" -- View this message in context: http://www.nabble.com/css-problem-ie7%3A-how-to-enlarge-width-of-searchitem-select-box-tp21088548p21129415.html Sent from the pmapper users mailing list archive at Nabble.com. -- ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
