Hi all,In our application, we need to be enter at least 16 digit number in a Textbox (Edit Box), I have took the input from csv file, when I put this input in our application, TestComplete gives me a warning message "The text specified in the edit box has been truncated, since it was too long." but when I put same 16 digit number as hardcoded it will be accept. what's the wrong with csv, please help.ThanksRavik

Hi Ravi, Have you tried specifying the type for each column? Here is the code I specified in the Schema.ini file (I mentioned about it earlier): [Test.csv] Format=Delimited(,) CharacterSet=ANSI Col1=CurrentNumber Double Width 20 Col2=NewNumber Double Width 20 In TestComplete 9.31, I successfully executed the following sample code that reads data from a CSV file: //JScript function CSVDriverExample() { DDT.CSVDriver("Test.csv" ); while (! DDT.CurrentDriver.EOF()) { Log.Message(aqConvert.VarToFloat(DDT.CurrentDriver.Value(0))); Log.Message(DDT.CurrentDriver.Value(1)); DDT.CurrentDriver.Next(); } DDT.CloseDriver(DDT.CurrentDriver.Name); }

Hi Ravik Does the textbox you are trying to type into have a max length? If TC detects that the string you are trying to enter is longer than the max length of the actual text box, that is the kind of message you get. Even if the textbox has a max length of 16, you may still run into an issue because... TC uses the information supplied by Microsoft on the datatype it detected in the column - in other words, Microsoft guesses, TC believes it. This means a CSV field with 16 numbers in won't be interpreted as a text, but rather a number. This number is larger than an integer though, so ends up being changed to scientific notation e.g. 1.2345678901234E15 That value is interpreted as a string longer than 16 characters. Here two potential ways around this: 1. Use a XLS/XLSX file. That way you can add the single qoute in front of the number e.g. '1234567890123456 and TC will read it as a literal string. If you use source control this isn't the best option though. There is no way to compare the two files. If you are using spreadsheets as data, I would recommend sticking to CSV 2. Use a CSV in conjuction with schema.ini Microsoft documentation on schema.ini You need to place the file in the same folder as the CSV and it will override the way TC interprets it from Microsoft. You should only need to specify the columns that don't behave, so in your case, you could have a CSV with 10 columns, but you only need to specify 2. So, for example: [MyFile.csv] Format=CSVDelimited ColNameHeader=True MaxScanRows=5 Col9=NumberIn Text Col10=NumberOut Text Hope that helps

Hi Ravik.Check the actual length of what TC tries to input into field property with logging like this:Log.Message( YourValue.length )orLog.Message( Len( YourValue ) ) if you use VBS.It's good idea to log value itself as well.

HI Andrey,I want to enter at least (min 16 digit ) 16 digit number into a Textbox and I want to get data from csv. actually what happen- When I put 16 digit number like - SetText("1234567890123456") it will be accept and execute by TestComplete but when I move for data drven testing and try to get same number from csv file, Then it is trancate and gives above mention Error

Hi Ravik.Can you attach your actual csv file (replace data with some neutral set of digits in case if you don't want actual data to be exposed) which causes error?Regards,Andrey

Input data has been trancated while taking from csv

12 Replies

TanyaYatskovska
SmartBear Alumni (Retired)
11 years ago

Hi Ravi,

Have you tried specifying the type for each column? Here is the code I specified in the Schema.ini file (I mentioned about it earlier):

[Test.csv]

Format=Delimited(,)

CharacterSet=ANSI

Col1=CurrentNumber Double Width 20

Col2=NewNumber Double Width 20

In TestComplete 9.31, I successfully executed the following sample code that reads data from a CSV file:

//JScript

function CSVDriverExample()

{

DDT.CSVDriver("Test.csv" );

while (! DDT.CurrentDriver.EOF())

{

Log.Message(aqConvert.VarToFloat(DDT.CurrentDriver.Value(0)));

Log.Message(DDT.CurrentDriver.Value(1));

DDT.CurrentDriver.Next();

}

DDT.CloseDriver(DDT.CurrentDriver.Name);

}
RUDOLF_BOTHMA
Community Hero
6 years ago
Hi Ravik

Does the textbox you are trying to type into have a max length? If TC detects that the string you are trying to enter is longer than the max length of the actual text box, that is the kind of message you get. Even if the textbox has a max length of 16, you may still run into an issue because...

TC uses the information supplied by Microsoft on the datatype it detected in the column - in other words, Microsoft guesses, TC believes it. This means a CSV field with 16 numbers in won't be interpreted as a text, but rather a number. This number is larger than an integer though, so ends up being changed to scientific notation e.g. 1.2345678901234E15 That value is interpreted as a string longer than 16 characters. Here two potential ways around this:

1. Use a XLS/XLSX file. That way you can add the single qoute in front of the number e.g. '1234567890123456 and TC will read it as a literal string. If you use source control this isn't the best option though. There is no way to compare the two files. If you are using spreadsheets as data, I would recommend sticking to CSV

2. Use a CSV in conjuction with schema.ini

Microsoft documentation on schema.ini

You need to place the file in the same folder as the CSV and it will override the way TC interprets it from Microsoft.

You should only need to specify the columns that don't behave, so in your case, you could have a CSV with 10 columns, but you only need to specify 2. So, for example:

[MyFile.csv] Format=CSVDelimited ColNameHeader=True MaxScanRows=5 Col9=NumberIn Text Col10=NumberOut Text

Hope that helps
Andrey_M
Contributor
11 years ago
Hi Ravik.

Check the actual length of what TC tries to input into field property with logging like this:

Log.Message( YourValue.length )

or

Log.Message( Len( YourValue ) ) if you use VBS.

It's good idea to log value itself as well.
Ravik
Super Contributor
11 years ago
HI Andrey,

I want to enter at least (min 16 digit ) 16 digit number into a Textbox and I want to get data from csv. actually what happen- When I put 16 digit number like - SetText("1234567890123456") it will be accept and execute by TestComplete but when I move for data drven testing and try to get same number from csv file, Then it is trancate and gives above mention Error
Andrey_M
Contributor
11 years ago
Hi Ravik.

Can you attach your actual csv file (replace data with some neutral set of digits in case if you don't want actual data to be exposed) which causes error?

Regards,

Andrey
Ravik
Super Contributor
11 years ago
Hi

I am attaching the csv file, which is I have use for Data Driven Testing, While I am reading data from Attached csv file it's giving me error (mention on above post).

Not able to attached csv and txt file hence I am putting data here,

CurrentNumber, NewNumber

3466011412316687, 1234567890123456

3466011412316687, 1234567890123456
paul_scroce
Frequent Contributor
11 years ago
The data in the CSV file is comma-separated so the extra space between the numbers will be counted as an extra character.

You can remove the extra spaces from the source data or by using aqString.Trim in your script

http://support.smartbear.com/viewarticle/28278
Ravik
Super Contributor
11 years ago
Hi Paul,

Actually There are no Space between column in actual csv, I have put space for easily understand in post . our actula data is like that. (do You know why data it trancated while reading from csv)

CurrentNumber,NewNumber

3466011412316687,1234567890123456

3466011412316687,1234567890123456
TanyaYatskovska
SmartBear Alumni (Retired)
11 years ago

Hi Ravi,

Are you using the Schema.ini file to set the structure of the CSV file? Make sure that the FixedLength value has the needed length. Refer to this MSDN article for more information.
Ravik
Super Contributor
11 years ago
Sorry Tanya,

I am not understand "Make sure that the FixedLength value has the needed length." What I did, I have Open a Notepad and Enter Data and Save it with csv extention

Like - Test.csv. Now I want to get the number from the Test.csv file. (Our Number is 16 Digit number) TC get the Number from csv but it will be trancated, I want to know Whey it's trancate ?

What is the alternavite, How we can get atleast 16 digit number from csv file.