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 ..
D
Big thank you for your help - with my noob questions.
Merci Merci .. greetz from Bern
Have a great Day ..
Sebastian (CRYXCL)