berkaykaya Posted November 26, 2018 Report Share Posted November 26, 2018 (edited) Hi everyone, We want to report the data records that we keep daily via e-mail at the end of the day. We have implemented the shipment with the help of examples but we have problems sending the data records in the form of an excel report. Columns and rows are interfering. Thanks for yours support ... Edited November 26, 2018 by berkaykaya Added visual. Quote Link to comment Share on other sites More sharing options...
MVP 2022 Joe Tauser Posted November 28, 2018 MVP 2022 Report Share Posted November 28, 2018 Can you show an example of "interfering"? Joe T. Quote Link to comment Share on other sites More sharing options...
berkaykaya Posted November 28, 2018 Author Report Share Posted November 28, 2018 A:Alarm Number B:Date C:Alarm Hour D:Alarm Type Trust me we try everything Thanks for your time. Quote Link to comment Share on other sites More sharing options...
berkaykaya Posted December 3, 2018 Author Report Share Posted December 3, 2018 Is there anyone can help? Quote Link to comment Share on other sites More sharing options...
Gabriel Franco Posted December 3, 2018 Report Share Posted December 3, 2018 I suggest to check CSV file using a text editor. It could be a separator and regional settings issue Quote Link to comment Share on other sites More sharing options...
berkaykaya Posted December 3, 2018 Author Report Share Posted December 3, 2018 We keep trying. We will provide positive or negative information. Quote Link to comment Share on other sites More sharing options...
MVP 2022 Joe Tauser Posted December 3, 2018 MVP 2022 Report Share Posted December 3, 2018 Something isn't right - the delimiters you're specifying are not appearing in your excel sheet. Post your program and one of the .csv files it makes. Joe T. Quote Link to comment Share on other sites More sharing options...
berkaykaya Posted December 4, 2018 Author Report Share Posted December 4, 2018 I cant find our last .csv file but i attached same .csv file. We try everything but we cant find our solution. @Gabriel Franco Sir,i dont understand what you mean.We looking with mail inbox or SD Card Suit "Data Table Editor" but they are same mixed view. YuksekGerilimTestiR3.vlp TEST16.csv TEST14.csv Quote Link to comment Share on other sites More sharing options...
MVP 2022 Ausman Posted December 4, 2018 MVP 2022 Report Share Posted December 4, 2018 The program has many things that I would do differently, particularly layout of elements. In rung 6 you've got 2 resets of MB28. So perhaps there is a similar overlooked hiccouph elsewhere that is upsetting what you want to achieve. However, to your specific issue (and I can't see that this observation will make a difference but it's worth a try), in rung 41 SD Utility you are referencing MI62 twice...looking at other parts of the program perhaps one of these should be MI6? Perhaps the double reference is confusing things? Regardless, what happens if you change your delimiters to << , >> (2C) ? I think this is partly what Gabriel is getting at. cheers, Aus Quote Link to comment Share on other sites More sharing options...
berkaykaya Posted December 4, 2018 Author Report Share Posted December 4, 2018 Thank you very much for your time. I fixed my mistakes and I'll try again. I'il write the results. If you change the delimiter to <<, it continues to write to the same column in excel as it should pass to the column. Sometimes it should pass to the bottom line, but not going the bottom line. It is very sad that there is no clear explanation for this. I can say that I have tried every way in the figures mentioned in the documents. Sorry for my language. Respect for you,Berkay Quote Link to comment Share on other sites More sharing options...
Gabriel Franco Posted December 4, 2018 Report Share Posted December 4, 2018 I see no problem with csv files other than spaces added. You are using MI62 twice in fields to add file. Why?. For debuging purposes, I suggest manually enable rung 41, instead of SB13. Keep in mind that, SD operations may take a while and trying to add a new record every second may not be possible. You may try also numeric field for all those numeric values, instead of indirect text. Quote Link to comment Share on other sites More sharing options...
berkaykaya Posted December 5, 2018 Author Report Share Posted December 5, 2018 @Gabriel Franco Thanks for your reply. I fix MI62 mistake,@Ausman right; 18 hours ago, Ausman said: MI62 twice...looking at other parts of the program perhaps one of these should be MI6? I attached last test mail,if i use the delimiters "2C" it continues to write to the same column in excel as it should pass to the column. TEST25-2C.csv Quote Link to comment Share on other sites More sharing options...
MVP 2022 Ausman Posted December 5, 2018 MVP 2022 Report Share Posted December 5, 2018 OK. Didn't think it would solve the issue. Did you try changing the write to a manual trigger like Gabriel suggested? Change things so that the write only occurs on some input you do manually. Then do this a few times with a space of 10 seconds, say. Then see if the write is ok. If you can't get to the bottom of this, perhaps consider changing what you are doing. Store data into a table, then periodically copy the entire table into a udt file on the SD, and then manually retrieve that from the plc on a scheduled basis. But I'd persevere with this first, it will likely be something simple. I seem to recall a line count somewhere, is that correctly rolling over? cheers, Aus Quote Link to comment Share on other sites More sharing options...
berkaykaya Posted December 5, 2018 Author Report Share Posted December 5, 2018 Yes,i set-reset manual in Online Mode and I did all the steps in sequence and i set delimiters like a picture. Finally i think we made it! (TEST32) But there are small problems... If you can look (TEST33),there are problems going to the bottom line. TEST32.csv TEST33.csv Quote Link to comment Share on other sites More sharing options...
MVP 2022 Ausman Posted December 5, 2018 MVP 2022 Report Share Posted December 5, 2018 That's great, but I can't help today, too busy. Others will. If not....I'll Be Back!!! Just for your own knowledge, I would play with SD card Explorer and see for yourself how slow the SD card interaction is. Anything that uses the SD sometimes doesn't work as you would expect. Same thing with anything that uses buffers.....might always need a few more scans after saying it is ok. cheers, Aus Quote Link to comment Share on other sites More sharing options...
MVP 2022 Joe Tauser Posted December 7, 2018 MVP 2022 Report Share Posted December 7, 2018 I opened both the files and there is only one line. Are there supposed to be more? Also, type out in your post what a line is supposed to look like in the .csv file. Joe T. Quote Link to comment Share on other sites More sharing options...
berkaykaya Posted December 7, 2018 Author Report Share Posted December 7, 2018 I attached what i mean; First Column:Alarm Number Column 1:Alarm Date Column 2:Alarm Clock Column 3:Alarm Type Excel - Test.xlsx Quote Link to comment Share on other sites More sharing options...
MVP 2022 Joe Tauser Posted December 10, 2018 MVP 2022 Report Share Posted December 10, 2018 I looked at the program you posted on Monday and noticed that your SD Create Line block was stomping on itself - you had the beginning of the vector at MI 15 and the number of bytes register at MI 16. You have the Max vector length set as 100 bytes, so you have to have a block of 50 sequential MIs that you don't do anything else with. Pick a block high in the MI memory - it doesn't matter where. I use the drop-down box in the MI selector to put the same descriptor on several MIs at once- Post your latest program that was used to create TEST33.csv. Joe T. Quote Link to comment Share on other sites More sharing options...
berkaykaya Posted December 10, 2018 Author Report Share Posted December 10, 2018 Firstly,thank you for your reply and your time.. You are right i must make a space MI's. This week im out the office,when i back the office i will try your soluitons. Thank you Joe.. YuksekGerilimTestiR3-Sadece Mail.vlp Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.