| Lborz |
| Member |
|
| Italy |
|
|
| None Specified |
|
| Wednesday, October 28, 2009 |
| Wednesday, November 18, 2009 3:35:59 PM |
20
[0.11% of all post / 0.00 posts per day] |
|
|
Thanks, once time again you helped me.
|
Ok,
i have attached the image in my previous post, but i attach it another time.
This is the link to the mapping file.
For creation of tables i use directly the GUI of Postgres client, so i don't use directly SQL code for generation of tables. If you mean the SQL code generated from Mapforce i cannot get it because the error is on mapping validation so Altove refuses to create output. Anyway i used the same tables for a complex mapping like this:
And i don't have any problem with them.
|
My work around for this problem doesn't work properly so i have again the problem of manipulating the id. Below an example of my project:
http://a.imagehost.org/0349/schema.png[/img]
And here the error:
[i]Mapforce10_example_function.mfd: Mapping validation failed - 2 error(s), 0 warning(s)
[JAVA] The SQL-WHERE condition cannot be applied to the database field 'id_utente' because the containing table 'public.utente' is already connected to 'id_utente' which is an ancestor of the target connector 'id_utente'.
[JAVA] The SQL-WHERE condition cannot be applied to the database field 'id_utente' because the containing table 'public.utente' is already connected to 'public.utente' which is an ancestor of the target connector 'id_utente'.
I dont understand what is the problem, can you help me?
Thanks.
|
The source db has 269 tables and more than 20000 records.
The destination db has 149 tables, has already more than 9000 record and at this stage of mapping i'm importing about 9500/10000 records.
|
Hi,
while i'm using more complex mapping between my databases, Mapforce is slowing down. The database are huge and contain a lot of objects, so i believe that is normal that Mapforce use a lot of RAM (i have only two gigabytes). There is something that i can do about this? It's possible to use a step-by-step mapping instead using only one (for example, a source table that contains header and summary of object, at the first time fill only destination header table and in the second time fill the summary destination table)? Or there is a configuration that is suitable for me?
Thanks in advance for your help.
|
Ok, i solve the problem.
And yes, the version of Mapforce is not 10 but 2010. Thanks for the correction.
|
Hi,
i found a problem while using Mapforce. I want to add to a table Province new records copying them from on old table, i cannot use the function "Maximum-value" that auto-assign the value to id_fields because is disabled.
I took the all old ids from target table tabProvince, get the id with max value, add to it 1, and use this sum as seed for module of autogeneration of numbers. It seem's all correct but when i save this mapping i got this error:
Code:The SQL-WHERE condition cannot be applied to the database field 'id_utente' because the containing table 'dbo.tabProvinces' is already connected to 'idProvince' which is an ancestor of the target connector 'idProvince'.
Where is the problem?
Thanks in advance for you help.
|
|
Thank you!
|
Hi,
i have a little problem: i'm using the function Insert SQL-WHERE condition for reading to an already existing table (dbo.tabProvincies), checking if there are a province object that has the field CodeIso equals to the input, like the image below.
Instead of return the entire Province Object, i want only the value of his field idProvince. I'm not able to extract this field directly using SQL-WHERE condition, it's my fault or what? What else can i use for a task like this?
Thanks in advance you for the help.
|
@That
Sorry i wrote the wrong names.
@Vlad
Thanks, is exactly what i need.
|
|
