I’ve just started setting up the WP GOOGLE MAPS PRO PLUGIN
Your Plugin demands that the Latitude & Longitude values Must not have ” ” double quote marks around them or they will not be imported.
I am always going to be importing a thousand or more locations via CSV
But your Import script does not work with all of the different Export CSV options commonly offered with the popular tool PHP MyAdmin
Apparently this is the ONLY format that works with your Import Script–
“Zion Lutheran Church”,”1405 E Fallbrook St, Fallbrook, CA, United States”,33.3765,-117.23,Fallbrook,,”United States”,92028,,churches
I do not see the sense in “Postal Code” I never use empty spaces in column headings for sql.
NO SETTING from the MySQL online table that I use can produce commas in the Column Header BUT “quote marks” around “Postal Code” because it has an empty space
And then NO QUOTES around the Latitude and Longitude values in the same export CSV setting.
I have worked with databases online for over 15 years and php and mysql.
Your requirement is the most unusual choice that is making your script Import the hardest part of setting this up.
Choosing “Comma separated” or “Semi-colon” in your Import File Choice does not help the problem. Every possible variation PHP MyAdmin outputs which always work for my typical projects does not Satisfy your Import CSV file function.
I do NOT want to rely on a manual search-replace action to customize a simple CSV import script to your Program.
WHY did you make this Import Script unable to accept ,”46.6045571″,”13.8433325″, ?
If the script could import from an SQL there would be no problem.
I must change the import script to allow the quote marks around the Latitude & Longitude values