Bosch Sensortec Community

    cancel
    Showing results for 
    Search instead for 
    Did you mean: 
    SOLVED

    Time Stamp conversion Development Desktop 2.0

    Time Stamp conversion Development Desktop 2.0

    Ben
    New Poster

    Hi all,

    I'm using a BME680 shuttleboard with an Appboard V2.0.

    As software I use Development Desktop 2.0 (DD 2.0).

     

    I'm testing the board via DD 2.0. The data is saved as a textfile by the DD 2.0.

    I want to export the data to plot graphs (for example in Excel). My problem is, that I'm not able to figure out how to convert the time stamps in the textfile to the actual time/date. I tried to use Unix time converter but i didnt work.

    So my (rather simple) question is: What format are these time stamps written in? And how can i convert them?

     

    Thank you for your help

    - Ben

    2 REPLIES 2

    FAE_CA1
    Community Moderator
    Community Moderator

    Hi,

    Thanks for your inquiry.

    The unit of the time stamp in BME680 data log CSV file through DD2.0 GUI SW is nano-seconds. For example, when BSEC library works under low power mode (LP), the IAQ value and other sensors' measurements update at every 3 seconds. Under ultra-low power mode (ULP) the update rate is 300 seconds. So you can simply ignore the time stamp values and just use 3 seconds for each row data plot in the CSV file. Please see the attached "BME680_data_log_DD2.0.xlsx" as an example that was renamed from the CSV file.

    Hi FAE_CA1,

    I tried your solution and ignored the nanoseconds and instead used three seconds for each measurement.

    This works. However, when I collect data over a prolonged period (~50 hours --> ~2 days) there is a problem with this conversion. As the timer for each measurement isn’t exactly 3 seconds but a little bit more (3.0X seconds) there is a slight offset which builds up over time.

    In the table below you can see that this offset results in a timing mismatch (delay) of almost 8 minutes after two days of continuous measurement.

     

    I want to correlate the data of these measurements with other sensor data for comparison. However, as the sensor data from the BME-680 is “too slow” the offset leads to a bias in visualization with increasing time if I plot all the data of different sensors in one graph.

     

    Is there a way to solve this without using the exact numbers (in nanoseconds) generated by the sensor?

     

    Total measurment time:54,74 hours  
        
    Nanoseconds (measurment date)Seconds (calcualted from data)Seconds calcualted
    with 3 sec for
    each measurment
    Difference in measured seconds and
    calculated seconds (using 3 sec for each measurment)
    197083392063232.0000197083.4 sec196605.0 sec478.39 seconds --> 7.97 minutes

     

     

    Icon--AD-black-48x48Icon--address-consumer-data-black-48x48Icon--appointment-black-48x48Icon--back-left-black-48x48Icon--calendar-black-48x48Icon--center-alignedIcon--Checkbox-checkIcon--clock-black-48x48Icon--close-black-48x48Icon--compare-black-48x48Icon--confirmation-black-48x48Icon--dealer-details-black-48x48Icon--delete-black-48x48Icon--delivery-black-48x48Icon--down-black-48x48Icon--download-black-48x48Ic-OverlayAlertIcon--externallink-black-48x48Icon-Filledforward-right_adjustedIcon--grid-view-black-48x48IC_gd_Check-Circle170821_Icons_Community170823_Bosch_Icons170823_Bosch_Icons170821_Icons_CommunityIC-logout170821_Icons_Community170825_Bosch_Icons170821_Icons_CommunityIC-shopping-cart2170821_Icons_CommunityIC-upIC_UserIcon--imageIcon--info-i-black-48x48Icon--left-alignedIcon--Less-minimize-black-48x48Icon-FilledIcon--List-Check-grennIcon--List-Check-blackIcon--List-Cross-blackIcon--list-view-mobile-black-48x48Icon--list-view-black-48x48Icon--More-Maximize-black-48x48Icon--my-product-black-48x48Icon--newsletter-black-48x48Icon--payment-black-48x48Icon--print-black-48x48Icon--promotion-black-48x48Icon--registration-black-48x48Icon--Reset-black-48x48Icon--right-alignedshare-circle1Icon--share-black-48x48Icon--shopping-bag-black-48x48Icon-shopping-cartIcon--start-play-black-48x48Icon--store-locator-black-48x48Ic-OverlayAlertIcon--summary-black-48x48tumblrIcon-FilledvineIc-OverlayAlertwhishlist