gents,

I have s7-1200 PLC with hmi comfort panel and TIA v14.

I have following process to check:

- operator scan barcode from first component

- operatos scan barcode from second component

- PLC chcecks if those components are supposed to work together and allows prodution if they do

Assignment of components working together will be delivered as table in csv file.

Now I need to somehow import this csv file into DB to compare them with codes from scanners.

Any ideas how to do it?

I thought to import this csv into hmi panel USB port, but then I don't know how to get all recepies into DB.

please advise.

regards

tomasz

Hi,

One thing you could do is to write a VB script and read the file from USB. Read which ever columns you need and write those to some tags connected to a DB.

This way you can easily get only the stuff you need in DB.

hi,

thanks for rapid reply.

unfortunatelly i'm not familiar with VB, so maybe there is a way to do it using standard functions.

regards

tomasz

Hi,

You could try to import it as recipe from PLC MMC, i do not know exactly how it works or if it is possible. There is a link.

https://support.industry.siemens.com/cs/attachments/109479727/109479727_Persistente_Daten_DOKU_v10_en.pdf

You can also read it from PLC MMC with block FileReadC. I have used this and FileWriteC and these work. Then you need to arrange your data in PLC program.

I do not know any other ways to do it. And the those mentioned i do not like. Hopefully someone knows some ready made solution on HMI side.

What kind of structure you have in your csv? Rows, Columns, Header?. Rows or header does not even matter, if the data you want is in same columns in every csv, structure is simple. 

If csv's are consistent and only amount of rows can vary, i would write a script. Even if you are not familiar with scripting. It is pretty easy to learn. Reading a file usually does not need much code.

hi,

solution that You gave link to, is interesting, but I'll have csv in USB connected to HMI panel, so it is unfortunatelly not my case.

structure of csv i can decide,so it is not a problem.

maybe someone alse can drop some ideas?

tomasz

I had to test my own suggestion of a script. In case there is no better solution,something like that could be used. I attached pdf with pictures. It is not meant to be excellent script and it has some unneeded code in it.

Script reads csv file with header line and as many rows and columns there are. Values are integers but those can be easily edited to strings, have to use multiplexing though. 

thank You very much for taking efford to make this script.

i'll test it in near future and place my feedback over here.

best regards

tomasz

Dear K_Ohjus,

I'm trying to implement Your solutiion and I'm facing first problem:

As I understand:

- DB block name is "FromCsv"

- In DB there is a array of Strings named "lines"

- there is internal tag in HMI tags named "index"

- I should create HMI tag "fromCsv_lines" that will be single array line depending of index value

I have problem with creating this HMI tag fromCsv_lines" with adress as You have in Your example - it is nt accepted - please see attached picture and kindly advise.

best regards

tomasz

Hi,

I attached string multiplexing instructions. It is only way to access string array index with variable. So if data that you need is strings instead of ints or reals, you need to use multiplexing. 

I only read whole lines from csv to see what kind of structure it has. With mine it is simplest possible like 3333;3333 then i know what i need to do with the data to get what i want. It could be something like "hdsd553", "ssd5621". Then i would need to do some extra work to get the data.

Thank You very much for explanation.

I'll test it once I've some panel available.

I have one more question - I can see that variable "dataString" is a string that contains every line from file - is there a limitation of number of characters that "dataString" can handle?

What I mean is - can this script handle csv file that have for example 150 rows / 30 characters each row?

regards

Tomasz