exclamation-circle Excel file doesn't import

More
06 Aug 2020 11:03 - 06 Aug 2020 11:04 #1 by miclaw86
Excel file doesn't import was created by miclaw86
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..
Last edit: 06 Aug 2020 11:04 by miclaw86.

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

More
06 Aug 2020 15:10 #2 by Ian
Replied by Ian on topic Excel file doesn't import
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.

More
06 Aug 2020 15:18 #3 by miclaw86
Replied by miclaw86 on topic Excel file doesn't import
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.

More
06 Aug 2020 17:41 - 06 Aug 2020 18:32 #4 by Ian
Replied by Ian on topic Excel file doesn't import
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.
Last edit: 06 Aug 2020 18:32 by Ian. Reason: Corrected URL for file upload.

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

More
07 Aug 2020 09:34 #5 by miclaw86
Replied by miclaw86 on topic Excel file doesn't import
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.

More
08 Aug 2020 13:41 #6 by Ian
Replied by Ian on topic Excel file doesn't import
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.

More
11 Aug 2020 10:42 #7 by miclaw86
Replied by miclaw86 on topic Excel file doesn't import
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.

More
11 Aug 2020 10:50 - 11 Aug 2020 10:51 #8 by Ian
Replied by Ian on topic Excel file doesn't import
Happy to help.

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

Kind regards,
Ian
Last edit: 11 Aug 2020 10:51 by Ian. Reason: Grammar

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

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