 |
|
| Computers Forum Index » Computer - Databases - Pick » How to automatically transfer data from QM to QM or D3... |
|
Page 1 of 1 |
|
| Author |
Message |
| ... |
 Posted: Wed Sep 16, 2009 2:17 pm |
|
|
|
Guest
|
I'm looking to develop an application in QM that I would deliver to
our clients. They would then be able to update their data on a regular
schedule (either manually started or on a phantom). Basically they
will have some simple GUI applications in Accuterm that allow them to
maintain their accounts, once uploaded they will get updated/created
in our system for billing and collection. As we add remarks, collect
payments, etc it would update back to the client for their accounts
only.
I am looking at this to allow offline handling of their data in case
of Internet connection issues, then when the link is back all new
updates could be pulled/pushed.
I am trying to figure out the best way to transmit the data. Right
now I have an FTPS server that I am thinking of pushing the raw
database files from QM up there, another QM server would then attach
those files, import the data and send it into our D3 system that runs
our current system. The same idea only in reverse to update the
clients system.
Thought, ideas?
Thanks,
Marshall |
|
|
| Back to top |
|
|
|
| Martin Phillips... |
| Posted: Wed Sep 16, 2009 4:34 pm |
|
|
|
Guest
|
Hi Marshall,
There appear to be two separate data transfer steps here; one QM to
QM, the other QM to D3.
The QM to QM one is best solved using QMNet. We have a system here
that is somewhat similar in that it updates files on a PDA from the
main licensing server. We achieve this by using a trigger on the files
we want to replicate that logs changes in a log file (just one, shared
by all the replicated files). When we want to update the PDA, we make
a QMNet connection and read the log file, deleting the records as they
are applied on the PDA. If no network connection is available, the
update is delayed.
You talk about "pushing the raw database files from QM". This will be
fine as an alternative approach so long as the file is not open to any
QM users when you do this. If it is open, you run the risk of getting
an inconsistent file.
For the QM to D3 transfer, you need to find a way to push data into
D3. If D3 can read flat text files, this might be the easiest route.
If there is a socket based interface, it might be interesting to write
a Virtual File System handler to make the D3 file system visible to QM
though that requires the commercial QM product rather than the open
source version that you appear to be using.
Martin Phillips, Ladybridge Systems. |
|
|
| Back to top |
|
|
|
| ... |
| Posted: Wed Sep 16, 2009 5:48 pm |
|
|
|
Guest
|
I like the idea of a trigger, but I'm not sure how to update multiple
clients with only their data at multiple sites. Updating from the
client to us is pretty easy and makes sense though. I will look at
QMNet and how it works so I can figure out that part (and maybe the
other way too).
As far as QM to D3, not a big deal as I can push out flat data to a
path on my internal network then D3 will watch for data and pick it up
and push back data the same way and QM can watch for that.
I think this will work, I'm getting really excited about it.
Thanks,
Marshall |
|
|
| Back to top |
|
|
|
| eppick77... |
| Posted: Wed Sep 16, 2009 6:00 pm |
|
|
|
Guest
|
On Sep 16, 1:48 pm, mlu... at (no spam) doxgroup.com wrote:
Quote: I like the idea of a trigger, but I'm not sure how to update multiple
clients with only their data at multiple sites. Updating from the
client to us is pretty easy and makes sense though. I will look at
QMNet and how it works so I can figure out that part (and maybe the
other way too).
As far as QM to D3, not a big deal as I can push out flat data to a
path on my internal network then D3 will watch for data and pick it up
and push back data the same way and QM can watch for that.
I think this will work, I'm getting really excited about it.
Thanks,
Marshall
Marshall,
We use QMNET all the time and it is great to use. It will allow you
to treat a file on the other QM system as if it was local and do
record locking on it.
We are using it currently to move programs and data from our
production server to our development server.
Eugene |
|
|
| Back to top |
|
|
|
| Tony Gravagno... |
| Posted: Thu Sep 17, 2009 12:59 am |
|
|
|
Guest
|
QM has Directory files and D3 does the exact same thing with OSFI. So
assuming you write to a Dir file from QM, you can transfer data any
way you want, then dump it into some directory on the target machine.
D3 will see it there, maybe with a phantom running a periodic Select
statement to poll the file for new data, and the data can be read in
with common OPEN/READ. Again, QM is exactly the same. That's all
there is too it. You don't need to go QM<>D3, just write to files.
If this were my system I would write a bit of middleware (might be as
simple as a BAT file executed with Windows scheduler) that waits for
data to appear in a source directory, then transmit it to another
system in a specified target directory. I might script an FTP client
like cURL to do that. For something more polished I'd write a Windows
Service to run in the background, monitor the file system, and use
native FTP transfer. The same code can be used on both ends of the
pipe, serving as both sender and receiver as required.
If all data is on the same system, you can OPEN/READ/WRITE everything
with BASIC, sharing file system directories, with no special
consideration for the file system at all. I do this with all of my MV
environments (I typically run at least 7 databases concurrently):
copy from D3FileX to UVFileY to CachéFileZ ...
For any other "can I move MV data to ...anywhere else...", have a look
at my blog:
nospamNebula-RnD.com/blog/tech/mv/2009/08/mv-to-anything.html
In short, don't make MV<>target your first approach. Go
MV<>middletier<>target. It's almost always a Lot easier.
HTH
Tony Gravagno
Nebula Research and Development
TG at (no spam) 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 PickWiki.com! Contribute! |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Sun Nov 29, 2009 1:13 am
|
|