2. PHPRunner General questions
  3. Before Import Event or How can I perform this import
This topic is locked

Before Import Event or How can I perform this import

 		4/20/2010 09:56:27
PHPRunner General questions
T
 TKindermann author

Hello,
I have a ASCII File like this:
[indent][left]0 HEAD

1 SOUR PhpGedView

2 NAME PhpGedView

2 VERS 4.2.3

1 DEST DISKETTE

1 DATE 10 MAR 2010

2 TIME 15:30:36

1 GEDC

2 VERS 5.5.1

2 FORM Lineage-Linked

1 CHAR UTF-8

1 FILE kindermann.ged

1 PLAC

2 FORM Stadt, Kreis, (Bundes)Land Staat

(...)
[/left][/indent]And a table like this
[indent]gedcom_import
(

id , integer, autoincrement

ged_line , varchar2,

mydata, varchar2

)
[/indent]I want now import this file into this table (Field ged_line), but the file has no fieldname in the first row AND I have special characters in the data like ','

(example : FORM Stadt, Kreis, (Bundes)Land[color="#ff0000"], Staat)
Has anyone a solution for this problem?
kind regards
Thomas
[indent]
[/indent]
[left]

[/left][indent][left] [/left][/indent]
Sergey Kornilov admin 4/20/2010

PHPRunner is only able to import CSV and Excel files. If you need to import file in custom format you need to implement your own routine.
T
 		TKindermann author 4/21/2010



PHPRunner is only able to import CSV and Excel files. If you need to import file in custom format you need to implement your own routine.


Yes I know, but I thought that it's possible to prepare the import file with the event 'BeforeImport' with the relavant data (First line Column Name and " at the beginning and at the end of a line.
J
 		Jane 4/23/2010

Thomas,
these events won't be executed because PHPRunner do not support this type of imported files.