DL3021 won't import the CSV

[v8dave]

I can get my DL3021 to import a CSV with the LIST settings that I want to run within the Ultra Load software. I am trying to run a test on a battery to see how long it will last repeating the same sequence.

It detects that there is 32 lines but the columns for the value are all blank.

I first created a CVS by exporting a list using the create button to check on the data format. It's not very nice and I ended up with loads of extra spaces.

This is what my CSV looks like when I view with a text editor.

Code: [Select]

Step,Mode,Range,Value(A),Time(s),Slew(A/us)
1,CC,6A,0.02,30,0.1
2,CC,6A,0.15,1,0.1
3,CC,6A,0.02,0.5,0.1
4,CC,6A,0.15,1,0.1
5,CC,6A,0.02,0.5,0.1
6,CC,6A,0.15,1,0.1
7,CC,6A,0.02,0.5,0.1
8,CC,6A,0.15,1,0.1
9,CC,6A,0.02,0.5,0.1
10,CC,6A,0.15,1,0.1
11,CC,6A,0.02,0.5,0.1
12,CC,6A,0.15,1,0.1
13,CC,6A,0.02,0.5,0.1
14,CC,6A,0.15,1,0.1
15,CC,6A,0.02,0.5,0.1
16,CC,6A,0.15,1,0.1
17,CC,6A,0.15,1,0.1
18,CC,6A,0.02,0.5,0.1
19,CC,6A,0.15,1,0.1
20,CC,6A,0.02,0.5,0.1
21,CC,6A,0.15,1,0.1
22,CC,6A,0.02,0.5,0.1
23,CC,6A,0.15,1,0.1
24,CC,6A,0.02,0.5,0.1
25,CC,6A,0.15,1,0.1
26,CC,6A,0.02,0.5,0.1
27,CC,6A,0.15,1,0.1
28,CC,6A,0.02,0.5,0.1
29,CC,6A,0.15,1,0.1
30,CC,6A,0.02,0.5,0.1
31,CC,6A,0.15,1,0.1
32,CC,6A,0.02,300,0.1
Anyone been able to load a CSV file into this software before?

[v8dave]

I figured it out. It requires a TAB character in front of each value. Using tab delimiter format from Excel doesn't work.

You have to manually edit the CSV file after you export it. Lucky my table wasn't too large.

Code: [Select]

Step, Mode, Range, Value(A), Time(s), Slew(A/us),
1, CC, 4A, 0.02, 30, 0.1,
2, CC, 4A, 0.15, 1, 0.1,
3, CC, 4A, 0.02, 0.5, 0.1,
4, CC, 4A, 0.15, 1, 0.1,
5, CC, 4A, 0.02, 0.5, 0.1,
6, CC, 4A, 0.15, 1, 0.1,
7, CC, 4A, 0.02, 0.5, 0.1,
8, CC, 4A, 0.15, 1, 0.1,
9, CC, 4A, 0.02, 0.5, 0.1,
10, CC, 4A, 0.15, 1, 0.1,
11, CC, 4A, 0.02, 0.5, 0.1,
12, CC, 4A, 0.15, 1, 0.1,
13, CC, 4A, 0.02, 0.5, 0.1,
14, CC, 4A, 0.15, 1, 0.1,
15, CC, 4A, 0.02, 0.5, 0.1,
16, CC, 4A, 0.15, 1, 0.1,
17, CC, 4A, 0.02, 0.5, 0.1,
18, CC, 4A, 0.15, 1, 0.1,
19, CC, 4A, 0.02, 0.5, 0.1,
20, CC, 4A, 0.15, 1, 0.1,
21, CC, 4A, 0.02, 0.5, 0.1,
22, CC, 4A, 0.15, 1, 0.1,
23, CC, 4A, 0.02, 0.5, 0.1,
24, CC, 4A, 0.15, 1, 0.1,
25, CC, 4A, 0.02, 0.5, 0.1,
26, CC, 4A, 0.15, 1, 0.1,
27, CC, 4A, 0.02, 0.5, 0.1,
28, CC, 4A, 0.15, 1, 0.1,
29, CC, 4A, 0.02, 0.5, 0.1,
30, CC, 4A, 0.15, 1, 0.1,
31, CC, 4A, 0.02, 300, 0.1,


[maukka]

That's a strange requirement for a comma separated value file.

Anyways, you can easily use a text editor to search and replace every occurence of "," with ",[TAB]". Even the default Windows Notepad works if you just copy a tab beforehand and paste it in the "replace with" field.