Closed briviere closed 8 years ago
@briviere few things to check on: 1) did the update actually work...do you see the items in mongo? 2) where is MLSNUM defined...I believe it should be a field 3) may want to try it in 0.4 to see if it works there :-)
Hello
1) did the update actually work...do you see the items in mongo? Yes the script ran successful and all of the fields where populated except for the TextArray Fields.
{ "_id" : ObjectId("56d2e85ec3880f4e6df379e3"), "key" : "575586", "Latitude" : "", "VTourUrl" : "", "Province" : "ON", "Longitude" : "", "CityRets" : "AYLMER", "Bedrooms" : "3", "ListPrice" : "219900", "MLSNUM" : "575586", "StreetName" : "DUFFERIN", "PHOTO_COUNT" : "17", "PROPCODE" : "N5H 3B1", "locationThumbUrls" : [ ], "locationPhotoUrls" : [ ], "__v" : 0 }
{ "_id" : ObjectId("56d2e85ec3880f4e6df379e4"), "key" : "572558", "Latitude" : "", "VTourUrl" : "", "Province" : "ON", "Longitude" : "", "CityRets" : "AYLMER", "Bedrooms" : "3", "ListPrice" : "144900", "MLSNUM" : "572558", "StreetName" : "ELK", "PHOTO_COUNT" : "14", "PROPCODE" : "N5H 1S9", "locationThumbUrls" : [ ], "locationPhotoUrls" : [ ], "__v" : 0 }
2) where is MLSNUM defined...I believe it should be a field.
MLSNUM is there, striped down my model becasue it is somewhat large.
var keystone = require('keystone');
var Types = keystone.Field.Types;
/**
* Property Model
* =============
*/
var Residential = new keystone.List('Residential', {
autokey: { from: 'MLSNUM', path: 'key', unique: true }
});
Residential.add({
locationPhotoUrls: { type: Types.TextArray, required: false },
locationThumbUrls: { type: Types.TextArray, required: false },
ElemSchool: { type: String, required: false },
UNITNUM: { type: String, required: false },
LA1_OFFICE_ID: { type: String, required: false },
VAC_SOIL_TEST: { type: String, required: false },
DiningRoomWidth: { type: String, required: false },
LSIZE14: { type: String, required: false },
SaleOfficePostCode: { type: String, required: false },
DISTRICT_TEXT: { type: String, required: false },
LSIZE20: { type: String, required: false },
LEVEL12: { type: String, required: false },
LCODE23: { type: String, required: false },
MTHCONDO: { type: String, required: false },
ListOfficeCity: { type: String, required: false },
AUX_PHOTOS: { type: String, required: false },
LSIZE16: { type: String, required: false },
LCODE21: { type: String, required: false },
VAC_SCHEME: { type: String, required: false },
ListOfficeEmail: { type: String, required: false },
AGE: { type: String, required: false },
BANNER: { type: String, required: false },
LEVEL22: { type: String, required: false },
LSIZE3: { type: String, required: false },
DISTRICT: { type: String, required: false },
LEVEL14: { type: String, required: false },
ENTRY_DATETIME: { type: String, required: false },
LSIZE1: { type: String, required: false },
LA1_OFFICE_PHONE: { type: String, required: false },
RENTAL: { type: String, required: false },
FamilyRoomArea: { type: String, required: false },
PROPCODE: { type: String, required: false },
LEVEL6: { type: String, required: false },
MUNICIPAL_MAP: { type: String, required: false },
EXCLU: { type: String, required: false },
HANDICAP: { type: String, required: false },
ListOfficePostCode: { type: String, required: false },
SA_B_MBR_ID_NUMBER: { type: String, required: false },
LCODE26: { type: String, required: false },
PHOTO_COUNT: { type: String, required: false },
FirePlaces: { type: String, required: false },
ExpiryDate: { type: String, required: false },
LA1_A_MBR_ID_NUMBER: { type: String, required: false },
SalePrice: { type: String, required: false },
STYLE: { type: String, required: false },
MORT2MSG: { type: String, required: false },
SaleOfficeCity: { type: String, required: false },
SDISTRICT_TEXT: { type: String, required: false },
ListOfficeName: { type: String, required: false },
MORTAMT: { type: String, required: false },
MortgageAmount: { type: String, required: false },
LCODE13: { type: String, required: false },
LA2_A_MBR_ID_NUMBER: { type: String, required: false },
SEWER: { type: String, required: false },
LEGALDESC: { type: String, required: false },
LEVEL26: { type: String, required: false },
VAC_SOILCOND: { type: String, required: false },
LCODE6: { type: String, required: false },
StreetName: { type: String, required: false },
ListingArea: { type: String, required: false },
PHOTO_MOD_DATE: { type: String, required: false },
LCODE8: { type: String, required: false },
LEVEL24: { type: String, required: false },
LEVEL18: { type: String, required: false },
DiningRoomArea: { type: String, required: false },
MAJOR_AREA: { type: String, required: false },
LEVEL16: { type: String, required: false },
PHOTOID: { type: String, required: false },
PubRemarks: { type: String, required: false },
SALES_BROUCHER: { type: String, required: false },
MORT2VER: { type: String, required: false },
LCODE9: { type: String, required: false },
UnitNo: { type: String, required: false },
MORT2: { type: String, required: false },
PROREF: { type: String, required: false },
ListAgentFax: { type: String, required: false },
GARAGET: { type: String, required: false },
LCODE15: { type: String, required: false },
SaleOfficeEmail: { type: String, required: false },
LA2_B_MBR_ID: { type: String, required: false },
RES_OPT_TEXT_10: { type: String, required: false },
SA2_B_MBR_ID: { type: String, required: false },
COUNTER: { type: String, required: false },
DRIVE1: { type: String, required: false },
MLSNUM: { type: String, required: false },
LCODE17: { type: String, required: false },
LEVEL4: { type: String, required: false },
LCODE19: { type: String, required: false },
CANDATE: { type: String, required: false },
MORT2AMT: { type: String, required: false },
LastModDate: { type: String, required: false },
SaleAgentFax: { type: String, required: false },
DIRECT: { type: String, required: false },
LEVEL8: { type: String, required: false },
LEVEL2: { type: String, required: false },
LSIZE26: { type: String, required: false },
SPRICE: { type: String, required: false },
PROPOVER: { type: String, required: false },
HOUSENUM_LO: { type: String, required: false },
NewConstruction: { type: String, required: false },
HAC_SHOW_ADDRESS: { type: String, required: false },
RES_OPT_NUM_10: { type: String, required: false },
RES_OPT_NUM_8: { type: String, required: false },
ListAgentURL: { type: String, required: false },
View: { type: String, required: false },
HISTORY: { type: String, required: false },
LSIZE9: { type: String, required: false },
StreetType: { type: String, required: false },
RES_OPT_TEXT_1: { type: String, required: false },
StreetNo: { type: String, required: false },
EXT: { type: String, required: false },
FamilyRoomPresent: { type: String, required: false },
ListPrice: { type: String, required: false },
SA_COCODE: { type: String, required: false },
ALLOW_FARMING: { type: String, required: false },
OPT_NUM_FIELD_1: { type: String, required: false },
LCODE1: { type: String, required: false },
SA_B_MBR_ID_PHONE: { type: String, required: false },
LCODE11: { type: String, required: false },
SaleAgentId: { type: String, required: false },
LEVEL21: { type: String, required: false },
PROPSIZE: { type: String, required: false },
RES_OPT_NUM_3: { type: String, required: false },
BOARD_ID: { type: String, required: false },
LCODE3: { type: String, required: false },
SOUND_BITE: { type: String, required: false },
LCODE18: { type: String, required: false },
RES_OPT_NUM_1: { type: String, required: false },
VAC_ACCESS: { type: String, required: false },
EXCLUDE_FROM_STATS: { type: String, required: false },
LEASE_PRICE_FMT: { type: String, required: false },
ListOfficeId: { type: String, required: false },
LSIZE28: { type: String, required: false },
LSIZE8: { type: String, required: false },
BathsTotal: { type: String, required: false },
LPRICE_FMT: { type: String, required: false },
StyleRets: { type: String, required: false },
Cooling: { type: String, required: false },
SDISTRICT: { type: String, required: false },
RES_OPT_NUM_5: { type: String, required: false },
LA2_OFFICE_ID_NUMBER: { type: String, required: false },
SA2_COCODE: { type: String, required: false },
SaleOfficeName: { type: String, required: false },
LSIZE22: { type: String, required: false },
SA2_B_MBR_ID_NUMBER: { type: String, required: false },
LEVEL10: { type: String, required: false },
LEVEL29: { type: String, required: false },
TYPE: { type: String, required: false },
RES_OPT_TEXT_8: { type: String, required: false },
STATUS: { type: String, required: false },
LSIZE24: { type: String, required: false },
MORTPIT: { type: String, required: false },
MORT2DATE: { type: String, required: false },
SA2_A_MBR_ID_NUMBER: { type: String, required: false },
Stories: { type: String, required: false },
SubDistrict: { type: String, required: false },
LA2_B_MBR_ID_NUMBER: { type: String, required: false },
StatusChangeDate: { type: String, required: false },
RES_OPT_NUM_7: { type: String, required: false },
TAXES: { type: String, required: false },
ListOfficePhone: { type: String, required: false },
LA1_B_MBR_ID_PHONE: { type: String, required: false },
RNET: { type: String, required: false },
SA_A_MBR_ID_PHONE: { type: String, required: false },
BOARD_NUM: { type: String, required: false },
V1HTEL: { type: String, required: false },
LA1_A_MBR_ID: { type: String, required: false },
RES_OPT_MULTI_2: { type: String, required: false },
Commission: { type: String, required: false },
LSIZE19: { type: String, required: false },
RES_OPT_POPUP_6: { type: String, required: false },
AGE_NUM: { type: String, required: false },
INCOMPLETE_FLAG: { type: String, required: false },
LA1_B_MBR_ID: { type: String, required: false },
HOUCOL: { type: String, required: false },
LCODE24: { type: String, required: false },
Bedrooms: { type: String, required: false },
RES_OPT_POPUP_8: { type: String, required: false },
SaleAgentPager: { type: String, required: false },
SA2_OFFICE_ID_NUMBER: { type: String, required: false },
FRENCH_REMARKS: { type: String, required: false },
CityRets: { type: String, required: false },
SaleAgentCellPhone: { type: String, required: false },
ExtFeatures: { type: String, required: false },
SIDE_OF_ROAD: { type: String, required: false },
LA2_A_MBR_ID_PHONE: { type: String, required: false },
FamilyRoomDim: { type: String, required: false },
SaleAgentURL: { type: String, required: false },
MORTDATE: { type: String, required: false },
LSIZE13: { type: String, required: false },
RES_OPT_POPUP_4: { type: String, required: false },
SQFTG: { type: String, required: false },
LCODE27: { type: String, required: false },
RES_OPT_POPUP_10: { type: String, required: false },
OUTDOOR: { type: String, required: false },
Basement: { type: String, required: false },
LPRICE: { type: String, required: false },
SaleAgentLastName: { type: String, required: false },
LCODE30: { type: String, required: false },
LSIZE11: { type: String, required: false },
VAC_TOT_AC: { type: String, required: false },
LCODE29: { type: String, required: false },
DiningRoomPresent: { type: String, required: false },
RES_OPT_TEXT_6: { type: String, required: false },
MORTPI: { type: String, required: false },
FOUND3: { type: String, required: false },
MORT2PNUM: { type: String, required: false },
SA_B_MBR_ID: { type: String, required: false },
MORTMSG: { type: String, required: false },
MORT2PI: { type: String, required: false },
WATACC: { type: String, required: false },
LSIZE15: { type: String, required: false },
RES_OPT_POPUP_2: { type: String, required: false },
Longitude: { type: String, required: false },
SA2_A_MBR_ID: { type: String, required: false },
SaleAgentEmail: { type: String, required: false },
VAC_ELEC: { type: String, required: false },
RES_OPT_MULTI_4: { type: String, required: false },
GarageRets: { type: String, required: false },
ListOfficeFax: { type: String, required: false },
LA2_A_MBR_ID: { type: String, required: false },
RES_OPT_TEXT_4: { type: String, required: false },
TITLE: { type: String, required: false },
LA1_B_MBR_ID_NUMBER: { type: String, required: false },
Zoning: { type: String, required: false },
YearBuilt: { type: String, required: false },
HeatingPresent: { type: String, required: false },
RES_OPT_TEXT_9: { type: String, required: false },
STREET: { type: String, required: false },
LSIZE17: { type: String, required: false },
SA_OFFICE_ID: { type: String, required: false },
LEVEL13: { type: String, required: false },
MORT2PIT: { type: String, required: false },
RES_OPT_MULTI_1: { type: String, required: false },
BathsFull: { type: String, required: false },
SaleAgentHomePhone: { type: String, required: false },
ListDateRets: { type: String, required: false },
FOUND1: { type: String, required: false },
SHOWINST: { type: String, required: false },
ROLL_NUMBER: { type: String, required: false },
VAC_DEV_PERM: { type: String, required: false },
SA_OFFICE_PHONE: { type: String, required: false },
SaleOfficePhone: { type: String, required: false },
ContractDate: { type: String, required: false },
MORTPNUM: { type: String, required: false },
LSIZE29: { type: String, required: false },
LOTSIZE: { type: String, required: false },
CONDO_MAINTINLU: { type: String, required: false },
SA2_OFFICE_ID: { type: String, required: false },
LCODE22: { type: String, required: false },
Assessment: { type: String, required: false },
LISTDATE: { type: String, required: false },
FEATURES: { type: String, required: false },
StreetDir: { type: String, required: false },
RES_OPT_MULTI_5: { type: String, required: false },
GarageStyle: { type: String, required: false },
LA2_OFFICE_ID: { type: String, required: false },
LA1_A_MBR_ID_PHONE: { type: String, required: false },
LSIZE2: { type: String, required: false },
AssociationFee: { type: String, required: false },
LEVEL5: { type: String, required: false },
DaysOnMarket: { type: String, required: false },
POSINFO: { type: String, required: false },
SA2_A_MBR_ID_PHONE: { type: String, required: false },
REMKS: { type: String, required: false },
ListAgentFirstName: { type: String, required: false },
PLAN: { type: String, required: false },
ListAgentPager: { type: String, required: false },
ListAgentHomePhone: { type: String, required: false },
LSIZE4: { type: String, required: false },
ACCESS1: { type: String, required: false },
DiningRoomLength: { type: String, required: false },
LCODE20: { type: String, required: false },
PID: { type: String, required: false },
ListAgentEmail: { type: String, required: false },
LCODE25: { type: String, required: false },
SA_A_MBR_ID: { type: String, required: false },
SPRICE_FMT: { type: String, required: false },
HighSchool: { type: String, required: false },
Waterfront: { type: String, required: false },
VAC_RESTRIC: { type: String, required: false },
Province: { type: String, required: false },
SaleAgentOfficePhone: { type: String, required: false },
MORTRATE: { type: String, required: false },
LEVEL7: { type: String, required: false },
ListAgentLastName: { type: String, required: false },
LEVEL1: { type: String, required: false },
AGE_APPROX_FLAG: { type: String, required: false },
Directions: { type: String, required: false },
LivingArea: { type: String, required: false },
LivingRoomPresent: { type: String, required: false },
HOUSENUM: { type: String, required: false },
LEVEL3: { type: String, required: false },
V2HTEL: { type: String, required: false },
Exterior: { type: String, required: false },
LEVEL17: { type: String, required: false },
NUMROOMS: { type: String, required: false },
LEVEL9: { type: String, required: false },
LEVEL30: { type: String, required: false },
VAC_BUILD_PLAN: { type: String, required: false },
LCODE5: { type: String, required: false },
LEVEL25: { type: String, required: false },
CLOSEDATE: { type: String, required: false },
LEASE_PRICE: { type: String, required: false },
ListAgentId: { type: String, required: false },
LSIZE6: { type: String, required: false },
LEVEL27: { type: String, required: false },
OwnerName: { type: String, required: false },
LA1_OFFICE_ID_NUMBER: { type: String, required: false },
LSIZE27: { type: String, required: false },
LCODE14: { type: String, required: false },
SDATE_FMT: { type: String, required: false },
V1NAME: { type: String, required: false },
SaleAgentFirstName: { type: String, required: false },
LEVEL11: { type: String, required: false },
ESCAPE_CLAUSE: { type: String, required: false },
Pool: { type: String, required: false },
VAC_LAND_REMARK: { type: String, required: false },
LEVEL23: { type: String, required: false },
LISTDATE_FMT: { type: String, required: false },
WATYPE: { type: String, required: false },
ENTRYDATE: { type: String, required: false },
RES_OPT_NUM_9: { type: String, required: false },
FamilyRoomLength: { type: String, required: false },
DRIVE2: { type: String, required: false },
V2NAME: { type: String, required: false },
RES_OPT_TEXT_2: { type: String, required: false },
LEVEL15: { type: String, required: false },
SA_A_MBR_ID_NUMBER: { type: String, required: false },
SaleOfficeProvince: { type: String, required: false },
LCODE16: { type: String, required: false },
SA2_B_MBR_ID_PHONE: { type: String, required: false },
LSIZE21: { type: String, required: false },
LA2_OFFICE_PHONE: { type: String, required: false },
MLSNUM2: { type: String, required: false },
LSIZE7: { type: String, required: false },
TotalRooms: { type: String, required: false },
PictureId: { type: String, required: false },
RES_OPT_NUM_2: { type: String, required: false },
LA2_B_MBR_ID_PHONE: { type: String, required: false },
SaleOfficeURL: { type: String, required: false },
OwnerPhone: { type: String, required: false },
BathsHalf: { type: String, required: false },
LCODE10: { type: String, required: false },
LSIZE25: { type: String, required: false },
MAJOR_AREA_TEXT: { type: String, required: false },
LA2_COCODE: { type: String, required: false },
ListOfficeStreetName: { type: String, required: false },
MORT: { type: String, required: false },
ListAgentCellPhone: { type: String, required: false },
EXPDATE_FMT: { type: String, required: false },
SaleOfficeStreetName: { type: String, required: false },
LCODE4: { type: String, required: false },
BOARD_COUNTER: { type: String, required: false },
SCOMM: { type: String, required: false },
Heating: { type: String, required: false },
LSIZE5: { type: String, required: false },
FLOORG: { type: String, required: false },
SA_OFFICE_ID_NUMBER: { type: String, required: false },
LEVEL28: { type: String, required: false },
VAC_SITE: { type: String, required: false },
SALE_REMKS: { type: String, required: false },
ListOfficeProvince: { type: String, required: false },
VTourUrl: { type: String, required: false },
TAXYR: { type: String, required: false },
CONDITION_CLAUSE: { type: String, required: false },
LA1_COCODE: { type: String, required: false },
GARAGE: { type: String, required: false },
SA2_OFFICE_PHONE: { type: String, required: false },
STATUSTEXT: { type: String, required: false },
DiningRoomDim: { type: String, required: false },
CloseDateRets: { type: String, required: false },
FamilyRoomWidth: { type: String, required: false },
RES_OPT_NUM_4: { type: String, required: false },
NUMBEDS: { type: String, required: false },
ListOfficeURL: { type: String, required: false },
IMPROVE: { type: String, required: false },
VAC_GAS: { type: String, required: false },
VAC_PHONE: { type: String, required: false },
EXPDATE: { type: String, required: false },
LOTBLOCKPLAN: { type: String, required: false },
RES_OPT_NUM_6: { type: String, required: false },
ASSESS: { type: String, required: false },
PROPZONE: { type: String, required: false },
LEVEL19: { type: String, required: false },
NUMBATHS: { type: String, required: false },
SDATE: { type: String, required: false },
LSIZE23: { type: String, required: false },
LCODE7: { type: String, required: false },
VPIS: { type: String, required: false },
Latitude: { type: String, required: false },
RES_OPT_POPUP_9: { type: String, required: false },
Roof: { type: String, required: false },
Ownership: { type: String, required: false },
ADDRESS: { type: String, required: false },
CITY: { type: String, required: false },
CONDO_FACIL: { type: String, required: false },
RES_OPT_TEXT_7: { type: String, required: false },
V2BTEL: { type: String, required: false },
RES_OPT_POPUP_7: { type: String, required: false },
RES_OPT_POPUP_5: { type: String, required: false },
MORTVER: { type: String, required: false },
RES_OPT_TEXT_5: { type: String, required: false },
Country: { type: String, required: false },
LivingRoomDim: { type: String, required: false },
LSIZE18: { type: String, required: false },
TYPE_CODE: { type: String, required: false },
VTOUR_URL: { type: String, required: false },
ListAgentOfficePhone: { type: String, required: false },
LSIZE12: { type: String, required: false },
STATUSTEXT_EXT: { type: String, required: false },
WATER: { type: String, required: false },
LCODE28: { type: String, required: false },
RES_OPT_POPUP_1: { type: String, required: false },
INCLU: { type: String, required: false },
VAC_PROSPEC: { type: String, required: false },
StatusRets: { type: String, required: false },
V1BTEL: { type: String, required: false },
MORT2RATE: { type: String, required: false },
SaleOfficeFax: { type: String, required: false },
LivingRoomWidth: { type: String, required: false },
LivingRoomLength: { type: String, required: false },
LivingRoomArea: { type: String, required: false },
PNAME: { type: String, required: false },
LSIZE10: { type: String, required: false },
OCCUPY: { type: String, required: false },
LSIZE30: { type: String, required: false },
VAC_VOLTAGE: { type: String, required: false },
LCODE12: { type: String, required: false },
SaleOfficeId: { type: String, required: false },
LEVEL20: { type: String, required: false },
RES_OPT_TEXT_3: { type: String, required: false },
VAC_TYPE: { type: String, required: false },
RES_OPT_POPUP_3: { type: String, required: false },
FOUND2: { type: String, required: false },
UFFI: { type: String, required: false },
LCODE2: { type: String, required: false },
RES_OPT_MULTI_3: { type: String, required: false },
IntFeatures: { type: String, required: false }
});
Residential.register();
3) may want to try it in 0.4 to see if it works there :-)
Is the npm keystonejs 0.4 available.
Thanks
Brian
0.4 has not been released, yet (soon). You need to pull the master branch and use that. I think the following may get you there: 1) cd to some directory where you want to put master keystone 2) run: git clone https://github.com/keystonejs/keystone.git 3) cd to the keystone directory 4) run: npm install 5) run: npm link 6) cd to your application directory 7) run: npm link keystone
If you run into issues check https://github.com/keystonejs/keystone/wiki/0.3.x-to-0.4.x-Changes
Note that you can also edit the app's package.json and set keystone to point to the master branch. Take your pick :-)
Ok figured out it was my bad. My model TextArray names where different from my json input I was using: locationPhotoUrls, should have been LocationPhotoUrls.
Brian
Hello
I have the following model defined:
I have the following json I use to seed my model using keystone update:
After updating is complete if I go to admin to veiw the data and the array's are showing as empty?
I'm currently using version 0.3.16 of KeystoneJS.
Thanks
Brian