Importing and Exporting CSV - Revision history

OriginalHotrodder at 04:46, 24 March 2013

2013-03-24T04:46:50Z

← Older revision		Revision as of 04:46, 24 March 2013
Line 14:		Line 14:
	----		----

	[[File:HLS_ExportCSV_ExportButton.png\|thumb\|Figure 11-4]]		[[File:HLS_ExportCSV_ExportButton.png\|350px\|thumb\|Figure 11-4]]
	[[File:HLS_ExportCSV_ExportConfirmation.png\|thumb\|Figure 11-5]]		[[File:HLS_ExportCSV_ExportConfirmation.png\|350px\|thumb\|Figure 11-5]]
	*To export your channel data, open the channel manager (''Manage Channels -> Manage Raw Channels'').		*To export your channel data, open the channel manager (''Manage Channels -> Manage Raw Channels'').
	*In the bottom-right of the window, click ''Export CSV File'' (see Figure 11-4).		*In the bottom-right of the window, click ''Export CSV File'' (see Figure 11-4).
Line 27:		Line 27:
	----		----

	[[File:HLS_ExportCSV_ExcelData.png\|thumb\|Figure 11-6]]		[[File:HLS_ExportCSV_ExcelData.png\|350px\|thumb\|Figure 11-6]]
	*'''Note:''' For this example, Excel will be used, but any program that can manipulate CSV files will work.		*'''Note:''' For this example, Excel will be used, but any program that can manipulate CSV files will work.
	*Open the exported file in Excel.		*Open the exported file in Excel.
Line 47:		Line 47:
	----		----

	[[File:HLS_ExportCSV_ImportCSV.png\|thumb\|Figure 11-7]]		[[File:HLS_ExportCSV_ImportCSV.png\|350px\|thumb\|Figure 11-7]]
	*Once changes have been made, save the CSV file.		*Once changes have been made, save the CSV file.
	*Go ahead and save your HLS sequence in case there is a problem with the import.		*Go ahead and save your HLS sequence in case there is a problem with the import.

Jlowe at 16:21, 7 March 2013

2013-03-07T16:21:30Z

← Older revision		Revision as of 16:21, 7 March 2013
Line 14:		Line 14:
	----		----

			[[File:HLS_ExportCSV_ExportButton.png\|thumb\|Figure 11-4]]
			[[File:HLS_ExportCSV_ExportConfirmation.png\|thumb\|Figure 11-5]]
	*To export your channel data, open the channel manager (''Manage Channels -> Manage Raw Channels'').		*To export your channel data, open the channel manager (''Manage Channels -> Manage Raw Channels'').
	*In the bottom-right of the window, click ''Export CSV File''.		*In the bottom-right of the window, click ''Export CSV File'' (see Figure 11-4).
	*A window will open confirming that the export is complete.		*A window will open confirming that the export is complete (see Figure 11-5).
	*The location of the exported file will be inside the HLS folder for the sequence you exported information from.		*The location of the exported file will be inside the HLS folder for the sequence you exported information from.
	**Ex.: Channel info exported from a sequence named "Carol". Go into the '''HLS/Carol''' folder and the exported file will be named '''Carol Export.csv'''.		**Ex.: Channel info exported from a sequence named "Carol". Go into the '''HLS/Carol''' folder and the exported file will be named '''Carol Export.csv'''.
			<br clear=all>


	====Working With Exported Data====		====Working With Exported Data====
	----		----

			[[File:HLS_ExportCSV_ExcelData.png\|thumb\|Figure 11-6]]
	*'''Note:''' For this example, Excel will be used, but any program that can manipulate CSV files will work.		*'''Note:''' For this example, Excel will be used, but any program that can manipulate CSV files will work.
	*Open the exported file in Excel.		*Open the exported file in Excel.
	*The Channel information will be listed in column format with headings explaining what each column value is for.		*The Channel information will be listed in column format with headings explaining what each column value is for (see Figure 11-6).
	**Guid: This is a unique identifier given by HLS for that channel.		**Guid: This is a unique identifier given by HLS for that channel.
	**Current Name: The current name of the channel.		**Current Name: The current name of the channel.
Line 36:		Line 41:
	*Make desired changes Excel. Know that HLS is unable to apply any error-correction for values you put in here since you are modifying it outside of HLS.		*Make desired changes Excel. Know that HLS is unable to apply any error-correction for values you put in here since you are modifying it outside of HLS.
	*If you add channels, you will not have a GUID. HLS will assign this on import.		*If you add channels, you will not have a GUID. HLS will assign this on import.
			<br clear=all>


Line 41:		Line 47:
	----		----

			[[File:HLS_ExportCSV_ImportCSV.png\|thumb\|Figure 11-7]]
	*Once changes have been made, save the CSV file.		*Once changes have been made, save the CSV file.
	*Go ahead and save your HLS sequence in case there is a problem with the import.		*Go ahead and save your HLS sequence in case there is a problem with the import.
Line 47:		Line 54:


	*There are two ways to import the data:		*There are two ways to import the data (see Figure 11-7):
	**Import based on GUID: Import and use the GUID when making changes to channel data.		**Import based on GUID: Import and use the GUID when making changes to channel data.
	**Import based on Current Name: Ignore the GUID field on import and copy any changes based on the Current Name field.		**Import based on Current Name: Ignore the GUID field on import and copy any changes based on the Current Name field.
Line 66:		Line 73:

	*'''Important:''' If you create NEW channels in CSV, you MUST FIRST create empty channels in the raw channel manager so HLS has a place to move that data into the sequence. If you do not do this, the data from those new channels will not be imported.		*'''Important:''' If you create NEW channels in CSV, you MUST FIRST create empty channels in the raw channel manager so HLS has a place to move that data into the sequence. If you do not do this, the data from those new channels will not be imported.
			<br clear=all>


			<noinclude>
			{\| class="wikitable"
			! colspan="3"\| [[HLS User Manual and Reference Guide]]
			\|-
			! align="center"\|Previous Page
			! align="center"\|Current Chapter
			! align="center"\|Next Page
			\|-
			\| align="center" \| [[Using HLS Sequence Images]]
			\| align="center" \| [[HLS User Manual and Reference Guide#Importing_and_Exporting_Data_and_Sequences \| Chapter 11: Importing and Exporting Data and Sequences]]
			\| align="center" \| [[Importing a Sequence from Vixen]]
			\|}
			<br />

	*Creating channels before importing new ones.		[[Category:HLS User Manual]]
			</noinclude>

Jlowe at 16:14, 7 March 2013

2013-03-07T16:14:49Z

@@ Line 1: / Line 1: @@
 ====Introduction====
@@ Line 6: / Line 5: @@
-*Potential Uses: Adjusting channels, creating new channels, Printing channel info, etc.
+*Some potential uses for this feature include:
@@ Line 12: / Line 14: @@
 ----
-*Export info.
+*To export your channel data, open the channel manager (''Manage Channels -> Manage Raw Channels'').
-*Where to find the exported file.
+*In the bottom-right of the window, click ''Export CSV File''.
+*A window will open confirming that the export is complete.
 ====Working With Exported Data====
 ----
-*Using in Excel (as an example).
+*'''Note:''' For this example, Excel will be used, but any program that can manipulate CSV files will work.
-*Column meanings and values.
+*Open the exported file in Excel.
-*Saving the file.
+*The Channel information will be listed in column format with headings explaining what each column value is for.
 ====Importing CSV Data Into HLS====
 ----
-*Importing the information back into HLS.
+*Once changes have been made, save the CSV file.
 *Creating channels before importing new ones.

Jlowe: Created outline to be filled in with how-to information.

2013-02-26T16:16:02Z

Created outline to be filled in with how-to information.

← Older revision		Revision as of 16:16, 26 February 2013
Line 1:		Line 1:
			Under Revision. Feel free to pitch in.

	~~Content needed~~		====Introduction====
			----
			To aid in mass channel configuration and changes, HLS allows the user to export channel information to CSV (Comma Separated Values). This is a common text-based data export that can be imported in various programs, such as Excel. This exported data can then be viewed in another program, modified, and then imported back into HLS.


			*Potential Uses: Adjusting channels, creating new channels, Printing channel info, etc.


			====Exporting Data to CSV====
			----

			*Export info.
			*Where to find the exported file.


			====Working With Exported Data====
			----

			*Using in Excel (as an example).
			*Column meanings and values.
			*Saving the file.

			====Importing CSV Data Into HLS====
			----

			*Importing the information back into HLS.
			*Creating channels before importing new ones.

OriginalHotrodder at 07:28, 21 February 2013

2013-02-21T07:28:43Z

← Older revision		Revision as of 07:28, 21 February 2013
Line 1:		Line 1:

	Content needed		Content needed

OriginalHotrodder: Created page with "Content needed"

2013-02-21T06:54:14Z

Created page with "Content needed"

New page

Content needed