Unusual Problems with Text Files in TI Processes

Post Reply
Thurston Howell III
Posts: 36
Joined: Fri Mar 10, 2017 8:26 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016
Location: Dallas, TX

Unusual Problems with Text Files in TI Processes

Post by Thurston Howell III »

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.
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Unusual Problems with Text Files in TI Processes

Post by jim wood »

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.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Unusual Problems with Text Files in TI Processes

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Unusual Problems with Text Files in TI Processes

Post by gtonkin »

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?
Post Reply