TM1 Forum

Hi All,

I have a TI process that loads data from a nightly text file out of our ERP. Right now a large block of the data no longer loads. I cannot see anything unusual in any of the lines in the block or in the lines before and after it (no special characters, leading or trailing spaces etc). This process worked until recently and accepts data at other intersections of these same elements with a different month. A csv version of this file loads with no problems. I see no signs of corruption in the text file. I tried an ASCII output file and the process does not even read these particular lines.

Are there any unusual issues TI processes can have with text files that might cause TM1 not to read lines of data?

Any input would be greatly appreciated.

Are there any free form text fields within the Data? If there are, within this field there may carriage returns or ". If there are if would throw everything off.

I would echo Jim. If part of the data you are importing to TM1 is text then I would look for carriage returns and other non-printable ASCII characters. Notepad++ can help you with this.

When you say that a CSV file loads with no problems, but the TXT does not, I get confused, unless you are generating two different files from the ERP.

The file extension should have no impact. What are the field separators in both the CSV and TXT files, for clarification?