Page 1 of 1

Fixtures CSV Import

Posted: Mon Sep 11, 2017 7:19 pm
by CRYXCL
Hello,

(Active Version: MadMapper 3.0.3)

any Manual for the Fixture Import?
CSV File Specs would be nice..

I try to get this csv in madmapper .. no success .. :(

Always the same Massage about an empty file under MAC CSV Excel Export.

Normal CSV breaks with Error in line 1 .. :/ (universe;startChannel;startPosX;startPosY;endPosX;endPosY;fixtureWidth;fixtureDefinition)

So please.. i need some help here.. ;D..

universe;startChannel;startPosX;startPosY;endPosX;endPosY;fixtureWidth;fixtureDefinition
1;1;0;1;30;1;1;Gen
1;2;0;2;30;2;1;Gen
1;3;0;3;30;3;1;Gen
1;4;0;4;30;4;1;Gen
....


Greetz,
Sebastian (CRYXCL)

Re: Fixtures CSV Import

Posted: Tue Sep 12, 2017 1:28 pm
by mad-matt
Remove the first line with the header.

Re: Fixtures CSV Import

Posted: Tue Sep 12, 2017 2:40 pm
by CRYXCL
Merci for the quick response.

I've deleted the Headerline, but I still have the same error messages.

Some Idea how i can fix it.
Maybe the File Format? (I try every csv option in office with no success.)

My CSV Table looks like:

1 1 0 0.5 30 0.5 1 Gen
1 2 0 1.5 30 1.5 1 Gen
1 3 0 2.5 30 2.5 1 Gen
1 4 0 3.5 30 3.5 1 Gen
1 5 0 4.5 30 4.5 1 Gen
1 6 0 5.5 30 5.5 1 Gen
1 7 0 6.5 30 6.5 1 Gen
1 8 0 7.5 30 7.5 1 Gen
1 9 0 8.5 30 8.5 1 Gen
1 10 0 9.5 30 9.5 1 Gen
1 11 0 10.5 30 10.5 1 Gen


can you provide me an example file for research please..

Kind Regrads,
Sebastian (CRYXCL)

Re: Fixtures CSV Import

Posted: Wed Sep 13, 2017 1:01 pm
by mad-matt
Here is an example. First line can be there

Fixture Definition Name,Start Universe,Start Channel,StartX,StartY,EndX,EndY,Width
Generic - 2x1 RGB,0,1,0,0.5,2,0.5,1
Generic - 2x1 RGB,0,4,2,0.5,4,0.5,1
Generic - 2x1 RGB,0,7,4,0.5,6,0.5,1
Generic - 2x1 RGB,0,10,6,0.5,8,0.5,1
Generic - 2x1 RGB,0,13,8,0.5,10,0.5,1

Re: Fixtures CSV Import

Posted: Wed Sep 13, 2017 4:51 pm
by CRYXCL
Hi Mad,

Sorry - but - i try everything... with no success.
I don't get it.. and i dont know why.. the Error messages that i got is wrong i think..?

What CSV Format with ";" or "," (Normal is ";") - you provide the sample with ",". (i try both)

What does the Error message mean
- "Failed importing files from file: Error at line 1, column 1, no such fixture definition: Generic - 2x1 RGB".

I try numbers and text - Everytime the same error message will come up - "no such fixture definition".

Also your fixture definition provide an Error..?
Any conversation for that field (String, Num, Float)...??

TEST 1 - NOK
Fixture Definition Name,Start Universe,Start Channel,StartX,StartY,EndX,EndY,Width
Generic - 2x1 RGB,0,0,0,0.5,2,0.5,1
Generic - 2x1 RGB,0,3,2,0.5,4,0.5,1
Generic - 2x1 RGB,0,6,4,0.5,6,0.5,1
Generic - 2x1 RGB,0,9,6,0.5,8,0.5,1
Generic - 2x1 RGB,0,12,8,0.5,10,0.5,1

TEST 2 - NOK
Generic - 2x1 RGB,0,0,0,0.5,2,0.5,1
Generic - 2x1 RGB,0,3,2,0.5,4,0.5,1
Generic - 2x1 RGB,0,6,4,0.5,6,0.5,1
Generic - 2x1 RGB,0,9,6,0.5,8,0.5,1
Generic - 2x1 RGB,0,12,8,0.5,10,0.5,1

Also the same with ";" doesn't work.
I also try Excel Export Formats with (DOS CSV, MAC CSV, Standard CSV).

An tested sample file would be nice.. because - no manual, no specs, nothing.
I only found an xcode project at gitHub (Build fails) and an animated gif with an old spec.

So please can you tell me the trick.

Kind Regrads,
Sebastian (CRYXCL)

Re: Fixtures CSV Import

Posted: Wed Sep 13, 2017 5:19 pm
by mad-matt
That's exact, the example I sent you uses a "fixture definition" called "Generic - 2x1 RGB". That's a fixture definition I created in my library (2x1 pixel RGB). You don't have it in yours, that's why you get the message: "Failed importing files from file: Error at line 1, column 1, no such fixture definition: Generic - 2x1 RGB".
The error message is clear in fact.
Replace it with "Generic - Pixel RGB" and it will work.

Re: Fixtures CSV Import

Posted: Wed Sep 13, 2017 5:21 pm
by mad-matt
Fixture Definition Name,Start Universe,Start Channel,StartX,StartY,EndX,EndY,Width
Generic - Pixel RGB,0,1,0,0.5,2,0.5,1
Generic - Pixel RGB,0,4,2,0.5,4,0.5,1
Generic - Pixel RGB,0,7,4,0.5,6,0.5,1
Generic - Pixel RGB,0,10,6,0.5,8,0.5,1
Generic - Pixel RGB,0,13,8,0.5,10,0.5,1

Attached is the file

Re: Fixtures CSV Import

Posted: Thu Sep 14, 2017 7:21 am
by CRYXCL
Hi Mad,

i got it.. finaly..:-)
It was an couple of issues at my site.
at first - my excel export comes with (;) - i had to switch my system settings to (,).
the second one was that i dont get the clue with Fixture Definition Name = Fixture Library Dropdown Field Entrys.

Now i can start my csv experiments .. :DD
Big thank you for your help - with my noob questions.

Merci Merci .. greetz from Bern
Have a great Day ..

Sebastian (CRYXCL)