Adobe Forums wrote:
> It works from Monday - Saturday, but bombs on Sunday
>
> Message Incorrect number of columns in row.
> Detail Verify the number of columns specified in the
columns attribute and
> in the target file
i assume this question relates to your trying to read txt/csv
files into
your db, right?
it then can mean:
a) depending on the way you read files into the db: that at
least one
row of data has fewer or more items than expected (defined by
the header
row or by some rule imposed by your code, like number of
columns of data
to expect)
b) as in the googled explanation: that at least one of the
fields/items
in the imported data has carriage returns stored in it, which
ends the
current data row with fewer data columns than expected.
i suspect that on sundays you get your data in a bit
different format
than on other days...
one way to get around the problem (if you can't
change/enforce data
model integrity) would be to
- read your data file in row by row
- in each row replace all carriage returns except the
end-of-row one
with spaces
- check each row for correct number of data columns: import
data if all
correct; otherwise do not import that row, store the row data
in some
var/file and review later to see what was wrong with it
hth
--
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com
1
Reply
AdChoices