logo
    Helping YOU do what YOU want with YOUR data.
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
m.mercer  
#1 Posted : Wednesday, June 19, 2019 1:09:26 PM(UTC)
m.mercer
Rank: Newbie

Reputation:

Groups: Registered
Posts: 2

Hi everyone,

When trying to import certain lab reports into tables the below error (10461 ETD) pops up and it does not let me continue.

Does anyone have any ideas of why, or how to get around this?

Thankyou

NickT  
#2 Posted : Thursday, June 20, 2019 8:13:40 AM(UTC)
NickT
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 85

Was thanked: 4 time(s) in 4 post(s)

Hi,

With the error was there any more description?

Can you please include a screenshot of the error message?

Thanks,

Nick

m.mercer  
#3 Posted : Thursday, June 20, 2019 10:15:14 AM(UTC)
m.mercer
Rank: Newbie

Reputation:

Groups: Registered
Posts: 2

Hi Nick,

No other descriptions unfortunately. I cannot post a picture of any size as the Forum page keeps saying that I have exceeded my word count. See below;

NickT  
#4 Posted : Thursday, June 20, 2019 3:31:13 PM(UTC)
NickT
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 85

Was thanked: 4 time(s) in 4 post(s)

Do you have any more detail that you can provide?

For example:

  • Is it only affecting a particular Project, if so can you import the same Lab Reports into a different Project?
  • Is it related to Lab Reports from a certain laboratory?
  • When do you get the error?
    • Directly after clicking the EDD import button?
    • After you've selected the file?
    • After you click upload?
    • etc....

If you can provide additional details for these questions, and any other details you might think are relevant, that would be great.

Cheers,

Nick

Catherine Hansen  
#5 Posted : Tuesday, July 30, 2019 5:50:02 PM(UTC)
Catherine Hansen
Rank: Newbie

Reputation:

Groups: Registered
Posts: 1

Hi Nick,

One of our users has the same issue but it occurs on exporting data. They get an error message 10461 ETD SQL Syntax Error. This occurs after selecting Chem Table then filtering to soil, selecting one of the workorders and then "Finish" to generate the table. It occurs with any combination of settings to export data. screenshot.jpg (60kb) downloaded 2 time(s).

They are also experiencing an issue importing data. When selecting a laboratory report to import, the excel file opens but the Add Ins toolbar has no buttons, it is visible, but without any buttons to select.

NickT  
#6 Posted : Wednesday, July 31, 2019 8:51:46 AM(UTC)
NickT
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 85

Was thanked: 4 time(s) in 4 post(s)

More often than not, these issues are related to updates that have been applied to Excel.

It's worth trying the following:

  • Can you do an export from the Excel Dump (ie not chem table) in the toolbar on the right, and send a screenshot of the whole screen?
  • Can you try clicking Import – Locations and send any errors.
  • Does doing a “Repair” on Excel resolve it?
  • Has it just started happening?  If it's just started happening, does uninstalling recent Excel or Office "Patches" resolve it? Were any applications recently installed or other changes made to the PC?
  • Does reinstalling Excel resolve it?
  • Are applications from different versions of Office on the same PC?

Cheers,

Nick

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.