Pick r83 to jbase conversion

382 views
Skip to first unread message

David Grenfell

unread,
Feb 28, 2012, 8:10:57 AM2/28/12
to jb...@googlegroups.com
Gentlemen:
 
I am coming out of retirement to help out an old client.  After 27 years of running on PICK R83, I have convinced him it is time to upgrade.
 
Here is my problem:
 
They backup their files on to a wangek streaming tape.  The controller card is a wangtek 30850-008.
 
I have a computer (p233) that has the 8 bit slot that will accomodate this card.  I have Windows 2000 installed on this system.  I have installed jbase 3.10 eval.  However, jbase will not access the tape drive.   I guess what I need now are installation instructions and probably a driver for this card.  Can any-one guide me through this?
 
Dave

Tony Gravagno

unread,
Feb 28, 2012, 1:15:58 PM2/28/12
to jB...@googlegroups.com
Dave, good to see you here.

Check out SAVE.RESTORE.AT, which is freeware that I published recently
on my site (http://Nebula-RnD.com/freeware). It allows you to
save/restore entire accounts between any MV systems through AccuTerm.
That completely eliminates the tape issue. I just did a R83/D3
migration and this will help for R83/jBase as well.

I’ll be happy to answer questions about the freeware but it would help
if requests for in-depth assistance were framed in a services
engagement. If you wish, I will be happy to manage the data migration
aspect of your client’s effort, and you can assist with the details of
code conversion, etc.

I'll be happy to provide more info here or via email about how the
utility works.

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula R&D sells mv.NET worldwide
and provides related development services
Remove.pleaseNebula-RnD.com/blog
Visit http://PickWiki.com! Contribute!
http://Twitter.com/TonyGravagno
http://groups.google.com/group/mvdbms/about

David Grenfell

unread,
Feb 28, 2012, 3:22:04 PM2/28/12
to jb...@googlegroups.com
Tony:  Thanks for this.
 
I am assuming that both R83 and Jb must be up and running at the same time to use this.  I just installed jb and r83 on to the same box so obviously can only run one at  a time.  I will however, be obtaining jb 4.x shortly, so will put it on another box and Accuterm also.  I will keep you informed of progress.
 
Dave
 
> --
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>
> To post, send email to jB...@googlegroups.com
> To unsubscribe, send email to jBASE-un...@googlegroups.com
> For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

Dick Thiot

unread,
Feb 28, 2012, 4:21:50 PM2/28/12
to jb...@googlegroups.com
David,

Is there a reason to go with jBASE 4 as opposed to jBASE 5?

Also, I am not sure about Tony's app but I will venture a guess that it can use Accuterm's concept of intermediary files so that you can transfer out from one system then transfer in at a different time.

Dick

Tony Gravagno

unread,
Feb 28, 2012, 5:40:16 PM2/28/12
to jB...@googlegroups.com

Yes, that’s how it works. One site has been using it for nightly R83 backups until we can get them migrated to D3. It’s a heck of a lot better than trying to do it by floppy.

T

Doug Owens

unread,
Feb 28, 2012, 4:50:12 PM2/28/12
to jb...@googlegroups.com

Remember, jBASE v5 is a 64bit implementation.

 

 

Doug

 

Douglas Lee Owens

Ashwood Computer, Inc.

10671 Techwoods Circle

Cincinnati, OH 45242

Office (513) 563-2800

Cell (513) 312-0341

Tony Gravagno

unread,
Feb 28, 2012, 4:45:16 PM2/28/12
to jB...@googlegroups.com

Dave –  I updated the sparse documentation with information that responds to your points below. I will be happy to work with you (or anyone) to ensure the utility can be understood for productive usage.

http://Nebula-RnD..com/freeware/SRAT_README.txt

(Look for “28-Feb-2012 Update”)

I did not fill in the jBase-specific bits of code myself (I’ve only used it for D3 so far) so I’m particularly interested in helping anyone who wants to get this fully working for jBase – and then of course I’d like to roll all changes back into the freeware source package!

 

Regards,

T

 

From: David Grenfell

 

Tony:  Thanks for this.
 
I am assuming that both R83 and Jb must be up and running at the same time to use this.  I just installed jb and r83 on to the same box so obviously can only run one at  a time.  I will however, be obtaining jb 4.x shortly, so will put it on another box and Accuterm also.  I will keep you informed of progress.
 
Dave
 

> From: Tony
> Dave, good to see you here.
>
> Check out SAVE.RESTORE.AT, which is freeware that I published recently
> on my site (http://Nebula-RnD.com/freeware). It allows you to
> save/restore entire accounts between any MV systems through AccuTerm.
> That completely eliminates the tape issue. I just did a R83/D3
> migration and this will help for R83/jBase as well.
>
> I’ll be happy to answer questions about the freeware but it would help
> if requests for in-depth assistance were framed in a services
> engagement. If you wish, I will be happy to manage the data migration
> aspect of your client’s effort, and you can assist with the details of
> code conversion, etc.
>
> I'll be happy to provide more info here or via email about how the
> utility works.
>
> Tony Gravagno
> Nebula Research and Development
> TG@ remove.pleaseNebula-RnD.com
> Nebula R&D sells mv.NET worldwide
> and provides related development services
> Remove.pleaseNebula-RnD.com/blog
> Visit http://PickWiki.com! Contribute!
> http://Twitter.com/TonyGravagno

David Grenfell

unread,
Feb 29, 2012, 7:55:02 AM2/29/12
to jb...@googlegroups.com

 
Thanks much Tony:  I am going on vacation tomorrow, so won't be able to respond for a while.  I plan to get into it when I return about March 12.
 
Dave

From: e09k...@sneakemail.com
To: jB...@googlegroups.com
Subject: RE: Pick r83 to jbase conversion
Date: Tue, 28 Feb 2012 13:45:16 -0800

David Grenfell

unread,
Feb 29, 2012, 5:05:38 PM2/29/12
to jb...@googlegroups.com
Tony:
 
I am putting the system together in my head before leaving for vacation so that I can concentrate of relaxing instead of working on the problem when i should be having a rum&coke.
 
I visualize it as this:
 
I will have PICK running on one box and have jbase 10 on xp-pro and Accuterm on a second box.  I will have my xp system connected to PICK with a serial cable, and run your save.restore using Accuterm (also on my xp box).  Will the "save" file be generated on the PICK system or on my xp hard drive?
 
I then must run your program again, this time accessing it on the xp box to restore the saved file.  If this file is on the PICK box, then I must be able to specify it's location in Accuterm, and also where I want to save the restore file. 
 
How am I doing?
 
Dave

 

To: jB...@googlegroups.com
Subject: RE: Pick r83 to jbase conversion
Date: Tue, 28 Feb 2012 13:45:16 -0800


Tony Gravagno

unread,
Feb 29, 2012, 6:00:27 PM2/29/12
to jB...@googlegroups.com

Almost there! The Saved files are pulled from AccuTerm into  your XP. So when the save is complete, you have  a directory with a bunch of files on your PC. If nothing else you now have a good backup of R83 and it’s time to take a vacation!

 

When you’re ready, open a connection into jBase, check the code, compile, create an account, etc. Then run the program to Restore into jBase. You’ll be prompted for the path to the saved files which are on your XP.  You’ll probably need to do this a couple times to get a feel for the process. Be sure you don’t accidentally blow away any changes you make to the MIGRATION.BP programs.

 

Each process is asynchronous, you do the save, stop, restore, stop.  For reference however, you can do multiple saves and restores simultaneously with different AccuTerm sessions – you just wouldn’t be saving and restore the same account at the same time.  Hope that makes sense (and that someone else here gets something out of this J  ).

 

When you get back, feel free to email me direct and we can setup a call to discuss it a little more – I’ll spend some personal time with you to work through some of this.  But like I said, the code is free and open source, but if we’re going to spend any “real” time with it then it would be nice to put an hour on the clock.  (Your client has gotten away without paying for their system for a Long time, it’s not unreasonable to ask them to pay something for a migration.)

 

HTH

T

(Enjoy the vacation!)

David Grenfell

unread,
Mar 14, 2012, 7:51:09 AM3/14/12
to jb...@googlegroups.com
Tony:
 
I'm back, all browned up and ready to begin.  Hit my first snag.  The computer I was going to use for xp/jbase has no serial ports, so will have to look for either an older box, or a serial port card. When I get this put together, I will begin the transfer process. 
 
As an aside, I put R83 on an old Pentium 233 box, and it worked perfectly.  I then installed windows 2000 on the other half of the hard drive, and now seems the only way I can boot PICK is to use the floppy to execute the monitor.  I guess the multiple boot thing doesn't work because windows doesn't recognize the pick partition as valid.
 
I will post progress reports.
 
Dave.
 

To: jB...@googlegroups.com
Subject: RE: Pick r83 to jbase conversion
Date: Wed, 29 Feb 2012 15:00:27 -0800

Dick Thiot

unread,
Mar 14, 2012, 11:37:32 AM3/14/12
to jb...@googlegroups.com
Why do you need serial ports on the jBASE box?  Don't you want to use Telnet for connectivity to jBASE?  Obviously it is MUCH faster.

Dick

Bob Coleman/FCA

unread,
Mar 14, 2012, 11:44:30 AM3/14/12
to jb...@googlegroups.com
You need to add the other partition in your boot.ini.� Windows does not need to understand it, it just needs to know it is there.
�
-------- Original Message --------
From: David Grenfell
Date: 3/14/2012 4:51 AM:
�
As an aside,�I put R83 on an old Pentium 233 box, and it worked perfectly.� I then installed windows 2000 on the other half of the hard drive,�and now seems the only way I can boot PICK�is to use the floppy to execute the monitor.� I guess the multiple boot thing doesn't work because windows doesn't recognize the pick partition as valid.

David Grenfell

unread,
Mar 14, 2012, 3:20:02 PM3/14/12
to jb...@googlegroups.com
Dick:  I need the serial ports to log on to PICK R83 with Accurterm so I can retreive Data from it.  Then I will import it to jbase.
 
Dave. 

Date: Wed, 14 Mar 2012 10:37:32 -0500
Subject: Re: Pick r83 to jbase conversion
From: dick....@gmail.com
To: jb...@googlegroups.com

Tony Gravagno

unread,
Mar 14, 2012, 2:16:43 PM3/14/12
to jB...@googlegroups.com

Partition Commander is the only product outside of our industry that I know of which recognizes the name Pick in its configuration. With that you can multi-boot back and forth.

For this non-jBase phase of your effort I recommend posting to the MVDBMS forum or even the TigerLogic forum.  Once you have the data extracted using MIGRATION.BP you might want to come back here and share notes about jBase-specific requirements.  Call it as you wish.

Good luck!

 

Tony Gravagno

Nebula Research and Development

TG@ remove.pleaseNebula-RnD.com

Nebula R&D sells mv.NET and other Pick/MultiValue products

Worldwide, and provides related development services

Charlie Noah

unread,
Mar 14, 2012, 4:48:02 PM3/14/12
to jb...@googlegroups.com
I would assume that all this would apply to Advanced Pick on an old 486 box as well. I have a lot of stuff there that I wasn't looking forward to T-DUMPing to floppies (yes, they still exist) and T-LOADing into Jbase. I will be watching with great interest, so keep us informed, David!

Thanks,
Charlie Noah
--

mike ryder

unread,
Mar 15, 2012, 4:46:20 AM3/15/12
to jb...@googlegroups.com
Dave,

You are lucky that you have anything of R83 left!

Windows does not acknowledge that there can be any other operating system in th world. If you want to install a second OS (even wen installing Linux) you have to load winblows first.

For serial ports, you can buy a USB-serial adaptor (try maplin)

Mike
To unsubscribe, send email to jBASE-unsubscribe@googlegroups.com

Dick Thiot

unread,
Mar 15, 2012, 11:13:37 AM3/15/12
to jb...@googlegroups.com
David,

You don't need the serial ports on the XP/jBASE machine though.  You need a system with Accuterm that has a serial port but it doesn't have to be the same machine as the jBASE system.  I assumed that you already had a machine with a serial port to access the R83 system.  Sorry.

Dick

David Grenfell

unread,
Mar 15, 2012, 3:17:38 PM3/15/12
to jb...@googlegroups.com
well guys, I have my two boxes side by side with R83 running on a Pentium 233, and my newer xp/pro/jbase box running beside it.  Both are connected with a serial cable and I am able to log on to R83 using "Netterm".  Next step is to get familiar with "Accuterm".  So far, so good.
 
Thanks
 
Dave.
 

 

Tony Gravagno

unread,
Mar 15, 2012, 3:48:03 PM3/15/12
to jB...@googlegroups.com

Congrats on progress so far.

 

It would have been nice for the MVDBMS group to have benefit from the non-jBase aspects of this effort. Oh well.

well guys, I have my two boxes side by side with R83 running on a Pentium 233, and my newer xp/pro/jbase box running beside it.  Both are connected with a serial cable and I am able to log on to R83 using "Netterm".  Next step is to get familiar with "Accuterm".  So far, so good.

Tony Gravagno

unread,
Mar 15, 2012, 12:05:46 PM3/15/12
to jB...@googlegroups.com

Mike - he doesn’t have serial ports and you think he’d have a USB port?  J

A serial port is just a ISA/PCI card, easy to find in most junk shops these days for a couple bucks. I have a box full of them.

 

From there Dave needs a properly pinned serial cable so that he can reach out from one PC with AccuTerm into the R83 box.  Dave, you might need a cross-over adapter for this to swap pins 2/3.  And of course you need to work through whether you’re using a 25pin or 9pin serial adapter on both ends. Oh boy, get out those crimpers and the magnifying glasses…  (Better you than me, bud. ;)  )

 

Another alternative (and much faster though more costly) is to put a NIC in the R83 box and then negotiate a one-time / week-long license with EasyCo for PicLan (http://piclan.com/).  Then you can telnet into R83 and the world becomes a much better place – for this week anyway.

 

Another option that I have never tried – load R83 into a virtual machine (free VMware Player).  You might then be able to somehow connect “virtually”  through the serial port, or use PicLan as above.  The good news here is – No Hardware!  The bad news – you may be on your own in trying to get this to work and there are no guarantees that it will.  You’ll need to look around the VMware forums for anyone trying to make use of virtual serial ports.

 

Completely off-topic for this thread and for jBase, but regarding multiboot with Windows and Linux:

You _can_ install Linux first, then Windows. But you need to go back and re-install GRUB (or other) to the MBR as the bootloader afterward so that you can get a selection when you boot.  As mentioned earlier, I’ve been using Partition Commander for more versatility (and I have something like 8 partitions that I can boot from on one of my boxes).  YMMV

 

HTH

T

Dick Thiot

unread,
Mar 15, 2012, 7:40:31 PM3/15/12
to jb...@googlegroups.com
Tony,

Interesting idea using a virtual machine.  I wonder if we could even run R83 on a virtual box.  Oh well, I guess I don't really care on that one since I hope that I don't run into a R83 box any time soon.  That just jinxed it for me, didn't it?!?!

Dick

--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com

David Grenfell

unread,
Mar 15, 2012, 11:37:22 PM3/15/12
to jb...@googlegroups.com
hey guys.  See my previous post.  I have my serial conection to R83 working just fine.  No need for any further hardware recomendations. :))
 
Dave
 

From: e09k...@sneakemail.com
To: jB...@googlegroups.com
Subject: RE: Pick r83 to jbase conversion
Date: Thu, 15 Mar 2012 09:05:46 -0700
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com

Charlie Noah

unread,
Mar 18, 2012, 9:44:53 AM3/18/12
to jb...@googlegroups.com
I download images from my bird store supplier using FileZilla (FTP). I want to automate the process such that a Jbase program can download an image if it finds that it's not on my system. I have used AIX scripts to move files around on a network before, but I've never done it in XP. Are there any gotchas I should be looking out for? I currently log in using FileZilla as anonymous, no password and port 21.

Thanks,
Charlie Noah

Tiny Bear's Wild Bird Store
"Everything For The Backyard Bird Enthusiast, Except For The Birds"
Info, Forum:  http://www.TinyBearMarketing.com
Store:            http://Stores.TinyBearMarketing.com
Toll Free:       1-855-TinyBear (855-846-9232)

Simon Verona

unread,
Mar 18, 2012, 10:26:19 AM3/18/12
to jb...@googlegroups.com
The "dos" command line supports fto with scripting

Something like :

Ftp /s:myscript.txt

Myscript.txt has the ftp commands in eg

Login
Password
Binary
Lcd mylocaldir
Cd remotedir
Get file
Quit

Hope this helps


Simon Verona 
--

Ed Clark

unread,
Mar 16, 2012, 12:11:29 PM3/16/12
to jb...@googlegroups.com
I don't know about r83, but I run Adds Mentor Pro in vmware fusion with no problem.

Tony Gravagno

unread,
Mar 19, 2012, 3:18:59 AM3/19/12
to jB...@googlegroups.com

Scripting the OS-provided FTP command is always “iffy”.  I highly recommend downloading cURL, and making it a part of your lifelong toolkit. It allows for all kinds of transfers, it’s well supported, very stable, very popular, cross-platform, and is easily scripted from MV.

 

Here are a couple examples that were posted to CDP (RIP) some years ago:

 

https://groups.google.com/d/msg/comp.databases.pick/rrU9W1TsN5E/soRBQiwTPNcJ

 

https://groups.google.com/d/msg/comp.databases.pick/mQm9tcRh1v8/6DJglzGo-DMJ

 

I have a great deal of code based on cURL for use with client projects … not for publication in a forum, sorry.

 

HTH

T

Charlie Noah

unread,
Mar 19, 2012, 8:01:48 AM3/19/12
to jb...@googlegroups.com
Thanks, Simon.

Charlie Noah

unread,
Mar 19, 2012, 8:03:05 AM3/19/12
to jb...@googlegroups.com
Thanks, Tony. I've heard you talk about cURL a number of times. I'll definitely check it out.
Charlie
--

David Grenfell

unread,
Mar 19, 2012, 7:44:37 PM3/19/12
to jb...@googlegroups.com
Tony:
 
Couple of questions to make sure I'm on the right tack here. 
 
Do I create the MIGRATION.BP both in R83 and in jBase?
 
When I run the "save" while logged in R83, is the saved info stored on the XP box ?
 
I haven't used ACCUTERM before, so I might be silent for a couple of days while I try to figure it out.
 
I have your SAVE.RESTORE programs T-DUMPED to a floppy, so am ready to put them to good use.
 
Wish this was just a simple conversion from R83 to jbase, but my jbase version has  a lot of new code (25 years of updates and modifications), and also a lot file structure changes too that I will have to compensate for. 
 
Thanks again for help thus far.  I am doing a detailed documentation of what I am doing, so I can forward to you when finished.
 
Dave.

 

Tony Gravagno

unread,
Mar 19, 2012, 9:01:07 PM3/19/12
to jB...@googlegroups.com
Responses in-line…

From: David Grenfell

>Tony:
>Couple of questions to make sure I'm on the right tack here.
>Do I create the MIGRATION.BP both in R83 and in jBase?


Yes. And the R83 side is already done for you. Note also that the R83 code is broken into a number of includes to keep it below the 32k item size limit, but for jBase you can use the one-item program.


>When I run the "save" while logged in R83, is the saved info stored on the XP box ?

Yes, it’s pulled from AccuTerm and stored in a directory local to your client PC where AccuTerm is running. The idea is that you would open a session into jBase as soon as a R83 save is complete, and then push that data, back through Accuterm, and out into new jBase files.


>I haven't used ACCUTERM before, so I might be silent for a couple of days while I try to figure it out.

IMO, it’s the best MV emulator available.
Quick primer:
You have a layout which is a container for sessions.
Then you have sessions which represent individual connections.
A layout is like a web browser, and sessions are like tabs on the browser which point to individual websites.
So you can open one session to R83, another to jBase, and then save them as a single layout. Open the layout again and your connections are instantly re-established.

Once you have a connection there are many features allowing for data movement between sessions or to/from the PC running a session. There are also GUI features and others which are irrelevant for this exercise. AccuTerm does not include non-MV features like AnzioWin or others, but all of the same functionality is possible using scripting. (I’m not using scripting in the migration code, just file transfers.)

I just got off the phone with a colleague and we were going over their GUI options. For a simple GUI effort, there are around 4 options in AccuTerm for varying degrees of quality. All of those can be done by a BASIC programmer. From there the next step is to consider other technologies and products, so there are Lots of options for cost, time, and skills when someone says “I need a new GUI”. For our purposes, the point here is that AccuTerm is much more than a simple terminal emulator, so you may want to consider using it for a variety of purposes. Feel free to email with questions.


>I have your SAVE.RESTORE programs T-DUMPED to a floppy, so am ready to put them to good use.

Wish this was just a simple conversion from R83 to jbase, but my jbase version has a lot of new code (25 years of updates and modifications), and also a lot file structure changes too that I will have to compensate for.

Source code will come over from program files. Make sure you have backups in jBase, and look at the code to see how it decides whether to over-write existing files. Rather than trying to pull data into an application account that has been prepared for application processing. I recommend creating a new account in jBase, pulling all data over, and then working with the results. This separates tasks, with data migration being one, and application upgrade being another.



>Thanks again for help thus far. I am doing a detailed documentation of what I am doing, so I can forward to you when finished.

>Dave.

Now THAT is great news, thanks. Your docs and code updates will be posted for others. Please don’t hesitate to email with basic questions – or to ask your client if we can put something more significant on the clock. ☺
T

David Grenfell

unread,
Mar 21, 2012, 4:13:03 PM3/21/12
to jb...@googlegroups.com

 
Tony:
 
Sorry for being such a dork, but have to ask any-way.
 
I have my migration.bp file on R83 with SAVE.RESTORE.AT, 1,2,3 ETC and also XBASIC.  I tried to "BASIC" the SAVE.RESTORE.AT item, but came up with a bunch of compiler errors, So I attempted to repair the code, but then realized that perhaps I should leave it alone and run XBASIC on it .  I attempted to compile XBASIC, but got some errors, and patched so it will run.  So it is now asking me for following and my responses are:
 
File name > MIGRATION.BP
Item.name> SAVE.RESTORE.AT
Operating Environment > R83
Precompile for R83 > Y
Leave Source ? Y
Precompiling SAVE.RESTORE.AT FOR R83...
Compiling SAVE.RESTORE.AT ...
..
*I331
*  (IT STOPPED HERE)
so I ended it.
*END
>
 
So, I suppose I should restore MIGRATION.BP items to your original code and run XBASIC on them again as above.??
 
In orther words, can you confirm that I should start over and follow the XBASIC ROUTE ?
 
 
Dave
 
 
 
> From: e09k...@sneakemail.com
> To: jB...@googlegroups.com
> Subject: RE: Pick r83 to jbase conversion
> --
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>
> To post, send email to jB...@googlegroups.com
> To unsubscribe, send email to jBASE-un...@googlegroups.com

Tony Gravagno

unread,
Mar 21, 2012, 5:11:11 PM3/21/12
to jB...@googlegroups.com

I believe the issue is that in R83 there are the multiple items broken up into Include items.  So try this:

 

BASIC MIGRATION.BP XBASIC   <<< that should compile with no issues

CATALOG MIGRATION.BP XBASIC

 

SSELECT MIGRATION.BP = “SAVE]”

XBASIC

File =MIGRATION.BP

Item.Name =     <<enter>>

Precompile Y

Compile NO  … you don’t want to compile Include items.

 

When that’s done, BASIC MIGRATION.BP SAVE.RESTORE.AT.

That will pull in the Includes.

 

HTH

T

David Grenfell

unread,
Mar 21, 2012, 8:41:36 PM3/21/12
to jb...@googlegroups.com
Sorry Tony:  see below
 

From: e09k...@sneakemail.com
To: jB...@googlegroups.com
Subject: RE: Pick r83 to jbase conversion
Date: Wed, 21 Mar 2012 14:11:11 -0700

I believe the issue is that in R83 there are the multiple items broken up into Include items.  So try this:

 

BASIC MIGRATION.BP XBASIC   <<< that should compile with no issues

 

There are issues with this compile.

 

says line 159 is a bad statement.  Looking at the code I see "...OKAY = TRUE"

 

Then several more error messages such as LINE 158 "ELSE" CLAUSE MISSING

There are also a couple of Blank lines , that R83 CANNOT HANDLE.  On one of my instances of trying to correct, I removed these two blank lines.

 

Perhaps this is a version for another mvdb system.

Dave

Tony Gravagno

unread,
Mar 22, 2012, 3:47:30 AM3/22/12
to jB...@googlegroups.com
David, I see you are correct. Responses below.


Tony wrote:
> > BASIC MIGRATION.BP XBASIC   <<< that should compile with no issues

> There are issues with this compile.
> says line 159 is a bad statement.  Looking at the code I see
"...OKAY = TRUE"

Those three dots are tabs that must have got into the code when I did
a Format or transfer between OS’s.
Just replace the tabs with spaces. (Position on the K, hit delete
several times, fill in the O).


> Then several more error messages such as LINE 158 "ELSE" CLAUSE
MISSING

Yup, I missed that. On line 160, from the READ ITEM block, change END
to END ELSE NULL.

> There are also a couple of Blank lines , that R83 CANNOT HANDLE.
> On one of my instances of trying to correct, I removed these two
blank lines.

Yup, missed those too, probably in later re-formatting.

When you're done here we should send Kevin King a revised version of
XBASIC.
 
Please feel free to email me notes like this so that we don’t bore our
colleagues. When you have a working version of the package for jBase
I’m sure people will be more interested in details.

Good luck,
T

O'Tunji Agbaje

unread,
Mar 23, 2012, 3:04:12 AM3/23/12
to jb...@googlegroups.com, jb...@googlegroups.com
Hello,

Does anyone know the name of the tool for migrating jBASE to ORACLE?

Regards,

Tunji


Daniel Klein

unread,
Mar 23, 2012, 10:06:58 AM3/23/12
to jb...@googlegroups.com
Yes, it's called 200 more programmers than what you have for jBASE ;-)

Dan

Richard Kann

unread,
Mar 23, 2012, 10:19:27 AM3/23/12
to jb...@googlegroups.com
But if you can afford Oracle you can afford those extra people.

Simon Verona

unread,
Mar 23, 2012, 10:25:07 AM3/23/12
to jb...@googlegroups.com
Are you looking to retain your jBASE code, and simply store the data in
Oracle? If so then you need a "jedi" driver for Oracle - I'm sure jBASE
can provide you with one.

If you are looking for a permanent migration, then you will probably
need to write something custom to export in a format that you can then
bulk upload into Oracle (I'm no expert in this area)

Hope this helps

Simon

=======================================
Simon Verona
Director
Dealer Management Services Ltd
T: 0845 686 2300
========================================

Dick Thiot

unread,
Mar 23, 2012, 11:36:22 AM3/23/12
to jb...@googlegroups.com
Tunji,

Simon asks a good question and I would like to ask it in a different way.  Are you wanting to convert data or are you trying to convert your application?  Data can be migrated and/or interchanged with Oracle but unless you are well versed in the schema of your data in jBASE you may need the assistance of whomever wrote your software.  Are you a Temenos customer?

Dick

--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-unsubscribe@googlegroups.com

O'Tunji Agbaje

unread,
Mar 24, 2012, 3:04:38 AM3/24/12
to jb...@googlegroups.com
Thank you Simon.

It is a permanent migration of data from jBASE to ORACLE in a T24 environment after upgrade.

Tunji AGBAJE
Sent from my iPad

> --
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>
> To post, send email to jB...@googlegroups.com

> To unsubscribe, send email to jBASE-un...@googlegroups.com

O'Tunji Agbaje

unread,
Mar 27, 2012, 6:20:19 AM3/27/12
to jb...@googlegroups.com
Hello,

Yes, we want to convert data through standard upgrade process in T24 but after the upgrade, we would like to migrate the data from jBASE to ORACLE.


Tunji AGBAJE
Sent from my iPad
To unsubscribe, send email to jBASE-un...@googlegroups.com

Babatunde Adebayo

unread,
Mar 27, 2012, 4:19:31 PM3/27/12
to jb...@googlegroups.com
Hello,
My first thought is to be clear on your reasons for migration to Oracle (this may be wrongly assumed to be obvious), be that as it may.
1. You may want to simply migrate data and end there (1st phase) with Oracle as datastore only and retain your jbase code
Or
2. you may require to do some jbase code conversion as 2nd phase of your migration. This would strongly depend on functions and features you plan to take advantage of in Oracle.

Regards
Sage

VK

unread,
Mar 28, 2012, 2:13:48 AM3/28/12
to jBASE
Hi guys,
we're talking here about standard Temenos procedure of "jbase->Oracle"
conversion which consists of transformation of jbase data to Oracle
(XML) using a standard Temenos tool. Don't remember the name but
Temenos could be asked for that.

All code remains mostly the same (except where you deal with files
distribution or jbase triggers etc). Compatibility of code is provided
by Temenos Oracle Direct Connect driver (or it was called that last
time I checked).

Oracle is just a storage - data in XLM and indices (so - no stored
procedures etc AFAIK). But one surely needs much more powerful
hardware and additional work force on Oracle side.

So this post is purely T24-related.

VK

On Mar 27, 10:19 pm, Babatunde Adebayo <tunde.adeb...@gmail.com>
wrote:
> Hello,
> My first thought is to be clear on your reasons for migration to Oracle
> (this may be wrongly assumed to be obvious), be that as it may.
> 1. You may want to simply migrate data and end there (1st phase) with
> Oracle as datastore only and retain your jbase code
> Or
> 2. you may require to do some jbase code conversion as 2nd phase of your
> migration. This would strongly depend on functions and features you plan to
> take advantage of in Oracle.
>
> Regards
> Sage
>
> On Tuesday, March 27, 2012, O'Tunji Agbaje <tagbaje2...@yahoo.co.uk> wrote:
> > Hello,
> > Yes, we want to convert data through standard upgrade process in T24 but
>
> after the upgrade, we would like to migrate the data from jBASE to ORACLE.
>
> > Tunji AGBAJE
> > Sent from my iPad

Lior-TIS

unread,
Mar 29, 2012, 3:55:19 AM3/29/12
to jBASE
Hello,

Please note that while the conversion procedure is purely technical it
does not end there.

Working with Oracle requires more resources, i.e. you will need more
CPU power and more hard disk than jBASE used.
In addition after the conversion you will need to invest time in
performance tuning, both on the Oracle side and the T24 side.

Lior

On Mar 27, 11:20 am, O'Tunji Agbaje <tagbaje2...@yahoo.co.uk> wrote:
> Hello,
>
> Yes, we want to convert data through standard upgrade process in T24 but after the upgrade, we would like to migrate the data from jBASE to ORACLE.
>
> Tunji AGBAJE
> Sent from my iPad
>
> On 23 Mar 2012, at 16:36, Dick Thiot <dick.th...@gmail.com> wrote:
>
>
>
>
>
>
>
> > Tunji,
>
> > Simon asks a good question and I would like to ask it in a different way.  Are you wanting to convert data or are you trying to convert your application?  Data can be migrated and/or interchanged with Oracle but unless you are well versed in the schema of your data in jBASE you may need the assistance of whomever wrote your software.  Are you a Temenos customer?
>
> > Dick
>
> > On Fri, Mar 23, 2012 at 9:25 AM, Simon Verona <si...@dmservices.co.uk> wrote:
> > Are you looking to retain your jBASE code, and simply store the data in Oracle?  If so then you need a "jedi" driver for Oracle - I'm sure jBASE can provide you with one.
>
> > If you are looking for a permanent migration, then you will probably need to write something custom to export in a format that you can then bulk upload into Oracle (I'm no expert in this area)
>
> > Hope this helps
>
> > Simon
>
> > =======================================
> > Simon Verona
> > Director
> > Dealer Management Services Ltd
> > T: 0845 686 2300
> > ========================================
>
> > On 23/03/2012 07:04, O'Tunji Agbaje wrote:
> > Hello,
>
> > Does anyone know the name of the tool for migrating jBASE to ORACLE?
>
> > Regards,
>
> > Tunji
>
> > --
> > IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>
> > To post, send email to jB...@googlegroups.com
> > To unsubscribe, send email to jBASE-un...@googlegroups.com
> > For more options, visit this group athttp://groups.google.com/group/jBASE?hl=en

code24 code

unread,
Mar 29, 2012, 5:55:46 AM3/29/12
to jb...@googlegroups.com
check the jbase site the is a tool for extracting data to RDBMS from jbase, i think it its called jbuilder

On Thu, Mar 29, 2012 at 9:55 AM, Lior-TIS <yis...@gmail.com> wrote:
Hello,
s called jbi

David Grenfell

unread,
Apr 12, 2012, 6:54:07 PM4/12/12
to jb...@googlegroups.com
Charlie:
 
You were wanting me to report back on my progress.  So here goes.  I have had a lot of support from Tony, but because I was not familiar with Accuterm, I came accross as a bit of a dummy.  I am however, getting familiar with accuterm.
 
Here are my actual results.  I have Accuterm loaded on my XP-PRO/JBASE systerm with a serial connection into my R83 box.  With some guidance from Peter at Accuterm, I did a file transfer from R83 to a DOS intermediate file on my XP BOX, because this apparently is the fastest way to get data over.  My baud rate is 19200.  I had an approximately 21mb file with 67435 items .  The transfer took just over 7 hours.  I did the same transfer with T-DUMP/T-LOAD in just under an hour.  So, don't throw out your floppies. I could have done it quicker, but I was only using one floppy, and sat there while the process was running.
 
I have to use conversion routines on these files to upgrade them to my newer software configurations.  Once I have all the conversion programs in place, I will dump my clients final data to my developement box and upgrade them.  There are many files, as you know in an accounting system, and a lot of them need conversions done, so I can't be held up by slow transfers, because my client cannot afford to be without his computer system for a long period of time.  So T-dumps it will be, since this still seems to be the fastest way for me.
 
Dave.
 

Date: Wed, 14 Mar 2012 15:48:02 -0500
From: cwn...@comcast.net
To: jb...@googlegroups.com
Subject: Re: Pick r83 to jbase conversion

I would assume that all this would apply to Advanced Pick on an old 486 box as well. I have a lot of stuff there that I wasn't looking forward to T-DUMPing to floppies (yes, they still exist) and T-LOADing into Jbase. I will be watching with great interest, so keep us informed, David!

Thanks,
Charlie Noah

On 03-14-2012 1:16 PM, Tony Gravagno wrote:

Partition Commander is the only product outside of our industry that I know of which recognizes the name Pick in its configuration. With that you can multi-boot back and forth.

For this non-jBase phase of your effort I recommend posting to the MVDBMS forum or even the TigerLogic forum.  Once you have the data extracted using MIGRATION.BP you might want to come back here and share notes about jBase-specific requirements.  Call it as you wish.

Good luck!

 

Tony Gravagno

Nebula Research and Development

TG@ remove.pleaseNebula-RnD.com

Nebula R&D sells mv.NET and other Pick/MultiValue products

Worldwide, and provides related development services

Remove.pleaseNebula-RnD.com/blog

Visit http://PickWiki.com! Contribute!

http://Twitter.com/TonyGravagno

NEW! http://groups.google..com/group/mvdbms/about

 

 

From: David Grenfell

I'm back, all browned up and ready to begin.  Hit my first snag.  The computer I was going to use for xp/jbase has no serial ports, so will have to look for either an older box, or a serial port card. When I get this put together, I will begin the transfer process. 
 
As an aside, I put R83 on an old Pentium 233 box, and it worked perfectly.  I then installed windows 2000 on the other half of the hard drive, and now seems the only way I can boot PICK is to use the floppy to execute the monitor.  I guess the multiple boot thing doesn't work because windows doesn't recognize the pick partition as valid.
 
I will post progress reports.

 

--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

Charlie Noah

unread,
Apr 12, 2012, 8:28:16 PM4/12/12
to jb...@googlegroups.com
Hi Dave,

Thanks for the update. It looks like T-DUMP is the way to go. I haven't had a chance to play with it any more since we last corresponded. I'll probably get #1 son to bring my old AP machine downstairs from my old office, since I can't climb the stairs very well anymore. Sure glad I bought an external floppy for my XP machine.

Charlie

Tony Gravagno

unread,
Apr 12, 2012, 9:29:00 PM4/12/12
to jB...@googlegroups.com

Correction...  T-dump is the way for _Dave_ to go. Respectfully, he had many issues in using the freeware which had nothing to do with that software itself, though in fairness he helped to improve the code and packaging as well. Someone else would have a different experience and therefore their conclusions may be different.

 

Dave is correct that moving data across the wire can take a long time. For this reason it's fault-tolerant and can continued in the save and restore wherever it left off. It was intended to be used in an environment where it was otherwise impossible to get a save, not in an environment where the time to get a save was inconvenient. Dave has been lucky to have options that others may not have.

 

T-Dump is viable if you have a floppy drive and time to sit there with floppies. I wrote the freeware for a site that required over 100 floppies for a single save, and after days of trying they couldn't get a single good restore. I've seen that scenario play out many times. For some sites the hardware is so crippled that the floppy drive isn't even active. With the software solution, the save/restore process can also be done remotely, not an option with floppies.

 

It's unfortunate that Dave was unable to use the software successfully, but that experience should not be used as a guide for someone else who is facing a similar challenge.

 

I still welcome a contribution to the SAVE.RESTORE.AT FOSS utility for moving data to and from jBase. I'll be happy to provide the latest version and guidance to anyone interested. It would be nice for the utility to be ready for a jBase user whenever they need it, rather than struggling with customizations when they're attending to other emergencies.

 

Tony Gravagno

Nebula Research and Development

TG@ remove.pleaseNebula-RnD.com

 

 

 

From: Charlie Noah

Thanks for the update. It looks like T-DUMP is the way to go. I haven't had a chance to play with it any more since we last corresponded. I'll probably get #1 son to bring my old AP machine downstairs from my old office, since I can't climb the stairs very well anymore. Sure glad I bought an external floppy for my XP machine.

Charlie Noah

unread,
Apr 13, 2012, 5:57:36 AM4/13/12
to jb...@googlegroups.com
Hi Tony,

I'd really like to get the latest version of SAVE.RESTORE.AT FOSS. I didn't mean to imply that T-DUMP was the way to go for everyone - sorry I wasn't clear. If your utility can make the process easier and more reliable than floppies, I'm all for it. Time isn't really an issue as I can just let it run while I'm doing other things. Floppies could still be a fall-back.

Thanks,
Charlie
--
Reply all
Reply to author
Forward
0 new messages