Skip to main content
T
tkrieger1-Visitor
1-Visitor
November 5, 2018
Solved

Windchill Qualitiy Solutions import large xls files for System Tree

  • November 5, 2018
  • 2 replies
  • 3828 views

Dear community,

 

I am not sure if it is absolutly odd, but I have to import an Excel file with 3.200.000 lines as System Tree (structured). I have the feeling that this will exceed the memory of Windchill and I do not think that the GUI import/export wizzard can handle this size. Has anyone recommendations or experience with this?

Any help is appreciated,

Tobias

Best answer by tkrieger

The sad answer is, that it is not possible.

 

-Tobias

2 replies

T
tkrieger1-VisitorAuthorAnswer
1-Visitor
November 29, 2018

The sad answer is, that it is not possible.

 

-Tobias

M
Mohammed_T1-Visitor
1-Visitor
February 25, 2019

I may be late but I know what you are going throughSmiley Happy

WQS is built on MS .Net Framework. This framework has a memory limitation of 1.2GB. When you are doing export which has large number of records then the application starts to consume large amount of memory. Since WQS is built on .net and the export task seeks memory beyond 1.2GB ( check task manager) the .net framework fails to acquire more RAM beyond 1.2GB as this value is hard coded. The application freezes and eventually crashes. PTC has no solution for this nor does Microsoft.

Solutions:
1. Using macros in excel extract data

2. Connect to your production DB through excel and pull the data

 

And please if you get a better answer please share it with me too.

 

Thank you

    T
    tkrieger1-VisitorAuthor
    1-Visitor
    February 26, 2019

    Dear Mohammed,

    Thank you for your answer and help - and I guess that it is the root cause (just wondering if PTC is working on this, we asked the support but we got no reply since month....).

     

    The direct DB hack is what I do now too, while exporting is no problem this way, importing is. There are some strange table dependencies and values (like recordID) which are hard to guess.

     

    If I get updates, I let you know.

    Sincerly,

    Tobias

    Terms & ConditionsAccessibility statement