Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help with skipping header row in .csv file during import

688716Mar 3 2009 — edited Mar 7 2009

I have a .csv file that refuses to import correctly unless the header row is removed. The import script is made by a consultant who never got the files to import correctly. I have fiddled around with the importing function and managed to correctly import the GL file by deleting the header row. The header row does not include any scandinavian letters or other unconventional characters. I tried changing the File encoding in the Configurations settings from ASCII to UNICODE but that did not help. I would now need some help in making a simple skip script for the header row.

The header looks like this:

Company AccountingYear AccountingPeriod YearPeriodKey YearPeriod Account CodeB CodeC CodeD CodeH Amount Balance Activity

Any gurus out there that would help a newbie in desperate need of some FDM scripting guidance?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2009

Added on Mar 3 2009

#business-intelligence-applications, #financial-data-management, #performance-management-applications

3 comments

2,179 views