Search results

  1. Support

    converting a column to Float as excel

    Hi Tri, In the "data preview", the columns of type Float (on a blue background) are displayed using a maximum of 6 digits behind the decimal point (this corresponds to the display "% .6g" which is described here). In summary, Anatella tries to use up to 6 digits to display the number. The value...
  2. Support

    Python environment set up via Jenkins?

    Hi Jérome and thanks for you query! In general, one creates a "technical user" (for example named "JenkinsUser") who has "extended rights". For example, what we absolutely want to avoid "in production" (ie for an Anatella job that runs in Jenkins), is that the job stops because the job involved...
  3. Support

    Security & LOGS Questions

    Hello, please find below our current answers: Security Questions Are user passwords must be stored using a Salted Cryptographic Hash? Yes, when it's possible. For example, the ODBC password to connect to relational database is encrypted using a symmetric algorithm with a 196 bit key. The...
  4. Support

    Remove white spaces at the start & end of each cell

    hi, in the "readcsv" box, you can use the specific setting as per below screenshot:
  5. Support

    MACD indicator

    hi Marie Ange, please find attached the graph to calculate the MACD indicator :D
  6. Support

    output a .gel file with zero records

    Hi G, Unfortunately this is not possible but, instead, you can use this option: And in case your disk takes too much time to write the output .gel file you check the settings below:
  7. Support

    Get just the column headers

    Hello Gershon, Yes sure! See example in attachment.
  8. Support

    change a general parameter within the graph

    Dear Gershon, Yes it is possible please see the demo in attachment.
  9. Support

    Cannot open file '"filename.gel_anatella"_TMP' for write

    Hi G, Here’s your answer! All the .gel files are always first written with a _TMP extension added. Once the file is completely written, Anatella finally renames the file (to removes the _TMP). This allows another process to check if the file is present: i.e. as soon as the file appears (with...
  10. Support

    Lots of counts of different values of all the variables

    Hi Vasco, Yes sure, check the graphs attached to do it.
  11. Support

    how to calculate deltas

    Please, have a look at the graph in attachment
  12. Support

    Data integration with data from Google Analytics ?

    There is already a box "GoogleAnalytics" in Anatella: It is here: The "Description" field of the "GoogleAnalytics" box contains the documentation of the box that explains how to configure the box to connect to GoogleAnalytics. The "GoogleAnalytics" box of Anatella is a box made in the Python...
  13. Support

    send 2 attch via the sendEmail box ?

    yes you can, attachments are defined within the "AttchmentIDs" column: The "AttchmentIDs" column contains IDs referring to the IDs defined on the table seond pin (in the "ID" column") ici: the different given IDs in the "AttchmentIDs" column are separated by a comma ",".
  14. Support

    MQTT Box best way to store messages and QOS2/ QOS1 config recommendation?

    In order to stock the MQTT messages we suggest using a sqlite file with the option “commit every 1 row” as per below. Like this Anatella writes directly on the disk we’re sure to not “loose” anything (even in case of power outage. However, this may slow down a slightly the graph and therefore we...
  15. Support

    Avoid sorting when already sorted

    yes you can, as per the screenshot below this will add the flag [1A] and it won’t actually sort anything.
  16. Support

    cannot read files. Error” Cannot open cache file 'C:/Users/****/****/Local/Temp/1*****.gel_anatella' for write

    Hi you whether has not the rights to write into this temporary file or the disk where is locate is full. We suggest to change the folder where the temporary Anatella files are stored to a bigger one or with the writing rights such as c:\soft\tmp Our Anatella quick guide section 4.5.1 Selecting...
  17. Support

    GetMails box refiniment

    it depends from the client that send the mail originally. i.e in thunderbird this parameter By default, in Thunderbird, I think we only send the html, without the txt. In the SendMail box of Anatella, you must also choose: one or the other (i.e. it is not possible to have one AND the other).
  18. Support

    calculate the travel distance/time between two points

    In the demonstration, I illustrate how to use the Anatella box named "restCall" to access 2 different API's offered by BING (the geocode API and the route API). we used BING because it's much cheaper than Google but with only a few small modifications, you can get exactly the same demonstration...
  19. Support

    dummify variables

    Hello Mats! Nice to hear from you! I added in attachment 2 examples of graph that creates dummy vars (see the 2 zip files). Please note that, if your final objective is to create afterwards some predictive model, you shouldn't create manually some dummy variables because "TIMi modeler"...
  20. Support

    Where to download the latest Anatella's Version?

    you can to the following link http://www.business-insight.com/TIM/ If a username and password is requested please contact our support desk or our sales representative
Top