Results 1 to 4 of 4
  1. #1
    Senior Member
    Join Date
    10.05.01
    Location
    Milan, MI
    Posts
    968
    Liked: 313

    Default AIM to CSV conversion

    Either through my own careless note keeping or a change to AIM software, I was confused in trying to save CSV files in Race Studio and then open them in SciLab. I had done it before but it was behaving differently this time.

    Opening the CSV's in Notepad I found that there are double quotes before and after each and every value that Race Studio saved in the CSV. By trial and error I found that opening the CSV in Excel and then saving it in Excel, again as a CSV, got rid of the double quotes. Double quotes make each entry in the data file a separate string variable and not really usable for calculations.

    Like I said, either my notes are faulty or AIM changed the CSV conversion with the recent software release. Does anyone know which? Better yet, is there a way to make the conversion to CSV without the quotes? I tried the various CSV conversion check-boxes but didn't find one that did what I wanted. I want the header on the file as I have written a SciLab script to work with it.

  2. #2
    Senior Member Brian.Novak's Avatar
    Join Date
    03.10.07
    Location
    Detroit, Mi
    Posts
    289
    Liked: 20

    Default

    I just checked on mine and I'm getting the same issue. I wonder if they just made a mistake in the latest software, I don't remember having this problem before.

  3. #3
    Senior Member
    Join Date
    10.05.01
    Location
    Milan, MI
    Posts
    968
    Liked: 313

    Default

    Thanks Brian. I wasn't sure if it was me or them. Good to know that is probably them.

    I will submit a question to AIM Sport. Sometimes they have answers, sometimes, not so much. My experience when asking questions that bore deep into the technical side is they don't know what the home office in Italy is up to.

  4. #4
    Senior Member
    Join Date
    10.05.01
    Location
    Milan, MI
    Posts
    968
    Liked: 313

    Default

    The first reply I got from AIM tech support was a demonstration that the CSV file the tech guy converted opened just fine in Excel, a fact I was aware of but did not address the issue that those very same CSV files would not open in other software designed to open CSV files. I replied to AIM tech support to please open the data file in Notepad or something similar. This is their reply:
    -----------------------------
    AiM Tech Support

    Hi David,

    I now see what you are referring to. I believe that we had to change this in order to be compatible with several third party video-data synchronization applications (i.e. TrackVision). A workaround is to simply choose the TXT option instead of the .CSV export. This option then removes the double quotation marks and appears to be formatted for your specifications in Notepad...
    -----------------------------

    I have yet to play with trying to open TXT's to do post analysis but at a minimum they do not have all the header information that the previous CSV's did.

    I wish they had made their other data files "TrackVision" or something instead of corrupting the CSV format.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  




About Us
Since 2000, ApexSpeed.com has been the go-to place for amateur road racing enthusiasts, bringing together a friendly community of racers, fans, and industry professionals. We're all about creating a space where people can connect, share knowledge, and exchange parts and vehicles, with a focus on specific race cars, classes, series, and events. Our community includes all major purpose-built road racing classes, like the Sports Car Club of America (SCCA) and various pro series across North America and beyond. At ApexSpeed, we're passionate about amateur motorsports and are dedicated to helping our community have fun and grow while creating lasting memories on and off the track.
Social