APISDWTutorialVBNET - Revision history

Kate Racaza: Redirected page to Transfer Data to the Synthesis Data Warehouse (SDW)

2016-02-10T18:10:30Z

Redirected page to Transfer Data to the Synthesis Data Warehouse (SDW)

Kate Racaza at 20:51, 17 November 2015

2015-11-17T20:51:52Z

← Older revision		Revision as of 20:51, 17 November 2015
Line 18:		Line 18:
	1. Before we begin, you'll need to reference the Microsoft Excel Object Library. Choose '''Project > Add Reference''', and then select the library from the COM tab. Click '''OK'''.		1. Before we begin, you'll need to reference the Microsoft Excel Object Library. Choose '''Project > Add Reference''', and then select the library from the COM tab. Click '''OK'''.

	2. Create a new form. On the code page, add an Imports statement for ~~'''~~Microsoft.Office.Interop.Excel~~'''~~, then start with the following code to create an SDW data collection. The code uses the <code>RawDataSet</code> class to represent an SDW data collection, and the <code>ExtractedType</code> property to specify that the data collection is for use with Weibull++.		2. Create a new form. On the code page, add an Imports statement for <code>Microsoft.Office.Interop.Excel</code>, then start with the following code to create an SDW data collection. The code uses the <code>RawDataSet</code> class to represent an SDW data collection, and the <code>ExtractedType</code> property to specify that the data collection is for use with Weibull++.

	'''VB.NET'''		'''VB.NET'''

Kate Racaza at 20:40, 17 November 2015

2015-11-17T20:40:35Z

← Older revision		Revision as of 20:40, 17 November 2015
Line 18:		Line 18:
	1. Before we begin, you'll need to reference the Microsoft Excel Object Library. Choose '''Project > Add Reference''', and then select the library from the COM tab. Click '''OK'''.		1. Before we begin, you'll need to reference the Microsoft Excel Object Library. Choose '''Project > Add Reference''', and then select the library from the COM tab. Click '''OK'''.

	2. Create a new form. On the code page, add an Imports statement for Microsoft.Office.Interop.Excel, then start with the following code to create an SDW data collection. The code uses the <code>RawDataSet</code> class to represent an SDW data collection, and the <code>ExtractedType</code> property to specify that the data collection is for use with Weibull++.		2. Create a new form. On the code page, add an Imports statement for '''Microsoft.Office.Interop.Excel''', then start with the following code to create an SDW data collection. The code uses the <code>RawDataSet</code> class to represent an SDW data collection, and the <code>ExtractedType</code> property to specify that the data collection is for use with Weibull++.

	'''VB.NET'''		'''VB.NET'''

Kate Racaza at 20:35, 17 November 2015

2015-11-17T20:35:59Z

← Older revision		Revision as of 20:35, 17 November 2015
Line 16:		Line 16:
	== Transfer Data from an Excel File to the SDW (VB.NET) ==		== Transfer Data from an Excel File to the SDW (VB.NET) ==

	1. We'll ~~begin with~~ the ~~<code~~>~~RawDataSet</code> class~~, ~~which represents an SDW data collection. We'll~~ then ~~use~~ the ~~<code>ExtractedType</code> property to specify that~~ the ~~data collection is for use with Weibull++~~.		1. Before we begin, you'll need to reference the Microsoft Excel Object Library. Choose '''Project > Add Reference''', and then select the library from the COM tab. Click '''OK'''.

	Create a new form ~~and~~ start with the following code to create an SDW data collection.		2. Create a new form. On the code page, add an Imports statement for Microsoft.Office.Interop.Excel, then start with the following code to create an SDW data collection. The code uses the <code>RawDataSet</code> class to represent an SDW data collection, and the <code>ExtractedType</code> property to specify that the data collection is for use with Weibull++.

	'''VB.NET'''		'''VB.NET'''
Line 30:		Line 30:
	DataCollection.ExtractedType = RawDataSetType.Weibull		DataCollection.ExtractedType = RawDataSetType.Weibull

	2. Next, ~~we'll~~ use the <code>RawData</code> class to represent a single row of data, and then use the <code>AddDataRow</code> method to add the row to the data collection.		3. Next, use the <code>RawData</code> class to represent a single row of data, and then use the <code>AddDataRow</code> method to add the row to the data collection.

	The following code demonstrates one way to extract a row of data from the Excel file. First, the code opens a connection to the Excel file and specifies the active sheet (in this case, Sheet1). Then <code>For i = 2</code>, the code creates a new <code>RawData</code> object and sets its properties by using the values from row #2 of the Excel file. After the code finishes reading the row of data, it adds the object to the data collection. When the code reaches <code>Next i</code>, it increases <code>i</code> with 1 and jumps back to the <code>For</code> statement, which adds another new <code>RawData</code> object~~, sets its properties with~~ the data ~~from~~ row #3 of the Excel sheet, and ~~adds the row to the data collection~~. The loop continues until <code>i</code> reaches the specified number of rows (MaxRow). Finally, the code closes the connection to the Excel file.		The following code demonstrates one way to extract a row of data from the Excel file. First, the code opens a connection to the Excel file and specifies the active sheet (in this case, Sheet1). Then <code>For i = 2</code>, the code creates a new <code>RawData</code> object and sets its properties by using the values from row #2 of the Excel file. After the code finishes reading the row of data, it adds the object to the data collection. When the code reaches <code>Next i</code>, it increases <code>i</code> with 1 and jumps back to the <code>For</code> statement, which adds another new <code>RawData</code> object for the data in row #3 of the Excel sheet, and so on. The loop continues until <code>i</code> reaches the specified number of rows (MaxRow). Finally, the code closes the connection to the Excel file.

	'''VB.NET'''		'''VB.NET'''
Line 68:		Line 68:
	Excel.Quit()		Excel.Quit()

	3. Now that the data from the Excel file have been copied to the data collection, the next step is to save the data collection to the Synthesis repository.		4. Now that the data from the Excel file have been copied to the data collection, the next step is to save the data collection to the Synthesis repository.

	~~First, connect~~ to the Synthesis repository and then use the <code>SaveRawDataSet</code> method to save the data collection to the repository.		Connect to the Synthesis repository and then use the <code>DataWarehouse.SaveRawDataSet</code> method to save the data collection to the repository.

	'''VB.NET'''		'''VB.NET'''

Kate Racaza at 16:22, 30 October 2015

2015-10-30T16:22:02Z

← Older revision		Revision as of 16:22, 30 October 2015
Line 3:		Line 3:
	<nowiki><<</nowiki> [[APIQuickStartGuide\|Back to Quick Start Guide]]		<nowiki><<</nowiki> [[APIQuickStartGuide\|Back to Quick Start Guide]]

	'''Synthesis Data Warehouse (SDW) Tutorial'''		'''[[APISDWTutorial\|Synthesis Data Warehouse (SDW) Tutorial]]'''
	*[[APISDWTutorialVBA\|VBA]]		*[[APISDWTutorialVBA\|VBA]]
	*VB.NET		*VB.NET

Kate Racaza at 16:20, 30 October 2015

2015-10-30T16:20:29Z

← Older revision		Revision as of 16:20, 30 October 2015
Line 8:		Line 8:
	</div>		</div>

	This VB.NET tutorial will demonstrate one approach to read data from an Excel file and extract it for the SDW. Note that this tutorial is for demonstration purposes only~~; it~~ does not include any exception handling ~~and its performance may be slow~~. To complete this tutorial successfully, please use the [[APISDWTutorial\|sample Excel data]] that was provided for this ~~tutorial~~.		This VB.NET tutorial will demonstrate one approach to read data from an Excel file and extract it for the SDW. Note that this tutorial is for demonstration purposes only and does not include any exception handling. To complete this tutorial successfully, please use the [[APISDWTutorial\|sample Excel data]] that was provided for this exercise.


Line 14:		Line 14:


	== Transfer Data from an Excel File to the SDW ==		== Transfer Data from an Excel File to the SDW (VB.NET) ==

	1. We'll begin with the <code>RawDataSet</code> class, which represents an SDW data collection. We'll then use the <code>ExtractedType</code> property to specify that the data collection is for use with Weibull++.		1. We'll begin with the <code>RawDataSet</code> class, which represents an SDW data collection. We'll then use the <code>ExtractedType</code> property to specify that the data collection is for use with Weibull++.
Line 32:		Line 32:
	2. Next, we'll use the <code>RawData</code> class to represent a single row of data, and then use the <code>AddDataRow</code> method to add the row to the data collection.		2. Next, we'll use the <code>RawData</code> class to represent a single row of data, and then use the <code>AddDataRow</code> method to add the row to the data collection.

	The following code demonstrates one way to extract a row of data from the Excel file. First, the code opens a connection to the Excel file and specifies the active sheet (in this case, ~~sheet #1~~). Then <code>For i = 2</code>, the code creates a new <code>RawData</code> object and sets its properties by using the values from row #2 of the Excel file. After the code finishes reading the row of data, it adds the object to the data collection. When the code reaches <code>Next i</code>, it increases <code>i</code> with 1 and jumps back to the <code>For</code> statement, which adds another new <code>RawData</code> object, sets its properties with the data from row #3 of the Excel sheet, and adds the row to the data collection. The loop continues until <code>i</code> reaches the specified number of rows (MaxRow). Finally, the code closes the connection to the Excel file.		The following code demonstrates one way to extract a row of data from the Excel file. First, the code opens a connection to the Excel file and specifies the active sheet (in this case, Sheet1). Then <code>For i = 2</code>, the code creates a new <code>RawData</code> object and sets its properties by using the values from row #2 of the Excel file. After the code finishes reading the row of data, it adds the object to the data collection. When the code reaches <code>Next i</code>, it increases <code>i</code> with 1 and jumps back to the <code>For</code> statement, which adds another new <code>RawData</code> object, sets its properties with the data from row #3 of the Excel sheet, and adds the row to the data collection. The loop continues until <code>i</code> reaches the specified number of rows (MaxRow). Finally, the code closes the connection to the Excel file.

	'''VB.NET'''		'''VB.NET'''
Line 39:		Line 39:
	{{APIPrefix\|Dim}} Row {{APIPrefix\|As New}} RawData		{{APIPrefix\|Dim}} Row {{APIPrefix\|As New}} RawData

	{{APIComment\|'Open the Excel file. The following code assumes that ~~your~~}}		{{APIComment\|'Open the Excel file. The following code assumes that the}}
	{{APIComment\|'~~sample data~~ is saved in the C drive.}}		{{APIComment\|'Excel file is saved in the C drive.}}
	{{APIPrefix\|Dim}} Excel {{APIPrefix\|As New}} Application		{{APIPrefix\|Dim}} Excel {{APIPrefix\|As New}} Application
	{{APIPrefix\|Dim}} Workbook {{APIPrefix\|As}} Workbook		{{APIPrefix\|Dim}} Workbook {{APIPrefix\|As}} Workbook
Line 106:		Line 106:
	{{APIPrefix\|Dim}} Row {{APIPrefix\|As New}} RawData		{{APIPrefix\|Dim}} Row {{APIPrefix\|As New}} RawData

	{{APIComment\|'Open the Excel file. The following code assumes that ~~your~~}}		{{APIComment\|'Open the Excel file. The following code assumes that the}}
	{{APIComment\|'~~sample data~~ is saved in the C drive.}}		{{APIComment\|'Excel file is saved in the C drive.}}
	{{APIPrefix\|Dim}} Excel {{APIPrefix\|As New}} Application		{{APIPrefix\|Dim}} Excel {{APIPrefix\|As New}} Application
	{{APIPrefix\|Dim}} Workbook {{APIPrefix\|As}} Workbook		{{APIPrefix\|Dim}} Workbook {{APIPrefix\|As}} Workbook

Kate Racaza at 18:04, 28 October 2015

2015-10-28T18:04:51Z

← Older revision		Revision as of 18:04, 28 October 2015
Line 89:		Line 89:
	'''VB.NET'''		'''VB.NET'''

	{{APIPrefix\|Imports}} ~~Synthesis.API~~		{{APIPrefix\|Imports}} SynthesisAPI
	{{APIPrefix\|Imports}} Microsoft.Office.Interop.Excel		{{APIPrefix\|Imports}} Microsoft.Office.Interop.Excel

Kate Racaza at 17:55, 28 October 2015

2015-10-28T17:55:50Z

← Older revision		Revision as of 17:55, 28 October 2015
Line 32:		Line 32:
	2. Next, we'll use the <code>RawData</code> class to represent a single row of data, and then use the <code>AddDataRow</code> method to add the row to the data collection.		2. Next, we'll use the <code>RawData</code> class to represent a single row of data, and then use the <code>AddDataRow</code> method to add the row to the data collection.

	The following code demonstrates one way to extract a row of data from the Excel file.		The following code demonstrates one way to extract a row of data from the Excel file. First, the code opens a connection to the Excel file and specifies the active sheet (in this case, sheet #1). Then <code>For i = 2</code>, the code creates a new <code>RawData</code> object and sets its properties by using the values from row #2 of the Excel file. After the code finishes reading the row of data, it adds the object to the data collection. When the code reaches <code>Next i</code>, it increases <code>i</code> with 1 and jumps back to the <code>For</code> statement, which adds another new <code>RawData</code> object, sets its properties with the data from row #3 of the Excel sheet, and adds the row to the data collection. The loop continues until <code>i</code> reaches the specified number of rows (MaxRow). Finally, the code closes the connection to the Excel file.


	'''VB.NET'''		'''VB.NET'''
Line 40:		Line 39:
	{{APIPrefix\|Dim}} Row {{APIPrefix\|As New}} RawData		{{APIPrefix\|Dim}} Row {{APIPrefix\|As New}} RawData

	{{APIComment\|'~~Read~~ the Excel file. The following code assumes that your}}		{{APIComment\|'Open the Excel file. The following code assumes that your}}
	{{APIComment\|'sample data is saved in the C drive.}}		{{APIComment\|'sample data is saved in the C drive.}}
	{{APIPrefix\|Dim}} Excel {{APIPrefix\|As New}} Application		{{APIPrefix\|Dim}} Excel {{APIPrefix\|As New}} Application
Line 49:		Line 48:
	Sheet = Workbook.Sheets(1)		Sheet = Workbook.Sheets(1)

	{{APIComment\|'~~Scan the cells~~ in the Excel file.}}		{{APIComment\|'Read each row of data in the Excel file.}}
	{{APIPrefix\|Dim}} i {{APIPrefix\|As}} Integer, MaxRow {{APIPrefix\|As}} Integer		{{APIPrefix\|Dim}} i {{APIPrefix\|As}} Integer, MaxRow {{APIPrefix\|As}} Integer
	MaxRow = 20		MaxRow = 20
Line 65:		Line 64:
	{{APIPrefix\|Next}} i		{{APIPrefix\|Next}} i

			{{APIComment\|'Close the Excel file.}}
	Workbook.Close()		Workbook.Close()
	Excel.Quit()		Excel.Quit()

	3. Now that the data from the Excel ~~sheet~~ have been copied to the data collection, the next step is to save the data collection to the Synthesis repository.		3. Now that the data from the Excel file have been copied to the data collection, the next step is to save the data collection to the Synthesis repository.

	First, connect to the Synthesis repository and then use the <code>SaveRawDataSet</code> method to save the data collection to the repository.		First, connect to the Synthesis repository and then use the <code>SaveRawDataSet</code> method to save the data collection to the repository.
Line 106:		Line 106:
	{{APIPrefix\|Dim}} Row {{APIPrefix\|As New}} RawData		{{APIPrefix\|Dim}} Row {{APIPrefix\|As New}} RawData

	{{APIComment\|'~~Read~~ the Excel file. The following code assumes that your}}		{{APIComment\|'Open the Excel file. The following code assumes that your}}
	{{APIComment\|'sample data is saved in the C drive.}}		{{APIComment\|'sample data is saved in the C drive.}}
	{{APIPrefix\|Dim}} Excel {{APIPrefix\|As New}} Application		{{APIPrefix\|Dim}} Excel {{APIPrefix\|As New}} Application
Line 115:		Line 115:
	Sheet = Workbook.Sheets(1)		Sheet = Workbook.Sheets(1)

	{{APIComment\|'~~Scan the cells~~ in the Excel file.}}		{{APIComment\|'Read each row of data in the Excel file.}}
	{{APIPrefix\|Dim}} i {{APIPrefix\|As}} Integer, MaxRow {{APIPrefix\|As}} Integer		{{APIPrefix\|Dim}} i {{APIPrefix\|As}} Integer, MaxRow {{APIPrefix\|As}} Integer
	MaxRow = 20		MaxRow = 20
Line 131:		Line 131:
	{{APIPrefix\|Next}} i		{{APIPrefix\|Next}} i

	Workbook.Close()		{{APIComment\|'Close the Excel file.}}
	Excel.Quit()		Workbook.Close()
			Excel.Quit()

	{{APIComment\|'Connect to the Synthesis repository. The following code assumes that}}		{{APIComment\|'Connect to the Synthesis repository. The following code assumes that}}

Kate Racaza: Created page with '{{InProgress}}{{DISPLAYTITLE:Synthesis Data Warehouse (SDW) Tutorial}}{{Template:API}}