Send Excel via Mail with the help of SD card

[berkaykaya 0]

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.

[Joe Tauser 312]

Can you show an example of "interfering"?

Joe T.

[berkaykaya 0]

 

A:Alarm Number

B:Date

C:Alarm Hour

D:Alarm Type

Trust me we try everything  

Thanks for your time.

[berkaykaya 0]

Is there anyone can help?

[Gabriel Franco 17]

I suggest to check CSV file using a text editor. It could be a separator and regional settings issue

[berkaykaya 0]

We keep trying.

We will provide positive or negative information.

[Joe Tauser 312]

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.

[berkaykaya 0]

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

[Ausman 163]

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

[berkaykaya 0]

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

[Gabriel Franco 17]

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.

 

[berkaykaya 0]

@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

[Ausman 163]

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

[berkaykaya 0]

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

[Ausman 163]

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

[Joe Tauser 312]

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.

[berkaykaya 0]

I attached what i mean;

First Column:Alarm Number

Column 1:Alarm Date

Column 2:Alarm Clock

Column 3:Alarm Type

 

Excel - Test.xlsx

 

[Joe Tauser 312]

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.  

[berkaykaya 0]

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