Ali shokouhi Posted June 29, 2022 Share Posted June 29, 2022 Hi, I just wanted to know if we can export the data from Rockworks to leapfrog. Thank you very much. Link to comment Share on other sites More sharing options...
JimReed Posted June 29, 2022 Share Posted June 29, 2022 Hi Ali, Short Answer: No Long Answer: We don't know anything about Leapfrog's file formats but I would assume that they have some kind of ASCII/CSV import routines in which case the answer could be a vague "yes". Also, I'm not sure what you're trying to export (e.g., grids, solids, datasheets, borehole database, diagrams, etc.). Vague Promise: If you can provide any documentation on Leapfrog's import or file formats, we'd be glad to add a Leapfrog export tools to RockWorks (at no charge). Best regards, Jim Reed RockWare Programmer jim@rockware.com Link to comment Share on other sites More sharing options...
Ali shokouhi Posted July 4, 2022 Author Share Posted July 4, 2022 Hi Jim, Thank you very much for your reply. Attached please find 2 files that can be used as an input for Leap Frog, in addition for the downhole data LAS can be used. Best regards, Ali 1_DummyLabel_Collar.csv 2_DummyLabel_Lith.csv Link to comment Share on other sites More sharing options...
JimReed Posted July 4, 2022 Share Posted July 4, 2022 Hi Ali, Thanks for the example files! The 1_DummyLabel_Collar.csv file looks fairly straightforward. We can easily add a subroutine to RockWorks (let's call it "Export_RockWorks_Collar_Locations_To_LeapFrog") that creates a CSV file that looks like your example. My only question has to do with the the DipAngle and Azimuth. RockWorks boreholes can be curved (e.g., imagine a corkscrew). Is this something that we need to deal with or can we just take use the DipAngle and Azimuth at the collar and assume that the boreholes are all straight lines? If the RockWorks borehole has no downhole survey data, RockWorks assumes that it's a perfectly straight vertical line and we can leave these fields blank (just like your example). The 2_DummyLabel_List.csv file also looks very straightforward and we can easily add a subroutine (called "Export_RockWorks_Lithology_To_Leapfrog") that creates a CSV file as per your example. I'm assuming that there's a tool in LeapFrog to assign colors and patterns to these keywords. Correct? LAS files are not as straightforward. Although RockWorks can import LAS files, it can't export to LAS. I'm assuming that you are getting the LAS files from elsewhere and importing them into both RockWorks and LeapFrog in which case it shouldn't matter. Correct? Best regards, Jim. Link to comment Share on other sites More sharing options...
Ali shokouhi Posted July 14, 2022 Author Share Posted July 14, 2022 Hi Jim, Please note the following responding to your questions: 1 - Let's use the DipAngle and Azimuth at the collar and assume that the boreholes are all straight lines. We seldom do directional drilling. 2 - I’ll need to check, but assume there will be. 3 - LF already can deal with LAS file directly, so if you have LAS files from your work, it can suck them in…. my point here was around outputs from CPTs (not sure sorry what format these are in) e.g. if you wanted to show a CPT strength with depth graph for instance, this can be shown also within LF. The LAS format will come straight in, but there are other standard LF formats for downhole testing data, which is basically (HoleID, Depth of Variable, and Variable Value – as a csv). Thank you very much. Best regards. Ali Link to comment Share on other sites More sharing options...
JimReed Posted July 17, 2022 Share Posted July 17, 2022 Hi Ali, Thanks for the clarifications. We should have a prototype by tomorrow morning. I will keep you posted. Best regards, Jim. Link to comment Share on other sites More sharing options...
JimReed Posted July 18, 2022 Share Posted July 18, 2022 Hi Ali, The attached PDF describes a new program that is hopefully what you're looking for. Please note the question about column titles at the end of the document. We will be creating a test version tomorrow and I will send you a DropBox link to download this new version. Best regards, Jim. Leapfrog_Export.pdf Link to comment Share on other sites More sharing options...
JimReed Posted July 18, 2022 Share Posted July 18, 2022 Here's the link to the new version: https://www.dropbox.com/s/2irepaxs0pjax17/rockworks20_installation.exe?dl=0 Link to comment Share on other sites More sharing options...
Ali shokouhi Posted July 18, 2022 Author Share Posted July 18, 2022 Hi Jim, Thank you very much. I tried to output the data but I got the error below. Please advise me how can I solve the problem. Best regards, Ali Link to comment Share on other sites More sharing options...
JimReed Posted July 18, 2022 Share Posted July 18, 2022 Hi Ali, Which version do you have? - Jim. Link to comment Share on other sites More sharing options...
Ali shokouhi Posted July 18, 2022 Author Share Posted July 18, 2022 Hi Jim, Version 2022.7.17. Thanks Ali Link to comment Share on other sites More sharing options...
JimReed Posted July 18, 2022 Share Posted July 18, 2022 Sorry, I meant Basic, Standard, or Advanced. I'd ask our support folks but they've left for the day. Link to comment Share on other sites More sharing options...
Ali shokouhi Posted July 18, 2022 Author Share Posted July 18, 2022 I am not sure Jim. Will ask and let you know. Thanks Ali Link to comment Share on other sites More sharing options...
JimReed Posted July 18, 2022 Share Posted July 18, 2022 If you click on the License option at the top of the main RockWorks menu it will show something like this: Link to comment Share on other sites More sharing options...
Ali shokouhi Posted July 18, 2022 Author Share Posted July 18, 2022 It is Standard. Link to comment Share on other sites More sharing options...
JimReed Posted July 18, 2022 Share Posted July 18, 2022 Thanks Ali! I'll make it available within the Standard version, recompile, and send you a link to a newer version. It will probably take about 15 minutes but I'll get it done before going home. - Jim. Link to comment Share on other sites More sharing options...
JimReed Posted July 18, 2022 Share Posted July 18, 2022 Hi Ali, My bad. It should not have been part of the Advanced version. Here's a new installation where it's classified as "Standard". - Jim. https://www.dropbox.com/s/2irepaxs0pjax17/rockworks20_installation.exe?dl=0 Link to comment Share on other sites More sharing options...
JimReed Posted July 18, 2022 Share Posted July 18, 2022 I'll check my email later this evening to make sure it worked for you. Link to comment Share on other sites More sharing options...
Ali shokouhi Posted July 18, 2022 Author Share Posted July 18, 2022 Thank you very much. Ali Link to comment Share on other sites More sharing options...
Ali shokouhi Posted July 18, 2022 Author Share Posted July 18, 2022 Hi Jim, Unfortunately it did not work and got the following error. The spreadsheets of lithology, Location and Pdata were built in the folder but they are empty. In addition, could you also please add stratigraphy spreadsheet? We are contacting our client (who needs the leapfrog input) asking how to include the stratigraphy in the leapfrog. Thank you very much. Best regards, Ali Link to comment Share on other sites More sharing options...
JimReed Posted July 19, 2022 Share Posted July 19, 2022 Hi Ali, Darn! I have no idea what's going on. I can have you try all sorts of stupid stuff to narrow-down on the problem but we can fix it quickly if you could please send me the SQLite database. My email address is jim@rockware.com. In the meantime, we will start in on the stratigraphy export. Best regards, Jim. p.s. Could you have a look at my last question in the PDF and let me know what you think. Link to comment Share on other sites More sharing options...
Ali shokouhi Posted July 19, 2022 Author Share Posted July 19, 2022 Hi Jim, Thank you very much. Regarding the SQL database, please let me know how can I get it to send you. Regarding the last question in the PDF, Please note Leadfrog doesn’t need the column titles (e.g. could have different titles and would still work, or no titles). But we do need to know which columns are which – so they can be assigned to the correct element during the Import – but as long as we know the order of the columns then that is fine. Best regards, Ali Link to comment Share on other sites More sharing options...
JimReed Posted July 19, 2022 Share Posted July 19, 2022 Hi Ali, There's a file in your Project Folder with a ".sqlite" suffix. For example, if yout project folder is called "Project_A" there will be a file within this folder titled "Project_A.sqlite" , ). This is the database. The database will always have the same name as the project folder. They're usually not to big so you should be able to sent it as an email attachment. If, the database is too large, you can use the Borehole Manager / File / Backup Database option to save it as a zip file within the Backup folder (located inside the project folder) and send that. Thanks for the clarification on the column titles. We'll change them to be "hardwired" with sensical titles which will simplify the menu and hopefully eliminate some potential confusion. Best regards, Jim. Link to comment Share on other sites More sharing options...
JimReed Posted July 19, 2022 Share Posted July 19, 2022 Hi Ali, I'm going to head off to bed now. Unfortunately, I'm leaving town on Wednesday - returning on Monday so I'd really like to get everything working before I leave. Otherwise, one of the other programmers will need to take over which means they'll need some time to understand what's been done (i.e., more delays). In the meantime, the stratigraphy export has been added, the column titles are now hardwired, and the column-titles tab has been eliminated. Once I figure out why it works with the Samples folder but not with your data, I'll be able to fix the problem and get you a new version. Best regards, Jim. Link to comment Share on other sites More sharing options...
Ali shokouhi Posted July 19, 2022 Author Share Posted July 19, 2022 Hi Jim, Thank you very much. I sent you our SQLite database. Best regards, Ali Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now