 Rank: Newbie
Groups: Registered
Posts: 1  Location: Calgary
|
Can I set up a nightly ETL to export my data to my own database? if not, can I pull my data via API and be provided with the appropriate table structure and DB schema to load this data in to my own DB? Aside from Excel Exports, how can I interact with my RAW DATA?
Thanks, Alain.
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators
Posts: 259
Location: Ballina
Was thanked: 8 time(s) in 8 post(s)
|
Hi Alain, You can export the raw data under the Import / Export menu. See, https://www.ESdat.net/ES..._Online_Help/export2.htm
To use the API you need another application that will have an equivalent API interface. Which application are you looking to integrate? Alex
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Posts: 4  Location: Sydney
|
Hi there, First time user of ESdat and I am having trouble with exporting any colour to my excels. I have enviornmental standards selected, I have exceedances in these, yet no colour is exported to any part of the excel. Have I missed a setting somewhere? I used a trial previously and had no such issue.
Any help would be appreciated!
Thanks, Angus
|
|
|
|
|
|
 Rank: Administration
Groups: Registered, Administrators Posts: 64 Location: Sydney Thanks: 1 times
Was thanked: 7 time(s) in 7 post(s)
|
Hi Angus, I'm assuming you are using ESdat online and trying to export from the chemistry table view. The knowledge database for chem Tables is here https://help.ESdat.net/en/article/chemistry-tables You may want to check which Table layout has been selected when you are exporting the excel tables as this may be why the environmental standards are not displaying.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Posts: 4 Location: Sydney
|
Hi Kimberley, Thankyou for replying. I have attached pictures of my issue as I don't think I was clear enough previously.
The image below is a screenshot of a chemistry table example which has both selected and formatted environmental standards. The issue I have is once I export this table to excel, none of the colour formatting or highlighting of exceedances within results is shown. I have included an image of a few outputs below. Any help would be appreciated!  ESDAT.png (64kb) downloaded 10 time(s).
ESDAT output.png (117kb) downloaded 4 time(s).
ESDAT fullscreen.png (342kb) downloaded 1 time(s).
I have also attached another preset I created with some resutls formatting which is also not exporting. Thankyou for your help ESDAT 02.png (64kb) downloaded 1 time(s).
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 64 Location: Sydney Thanks: 1 times
Was thanked: 7 time(s) in 7 post(s)
|
Hi Angus - I'm going to move this into the helpdesk - I just need to know which browser you are using.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Posts: 4 Location: Sydney
|
|
|
|
|
|
|
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.