Version 425: No data map for UNIQUE_KEY EXTRACT check configuration

[Randy Johnson]

I just tried doing a text only extract to mysql in 422 and for some reason
it is not doing the data map.

On /extract_map.php it is showing the fields as **Not Used**

I will try a clean install and see if I get the same results, The 425 trial
below was a clean install.

Randy

From: viele-de...@crt.realtors.org
[mailto:viele-de...@crt.realtors.org] On Behalf Of Randy Johnson
Sent: Thursday, April 09, 2009 1:34 PM
To: 'For discussion on the development of viele rets'
Subject: [viele-dev] Version 425: No data map for UNIQUE_KEY EXTRACT check
configuration

Hello,


Version: Revision 425


Here is an error I am getting when I set up a source, target and extract
from scratch.

No data map for UNIQUE_KEY EXTRACT check configuration

I have done this several times and keep getting this issue.

I then look in the table and only the MLS Number is populated .

What can I do to get you more information about this issue?

Thanks!


Randy

[Chris Chase]

Has anyone heard from Mark since he left for 5 days?

________________________________
Chris Chase |Solutions Integrator | DTi | my vcard
Voice/Fax 607.433.2200 ext 201 | chris...@directive.com

"Failure is not an option... It comes bundled with Windows"

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, immediately contact the sender by reply e-mail and destroy all copies of the original message.

[Tom Ashworth]

I tried them all and it does the same, so wondering what kind of config
problem.

Tom

-----Original Message-----
From: viele-de...@crt.realtors.org
[mailto:viele-de...@crt.realtors.org] On Behalf Of Mark Lesswing
Sent: Saturday, April 11, 2009 4:25 PM
To: For discussion on the development of viele rets
Subject: Re: [viele-dev] Version 425: No data map for UNIQUE_KEY EXTRACT
check configuration

Thanks Randy,

What kind of TARGET are you using for your EXTRACT (CSV, OR, RDB or XML)?

Randy Johnson wrote:
> I just tried doing a text only extract to mysql in 422 and for some
> reason it is not doing the data map.
>
>
>
> On /extract_map.php it is showing the fields as **Not Used**
>
>
>
> I will try a clean install and see if I get the same results, The 425
> trial below was a clean install.
>
>
>
> Randy
>
>
>

> *From:* v iele-dev...@crt.realtors.org
> [mailto:viele-de...@crt.realtors.org] *On Behalf Of *Randy Johnson
> *Sent:* Thursday, April 09, 2009 1:34 PM
> *To:* 'For discussion on the development of viele rets'
> *Subject:* [viele-dev] Version 425: No data map for UNIQUE_KEY EXTRACT

> check configuration
>
>
>
> Hello,
>
>
>
>
>
> Version: Revision 425
>
>
>
>
>
> Here is an error I am getting when I set up a source, target and extract
> from scratch.
>
>
>
> No data map for UNIQUE_KEY EXTRACT check configuration
>
>
>
> I have done this several times and keep getting this issue.
>
>
>
> I then look in the table and only the MLS Number is populated.
>
>
>
> What can I do to get you more information about this issue?
>
>
>
> Thanks!
>
>
>
>
>
> Randy
>
>
>
>
>

> < br>>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> viele-dev mailing list
> viel...@crt.realtors.org
> http://mail.crt.realtors.org/mailman/listinfo/viele-dev

--
Mark
_______________________________________________
viele-dev mailing list
viel...@crt.realtors.org
http://mail.crt.realtors.org/mailman/listinfo/viele-dev

[Randy Johnson]

Mark,

> When you create an EXTRACT, did you remember to create a data map after
> you define which SOURCE and TARGET to use? You have to perform this
> step yourself.
>

Is this something changed along the way?

I cannot remember what revision it was, but I could go through the screens
on each of the Source, Target , Extract and then when I downloaded the
listings it just worked.

Now after I go through each of the screens to set this up it throws errors
when downloading and gives this error:

No data map for the EXTRACT, check configuration

Is safe to say that I need to go to this page: extract_map.php?ELEMENT=
after the extract is created and actually do the datamap myself now?

Thanks!

Randy

-----Original Message-----
From: viele-de...@crt.realtors.org
[mailto:viele-de...@crt.realtors.org] On Behalf Of Mark Lesswing
Sent: Sunday, April 12, 2009 9:17 AM
To: For discussion on the development of viele rets
Subject: Re: [viele-dev] Version 425: No data map for UNIQUE_KEY EXTRACT
check configuration

Improved error messaging added to SVN 427. Please update and try again,
thanks. Don't forget to check the Data Map definition in the EXTRACT
definition too.

Thanks.

Mark Lesswing wrote:
> When you create an EXTRACT, did you remember to create a data map after
> you define which SOURCE and TARGET to use? You have to perform this
> step yourself.
>
> Analysis
> --------
>
> This error is generated by the {installation}/common/download.php script
> in two spots:
>
> 1) line 1016 - For RDB Targets - when no data is present from the
> EXTRACT definition step or the Unique Key of the SOURCE is not present
> in the map.
>
> 2) line 1644 - For RDB Targets - as part of the Synchronization logic to
> check for the same condition.
>
> I will improve the error messaging to flag exactly which condition is
> causing the problem.
>
>
>
>
> Mark Lesswing wrote:
>> Is the unique key of your system chosen as a field to download in the
>> SOURCE definition?

[Randy Johnson]

Mark,

Ok that makes sense.

Here is my scenario.

I have a db table that I cannot have each of the column names be 255 because
MySQL throws an error because that's too many bytes or something so I
changed them to be varchar(100) and then I just change the remarks columns
etc to be text and that takes care of the errors.

What I did was take the create table statement that I think was outputted at
one point with all the variable names named C_variable name and created the
table ahead of time.

Now that I think about it, the reason it worked for me was because it
attempted to create the table automatically which created the datamap and
that allowed me to switch out the table and use the datamap that was created
automatically, because I went in and chose not to create the table
automatically.

Not sure if that makes sense to you, but I am pretty sure what I need to do
now to get things working the wa y I need them to.

Here are two suggestions:

1. (This was mentioned before) To create the table based on metadata
contents, integer / text etc.

2. document where in the PHP we could change the varchar(255) to a
varchar(100) so the table gets created. This only happens when the MLS has
a bunch of fields.

For me it really comes down to #2 where would I change the varchar 255 to
varchar 100. Looks like it might be in the common/download.php file.

Thanks!

Randy




-----Original Message-----
From: viele-de...@crt.realtors.org
[mailto:viele-de...@crt.realtors.org] On Behalf Of Mark Lesswing
Sent: Tuesday, April 14, 2009 1:53 PM
To: For discussion on the development of viele rets
Subject: Re: [viele-dev] Version 425: No data map for UNIQUE_KEY EXTRACT
check configuration

Yes, this was a change.

When the AUTO-CREATE thought went in, the auto-mapping was joined wi th
that feature. The thought was that if you are creating a table that
didn't exist, it would be natural for the map to be created.

On the other hand, some folks wanted to use VieleRETS to map to an
existing RDB structure and automatically creating the map would not be
desirable (it would really mess up the RDB tables).

For this reason, mapping to an existing structure is a manual process.

I'm open to other approaches though because this is a community tool.

>> When you cr eate an EXTRACT, did you remember to create a data map after

>> you define which SOURCE and TARGET to use? You have to perform this
>> step yourself.
>>
>> Analysis
>> --------
>>
>> This error is generated by the {installation}/common/download.php script
>> in two spots:
>>
>> 1) line 1016 - For RDB Targets - when no data is present from the
>> EXTRACT definition step or the Unique Key of the SOURCE is not present
>> in the map.
>>
>> 2) line 1644 - For RDB Targets - as part of the Synchronization logic to
>> check for the same condition.
>>
>> I will improve the error messaging to flag exactly which condition is
>> causing the problem.
>>
>>
>>
>>
>> Mark Lesswing wrote:
>>> Is the unique key of your system chosen as a field to download in the
>>> SOURCE definition?
>>>
>>> Tom Ashworth wrote:
>>>> I tried them all and it does the same, so wondering what kind of
config
>>>> problem .
>>>>
>>>> Tom
>>>>
>>>>
>>>>
>
>
>
>
>
>
>
>

[Randy Johnson]

Hello,


Version: Revision 425


Here is an error I am getting when I set up a source, target and extract
from scratch.

No data map for UNIQUE_KEY EXTRACT check configuration

[Randy Johnson]

An RBD Target. I will download SVN 427 today and let you know how it goes.

Randy

-----Original Message-----
From: viele-de...@crt.realtors.org
[mailto:viele-de...@crt.realtors.org] On Behalf Of Mark Lesswing
Sent: Saturday, April 11, 2009 6:25 PM
To: For discussion on the development of viele rets

Subject: Re: [viele-dev] Version 425: No data map for UNIQUE_KEY EXTRACT
check configuration

Thanks Randy,

What kind of TARGET are you using for your EXTRACT (CSV, OR, RDB or XML)?

Randy Johnson wrote:
> I just tried doing a text only extract to mysql in 422 and for some
> reason it is not doing the data map.
>
>
>
> On /extract_map.php it is showing the fields as **Not Used**
>
>
>
> I will try a clean install and see if I get the same results, The 425
> trial below was a clean install.
>
>
>
> Randy
>
>
>

> *From:* viele-dev-bounce s...@crt.realtors.org

> [mailto:viele-de...@crt.realtors.org] *On Behalf Of *Randy Johnson
> *Sent:* Thursday, April 09, 2009 1:34 PM
> *To:* 'For discussion on the development of viele rets'

> *Subject:* [viele-dev] Version 425: No data map for UNIQUE_KEY EXTRACT

> check configuration
>
>
>
> Hello,
>
>
>
>
>
> Version: Revision 425
>
>
>
>
>
> Here is an error I am getting when I set up a source, target and extract
> from scratch.
>
>
>
> No data map for UNIQUE_KEY EXTRACT check configuration
>
>
>
> I have done this several times and keep getting this issue.
>
>
>
> I then look in the table and only the MLS Number is populated.
>
>
>
> What can I do to get you more information about this issue?
>
>
>
> Thanks!
>
>
>
>
>
> Randy
>
>
>
>
>
>
>
>

> ------------------------------------------------------------------------