HJB 7/18/2017 | |
https://xlinesoft.com/phprunner/docs/_view_as__settings_map.htm (ex v9.7 manual) |
HJB 7/20/2017 | |
John, how far? Look, I had been killing precious time on map issues longer time ago in regard to BING, GOOGLE and OPENSTREETMAP and while the import of GPS data is just in second row, your clients may want to make use of filtered maps under dashboard technology, of course with several different icons per map location and of course want to enjoy to see the map descriptions in their own language too (tested several handling menu languages and it workd fine), say, I found the best solution for me to collect product demands per region, to display the nearest distributor and his contact address plus of course a summary on the bottom line of regional actual or pending orders per item to let the web page viewer a fully transparent picture of volumes, amounts, in short, what counts in product and service marketing. I have to admit, it is hard to sell such mapped filtering, yet thanks to bootstrap and responsiveness, marketing is going to become a real fun (at least for me). |
lefty author 7/21/2017 | |
John, how far? Look, I had been killing precious time on map issues longer time ago in regard to BING, GOOGLE and OPENSTREETMAP and while the import of GPS data is just in second row, your clients may want to make use of filtered maps under dashboard technology, of course with several different icons per map location and of course want to enjoy to see the map descriptions in their own language too (tested several handling menu languages and it workd fine), say, I found the best solution for me to collect product demands per region, to display the nearest distributor and his contact address plus of course a summary on the bottom line of regional actual or pending orders per item to let the web page viewer a fully transparent picture of volumes, amounts, in short, what counts in product and service marketing. I have to admit, it is hard to sell such mapped filtering, yet thanks to bootstrap and responsiveness, marketing is going to become a real fun (at least for me).
|
HJB 7/21/2017 | |
John, 1st some basics: Either you drop LNG/DAT manually or by import under unchecked UPDATE hook in the map properties (which practically means, the Google API won't look for map icon address detail at all and as well means, those now free address fields can now server for any text string you want to see there to popup in the map) or you use checked UPDATE HOOK (which practically means, the Google API is doing the update in accordance with what is seen as per address details, once UPDATE is unchecked, you can use such fields to drop anything you want to see by popup in tzhe map in such fields). |
lefty author 7/22/2017 | |
John, 1st some basics: Either you drop LNG/DAT manually or by import under unchecked UPDATE hook in the map properties (which practically means, the Google API won't look for map icon address detail at all and as well means, those now free address fields can now server for any text string you want to see there to popup in the map) or you use checked UPDATE HOOK (which practically means, the Google API is doing the update in accordance with what is seen as per address details, once UPDATE is unchecked, you can use such fields to drop anything you want to see by popup in tzhe map in such fields). Further, in regard to regular updates of the map details, it is recommendable to avoid differences between your client ID data and what is dumped inside the map details. Say for example, you get new clients, other clients go, so you client DB is changing regularly while it could happen then, you are listing client IDs in the map which are no longer in existence any longer or you need to add (update) new ones, leading to trouble by means of non-actualized data being mapped. These days, I mean by registration page on user to drop their details first to finally be awarded a login and password after the registration page, I would recommend to add LNG/LAT fields to the user table. By the way, http://www.mapcoordinates.net/en is a useful tool for clients to add their own LAT/LNG data into e.g. a registration page then. Anyway, now you can grab the client DB originating LAT/LNG into the map by means of AUTO-FILL feature, same refers of course to client ID and name to later popup in the map. Earlier Sergey and his developer team had been as well presenting an online demo where one could see SEVERAL icons per one map location, visually indicating by optical of what else services or classifications of all kinds, just fyi in regard to improvements on the map later on. As the map viewer is usually knowing his own map location, such map viewer needs to center himself in the map by mouse to see what is the nearest next map icon to his own location. Now to the two different terms named IMPORT and UPDATE which are to different kind of shoes anyway. It is my understanding that the CSV import feature under PHPR is only touching the term IMPORT, but not UPDATE. So, whatever you try to code manually, PHPR's import functionality is NOT updating, but just importing data. There are numerous methods out there to convert CSV import data into SQL (e.g. http://www.convertcs.../csv-to-sql.htm ) to then make either use of PHPmyADMIN update feature then or to use other MySQL software (partially available as even freeware) to run the UPDATE. I personally prefer to run maps in dashboards, say, the map on the left, and client ID etc pp in a table seen on the right (see demo under: https://www.xlinesof...p_dashboard.php ) and with some amendments on the table, even things like SUM, COUNT, AVERAGE can appear on the bottom line too, plus of course clickable e-mail addresses or URLs while you know, the PHPR built-in features are endless. Finally, I prefer BING rather than GOOGLE as it came to light that only BING supports PHPR's built-in handling menu language options, say, for example, you would own a golf client in China, using the Chinese handling menu language then by linkn or dropdown on your web apppliance, very same would see the map descriptions in CHINESE too (like e.g. ocean names etc pp) while the Google map does not.
|
HJB 7/23/2017 | |
https://stackoverflow.com/questions/9472562/csv-import-to-mysql-for-update |
lefty author 7/23/2017 | |
https://stackoverflo...ysql-for-update ... for inspiration purposes only ..., there are tons of other ways to update MySQL data anyway. Some weeks ago there was a query on this forum on how to update, say, there are regions on this plant where the Internet is not present all the time, so, that very PHPRunner is using the built-in offline option of PHPR and once the Internet is getting back, the synchronization of the offline data with what had been already online in the database has to happen then.
|
HJB 7/24/2017 | |
https://xlinesoft.com/phprunner/docs/export_import_pages.htm
|
lefty author 7/24/2017 | |
https://xlinesoft.co...mport_pages.htm Quote excerpt PHPRunner adds the new records or updates the existing ones while importing. During import PHPRunner will try to insert a new record first. If insert fails for any reason like duplicate primary key it will try to locate and update this record with new data. It will update the existing records instead of adding them in the following case:
|