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

Notification

Icon
Error

Options
Go to last post Go to first unread
JKW  
#1 Posted : Tuesday, July 28, 2015 5:45:26 PM(UTC)
JKW
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 79

Is there a simple way to create or modify an import spreadsheet so that the SID field can be used instead of Site_ID? 

It's not common. But there are times im pulling multi site data in from an export. I already have the SID in the source data and am having to convert to Site_ID so that ESdat can convert back to SID.

Be easier if it just could be imported as SID. Changing the field Name in the spreadsheet doesnt seem to let it come in.  

Warwick Wood  
#2 Posted : Friday, July 31, 2015 3:18:55 AM(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 Justin,

There isn't, it needs to have the Site ID so it is clear to the user, a SID is a bit abstract.

To get that scenario, the only way I can think of is doing a bulk dump of a raw Data Table, editing values in Excel then wanting to import the changes with Update?

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.