ProvisioningTool.zip is a .NET console tool for performing bulk provisioning of AQTS systems from CSV data files.
The tool works for AQTS 2018.4 or greater.
Installation
- Download the
ProvisioningTool.ziparchive - Extract the Zip archive to a new folder
- See the
SampleFilessubfolder for examples of different CSV data files. - Open a CMD.EXE, bash shell, or Powershell window to the folder, and run the commands.
See the wiki page for more details.
Change log
2024-May-29 - v3.0.206 - Digitally signed. Previous v3.0.176 was not signed.
2024-May-01 - v3.0.176 - Calulation Input Lag did not allow HH:mm:ss as per wiki. Day part now optional.
2023-Sep-19 - v3.0.120 - New feature: Timeseries note import and delete.
2023-Mar-28 - v3.0.70 - BugFix: Update ReferencePointPeriod would only update the first one in the csv file if periods are of the same start time.
2022-Aug-26 - v3.0.40 - BugFix: LocationNote updates would lose any TimeSeries reference. Added EXPORT option for LocationNote.
2022-Aug-24 - v3.0.28 - BugFix: DerivedSeries: Calculation rows now ignore blank columns at the end of the row
2022-Aug-23 - v3.0.25 - BugFix: DerivedSeries: DatumConversion plans now correctly read an empty Source field as "location local assumed datum"
2022-Aug-22 - v3.0.21 - BugFix: DerivedSeries: DatumConversion plans are now exported with the ReferencePoint name, not the internal database ID
2022-Aug-19 - v3.0.19 - BugFix: DerivedSeries: "Unknown" values for computation period and type are now silently ingored on read and are never written to CSV.
2022-Aug-18 - v3.0.17 - BugFix: Exported CSVs now contain UTF-8 byte order marks, so the open correctly in Excel. Picklist tag values now support multiple list item assignment.
2022-Aug-17 - v3.0.13 - BugFix: DerivedSeries exports are now sorted by location, parameter, and label, and calc-derived time-lags of >1day are supported.
2022-Jun-28 - v2.0.998 - BugFix: DerivedSeries calculation time-lags are now correctly applied.
2022-Jun-23 - v2.0.994 - Exported CSVs no longer have a space after each comma for better compatibility with the CSV ecosystem.
2022-Jun-21 - v2.0.992 - Tags and extended attribute values are now exported for locations and tie-series in a predictable order
2022-Jun-02 - v2.0.974 - Improved timing output of some long-running tasks
2022-May-31 - v2.0.967 - Fixed some EXPORT TimeSeries edge cases
2022-May-27 - v2.0.960 - Fixed some DerivedSeries edge cases
2022-May-25 - v2.0.955 - Added DerivedSeries support
2022-Apr-29 - v2.0.908 - Added ComputationType and ComputationPeriod support.
2022-Apr-28 - v2.0.900 - Added EXPORT support for LocationFolder. Fixed a few edge case bugs in tag, extended attribute, and global setting exports
2022-Apr-26 - v2.0.893 - Added EXPORT support for Tag, ExtendedAttribute, and GlobalSetting categories
2022-Apr-25 - v2.0.887 - Added EXPORT support for Approval levels.
2022-Apr-22 - v2.0.882 - Added EXPORT support for Parameter, Unit, UnitGroup, LocationType, Location, TimeSeries, Grade, Qualifier, MnitoringMethod
2022-Mar-14 - v2.0.805 - Bugfix for the LOCATION task. Works with 2021.3-systems that only have new-style location type extended attributes configured.
2022-Mar-11 - v2.0.799 - Bugfix for the LOCATION task. Empty values for lat/long/elevation are now supported. Empty extended attribute and
2022-Mar-02 - v2.0.789 - Added "Ext:" and "Tag:" column support for the LOCATION task. Removed obsolete LocationTag and LocationExtendedAttributes support.
2022-Feb-03 - v2.0.780 - Support the AppliesToAttachments and AppliesToReports tag scope
2022-Jan-25 - v2.0.777 - Bugfix for the "UPDATE RepairTimeSeries" task, to improve moving series to another location
2021-Sep-22 - v2.0.614 - Bugfix for the "UPDATE RepairTimeSeries" task, to allow changing a time-series unit ID
2021-Jun-25 - v2.0.565 - Support AQTS 2021.x systems (the UPDATE LOCATION and UPDATE TIMESERIES tasks were failing)
2021-Jun-23 - v2.0.562 - Bugfix for the "UPDATE TimeSeries" task, to allow matching by UniqueId
2021-Apr-22 - v2.0.533 - Bugfix for the "UPDATE Sensor" tasks, for improved matching of existing sensors
2021-Apr-14 - v2.0.518 - Bugfix for the Location tasks to work with AQTS 2020.4 systems with more than 100 locations
2021-Mar-12 - v2.0.500 - ProvisioningTool.exe is now code-signed, for simpler distribution.
2021-Mar-08 - v2.0.478 - Added "UPDATE RepairTimeSeries" to change parameter/units/interpolation of basic time-series.
2020-Sep-20 - v2.0.339 - Minor fixes for the location and time-series extended attribute tasks, parameter task, and locationUserRole task.
2020-Aug-19 - v2.0.312 - Added LocationTag task
2020-Aug-10 - v2.0.295 - Added pick list location tag support for importing secondary folders. Added two related sample csv files.
2020-Jul-27 - v2.0.273 - Fixed the "UPDATE DatumReading" task to preserve each modified visit's approval level
2020-Jul-20 - v2.0.261 - Added the DatumReading task (UPDATE only)
2020-Jul-17 - v2.0.253 - Added LocationStandardDatum and LocalAssumedDatumPeriod tasks
2020-Jun-30 - v2.0.245 - Improved Excel file parsing logic
2020-Jun-12 - v2.0.238 - Improved error logging
2020-May-29 - v2.0.201 - Added support for renaming location identifiers and time-series labels in UPDATE tasks
2020-May-28 - v2.0.199 - Added support for Location.Publish provisioning
2020-Apr-24 - v2.0.108 - Changed the format of the TimeSeriesExtension and LocationExtension CSV files for easier use.
2020-Apr-06 - v2.0.89 - Update PanelCount task can now also set ADCP NumberOfTransects
2020-Mar-21 - v2.0.87 - Improved LocationNote provisioning
2020-Mar-18 - v2.0.71 - Added StandardDatum CREATE and DELETE tasks.
2020-Mar-16 - v2.0.70 - Fixed a bug in the UPDATE LOCATION task.
2020-Mar-12 - v2.0.69 - Improved extended attribute value provisioning
2020-Feb-26 - v2.0.39 - Fixed LocationNote task and added Tag provisioning tasks
2019-Dec-13 - v1.0.960 - Log the affected row count for ExtendedAttributeSchema SQL statements
2019-Oct-28 - v1.0.829 - More robust time-series creation logic
2019-Sep-04 - v1.0.735 - Added ReferencePoint and ReferencePointPeriod support
2019-Jul-08 - v1.0.629 - Added MeasurementGrade support
2019-Jun-10 - v1.0.572 - Added support for MonitoringMethods, LocationNotes, and ExtendedAttributeSchemas
2019-Feb-19 - v1.0.398 - Added the initial release of the tool