CDF Fundamentals Discussion

​@Rodrigo Cezar Leão can you please let me know the browser that you are using? I checked using Google Chrome and I was able to upload the CSV without any issues.

Hi ​@Rodrigo Cezar Leão! If you still have the same issue, just please continue and use the pre-uploaded table available for you. Going forward, you will just do 

“IFSDB.assets” for the CDF transformation 

I could do the upload changing Firefox for Chrome. 

This information confused me a little. The spreadsheet that must be upload contains the assets data, like the tags names and is called AvevaNet. Later on, we use the IFSDB table to generate the timeseries and fill with the datapoints. So if I understand right what you said, I am suposed to get the spreadsheet AvevaNet data from the IFSDB.assets table?

​@Rodrigo Cezar Leão, I’m sorry for the confusion. There is an extra (backup) in the IFSDB db, with the assets table as well. In case you can’t upload the CSV file. You can continue and read from this table when generating the assets. 

Hello,
I am redoing this course from two years ago, 
and I am at the moment in (Working With CDF: Integrate) step: (Complete data set documentation)
And I noticed an issue I didn’t face before when selecting ( document Data Extraction) for my Data Catalog
I am unable to select the DataBase / Table
I even tried with anew data base, and other users databases, I tried both google chrome & Microsoft Edge
but to no avail, the box won’t tick:
 

I sometimes notice this message too when opening Document Extraction : ( Something went wrong: [object object] )
 

Is it something I missed ? I tried refresh many times and different browsers (new logins)

​@Maryam Al-Anssari I checked from my end and I was able to reproduce the same issue. It looks like a bug, I’ll create a support ticket for this. The support team will get back to you with an update.

Additionally, in working with CDF : Integrate 
in Data points section,
I copied the code and adjusted it as instructed below:

-------------------------------------

SELECT 
concat('Maryam1998:',dp.sensor) AS externalId,
cast(time_stamp/1000 as timestamp) AS timestamp,
cast(value AS double)

FROM IFSDB.values AS dp,

--selecting from _cdf.timeseries means we select from the timeseries we ingested to CDF earlier. We do this to make sure all the time series we try to add data points to actually exist

_cdf.timeseries AS ts WHERE CONCAT('Maryam1998:',dp.sensor) = ts.externalId
---------------------------------------
I still get empty timeseries ( no data points) in my dataset:
 

Kindly, could you please advise on what might the mistake be

Hello Mithila,
Sounds good, thank you for your help! :)

Hello,
I am facing the same issue mentioned here. Is there a solution that can be applied? 

Thanks in advance for your help! 

Maryam Al-Anssari wrote:

Additionally, in working with CDF : Integrate 
in Data points section,
I copied the code and adjusted it as instructed below:

-------------------------------------

SELECT 
concat('Maryam1998:',dp.sensor) AS externalId,
cast(time_stamp/1000 as timestamp) AS timestamp,
cast(value AS double)

FROM IFSDB.values AS dp,

--selecting from _cdf.timeseries means we select from the timeseries we ingested to CDF earlier. We do this to make sure all the time series we try to add data points to actually exist

_cdf.timeseries AS ts WHERE CONCAT('Maryam1998:',dp.sensor) = ts.externalId
---------------------------------------
I still get empty timeseries ( no data points) in my dataset:
 

Kindly, could you please advise on what might the mistake be

Hi ​@Thiago dos Santos Rodrigues 

For a start, I see that the external id of your time series is “Maryam198” and not “Maryam1998”
 

If you make it match, you should get your datapoint added to your time series!

Best regards, Sofie