Importing Clarion Data into Windev

Hello all

Is it possible to import Clarion Data (.TPS) files into Windev's Hyperfile? Can WDConver be used for this? Are there any tools that can import data from Clarion into Hyperfile?

Thanks and regards

Gautam

Message forwarded from pcsoft.us.windev

Hi Gautum,

You can connect directly to the Clarion files with the Clarion odbc driver and access the data in that manner to re3ad and/or import it. If you don't have the odbc driver I can possibly help.

Milton

Milton,

I am interested in the Clarion ODBC driver also.

Hi Rich,

If you want you can send me an email (click on my profile to see my email address) and I will send you back the odbc driver/s. There are 2 and zipped up one is 1.3Mb and the other is 2Mb. Can you accept attachments of this size or do you have an FTP address.

Milton

This product supports TPS and FIC (Hyperfiles)

DMC - Data Management Center - A tool to let you Migrate Import Export
Transfer all your Data very easily
www.dmc-fr.com sales@dmc-fr.com
[www.dmc-fr.com]

I also wrote a template that takes a DCT and create WinDev Snippets of code
to convert each file.

It is not entirely automated. you need to open the file in TopScan Export as
a CSV file. Then open that file in Excel and save as an XLS file. This may
not be the most efficient, but for the moderate amount of tables I need to
convert this was what I needed.

Sample code generated for my zipcode file.

//=============================================================================
// ZipCodes - City\State\ZipCode table
//=============================================================================
STC_Progress..Caption = "Deleting(" + HNbRec(ZipCodes) + ")"
hCreateFile(ZipCodes)

// Load the file
XlsFileID = xlsOpen(SourceDir + "ZipCodes.xls")
IF XlsFileID <> -1 THEN
XlsRowCnt = xlsNbRow(XlsFileID)
STC_Progress..Caption = "Processing(" + XlsRowCnt + ")"
PROGBAR_ProgressBar..MaxValue = XlsRowCnt

FOR XlsRowNum = 2 TO XlsRowCnt
PROGBAR_ProgressBar..Value= XlsRowNum
HReset(ZipCodes)

ZipCodes.SysID_ZIP = xlsData(XlsFileID, XlsRowNum,
2) // DECIMAL(13) |
ZipCodes.ZipCode = xlsData(XlsFileID, XlsRowNum,
3) // LONG | ZipCode
ZipCodes.City = xlsData(XlsFileID, XlsRowNum,
4) // CSTRING(31) | City
ZipCodes.County = xlsData(XlsFileID, XlsRowNum,
5) // CSTRING(31) | The name of the county (and sometimes parish)
of the ZIP Cod
ZipCodes.CountyFIPS = xlsData(XlsFileID, XlsRowNum,
6) // LONG | FIPS stands for "Federal Information Processing
Standard".
ZipCodes.StateName = xlsData(XlsFileID, XlsRowNum,
7) // CSTRING(76) | The full name of the state (or territory)
ZipCodes.State = xlsData(XlsFileID, XlsRowNum,
8) // STRING(2) | State
ZipCodes.CityType = xlsData(XlsFileID, XlsRowNum,
9) // STRING(1) | Tells if the City is an organization:
Default|Alternate|Not
ZipCodes.ZIPCodeType = xlsData(XlsFileID, XlsRowNum,
10) // STRING(1) | The type of ZIP Code, for example: Standard|PO
Box Only|Used
ZipCodes.AreaCode = xlsData(XlsFileID, XlsRowNum,
11) // CSTRING(4) | Area Code belonging to that particular ZIP
Code.
ZipCodes.TimeZone = xlsData(XlsFileID, XlsRowNum,
12) // CSTRING(16) | Global TimeZone
ZipCodes.DaylightSavings = xlsData(XlsFileID, XlsRowNum,
13) // BYTE | Tells if the the particular ZIP Code obeys the
Daylight Savi
ZipCodes.Longitude = xlsData(XlsFileID, XlsRowNum,
14) // DECIMAL(9,4) | Map Coordinates Longitude
ZipCodes.Latitude = xlsData(XlsFileID, XlsRowNum,
15) // DECIMAL(9,4) | Map Coordinates Latitude
ZipCodes.SysID_MCF = xlsData(XlsFileID, XlsRowNum,
16) // DECIMAL(13) | Master Control File (Store Number)
ZipCodes.RoutingZone = xlsData(XlsFileID, XlsRowNum,
17) // LONG | Routing Zone
ZipCodes.MapPage = xlsData(XlsFileID, XlsRowNum,
18) // CSTRING(11) | Map Page
ZipCodes.TaxRate_Sales = xlsData(XlsFileID, XlsRowNum,
19) // DECIMAL(5,2) | Sales Tax Rate
ZipCodes.CanShip = xlsData(XlsFileID, XlsRowNum,
20) // BYTE | Can Be shipped
ZipCodes.CanDeliver = xlsData(XlsFileID, XlsRowNum,
21) // BYTE | Can Deliver
ZipCodes.SameDayNotAllowed = xlsData(XlsFileID, XlsRowNum,
22) // BYTE | Same Day Not Allowed

HAdd(ZipCodes)
END

xlsClose(XlsFileID)
STC_Progress..Caption = "Complete"
ELSE
Info(xlsMsgError(XlsFileID))
END


"Gautam" <gautam@ibexhill.com> wrote in message
news:ac8fc782a3e12e97fcd0920bb5495a2c@news.pcsoft...
>
> Hello all
>
> Is it possible to import Clarion Data (.TPS) files into Windev's
> Hyperfile? Can WDConver be used for this? Are there any tools that can
> import data from Clarion into Hyperfile?
>
> Thanks and regards
>
> Gautam
>

--
Kevin Erskine
Software By Ragazzi
www.Software-By-Ragazzi.com
Alameda, CA (USA)

Message forwarded from pcsoft.us.windev

Hi Gautam: Easier way install ODBC driver and import to analysis with
data migration to HF

Sincerely,

Fredy Diazpernett

Gautam escribió:
> Hello all
>
> Is it possible to import Clarion Data (.TPS) files into Windev's Hyperfile? Can WDConver be used for this? Are there any tools that can import data from Clarion into Hyperfile?
>
> Thanks and regards
>
> Gautam
>
Message forwarded from pcsoft.us.windev

Gautam wrote:
> Hello all
>
> Is it possible to import Clarion Data (.TPS) files into Windev's Hyperfile? Can WDConver be used for this? Are there any tools that can import data from Clarion into Hyperfile?
>
> Thanks and regards
>
> Gautam
>

Guess you have to purchase the clarion ODBC driver

Other than that ( Haven't use Clarion since 5-6 years or so) you can try
to extract at least the database model via DDE (No idea if this is still
an valid option respective available) However, in case that this works
for; you can than import the previously clarion exported csv data files.
See Online-Help DDEConnect()

hth, björn
Message forwarded from pcsoft.us.windev

I chose not to use the ODBC driver - because my HF files were not exact
replicas of my TPS files and I wanted to be able to exclude fields and make
programming changes etc.

I chose my method because it allows me greater flexibility during the import
process.

But the ODBC way is a way to go (if you have it)

Kevin Erskine

"Kevin Erskine" <KErskine@Software-By-Ragazzi.com> wrote in message
news:4a16d07b$1@news.pcsoft.fr...
>
> This product supports TPS and FIC (Hyperfiles)
>
> DMC - Data Management Center - A tool to let you Migrate Import Export
> Transfer all your Data very easily
> www.dmc-fr.com sales@dmc-fr.com
> [www.dmc-fr.com]
>
> I also wrote a template that takes a DCT and create WinDev Snippets of
> code
> to convert each file.
>
> It is not entirely automated. you need to open the file in TopScan Export
> as
> a CSV file. Then open that file in Excel and save as an XLS file. This may
> not be the most efficient, but for the moderate amount of tables I need to
> convert this was what I needed.
>
> Sample code generated for my zipcode file.
>
> //=============================================================================
> // ZipCodes - City\State\ZipCode table
> //=============================================================================
> STC_Progress..Caption = "Deleting(" + HNbRec(ZipCodes) + ")"
> hCreateFile(ZipCodes)
>
> // Load the file
> XlsFileID = xlsOpen(SourceDir + "ZipCodes.xls")
> IF XlsFileID <> -1 THEN
> XlsRowCnt = xlsNbRow(XlsFileID)
> STC_Progress..Caption = "Processing(" + XlsRowCnt + ")"
> PROGBAR_ProgressBar..MaxValue = XlsRowCnt
>
> FOR XlsRowNum = 2 TO XlsRowCnt
> PROGBAR_ProgressBar..Value= XlsRowNum
> HReset(ZipCodes)
>
> ZipCodes.SysID_ZIP = xlsData(XlsFileID,
> XlsRowNum,
> 2) // DECIMAL(13) |
> ZipCodes.ZipCode = xlsData(XlsFileID,
> XlsRowNum,
> 3) // LONG | ZipCode
> ZipCodes.City = xlsData(XlsFileID,
> XlsRowNum,
> 4) // CSTRING(31) | City
> ZipCodes.County = xlsData(XlsFileID,
> XlsRowNum,
> 5) // CSTRING(31) | The name of the county (and sometimes parish)
> of the ZIP Cod
> ZipCodes.CountyFIPS = xlsData(XlsFileID,
> XlsRowNum,
> 6) // LONG | FIPS stands for "Federal Information
> Processing
> Standard".
> ZipCodes.StateName = xlsData(XlsFileID,
> XlsRowNum,
> 7) // CSTRING(76) | The full name of the state (or territory)
> ZipCodes.State = xlsData(XlsFileID,
> XlsRowNum,
> 8) // STRING(2) | State
> ZipCodes.CityType = xlsData(XlsFileID,
> XlsRowNum,
> 9) // STRING(1) | Tells if the City is an organization:
> Default|Alternate|Not
> ZipCodes.ZIPCodeType = xlsData(XlsFileID,
> XlsRowNum,
> 10) // STRING(1) | The type of ZIP Code, for example:
> Standard|PO
> Box Only|Used
> ZipCodes.AreaCode = xlsData(XlsFileID,
> XlsRowNum,
> 11) // CSTRING(4) | Area Code belonging to that particular ZIP
> Code.
> ZipCodes.TimeZone = xlsData(XlsFileID,
> XlsRowNum,
> 12) // CSTRING(16) | Global TimeZone
> ZipCodes.DaylightSavings = xlsData(XlsFileID,
> XlsRowNum,
> 13) // BYTE | Tells if the the particular ZIP Code obeys
> the
> Daylight Savi
> ZipCodes.Longitude = xlsData(XlsFileID,
> XlsRowNum,
> 14) // DECIMAL(9,4) | Map Coordinates Longitude
> ZipCodes.Latitude = xlsData(XlsFileID,
> XlsRowNum,
> 15) // DECIMAL(9,4) | Map Coordinates Latitude
> ZipCodes.SysID_MCF = xlsData(XlsFileID,
> XlsRowNum,
> 16) // DECIMAL(13) | Master Control File (Store Number)
> ZipCodes.RoutingZone = xlsData(XlsFileID,
> XlsRowNum,
> 17) // LONG | Routing Zone
> ZipCodes.MapPage = xlsData(XlsFileID,
> XlsRowNum,
> 18) // CSTRING(11) | Map Page
> ZipCodes.TaxRate_Sales = xlsData(XlsFileID,
> XlsRowNum,
> 19) // DECIMAL(5,2) | Sales Tax Rate
> ZipCodes.CanShip = xlsData(XlsFileID,
> XlsRowNum,
> 20) // BYTE | Can Be shipped
> ZipCodes.CanDeliver = xlsData(XlsFileID,
> XlsRowNum,
> 21) // BYTE | Can Deliver
> ZipCodes.SameDayNotAllowed = xlsData(XlsFileID,
> XlsRowNum,
> 22) // BYTE | Same Day Not Allowed
>
> HAdd(ZipCodes)
> END
>
> xlsClose(XlsFileID)
> STC_Progress..Caption = "Complete"
> ELSE
> Info(xlsMsgError(XlsFileID))
> END
>
>
> "Gautam" <gautam@ibexhill.com> wrote in message
> news:ac8fc782a3e12e97fcd0920bb5495a2c@news.pcsoft...
>>
>> Hello all
>>
>> Is it possible to import Clarion Data (.TPS) files into Windev's
>> Hyperfile? Can WDConver be used for this? Are there any tools that can
>> import data from Clarion into Hyperfile?
>>
>> Thanks and regards
>>
>> Gautam
>>
>
> --
> Kevin Erskine
> Software By Ragazzi
> www.Software-By-Ragazzi.com
> Alameda, CA (USA)
>

--
Kevin Erskine
Software By Ragazzi
www.Software-By-Ragazzi.com
Alameda, CA (USA)

Message forwarded from pcsoft.us.windev

Hi Gautham,

As Kevin said (and as explained in my personal email also) - you can use our tool DMC to work on ANY tables (and from next version to be relesed later today) also on HF Tables as destination IF you have version 11 up - the ODBC driver now being read write)

You can download the beta version from this link if you want to try it before we release it
www.dmc-fr.com/dmc_maj/dmcsetup.exe


This tool will let you select the TPS or DAT or any SQL or Access - Excel tables and clone or transfer the data to your HF Tables with full mapping options so as to select all columns or not etc ...

Here is a page to show you all you can do with this tool
[www.dmc-fr.com]

Please do not hesitate to ask for detailed help if you need any

Merci

JPG

Message forwarded from pcsoft.us.windev

Milton, the TPS ODBC drivers are not free, and must be purchased from SoftVelocity. I'm not sure it's appropriate to share commercial software via this forum, nor anywhere else.

-Peter

Hello,

I used DMC [www.dmc-fr.com] to transfer data from our TPS files to HyperFiles. But it does a lot more.

Its and excellent tool and the support is great.

if you remember data junction this is a lot like that but way cheaper.

Cheers

Brian Holmes

Hi Kevin,

The DC looks impressive. Thanks for the link to it.