Lot Size needs to map to Acreage

[CodySwannGT]

@johnsisland: Overriding existing data in PB fields: Example - 61 Dove Plum Road does show the lot dimension in PB as 1.35 per the website field (Lot size). This doesn't appear to be mapping over, or overriding what's there. HOWEVER, we need Lief to filter the TM data in the field since it's mixed with Lot Dimensions and Lot Acreage numbers first. Either way, please check that the Web is migrating to the correct PB field (Lot Acreage).

[CodySwannGT]

OK, so here's what I know about this:

We are mapping lot size like this when we update the pbaPropertyc:

pba__LotSize_pb__c: listing.lot_size,

In refinery, that field is this: https://www.dropbox.com/s/vfcciqosveuygrn/Screenshot%202016-02-23%2019.43.44.png?dl=0

My guess is that a value such as "1.35" is considered "invalid" for the reasons you mentioned, so PB is ignoring it.

We'll have to ask them, though.

[johnsisland]

In PB, we aren't mapping to "lot size" but rather "lot acreage"

Sent from my iPhone

On Feb 23, 2016, at 7:44 PM, Cody Swann notifications@github.com wrote:

OK, so here's what I know about this:

We are mapping lot size like this when we update the pbaPropertyc:

pba__LotSize_pb__c: listing.lot_size, In refinery, that field is this: https://www.dropbox.com/s/vfcciqosveuygrn/Screenshot%202016-02-23%2019.43.44.png?dl=0

My guess is that a value such as "1.35" is considered "invalid" for the reasons you mentioned, so PB is ignoring it.

We'll have to ask them, though.

— Reply to this email directly or view it on GitHub.

[CodySwannGT]

So where in refinery is that?

On Tue, Feb 23, 2016 at 9:32 PM, johnsisland notifications@github.com wrote:

In PB, we aren't mapping to "lot size" but rather "lot acreage"

Sent from my iPhone

On Feb 23, 2016, at 7:44 PM, Cody Swann notifications@github.com wrote:

OK, so here's what I know about this:

We are mapping lot size like this when we update the pbaPropertyc:

pba__LotSize_pb__c: listing.lot_size, In refinery, that field is this: https://www.dropbox.com/s/vfcciqosveuygrn/Screenshot%202016-02-23%2019.43.44.png?dl=0

My guess is that a value such as "1.35" is considered "invalid" for the reasons you mentioned, so PB is ignoring it.

We'll have to ask them, though.

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub https://github.com/gunnertech/jire2/issues/177#issuecomment-188020959.

Cody Swann - CEO, Gunner Technology T: 213.915.4083 | cody@gunnertech.com | www.gunnertech.com http://www.gunnertech.com/Skype: cody.swann

CONFIDENTIALITY NOTICE: This email message, together with any documents, files and/or email messages attached to it, is intended for the sole use of the individual or entity to whom it is addressed, and may contain information that is legally privileged, confidential and restricted from disclosure. If you are not the intended recipient, or responsible for delivery to that person, you are hereby notified that any dissemination or copying of this communication is STRICTLY PROHIBITED. In such case please notify the sender by reply email and delete this message without reading, printing or saving.

[johnsisland]

I'm not sure I understand you. The "pba_lot size..." Isn't a PB field we are using. We're using the field "Lot Acreage".

Sent from my iPhone

On Feb 23, 2016, at 10:00 PM, Cody Swann notifications@github.com wrote:

So where in refinery is that?

On Tue, Feb 23, 2016 at 9:32 PM, johnsisland notifications@github.com wrote:

In PB, we aren't mapping to "lot size" but rather "lot acreage"

Sent from my iPhone

On Feb 23, 2016, at 7:44 PM, Cody Swann notifications@github.com wrote:

OK, so here's what I know about this:

We are mapping lot size like this when we update the pbaPropertyc:

pba__LotSize_pb__c: listing.lot_size, In refinery, that field is this: https://www.dropbox.com/s/vfcciqosveuygrn/Screenshot%202016-02-23%2019.43.44.png?dl=0

My guess is that a value such as "1.35" is considered "invalid" for the reasons you mentioned, so PB is ignoring it.

We'll have to ask them, though.

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub https://github.com/gunnertech/jire2/issues/177#issuecomment-188020959.

Cody Swann - CEO, Gunner Technology T: 213.915.4083 | cody@gunnertech.com | www.gunnertech.com http://www.gunnertech.com/Skype: cody.swann

CONFIDENTIALITY NOTICE: This email message, together with any documents, files and/or email messages attached to it, is intended for the sole use of the individual or entity to whom it is addressed, and may contain information that is legally privileged, confidential and restricted from disclosure. If you are not the intended recipient, or responsible for delivery to that person, you are hereby notified that any dissemination or copying of this communication is STRICTLY PROHIBITED. In such case please notify the sender by reply email and delete this message without reading, printing or saving. — Reply to this email directly or view it on GitHub.

[CodySwannGT]

Right so right now, we're mapping like this:

Refinery listing.lot_size => PB pba__LotSize_pb__c

It sounds like you're saying, I need to use "acreage"

So, my question is, "Is there a field in refinery called "acreage?"

On Tue, Feb 23, 2016 at 10:08 PM, johnsisland notifications@github.com wrote:

I'm not sure I understand you. The "pba_lot size..." Isn't a PB field we are using. We're using the field "Lot Acreage".

Sent from my iPhone

On Feb 23, 2016, at 10:00 PM, Cody Swann notifications@github.com wrote:

So where in refinery is that?

On Tue, Feb 23, 2016 at 9:32 PM, johnsisland notifications@github.com wrote:

In PB, we aren't mapping to "lot size" but rather "lot acreage"

Sent from my iPhone

On Feb 23, 2016, at 7:44 PM, Cody Swann notifications@github.com wrote:

OK, so here's what I know about this:

We are mapping lot size like this when we update the pbaPropertyc:

pba__LotSize_pb__c: listing.lot_size, In refinery, that field is this:

https://www.dropbox.com/s/vfcciqosveuygrn/Screenshot%202016-02-23%2019.43.44.png?dl=0

My guess is that a value such as "1.35" is considered "invalid" for the reasons you mentioned, so PB is ignoring it.

We'll have to ask them, though.

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub <https://github.com/gunnertech/jire2/issues/177#issuecomment-188020959 .

Cody Swann - CEO, Gunner Technology T: 213.915.4083 | cody@gunnertech.com | www.gunnertech.com http://www.gunnertech.com/Skype: cody.swann

CONFIDENTIALITY NOTICE: This email message, together with any documents, files and/or email messages attached to it, is intended for the sole use of the individual or entity to whom it is addressed, and may contain information that is legally privileged, confidential and restricted from disclosure. If you are not the intended recipient, or responsible for delivery to that person, you are hereby notified that any dissemination or copying of this communication is STRICTLY PROHIBITED. In such case please notify the sender by reply email and delete this message without reading, printing or saving.

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub https://github.com/gunnertech/jire2/issues/177#issuecomment-188036066.

Cody Swann - CEO, Gunner Technology T: 213.915.4083 | cody@gunnertech.com | www.gunnertech.com http://www.gunnertech.com/Skype: cody.swann

CONFIDENTIALITY NOTICE: This email message, together with any documents, files and/or email messages attached to it, is intended for the sole use of the individual or entity to whom it is addressed, and may contain information that is legally privileged, confidential and restricted from disclosure. If you are not the intended recipient, or responsible for delivery to that person, you are hereby notified that any dissemination or copying of this communication is STRICTLY PROHIBITED. In such case please notify the sender by reply email and delete this message without reading, printing or saving.

[johnsisland]

Refinery is LOT SIZE

PB is LOT ACREAGE

Those two need to talk to each other

Sent from my iPhone

On Feb 23, 2016, at 10:27 PM, Cody Swann notifications@github.com wrote:

Right so right now, we're mapping like this:

Refinery listing.lot_size => PB pba__LotSize_pb__c

It sounds like you're saying, I need to use "acreage"

So, my question is, "Is there a field in refinery called "acreage?"

On Tue, Feb 23, 2016 at 10:08 PM, johnsisland notifications@github.com wrote:

I'm not sure I understand you. The "pba_lot size..." Isn't a PB field we are using. We're using the field "Lot Acreage".

Sent from my iPhone

On Feb 23, 2016, at 10:00 PM, Cody Swann notifications@github.com wrote:

So where in refinery is that?

On Tue, Feb 23, 2016 at 9:32 PM, johnsisland notifications@github.com wrote:

In PB, we aren't mapping to "lot size" but rather "lot acreage"

Sent from my iPhone

On Feb 23, 2016, at 7:44 PM, Cody Swann notifications@github.com wrote:

OK, so here's what I know about this:

We are mapping lot size like this when we update the pbaPropertyc:

pba__LotSize_pb__c: listing.lot_size, In refinery, that field is this:

https://www.dropbox.com/s/vfcciqosveuygrn/Screenshot%202016-02-23%2019.43.44.png?dl=0

My guess is that a value such as "1.35" is considered "invalid" for the reasons you mentioned, so PB is ignoring it.

We'll have to ask them, though.

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub <https://github.com/gunnertech/jire2/issues/177#issuecomment-188020959 .

Cody Swann - CEO, Gunner Technology T: 213.915.4083 | cody@gunnertech.com | www.gunnertech.com http://www.gunnertech.com/Skype: cody.swann

CONFIDENTIALITY NOTICE: This email message, together with any documents, files and/or email messages attached to it, is intended for the sole use of the individual or entity to whom it is addressed, and may contain information that is legally privileged, confidential and restricted from disclosure. If you are not the intended recipient, or responsible for delivery to that person, you are hereby notified that any dissemination or copying of this communication is STRICTLY PROHIBITED. In such case please notify the sender by reply email and delete this message without reading, printing or saving.

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub https://github.com/gunnertech/jire2/issues/177#issuecomment-188036066.

Cody Swann - CEO, Gunner Technology T: 213.915.4083 | cody@gunnertech.com | www.gunnertech.com http://www.gunnertech.com/Skype: cody.swann

CONFIDENTIALITY NOTICE: This email message, together with any documents, files and/or email messages attached to it, is intended for the sole use of the individual or entity to whom it is addressed, and may contain information that is legally privileged, confidential and restricted from disclosure. If you are not the intended recipient, or responsible for delivery to that person, you are hereby notified that any dissemination or copying of this communication is STRICTLY PROHIBITED. In such case please notify the sender by reply email and delete this message without reading, printing or saving. — Reply to this email directly or view it on GitHub.

[CodySwannGT]

Oh oh oh. OK. I'll have to wait for Leif on that, too, then

On Tue, Feb 23, 2016 at 10:50 PM, johnsisland notifications@github.com wrote:

Refinery is LOT SIZE

PB is LOT ACREAGE

Those two need to talk to each other

Sent from my iPhone

On Feb 23, 2016, at 10:27 PM, Cody Swann notifications@github.com wrote:

Right so right now, we're mapping like this:

Refinery listing.lot_size => PB pba__LotSize_pb__c

It sounds like you're saying, I need to use "acreage"

So, my question is, "Is there a field in refinery called "acreage?"

On Tue, Feb 23, 2016 at 10:08 PM, johnsisland notifications@github.com wrote:

I'm not sure I understand you. The "pba_lot size..." Isn't a PB field we are using. We're using the field "Lot Acreage".

Sent from my iPhone

On Feb 23, 2016, at 10:00 PM, Cody Swann notifications@github.com wrote:

So where in refinery is that?

On Tue, Feb 23, 2016 at 9:32 PM, johnsisland < notifications@github.com> wrote:

In PB, we aren't mapping to "lot size" but rather "lot acreage"

Sent from my iPhone

On Feb 23, 2016, at 7:44 PM, Cody Swann < notifications@github.com> wrote:

OK, so here's what I know about this:

We are mapping lot size like this when we update the pbaPropertyc:

pba__LotSize_pb__c: listing.lot_size, In refinery, that field is this:

https://www.dropbox.com/s/vfcciqosveuygrn/Screenshot%202016-02-23%2019.43.44.png?dl=0

My guess is that a value such as "1.35" is considered "invalid" for the reasons you mentioned, so PB is ignoring it.

We'll have to ask them, though.

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub < https://github.com/gunnertech/jire2/issues/177#issuecomment-188020959 .

Cody Swann - CEO, Gunner Technology T: 213.915.4083 | cody@gunnertech.com | www.gunnertech.com http://www.gunnertech.com/Skype: cody.swann

CONFIDENTIALITY NOTICE: This email message, together with any documents, files and/or email messages attached to it, is intended for the sole use of the individual or entity to whom it is addressed, and may contain information that is legally privileged, confidential and restricted from disclosure. If you are not the intended recipient, or responsible for delivery to that person, you are hereby notified that any dissemination or copying of this communication is STRICTLY PROHIBITED. In such case please notify the sender by reply email and delete this message without reading, printing or saving.

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub <https://github.com/gunnertech/jire2/issues/177#issuecomment-188036066 .

Cody Swann - CEO, Gunner Technology T: 213.915.4083 | cody@gunnertech.com | www.gunnertech.com http://www.gunnertech.com/Skype: cody.swann

CONFIDENTIALITY NOTICE: This email message, together with any documents, files and/or email messages attached to it, is intended for the sole use of the individual or entity to whom it is addressed, and may contain information that is legally privileged, confidential and restricted from disclosure. If you are not the intended recipient, or responsible for delivery to that person, you are hereby notified that any dissemination or copying of this communication is STRICTLY PROHIBITED. In such case please notify the sender by reply email and delete this message without reading, printing or saving. — Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub https://github.com/gunnertech/jire2/issues/177#issuecomment-188050199.

Cody Swann - CEO, Gunner Technology T: 213.915.4083 | cody@gunnertech.com | www.gunnertech.com http://www.gunnertech.com/Skype: cody.swann

CONFIDENTIALITY NOTICE: This email message, together with any documents, files and/or email messages attached to it, is intended for the sole use of the individual or entity to whom it is addressed, and may contain information that is legally privileged, confidential and restricted from disclosure. If you are not the intended recipient, or responsible for delivery to that person, you are hereby notified that any dissemination or copying of this communication is STRICTLY PROHIBITED. In such case please notify the sender by reply email and delete this message without reading, printing or saving.

[leifg]

The problem here is, that the telemagic fields provides the lot size in very different formats. Here some examples:

• 1.25+ Acr
• 120 x 500
• 9/10 acre
• .2
• 114'x150'
• 3.03* acr
• 76x105x15
• 30,000 +-
• Townhouse

It's almost impossible to find a consistent way to convert all of these examples into a number. That's why I just mapped it to the text field Lot_Acreage__c

I suggest, just overwriting the field Lot_Acreage__c with whatever the website offers in a defined format (e.g. "1.86 Acres")

[CodySwannGT]

Got it. Re-running migration tonight

[johnsisland]

Cody, it needs to map to "Lot Acreage" please. See this thread

[CodySwannGT]

Yes - that's what I've done. I've updated the code to map to lot acreage and will re-run the migration tonight.

[johnsisland]

My bad. Wrong issue. Will post for GSF issue ASAP