(Not Signed In)

1. • CommentAuthorcbetts
   • CommentTimeSep 28th 2009

    
   Hi,
   
   I get an error trying to import some map data using alchemy.
   This is my script:
   ------------------
   OUTPUT Blah ;
   DATASET "Custom Data Import Example" ;
   COPYRIGHT "(c) 2006 Telogis" ;
   
   SELECT TRACK_NO as TRACK_NO
   INTO awsit_bc
   From "C:\Mentor\GeobaseMaps\OGC - BC\July 2009\Wells\awsit_bc.shp";
   -----------------------------
   TRACK_NO is the first column in the database. It doesnt seem to matter if I use the first column or all of them, I get the same result.
   
   Here is the error:
   
   -----------------------------
   starting
   Processing 'C:\Mentor\GeobaseMaps\OGC - BC\July 2009\Wells\awsit_bc.shp'
   Data build failed: Values out of range - check that your data is WGS84
   
   at xc964d2319e53c184.x5cec2f5ba13587f8.xa4e1e08a9123606f(Geometry xc98d13972e
   d382b3)
   at xc964d2319e53c184.x166550d4656870de.x1325707671e2edd9()
   at xc964d2319e53c184.x166550d4656870de.Process(x32eac27632acc346 xbce90b56ab4
   11c23)
   at xc964d2319e53c184.x867eb3246b182488.xc447809891322395(String[] xce8d8c7e3c
   2c2426)
   Total Time = 00:00:00.2498576
   Press any key to exit ...
   
   ---------------------------------------
   
   
   Any idea whats going on?
   
   Thanks,
2. •  
     CommentAuthorPepitaL
   • CommentTimeSep 28th 2009

    
   Hi,
   
   As stated in the error message, your data are not in the format expected by Alchemy. Database should have standard format WGS84 coordinates. You can either ask your provider to send you the data in the appropriate format or try to project the data onto WGS84.
   
   Pepita
3. • CommentAuthorcbetts
   • CommentTimeSep 29th 2009

    
   Thank you. I think I have managed to project the data onto WGS84.
   You may or may not be able to answer my next question, but I am now getting a different error:
   
   starting
   Processing 'C:\Mentor\GeobaseMaps\OGC - BC\July 2009\Roads\aapr_bc_reproj.shp'
   Data build failed: Year, Month, and Day parameters describe an un-representable
   DateTime.
   
   at System.DateTime.DateToTicks(Int32 year, Int32 month, Int32 day)
   at Geotools.IO.DbaseFileReader.DbaseFileEnumerator.x06b0e25aa6ad68a9()
   at Geotools.IO.DbaseFileReader.DbaseFileEnumerator.MoveNext()
   at Geotools.IO.ShapefileDataReader.Read()
   at xc964d2319e53c184.x166550d4656870de.Process(x32eac27632acc346 xbce90b56ab4
   11c23)
   at xc964d2319e53c184.x867eb3246b182488.xc447809891322395(String[] xce8d8c7e3c
   2c2426)
   Total Time = 00:00:00.5935258
   Press any key to exit ...
   
   
   To which date/time parameters is it refering?
4. •  
     CommentAuthorPepitaL
   • CommentTimeSep 29th 2009

    
   hi,
   
   For the date/time parameter, it would be actually helpful to know when this error happens, I mean during which import statement that occurs.
   It is possible that the data you try to import have a incorrect datetime format. I would suggest to check when it happens and the format in the datafile treated.
   
   If you keep having thsi error, please send a email to gbsupport@telogis.com with a data sample and your sfi script.
   Pepita
5. • CommentAuthorcbetts
   • CommentTimeSep 30th 2009

    
   Hi,
   
   I found the problem. It looks like a couple of the columns in the dbf have a date/time that is unreadable by Alchemy. What is the date/time fomat that alchemy is expecting? Currently we have 7/17/2009 in our dbf.
   
   Chris
6. •  
     CommentAuthorSeanS
   • CommentTimeOct 1st 2009

    
   Have you tried YYYYMMDD format? That is what's shown in the "Alchemy IMPORT CONSTRAINTS Example" section of the documentation:
   
   http://docs.geobase.info/html/2dc20e3f-a4ba-4583-aac6-1c730e785c58.htm
7. • CommentAuthorcbetts
   • CommentTimeOct 1st 2009

    
   That worked. Thank you!