Fixtures CSV Import
  • CRYXCL
    junior Member
    Posts: 4
    Joined: Wed Sep 14, 2016 10:22 am

    Fixtures CSV Import

    by CRYXCL » Mon Sep 11, 2017 7:19 pm

    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)
  • mad-matt
    garageCube team
    Posts: 333
    Joined: Mon Sep 09, 2013 5:50 pm

    Re: Fixtures CSV Import

    by mad-matt » Tue Sep 12, 2017 1:28 pm

    Remove the first line with the header.
  • CRYXCL
    junior Member
    Posts: 4
    Joined: Wed Sep 14, 2016 10:22 am

    Re: Fixtures CSV Import

    by CRYXCL » Tue Sep 12, 2017 2:40 pm

    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)
  • mad-matt
    garageCube team
    Posts: 333
    Joined: Mon Sep 09, 2013 5:50 pm

    Re: Fixtures CSV Import

    by mad-matt » Wed Sep 13, 2017 1:01 pm

    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
    Last edited by mad-matt on Wed Sep 13, 2017 5:16 pm, edited 1 time in total.
  • CRYXCL
    junior Member
    Posts: 4
    Joined: Wed Sep 14, 2016 10:22 am

    Re: Fixtures CSV Import

    by CRYXCL » Wed Sep 13, 2017 4:51 pm

    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)
  • mad-matt
    garageCube team
    Posts: 333
    Joined: Mon Sep 09, 2013 5:50 pm

    Re: Fixtures CSV Import

    by mad-matt » Wed Sep 13, 2017 5:19 pm

    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.
  • mad-matt
    garageCube team
    Posts: 333
    Joined: Mon Sep 09, 2013 5:50 pm

    Re: Fixtures CSV Import

    by mad-matt » Wed Sep 13, 2017 5:21 pm

    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
    Attachments
    test import fixture lines 2x1.csv.zip
    (1.15 KiB) Downloaded 3 times
  • CRYXCL
    junior Member
    Posts: 4
    Joined: Wed Sep 14, 2016 10:22 am

    Re: Fixtures CSV Import

    by CRYXCL » Thu Sep 14, 2017 7:21 am

    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)

Who is online

Users browsing this forum: No registered users and 2 guests