AGG Software Forums

Hello,
Can I include the file name in the ASCII contents when I'm importing the ASCII file? Or can I only capture the contents of the file that was modified?

Also after capturing the file name can I convert it to a corresponding number and export it to the MySQL database?

Can I do these 2 things?

Thanks

Hello,

Could you explain your needs a bit more (by example)?

Hi Arthur, let me explain a bit more.

I have an ASCII file which a line is written every X seconds into it. I collect this line using DataLoggerSuite every time it is written in ASCII file. What I need from this point are 2 things:

1) Insert in the line which I am collecting the name of the ASCII file that was collected. For example I have collected a row with two columns from file Example.txt. Then the contents of this file will be 100,200 (two columns by CSV). By collecting this line with DataLoggerSuite I need to add in this row the file name, in this case it looks like this: Example,100,200 (file name + two columns originally collected from ASCII file).

2) Now I need to convert the file name that I have added in the row ("Example" in this case) to a preset value so I can export this value to the database and not the file name. Suppose that Example (file name that I have collected) corresponds to value 1 then I will export to the database the following line: 1,100,200

Can I do these two procedures? Or at least one of them?

Thanks

I'm sorry, but both things are not possible.

Arthur, see whether you can get some idea, I have a folder with multiple ASCII files. I'll export their content to a database. But I need to add a value in the table for each different file exported. Is there any way to add some data in the database additionally to the existing data in ASCII file? Or I can only export to database only those data extracted from the ASCII file?

ASCII codes are important for security purpose.