For Users
This is a documentation for users who use this app to edit the project's database.
Go to localhost/admin, and you will need username and password to log in. Ask us to create an account for you if you do not have one.
After login, you will see the homepage of our admin interface similar to this:
Now you are good to go!
You are allowed to import CSV files to the following models so far:
- Contacts
- Locations
- Locations(NCUA)
- NCUA
- NCUA (edit)
- Organizations
After you click each model, you will see a page similar to this, and clicking the IMPORT button on the upper-right corner takes you to the import interface:
The importer has a strict requirement for the formatting of the importing file's headers; usually, they should be named exactly as the fields indicate:
Here are the sample formats for some models (all saved as CSV):
After choosing the file and picking the right format, clicking SUBMIT will lead you to the preview page (Notes: even though there are a few options for the format, CSV is working best for our importer. And we suggest try not to use Microsoft Excel to convert CSV format, because sometimes it gets some small error when doing the conversion):
The preview page looks like this, and the first column of the table indicates the status (new, update, skipped, or delete) of each importing row:
For Locations & Locations(NCUA) models, rows are skipped when their information is already in the database and do not have any difference than the database except for the last column geographic_location. And you might find out that the in your CSV file you do not have any values for this column, but on the preview, you get something like "SRID=4326;POINT (-75.305656 40.0093478)". It is because our importer extracts the address information of each row when you import the CSV file, and generates the geographic coordinates like this to display the locations on the map. Because we are charged every time when we produce a new geographic pair, as long as other information does not change, we skip the row from our geocoding process. So don't get nervous when you see a red highlight when the status is skipped. You are fine!
- Other important notes*: all changes will be made only when you click the button
CONFIRM IMPORT. Don't worry if you do something wrong before it.
After you click CONFIRM IMPORT, you will see a success message in green!
Open one of the objects you just import, you will see all information are there, and for Locations and Locations(NCUA), you see a point on the map corresponding to the address.
