Mass Data Update - Revision history

Cody Gallagher at 15:13, 25 March 2020

2020-03-25T15:13:25Z

Cody Gallagher at 17:49, 19 December 2019

2019-12-19T17:49:07Z

Cody Gallagher at 14:44, 5 June 2019

2019-06-05T14:44:52Z

Cody Gallagher at 14:36, 5 June 2019

2019-06-05T14:36:50Z

Cody Gallagher at 22:06, 4 June 2019

2019-06-04T22:06:55Z

Cody Gallagher: Created blank page

2019-06-04T18:04:19Z

Created blank page

New page

@@ Line 1: / Line 1: @@
 Similar to '''[[Mass Edit]]''' this data update tool is designed to take in file information and apply the info to PRAMS.
 ----
 In order for this module to work a Excel data file is needed. It is paramount that the Site Identifier data, for the Update Item, be identical to what PRAMS has stored.

← Older revision		Revision as of 17:49, 19 December 2019
Line 75:		Line 75:


−	Copyright © ~~2019~~ by PRAMS Plus LLC. All Rights Reserved.	+	Copyright © {{CURRENTYEAR}} by PRAMS Plus LLC. All Rights Reserved.

← Older revision		Revision as of 14:44, 5 June 2019
Line 67:		Line 67:
	[[File:Mass data update completion.png\|border\|600px]]		[[File:Mass data update completion.png\|border\|600px]]

		+	>Once complete modify the update file to show NRI in column two and repeat the process.

@@ Line 12: / Line 12: @@
 In order to prep the data file for the update the first step is to choose a Site Identifier. It is recommended to chose a consistent variable such as
 [[User_Ref]], [[Site Name]], or [[API]].
 Using '''[[QueryX2]]''' to pull this info for all wells can be done with the following syntax:[[File:Query syntax Mass Edit.png|border|For more info visit the query page]]
 This will return all database information in the '''Site''' table. This will contain a substantial amount of columns so its recommended to cut and paste from this export.
-If you have the Site Identifiers place them as the first column in the file that will be used for the update. This will be known later as the '''Site Xref'''.
+>Prep the update file by having User_Ref in column one and then WI in column two, then save. Remember the process only looks at two columns at a time.
-Once you have the first Site Identifier complete the second column will be the '''Update Item'''. This will be the update data that will replace the old data in PRAMS.
+>Load the update file that was saved by selecting the folder icon on the third line.
-''EXAMPLE: Updating existing and missing '''NRI'''(Net Revenue Interest) and '''WI'''(Working Interest).''
+>If there are no issues select update data.
-For the Site Identifier, User_Ref will be used.
+>Result:

← Older revision	Revision as of 22:06, 4 June 2019
Line 1:	Line 1:
	+	Similar to '''[[Mass Edit]]''' this data update tool is designed to take in file information and apply the info to PRAMS.
	+	----

	+	In order for this module to work a Excel data file is needed. It is paramount that the Site Identifier data, for the Update Item, be identical to what PRAMS has stored.
	+
	+	The Excel file can contain multiple columns of info, but the module will only look at the first two. The file then can be modified by moving around columns if you have multiple changes to be made.
	+
	+
	+	<u>'''Prepping the Data File'''</u>
	+	[[File:Mass edit site identifier.png\|right\|frame\|Site Identifiers]][[File:Mass edit Update Item.png\|right\|frame\|Update Items]]
	+
	+	In order to prep the data file for the update the first step is to choose a Site Identifier. It is recommended to chose a consistent variable such as
	+	[[User_Ref]], [[Site Name]], or [[API]].
	+
	+	Using '''[[QueryX2]]''' to pull this info for all wells can be done with the following syntax:[[File:Query syntax Mass Edit.png\|border\|For more info visit the query page]]
	+
	+	This will return all database information in the '''Site''' table. This will contain a substantial amount of columns so its recommended to cut and paste from this export.
	+
	+	If you have the Site Identifiers place them as the first column in the file that will be used for the update. This will be known later as the '''Site Xref'''.
	+
	+	Once you have the first Site Identifier complete the second column will be the '''Update Item'''. This will be the update data that will replace the old data in PRAMS.
	+
	+
	+	''EXAMPLE: Updating existing and missing '''NRI'''(Net Revenue Interest) and '''WI'''(Working Interest).''
	+
	+	For the Site Identifier, User_Ref will be used.
	+
	+
	+
	+
	+
	+
	+
	+	Copyright © 2019 by PRAMS Plus LLC. All Rights Reserved.