bkreuzinger
Forum Replies Created
-
Hi Peter,
oh yeah, I forget to go to this settings 😉
Perfect, – it’s a success !!!
I’m excited 👍✔✌
It’s a great tool. I wish you, your team and the whole community the very best for the future. It may hear from me again. I think I will use wp data access further on and I may have a problem again. Perhaps I can help someone in the future, too…
Best regards,
Berndp.s.
Do you have a detailed document about the syntax etc. of wp data access?Thank you both very much.
I can use the concat url in the view in data explorer to get the position in openstreetmap.
Thanks a lot.But I have another problem:
How can I show this view in a Website and not only in data explorer?
My target is to show (not to edit) the view in my custom website.
I can’t show the correct view (with the concat link) in data publisher, to get a publishing shortcode. There I can always choose only my table..
Should I open another support topic?Best regards,
Bernd@gypsy-bytes thank you.
Perhaps it may be the blank new line at the end.
After another try I was successful and I see the view in data explorer 🙂
But the url column in the view has no data.
I have to research more…Is it possible to insert an image in a message exept with an link from above?
Hi Peter,
I have tried to get this.
My create view script:
create view bk_weg_view as select weg_bezeichnung, concat('{"label:osm_link","url":"http://www.openstreetmap.org/?mlat=',start_gps_breite,'&mlon=',start_gps_laenge,'&zoom=15&layers=M","target":"_blank"}') AS url from bk_weg;I had to add the key name
ASbefore url in the concat line and then I get the messageINFO: Importbk_weg_view1.sqlcompleted succesfully
But where can I find the view for the other settings in your thread?
In the data explorer I only find my table (with type “base table”) but not this view.Is there a documentation of the “wp data access” syntax and statements?
The mysql syntax is a little different.Thank you very much.
Best regards,
BerndOh yes, this is a table with a misleading name. Until now it is all a test environment…
The concat row in the thread before is not correct:
The http-string ends with an =,CONCAT('http://www.openstreetmap.org/?mlat=',W.start_gps_breite,'&mlon=',W.start_gps_laenge,'&zoom=15&layers=M') AS osm_linkI have only a simple table with 7 columns:
Column Name
weg_id
weg_bezeichnung
start_gps_breite
start_gps_laenge
end_gps_breite
end_gps_laenge
nlp_bereichMy create view statement comes with error message:
ERROR: Importwege_view.sqlfailed [check import file]
Here is my script:CREATE VIEW bk_weg_view AS
SELECT W.weg_bezeichnung
,W.nlp_bereich
,CONCAT(‘http://www.openstreetmap.org/?mlat=’,W.start_gps_breite,’&mlon=’,W.start_gps_laenge,’&zoom=15&layers=M’) AS osm_link
,W.start_gps_breite
,W.start_gps_laenge
,W.end_gps_breite
,W.end_gps_laenge
FROM bk_weg_db AS W;I have already tried several variations without success..
Thank you.
I will try this. This could be the solution.
Where can I look for the syntax of the sql statements?
It seems there is a difference between wp data access and mysql syntax, or?
– https://www.mysqltutorial.org/mysql-views-tutorial.aspx
Thank you and best regards.Hi Melody,
oh, to write a little SQL Code should not be the problem.
I was a programmer in my first job.
Now I’am coding in Windows powershell, some other scripting and SQL Scripting is not strange to me.
I am new in “wp data access” plugin and I don’t know where I have to create the view (Data Explorer, Designer, Projects, Publisher) and where to place the sql select statement or query in this view.
Please give me a tipp…
Thank you.
Kind regards,
BerndHi Melody, hi Peter,
thank you for your rapid feedback.
What do you mean with “create a view” and “in the select statement to create the fields you need” there?
Where can I do that in the plugin area?
I only started working with “wp data access” yesterday and and I am not an expert yet 😉
I have an idea in a very simple table and it would be great i can get a solution…Thank you and kind regards,
Bernd