Thanks, Option B was sounding great until we got to the licenses and the
learning curve for maintaining your own host.
I might just be better off doing what I'm doing and biting the bullet and
learning how to get my data into mysql reliably as that is my bottleneck
(all data files come from a spreadsheet, that I load into open office calc
and save as a dbf and then I add the longitude, latitude in VFP and create
the SQL Insert statement (i find different types of garbage and what
happens now is when I find a problem that I haven't run across before, I
need to repeat the process and update my VFP code that creates the sql
statment)
What I'm doing is creating one of these google maps for all major job
occupations (google BLS OES)
The links work - if not, you can find it here
http://keepamericaatwork.com/give-me-a-map-for-2014-showing-all-h-1b-applications-in-america/
)
- 11 – Management Occupations Map
<http://keepamericaatwork.com/map_11.html>
- 13 – Business and Financial Operations Occupations Map
<http://keepamericaatwork.com/map_13.html>
- 15 – Computer and Mathematical Occupations (lot of data, wait for it
to load)
- WA, OR, CA, ID, UT, CO, NV, & AZ Map
<http://keepamericaatwork.com/map_computer_westcoast.html>
- MT, WY, ND, SD, MN, IA, WI & IL Map
<http://keepamericaatwork.com/map_computer_northwest.html>
- NM, KS, TX, OK, MO, AR, LA & NB Map
<http://keepamericaatwork.com/map_computer_southcentral.html>
- MS, AL, GA, FL, SC, NC, TN & KY Map
<http://keepamericaatwork.com/map_computer_southeast.html>
- ME, NH, VT, NY, NJ, CT, PA & MA Map
<http://keepamericaatwork.com/map_computer_northeast.html>
- MD, DE, IN, MI, OH, WV, VA & RI Map
<http://keepamericaatwork.com/map_computer_remaining.html>
- 17 – Architecture and Engineering Map
<http://keepamericaatwork.com/map_17.html>
- 19 – Life, Physical and Social Science Map
<http://keepamericaatwork.com/map_19.html>
- 21 - Community and Social Service Organizations Map
<http://keepamericaatwork.com/map_21.html>
- 23 – Legal Occupations Map <http://keepamericaatwork.com/map_23.html>
- 25 – Education, Training & Library
<http://keepamericaatwork.com/map_25.html>
- 27 – Arts, Design, Media, Sports & Entertainment
<http://keepamericaatwork.com/map_27.html>
- 29 – Healthcare Practitioners and Technical
<http://keepamericaatwork.com/map_29.html>
- 31 – Healthcare Support <http://keepamericaatwork.com/map_31.html>
- 33 – Protective Services <http://keepamericaatwork.com/map_33.html>
- 35 – Food Preparation and Serving Related
<http://keepamericaatwork.com/map_35.html>
- 37 – Building and Ground Cleaning and Maintenance
<http://keepamericaatwork.com/map_37.html>
- 39 – Personal Care and Service
<http://keepamericaatwork.com/map_39.html>
I have about 10 more left to do on this before I'm finished.
I also am doing it on a company basis
- Infosys <http://keepamericaatwork.com/map_infosys.html>
- Microsoft <http://keepamericaatwork.com/map_microsoft.html>
- IBM <http://keepamericaatwork.com/map_ibm.html>
- Google <http://keepamericaatwork.com/map_google.html>
- Baltimore <http://keepamericaatwork.com/map_baltimore.html>
- WIPRO <http://keepamericaatwork.com/map_wipro.html>
After I finish all of these, and I'm probably looking at months, I want to
do a per job type map using numbers like these that I found on BLS OES, and
ultimately I need to make it data driven as right now, I simply change the
SQL select statement and the map remains the same, although I give it a
different name for each map (not the way I would normally do it, but it is
what it is for now.)
31-0000Healthcare Support Occupations
<http://www.bls.gov/oes/current/oes310000.htm>major3,924,3900.4%29.598$12.54
$13.61$28,3000.2%31-1010Nursing, Psychiatric, and Home Health Aidesbroad
2,361,9100.5%17.814$11.22$11.87$24,7000.3%31-1011Home Health Aides
<http://www.bls.gov/oes/current/oes311011.htm>detail806,7101.2%6.084$10.10
$10.60$22,0500.4%31-1013Psychiatric Aides
<http://www.bls.gov/oes/current/oes311013.htm>detail75,3402.1%0.568$12.08
$12.98$26,9901.2%31-1014Nursing Assistants
<http://www.bls.gov/oes/current/oes311014.htm>detail1,427,8300.5%10.769
$11.97$12.51$26,0200.2%31-1015Orderlies
<http://www.bls.gov/oes/current/oes311015.htm>detail52,0302.4%0.392$11.75
$12.66$26,3400.6%31-2000Occupational Therapy and Physical Therapist
Assistants and
Aidesminor160,4301.2%1.210$20.80$21.19$44,0800.6%31-2010Occupational
Therapy Assistants and Aidesbroad39,1602.4%0.295$24.16$23.75$49,3901.3%
31-2011Occupational Therapy Assistants
<http://www.bls.gov/oes/current/oes312011.htm>detail30,4502.0%0.230$26.57
$26.56$55,2500.8%31-2012Occupational Therapy Aides
<http://www.bls.gov/oes/current/oes312012.htm>detail8,7108.2%0.066$12.67
$13.90$28,9002.5%31-2020Physical Therapist Assistants and Aidesbroad121,270
1.2%0.915$19.43$20.37$42,3600.5%31-2021Physical Therapist Assistants
<http://www.bls.gov/oes/current/oes312021.htm>detail72,6401.4%0.548$25.65
$25.63$53,3200.5%31-2022Physical Therapist Aides
<http://www.bls.gov/oes/current/oes312022.htm>detail48,6302.0%0.367$11.69
$12.50$25,9900.6%31-9000Other Healthcare Support Occupationsminor1,402,060
0.5%10.574$14.92$15.66$32,5700.2%31-9011Massage Therapists
<http://www.bls.gov/oes/current/oes319011.htm>detail79,0403.0%0.596$17.27
$19.42$40,4001.1%31-9090Miscellaneous Healthcare Support Occupationsbroad
1,323,0100.5%9.978$14.83$15.44$32,1100.2%31-9091Dental Assistants
<http://www.bls.gov/oes/current/oes319091.htm>detail309,5400.9%2.335$16.78
$17.13$35,6400.4%31-9092Medical Assistants
<http://www.bls.gov/oes/current/oes319092.htm>detail571,6900.8%4.312$14.24
$14.80$30,7800.3%31-9093Medical Equipment Preparers
<http://www.bls.gov/oes/current/oes319093.htm>detail51,3001.5%0.387$15.25
$16.02$33,3200.4%31-9094Medical Transcriptionists
<http://www.bls.gov/oes/current/oes319094.htm>detail68,3502.0%0.516$16.63
$16.95$35,2600.5%31-9095Pharmacy Aides
<http://www.bls.gov/oes/current/oes319095.htm>detail42,2503.9%0.319$10.85
$11.78$24,5100.9%31-9096Veterinary Assistants and Laboratory Animal
Caretakers <http://www.bls.gov/oes/current/oes319096.htm>detail71,8002.3%
0.542$11.32$12.07$25,1100.7%31-9097Phlebotomists
<http://www.bls.gov/oes/current/oes319097.htm>detail108,2101.6%0.816$14.50
$15.10$31,4100.4%31-9099Healthcare Support Workers, All Other
<http://www.bls.gov/oes/current/oes319099.htm>detail99,8801.9%0.753$16.42
$16.80$34,9500.4%
On Thu, Jan 29, 2015 at 9:13 AM, Kevin Cully <kcu...@cullytechnologies.com>
wrote:
Hello Virgil,
I think there are three ways to go to keep this on the cheap: [A] VPS [B]
Vultr.com or [C] Brute force VFP
[A] For inexpensive VFP and Windows hosting, there are many companies that
provide Virtual Private Server (VPS) support. They typically start at $25
per month. This will get you a Windows Server with IIS and you can load VFP
executables where you can run West-Wind or AFP or something in between. The
downside is that it truly is a "shared" server so performance will suffer
as the load grows by other users being added to that server. Basically,
your site can slow down because other people are hogging the CPU and other
resources.
[B] I recently stumbled upon a company called Vultr.com. They offer server
hosting but what makes them different is that you can upload a Windows
Server ISO and create your own Windows + VFP solution. I've used them for
Linux hosting and the performance on their "All SSD" server farm is
amazing. Prices start at $5 per month, but you'd need your own license of
a Windows server, and you would need to install and maintain your own
firewall, patches etc. You are on your own with this configuration and
that'd be pretty scary to me for a Windows solution.
[C] I'm not really clear on what your end result is but what about using
VFP locally on your PC or laptop to crank out HTML or PHP pages? You can
then programmatically FTP (curl or Sweet Potato's FTP FLL) to upload those
files to a cheap Linux hosting. For searching, you can embed the Google
search of your site. The downside is that the site is pretty 'static' but
the price is right.
I'll cheat and throw in an option [D] here and suggest that you download a
free copy of Xojo from http://xojo.com. You can get started building web
applications that are very much like building a VFP desktop application and
use a very VFP application mindset. If you decide to deploy the application
(build an app using the "alone alone" target for Linux) that is when you
would need to purchase a license. Write both your VFP app and the Xojo app
to access the same MySQL databases. I've tested deploying a Xojo app to
Vultr.com and DigitalOcean.com for their starting $5 per month cost and it
seems to work well for the short time I was testing it.
Good luck,
Kevin
CULLY Technologies, LLC
678-929-7762
http://cullytechnologies.com
http://cully.biz
On 01/29/2015 09:35 AM, Virgil Bierschwale wrote:
Does something like that exist?
I need to add data files from 02 till 15 for my maps and I'm running into
lots of garbage in the data which consumes an enormous amount of time
because of my inexperience with mysql, php, etc. and I could do it in
seconds using vfp.
I have found that I can enable a remote host (as long as it is on the
internet, static ip, etc)
What I'm thinking about is moving the data to a vfp host, doing all my
preprocessing there and then doing a insert into the mysql table, or maybe
even doing it all on a vfp box/host.
Normally time would not be an issue but I'm getting more and more demands
for my maps from various organizations and after being without work for so
long, I like demand.
Now if I can just figure out how to monetize it <g>
Thanks,
Virgil
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
