Subject | RE: [IBO] IB_Import |
---|---|
Author | Terry Black |
Post date | 2012-02-15T22:06:56Z |
Hi Jason, what I want to do would seem simple enough, however, maybe I just am assuming that and it might be more involved.
I have attached a file showing what I have done.
Terry
IT Manager | Public Health Unit Hornsby | Health Reform Transitional Organisation Northern
Hornsby Hospital, Main Building 1, 36-76 Palmerston Road, Hornsby NSW 2077
Tel. 02 9477 9400 | Fax. 02 9482 1650 | tblac@...
www.health.nsw.gov.au
Please be more specific in what you have tried, what happens, etc.
I need more information to be able to help you better.
I have recently written some additional code for the IB_Script to do batch
executions that might be better for you than to use the IB_Import component.
Writing a manual importer is likely going to deliver the best performance.
Jason
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Terry Black
Sent: 15 February 2012 04:15 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] IB_Import
Hi Jason, I have read the IB_Import.pas a number of times and tried to get
it to work, however, I need just some direction.
Terry
Terry Black
IT Manager
Northern Sydney Central Coast
Public Health Unit (Hornsby Office)
Jason
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Terry Black
Sent: 14 February 2012 08:59 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] IB_Import
Hi, I want to read a simple .csv file into a Firebird table, however, I
cannot find many examples of how to achieve this.
The csv file has only one record of 4 fields, but I will be reading in
multiple cv files each week.
e.g FILE SOURCE,VERSION,PRACTICE,DATA SOURCE
Egps,3,SSNSCC009,BP
Could someone please give me some examples of code I should be using.
Terry
I have attached a file showing what I have done.
Terry
IT Manager | Public Health Unit Hornsby | Health Reform Transitional Organisation Northern
Hornsby Hospital, Main Building 1, 36-76 Palmerston Road, Hornsby NSW 2077
Tel. 02 9477 9400 | Fax. 02 9482 1650 | tblac@...
www.health.nsw.gov.au
>>> "IBO Support List" <supportlist@...> 16/02/2012 4:59 am >>>Terry,
Please be more specific in what you have tried, what happens, etc.
I need more information to be able to help you better.
I have recently written some additional code for the IB_Script to do batch
executions that might be better for you than to use the IB_Import component.
Writing a manual importer is likely going to deliver the best performance.
Jason
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Terry Black
Sent: 15 February 2012 04:15 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] IB_Import
Hi Jason, I have read the IB_Import.pas a number of times and tried to get
it to work, however, I need just some direction.
Terry
Terry Black
IT Manager
Northern Sydney Central Coast
Public Health Unit (Hornsby Office)
>>> "IBO Support List" <supportlist@...> 15/02/12 3:36 PM >>>Look in the source code of the IB_Import.pas unit for all the details.
Jason
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Terry Black
Sent: 14 February 2012 08:59 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] IB_Import
Hi, I want to read a simple .csv file into a Firebird table, however, I
cannot find many examples of how to achieve this.
The csv file has only one record of 4 fields, but I will be reading in
multiple cv files each week.
e.g FILE SOURCE,VERSION,PRACTICE,DATA SOURCE
Egps,3,SSNSCC009,BP
Could someone please give me some examples of code I should be using.
Terry