SIMBAD - Revision history

Childers at 17:16, 21 February 2012

2012-02-21T17:16:39Z

2012-02-20T13:40:14Z

2012-02-19T23:33:47Z

Downloading Magnitudes from a List of Identifiers to a Spreadsheet

2012-02-19T23:32:40Z

Downloading Magnitudes from a List of Identifiers to a Spreadsheet

2012-02-19T23:25:28Z

Downloading Magnitudes from a List of Identifiers to a Spreadsheet

← Older revision		Revision as of 17:16, 21 February 2012
Line 27:		Line 27:

	--[[User:Childers\|Childers]] 15:21, 19 February 2012 (PST)		--[[User:Childers\|Childers]] 15:21, 19 February 2012 (PST)
		+
		+	----
		+
		+	[[BOKO_Current_Research_Activities\|Back to the BOKO home page]]

@@ Line 10: / Line 10: @@
 ## Make changes to the '''List Display''' column.
 ### Make sure '''Identifier''' is checked.
 ### Make sure '''Fluxes/Magnitudes''' is checked
 ###  You must also check the '''individual filters''' in the right-hand cells of the Fluxes/Magnitudes row.  You have nothing to lose by clicking all of them.
@@ Line 22: / Line 23: @@
 ::* Since semicolon is not the default delimiter in Excel, either use File > Open and then Data > Text to Columns, or use Data > Import External Data > Import Data.
 ::* The first few rows of the file identify and timestamp the query
-::* Missing magnitudes for a given filter are shown with a tilde (~) symbol.
+::* Missing magnitudes for a given filter are shown with a tilde (~) symbol.  Use Edit > Replace to get rid of them.
 ::* Identifiers from the uploaded list that SIMBAD couldn't parse are listed separately at the end.
 --[[User:Childers|Childers]] 15:21, 19 February 2012 (PST)

@@ Line 4: / Line 4: @@
 # '''Start on the [http://simbad.u-strasbg.fr/simbad/ SIMBAD home page.]'''  Look on the left for <font color="red">''Queries''</font>, and then underneath that click on ''by identifier''.
 # '''Set Output Options'''
-## Click on '''Output Options''', which is in a yellow box on the right-hand side of the '''''other query modes''''' row along the top.  A new tab will open.
+## Click on '''Output Options''', which is in a yellow box on the right-hand side of the '''''other query modes''''' row along the top.  A new browser tab will open.
 ## Set the '''Output Format''' in the top row.
 ### Choose '''ASCII (;-separator for spreadsheet)''' from the drop-down menu.
@@ Line 14: / Line 14: @@
 ### In general, uncheck all other rows, unless you are suspicious about your target list and would like some extra columns in your spreadsheet to act as a reality check.
 ## Click the '''SAVE''' button at the bottom to set a browser cookie and save your changes.
-# '''Query a List of Identifiers''' is on the bottom half of the page.
+# '''Query a List of Identifiers''' is on the bottom half of the original SIMBAD query browser tab.
 ## Prepare a '''.txt''' Notepad file containing only SIMBAD acceptable identifiers without a header.  Chances are if you got your list of identifiers from a catalog, you'll be okay.
 ## Click '''Choose File''' and browse to your text file.

@@ Line 20: / Line 20: @@
 ## Check '''Submit File'''.
 # '''A .csv file will begin downloading automatically.'''
-::* If you are using Excel, then you'll need to use Data > Text to Columns and explicitly tell it that you are using semi-colons as a delimiter.
+::* Since semicolon is not the default delimiter in Excel, either use File > Open and then Data > Text to Columns, or use Data > Import External Data > Import Data.
 ::* The first few rows of the file identify and timestamp the query
 ::* Missing magnitudes for a given filter are shown with a tilde (~) symbol.