• Page:
  • 1

TOPIC:

Excel file doesn't import 06 Aug 2020 11:03 #1

  • miclaw86
  • miclaw86's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
Hi Ian, thanks for the great add-in! When i import a file it loads up then the last step before it wants to save, the excel text gets wiped and im left with only the top three lines of data in the excel sheet, and the balance of the BOQ hasn't loaded. Do you know what could be the problem? First time this has happened after years of use..

Please Log in or Create an account to join the conversation.

Last edit: by miclaw86.

Excel file doesn't import 06 Aug 2020 15:10 #2

Glad you're finding my addin useful.

Does the problem that you're having occur when importing one particular file, or on all files that you import?

Please Log in or Create an account to join the conversation.

Excel file doesn't import 06 Aug 2020 15:18 #3

  • miclaw86
  • miclaw86's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
Hi Ian,

It seems to be one or two files not all - i measured in locations and when printing selected locations to PDF and extracting the txt file, the PDF prints fine but some txt files cannot import into excel..

Please Log in or Create an account to join the conversation.

Excel file doesn't import 06 Aug 2020 17:41 #4

The fact that not all files are affected indicates that it is something unique in the content of those files. This could be caused by something such as an out of place punctuation mark, a double space, or an unexpected character.

If you're able to, uploading one of those files for me to look at would help.

Please Log in or Create an account to join the conversation.

Last edit: by Ian. Reason: Corrected URL for file upload.

Excel file doesn't import 07 Aug 2020 09:34 #5

  • miclaw86
  • miclaw86's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
Hi Ian,

Interestingly - if I print all locations and extract a txt file then it imports without issue to excel, and i would assume that same unique character would also exist in the full txt file. The import error only happens on two of the four print locations. i will upload the files for you to assess. Many thanks!

Please Log in or Create an account to join the conversation.

Excel file doesn't import 08 Aug 2020 13:41 #6

Thank you for uploading the file.

The contents of the file show that there was no information useful for importing included in the file.

This image shows an extract from your file.



The following image shows an extract from a typical file exported from WinQS.



There are no descriptions or quantities in the file that you are importing.

I am not able to say why WinQS exported your data in the way that it did, but it could be related to items with zero quantities in those locations.

Please Log in or Create an account to join the conversation.

Excel file doesn't import 11 Aug 2020 10:42 #7

  • miclaw86
  • miclaw86's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
Thanks Ian,

Strangely it imports to PDF but cant export to Excel, even through the conventional route without using your add-in.

I will liaise with WinQS.

Many thanks for the assistance.

Please Log in or Create an account to join the conversation.

Excel file doesn't import 11 Aug 2020 10:50 #8

Happy to help.

Please feel free to drop in again for any further assistance with the addin.

Kind regards,
Ian

Please Log in or Create an account to join the conversation.

Last edit: by Ian. Reason: Grammar
  • Page:
  • 1

We use cookies to personalise content and to analyse our traffic. You consent to our cookies if you continue to use our website.