Appending to CSV

📐 Rule Machine®
1

I am trying to write variables to a CSV file.

Everything works well, except when I append to report it just adds it onto the same line. I'd like for it to append onto a new line (row).

Is there a trick to this?

I am currently getting:

Value 1;value 2;value 3

I want:

Value 1
Value 2
Value 3

Thanks

2

Try adding "\n" to the end of the values, without the quotes.

3

No dice. Now I just see \n at the end of everything.

4

They may be escaping it, try appending the values separately, i.e. separate Actions in the rule.

6

Still seeing it unfortunately

7

Maybe it would be worth posting some screenshots of the rule you are using...

8

Great idea. I agree. I am writing this as a little expiriment and I also have a newborn, lol.

Screenshot_20220417-174318_Edge
Screenshot_20220417-174318_Edge972×3580 244 KB

9

That does help to clarify some of the references throughout the rule :slight_smile:

10

I have been using her frequent nap times to play around with the hub more. My wife hates it.

1 Like
11

I'm not sure what to suggest myself, apart from separating out those append calls. Hopefully someone else has experience in this.

1 Like
12

In the area of the rule where you type the text you want to append, hit "enter" to move the cursor to the next line then save.

13

That was what I had tried first.

Is it possible it is not working because I am on mobile?

14

Perhaps... the method I described works for me.

15

So I do it at the end of each statement to make room for the next? Not at the start?

16

At the end... let me see if i can get a screenshot...

EDIT:

Capture
Capture722×158 9.71 KB

Notice that my text cursor is on line 2.

3 Likes
17

Initial testing suggests this has done the trick. I'll let the overnight component run, and then update tomorrow! Thank you.

2 Likes
18

It works great.

I would note that doing this on mobile did not work for whatever reason. It had to be done on a laptop.

2 Likes
19

That could be a difference in the use of carriage return / line feed characters between your mobile and laptop. If you are keen to work it out you could try opening the file in a text editor that allows for display of those system characters to understand which one's are used. But I would expect that now you have a solution, probably not worth it...

20

I'm not currently very interested in the mechanics of it.

Mostly just documenting in case some other poor bloke stumbles into this thread with the same problem.

1 Like
21

Me too :grin: