Skip to main content
To homepage To homepage

TimeXtender Portal Q&A

Ask questions and find answers about the TimeXtender Portal

46 Topics
R
Starter
rick.hilbrandsStarter
asked in General
TimeXtender API Endpoint questions

Hi, we are trying to use the TX API endpoint (https://support.timextender.com/timextender-portal-111/timextender-api-endpoints-1110) to check whether TimeXtender jobs have run or failed (or have warnings). We want to check this with Zabbix monitoring tool.For this check, we are only interested in the last run of a job. The TX API gives us a number of functions, like:GET /public/jobs/{job_id}/status: this only gives status none, pending and running. Not failed, errors, warning, ok et cetera…. GET /public/jobs/{job_id}/logs: this one gives status like completed, failed, warning. But it gives the status of al jobs that have run the last weeks. It also shows ‘severity’ as a property, but it's not documented what different severity states mean.Questions:How can we filter in job logs, so we only get the last execution with status of the execution (errors, failed, ok, ...) ?  What do different severity states (0,2,..?) mean?Our main goal is to get the status of the last job exectution.Thanks!

1423
R
Starter
H
Explorer
htrimasExplorer
asked in General
New index truncates table

Why does TimeXtender truncate the table when creating a new index? Is there a way to avoid that? (We’re using TimeXtender legacy 20.10.35.64)

1909
Christian Hauggaard
Community Manager
P
Contributor
pontus.berglundContributor
asked in General
Older versions of TimeXtender 6XXX

Hi,We are upgrading from 6221.1 to the latest version. To uninstall 6221.1 it seems that we need the installation files for this version, but we no longer have those.Is there some way to get the older installation files for versions 6XXX?Is there another way to uninstall older versions without having the older installation files?

834
P
Contributor
R
Starter
Roy VHStarter
asked in General
Which sql server is supported for timextender 20.10.20.64

Hello,We would like to update our sql server if this is possible. We use TimeXtender version 20.10.20.64. Untill which version of SQL server does TimeXtender support? 

892
R
Starter
F
Explorer
FENExplorer
asked in General
Benefits of pre defining a Relation or just defining the Relation while Adding a Conditional look Up

Hallo,Iam really new to all of the Timextender functionalities, so i have a small case/question for the Community: I would like to join two tables and i dont know, if I first define the relation between the two tables or just drag the field into the othe table and create a lookup field  then I will have the option to define a specific relation for this field. Where are the benefits of creating a relation first ? ty in advance FEN

894
F
Explorer
K
Starter
KristofferStarter
asked in General
Time stamps

I have this table where i get some time stamp called start and end, i split those up into more tabels with start_hour,start_min,end_hour,end_min. There is a time between 12.00 and 12.30 where the people goes to break if they work over the break they get 30 min less in thier total worktime, if they start doing break or end during break i want to make a transformation that subtracts the time spent if they start thier shift in the break. I have 2 fields called Start_in_lunch and End_in_work. I made this into a boolean conditions so if they start or end in lunch it should trigger, how can i do this. I tried some DateDiff with some Timefromparts but with no luck. The simple solution saying Start-30 and end-30 works but doing that devided by 60 does not work. Any good ideers

742
Christian Hauggaard
Community Manager
J
Contributor
jyothi.dosiContributor
asked in General
MFA reset request

Hi , I had to uninstall the Authenticator app which also has MFA confirgured for TX. How to i retrieve it back? It is always asking me for 6 digit code which i dont have any more

962
J
Contributor
K
Starter
KristofferStarter
asked in General
splitting up time

I have a table with dates of employees when they start and end work each day. Some days the start of work day is not the same as the end of the work day. Example : employee 2 start work 07-08-2023 end work 09-08-2023. This means that the employee is sick in the period. I have a condition that set this employees work time to 7.5 hours. I have to split up the dates where start_date <> end_date. So that i in the interval can add 7.5 hours to the employee each day he was sick. How can i do this? This is a screenshot where the dates are different. Sorry about the language “mekaniker” is the employee and “Antaltimer_Frokost” means being sick The end result i want is to get 7.5 for each day, so at the first i would like a row for each sicks day . So for the last employee “95012” there would be three rows with each of the day the employee has been sick. Hope its clear what i want

1036
K
Starter
K
Starter
KristofferStarter
asked in General
Date difference

I have a table with dates of employees when they start and end work each day. Some days the start of work day is not the same as the end of the work day. Example : employee 2 start work 07-08-2023 end work 09-08-2023. This means that the employee is sick in the period. I have a condition that set this employees work time to 7.5 hours. I have to split up the dates where start_date <> end_date. So that i in the interval can add 7.5 hours to the employee each day he was sick. How can i do this? This is a screenshot where the dates are different. Sorry about the launge “mekaniker” is the employee and “Antaltimer_Frokost” means being sick The end result i want is to get 7.5 for each day, so at the first i would like 7.5 + 7.5 . So for the last employee “95012” i want 7.5+7.5+7.5. Hope its clear what i want

1052
Thomas Lind
Community Manager
A
Contributor
Agnes.SoumanContributor
asked in General
TimeXtender - Basics course

Hello,We are extending the user group of people using TimeXtender and we want them to follow the same courses as we did. However on the old training site the TimeXtender - Basics course cannot be accessed by them anymore. For those of us who have already followed it, it is still available. Can it be made available to new users again?Thanks,Agnes

1697
A
Contributor
A
Contributor
alain.thireContributor
asked in General
Installing 6221.1

I try to upgrade  version 6221.1 for  customer Dorel.eu . I have the license number. But it requires me to log onto one of your servers to get authorisation . I cannot do that with this user  (not a dorel user). What should I do ?    

1444
A
Explorer
S
Contributor
sguntupalliContributor
asked in General
How to move Project from Sandbox to production

SANDBOX Project developed using ODX server. Both environments Version: 20.10.36.64Please provide me with document to move environments.

1057
S
Contributor
L
Contributor
LorenzoContributor
asked in General
Execute .bat file

Hi,I need to create sub directories for a list of users. I have the users in a table so I'm able to create a .bat file with the mkdir statements.I can manually execute this file but I wonder if there is an option to execute this .bat file using TX?

2964
Søren Sørensen
Contributor
Acumen
Visitor
AcumenVisitor
asked in General
Create a column in table using If Function

I’m very new to TimeXtender and was hoping someone could assist with my issues.  How would you use an “If” function in TimeXtender?For example, I need to create a new column in my table called “Quantity” . I then need to look at the [code] column in the same table and bring back a value using an If Function. Something like this:If [code] = 1 then ‘small’ else if [code] = 2 then ‘medium’ else if [code] = 3 then ‘large else if [code] = 4 then ‘x large’ else null. Thank you

3451
Thomas Lind
Community Manager
L
Contributor
LorenzoContributor
asked in General
Populate Existing table

Hi,I would like to “misuse” TX as an ETL tool by populating an Existing table with new rows.All the logic necessary is processed using TX. The end table to be filled is an existing table and it's table structure can't be modified  so I also need to omit the system control fields. I planned to use an incremental load table but getting errors that the table already exist when I deploy.Not sure if we can use TX this way and someone already solved such a problemAny help would be appreciated.

1798
Thomas Lind
Community Manager
V
Starter
VictorVinkStarter
asked in General
adding user with a '-' in domain

hi all, i’d like to add an user with a ‘-’ in their domain, it gives me an error in request. how can we create a go around for this? example:victor@test-test.com it can also have to do something with an alias they are using, they have an alias that is not sending them an email, but how can they get access to the portal then?

643
Christian Hauggaard
Community Manager
A
Starter
anishekkamal26Starter
asked in General
Hi team how to run data bricks script from TX

Hi team how to run data bricks script from TX 

1605
Christian Hauggaard
Community Manager
rory.smith
TimeXtender Xpert
rory.smithTimeXtender Xpert
asked in General
Explanation of version numbers / nomenclature

While talking to TimeXtender, other people, and upgrading TimeXtender a lot of different numbers are thrown around. For some of those the definition and messaging is clear, but others less so.While upgrading the latest patch I encounter:Software (build?) version: 6221.1 Instance version: 2.0.0.0 (I assume something like Cloud Repository structure version?) TimeXtender Next Gen (in articles on the community) API version (if your ODX Server and TimeXtender desktop mismatch)To avoid going down the path that IBM or Microsoft took with a flurry of different numbers that you all need to understand and be careful about, it would be nice to have a place in the Community that lists all these things. This makes it much easier to triage issues and create a “common parlance” between partners, customers and TimeXtender.

721
Thomas Lind
Community Manager
E
Contributor
ebayContributor
asked in General
transfer task error

Hi everyone After successful synchronization of a csv file, I get an error in the transfer job. The error is: ‘The schema XXXData_CSV is invalid. Execution is canceled’  But with Query Tool I can see all of data. In addition If I click to preview this source in ODX , I take this error  'the sql server contains no data for the table'.  What changes should I make to the schema of this csv data? Best Regards

1705
E
Contributor
M
Starter
mirjam.bleuminkStarter
asked in General
Is upgrade from legacy version to SAAS possible?

Is there any documentation on how you would move (upgrade) from a legacy version to the SAAS solution? I currently use version 20.10.40.64. Also, what does it mean for us since we currently have the legacy version? Will there still be support on the legacy versions (20.x)?

691
Christian Hauggaard
Community Manager
M
Visitor
Michael van AdrichemVisitor
asked in General
URL's in training material outdated - Can i get the correct links?

Hello all,I'm new to TimeXtender and wanted to start with the training material.However, not even 5 minutes into the material. I'm finding so many links to dead or not used pages. For example:The TimeXtender user interface is a standard Windows application with a menu bar, a toolbar and a number of tabs that contain the different objects you will be working with. For more detailed information, please see The User Interface.Points to a page not found. New to TimeXtender and want to get a Trial License?If you are NOT working with a TimeXtender partner but are interested in a trying out our data management platform you can get started with a Trial License and Sandbox Environment here.Points to a 404 page.I would really like to get started with the material, and some dead pages are ok i guess, but there are a lot in there. Could this maybe be fixed?Also could you point me to the page where i could get a trial license to get started?Thank you in advance!best regards,Michael

831
ShivamKapoor
Employee

Badge winners

Show all badges
Terms and ConditionsCookie settings