View Issue Details

IDProjectCategoryView StatusLast Update
0002935CCdcielGeneralpublic26-07-20 22:04
ReporterWayne Green Assigned ToPatrick Chevalley  
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
PlatformMicrosoftOSWindowsOS Version11 Pro
Product Version0.9 
Summary0002935: Fails to import CSV file for sequence
DescriptionUsing Sequence-> new and Import csv to pick the file, entire line appears in one column, even the commas.
Steps To ReproduceCreated a target list using TOPCAT TAP query of SIMBAD, saved as CSV file.
Imported to MS Excel as CSV
Changed MAIN_ID to Name, added RA and Dec as sexagesimal.
Saved as CSV

CCDCiel -> Sequence -> new
Insert rows -> Import CSV ... Picked the file.

Failed to import into CCDCiel properly. All data, commas included appear in one column.

To check, I Imported this file back into TOPCAT with no problem.
Additional InformationAs a professional, I create target lists with a number of professional program queries. The common
format is CSV or VOT (Virtual Observatory Tables). We use the SAMP protocol to tie TOPCAT
to Aladin with the DSS full color. Selecting the target in the TOPCAT cable positions Aladin
against a picture of the sky. Working in the Southern hemisphere there are far too many stars
for amateur planetarium programs to display -- however to disambiguate our targets from the
background requires the stars. As a fall back, I will overlay the Gaia or SIMBAD catalogs where
the little circles helps for blurred star situations for example two bright targets that overlap.

I was trying to use the load local dss image for each target, cumbersome, to use as finders.
TagsNo tags attached.

Activities

Patrick Chevalley

26-07-11 09:41

administrator   ~0009890

Currently it use the semicolon (;) for the field separator, not the coma.

Is possible for you to save the CSV with a semicolon?
Otherwise I need to add a prompt to select what to use.

Patrick Chevalley

26-07-11 15:49

administrator   ~0009891

I make the change to allow to select the separator and string delimiter character when importing a CSV file.
Now it must work with your file.

To test, please install the version 0.9.96-4206 available from https://vega.ap-i.net/pub/ccdciel/daily_build/

Please tell me if this is OK this way.

Patrick Chevalley

26-07-20 22:04

administrator   ~0009909

This is now in version 0.9.97

Issue History

Date Modified Username Field Change
26-07-11 05:41 Wayne Green New Issue
26-07-11 09:41 Patrick Chevalley Note Added: 0009890
26-07-11 15:49 Patrick Chevalley Note Added: 0009891
26-07-11 15:50 Patrick Chevalley Assigned To => Patrick Chevalley
26-07-11 15:50 Patrick Chevalley Status new => feedback
26-07-20 22:04 Patrick Chevalley Status feedback => resolved
26-07-20 22:04 Patrick Chevalley Resolution open => fixed
26-07-20 22:04 Patrick Chevalley Note Added: 0009909