Back to the NBOS Home Page
›

CSV

gojira88ggojira88
in AstroSynthesis Plug-ins and Scripts

How would I go about creating a CSV file, so far using excel spreadsheet I have column A is star name, column B is X coordinate, column C is Y coordinate, and column D is Z coordinate, thank you.

Comments

  • Ed_NBOSEd_NBOS

    In the Advanced Usage section of the help file, there's a section on importing CSV data. Included in that section is a description of what columns are required.

  • gojira88ggojira88

    I have run into another problem I have included the required information in the correct columns but it only imports 127 Systems when the CSV file has 2000 Systems, why would it only recognize a fraction of the file. I mean had it not recognized anything I would guess I had done it wrong but that it does recognize 127 at least means I did it right.

  • Ed_NBOSEd_NBOS

    There should be no limit to the number of stars you can import that way. I checked the code and it doesn't have anything like that in it. Its possible there's a problem on the 127th line that's causing it to fail to import.

  • Ed_NBOSEd_NBOS

    If you want, email me the csv file and I'll try it here to see what is going on.

  • gojira88ggojira88

    Thank you very much I will do that.

  • Ed_NBOSEd_NBOS
    edited September 29

    Ok, I took a look at the csv file. You're very close!

    Couple of items:
    1) Remove the header row.
    2) Make sure no fields have quotes around them.
    3) Numbers should not have commas in there for the thousands. That throws off the csv importer.
    4) At the bottom of the csv file is a ton of empty rows. Remove all of those.

    Here's an example that won't import. Notice the numbers with commas and quotes.
    Star,1,Needan,"-3,461",-16228.07,"-19,690",3.932301782,0,239.1042855,B9,,

    Change it so it looks like:
    Star,1,Needan,-3461,-16228.07,-19690,3.932301782,0,239.1042855,B9,,

    When I made these changes, it imported 2300 or so systems.
    I'm not too great with excel, but I know in LibreOffice you'd format the number without the commas, and not to wrap all fields in quotes. And then export 'as displayed'.

    You can use something like notepad++ or even just notepad to look at the csv in its raw form to confirm it looks right.

  • gojira88ggojira88

    I want to give you an update, thank you so very much you have saved me hours, days, maybe even weeks of entering each one separately. Once I removed the commas for the thousands it only left 4 errors, but then once I removed the commas from the star names example Sun, The everything imported, so once again thank you for being so patient with me.

  • Ed_NBOSEd_NBOS

    Great! Glad I could help!

Leave a Comment