- - Knowledge base overview
Product Updates
Training
Portal
For Partners
TimeXtender Classic

Home
Community overview
TimeXtender Portal Q&A
General

General

Questions about the TimeXtender Portal & Administration

35 Topics
156 Replies

When you subscribe we will email you when there is a new topic in this category

35 Topics

Recently active

Most replies Most views Newest first

LorenzoContributor

asked in General

Project variables

Hi,Where can I find a description/explanation of the several types regarding the project variables?

2234

6 days ago

FenchContributor

asked in General

Update repository version

Dear all,Upon trying to migrate the mdw instance from DEVelopment to PRODuction environment, the following error message appears:Error: Target repository version 5.0.0.0 does not match source repository version 5.0.2.0DEV and PROD environments are both in the same TX desktop app, version 6766.1In the portal, under Data estate > Instances > mdw development instance and mdw production instance, i can’t find any version info.Any suggestions welcome.

212

12 days ago

KCMTContributor

asked in General

Error A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Hello,While migrating from TX 20.10.35.64 to new version 6675.2 with the Portal, we’re running into issues with connecting to a certain data source. I’m getting the same error message in the Portal as i’m getting in SSMS.In our current environment on Azure VM A I’m able to successfully connect to the datasource running on Microsoft SQL Server 2008 R2 (SP2) - 10.50.4042.0 (X64) Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor) using the TimeXtender SQL Data Source 16.1.0.1 version. I’m also able to connect through SSMS to this Server.However, using the same settings and credentials on our new environment on Azure VM B using the portal I’m not able to connect, resulting in the error message below. The portal has SQL Data Source version 17+, so not sure if that has something do with it. Using the SqlClient Data Provider Source results in the same error.Meanwhile, I’m also not able to connect to this server with SSMS

75616

2 months ago

czgaragaContributor

asked in General

Excel from SFTP Datasource

Hello team!I need to extract a Excel file from an SFTP server. I successfully created my SFTP datasource :SFTP Connection But I only see the ‘root’ folder on data selection section. When I click preview I can see all my files but I don’t know what to do to get them ! Root Could you help me on the next step ? Thanks a lot!Christine

aftabpContributor

We have moved from on-premise to AZURE a few months ago. Our TX server is on a node in AZURE and so is our DWH.I have observed that jobs that took a few minutes to complete when we were on-premise now takes much longer.I am wondering if there is a way to person a “health-check” on TX?

13015

3 months ago

JogchumSiRContributor

asked in General

Azure AD Data Source cannot generate schema files?

Hi Folks, I'm trying to use the Azure AD data source to get information from our Azure AD into TimeXtender. I'm extracting User, Group and GroupMembership information using this data source. So far it's working but i notice that a lot of columns that were found are not filled (NULL). If i do a test with PostMan to the Graph API, i see that the fields are filled in (Department and CompanyName).I’ve also enabled logging, i see the Graph API request being made: I don't see the fields that i want come back in the results: I'm guessing that the schema used to get the data from the API does not contain my field so i want to add them. Normally i would generate the schema files using the ‘Generate Schema Files’ option on the portal and edit those to expand the call to the API. There is an option to specify the location of the schema files, but i'm lacking the ‘Generate Schema Files’ option like we have on other similar data sources: Is there maybe an option to enable this outside the portal?

896

5 months ago

ignacioContributor

posted in General

I am looking for Job as a freelance TX developer

Hi team, I am Ignacio, I have worked as a TX developer for 3 years, and now I don't have any projects and want to continue working with TX.Could you help me?Thanks

290

5 months ago

Paul McLeod Bespoke AnalyticsTimeXtender Xpert

asked in General

TimeXtender Portal Changes to DataSources

Hi I wanted to verify what I am seeing as recent changes to the TimeXtender Portal data source definitions.I distinctly remember being able to switch how a data source was being used to upload data to the ODX whether it was going to use AD).NET or ADF. If I selected ADF then I had to enter the ADF credentials.This seems to have disappeared in recent changes. I was using CDATA REST API connectors, I can no no -longer switch between transfer methods without it seems defining new connections. Can someone confirm this and let me know how I can switch between these transfers without creating new data sources?

281

6 months ago

JogchumSiRContributor

asked in General

Copy to instance not working - Unclear why

Goodmorning Everyone, I'm trying to copy the development to production right now but i'm not able to transfer the ODX because of the following error: I filled in everything correctly but it doesn't work. What frustrates me that the GUI doesn't tell me what's wrong. I tried several thing (even getting rid of data source mappings that are unused) but nothing seems to help. There are no ODX <> MDW mappings that need resolving or any other errors. Only thing that i can think of that one source is giving errors on synchronize (the TimeXtender API to read Job Logs). Does anyone have any idea how to fix this?

957

6 months ago

Bakos GáborStarter

asked in General

qlik sense and timextender

Hi all,We have a prospect who uses TimeXtender for data management, with Qlik Sense providing the Visualizations. They have purchased TimeXtender in a bundle with Qlik Sense and NPrinting and Checkpro which is and android App.Data Structure is created in TimeXtender along with calculated fields and filters and aggregated tables and it is taken from there into Qlik Sense via MSSQL. TimeXtender also loads the data.Data is coming in to Qlik Sense from Excel.The company would like to get rid of TimeXtender and use Qlik Sense exclusively by utilising everything as is, but without TimeXtender. They are not familiar with the SQL scripts in TimeXtender because it is not visible for them. In TimeXtender they just had to drag and drop all the tables to create the data structure, but with Qlik Sense they will have to rewrite all the scripts manually to recreate the same structure.My question is does anybody have any similar experience or any idea? To migrate everything from one system into anothe

472

6 months ago

it_lmepStarter

asked in General

TimeXtender License Recognition Issue Following Golden Image Update

Hello Support Team and Community,I'm a System Administrator. I'm reaching out for help with a licensing issue we've encountered with TimeXtender after updating our golden image. Environment:VMware Horizon: Version 2303 SCCM (System Center Configuration Manager): Version 2309 VDI Operating System: Windows 10 LTSC 1809 TimeXtender: Version 20.10.43.64Problem Description: Following a significant update to our golden image, which included various software updates (except TimeXtender), the TimeXtender license is no longer recognized. This update was deployed following our standard procedure via SCCM, without any modification to the PowerShell script used for installing TimeXtender and deploying the Codeletter.xml license file.Symptom: TimeXtender is requesting activation, whereas the license file, generated in October for our current version, should be valid and recognized automatically. Questions for Support:License Management: Does TimeXtender use the "hardware ID" to generate the license

1405

8 months ago

Paul McLeod Bespoke AnalyticsTimeXtender Xpert

asked in General

V21 Instance Copy dialog asking to map 2 ODX instances

I have just completed a migration for a client from V20 to V21.I have created Dev UAT and Production Data warehouse instances and I have a Dev ODX and a Production ODX instance.In my V20 project there was only one ODX (v20 limitation). I have re-created that ODX instance as my “DataLake Prod” instance and my plan is to build out the “DataLake Dev” instance in the future and move the Dev and UAT DW instances to use the “DataLake Dev”.But that is for the future. My goal right now is to complete the migration as is and get it up and running for testing and signoff.I have migrated my Dev Data Warehouse deployed and loaded successfully. I am now looking to promote the Dev instance to the UAT instance. When I try that I get a dialog requesting that I map 2 instances of the “DataLake Prod” ODX instance which makes no sense. I also have to choose a different ODX instance for each mapping. The result is the dialog below. When I execute it the copy fails with a “Mapping Error” message!Any sugges

VictorParticipant

Hello, TimeXtender 20.10.40.64.I have created a simple project variable that takes the environment name. Our goal was to use the project variable in a transformation to say that if a hard coded table field = project variable then 1 else 0.The issue is I cannot use this field in transformations without timextender failing on deploying the table.In the dev environment I have tried sereral ways to achieve this. Custom field transformations where I try to use project variable in any way just results in the error “invalid column name “X”. Where X is whatever enviroment I try to deploy it on.Is there any way to use environment project variables other then usage conditions on execution packages?Thank you,Victor

542

8 months ago

aftabpContributor

asked in General

Why cant i only Execute instead of 'Deploy and Execute'?

I have a table in my Application layer which is based on a view from DSA.The table in Applicaiton layer is a write-back from PBI App where certain columns have data from existing tables and others are empty so that Power App can write to these.Whenever i make a change in my view, the table in Application becomes red.I have tested the following senarios and both times i needed to Deploy and Execute to get rid of the red color and star at the end:Senario 1:Made a minor change in VIEW:From:Select column1 as A from table1toSelect column2 as A from table1I kept the alias but change the column.Senario 2:Wrote a few commentsNow the issue is, i cant Deploy and Execute because then it wont keep the last changes written from PBI App. I need to just Execute or just save so that it wont be overritten/initialized.Is there a way to only Execute when changes dont impact the table structure in Applicatons?

433

8 months ago

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!

1163

11 months ago

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)

1689

11 months ago

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?

634

1 year ago

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?

662

1 year ago

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

KristofferStarter

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

622

1 year ago

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

KristofferStarter

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

KristofferStarter

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

792

1 year ago

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

1497

1 year ago

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 ?

1264

1 year ago

Page 1 / 2

Badge winners

devin.tiemenshas earned the badge Prepare Expert
KCMThas earned the badge Innovator
dennishanssenhas earned the badge Certified Solutions Architect
Roy Vhas earned the badge Prepare Expert
rvgfoxhas earned the badge Deliver Expert

Show all badges

Terms and Conditions Cookie settings

Sign up

Already have an account? Login

Login with SSO

SSO login

Username *

E-mail address *

Full Name

(Private)

Only you and moderators can see this information

TX Partner / Customer *

Company

(Private)

Only you and moderators can see this information

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login with SSO

SSO login

Username or Email

Password

Remember me

Forgot password?

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.