When I run macro which there is ${!csvReadMaxRow}
the log has [error][ignored] Internal variable “!CSVREADMAXROW” not supported
When I run macro which there is ${!csvReadMaxRow}
the log has [error][ignored] Internal variable “!CSVREADMAXROW” not supported
can you share macro?
would like to see the flow
2026-11-17-myoceancity-prjcount.zip (2.9 KB)
2026-11-17-myoceancity-prjcount.zip (2.9 KB)
run macro with this file
but I need 2 record columns
test with this file
2026-11-17-myoceancity-prjcount.zip (3.0 KB)
nothing changes
nothing changes
can you show error?
issue is with 2026-11-17-myoceancity.csv now
[info]
Executing: | csvRead | 2026-11-17-myoceancity-prjcount.csv | |
[info]
Macro completed (Runtime 0.28s, 100% local execution, no cloud used)
[info]
Executing: | csvRead | 2026-11-17-myoceancity.csv | |
[error][ignored]
Line 21: Invalid Closing Quote: got “X” at line 6 instead of delimiter, record delimiter, trimable character (if activated) or comment
[info]
Macro completed (Runtime 0.25s, 100% local execution, no cloud used)
2026-11-17-myoceancity.zip (8.3 KB)
I deleted Line 6 and now it doesnt give error
[info]
Executing: | csvRead | 2026-11-17-myoceancity.csv | |
[info]
Macro completed (Runtime 0.33s, 100% local execution, no cloud used)
There are over 200 lines in csv. So the runtime will over 1s. I run the other macro with 100 lines csv, the runtime is near 60s
My log
2026-11-18T17:14:16.951Z - [status] Playing macro nha1001-myoceancity-subproject-count
2026-11-18T17:14:17.037Z - [info] Executing: | store | nodisplay | !replayspeed |
2026-11-18T17:14:17.098Z - [info] Executing: | store | true | !ErrorIgnore |
2026-11-18T17:14:17.105Z - [info] Executing: | selectWindow | tab=open | Thông tin dự án - Hệ thống hỗ trợ bán hàng Ocean City |
2026-11-18T17:14:20.737Z - [info] Executing: | pause | 2000 | |
2026-11-18T17:14:22.745Z - [info] Executing: | executeScript | var d= new Date();
var m=((d.getMonth()+1)<10)?‘0’+(d.getMonth()+1):(d.getMonth()+1);
return d.getFullYear()+“-”+m+“-”+d.getDate(); | time3 |
2026-11-18T17:14:22.775Z - [info] Executing: | store | Project name | !csvline |
2026-11-18T17:14:22.780Z - [info] Executing: | store | Sub project count | !csvline |
2026-11-18T17:14:22.785Z - [info] Executing: | store | Project link | !csvline |
2026-11-18T17:14:22.789Z - [info] Executing: | store | Project square (ha) | !csvline |
2026-11-18T17:14:22.793Z - [info] Executing: | store | Project address | !csvline |
2026-11-18T17:14:22.797Z - [info] Executing: | store | Sub project link | !csvline |
2026-11-18T17:14:22.804Z - [info] Executing: | csvSave | ${time3}-myoceancity-subproject-count.csv | |
2026-11-18T17:14:22.864Z - [info] Executing: | csvRead | 2026-11-17-myoceancity-prjcount.csv | |
2026-11-18T17:14:22.913Z - [error][ignored] Invalid Record Length: expect 2, got 1 on line 16
2026-11-18T17:14:22.915Z - [info] Executing: | times | ${!csvReadMaxRow} | |
2026-11-18T17:14:22.917Z - [error][ignored] Internal variable “!CSVREADMAXROW” not supported
2026-11-18T17:14:22.920Z - [info] Executing: | comment | selectWindow // tab=close | |
2026-11-18T17:14:22.926Z - [info] Macro completed (Runtime 5.89s, 100% local execution, no cloud used)
2026-11-18T17:14:22.864Z - [info] Executing: | csvRead | 2026-11-17-myoceancity-prjcount.csv | |
2026-11-18T17:14:22.913Z - [error][ignored] Invalid Record Length: expect 2, got 1 on line 16
There is problem with your CSV
How did you create it?
Try Google Sheets to create CSV file
I also uploaded CSV earlier