[PLUGIN] CSV, CSV2Array, CSV2Dictionary

Post your completed addons to share with the community

Post » Fri Apr 05, 2013 1:19 am

Update

Support save/load system.
B
97
S
22
G
178
Posts: 4,121
Reputation: 104,049

Post » Thu May 09, 2013 3:15 pm

I have a few questions.

I understand that you can get data from row & col but can I also get data from the whole col or row.

example:

this is a part of my csv

,tankname,year,point,nation
Tanknr.1,Panzer IIC,L1939,13,DE
Tanknr.2,Panzer III-E,L1939,21,DE
Tanknr.3,Panzer II-F,E1940,15,DE
Tanknr.4,Panzer III-F,E1940,23,DE
Tanknr.35,Carro M11/39,E1940,13,IT
Tanknr.36,Fiat L6/40,E1940,10,IT
Tanknr.37,Carro M13/40,E1940,14,IT
Tanknr.38,Semovente L40,E1940,10,IT
Tanknr.39,Carro M15/42,E1942,18,IT

Lets say I want to see my tanks from E1940 from the nation DE.
so I would need a drop down list were I can set the year and nation. and then the tanks would have to appear in a drag drop box with all the tank data like armor, firepower, speed etc..

could you show me how to do this?
B
3
Posts: 3
Reputation: 206

Post » Fri May 10, 2013 5:01 am

@Murat

Use "condition:For each row" to travel all rows.
B
97
S
22
G
178
Posts: 4,121
Reputation: 104,049

Post » Fri May 10, 2013 11:58 am

I dont know how to use the condition for each row. What action should come after this condition to make it appear on a list? I used CurCol in add item to list. It does not work. Can I do something with the At action?

like At("year", row all) something like that?
B
3
Posts: 3
Reputation: 206

Post » Fri May 10, 2013 4:08 pm

@Murat

Capx - for each row
[code]+ CSV: for each row
- Text: append text to CSV.At("nation", CSV.CurRow)[/code]rexrainbow2013-05-10 16:08:52
B
97
S
22
G
178
Posts: 4,121
Reputation: 104,049

Post » Fri May 10, 2013 7:04 pm

@rexrainbow

Ok, so I need to start with the for each row condition to make it work.

now im trying to get all the tank names in a separate text. Do I need to use the for each col condition to make the csv look for the tanks from a specific nation and year?

Im trying things out, so far Im braking firefox.
B
3
Posts: 3
Reputation: 206

Post » Mon May 20, 2013 4:37 am

Update:

Expression:At now has 3 modes.
1. CSV.At(col, row) - get date by (col, row) from current page.
2. CSV.At(col, row, page) - get date by (col, row) from target page.
3. CSV.At(col, row, page, default value) - get date by (col, row) from target page. Return default value if the target entry is invalid.
B
97
S
22
G
178
Posts: 4,121
Reputation: 104,049

Post » Sun May 26, 2013 11:47 pm

excel to csv
A tool for transferring excel file to csv text file, each page will create one csv text file.

Usage:
1. download this 7z file. unzip it
2. edit run.bat file, ths format is
[code]excel2csv excel_filename[/code]
(You might put excel file in the same folder.)
3. double click run.bat.

Or, drag the excel file onto excel2csv.exe directly.



There is a testing run.bat and an excel file inside this 7z file.
rexrainbow2013-05-27 10:15:16
B
97
S
22
G
178
Posts: 4,121
Reputation: 104,049

Post » Fri May 31, 2013 11:41 am

Really simple question I'm hoping. :) How do I load the file which I'll be manipulating with this plugin in the first place? I'm not seeing a load file, just load from json. Is there a way to load a csv file with this plugin or do I need a different plugin to load the file first?
B
68
S
21
G
15
Posts: 701
Reputation: 15,604

Post » Fri May 31, 2013 3:26 pm

@lanceal

"Action: Load table from csv string" , see first post of this thread.
B
97
S
22
G
178
Posts: 4,121
Reputation: 104,049

PreviousNext

Return to Completed Addons

Who is online

Users browsing this forum: No registered users and 0 guests