My kingdom for a Sesame SQL parser...

I have two applications that are basically identical for a client that runs a job placement business. The applications are for maintaining a database of job applicants, the major difference being they are different regions. However, they would like to combine these two regions into one bigger region, so I need to combine the data into one larger application. The forms and table layout are basically identical. The data is heavily textual, with several multi-line text boxes.

I tried the Export to CSV and Import, but embedded commas screwed things up when I used the defaults. I'm assuming I need to use a custom spec but I couldn't get that work...

Is there an easier or better way?

I haven't upgraded them yet from 2.6.3...they have 14 or 15 users in seven remote offices connecting to a cloud server. It takes a unified effort to update them all overnight.

When I export with tab separators and pipe delimiters, the data looks okay, but then it won't even import without erroring immediately.

CSV export and import would be the easiest way. Other then that you could write a push routine from the one database that uses XResultSetSearch() and XResultSetValue() to push over the records.

Quote:


Not directly. You can modify the code that I posted at https://www.lantica.com/Forum5/cgi-bin/yabb2/YaBB.pl?num=1505872755/1#1 You would need to use 2 Mass Updates. One to load the export spec and write the data out to a text file. Then another one in the other database that reads in the text file and uses the data in it to create an import spec.

-Ray