Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
12
Erster Beitrag:
vor 8 Jahren, 4 Monaten
Letzter Beitrag:
vor 8 Jahren, 3 Monaten
Beteiligte Autoren:
"Kevin Erskine".pcs.crosspost, Milton, Brian, Peter Raines, Glenn Rathke, "Jean-Pierre Gutsatz (DMC)".pcs.cross, IkBeen.pcs.crosspost, Rich, Gautam.pcs.crosspost, Superdan.pcs.crosspost

Importing Clarion Data into Windev

Startbeitrag von Gautam.pcs.crosspost am 22.05.2009 15:58

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

Antworten:

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

von Milton - am 22.05.2009 22:39
Milton,

I am interested in the Clarion ODBC driver also.

von Rich - am 22.05.2009 23:50
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

von Milton - am 23.05.2009 06:08

Re: Importing Clarion Data into Windev

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
http://www.dmc-fr.com/comparisson_table_en.php

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" 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

von "Kevin Erskine".pcs.crosspost - am 24.05.2009 14:04

Re: Importing Clarion Data into 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

von IkBeen.pcs.crosspost - am 24.05.2009 14:08

Re: Importing Clarion Data into 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

von Superdan.pcs.crosspost - am 24.05.2009 14:09

Re: Importing Clarion Data into 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" 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
> http://www.dmc-fr.com/comparisson_table_en.php
>
> 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" 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

von "Kevin Erskine".pcs.crosspost - am 25.05.2009 05:39

Re: Importing Clarion Data into 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
http://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

von "Jean-Pierre Gutsatz (DMC)".pcs.cross - am 25.05.2009 09:31
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

von Peter Raines - am 26.05.2009 01:59
Hello,

I used DMC http://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

von Brian - am 01.06.2009 13:15

Re: Re: Importing Clarion Data into Windev

Hi Kevin,

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



von Glenn Rathke - am 02.06.2009 12:50
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.