-
Notifications
You must be signed in to change notification settings - Fork 36
Description
I've managed to log in fine, however when querying for specific rows with:
fm.doFindQuery({'idno': ['2011.63',]})
I get this error:
File "/usr/local/lib/python2.7/site-packages/PyFileMaker/FMData.py", line 50, in FMData __slots__, __init_dict__, __old2new__, __new2old__ = key_dict( from_dict ) File "/usr/local/lib/python2.7/site-packages/PyFileMaker/FMData.py", line 26, in key_dict k = normalizeUnicode(key,'identifier') File "/usr/local/lib/python2.7/site-packages/PyFileMaker/UnicodeNormalizer.py", line 109, in normalizeUnicode if not res.strip('_')[0] in string.ascii_letters
This maybe due to the data from the database:
<fmresultset xmlns="http://www.filemaker.com/xml/fmresultset" version="1.0"> <error code="0"/> <product build="04/05/2017" name="FileMaker Web Publishing Engine" version="16.0.1.184"/> <datasource database="maa" date-format="MM/dd/yyyy" layout="Cat_Object_List" table="CAT_OBJECT" time-format="HH:mm:ss" timestamp-format="MM/dd/yyyy HH:mm:ss" total-count="152279"/> <metadata> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="d_Description_Name" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"/> <field-definition auto-enter="no" four-digit-year="no" global="no" max-characters="10" max-repeat="1" name="dept" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"/> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="d_Place" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"/> <field-definition auto-enter="no" four-digit-year="no" global="no" max-characters="500" max-repeat="1" name="period" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"/> <field-definition auto-enter="no" four-digit-year="no" global="no" max-characters="250" max-repeat="1" name="source" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"/> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="" not-empty="no" numeric-only="no" result="unknown" time-of-day="no" type="unknown"/> <field-definition auto-enter="yes" four-digit-year="no" global="no" max-characters="10" max-repeat="1" name="catalogue_type" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"/> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="t_Record_Count" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="calculation"/> <field-definition auto-enter="no" four-digit-year="no" global="yes" max-repeat="1" name="f_Search_Field" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"/> <field-definition auto-enter="no" four-digit-year="no" global="yes" max-repeat="6" name="Catalogue_PREFERENCE::d_Logo[2]" not-empty="no" numeric-only="no" result="container" time-of-day="no" type="normal"/> <field-definition auto-enter="no" four-digit-year="no" global="no" max-characters="10" max-repeat="1" name="num" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"/> <field-definition auto-enter="no" four-digit-year="no" global="no" max-characters="1000" max-repeat="1" name="idno" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"/> <field-definition auto-enter="no" four-digit-year="no" global="no" max-characters="2000" max-repeat="1" name="Location_Status" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"/> <relatedset-definition table="Cat_Object_IMAGES"> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="Cat_Object_IMAGES::d_Thumbnail_Tiny" not-empty="no" numeric-only="no" result="container" time-of-day="no" type="normal"/> </relatedset-definition> <relatedset-definition table="Cat_Object_IMAGES"> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="Cat_Object_IMAGES::Web_Image" not-empty="no" numeric-only="no" result="container" time-of-day="no" type="normal"/> </relatedset-definition> </metadata> <resultset count="1" fetch-size="1"> <record mod-id="46" record-id="264679"> <field name="d_Description_Name"> <data> print - Print by Timothy Akis, titled 'Faipela man wantaim ol gaden bilong ol'. Edition 26/53. </data> </field> <field name="dept"> <data>Anth</data> </field> <field name="d_Place"> <data> Oceania; Melanesia; Papua New Guinea; Highlands; Madang Province </data> </field> <field name="period"> <data/> </field> <field name="source"> <data> Rogers.Elliot (vendor); Rogers.Betty (collector); Rogers.Cyril (collector) </data> </field> <field name=""> <data/> </field> <field name="catalogue_type"> <data>object</data> </field> <field name="t_Record_Count"> <data>1 of 1 Records</data> </field> <field name="f_Search_Field"> <data/> </field> <field name="Catalogue_PREFERENCE::d_Logo[2]"> <data> /fmi/xml/cnt/Untitled.png?-db=maa&-lay=Cat_Object_List&-recid=264679&-field=Catalogue_PREFERENCE::d_Logo[2](1) </data> </field> <field name="num"> <data>1</data> </field> <field name="idno"> <data>2011.63</data> </field> <field name="Location_Status"> <data>In Store</data> </field> <relatedset count="1" table="Cat_Object_IMAGES"> <record mod-id="10" record-id="164587"> <field name="Cat_Object_IMAGES::d_Thumbnail_Tiny"> <data> /fmi/xml/cnt/2011.63_001.jpg?-db=maa&-lay=Cat_Object_List&-recid=264679&-field=Cat_Object_IMAGES::d_Thumbnail_Tiny(1).164587 </data> </field> </record> </relatedset> <relatedset count="1" table="Cat_Object_IMAGES"> <record mod-id="10" record-id="164587"> <field name="Cat_Object_IMAGES::Web_Image"> <data> /fmi/xml/cnt/2011.63_001.jpg?-db=maa&-lay=Cat_Object_List&-recid=264679&-field=Cat_Object_IMAGES::Web_Image(1).164587 </data> </field> </record> </relatedset> </record> </resultset> </fmresultset>
Any ideas?