Difference between revisions of "Import"

From PRAMS Plus Wiki
Jump to navigation Jump to search
m (Monthly Data)
m (Sites)
Line 8: Line 8:
 
===<u>'''Sites'''</u>===
 
===<u>'''Sites'''</u>===
  
[https://wiki.pramsplus.com/w/images/c/c4/Site_Import_Specs.xlsx Site Import Specs.xlsx]
+
Download the template : [https://wiki.pramsplus.com/w/images/c/c4/Site_Import_Specs.xlsx Site Import Specs.xlsx]
 +
 
 +
To start the process upload a file that contains the template with the appropriate fields. Then select import and if it ran with no problems it will show that it has ran successfully.
 +
 
 +
If there are any issues it will show you what is problematic by referencing the cell with an @ symbol.
 +
 
 +
[[File:Tools - Import - Sites.png|border|300px]]
  
 
===<u>'''Forecasts'''</u>===
 
===<u>'''Forecasts'''</u>===

Revision as of 19:41, 29 January 2020

Import many different type of data and speed up the process of adding data to a project.


Start by opening AnalystX2 > Tools > Imports > Then select the type of import from the list below:

The available imports are as followed:

Sites

Download the template : Site Import Specs.xlsx

To start the process upload a file that contains the template with the appropriate fields. Then select import and if it ran with no problems it will show that it has ran successfully.

If there are any issues it will show you what is problematic by referencing the cell with an @ symbol.

Tools - Import - Sites.png

Forecasts

Forecast Import Specs.xlsx

Meters

Meter Import Specs.xlsx

Tanks

Tank Import Specs.xlsx

Gas Statements

Gas Statement Import.xlsx

Daily Data

Daily Data Import Specs.xlsx

Monthly Data

Monthly Data Import.xlsx