Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
NicoTM  
#1 Posted : Thursday, September 15, 2016 1:38:00 AM(UTC)
NicoTM
Rank: Newbie

Reputation:

Groups: Registered
Posts: 3
Location: Lima

Hi all,

I need to import surface water flow data to my database, but I cannot do this due to an import error. I´m using a blank import template. When trying to add data, I get the following error message in the date/time column: ´Item cannot be found in the collection corresponding to the requested name or ordinal´.  Please check the screenshot attached (Capture). How can I solve this issue? Thank you very much.

Another issue is the following: I cannot get a full surface water flow import template using the ´Import´ button. Please check the screenshot attached (Capture2). Is this a problem of my program version?

Thank you

Regards

Capture2.PNG (35kb) downloaded 1 time(s). Capture.PNG (30kb) downloaded 0 time(s).

Warwick Wood  
#2 Posted : Thursday, September 15, 2016 3:04:56 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)
Hi Nico, We'll look into it. In the interim if you put the Date/Time header in the excel import template in square brackets [Date/Time] does that help? (/ is a special character and field names with special characters need to be in square brackets, but normally ESdat would work that out behind the scenes. ) Also you said you can't generate an Import template for that table, but you have one shown. Was that generated previously, before the error, and saved? Regards Warwick
Warwick Wood  
#3 Posted : Thursday, September 22, 2016 5:33:24 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

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

Hello Nico,

This has been fixed, please download the latest update.

Regards,

Warwick

NicoTM  
#4 Posted : Wednesday, October 5, 2016 6:42:09 AM(UTC)
NicoTM
Rank: Newbie

Reputation:

Groups: Registered
Posts: 3
Location: Lima

Thank you very much Warwick,

I tried  to put the Date/Time header in the excel import template in square brackets, and It does not work, I get the same error.

And yes, the template I´m using was previously generated, when my program was working properly.

My ESdat version is 5.1.34, is that the latest version? Thank you

Regards

Warwick Wood  
#5 Posted : Wednesday, October 5, 2016 12:46:47 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

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

Hi Nico,

If you are still seeing the field called "Date/Time" instead of "Date_Time" when generating an Import Template it is not the latest version, you will have to update.

Did you update after the post indicating it was fixed?

Regards,

Warwick

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.