Example database and config

[Mop100]

I have tried the "serverfilter".

        <serverFilter>
          <column>UserID</column>
          <type>Int32</type>
          <value>1</value>
        </serverFilter>

The problem is that if I filter records in my CalendarTable, then all the records that does not meet the criteria are treated as deletes and are added to the tombstone-table..

So the scenario is:
I have 40 records, 10 in each calendar.

(Sync with 4 subscriptions or 4 items in 1 subscription does not make any difference.)

Sync1 goes well, records added in outlook.

Sync2 seems to goes almost well, records added in outlook, but secondly records are deleted from CalendarTable where userid=1..

Sync3 does not add records in outlook

Sync4 does not add records in outlook

all syncs runs well alone.
but when 2 or more syncs run, then records are falsely added to tombstone-table and makes the error go wrong.

I can send you the an excel-file with the records if you want to try..

[Developer team]

Hello Morten,

Yes, please send us:
1) mentioned excel file;
2) the current version of your configuration files (4 sets as I understand);
3) the current structure of the database objects in the form of SQL script;
4) log file.

[Mop100]

I have a zipfile with mentioned files. Do you have an emailadress to send attachment to?
Run sql-script in sequense, then add records to outlooktest-table.

each subscription works well on its own, but when more than one is active records are transferred to tombstone (and then added to table again and then removed again).
That is why some subscriptions not are active at the moment..

[Developer team]

support [at] sync2db.com

[Developer team]

Morten,

I have received your files, thank you.

We will inform you as soon as we have any progress.

[Mop100]

Hello.
In my database table I have a field with emailadress that is attending in a meeting.
Sync2db syncs appointments to outlook.
I want to add RequiredAttendees into the appointment in outlook.

The property RequiredAttendees should be able to do this.
If I create a meeting in Outlook and add RequiredAttendees, and sync2db to my database, then I can read the emailadresses in my databasefield. (attendees given in Outlook is visible in field in database correctly).
My problem is when I create the item in my database. Then the RequiredAttendees is not added into Outlook.
My mapping is like this:

    <mapping>
      <Active>true</Active>
      <PropertyName>RequiredAttendees</PropertyName>
      <ColumnName>RequiredAttendees</ColumnName>
      <PropertyType>String</PropertyType>
      <ColumnType>VARCHAR</ColumnType>
      <Length>250</Length>
      <AllowNull>true</AllowNull>
      <PrimaryKey>false</PrimaryKey>
      <Indexed>false</Indexed>
     </mapping>

Is there any other fields I should include to make the meeting / appointment correct?

[Mop100]

I have sent you a new email with further information.

[Mop100]

Hello. Have you received my email?

[Mop100]

With this last piece functioning, I think I will be ready to go live with my syncsystem, just run test in my backupsystem to check stability once again.

Last fix has worked like a charm - no more failed sync!

After that requiredattendees is fixed, the only thing that is missing in my system will be that your collegues in sync2-team fix an issue with syncing blank calendar items. My company happen to create calendar-activity often that is blank (no text in it). We just select a timeframe, and create activity, and leave everything blanc. This is to "reservate" time that we do not work --> to be offline. we dont normally write anything there.

[Developer team]

Dear Morten,

Sorry for the delay.

1) About RequiredAttendees.

This is a Sync2DB Synchronizer issue – it cannot update Outlook fields RequiredAttendees, OptionalAttendees, Resources.

Thank you very much for your help in finding it.
Unfortunately, I can not say exactly when it will be fixed.
We will be happy to inform you via e-mail as soon as the fix is available.

2) About 4 Calendar folders for 4 users.
Please find the files attached. We hope they will help you.

Thank you again for cooperation.

[Support Manager]

Dear Morten,

Developers fixed the issue with Sync2. You should be able to download it dirrectly from link bellow:

http://download.4team.biz/updates/sync2_1.90.0981.exe


Please let us know about results.

Have a great day!

[Mop100]

Thank you.
Works almost good. Great to experience quick response to bugfixes! I will do my best to report back with my thorough testing reports.

I create empty appointment-entry as issued.
Sync - OK!
Create 2 empty appointment-entries in google just to see if both are synced back.. They are not. They are treated as one appointment.
Try to edit one of these appointments in outlook (write e.g. "Test" in subject) and sync back to google..
Then one appointment is deleted and the other one is edited with the text I specified.

Try to create 2 equal empty appointments in google, then sync to outlook, then delete from outlook the one that is visible there.. Then both are deleted from google.
Same thing happens if I have 2 equal appointments.

If I create 2 equal (empty or not empty) appointments in Outlook they are synced to google, and act as 2 separate appointments which is correct.

BR

Morten

[Mop100]

Hello. Have now tried this one-table-sync with 4 views. Cannot get it working correctly. Mostly it is OK, but there is one or more issues..
I have in the maintable 1849 rows, filtered: userid = 1 ; 563 rows, userid = 2 ; 592 rows, userid = 3 ; 501 rows, userid = 4 ; 193 rows.
When sync2db to outlook this produces in the outlook calendarfolders:
user 1 (folder) : 563 records
user 2 (folder) : 592 records
user 3 (folder) : 501 records
user 4 (folder) : 179records
no records are deleted to the tombstone-table.
The reason why there is different recordcount in view userid4 and user4 (folder) is unknown.
The records that are not transferred are if there are equal records. The only difference between the records is the primary key. The date and text in the records are the same, and somehow these records are treated as one record.

If I increase the recordcount in one of the views to be eg. 1804 records, then only 1001 records are transferred to outlook. There seems to be some kind of limit? Is this in the sdb-file or is it in the program?

Best regards
Morten

Dear Morten,

Sorry for the delay.

1) About RequiredAttendees.

This is a Sync2DB Synchronizer issue – it cannot update Outlook fields RequiredAttendees, OptionalAttendees, Resources.

Thank you very much for your help in finding it.
Unfortunately, I can not say exactly when it will be fixed.
We will be happy to inform you via e-mail as soon as the fix is available.

2) About 4 Calendar folders for 4 users.
Please find the files attached. We hope they will help you.

Thank you again for cooperation.

[Developer team]

The records that are not transferred are if there are equal records. The only difference between the records is the primary key. The date and text in the records are the same, and somehow these records are treated as one record.

Hello Morten,

The reason of your issue is the following: Sync2DB considers the records you mentioned as duplicates, because uniqueness of records/items is defined by “equivalenceFields” parameter:
<equivalenceFields>Subject,Start,Duration,Location</equivalenceFields>

So, please take it into account.

[Mop100]

Hello.
Sync2 does not handle very well to "merge" 2 existing calendars.
That is I have a google calendar that is being used, and an Outlook-calendar.
Basically the calendars contains the same records, but are uploaded to google calendar previously.
Then there has been some changes both in outlook and google calendar.

I now decided to use sync2 to merge the calendars and do deletes (manually) of duplicates.

I synced my calendar, and discover that some records are not synced (uploaded) to google. There is also some records that are not downloaded from google.

Sync2 seems to work best with a "clean" google calendar from starting of. So when I use sync2 I have to delete my calendar in google to start the syncing.

Best regards Morten