Submitted by william_wicker on 2010/11/03 16:17
I've tried to adapt the supplied example to my own database situation, but I'm having no luck.
 
Here's my version of the SQLSynch.xml file: (connection string redacted for paranoia reasons)
 
<ConnectionString>Provider=SQLNCLI10;PWD=xxxx;UID=xxxx;DATABASE=xxxx;SERVER=xxxx\SQLEXPRESS
</ConnectionString>

<Password></Password>
<FieldMap>
[ID] VJS_PartNumber
[description] Item
[record_modified] VJS_DateModified
[mfg_name]ManufacturerName
[mfg_part_id]ManufacturerPartNum
-1 VJS_Parts
IMPORT VJS_SQLStatus
</FieldMap>
<Source>
SELECT ID, description, record_modified, mfg_name, mfg_part_id
FROM inventory_part
WHERE inactive = 0
and (record_modified > convert(datetime, '[DateUpdate]', 102))

</source>
<RecordIDField>VJS_PartNumber</RecordIDField>
<RecordStatus>VJS_SQLStatus ADD UPDATE</RecordStatus>
<RecordDateField>VJS_DateModified</RecordDateField>
<LastUpdate>2000-01-01 01:00:01</LastUpdate>
 
I've created the following fields in InfoQube:
VJS_PartNumber (text)
VJS_DateModified (date)
ManufacturerName (text)
ManufacturerPartNum (text)
VJS_Parts (bool)
VJS_SQLStatus (text)
 
The problem is that when I try to do the sync nothing happens! Tools->Database management->Synch with external database gives no result. no error, no nothing. I'm not sure how to try to troubleshoot this.
 
Is there a specific provider/style of connection string I need to use for IQ's sake?
 
Any other ideas?
 
Perhaps related: When I open the target grid, I get a message "Error reading data. Check the source, filter and sort criteria." Test data that I enter by hand disappears when the grid is closed and reopened. (But I can find it in the journal)
 
Puzzling.
 

Comments

UPDATE:
 
Changing the value of -1 to 1 for the VJS_Parts field in the xml file seems to have made things slightly better: No more "Error reading data". Still no remote data showing up, though.

Armando

2010/11/04 09:29

Permalink

I've never tried to do that, so I'm not sure.
BTW : The "Error reading data. Check the source, filter and sort criteria." is most probably related to a source/filter problem in your grid. Normally the XML file for syncing shouldn't have anything to do with that so I don't understand why the error disapeared after you changed one the values to 1

Hi,
 
In the field assignment, you need a space between the 2 fields, these 2 don't seem to have one:
 
[mfg_name]ManufacturerName
[mfg_part_id]ManufacturerPartNum
 
Can you try this ?