Apatar Community Forums

RE: Problem connector AS400 V4R5M0

Anonymous — Thu, 02 Jul 2009 16:01:19 GMT

Hi Segei, thank you for replying.

Can you give me details on :
Security Settings please ?
I have no problem with other system which extract datas

RE: Problem connector AS400 V4R5M0

Sergei — Thu, 02 Jul 2009 15:13:19 GMT

PGOSXS wrote:

Hello,

I have a problem when trying to connect to my AS400 with Apatar V1.10 :
General Security Error.

What can I do ? Is there a check list ? a minimum system requirement ?

Please check your security settings and if the system allows Apatar connecting to it.

Regards,
Sergei

Problem connector AS400 V4R5M0

Anonymous — Thu, 02 Jul 2009 14:55:24 GMT

Hello,

I have a problem when trying to connect to my AS400 with Apatar V1.10 :
General Security Error.

What can I do ? Is there a check list ? a minimum system requirement ?

RE: problem in preview results at target node

kunla — Thu, 02 Jul 2009 08:02:12 GMT

As you specified i changed but :
It is giving error : "The syntax of the string representation of datetime value is incorrect."

RE: Getting different output everytime

Sergei — Wed, 01 Jul 2009 14:07:27 GMT

rtest wrote:

even though I deleted tempDB and not seeing any error detail in error_text.

Hi,

It is the problem with Salesforce and how it returns the results. It is not the issue with Apatar functionality. Check again your query and pay attention to the fields datatypes when form the query.

Regards,
Sergei

RE: problem in preview results at target node

Sergei — Wed, 01 Jul 2009 13:10:09 GMT

Hello kunla,

kunla wrote:

thanks
Thanks,this problem is solved..but a new prob is arised.
In input table i have 2 fields with datatype varchar,fieldname are date and time(lets say eg.21/01/2009,18:14:1.In output table there is field named as datetime(datatype:DATE db:oracle).Now i want both date and time in single output field(datetime).How can i achieve this.

Regards

If i understood you correctly you need to do the following:
1. Transform your data from both fields into string using To Sting function.
2. Concatenate these fields with "Space" separator using Concatenate function.
3. Transform concatenated fields into time using To Time function and map it to field named as datetime(datatype:DATE db:oracle)

It will look like:

Code:

Input Date field -> To String ->
Concatenate -> To Time -> Output datetime field
Input Time field -> To String ->

It should help.

Regards,
Sergei

RE: problem in preview results at target node

kunla — Wed, 01 Jul 2009 05:45:24 GMT

RE: Getting different output everytime

rtest — Tue, 30 Jun 2009 16:55:28 GMT

even though I deleted tempDB and not seeing any error detail in error_text.

Getting different output everytime

rtest — Tue, 30 Jun 2009 16:54:17 GMT

Hello,

I am using SFDC connector where used below query:

select c.CaseNumber, c.Severity__c, c.Subject, c.cc_cycle__c, c.Bug_ID__c, c.Delta_ts__c, c.List_Accessible__c, c.targate_milestone__c, c.version__c, c.votes__c, c.estimated_time__c, c.everconfirmed__c, c.keywords__c, c.remaining_time__c, c.Description, c.Default_Assignee__c, c.Default_Component__c, c.Default_Project__c, c.Priority, c.Submitter__c, c.status_whiteboard__c, c.cf_type__c From Case c where c.Default_Project__c ='any number'

when I go with preview result sometime it does not display value for few fields e.g. show CaseNumber as 0 and display Severity as High

Quote:

when I go and re-arrange the query and do preview result , this time shows me Case Number with expected value but display Severity as 1900-01-01

I checked debug_text where I am getting below where 76 value assigned to some text field and debug file shows this as date field.

sometime display severity field value "High" as Unparseable date: "High"

Code:

Unparseable date: "76"
UI query: `INSERT %post_insert% INTO temp1243435832578 ("Description", "Default_Assignee__c", "Subject", "keywords__c", "everconfirmed__c", "List_Accessible__c", "targate_milestone__c", "estimated_time__c", "Priority", "remaining_time__c", "version__c", "cf_type__c", "Submitter__c", "Bug_ID__c", "Default_Component__c", "cc_cycle__c", "status_whiteboard__c", "Default_Project__c", "CaseNumber", "votes__c", "Severity__c", "Delta_ts__c") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`

do not know why it behaving like this. Please suggest.

RE: Two tables from one

Sergei — Tue, 30 Jun 2009 14:34:56 GMT

Hi Ben,

been wrote:

Hi,

I have a scenario in which each row has to be split into multiple rows.

My idea was to take the same data source, duplicate it, filter each table separately, and merge the records.

problem: how do I make two tables from one?

Thanks

Ben

You may use RegExp function to split one field into several fields. An example how to do it can be found here: http://www.apatarforge.org/datamaps/business-management/csv-file-to-salesforce-where-one-of-the-fields-is-split-into-several-fields-using-regexp-function/download.html

Hope it will help you.

Regards,
Sergei