playMaker

Author Topic: [SOLVED] Does not process large content [Datamaker]  (Read 196 times)

Farwest

  • Beta Group
  • Junior Playmaker
  • *
  • Posts: 52
    • View Profile
[SOLVED] Does not process large content [Datamaker]
« on: May 14, 2019, 07:53:02 AM »
Hi,
When I am processing a CSV file from CsvReader Sample (Ecosystem), it processes if the CSV file is small (with few columns and rows).

When I want to use CSV file for a lot of data, such as 10 columns and 13 rows which 2 columns have a few sentence long cells, it does not process but gives: "Array Index is out of Range" error after passing through "ConvertCsvStringToXmlNode" action.

Is it possible for us to use CSV file with large data or are we limited to a definite array size in processing it? I will be happy to know if there is a fix or not, thanks.
« Last Edit: May 16, 2019, 07:00:55 AM by Farwest »

Farwest

  • Beta Group
  • Junior Playmaker
  • *
  • Posts: 52
    • View Profile
Re: [Datamaker] Does not process large content
« Reply #1 on: May 16, 2019, 07:00:05 AM »
Solved thanks to Jean Fabre through PM.

He observed there are too many "-" (my custom delimiter) at the end of columns, then when I deleted "empty columns" at the end of last column with header, error was removed and it correctly processed.
Issue was totally due to document, so one must be careful of removing rest of the "empty" columns or rows if you had ever touch them by mistake.