Upload CSV to the thingworx studio composer

Hi,

I am sorry for the delay but there was no time to test. Now I tested it and it works but it was for me also not easy to manage it. Yes for me the CVS methods are working only for strings- I tested a lot of formatstrings for date but it was not working so my solution is to use a service which create first a InfoTable with strings  and then in a second service  (is possible also in one service) to convert it to a correct data type.

So I have e.g. the following excel table:

The excel table was added to repositrory as earler was already mentioned:

So I defined two datashapes - the first one DS1 - there  the fileds are defined only as string and a second datashape DS3 where the field are defined with the correct data type. Also here have to mention , that I had difficulty to convert the german date format with milliseconds and separtor to the correct number. So the solution was to split every thing! So the source Data String was some thing like: "01.01.2018 00:00:00.010"

So I defined the first service   testReadCSV (retuns InfoTable) which convert only to string -something like this:

And then in the second service  convertTypeReadCSV  (retuns InfoTable) converted it to the correct dataformat:

{
var result1 = me.testReadCSV();
var params = {
	infoTableName : "InfoTable",
	dataShapeName : "DS3"
};
var InfoTable = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);

for(var i=0;i<result1.getLength();i++){
var myDateStr=result1.getRow(i).getStringValue('DateTime').split(" ",2)[0];
var dd=myDateStr.split(".",3)[0];
var mm=myDateStr.split(".",3)[1];
var yyyy=myDateStr.split(".",3)[2];
var myTimeStr=result1.getRow(i).getStringValue('DateTime').split(" ",2)[1];
var HH=myTimeStr.split(":",3)[0];
var MM=myTimeStr.split(":",3)[1];
var SEC_ALL=myTimeStr.split(":",3)[2];
var ss=SEC_ALL.split(".",2)[0];
var millsec=SEC_ALL.split(".",2)[1];
var NrStr=result1.getRow(i).getStringValue('Nr');
var TorqueStr= result1.getRow(i).getStringValue('Torque');
var myDate = new Date(yyyy,mm,dd,HH,MM,ss,millsec ); 
 InfoTable.AddRow({StripNr: Number(NrStr).toFixed(0),
 DateTime:myDate,
 Torque: Number(TorqueStr.replace(",",".")).toFixed(2)});
 }
result = InfoTable;
}

 So that when I tested it got the desired result: