Transfer Data to the Synthesis Data Warehouse (SDW) - Revision history

Kate Racaza at 18:29, 3 April 2017

2017-04-03T18:29:36Z

Kate Racaza at 17:02, 19 May 2016

2016-05-19T17:02:57Z

← Older revision		Revision as of 17:02, 19 May 2016
Line 3:		Line 3:
	The Synthesis Data Warehouse (SDW) — formerly called "Reliability Data Warehouse" — is a temporary data storage location in a Synthesis repository. With the Synthesis API, you can transfer data from external sources into the SDW of a repository for use in Weibull++, ALTA or RGA standard folios.		The Synthesis Data Warehouse (SDW) — formerly called "Reliability Data Warehouse" — is a temporary data storage location in a Synthesis repository. With the Synthesis API, you can transfer data from external sources into the SDW of a repository for use in Weibull++, ALTA or RGA standard folios.

	In this tutorial, you'll create a simple solution for ~~moving~~ data from a Microsoft Excel® file over to the SDW. Note that the tutorial only demonstrates one particular approach for extracting data from Excel. It's for demonstration purposes only; it doesn't take efficiency into account and doesn't include any exception handling.		In this tutorial, you'll create a simple solution for copying data from a Microsoft Excel® file over to the SDW. Note that the tutorial only demonstrates one particular approach for extracting data from Excel. It's for demonstration purposes only; it doesn't take efficiency into account and doesn't include any exception handling.

	==Prerequisites==		==Prerequisites==

Kate Racaza at 20:57, 12 May 2016

2016-05-12T20:57:13Z

← Older revision		Revision as of 20:57, 12 May 2016
Line 202:		Line 202:

	===References===		===References===
			*[[RawData Class]]
	*[[RawDataSet Class]]		*[[RawDataSet Class]]
	*~~[[RawData Class]]~~		**[[AddDataRow Method\|RawDataSet.AddDataRow Method]]
	*[[AddDataRow Method\|RawDataSet.AddDataRow Method]]
	*[[Repository.DataWarehouse.SaveRawDataSet\|Repository.DataWarehouse.SaveRawDataSet Method]]		*[[Repository.DataWarehouse.SaveRawDataSet\|Repository.DataWarehouse.SaveRawDataSet Method]]

Kate Racaza at 21:48, 9 May 2016

2016-05-09T21:48:41Z

@@ Line 188: / Line 188: @@
 ==Notes==
 In a secure database, you must have the "Create/edit/delete SDW data collections" permission in order to send a data collection to the database.
 ===References===

Kate Racaza at 18:28, 5 May 2016

2016-05-05T18:28:09Z

← Older revision		Revision as of 18:28, 5 May 2016
Line 1:		Line 1:
	{{Template:API}}{{Template:BacktoPrevPage~~\|[[API Tutorials\|<< Back to Tutorials Main Page]]~~}}		{{Template:API}}{{Template:BacktoPrevPage}}

	The Synthesis Data Warehouse (SDW) — formerly called "Reliability Data Warehouse" — is a temporary data storage location in a Synthesis repository. With the Synthesis API, you can transfer data from external sources into the SDW of a repository for use in Weibull++, ALTA or RGA standard folios.		The Synthesis Data Warehouse (SDW) — formerly called "Reliability Data Warehouse" — is a temporary data storage location in a Synthesis repository. With the Synthesis API, you can transfer data from external sources into the SDW of a repository for use in Weibull++, ALTA or RGA standard folios.

Kate Racaza at 17:02, 29 April 2016

2016-04-29T17:02:26Z

← Older revision		Revision as of 17:02, 29 April 2016
Line 8:		Line 8:
	Before you begin:		Before you begin:

	*Reference the Microsoft Excel Object Library in your code. In Visual Studio, choose '''Project > Add Reference''', and in the COM tab, select the latest version of the Microsoft Excel Object Library. Click '''OK'''.		*Reference the Microsoft Excel Object Library in your code. (In Visual Studio, choose '''Project > Add Reference''', and in the COM tab, select the latest version of the Microsoft Excel Object Library. Click '''OK'''.)

	*Create a Synthesis repository for testing purposes.		*Create a Synthesis repository for testing purposes.

	*You'll also need to create a sample Excel file to complete the tutorial successfully. Copy and paste the following data to an Excel file. Be sure to select cell A1 in Sheet1 of the workbook when pasting the data. Name the Excel file, "SampleData."		*You'll also need to create a sample Excel file to complete the tutorial successfully. Copy and paste the following data to an Excel file. Be sure to select cell A1 in Sheet1 of the workbook when pasting the data. Name the Excel file, "SampleData."


	{\| {{table}}		{\| {{table}}
Line 121:		Line 120:
	{{APIPrefix\|End Sub}}		{{APIPrefix\|End Sub}}
	{{APIPrefix\|End Module}}		{{APIPrefix\|End Module}}


	==Discussion==		==Discussion==
	Begin by creating an SDW data collection ~~or container~~. The [[RawDataSet Class\|RawDataSet]] class represents the data collection, and the type of data it will contain must be defined. For this example, we've set it to contain data sets for Weibull++.		Begin by creating an SDW data collection. The [[RawDataSet Class\|RawDataSet]] class represents the data collection, and the type of data it will contain must be defined. For this example, we've set it to contain data sets for Weibull++.

	{{APIComment\|'Declare a new RawDataSet object.}}		{{APIComment\|'Declare a new RawDataSet object.}}
Line 188:		Line 186:


	==References==		==Notes==
			In a secure database, you must have the "Create/edit/delete SDW data collections" permission in order to send a data collection to the database.

			===References===
	*[[RawDataSet Class]]		*[[RawDataSet Class]]
	*[[RawData Class]]		*[[RawData Class]]
	*[[AddDataRow Method\|RawDataSet.AddDataRow Method]]		*[[AddDataRow Method\|RawDataSet.AddDataRow Method]]
	*[[Repository.DataWarehouse.SaveRawDataSet\|Repository.DataWarehouse.SaveRawDataSet Method]]		*[[Repository.DataWarehouse.SaveRawDataSet\|Repository.DataWarehouse.SaveRawDataSet Method]]

Kate Racaza at 18:36, 28 April 2016

2016-04-28T18:36:26Z

Show changes

Kate Racaza: /* VB.NET Tutorial: Transfer Data from an Excel File to the SDW */

2016-03-30T23:21:09Z

VB.NET Tutorial: Transfer Data from an Excel File to the SDW

← Older revision		Revision as of 23:21, 30 March 2016
Line 210:		Line 210:

	{{APIComment\|'Add the current row to the data collection.}}		{{APIComment\|'Add the current row to the data collection.}}
	~~{{APIPrefix\|Call}}~~ DataCollection.AddDataRow(Row)		DataCollection.AddDataRow(Row)
	{{APIPrefix\|Next}} i		{{APIPrefix\|Next}} i

Line 275:		Line 275:

	{{APIComment\|'Add the current row to the data collection.}}		{{APIComment\|'Add the current row to the data collection.}}
	~~{{APIPrefix\|Call}}~~ DataCollection.AddDataRow(Row)		DataCollection.AddDataRow(Row)
	{{APIPrefix\|Next}} i		{{APIPrefix\|Next}} i

Kate Racaza: added colors to section headers to make them easier to pick out

2016-03-09T21:30:21Z

added colors to section headers to make them easier to pick out

← Older revision		Revision as of 21:30, 9 March 2016
Line 62:		Line 62:


	== VBA Tutorial: Transfer Data from an Excel File to the SDW==		== <span style="color:#FF8000;font-weight:bold;">VBA Tutorial: Transfer Data from an Excel File to the SDW </span>==

	Before you begin, be sure to reference the Microsoft Excel Object Library. Choose '''Tools > Reference''', and then select the library from the list. Click '''OK'''.		Before you begin, be sure to reference the Microsoft Excel Object Library. Choose '''Tools > Reference''', and then select the library from the list. Click '''OK'''.
Line 162:		Line 162:


	== VB.NET Tutorial: Transfer Data from an Excel File to the SDW ==		== <span style="color:#FF8000;font-weight:bold;">VB.NET Tutorial: Transfer Data from an Excel File to the SDW</span>==
	Before you begin, be sure to reference the Microsoft Excel Object Library. Choose '''Project > Add Reference''', and then select the library from the COM tab. Click '''OK'''.		Before you begin, be sure to reference the Microsoft Excel Object Library. Choose '''Project > Add Reference''', and then select the library from the COM tab. Click '''OK'''.

Line 293:		Line 293:
	{{APIPrefix\|End Class}}		{{APIPrefix\|End Class}}

	==References==		==<span style="color:#FF8000;font-weight:bold;">References</span>==
	To learn more, see the reference documentation for the classes and methods discussed in this tutorial:		To learn more, see the reference documentation for the classes and methods discussed in this tutorial:
	*[[RawDataSet Class]]		*[[RawDataSet Class]]

Kate Racaza at 16:39, 17 February 2016

2016-02-17T16:39:20Z

← Older revision		Revision as of 16:39, 17 February 2016
Line 11:		Line 11:
	The Synthesis Data Warehouse (SDW) — formerly called "Reliability Data Warehouse" — is a temporary data storage location in a Synthesis repository. With the Synthesis API, you can transfer data from external sources into the SDW of a repository for use in Weibull++, ALTA or RGA standard folios.		The Synthesis Data Warehouse (SDW) — formerly called "Reliability Data Warehouse" — is a temporary data storage location in a Synthesis repository. With the Synthesis API, you can transfer data from external sources into the SDW of a repository for use in Weibull++, ALTA or RGA standard folios.

	In the following tutorial, you'll ~~learn how to~~ create a simple solution for moving data from an Excel file over to the SDW. The tutorial is available for both VBA and VB.NET. Note that the tutorial demonstrates one particular approach for extracting data from Excel. ~~This is~~ for demonstration purposes only; it doesn't take efficiency into account and doesn't include any exception handling. To complete the tutorial successfully, please use the sample Excel data given below.		In the following tutorial, you'll create a simple solution for moving data from an Excel file over to the SDW. The tutorial is available for both VBA and VB.NET. Note that the tutorial demonstrates one particular approach for extracting data from Excel. It's for demonstration purposes only; it doesn't take efficiency into account and doesn't include any exception handling. To complete the tutorial successfully, please use the sample Excel data given below.

	===Create an Excel file for this tutorial===		===Create an Excel file for this tutorial===
Line 294:		Line 294:

	==References==		==References==
	To learn more, see the reference documentation for the classes and methods discussed in this ~~section~~:		To learn more, see the reference documentation for the classes and methods discussed in this tutorial:
	*[[RawDataSet Class]]		*[[RawDataSet Class]]
	*[[RawData Class]]		*[[RawData Class]]
	*[[AddDataRow Method\|RawDataSet.AddDataRow Method]]		*[[AddDataRow Method\|RawDataSet.AddDataRow Method]]
	*[[Repository.DataWarehouse.SaveRawDataSet\|Repository.DataWarehouse.SaveRawDataSet Method]]		*[[Repository.DataWarehouse.SaveRawDataSet\|Repository.DataWarehouse.SaveRawDataSet Method]]

← Older revision		Revision as of 23:21, 30 March 2016
Line 210:		Line 210:

	{{APIComment\|'Add the current row to the data collection.}}		{{APIComment\|'Add the current row to the data collection.}}
	~~{{APIPrefix\|Call}}~~ DataCollection.AddDataRow(Row)		DataCollection.AddDataRow(Row)
	{{APIPrefix\|Next}} i		{{APIPrefix\|Next}} i

Line 275:		Line 275:

	{{APIComment\|'Add the current row to the data collection.}}		{{APIComment\|'Add the current row to the data collection.}}
	~~{{APIPrefix\|Call}}~~ DataCollection.AddDataRow(Row)		DataCollection.AddDataRow(Row)
	{{APIPrefix\|Next}} i		{{APIPrefix\|Next}} i

← Older revision		Revision as of 18:29, 3 April 2017
Line 103:		Line 103:
	Row.FailureMode = sheet.Cells(i, 3).text		Row.FailureMode = sheet.Cells(i, 3).text

	{{APIComment\|'Add the current data point to the data collection.}}		{{APIComment\|'Add the current data point to the data collection.}}
	DataCollection.AddDataRow(Row)		DataCollection.AddDataRow(Row)
	{{APIPrefix\|Next}} i		{{APIPrefix\|Next}} i

Line 113:		Line 113:
	{{APIComment\|'Connect to a Synthesis repository.}}		{{APIComment\|'Connect to a Synthesis repository.}}
	{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository		{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository
	MyRepository.ConnectToRepository ({{APIString\|"C:\RSRepository1.~~rsr10~~"}}){{APIComment\|'Replace with name and path to test repository.}}		MyRepository.ConnectToRepository ({{APIString\|"C:\RSRepository1.rsr11"}}){{APIComment\|'Replace with name and path to test repository.}}

	{{APIComment\|'Send the data collection to the repository.}}		{{APIComment\|'Send the data collection to the repository.}}
Line 122:		Line 122:

	==Discussion==		==Discussion==
	Begin by creating an SDW data collection. The [[RawDataSet Class\|RawDataSet]] class represents the data collection~~, and the type of data it will contain must be defined~~. For this example, we've set it to contain data sets for Weibull++.		Begin by creating an SDW data collection. The [[RawDataSet Class\|RawDataSet]] class represents the data collection. For this example, we've set it to contain data sets for Weibull++.

	{{APIComment\|'Declare a new RawDataSet object.}}		{{APIComment\|'Declare a new RawDataSet object.}}
Line 176:		Line 176:
	{{APIComment\|'Connect to a Synthesis repository.}}		{{APIComment\|'Connect to a Synthesis repository.}}
	{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository		{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository
	MyRepository.ConnectToRepository({{APIString\|"C:\RSRepository1.~~rsr10~~"}}){{APIComment\|'Replace with name and path to test repository.}}		MyRepository.ConnectToRepository({{APIString\|"C:\RSRepository1.rsr11"}}){{APIComment\|'Replace with name and path to test repository.}}

	Then use the [[Repository.DataWarehouse.SaveRawDataSet\|Repository.DataWarehouse.SaveRawDataSet]] method to save the data collection to the Synthesis repository, as shown below.		Then use the [[Repository.DataWarehouse.SaveRawDataSet\|Repository.DataWarehouse.SaveRawDataSet]] method to save the data collection to the Synthesis repository, as shown below.

	To verify that the data were imported, launch Weibull++, open the SDW ('''Home > Synthesis > Synthesis Data Warehouse''') and then select the new data collection. (To view the data, you may need to display the StateTime, StateFS and FailureMode columns by right-clicking a column header and choosing '''Select Columns'''.)

	{{APIComment\|'Send the data collection to the repository.}}		{{APIComment\|'Send the data collection to the repository.}}
	MyRepository.DataWarehouse.SaveRawDataSet(DataCollection)		MyRepository.DataWarehouse.SaveRawDataSet(DataCollection)

			To verify that the data were imported, launch Weibull++, open the SDW ('''Home > Synthesis > Synthesis Data Warehouse''') and then select the new data collection. (To view the data, you may need to display the StateTime, StateFS and FailureMode columns by right-clicking a column header and choosing '''Select Columns'''.)

	==Notes==		==Notes==