Categories
View Replies (5)

Resolved schema.ini

  1. drees
    drees
  2. RO CSVI
  3. Tuesday, 17 April 2018
  4.  Subscribe via email
I have separated a txt file without a comma or tab. Is it possible that I can process my data via a schema.ini.
0
Responses (5)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The top line is an example of a text line that I want to import. It is not separated by a comma or tab. I specify a fixed number of characters for the file. The file is approximately 30 lines long and comes 3 times a week.

CSVI does not support import of files with fixed value separators.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
drees
drees
Accepted Answer Pending Moderation
ART00000000000016000000000001740977187986902900000000000000THE GENTLE WOMAN 01 TIJDSCHRIFTEN 0001ST000001105B1100000000000500000000010,99000000010,9906031800000017 100051

schema.ini example
[0203tran0487.txt]
ColNameHeader=True
Format=CSVDelimited
MaxScanRows=25
CharacterSet=ANSI
Col1=Employee_number Char Width 3
Col2=First_Name Char Width 14
Col3=Last_Name Char Width 14
Col4=Address Char Width 14
Col5=City Char Width 30
Col6=Department Char Width 20
Col7=Photograph_File_Name Char Width 20

The top line is an example of a text line that I want to import. It is not separated by a comma or tab. I specify a fixed number of characters for the file. The file is approximately 30 lines long and comes 3 times a week.
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
where can I find this information.

Not sure what information you are asking for. I meant that you cannot use a file with extension .ini for import but you can use .txt file.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
drees
drees
Accepted Answer Pending Moderation
Great, where can I find this information.
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
CSVI does not support .ini extension files but you can use schema.txt instead.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!