|
FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile |
| | | | | |
| Iniciado por gallen.dbmc, 05,jul. 2015 03:07 - 4 respuestas |
| |
| | | |
|
| |
Miembro registrado
31 mensajes |
|
| Publicado el 05,julio 2015 - 03:07 |
Hi
I am a new WinDev developer (a couple of days!) but I have been programming for 35+ years.
I have several projects which I would like to move to WinDev. These have mostly been developed in Alaska Xbase++ using FOXCDX and DBFNTX files.
I'm looking for some guidance in importing these into HFSQL (probably client/server).
There is a wizard mentioned in the docs for importing from xbase but it doesn't appear to exist on my system.
Thanks
Garry Allen
--
Garry |
| |
| |
| | | |
|
| | |
| |
| Publicado el 06,julio 2015 - 14:58 |
Hi Garry and welcome to the WinDev world 
before you try importing your data, I STRONGLY suggest that you take the
time to follow in details the tutorial that comes with windev. This will
be some time spent with a huge ROI.
Then, you have to define more closely what you want to do:
- import your database once?
- create a process that will import the data from customers installed DB?
Finally, in both case, you'll start by importing the external base
description in your analysis... Depending on the answer above, you
should do it as xbase file (multiple imports) or as HFCS classic (import
once)...
If you need multiple import, you'll then define your NEW file structure
and start coding the data transfer between the two
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
Already there: WXShowroom.com, WXReplication (open source)
Coming soon: WXEDM (open source)
More information on http://www.fabriceharari.com
Contact me at:
Email: fabrice@fabriceharari.com
Skype ID: fabriceharari
Tel # in the USA: +1 985 746 1422
Tel # in France: +33 970 444 445 (local number 0970 444 445)
On 7/4/2015 7:07 PM, Garry ALLEN wrote:
Hi
I am a new WinDev developer (a couple of days!) but I have been
programming for 35+ years.
I have several projects which I would like to move to WinDev. These have
mostly been developed in Alaska Xbase++ using FOXCDX and DBFNTX files.
I'm looking for some guidance in importing these into HFSQL (probably
client/server).
There is a wizard mentioned in the docs for importing from xbase but it
doesn't appear to exist on my system.
Thanks
Garry Allen
--
Garry |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,julio 2015 - 00:29 |
Indeed, I went through the entire tutorial and WinDev looks very promising but as soon as I attempted to import data I ran into problems:
The simplest of my apps which I want to convert has its data in a local MySql server but I couldn't get WinDev to connect to it (although I have no problem connecting MYSql WorkBench, Toad, etc.. I then decided to create the data by importing via a script into HFSQL Client/Server but the syntax for HFSQL is so different that I decided to try the wizard for creating the structure and worry about the data later. May attempts later (the wizard is very easy to exit accidentally) I got a script to run successfully, or so I thought, but the resulting data file seemed to have disappeared. I finally created the file in a wizard for HFSQL Classic mode and that's where I am in that project.
As far as xBase files are concerned, although I wasn't successful with the wizards. I found that Drag and Drop appeared to work.
I suspect that many of my problems have to do with being a WinDev neophyte and will gradually diminish! |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,julio 2015 - 21:15 |
Follow up...
I rebooted and restarted WinDev and lo and behold I had no problem accessing my MySQL files and importing them!
Onwards and upwards. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 09,julio 2015 - 17:54 |
Hi Garry,
welcome to WinDev. I remember your name from the times where I used to work with Xbase++ myself.
You have several possibilities:
a) import your data from DBF to HFSQL
b) import into another DBMS like for example MySQL or PostgreSQL
c) use the ExtendSys Advantage Database Server and access your data without any conversion with WinDev
I clearly suggest solution b. Why is that? HFSQL is powerfull and is well integrated into WinDev, but it has some limitations. One of them is, you only have a small user base. And for you, coming from a development environment with the same limited amount of users, you know how hard it can be to get good answers when you have a problem. ADS is nice (very nice in my oppinion) but it is not cheap.
Sebastian |
| |
| |
| | | |
|
| | | | |
| | |
| | |
| |
|
|
|