hexagon logo

CSV normally outputs a SEGMENT column

Currently on 2017

Our front office has this glorious software that takes all our data via CSV and shuffles it around and makes us 95% more efficient Wink
Honestly, maybe it helps, but their dimensional software analysis tools require perfect data formatting from us. Not something I'd like to be dependent on.

Today, I was made aware that a new part is transmitting CSV data that is missing a column titled 'Segment'. I guess all our programs export this column, but this new part isn't playing nicely. Our head programmer exhausted all his knowledge working on this today, some of his workarounds were actually quite ingenious listening to them.

I'm not asking for anyone to think too hard about this, but is this something you know about and why this SEGMENT column even exists and why it would randomly just disappear?

The top pic below is our normal working export data with the SEGMENT column, our front office loves the SEGMENT column...and the below is the problem child, without it we are shutting down for the next 2 years I think. Wink

thanks.,,

Parents
  • I would:

    -Open a program that works correctly. Make a COPY of it and SAVE AS something new so you can mess with it
    -Delete ALL of the code from the "mess with this" prg
    -Also open the new program you're writing
    -Copy the code from new prg and paste it into the "mess with this" prg
    -Execute the "mess with this" prg and see if your CSV output looks correct
  • @DAN_M

    William already did this, but I thought you couldn't copy a bunch of command line codes from one program to another?

    Can you simply copy all lines and paste to another program? I work this wkend so,I'll mess with it. I went,in today on my day off to try and tinker around and there is a ghost in the program it seems. Some,csv's kick out only the header some blank, some correct. 2017 R2. On 2021.2 it kicks out 2 xlsx files when I have csv checked and 1 is empty, the other has good correct data.
Reply
  • @DAN_M

    William already did this, but I thought you couldn't copy a bunch of command line codes from one program to another?

    Can you simply copy all lines and paste to another program? I work this wkend so,I'll mess with it. I went,in today on my day off to try and tinker around and there is a ghost in the program it seems. Some,csv's kick out only the header some blank, some correct. 2017 R2. On 2021.2 it kicks out 2 xlsx files when I have csv checked and 1 is empty, the other has good correct data.
Children
No Data