Resultados 1 al 3 de 3

Tema: Lookup Table Import - Separator Invalid

  1. #1
    Junior Member Avatar de EleventhHour
    Fecha de Ingreso
    20 dic, 11
    Hora local

    Not allowed! Not allowed!

    Lookup Table Import - Separator Invalid

    Hi all,

    I've been trying to teach myself about lookup tables and made a first, very very simple .csv lookup table to test the basics. However, I've hit a brick wall with this error - upon importing the lookup table I get the "The separator in the header is invalid" error message.

    The headers both have the very basic "Holesize##length##millimeters" and "HR##length##millimeters" in them (without quote marks) as you can see in the screen shot - is there something obvious that I'm missing?

    After hours of googling & reading the things that I've already tried are:-

    1. Closing both excel and Revit after editing the .csv file / prior to importing
    2. Changing the values from millimeters to millimetres to inches to feet
    3. importing the lookup table .csv file both before and after creating the two required relevant parameters to use the bolts.csv file - although I can't see how this would actually affect the import...
    4. Also tried changing the .csv to a .txt and viewing to make sure that it is using the expected , as the separator and not another symbol - as in second screenshot.

    It seems to be such a simple test but I can't understand what the problem is - can anyone shed any light on this? Thanks.

    Pulsa en la imagen para verla en tamaño completo

Nombre: Import Lookup Table Fail.PNG
Visitas: 21
Tamaño: 99.4 KB
ID: 34417

    Pulsa en la imagen para verla en tamaño completo

Nombre: Import Lookup Table as text.PNG
Visitas: 16
Tamaño: 8.6 KB
ID: 34418

  2. #2
    Forum Addict Avatar de josephpeel
    Fecha de Ingreso
    03 may, 12
    Hora local

    Not allowed! Not allowed!
    Wierd.. I would suggest you find an existing lookup table in a family that works and use that as the basis (Or at least see what is different)

    Personally I have managed to avoid lookup tables for a long time. I prefer to use formulas.
    If you graph that type of data you can always fit a 'Y=A + Bx' formula to it quite accurately (Use 'fit trendline' and 'show equation' in excel to get A and B)
    Then instead of a lookup table you can use the formula to look up any value of Y from X..
    A and B can be Type Parameters, so you can make types within the same family that use different source data.

    So for example.. Heres data for a bunch of different air grilles and their throw distance for different airflows.
    By graphing this data to get the A and B constants I was able to make one air terminal family that will accurately calculate the throw distance for each type based on the Flow.

    Maybe this seems complicated... but I find it much easier to use than lookup tables.
    I use this method for stuff like pipe fittings too (Outside diameter, flange size etc..) so one pipe fitting can have multiple materials/manufacturers as types.
    Miniaturas Adjuntadas Miniaturas Adjuntadas Air Grille Type Graphs.JPG  
    Última edición por josephpeel; 07/08/2018 a las 16:10

  3. #3
    New Member
    Fecha de Ingreso
    08 ago, 16
    Hora local

    Not allowed! Not allowed!
    try selecting all the blank header cells and pressing delete. you may find you have accidentally put a space in one.

Temas Similares

  1. Lookup table
    Por gowthamsamys en el foro MEP - General
    Respuestas: 2
    Último Mensaje: 16/04/2018, 21:48
  2. Lookup Table Using Number
    Por Tim_Ea en el foro MEP - General
    Respuestas: 5
    Último Mensaje: 31/01/2018, 02:03
  3. Lookup table Yes/no not working
    Por Arno en el foro Architecture - Family Creation
    Respuestas: 6
    Último Mensaje: 28/09/2015, 18:21
  4. Lookup Table: First Column?
    Por doni49 en el foro Architecture - Family Creation
    Respuestas: 3
    Último Mensaje: 27/09/2015, 23:09
  5. Lookup Table issue
    Por sabari2504 en el foro MEP - General
    Respuestas: 8
    Último Mensaje: 15/01/2014, 08:19

Permisos de Publicación

  • No puedes crear nuevos temas
  • No puedes responder temas
  • No puedes subir archivos adjuntos
  • No puedes editar tus mensajes