Bikur Cholim בקור חולים

Sunday, June 12, 2011

Data Import II: Importing Records

1. 1. Webviewer set to the address used as the get request should work. Then you can grab the source code for the html and parse it out.

1.2. You can add a java based 'module' or plugin to grab the data for you.

Q. It looks to me that many records were imported twice: once with, and once without the company name.  
I accept that this was required for Employer/Employees (or as you call it Company/Staff) purposes.  
However where there is only a Company, we don't need Company/Company relationships do we?  
It is not urgent, but sometime in the future (after you finish the accounts module?) please delete all records that are identical except that one has a company name and the other hasn't.

Q. There are many details in the fields that were not imported from the old contact file: Position, Department and Notes for example. 
Whenever I try to contact a gas engineer, all the pertinent details are practically lost. Is there any way to import them into the new file, in the Notes Field for example?
A. 22/10/2009 Menasche says: This task can be made easier, if you duplicate the original contacts file and Find all Records that have no notes in Notes Field (or all the other Fields mentioned in this request). 
Then choose Delete Found Records, which will leave you with a smaller File that contains the Records we need to work with.

27/09/2016
MS
Q. How can I arrange the Import Field Mapping Dialogue Box to only import Data that Matches a Field AND create a NEW Record IF the Data is NOT already in the Target Database?
Example: I have exported Records from one Table in FileMaker that need to be imported into another Table in FileMaker.  Problem is: some of the Data from the Source might already be in the Target Table. 
Step One is to Match Records,
Step Two is to esnure existing Data is NOT overwritten,
Step Three is to ensure that the Data that is not yet in the Target Table reaches it.
A. Change the Field Mapping Symbol to the Equal Sign: = for every Field that you are afraid that you will lose the Data: If the Data is not present it will be added (remember to tick the option "Add remaining data as new records") and if it is present, then it will be overwritten with the identical Data.

No comments:

Post a Comment