public void createCSVFromRows(DataGrid dt)
{
var items = dt.SelectedItems;
csvBasketList.Clear();
if (items != null)
{
foreach (var item in items)
{
csvBasketList.Add((ArticleModel)item);
}
if (csvBasketList.Count > 0)
{
SaveFileDialog svd = new SaveFileDialog();
svd.Filter = "CSV File|*.csv";
svd.Title = "Save CSV File";
svd.ShowDialog();
List <ArticleModel> myCsvBasket = new List <ArticleModel>(csvBasketList);
CSVEditor.createCSVFromInventarList(myCsvBasket, svd.FileName, checkBoxes);
openGeneratedFile(svd.FileName);
}
else
{
MessageBox.Show("CSV Basket is Empty");
}
}
}
private static void Init()
{
if (!_instance)
{
_instance = GetWindow <CSVEditor>();
_instance.minSize = new Vector2(800, 600);
}
}
public void Awake()
{
if (instance == null)
{
instance = this;
}
else
{
Debug.LogError("Two same wondows : CSVEditor");
}
}
public void BaseCSVReadTest()
{
string filename = "./Resources/FL_insurance_sample.csv";
CSVEditor CSVEdit = new CSVEditor();
CSVEdit.ReadFile(filename);
Assert.Equal(18, CSVEdit.CSVDT.Columns.Count);
Assert.Equal(36635, CSVEdit.CSVDT.Rows.Count);
}
public void JaggedCSVWriteTest()
{
string filename = "./Resources/JaggedCSV.csv";
CSVEditor CSVEdit = new CSVEditor();
CSVEdit.ReadFile(filename);
Assert.Equal(4, CSVEdit.CSVDT.Columns.Count);
Assert.Equal(3, CSVEdit.CSVDT.Rows.Count);
}
private void cmdEditMachineNames_Click(object sender, EventArgs e)
{
CSVEditor csvEditor = new CSVEditor();
csvEditor.Text = "Machine names";
csvEditor.ItemDescription = "Machine";
csvEditor.CSVData = txtMachines.Text;
if (csvEditor.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
txtMachines.Text = csvEditor.CSVData;
}
}
private void cmdEditColumnNames_Click(object sender, EventArgs e)
{
CSVEditor csvEditor = new CSVEditor();
csvEditor.Text = "Column names";
csvEditor.ItemDescription = "Column";
csvEditor.Sorted = false;
csvEditor.CSVData = txtColumnNames.Text;
if (csvEditor.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
txtColumnNames.Text = csvEditor.CSVData;
}
}
private void cmdEditEventIds_Click(object sender, EventArgs e)
{
CSVEditor csvEditor = new CSVEditor();
csvEditor.Sorted = false;
csvEditor.ClearTextOnUpdate = true;
csvEditor.ValuesAreIntegers = true;
csvEditor.CSVData = txtEventIds.Text;
if (csvEditor.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
txtEventIds.Text = csvEditor.CSVData;
}
}
static void Main(string[] args)
{
string source = @"C:\Users\Nobel360\Desktop\leftovers.csv";
//string source2 = @"C:\Users\Nobel360\Desktop\outgoing_btn.csv";
//string dest = @"C:\Users\Nobel360\Desktop\leftovers.csv";
//string dest2 = @"C:\Users\Nobel360\Desktop\outgoing_GBP.csv";
//string dest = @"C:\Users\Nobel360\Desktop\bitcoin_in.csv";
string dest = @"C:\Users\Nobel360\Desktop\outgoing_leftovers_btn.csv";
string dest2 = @"C:\Users\Nobel360\Desktop\outgoing_leftovers_gbp.csv";
List <List <string> > outgoing_complete = CSVEditor.Read(source);
CSVEditor.Write(dest, outgoing_complete.ToBTNList());
CSVEditor.Write(dest2, outgoing_complete.ToGBPList());
}
public void BaseCSVWriteTestWithQuotationMarks()
{
string filename = "./Resources/FL_insurance_sample.csv";
string destfilename = "./Resources/FL_insurance_sample3.csv";
CSVEditor CSVEdit = new CSVEditor();
CSVEdit.ReadFile(filename);
CSVEdit.WriteFile(destfilename, true);
CSVEdit.ReadFile(destfilename);
File.Delete(destfilename);
Assert.Equal(18, CSVEdit.CSVDT.Columns.Count);
Assert.Equal(36636, CSVEdit.CSVDT.Rows.Count);
}
void OnGUI()
{
///// Just in case
if (instance == null)
{
Debug.Log("Was not initiate ");
instance = this;
if (aH == null && gM == null)
{
InitAllListString();
}
}
/////
if (GUILayout.Button("Load CSV from selected gameObject", GUILayout.Width(300)))
{
UpdateCSVInSelectedGameObject();
}
//add a browser button (or even a 3 sliders of : room -> objet -> interaction)
if (GUILayout.Button("Browse/Create a CSV", GUILayout.Width(300)))
{
string[] filters = { "Text", "txt" };
string pathRecover = EditorUtility.OpenFilePanelWithFilters("Choose a CSV file", BASIC_PATH, filters);
if (pathRecover.EndsWith(".txt"))
{
//load all Room name, Zone name and Interaction name.
InitAllListString();
//Get the correct path name, from Path folder and without the ending (.txt here)
int index = pathRecover.IndexOf(BASIC_PATH);
pathToTreat = pathRecover.Remove(0, index + BASIC_PATH.Length);
pathToTreat = pathToTreat.Remove(pathToTreat.Length - 4);
//Finish the path to treat.
//Now, we split it in three and test each one to see if they are correct name for the popup menu : Room/Zone/Interaction
string[] folder = pathToTreat.Split('/');
if (folder.Length == 3)
{
CSVindexRoom = roomsName.IndexOf(folder[0]);
if (CSVindexRoom != -1)
{
CSVindexZone = zoneName[CSVindexRoom].IndexOf(folder[1]);
if (CSVindexZone != -1)
{
CSVindexInter = interName[CSVindexRoom][CSVindexZone].IndexOf(folder[2]);
if (CSVindexInter != -1)
{
//Technically, they already set correctly all value
}
else
{
Debug.Log("No interaction with this name");
CSVindexInter = -1;
}
}
else
{
Debug.Log("No zone with this name");
CSVindexZone = -1;
CSVindexInter = -1;
}
}
else
{
Debug.Log("No room with this name");
CSVindexRoom = -1;
CSVindexZone = -1;
CSVindexInter = -1;
}
}
else
{
Debug.Log("It's : " + folder.Length + " long.");
CSVindexRoom = -1;
CSVindexZone = -1;
CSVindexInter = -1;
}
//Now that we have the correct path, we load the CSV
LoadCSV();
}
else
{
Debug.Log("Not with .txt at the end");
}
}
if (pathToTreat == "")
{
}
else
{
if (CSVindexRoom != -1 && CSVindexZone != -1 && CSVindexInter != -1)//index -1 mean that's a custom CSV // need to test the three separatly
{
EditorGUILayout.BeginHorizontal();
EditorGUILayout.LabelField("Path of current CSV : ");
CSVindexRoom = EditorGUILayout.Popup(Mathf.Min(CSVindexRoom, roomsName.Count - 1),
roomsName.ToArray());
CSVindexZone = EditorGUILayout.Popup(Mathf.Min(CSVindexZone, zoneName[CSVindexRoom].Count - 1),
zoneName[CSVindexRoom].ToArray());
CSVindexInter = EditorGUILayout.Popup(Mathf.Min(CSVindexInter, interName[CSVindexRoom][CSVindexZone].Count - 1),
interName[CSVindexRoom][CSVindexZone].ToArray());
if (GUILayout.Button("Change for this CSV"))
{
//update the path
pathToTreat = roomsName[CSVindexRoom] + "/" + zoneName[CSVindexRoom][CSVindexZone] + "/" + interName[CSVindexRoom][CSVindexZone][CSVindexInter];
//load that path
LoadCSV();//create it if it don't existe now ? no weird...
}
EditorGUILayout.EndHorizontal();
EditorGUILayout.LabelField(" ");
}
else
{
//If room//inter
EditorGUILayout.LabelField("Path of current CSV : " + pathToTreat);
}
EditorGUILayout.LabelField("Step list : ");
stepIndex = 0;
listeOfCondYes = new List <int>();
listeOfCondNo = new List <int>();
foreach (Step s in stepList)
{
LayoutForType(s);
}
if (stepToRemove != null)
{
stepList.Remove(stepToRemove);
}
EditorGUILayout.LabelField(" ");
EditorGUILayout.LabelField("Edit list : ", GUILayout.Width(300));
if (GUILayout.Button("Add", GUILayout.Width(300)))
{
Step newStep = new Step();
stepList.Add(newStep);
}
//button : add a step, remove a step, reorder a step
EditorGUILayout.BeginHorizontal();
if (GUILayout.Button("Swap"))
{
Step toSwap = stepList[swapIndex];
stepList.RemoveAt(swapIndex);
stepList.Insert(switchIndex, toSwap);
}
swapIndex = EditorGUILayout.IntField(swapIndex);
switchIndex = EditorGUILayout.IntField(switchIndex);
EditorGUILayout.EndHorizontal();
//save the CSV
if (GUILayout.Button("Save/Update the CSV file", GUILayout.Width(300)))
{
UpdateCSV();
}
if ((Input.GetKey(KeyCode.LeftControl) || Input.GetKey(KeyCode.RightControl)) && Input.GetKey(KeyCode.S))
{
UpdateCSV();
}
if (displayFrame != 0)
{
EditorGUILayout.LabelField("Saved this CSV");
displayFrame--;
}
}
//end of "if path is empty"
}
