Information Systems:Updating PharmaCare alternatives data in Infonet - Revision history

Johnt at 22:22, 5 June 2017

2017-06-05T22:22:14Z

Norwinu: /* Expected file format */

2016-11-04T16:37:20Z

Expected file format

Norwinu at 16:35, 4 November 2016

2016-11-04T16:35:59Z

Norwinu at 17:11, 15 July 2016

2016-07-15T17:11:09Z

Norwinu: Norwinu moved page Information Systems:B.C. PharmaCare to Information Systems:Updating PharmaCare alternatives data in Infonet

2016-06-30T19:10:33Z

Norwinu moved page Information Systems:B.C. PharmaCare to Information Systems:Updating PharmaCare alternatives data in Infonet

Norwinu at 19:09, 30 June 2016

2016-06-30T19:09:58Z

New page

=Background=

PharmaCare makes information on Low Cost Alternatives and the Reference Drug Program available to be downloaded from their web site. They are updated on the first Thursday of each month. We display this information in Web Orders, and in item file maintenance and display.

The complete process for retrieving and updating these files is in InfoNet / Admin / Upload PharmaCare Info.

[[File:pharmacare-1.jpg]]

There are five steps in this process.

'''1 - Retrieve LCA spreadsheet from PharmaCare'''

Click here to open the current Low Cost Alternatives spreadsheet from PharmaCare's web site. Then save it to your PC as CSV (comma delimited).

'''2 - Retrieve RDP spreadsheet from PharmaCare'''

Click here to open the current Reference Drug Program spreadsheet from PharmaCare's web site. Then save it to your PC as CSV (comma delimited).

'''3 - Upload Low Cost Alternatives CSV file to the System i.'''

Click on 'Browse' to find and select the file you retrieved from PharmaCare. Select file type LCE, then click on 'Upload'.

'''4 - Upload Reference Drug Program CSV file to the System i.'''

Click on 'Browse' to find and select the file you retrieved from PharmaCare. Select file type RDP, then click on 'Upload'.

'''5 - Update PharmaCare data file on the System i'''

Click on 'Update' to rebuild the file on the System i. The program will attempt to clear the file before loading the new data, but will not be able to if it is in use. In that case, the program will update the existing records. The drawback to this, is that items that have been removed from the programs will remain on the file until the next time it can be successfully cleared.

You will get a message telling you whether or not the file could be cleared. If it couldn't be, you can redo step 5 until it can be; first thing in the morning is the best time to try.

[[Category: Infonet Programs]]

Sheilav: /* DataBase */

2015-10-15T19:06:09Z

DataBase

Sheilav: /* DataBase */

2015-10-15T19:04:46Z

DataBase

Sheilav: Created page with "=DataBase= PharmaCare makes information on Low Cost Alternatives and the Reference Drug Program available to be downloaded from their web site. They are updated on the first..."

2015-10-13T22:30:46Z

Created page with "=DataBase= PharmaCare makes information on Low Cost Alternatives and the Reference Drug Program available to be downloaded from their web site. They are updated on the first..."

New page

=DataBase=

PharmaCare makes information on Low Cost Alternatives and the Reference Drug Program available to be downloaded from their web site. They are updated on the first Thursday of each month. We display this information in Web Orders, and in item file maintenance and display.

The complete process for retrieving and updating these files is in InfoNet / Admin / Upload PharmaCare Info.

add image

There are five steps in this process.

'''1 - Retrieve LCA spreadsheet from PharmaCare'''

Click here to open the current Low Cost Alternatives spreadsheet from PharmaCare's web site. Then save it to your PC as CSV (comma delimited).

'''2 - Retrieve RDP spreadsheet from PharmaCare'''

Click here to open the current Reference Drug Program spreadsheet from PharmaCare's web site. Then save it to your PC as CSV (comma delimited).

'''3 - Upload Low Cost Alternatives CSV file to the System i.'''

Click on 'Browse' to find and select the file you retrieved from PharmaCare. Select file type LCE, then click on 'Upload'.

'''4 - Upload Reference Drug Program CSV file to the System i.'''

Click on 'Browse' to find and select the file you retrieved from PharmaCare. Select file type RDP, then click on 'Upload'.

'''5 - Update PharmaCare data file on the System i'''

Click on 'Update' to rebuild the file on the System i. The program will attempt to clear the file before loading the new data, but will not be able to if it is in use. In that case, the program will update the existing records. The drawback to this, is that items that have been removed from the programs will remain on the file until the next time it can be successfully cleared.

You will get a message telling you whether or not the file could be cleared. If it couldn't be, you can redo step 5 until it can be; first thing in the morning is the best time to try.

← Older revision		Revision as of 22:22, 5 June 2017
Line 2:		Line 2:

	PharmaCare makes information on Low Cost Alternatives and the Reference Drug Program available to be downloaded from their web site. They are updated on the first Thursday of each month. We display this information in Web Orders, and in item file maintenance and display.		PharmaCare makes information on Low Cost Alternatives and the Reference Drug Program available to be downloaded from their web site. They are updated on the first Thursday of each month. We display this information in Web Orders, and in item file maintenance and display.
		+	- NOTE: With the June 2017 process, the webpage location was changed by Pharmacare to
		+	http://www2.gov.bc.ca/gov/content/health/practitioner-professional-resources/pharmacare/pharmacies/low-cost-alternative-lca-and-reference-drug-program-rdp-data-files#current

	=Instructions=		=Instructions=

@@ Line 34: / Line 34: @@
 ==Expected file format==
-The programs that parse and process the LCA and RDP files expect certain fields to be in certain columns. The LCA file occasionally changes, and thus it will need to be edited to match the format outlined below to be processed properly.
+The programs that parse and process the LCA and RDP files expect certain fields to be in certain columns. The LCA file occasionally changes, thus requiring an edit before it can be processed properly.
 {| class="wikitable sortable"

← Older revision		Revision as of 19:04, 15 October 2015
Line 5:		Line 5:
	The complete process for retrieving and updating these files is in InfoNet / Admin / Upload PharmaCare Info.		The complete process for retrieving and updating these files is in InfoNet / Admin / Upload PharmaCare Info.

		+	[[File:Example.jpg]]
−	add image

	There are five steps in this process.		There are five steps in this process.

@@ Line 3: / Line 3: @@
 PharmaCare makes information on Low Cost Alternatives and the Reference Drug Program available to be downloaded from their web site.  They are updated on the first Thursday of each month.   We display this information in Web Orders, and in item file maintenance and display.
 The complete process for retrieving and updating these files is in InfoNet / Admin / Upload PharmaCare Info.
@@ Line 30: / Line 31: @@
 You will get a message telling you whether or not the file could be cleared.  If it couldn't be, you can redo step 5 until it can be; first thing in the morning is the best time to try.
 [[Category: Infonet Programs]]

@@ Line 5: / Line 5: @@
 The complete process for retrieving and updating these files is in InfoNet / Admin / Upload PharmaCare Info.
-[[File:pharmacare-1.jpg]]
+[[File:Pharmacare-1.jpg]]
 There are five steps in this process.