Jump to content
RockWare Support Forum

Jim Jackson

Admin
  • Content count

    14
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jim Jackson

  • Rank
    Member

Contact Methods

  • Website URL
    http://
  • ICQ
    0

Profile Information

  • Gender
    Male
  • Location
    Golden, CO
  1. Kuldip Upasani

    An extra note: If you cannot open RockWorks at all due to the "Syntax" Error, delete the ..\RockWorks17 Data\Samples folder. RockWorks will recreate it and recopy the sample files. This is the fall back folder, if RockWorks cannot open your current project, it will try to open Samples, failing that I believe it closes.
  2. Kuldip Upasani

    Hi Kuldip, I am having a difficulty duplicating the error on my computer. Would you please clear the folder of everything except your Excel file. Then proceed thru your steps again to create the new project. When you get the error dialog, please click on the "Report Error / Restart" button and send the bug report to Tech@rockware.com, to my attention: Jim Jackson. This error report gives a detailed trace of what RockWorks was having a problem with at the time. Thanks, Jim
  3. Kuldip Upasani

    Hi Kuldip, I am having a difficulty duplicating the error on my computer. Could you tell me more about the folder you are creating the RockWorks project in? It appears to be a network drive, is this true? Was the folder empty when you tried creating the project? Do you have rights to create/modify files in this folder? Can you create a new project on your local hard disk ok? When you get the Error report, please click on the "Report Error / Restart" button and send the bug report to us. This will help me see where the problem is occurring. Thanks, Jim
  4. Kuldip Upasani

    Hi Kuldip, Could you give me a little more information. Did this occur when starting RockWorks, or during some program function, or just clicking on something? Thanks, Jim
  5. If your RockWorks16 project was initially ok on the local drive, then with RockWorks closed, try deleting the project's "System" sub-folder. When RockWorks opens and you connect to this project, RockWorks will recreate the System sub-folder and the necessary files in it. This process will work for the project on the network drive also. The database needs to have been created correctly for this to work. Then you could give the "Create New Project" another try. I have created projects on my network with out a problem, hopefully this was a just a glitch and will work on a second try. Jim
  6. RW17 SQL database limitations

    The limitations of an SQLite database can been seen at www.sqlite.org/limits.html. You should see a performance improvement over using MS Access (mdb) as the SQLite engine is embedded in RockWorks where using MS Access the data had to move (be marshaled) from Access to RockWorks across the COM interface. If you mean MS SQL Server, the limits can been seen at msdn.microsoft.com/en-us/library/ms143432.aspx. With MS SQLServer some of the processing is done on the server but the network latency comes into play. We try to have the server only send back the data for the process at hand, but again large P-Data model will be slow. So I do not have any hard and fast suggestions for limiting the number of boreholes or the amount of data for a borehole, it depends on what you are doing with the data in RockWorks. Once the data is in, you can disable some boreholes.
  7. RW16 Borehole Manager Data Listings

    I went back and looked at this and I believe you can do what you want with the Filter/Select boreholes on the View menu. It does not give you a list it enables/disables boreholes which you can base on a P-Data type.
  8. RW16 Borehole Manager Data Listings

    You could open your project database (mdb file) in Access and run a query like: SELECT DISTINCT Location.Name, PointType.Name FROM PointType INNER JOIN (Location INNER JOIN Point ON Location.BhId = Point.BhId) ON PointType.PointTypeId = Point.PointTypeId ORDER BY Location.Name, PointType.Name; This will give you a list of all the Boreholes with P-Data and the name of the P-DataType
  9. You can work around the problem by adding the project's System folder to AVG's Virus Resident Shield Exceptions list. If you have several projects, you have to add each project's System folder to the Exceptions list. Jim Jackson RockWare, Inc.
  10. RCL: Importing Pdata from excel into BM

    Attached is an example of an RCL file to import P-Data, Jim : Define the input file name, : remember the borehole needs to already exist before the import begins : for Excel the filename variable is XLS_FILE_NAME DEFINE: BM_EXCHANGE ASCII_FILE_NAME C:\Users\Joe User\Documents\RockWorks15 Data\New Project\P-Data Import.txt : This DEFINE is the where the columns in the input are saved : So in this example the first column represents which borehole by Name, : column 2 is the Depth of the sample, : column 3 are Gamma numbers and : column 4 are the Resistivity numbers DEFINE: BM_EXCHANGE ASSAY_FIELDS_MAP Name,Depth,Gamma,Resistivity : Are there column titles in the input file? DEFINE: BM_EXCHANGE INCLUDE_COLUMN_TITLES True : Set the data delimiter if an ASCII file, number 9 is a TAB, 32 is a SPACE, 44 is a COMMA DEFINE: BM_EXCHANGE ASCII_DELIMITER 9 : Run the ASCII import EXECUTE: CSV_2_PDATA : or run the XLS import with the command XLS_2_PDATA : Terminate script without killing RockWorks. EXIT:
  11. It looks like there may be a problem with your contour data. Look at the values in the columns 'Level', 'LineStyle', 'LineWidth' and 'LineColor'. These should all be numbers and specifically integers except for 'Level'. By integers I mean no decimal point or letters. 'Level' may have decimal values. They all should have values even if the value is a 0 (zero) and not be left blank. Make sure the 'TableName' also has a value. Jim
  12. Lithology Table

    Hi Kyle, The Lithology type column is sizable, click on the line between the keyword and comment columns in the titles bar and drag it to the make it bigger. If you need to print it you could export it from the Lithology Types table editor and import into Word or Excel and print it from there. You can open the Lithology Types table editor by double-clicking on the keyword, clicking on the Lithology Type button just above the Lithology grid (let the help hint appear by pausing the mouse cursor over the buttons) or choose Lithology Types from the Project Manager (on the left side of the screen) / Borehole Tables / Lithology Types. The 'Tables' tab on the far left of the window that was in RW/2006 was redone as the 'Project Manager' in RW/14. HTH, Jim
  13. Stratigraphy Help

    The import was expecting all of your stratigraphy layers to be together for a borehole. The data file had the data grouped by stratagraphic layer instead of by borehole. One solution would be to do what you did and import it first into Excel, resort the stratigraphy section and save it back out. RockWorks 14 (and 2006) will import the 2004 borehole data (*.bh files) directly.
  14. RockWorks/2006 cannot create a new project and fails with: EOleException : Application uses a value of the wrong type for the current operation. Occurs when running Windows 2000 and Microsoft Data Access Components (MDAC) version 2.5. In the BugReport look for version on one of: msado15.dll oledb32.dll msadox.dll These dll’s can be found on the machine in the directory C:\Program Files\Common Files\System\ado This problem will occur when the version is 2.53.xxxx.xxxx (Version 2.5) the version should be 2.81.xxxx.xxxx (Version 2.8) Solution: Go to Microsoft download site www.microsoft.com/downloads and search for MDAC (current version is 2.8). Download and install latest version.
×