Reply to topic

Maps in forms and reports: coordinates, whishes/bugs

User avatar awill
Registered Member
Posts
44
Karma
0
OS
Hi,
from my experiments I want to make some proposals.
The longitude and latittude values are too unprecise because there are only 2 decimal places after the comma. UTM-coordinates have 7 decial places.
In formular the theme of OSM is missing.
Editing the formular the map presents the place of the given coordinates. switching into the view-mode it shows 0,00 and 0,00 (equator).

Could the map/mapbrowser better read the datas from a db-field ?
What kind of coordinates are right? Most people have UTM-coordinates from theire GPS-devices.

Albrecht


alwi
User avatar jstaniek
Moderator
Posts
990
Karma
2
OS
awill wrote:Hi,
from my experiments I want to make some proposals.
The longitude and latittude values are too unprecise because there are only 2 decimal places after the comma. UTM-coordinates have 7 decial places.
In formular the theme of OSM is missing.
Editing the formular the map presents the place of the given coordinates. switching into the view-mode it shows 0,00 and 0,00 (equator).

Could the map/mapbrowser better read the datas from a db-field ?
What kind of coordinates are right? Most people have UTM-coordinates from theire GPS-devices.

Hi Albrecht,
I like your usage of Kexi.
Yes, the number of decimal places should be increased. Noted.

Regarding openstreetmap theme, if you have it available in the Marble app, you have it in Kexi too. Just set mapThemeId to earth/openstreetmap/openstreetmap.dgml. See http://kexi-project.org/pics/2.9/kexi-2.9-openstreetmap-forms.png

On my system Marble maps sit in /usr/share/kde4/apps/marble/data/maps and this is the folder in relation to which the mapThemeId should be set.

We'd like to make themes easier to pick, from a combo box, without a need for this kind of dgml paths.

I also confirmed and noted the defect "Editing the formular the map presents the place of the given coordinates. switching into the view-mode it shows 0,00 and 0,00 (equator)."

Thanks!


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
User avatar awill
Registered Member
Posts
44
Karma
0
OS
Hi Jaroslaw,
I enjoy your answer!
in editing the report, the following I made yet by hand.
Regarding openstreetmap theme, if you have it available in the Marble app, you have it in Kexi too. Just set mapThemeId to earth/openstreetmap/openstreetmap.dgml.


The datas for long. and lat. I wrote into the maps properties-menu were not persistent. Would you please find a way?

The text-field in the report gives the rows too much vertical distance.

Very strange: After starting the computer today - the inputfields of the map-browser in formular for long. and lat. changed to search for an image. No free input of figures are possible. (Yesterday I thouhgt it was an oversight by me.)

And last, the combi-field in the formular reports nothing.

Even if Kexi has some issues, I like it.
Albrecht


alwi
User avatar jstaniek
Moderator
Posts
990
Karma
2
OS
the inputfields of the map-browser in formular for long. and lat. changed to search for an image. No free input of figures are possible

I do confirm that, to be fixed in 2.9.3.


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
User avatar jstaniek
Moderator
Posts
990
Karma
2
OS
The datas for long. and lat. I wrote into the maps properties-menu were not persistent. Would you please find a way?

Is that the same issue as this one? "Editing the formular the map presents the place of the given coordinates. switching into the view-mode it shows 0,00 and 0,00 (equator)."

The text-field in the report gives the rows too much vertical distance.

Could you show a screenshot or explain more?

And last, the combi-field in the formular reports nothing.

You can see how the Ownership form is constructed as an example in this project file: http://kde-files.org/content/show.php/S ... tent=23137

Thanks!


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
User avatar awill
Registered Member
Posts
44
Karma
0
OS
jstaniek wrote:
The datas for long. and lat. I wrote into the maps properties-menu were not persistent. Would you please find a way?

Is that the same issue as this one? "Editing the formular the map presents the place of the given coordinates. switching into the view-mode it shows 0,00 and 0,00 (equator)."

No, it's different. My last sentence based on my misunderstanding: you cannot enter coordinates in the section "project". They must be entered in seperate fields, reading them from there. Even if this works in the project of report (it does really), this is not the way, a user could enter datas in the formlar.

The text-field in the report gives the rows too much vertical distance.

Could you show a screenshot or explain more?


And last, the combi-field in the formular reports nothing.

You can see how the Ownership form is constructed as an example in this project file: http://kde-files.org/content/show.php/S ... tent=23137

Thanks![/quote]


alwi
User avatar jstaniek
Moderator
Posts
990
Karma
2
OS
awill wrote:No, it's different. My last sentence based on my misunderstanding: you cannot enter coordinates in the section "project". They must be entered in seperate fields, reading them from there. Even if this works in the project of report (it does really), this is not the way, a user could enter datas in the formlar.


Hi Albrecht,
You can bind a table or query column to the map element of reports and forms. The column is expected to have this format:

Code: Select all
latitude;longitude;zoom

For example:
Code: Select all
59.0364;14.8033;1628


(zoom in other words is the altitude, an integer)

Any changes made by user in the date view by dragging the map area or zooming will be reflected in that column's value.

This unusual approach comes from the fact that for now Kexi does not allow binding form/report elements to more than one column.
There's a room for improvement.

Cheers.


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
User avatar awill
Registered Member
Posts
44
Karma
0
OS
jstaniek wrote:
The datas for long. and lat. I wrote into the maps properties-menu were not persistent. Would you please find a way?

Is that the same issue as this one? "Editing the formular the map presents the place of the given coordinates. switching into the view-mode it shows 0,00 and 0,00 (equator)."

No, it's different. My last sentence based on my misunderstanding: you cannot enter coordinates in the section "project". They must be entered in seperate fields, reading them from there. Even if this works in the project of report (it does really), this is not the way, a user could enter datas in the formlar.

jstaniek wrote:
The text-field in the report gives the rows too much vertical distance.

Could you show a screenshot or explain more?

I'll send you a new link

jstaniek wrote:
And last, the combi-field in the formular reports nothing.

You can see how the Ownership form is constructed as an example in this project file: http://kde-files.org/content/show.php/S ... tent=23137

This link from April 2005 is an announcment for Kexi in KDE 3.3 ?

Thanks![/quote]
Cheers, Albrecht


alwi
User avatar awill
Registered Member
Posts
44
Karma
0
OS
it shows now the North Pole.
would you please controll my understanding if youl take a look in my database from 10:28? A link was sent.


alwi
User avatar jstaniek
Moderator
Posts
990
Karma
2
OS
@awill Please expect this in the evening.


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
User avatar awill
Registered Member
Posts
44
Karma
0
OS
Hi Jaroslaw,
Its all ok, works good enough for entering datas. In this way the map accepts all my 7 decimal digits!!

But following problems yet.
To secure the input in the table, i disabled the activity. Then the colours of the map are lost. If I disable the world-overview, it works in the design-view but not in the data-view.
A little bit problematical: If a record do not contain coordinats, the map shows the last picture. better to show 0;0 to avoid misunderstandings.

With your proposal of an table my thread about daynamic links is obolete.

I keep my file actual for you.


alwi
User avatar jstaniek
Moderator
Posts
990
Karma
2
OS
OK, I propose that you don't remove previous version of the files shared, but publish under new names, and use some way of versioning in the filenames. We need that for reference.


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
User avatar awill
Registered Member
Posts
44
Karma
0
OS
Is it possible to insert a drawing into the design-view? I would like to combine it with data-fields. A picture what I want is on my cloud.

I think this should be a new thread.


alwi
User avatar jstaniek
Moderator
Posts
990
Karma
2
OS


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help

 
Reply to topic

Bookmarks



Who is online

Registered users: Alexa [Bot], Baidu [Spider], Bing [Bot], cmb, Google [Bot], hsnnsnc, ostroffjh, thunder422