CSV to VOTable importer

None

BufferedReader getReader (String fileUrl, String encoding) throws IOException {
		InputStreamReader reader;
		try {
			if (encoding == null) {
				reader = new FileReader(fileUrl);
			} else {
				reader = new InputStreamReader(new FileInputStream(fileUrl),encoding); 
			}
		}
		catch (FileNotFoundException e) {
			// try a real URL instead
			URL url = new URL(fileUrl);
			if (encoding == null) {
				reader = new InputStreamReader (url.openStream());
			} else {
				reader = new InputStreamReader (url.openStream(), encoding);
			}
		}
		return new BufferedReader(reader);
	}


StringBuffer sb = new StringBuffer(4000);

if (encoding == void) {
	encoding = null;
}

BufferedReader in = getReader(fileurl, encoding);
String str;
String lineEnding = System.getProperty("line.separator");

while ((str = in.readLine()) != null) {
	sb.append(str);
	sb.append(lineEnding);
}
in.close();
filecontents = sb.toString();

Name	Type	Description
Format_conversion	tpipe	This AstroTaverna module uses the STIL library to change between the formats set by formatTableIn and formatTableOut (for instance, csv, fits, votable, tsv, and many others). In string mode, it changes the table _content_ passed by voTable, and generates content in the output format in outputTable. In file or URL mode, the path or URL is read, and a new file is generated, and its path is delivered in the output.
formatTableIn_value_csv	stringconstant	Set to csv, so that CSV files can be read. Value csv
formatTableOut_value_votable	stringconstant	Set to votable, so that the result is a VOtable. Value votable
Read_Text_File	localworker	Beanshell generic module that produces a Taverna string from the path of the given file. Used here to retrieve the contents of the CSV file path or URL. Script BufferedReader getReader (String fileUrl, String encoding) throws IOException { InputStreamReader reader; try { if (encoding == null) { reader = new FileReader(fileUrl); } else { reader = new InputStreamReader(new FileInputStream(fileUrl),encoding); } } catch (FileNotFoundException e) { // try a real URL instead URL url = new URL(fileUrl); if (encoding == null) { reader = new InputStreamReader (url.openStream()); } else { reader = new InputStreamReader (url.openStream(), encoding); } } return new BufferedReader(reader); } StringBuffer sb = new StringBuffer(4000); if (encoding == void) { encoding = null; } BufferedReader in = getReader(fileurl, encoding); String str; String lineEnding = System.getProperty("line.separator"); while ((str = in.readLine()) != null) { sb.append(str); sb.append(lineEnding); } in.close(); filecontents = sb.toString();
encoding_value	stringconstant	Constant value to set the input encoding for the CSV file. Set to UTF-8. Value utf-8

Source	Sink
formatTableIn_value_csv:value	Format_conversion:formatTableIn
formatTableOut_value_votable:value	Format_conversion:formatTableOut
Read_Text_File:filecontents	Format_conversion:voTable
csv_file_path	Read_Text_File:fileurl
encoding_value:value	Read_Text_File:encoding
Format_conversion:outputTable	votable

CSV to VOTable importer

Preview

Run

Run this Workflow in the Taverna Workbench...

Workflow Components

Value

Value

Script

Value

Reviews (0)

Comments (1)

Other workflows that use similar services (0)

Julian Garrido	Thursday 01 August 2013 06:51:16 (UTC)
	the read_file box is not needed. Instead of providing a path in the input port, you can choose the file when you run the workflow and Taverna open it and extract its content.