How to do batch record changes, updating multiple records in PostgreSQL
so they appear in DAViCAL?
I made updates to the database, but the changes do not show up in DAViCAL.
Details:
There are many contacts at one company that moved from, let's say, 1233
Main St. to 1234 Main St.
I did this in PostgreSQL:
update addressbook_address_adr set street_address =
replace(street_address, '1233 Main St.', '1234 Main St.');
That seems to have worked. This command:
select * from addressbook_address_adr where street_address='1233 Main St.';
returns nothing, and the same command with '1234' returns all the
updated records.
However, DAViCAL (as viewed from Apple's Contacts.app) still shows all
contacts at 1233 Main St.
Thanks in advance for troubleshooting clues.
dn
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
_______________________________________________
Davical-general mailing list
Davical-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-general
so they appear in DAViCAL?
I made updates to the database, but the changes do not show up in DAViCAL.
Details:
There are many contacts at one company that moved from, let's say, 1233
Main St. to 1234 Main St.
I did this in PostgreSQL:
update addressbook_address_adr set street_address =
replace(street_address, '1233 Main St.', '1234 Main St.');
That seems to have worked. This command:
select * from addressbook_address_adr where street_address='1233 Main St.';
returns nothing, and the same command with '1234' returns all the
updated records.
However, DAViCAL (as viewed from Apple's Contacts.app) still shows all
contacts at 1233 Main St.
Thanks in advance for troubleshooting clues.
dn
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
_______________________________________________
Davical-general mailing list
Davical-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-general