iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
Hi,
im using the Crosslight Enterprise Data Synchronization. My Database is in iis, not express. I can see the items in the Crosslight App in Android 5.0, but it dont work in Android 4.x? After 15 sec., when the synchronization starts, the App will close without any errors. Same in emulator. The tables I synchronize have about 4000 rows.
The synchronization works on Android 5.0. But I cant edit an new item into the database on the server. If I create new Item in the App, it will apear in the list it is also created in the SQLite database. But when I look in the database from the server after the synchronization, the item is not insered. I try to debug from the WebApi side. After editing the new Item this function triggers.
[HttpPost] public SynchronizationResult SynchronizeChanges(MultipartData saveBundle) { return db.SynchronizeChanges(saveBundle); }
In the saveBundle I can see the new item with right timestamp and so on. I tried everything. What can it be? Where should I search the mistake?
{ "SynchronizationInfo": { "LastSyncDate": "2015-02-06T14:13:46.667109Z", "UserId": "7f931e1d-61c8-43d5-b708-31f5dff10bae", "Tag": null }, "Entities": [ { "ADRNR": "1164", "KNDNR": "86", "KGRUPNR": 0, "UNSNR": "", "LFDSPERRNR": null, "DEBLFDNR": null, "SONDERNR": "", "ANRUFER": "", "TELEX": "", "KOORD1": null, "KOORD2": null, "TEXT1": "", "TEXT2": "", "TEXT3": "", "BETREUER": "0", "VERMITTLER": "0", "ANFZEIT": null, "KDNR1": "1000000000000000", "KDNR2": "1000000000000000", "ENTFERNUNG": null, "ZUSINFO": "", "RABATTETEILE": null, "ANREDE": 0, "NAME1": "aa", "NAME2": "", "STRASSE": "", "ORTSTEIL": "", "PLZ": "", "ORT": "", "LAND": "", "TELEFON": "", "TELEFAX": "", "ANLAGEDAT": null, "AENDDAT": null, "PLZNEU": "", "POSTFACHPLZ": "", "POSTFACH": "", "WAEHRUNG": 0, "WSYMBOL": "", "KONTONR": "", "BLZ": "", "BANK": "", "ZBEDING": null, "RABATT": "0", "MWST": 0, "TOUR": null, "SPERRE": null, "MAHNSTOPP": 0, "SFAKTURA": 0, "FIBUKONTO": null, "KREDITLIMIT": null, "OPOSTEN": "0", "IDENTNR": "", "MATCHCODE": "", "GEBIET": null, "LFDDEBNR": null, "DEBNR": "", "KHKBLOCKNR": null, "KOPANG": null, "KOPLIEF": null, "KOPRECH": null, "KOPGUT": null, "KOPSTO": null, "LBEDING": null, "LART": null, "SPRKZ": null, "KOPANZ": null, "FORMANG": null, "FORMLIEF": null, "FORMRECH": null, "FORMGUT": null, "FORMSTO": null, "KOPAUF": null, "FORMAUF": null, "LOESCHKNZ": 0, "DEBITOR": 0, "STANDORT": 0, "BEZLFDNR": null, "KONSILAGER": null, "TEILLIEFSPERRE": 0, "KOSTENSTELLE": null, "KOSTENART": null, "KOSTENTRAEGER": null, "KOSTENPROJEKT": null, "VERSANDKOSTEN": 0, "ZVBEDING": null, "FAHRTKOSTENART": 0, "ANLAGELOGIN": "", "LAENDLOGIN": "", "FAKTURAART": null, "MANDANT": 0, "TMSTMP": "2015-02-06T15:33:03.442509Z", "CH_WIRABS": null, "CH_WIRPROZ": null, "CH_FKONTO": null, "ABBUCHUNG": null, "WWWURL": "", "KOPAFAKT": null, "KOPVFAKT": null, "KOPCLICK": null, "FORMAFAKT": null, "FORMVFAKT": null, "FORMCLICK": null, "VERBOTSKUNDE": null, "CTITEL": "", "ERPSPRKZ": null, "SONDERNR2": "", "SAMMELLS": null, "SAMMELDRUCK": 0, "SFAKTWOCHE": 0, "SFAKTZWOCHE": 0, "SFAKTMONAT": 0, "CH_BNT_BATCH": null, "CH_BNT_CTRL": 0, "ISTAT_LAND": null, "SYSTEMID": null, "FIBUSPRACHE": "", "ABWENTFERNUNG": null, "ABWFAHRTKOSTENART": null, "WEBSHOWDAYS": null, "STEUERNR": "", "SI_LOESCHBAR": null, "DEC_EROEFFSALDO": null, "DEC_ABSCHLSALDO": null, "SI_MAXMAHN": null, "SI_DATEVEXP": null, "C_INHABER_ABI": "", "Name3": "", "Name4": "", "zbedingretoure": null, "zbedingdienst": null, "einmaldebitor": null, "vzahlart": null, "azahlart": null, "mzahlart": null, "zabeding": null, "zmbeding": null, "zzahlart": null, "zzbeding": null, "postfachort": "", "folgepositionen": null, "ec_ja": null, "ec_zahlungsmittel": null, "ec_passwort": "", "vortextnr": null, "vortext": "", "nachtextnr": null, "nachtext": "", "LON": null, "LAT": null, "ec_B2B": null, "LEERGUT": null, "BRUTTO": null, "ExchangeSync": null, "NoKoord": 0, "geburtsdatum": null, "altersnachweis": null, "parentkndnr": "0", "parentflag": 0, "handy": "", "ec_parnterkunde": null, "ec_kontosperre": null, "ec_anonymregist": null, "valutatage": null, "portokosten": null, "portofreigrenze": null, "cp_ILN": "", "APCRM_ja": null, "APCRM_Key": "", "EmailAng": null, "EmailAuf": null, "EmailLief": null, "EmailSto": null, "EmailGut": null, "EmailRech": null, "STDAUFART": null, "ILN": "", "ctihandy": "", "postgeprueft": null, "postpruefdatum": null, "fehler": "", "ec_passwort_geaendert": 0, "EMAIL": "", "EBAYID": "", "ROWID": null, "USN": null, "EXTERNID": null, "STANDARDINVENTAR": null, "C_IBAN": "", "C_SWIFT_CODE": "", "IDENTNRCHECKRESULT": null, "SAMMELGELANGENSBESTAETIGUNG": 0, "EC_PARTNERKUNDE": null, "EntityAspect": { "AutoGeneratedKey": null, "DefaultResourceName": null, "EntityState": "Added", "EntityTypeName": "CrosslightDB.DomainModels.Evolution.KUNDE", "OriginalValuesMap": { "ADRNR": "1164", "KNDNR": "86", "KGRUPNR": 0, "UNSNR": "", "LFDSPERRNR": null, "DEBLFDNR": null, "SONDERNR": "", "ANRUFER": "", "TELEX": "", "KOORD1": null, "KOORD2": null, "TEXT1": "", "TEXT2": "", "TEXT3": "", "BETREUER": "0", "VERMITTLER": "0", "ANFZEIT": null, "KDNR1": "1000000000000000", "KDNR2": "1000000000000000", "ENTFERNUNG": null, "ZUSINFO": "", "RABATTETEILE": null, "ANREDE": 0, "NAME1": "aa", "NAME2": "", "STRASSE": "", "ORTSTEIL": "", "PLZ": "", "ORT": "", "LAND": "", "TELEFON": "", "TELEFAX": "", "ANLAGEDAT": null, "AENDDAT": null, "PLZNEU": "", "POSTFACHPLZ": "", "POSTFACH": "", "WAEHRUNG": 0, "WSYMBOL": "", "KONTONR": "", "BLZ": "", "BANK": "", "ZBEDING": null, "RABATT": "0", "MWST": 0, "TOUR": null, "SPERRE": null, "MAHNSTOPP": 0, "SFAKTURA": 0, "FIBUKONTO": null, "KREDITLIMIT": null, "OPOSTEN": "0", "IDENTNR": "", "MATCHCODE": "", "GEBIET": null, "LFDDEBNR": null, "DEBNR": "", "KHKBLOCKNR": null, "KOPANG": null, "KOPLIEF": null, "KOPRECH": null, "KOPGUT": null, "KOPSTO": null, "LBEDING": null, "LART": null, "SPRKZ": null, "KOPANZ": null, "FORMANG": null, "FORMLIEF": null, "FORMRECH": null, "FORMGUT": null, "FORMSTO": null, "KOPAUF": null, "FORMAUF": null, "LOESCHKNZ": 0, "DEBITOR": 0, "STANDORT": 0, "BEZLFDNR": null, "KONSILAGER": null, "TEILLIEFSPERRE": 0, "KOSTENSTELLE": null, "KOSTENART": null, "KOSTENTRAEGER": null, "KOSTENPROJEKT": null, "VERSANDKOSTEN": 0, "ZVBEDING": null, "FAHRTKOSTENART": 0, "ANLAGELOGIN": "", "LAENDLOGIN": "", "FAKTURAART": null, "MANDANT": 0, "TMSTMP": "2015-02-06T15:33:03.442509Z", "CH_WIRABS": null, "CH_WIRPROZ": null, "CH_FKONTO": null, "ABBUCHUNG": null, "WWWURL": "", "KOPAFAKT": null, "KOPVFAKT": null, "KOPCLICK": null, "FORMAFAKT": null, "FORMVFAKT": null, "FORMCLICK": null, "VERBOTSKUNDE": null, "CTITEL": "", "ERPSPRKZ": null, "SONDERNR2": "", "SAMMELLS": null, "SAMMELDRUCK": 0, "SFAKTWOCHE": 0, "SFAKTZWOCHE": 0, "SFAKTMONAT": 0, "CH_BNT_BATCH": null, "CH_BNT_CTRL": 0, "ISTAT_LAND": null, "SYSTEMID": null, "FIBUSPRACHE": "", "ABWENTFERNUNG": null, "ABWFAHRTKOSTENART": null, "WEBSHOWDAYS": null, "STEUERNR": "", "SI_LOESCHBAR": null, "DEC_EROEFFSALDO": null, "DEC_ABSCHLSALDO": null, "SI_MAXMAHN": null, "SI_DATEVEXP": null, "C_INHABER_ABI": "", "Name3": "", "Name4": "", "zbedingretoure": null, "zbedingdienst": null, "einmaldebitor": null, "vzahlart": null, "azahlart": null, "mzahlart": null, "zabeding": null, "zmbeding": null, "zzahlart": null, "zzbeding": null, "postfachort": "", "folgepositionen": null, "ec_ja": null, "ec_zahlungsmittel": null, "ec_passwort": "", "vortextnr": null, "vortext": "", "nachtextnr": null, "nachtext": "", "LON": null, "LAT": null, "ec_B2B": null, "LEERGUT": null, "BRUTTO": null, "ExchangeSync": null, "NoKoord": 0, "geburtsdatum": null, "altersnachweis": null, "parentkndnr": "0", "parentflag": 0, "handy": "", "ec_parnterkunde": null, "ec_kontosperre": null, "ec_anonymregist": null, "valutatage": null, "portokosten": null, "portofreigrenze": null, "cp_ILN": "", "APCRM_ja": null, "APCRM_Key": "", "EmailAng": null, "EmailAuf": null, "EmailLief": null, "EmailSto": null, "EmailGut": null, "EmailRech": null, "STDAUFART": null, "ILN": "", "ctihandy": "", "postgeprueft": null, "postpruefdatum": null, "fehler": "", "ec_passwort_geaendert": 0, "EMAIL": "", "EBAYID": "", "ROWID": null, "USN": null, "EXTERNID": null, "STANDARDINVENTAR": null, "C_IBAN": "", "C_SWIFT_CODE": "", "IDENTNRCHECKRESULT": null, "SAMMELGELANGENSBESTAETIGUNG": 0, "EC_PARTNERKUNDE": null } } } ], "SaveOptions": { "ConcurrencyStrategy": 0, "ResourceName": null, "ReturnSavedEntities": false, "Tag": null } }
BG Max
I'd like to confirm whether you have set the DateTime Serialization Mode property value of ModifiedDate to Utc?
One of the key challenges in building successful data-driven mobile apps is the consideration of multiple users who access and make changes to the data in different time zone. Consider a user posted a comment on 8:00 AM GMT+7, the app should smartly display the comment as 11:00 AM on other user's devices located in GMT+10 timezone.The best practice to address this challenge is to convert the date/time value to UTC+0 time when sending the data to the data service. Upon retrieval, the UTC+0 value will be converted back to the local time zone respective to the setting in each device.
One of the key challenges in building successful data-driven mobile apps is the consideration of multiple users who access and make changes to the data in different time zone. Consider a user posted a comment on 8:00 AM GMT+7, the app should smartly display the comment as 11:00 AM on other user's devices located in GMT+10 timezone.
The best practice to address this challenge is to convert the date/time value to UTC+0 time when sending the data to the data service. Upon retrieval, the UTC+0 value will be converted back to the local time zone respective to the setting in each device.
Please find the complete guides about how to implement data synchronization by creating a new Crosslight app from Crosslight Business Template in here.
Another suggestions that you can try are:
To break execution when an exception is thrown
After this, try to add a breakpoint in SynchronizeChanges. If this doesn't help, you can try to use SQL Profiler to analyze if there are any issues during data-synchronization in server.
Hope this help.
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname
Creating your account...