Ian's Excel Add-in Ribbon Menu

Excel "hanging"

  • qssel
  • Topic Author
  • Visitor
  • Visitor
8 years 7 months ago #1 by qssel
Excel "hanging" was created by qssel
Dear Ian

Thank you for a great Website and Definitely Great Addin's. I am a QS myself and Also use Win QS extensively. Your WinQS ASCII Import has helped me tremendously as All Contractors nowadays requests an Excel Copy of The B of Q. It use to take me hours previously to import and clean up and now it only takes me minutes. I have however run into a problem. I am busy working on a huge project and when Importing the ASCII file it runs smoothly until it reaches a certain number of lines then it just "hangs". I have tried everything but it still seems to get stuck at the same point. PLEASE HELP.

Please Log in to join the conversation.

More
8 years 7 months ago #2 by Ian
Replied by Ian on topic Excel "hanging"
Hi there,

Thank you for the positive comments, much appreciated.

The import routine may go into an infinite loop (hang) when it comes across an unusual combination of characters at the end of one of the lines of text it is trying to import. For example, character combinations such as ... or (?) may cause issues.

If possible, try to identify the description that the import routine is busy with when it hangs. Then locate this same description in the text file exported from WinQS to see if there are any unusual character combinations at the end of the lines in this description.

Removing these characters from the description (either in the text file or in WinQS before exporting to a text file) should solve the problem.

Please keep me up to date on this issue.

Kind regards,
Ian

Please Log in to join the conversation.

  • Mareli
  • Visitor
  • Visitor
8 years 1 month ago #3 by Mareli
Replied by Mareli on topic Excel "hanging"
Ian

I checked the description where Excel hangs, and have changed some of the characters but still experience the not responding error.
Do you have other suggestions to fix the problem?

Please Log in to join the conversation.

More
8 years 1 month ago - 8 years 1 month ago #4 by Ian
Replied by Ian on topic Excel "hanging"
Hi Mareli,

Please open a new ticket at the helpdesk so that you can upload the text file that is giving you trouble.

Kind regards,
Ian
Last edit: 8 years 1 month ago by Ian. Reason: Hyperlink problem

Please Log in to join the conversation.

  • Mareli
  • Visitor
  • Visitor
8 years 4 weeks ago #5 by Mareli
Replied by Mareli on topic Excel "hanging"
Hi Ian,

I got the problem, the error (loop?) was a line starting with a comma... It is all fine now. Thanks.
:woohoo:

Please Log in to join the conversation.

More
8 years 4 weeks ago #6 by Ian
Replied by Ian on topic Excel "hanging"
Hi Mareli,

Thanks for the feedback, glad you have resolved the issue.

On a side note, this error should not occur when importing text files created with the new version (V2?) of WinQS. The manner in which the data is exported to the text file has been changed.

Kind regards,
Ian

Please Log in to join the conversation.

Powered by Kunena Forum
We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.