| Author |
Message |
    
Okkamogaadu
Pilla Bewarse
Username: Okkamogaadu
Post Number: 353
Registered: 02-2005
Posted From: 164.64.248.174
| | Posted on Friday, December 30, 2005 - 2:39 pm: |    |
Ok I even got that mama
thx a lott...
U made my day grt ofcourse others too..
anantam ee payanam, avisraantam mee poraatam, madama tippani nee naijam, aluperugani nee payanam. Anna neeve naaku aadarsam. |
Okkamogaadu
Pilla Bewarse
Username: Okkamogaadu
Post Number: 352
Registered: 02-2005
Posted From: 164.64.248.174
| | Posted on Friday, December 30, 2005 - 2:37 pm: | |
babu mama
One small doubt I will get many files like this and I need to process all the files one by one..
in the schema.ini I mentione first filename and next as per the syntax column name <datatype> <columnwidth> etcc
but while executing the dotnet code...
while establishing the connection here Im not mentioning the file name where as I mention the text file name with the SQL statement. So here my doubt is if I mention the text file name in the sql statement whether the process look for the file name that is mentioned in the schema.ini file and will it take the way I defined the columns definition under that file.
and how can I include that schema.ini file in the source code.
anantam ee payanam, avisraantam mee poraatam, madama tippani nee naijam, aluperugani nee payanam. Anna neeve naaku aadarsam. |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 7282
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Friday, December 30, 2005 - 2:34 pm: | |
cool mama  |
Okkamogaadu
Pilla Bewarse
Username: Okkamogaadu
Post Number: 351
Registered: 02-2005
Posted From: 164.64.248.174
| | Posted on Friday, December 30, 2005 - 2:33 pm: | |
yes babu mama
so Im in the process of creating it.
thx 1s again 2 U mama by initiating by saying schema.ini
anantam ee payanam, avisraantam mee poraatam, madama tippani nee naijam, aluperugani nee payanam. Anna neeve naaku aadarsam. |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 7281
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Friday, December 30, 2005 - 2:32 pm: | |
so schema.ini file use cheyyali kadha mama. |
Okkamogaadu
Pilla Bewarse
Username: Okkamogaadu
Post Number: 350
Registered: 02-2005
Posted From: 164.64.248.174
| | Posted on Friday, December 30, 2005 - 2:30 pm: | |
babu mama
I got the solution
here is the link
http://www.aspdb.com/tornadoManual/_CsvText.html
thx for all of U brothers
anantam ee payanam, avisraantam mee poraatam, madama tippani nee naijam, aluperugani nee payanam. Anna neeve naaku aadarsam. |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 7279
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Friday, December 30, 2005 - 2:27 pm: | |
om mama
see this link if it cud help u
http://msdn.microsoft.com/library/default.asp?url= /library/en-us/dnclinic/html/scripting03092004.asp |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 7278
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Friday, December 30, 2005 - 2:23 pm: | |
om mama thats where u define schema.ini file..
in this u define the lenghts of each column and this file wud be present in the samelocation where the txt files r located..
gimme some time..i will see if i cud give u any link |
Okkamogaadu
Pilla Bewarse
Username: Okkamogaadu
Post Number: 349
Registered: 02-2005
Posted From: 164.64.248.174
| | Posted on Friday, December 30, 2005 - 2:22 pm: | |
asalu itlaa fixed length files ki FileSystemObject dwars easy ga problem solve avuddi...
emito ilaa rasi sachharu appudu gippudu naaku solution telisina seppina evaru inatam ledu and Y do we re-write the code antunnaru...
anantam ee payanam, avisraantam mee poraatam, madama tippani nee naijam, aluperugani nee payanam. Anna neeve naaku aadarsam. |
Okkamogaadu
Pilla Bewarse
Username: Okkamogaadu
Post Number: 348
Registered: 02-2005
Posted From: 164.64.248.174
| | Posted on Friday, December 30, 2005 - 2:21 pm: | |
babu mama
if I used FixedLength as U said how the system knows first column is from 1st position to 15th and second column is from 15th to 25th and 3rd from so and so on..
anantam ee payanam, avisraantam mee poraatam, madama tippani nee naijam, aluperugani nee payanam. Anna neeve naaku aadarsam. |
Okkamogaadu
Pilla Bewarse
Username: Okkamogaadu
Post Number: 347
Registered: 02-2005
Posted From: 164.64.248.174
| | Posted on Friday, December 30, 2005 - 2:19 pm: | |
gade kada eeda naaku problem hemant mama
deentalli ee maintenance lo work sette gide problem...
manaku full rights ivvaru and vachhe problems emo gitla untaai.. emti naa bad time...
anantam ee payanam, avisraantam mee poraatam, madama tippani nee naijam, aluperugani nee payanam. Anna neeve naaku aadarsam. |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 7277
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Friday, December 30, 2005 - 2:19 pm: | |
om mama
i think ..u need to use a schema.ini file.
and for the delimited property
use "FixedLength" |
Hemanth
Desanike Pedda Bewarse
Username: Hemanth
Post Number: 11660
Registered: 03-2004
Posted From: 63.110.106.226
| | Posted on Friday, December 30, 2005 - 2:14 pm: | |
production lo source code lekapothe ela mama, ippudu edanna change cheyyalanna, enhance cheyyalanna ela mama?? |
Okkamogaadu
Pilla Bewarse
Username: Okkamogaadu
Post Number: 346
Registered: 02-2005
Posted From: 164.64.248.174
| | Posted on Friday, December 30, 2005 - 2:05 pm: | |
yes babu
I got a chance to see and the same file Im using here in the development server.
anantam ee payanam, avisraantam mee poraatam, madama tippani nee naijam, aluperugani nee payanam. Anna neeve naaku aadarsam. |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 7274
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Friday, December 30, 2005 - 2:01 pm: | |
om mama
did u get a chance to look at the text files used in the production system
and
r u sure abt the delimiter in the text files like 1- 15 and 16-25 ?? |
Okkamogaadu
Pilla Bewarse
Username: Okkamogaadu
Post Number: 345
Registered: 02-2005
Posted From: 164.64.248.174
| | Posted on Friday, December 30, 2005 - 2:01 pm: | |
production lo only required files unnai i.e aspx and exe's no source code
aa donga sachhinodu elaa raasado 2002 lo gippudu naa dimaak kharab setta unnadi..
malla nenu raasta ante ma PM malla enduku raayadam already production lo work avutunnadi
so we need to find some how antunnadu...
ento anta ishnu maaya...
source code lekunda production lo unnadi ela work avutunnadi teluskovdam elaa chepma....
anantam ee payanam, avisraantam mee poraatam, madama tippani nee naijam, aluperugani nee payanam. Anna neeve naaku aadarsam. |
Vytwo
Vooriki Bewarse
Username: Vytwo
Post Number: 3378
Registered: 01-2005
Posted From: 162.119.64.118
| | Posted on Friday, December 30, 2005 - 2:00 pm: | |
production data ala evaru emo mama.
hemanth mama.
security .
live Life like sinna. |
Hemanth
Desanike Pedda Bewarse
Username: Hemanth
Post Number: 11659
Registered: 03-2004
Posted From: 63.110.106.226
| | Posted on Friday, December 30, 2005 - 1:58 pm: | |
production copy thesukoni development(test) dantlo ki pedathaniki leda mama?? |
Okkamogaadu
Pilla Bewarse
Username: Okkamogaadu
Post Number: 344
Registered: 02-2005
Posted From: 164.64.248.174
| | Posted on Friday, December 30, 2005 - 1:55 pm: | |
hi
I have got a strange problem. May I know any solution for this.
Here is the detailed description about the problem
We have got a mainframe system and also production and development server.
There was an application in the production server since 3 years and was working fine. Recenlty we got into stucked up with this problem. Every night the mainframe generates few text files and thru FTP it sents those files to production server.
In the production server application we do have got few jobs (i.e dotnet application) that reads this text file(s) and the data from these text files will be stored in our sql server DB for the use of web applications.
Now the jobs in the development server (which we are using for testing) got creating problems like "Invalid index" and stoping the process further. After examining the problem in respective dotnet application i got to know the problem where it is but I am surprised to see that the same application working fine in production server since few years.
I dont have the source code of dotnet application which is running in the production server. But I do have source code of dot net application that is in development server.
Here in the dot net application I am able to see the source code and it is being written like this...the algorithm as follows.
1. Dynamically getting the connection string (i.e. Provider=Microsoft.jet.oledb.4.0;Data source=C:\myapp;Extended Properties=Text;)
2. Establishing oledb connection.
3. Dynamically constructing the SELECT stmt with respective txt file ex "select * from members.txt" (here the members.txt file is from Mainframe and stored in C:\myapp folder)
4. Using OLEDB Command object executing the about SELECT statement and returning back to OLEDBDataReader object back to the caller.
5. In the caller function the person who written the code directly referring values from the reader as objReader.getvalue(0), objReader.getvalue(1)... so on.
6. Now the problem is after executing the command object in the reader I am able to see only one column i.e objReader.getvalue(0). Its because
the entire one line of the text file is coming in one column (but it suppose to split in to multiple columns)
7. Its generating an exception when the code refers second column on wards.
8. Here I donno wat is the delimeter for knowing columns in the text file.
9. I do see few spaces between values in the text files.
10. Here my doubt is if the code is compiled like this how its running fine in the production server.
11. Or if I wann change code in the development server how could I do that. After I seached in internet in the while generating the connection string in the extended properties I have to mention lie this..
"Extended Properties=Text;HDR=No;delimited=TabDelimited" This is in case of the text file content was delimited by tab
Where as here I am thinking that its not delimited by TAB and also thinking that it might be delimited by no of characters example.. first column is 15 characters and from 16th character on wards its second column until 25th character etc.... in this case how and wat value should I mention in the delimited property?
can any one of you enlighten me on this.
I am desperately looking for valuable suggestions.
Thanks in advance...
anantam ee payanam, avisraantam mee poraatam, madama tippani nee naijam, aluperugani nee payanam. Anna neeve naaku aadarsam. |
