Esempio n. 1
0
    def do_sample_import(self, event):
        cname = self.corename
        core = datastore.cores.get(cname)
        if core is None:
            core = Core(cname)
            datastore.cores[cname] = core
        for item in self.rows:
            # TODO -- need to update existing samples if they exist, not
            # add new ones!
            s = Sample('input', item)
            core.add(s)
        all = Sample('input', {'depth': 'all'})
        source = self.corepage.source_name
        # TODO: should only put metada in mdata if it will not be used for
        # calculations anywhere
        if source:
            all['input']['Provenance'] = source

            core.mdata.atts['Provenance'] = (mData.CorePubAtt('input',
                                             'Provenance', source))
        latlng = self.corepage.latlng
        all['input']['Latitude'] = latlng[0]
        all['input']['Longitude'] = latlng[1]
        guid = self.corepage.core_guid
        if guid:
            all['input']['Core GUID'] = guid
            core.mdata.atts['Core GUID'] = (mData.CoreAttribute('input',
                                            'Core GUID', guid, 'guid'))

        core.mdata.atts['Geography'] = (mData.CoreGeoAtt('input',
                                        'Geography', latlng, ""))


        core.add(all)
        core.loaded = True
Esempio n. 2
0
    def do_sample_import(self, event):
        cname = self.corename
        core = datastore.cores.get(cname)
        if core is None:
            core = Core(cname)
            datastore.cores[cname] = core
        for item in self.rows:
            # TODO -- need to update existing samples if they exist, not
            # add new ones!
            s = Sample("input", item)
            core.add(s)
        all = Sample("input", {"depth": "all"})
        source = self.corepage.source_name
        # TODO: should only put metada in mdata if it will not be used for
        # calculations anywhere
        if source:
            all["input"]["Provenance"] = source

            core.mdata.atts["Provenance"] = mData.CorePubAtt("input", "Provenance", source)
        latlng = self.corepage.latlng
        all["input"]["Latitude"] = latlng[0]
        all["input"]["Longitude"] = latlng[1]
        guid = self.corepage.core_guid
        if guid:
            all["input"]["Core GUID"] = guid
            core.mdata.atts["Core GUID"] = mData.CoreAttribute("input", "Core GUID", guid, "guid")

        core.mdata.atts["Geography"] = mData.CoreGeoAtt("input", "Geography", latlng, "")

        core.add(all)
        core.loaded = True
Esempio n. 3
0
 def import_samples(self, event):
     dialog = wx.FileDialog(None,
             "Please select a CSV File containing Samples to be Imported or Updated:",
             defaultDir=os.getcwd(), wildcard="CSV Files (*.csv)|*.csv|All Files|*.*",
             style=wx.OPEN | wx.DD_CHANGE_DIR)
     result = dialog.ShowModal()
     path = dialog.GetPath()
     #destroy the dialog now so no problems happen on early return
     dialog.Destroy()
     
     if result == wx.ID_OK:
         with open(path, 'rU') as input_file:
             #allow whatever sane csv formats we can manage, here
             sniffer = csv.Sniffer()
             dialect = sniffer.sniff(input_file.read(1024))
             dialect.skipinitialspace = True
             input_file.seek(0)
             
             reader = csv.DictReader(input_file, dialect=dialect)
             if not reader.fieldnames:
                 wx.MessageBox("Selected file is empty.", "Operation Cancelled", 
                               wx.OK | wx.ICON_INFORMATION)
                 return
             #strip extra spaces, since that was apparently a problem before?
             reader.fieldnames = [name.strip() for name in reader.fieldnames]
                
             if 'depth' not in reader.fieldnames:
                 wx.MessageBox("Selected file is missing the required attribute 'depth'.", 
                               "Operation Cancelled", wx.OK | wx.ICON_INFORMATION)
                 return
             
             rows = []
             for index, line in enumerate(reader, 1):
                 #do appropriate type conversions...
                 for key, value in line.iteritems():
                     try:
                         line[key] = datastore.sample_attributes.convert_value(key, value)
                     except ValueError:
                         wx.MessageBox("%s on row %i has an incorrect type."
                             "Please update the csv file and try again." % (key, index),
                             "Operation Cancelled", wx.OK | wx.ICON_INFORMATION)
                         return
                 rows.append(line)
             if not rows:
                 wx.MessageBox("Selected file appears to contain no data.", 
                               "Operation Cancelled", wx.OK | wx.ICON_INFORMATION)
                 return
             
             dialog = DisplayImportedSamples(self, os.path.basename(path), 
                                             reader.fieldnames, rows)
             if dialog.ShowModal() == wx.ID_OK:
                 if dialog.source_name:
                     for item in rows:
                         item['source'] = dialog.source_name
                 cname = dialog.core_name
                 core = datastore.cores.get(cname, None)
                 if core is None:
                     core = Core(cname)               
                     datastore.cores[cname] = core            
                 for item in rows:
                     s = Sample('input', item)
                     core.add(s)
     
                 wx.MessageBox('Core %s imported/updated' % cname, "Import Results",
                               wx.OK | wx.CENTRE)
                 events.post_change(self, 'samples')
             dialog.Destroy()