-
Login as a guest.
This is the default login state of the application. Regardless if you are a registered user or never visited before, the login as a guest offers you full access to process geolocation data. The system is already set up for you to log in as a guest.
There is no logout if you are logged in as a guest.
-
Login, Logout as registered user.
There are two ways that you can log in as a registered user. The first way is to enter user email and password. Click on the Guest link and supply registered already email and password.
The second way is to click on a link inside an email with processed job sent to your registered email account. The system will automatically log you in with proper credentials. To log out, simply click on user link and select log out.
-
Upload data
The user can upload data from a local device - cell phone, iPad, PC, laptop, etc... also, the user also can upload data from the cloud if local device is connected to the cloud and offers upload capabilities. To upload data, the user drags and drops a file inside the designated file upload area or clicks on that area and then navigates to the desired file and selects the file.
-
File type and size
Csv2geo.com accepts only comma separated value type files . We limit the size of the file to 100 MB, as large files take an hour or more to process live data. For example, a voter file may consist of more than 100 columns per row, where 100 Mb file will consist of about 300,000 records.
-
Upload from source
The user is liberated to upload the data file from any location granted by the device the user is using. For example, iPad or cell phone user may decide to use iCloud or similar cloud storage directly.
-
File properties
After successfully uploading the data file, the following file properties are displayed: - Name of the file, including the CSV extension - Size of the file in bytes - Number of rows in the file.
-
Set up map address fields
Geographical address is a complicated structure and over time nearly everyone takes it for granted. For example, just the street number may occasionally have 4-5 parts. Street name every so often may consist of 5-6 parts. At csv2geo.com, we look it differently. We separate an address into six major components (tokens) and give the user the ability to associate on the fly one or more file columns to single address token. One of the reasons geodata manipulation is expensive since the majority of the competitor tools will require either flat file template that restricts user of what input data to load or awfully inefficient file manipulation.
In csv2geo.com you can specify the following combinations:
country if omitted is consider USA- street number, street name,city,state,zip, country
- street number, street name, city, state
- street,city,state (street will include the number as one column)
- zip
- zip,country(uses postal code instead of zip)
- street
- etc...
-
File header
The user has the ability at every point while setting up map address fields to clear the selection by pressing Clear address button.
-
Address components(tokens)
-
Street Number
The street number can consist of several parts that form the street number fully. For example, a street number can consist of and not limited to;
- - house number character - an alpha prefix to house
- - Resident street number - actual street number
- - House suffix
-
Street Name
This segment indicates the general street name.Street name can consist of several parts listed below, and not limited to:
- - Pre-direction - N, S, NE, etc...
- - Street name
- - Street Type - Ave, St, RD, etc...
- - Suffix direction - N, S, NE, etc...
- - Residence extension: lot #, app #, etc...
-
City Name
City name can consist of one or more words, often in separate columns in the input file
-
State Name
This segment indicates state name, province, or similar territory.
-
Zip Code
Zip indicates Zone Improvement Plan code number or postal number outside of USA
-
Country
Country or region that indicates a distinct area in political geography. If a country is omitted from selection, United States is used by default.
-
Select address tokens from uploaded file columns
When imported to csv2geo.com, a letter driven header is added on the top of the imported file data that will be used to mark selection inside address token segments.
The user can select zero, one or more columns from the imported file to map to one of the six map filed address segments.
For example, a file that has a column with the following data:
To make the selection, use the tiny pointing down triangle type arrow.
On the example for column J we might notice that street number and street name are combined into one column. Therefore, the user can decide to select under the columns both, the street number, and street name or just street using the tiny arrow in the right corner of the column. The system will indicate the user's choice by adding street number and street token under column J to indicate the selection. Also, column J label is placed under two address token - Street number and Street name.
Regardless of whether the order of checks, user's choice are always ordered left to right.
For example selecting street number and street name will be street number first and street name second.
-
Deselect address token selection
Similar to selecting the address token, in reverse order, the user may decide to deselect already selected columns in the address tokens. To do that, the user simply traces the letter from address token segment to which column represents in the data file and using the tiny arrow un-checks the selection.
-
Process data
In order for the service to process imported data, a minimal valid address compilation must be selected by the user.For US, that could be just a zip file.
If you select street, then you would need to select at a minimum, the city and zip code in order to process the data. A green button labeled Process appears.The Example shows a minimal selection of just a zip code.
Process fileClicking on Process button will process the first ten addresses and compile and display their geolocation. The data will be added to the right of the last column of the file inside the grid.
Also, by default all non-selected columns from file data will be hidden. Only columns that were part of geolocation calculation will be shown. The user may decide to see all columns by checking Show all columns check box
The User could verify the accuracy of calculating data before buying it by examining the first ten rows.
Clicking on the buy button will trigger one of the two events:
-
Buy data as already logged in user
In case when the user is already logged in, PayPal/Credit Card payment page will be open, and the user has to fill the mandatory data to complete the purchase.
-
Buy records as guest or non logged in user
Buy records as guest or non-logged in user. In case the user was never registered in the system, or currently is logged out, simply fill the open text box with your email and agree to the company policy and terms of services by checking the check box under the email entry.
-
Notification email to complete purchase
Finally, after submitting the email address and agreeing to the license, the user should receive an email on the email address that was supplied.
The email contains a direct link to Working History page where the purchase needs to be finalized.
Work History page is where the user can buy the actual data and download the desired result. There are two ways to navigate to that page.
-
Navigate to Work History using email
Clicking on the email link from your email you received after submitting desire to buy records will bring you to Work History page.
-
Navigate to Work History by log in
Click on Guest link and enter your email and password
Records via file are available to buy the moment the user sees the buy button
Buy
Inside Work history page the user can pay to obtain the calculated geocoding results.
There are two ways currently the user can pay:
-
Pay by credit card
By clicking on the Credit card button the user navigates to the credit card payment page. Csv2geo.com does not store credit card information. Also, csv2geo.com rely on PayPal to handle security and maintenance of the credit card payment process.
-
Pay directly by PayPal
By clicking on PayPal card button, the user navigates to the PayPal payment page.
After successful payment, csv2geo.com starts to process the data. Depends on the size of the file it may take minutes to hours. The user can see the progress inside the Work history page. When the process is completed, the user will receive an email with a link to download the file. Also, inside Work history page the records will be available for download via a download button.
In order to create interactive map you must first geocode your data. After you successfully geocode your data and verify it inside your work history account, then click Map it button next to 
download in order to start creating the map.
The map will load initially with some predefined settings that you can change.
Markers maybe grouped together and by zooming in they will show in more details.
On the left is the menu settings.
Group by column value segment of menu represent the ability to group map markers via any of the column headers from file you uploaded for geocoding.
The system will automatically select each group with different color. In the example above the column header city was selected. Any unique value from that column received different color.
Map Markers
Map Markers setting from the menu gives the ability to set up each of the values from the grouped column with icon chosen from preloaded library
and filter these markers out of the map if needed.
Settings
Logo
Under the general settings you can load your own logo instead of Scale Campaign logo.
Access
Then you can define how maps will be accessed. Csv2geo provides four different ways of sharing and accessing maps:
- Public Map - available to everyone
- Hidden URl Map - available only to users who have access to the URL
- Access to provisioned users only - available only to registered and provisioned users with csv2geo.com
- password protected map - available only to users who know the password
Map Circle
You can set up double circle around chosen value.
Map Style
You can choose from preloaded map styles by clicking on the map button in the top right corner
Sharing map
You can print/share map by clicking on share button in the right top corner
}
