Import project variables from excel of flat file

Irina_Stensky · 18 September 2017 13:57

Is there any way to import into project the set of variables,values and environments form excepl,csv or any form of json or flat file?

Kenneth_Bates · 19 September 2017 05:29

Hi Irina,

Thanks for getting in touch! There’s no built-in mechanism for importing variables from excel, csv or JSON files. This functionality would need to be scripted via the API. I’ve had a look for some example scripts that I hope will be helpful!

github.com

OctopusDeploy/OctopusDeploy-Api/blob/master/Octopus.Client/LINQPad/ImportExportUpdateVariables.linq

<Query Kind="Statements">
  <NuGetReference>Newtonsoft.Json</NuGetReference>
  <NuGetReference>Octopus.Client</NuGetReference>
  <Namespace>Octopus.Client</Namespace>
  <Namespace>Octopus.Client.Model</Namespace>
  <Namespace>Octopus.Client.Model.Endpoints</Namespace>
  <Namespace>Octopus.Client.Serialization</Namespace>
  <Namespace>System.Net</Namespace>
  <Namespace>System.Net.Http</Namespace>
  <Namespace>Newtonsoft.Json</Namespace>
</Query>

// This script shows how to retrieve, export, import, manipulate and update a project's variables

var endpoint = new OctopusServerEndpoint("http://localhost", "API-AOLL7T3QASOZEJROIAYAGBWA6M");
var repository = new OctopusRepository(endpoint);


var project = repository.Projects.FindByName("Test");
var set = repository.VariableSets.Get(project.VariableSetId);

This file has been truncated. show original

Additionally, there’s a new UserVoice item suggesting the ability to import variables from a JSON file. Feel free to give that some more attention with a vote/comment.
https://octopusdeploy.uservoice.com/forums/170787-general/suggestions/20504002-import-variables-from-json

I hope this helps! Don’t hesitate to reach out if you have any further questions.

Best regards,

Kenny

sophiacharles9090 · 21 September 2017 07:14

Hi, this is a good question. If you want to import project variables from excel of flat file then you should installed The JIRA Importers plugin. It allows you to import your data from a comma-separated value (CSV) file . As you know that CSV files are text files and it can export its data in a structured/tabulated format, for example Microsoft Excel, databases, etc. I am very glad if my suggestion will helpful to you.