Knowledgebase
dVnet: Importing from Excel
Posted by Wayne Howell on 10 May 2013 02:01 PM

You'll find the import from CSV button in the Pixel Map tab. From here the process of importing a properly formatted CSV is straight forward. You just need to find and open your pre-existing CSV file. Please note that you must not have the file open in any other applications (Excel or NotePad) as the import will not work. 

In order to make a dVnet CSV file you need to have the following line as the first line of the file. Attached is an example which can be used with the example show which installs with dVnet.

Name, Type,X,Y,Width,Height,Fixture #,Pixel #,Pipe,Start,Footprint,Red slot,Grn slot,Blu slot,Yel slot,Wht slot,Int slot,Group,

Each subsequent line of the CSV file will be a single pixel within your map.

  • Name is required though this can just be a number
  • Type would be the type of fixture this pixel is in - optional
  • X & Y are the co-ordinates that this pixel will take on your map
  • Width and Height are the relative size of this pixel
  • Fixture this will be a number representing the fixture that this pixel is a part of
  • Pixel # represents which pixel this is within its fixture. As all the fixtures in the example file only contain a single pixel this number will always be 1. However if you are using a fixture with 4 LEDs this would be between 1 and 4.
  • Pipe see the notes below on pipes
  • Start is this pixels DMX address
  • Footprint is the number of DMX slots this pixel occupies
  • Red slot which of the slots for this pixel contains data for the red channel (typically 1)
  • Grn slot which of the slots for this pixel contains data for the green channel (typically 2)
  • Blu slot which of the slots for this pixel contains data for the blue channel (typically 3)
  • Yel slot which of the slots for this pixel contains data for the yellow channel (typically 0 for RGB pixels)
  • Wht slot which of the slots for this pixel contains data for the white channel (typically 0 for RGB pixels)
  • Int slot which of the slots for this pixel contains data for the intensity channel (typically 0 for RGB pixels)
  • Group is optional

Please note that we have implemented a 'pipe-centric' way of patching pixels. When patching pixels you first select the pipe that the fixture is on (between 1 and 300) then the fixtures start address which will be its DMX address between 1 and 512.

By default each pipe is patched 1 to 1 with its respective universe and will unicast as Art-Net. However you can patch a pipe to any Art-Net or sACN universe using the 'Pipe patch' tab.

Lastly there is an export to dVnet function within the latest release of Colour-Tramp, a download of which can be found here.



Attachments 
 
 example 02 - circular map - import.csv (36.92 KB)

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako Fusion