...
The file must be in CSV format.
The first column of the file must be Unit ID (unit_id). This column must include valid unit ids, so its values must be filled. In addition. each Id should have a single row (the same unit cannot be updated with 2 different rows).
Each field you wish to update must appear with its system name in the column headline (all the system names appear here).
Each value should much the field's type. The field can be of one of the following types:
Numeric - numeric fields cannot be empty. (points/commas?)
Date - must be in the following format: yyyy-mm-dd hh:mm:ss (hh:mm:ss are optional). date fields cannot be empty.
Textual - free text. Note that empty fields will override the existing value (delete it).
Boolean fields - valid values are "Yes" / "No". (case sensitive?)
...
Prepare the CSV file in accordance with the limitations listed above.
Open the Galooli Apps Manager solution and enter the “Grid Oracle” “My Units” menu.
Select "Load From File”Bulk Update”.
Upload the prepared CSV file
...
6. After the file has been uploaded, a validation process will begin:
If the unit ID isn’t valid the validation will fail. It may occur for one of the following reasons:
The user does not have permission to view the unit
The unit does not exist or has been removed from the organization
If the kWh value is < 0 the validation will fail.
...
file is not in CSV format or doesn't include "unit_id" in the first column, the file will not be uploaded.
If the column headline doesn't cantain a valid parameter name the headline will be colored in red.
If one of the rows contains an invalid value, the value will be colored in red.
7. Only after all values are valid (no red values in the table), you can save the settings of the units.
...
8. Following the successful upload process the user will receive an email from Galooli.
...
As soon as you click the link, you will be able to download a file containing information about the status of the upload process as well as the reasons for the failure.
(???)
...
File Loader Success and Error Messages (relevant?)
Success Result
The units have been updated and an email has been sent to the user
...