Jump to content

Store DTI to file - Append not working with "Only csv"


Sandy

Recommended Posts

Hi,

I'm trying to build a log for my system using the Store DTI to File function. This runs after the struct containing the date is inserted into row 0 of a table, which should be appended immediately to the log file. The writes are sufficiently spaced (~30 minutes) that the SD write interval isn't an issue.

I've found that when using option 2 "Only CSV" for the "Create CSV" input (F), the file is simply overwritten, and only ever contains 1 row. Option 1 "Create CSV  File (All - udtf,csv,csv.zip)" does append correctly.

In both cases "Append to File" (E) is set to 1 "Data will be appended to the file".

This looks like a bug to me, and combined with the missing documentation for those options, I've wasted a little more time than I'd like trying to figure that out. Option 1 is an acceptable workaround, so I don't need further support, but this should be fixed.

Sandy

Link to comment
Share on other sites

Dear Sandy,
For now you have to use "1" in "F" parameter in order to get the CSV you want as a workaround. I will check the issue.

Note:
'Store DT To File' Ladder utility:

  • Parameter in
    • A, Data Table to store
    • B, Start row in store file
    • C, Target file name
    • D, Number of rows
    • E, Append to file (0 – Overwrite, 1 – Append)
    • F. Create CSV (0 - No CSV, 1 – All files, 2 – Only CSV, 3 – Only CSV.zip)
    • G, CSV file delimiter
       
  • Parameter out
    • H, status
Link to comment
Share on other sites

  • 2 months later...
  • 1 year later...

I may be wrong, but it seems to me that the file on the SD card that contains the raw DT data saved, are the UDTF files.
The CSVs are just "copies". If you want to make an "append", you will have to read the DT on the SD, via the UDTF file (which will be automatic).
Then the UDTF file will be written with a new line, and the CSV will be copied from this new UDFT (the timing may be different).
IF the UDTF does not exist... it will be as if the CSV is empty.
At least that's how I understood it.

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...