[PLUGIN] CSV, CSV2Array, CSV2Dictionary

Post your completed addons to share with the community

Post » Thu Jan 23, 2014 7:58 pm

So am I correct in thinking this plugin basically just uses excel as an input area, then saves as a .csv for formatting, from which you copy and paste into Construct 2 in the LOAD table action? And from then on you no longer need excel to edit?

How much data can be stored? How many rows, columns? What's the advantage?

If I copy and paste a bunch eventually I can no longer click 'done'

Suggestion: maybe adding a scroll bar to the Parameters for CSV: Load table Centra2014-01-23 23:31:30
B
10
S
2
Posts: 76
Reputation: 987

Post » Fri Jan 24, 2014 2:36 am

@Centra

This csv plugin did not limit the col and row count.

The plugin could not create a scroll bar, it need to be supported by C2 editor (but I had suggested this request before). A possible solution is, putting the csv string into a external text file and using AJAX to read this file to be a string input.

The advantage of using csv is, user could create/edit the 2d data in excel/google doc, it's visualize, more readable and easy to edit.rexrainbow2014-01-24 02:40:10
B
97
S
22
G
176
Posts: 4,108
Reputation: 103,019

Post » Fri Feb 07, 2014 1:01 am

@rexrainbow

Hello sir ^^ I'm quite new to Construct2 and just downloaded your plugins and it's really helping. However I have to ask.

Do you have an example or an explanation as to put a column of values into an array so that the values in the array can be used across the project. I tried using the CSV2Array plugin but I dont think I'm familiar with it yet enough to know what to do with it exactly.

B
8
Posts: 35
Reputation: 388

Post » Fri Feb 07, 2014 3:21 pm

@rexrainbow

Thank you for this great plugin. I need to use a lot of comas in my spreadsheet. So i use delimiter property. But it needs a lot of hand corrections. So i need an easy converter. Your excel2csv tool works great. (But if i try to do the same thing in Excel --> Save as cvs it didn't work). It's possible to add a parameter for using different character than comma. For example

excel2csv test.xlsx "@"mrcgkh2014-02-07 15:29:07
B
20
S
8
G
6
Posts: 176
Reputation: 8,047

Post » Sat Feb 08, 2014 3:43 pm

@mrcgkh

Do you mean that you want to transfer the excel to csv with other delimiter (for example "@")?
But why you need it? I thought you might use delimiter "," and read them in csv plugin with delimiter ",".
B
97
S
22
G
176
Posts: 4,108
Reputation: 103,019

Post » Sun Feb 09, 2014 11:09 am

@rexrainbow

Yes. I use long sentences in excel that have some commas (,) in it. So i prefer another delimiter like @. After every conversion with excel2csv tool i make extra hand corrections in csv file.
B
20
S
8
G
6
Posts: 176
Reputation: 8,047

Post » Tue Mar 04, 2014 2:01 am

@rexrainbow

First thank you for this plug-in, I find it to be much more intuitive than C2 array function. I am however experiencing one bug that I cant seem to nail down its cause and am hoping you could point me in the right direction.

At start of layout I load a csv string
"NULL,NAME,RANK,TAC,SCI,ENG
1,Ted,Admiral,10,30,10
2,Sue,Captain,16,4,0
3,Bob,Ensign,0,6,0"

and I can call it just fine such as CSV.At("NAME", str(1)) and I am expecting it to return "Ted" but for some resin the col will always move one to the right so instead it will return "Admiral". What am I doing wrong?
"Were all mad here. I'm mad, your mad." "How do you know I'm mad?" Asked Alice. "You must be" Said the Cheshire Cat. "Or you wouldn't have come here"-Lewis Carroll: Adventures In Wonderland
B
6
S
2
Posts: 113
Reputation: 1,220

Post » Tue Mar 04, 2014 2:47 am

@CrazyVulcan

Try to fix "NULL,NAME,RANK,TAC,SCI,ENG" to ",NAME,RANK,TAC,SCI,ENG" (remove NULL at first cell). It would be OK.
B
97
S
22
G
176
Posts: 4,108
Reputation: 103,019

Post » Tue Mar 04, 2014 2:52 am

rexrainbow wrote:@CrazyVulcan

Try to fix "NULL,NAME,RANK,TAC,SCI,ENG" to ",NAME,RANK,TAC,SCI,ENG" (remove NULL at first cell). It would be OK.


That did the trick, thank you for your time. :)
"Were all mad here. I'm mad, your mad." "How do you know I'm mad?" Asked Alice. "You must be" Said the Cheshire Cat. "Or you wouldn't have come here"-Lewis Carroll: Adventures In Wonderland
B
6
S
2
Posts: 113
Reputation: 1,220

Post » Fri Mar 21, 2014 11:40 pm

Hello @rexrainbow

I have the following problem:
https://www.scirra.com/forum/how-do-i-store-a-list-of-objects-for-quot-connect-the-dots-quot_t99625

After searching a little, I've found your CSV Plugin. Could you please give me some advice how should I implement/use it in my game ?

Thank you :)
B
43
S
15
G
6
Posts: 481
Reputation: 6,942

PreviousNext

Return to Completed Addons

Who is online

Users browsing this forum: edisone and 2 guests