search

burnsoftnet / BurnSoft.Applications.MGC

Main LIbrary for the My Gun Collection Application containing a majority of the functions to interacti with the database
MIT License
0 stars 0 forks source link

Convert Import XML #37

Closed burnsoftnet closed 2 years ago

burnsoftnet commented 2 years ago

Need to create an Import class to match up how the data is handled on export and import

burnsoftnet commented 2 years ago

12/16/2021 8:14:19 AM frmViewCollectionDetails.Load::13::Conversion from string "N/A" to type 'Date' is not valid unittest_fiream.zip .

burnsoftnet commented 2 years ago

12/16/2021 8:15:43 AM frmImportFirearm.ProcessXMLToDB::5::BurnSoft.Applications.MGC.Firearms.XmlImport.Details - BurnSoft.Applications.MGC.Firearms.MyCollection.Add - BurnSoft.Applications.MGC.Database.ConnExec - ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Field 'Gun_Collection.PetLoads' cannot be a zero-length string. SQL - INSERT INTO Gun_Collection (OID,MID,FullName,ModelName,ModelID,SerialNumber,Type,Caliber,Finish,Condition,CustomID,NatID,GripID,Qty,Weight,Height,StockType,BarrelLength,BarrelWidth,BarrelHeight,Action,Feedsystem,Sights,PurchasedPrice,PurchasedFrom,AppraisedValue,AppraisalDate,AppraisedBy,InsuredValue,StorageLocation,ConditionComments,AdditionalNotes,Produced,PetLoads,dtp,IsCandR,Importer,ReManDT,POI,HasMB,DBID,SGChoke,IsInBoundBook,TwistRate,lbs_trigger,Caliber3,Classification,DateofCR,ItemSold,BID,sync_lastupdate,IsClassIII,ClassIII_owner) VALUES(2,15,'Glock G17 Open Class','G17 GEN3',22713,'vul696','Semi-Auto Pistol','9mm Luger','Black','New','',15,2,1,'625 g / 22.04 oz (unloaded)','10.32 in','Plastic','5.03 in','','','Safe Action','Safe Action','Fixed front and rear','479.00','Mike''s Guns','865.00','11/9/2016 12:20:09 PM','BlueBook + Accessories','865.00','Armory Rack','',' ','8-26-2013','','12/23/2013 12:20:09 PM',0,'Glock USA','12/26/2013','',0,0,'',1,'','5','','Modern','8/13/2017',0,2,Now(),0,'')