- Expected Frequency is in days.
- Unique Contents will cause a subsequent import to halt if the file contents between the current and last import are the same. It is a way of preserving time as well as preventing unnecessary database activity.
- It is documented, under Blueprint Help as "Importing files," but the full syntax of the "importconfig" file is not covered. The modification of some components of this file are intended for action by either a Pharos employee or reseller.
You can use the GenericHR file as a template for your use.
Thank you Scott for your answer, it helps
Could you please also clarify this point
I use HrLdapImporter to populate employees.csv file and then try to automate this import into BP database
An importconfig file is registered and I can see a new type of data available in Integration section.
I put the csv file into c:\ for test and setup importconfig as
which I believe should tell File Importer to pick up test.csv as soon as it gets into c:\
HrLdapImporter runs and creates testyyyymmddhhmmss.csv
but it seems that it is never imported
Where should I trace those attempts of File Importer to actually import the data?
the MustMatch parameter is setup as follows
but unless I rename the test20150909100000.csv into test.csv it is never picked up with file importer.
With manual renaming it is picked up, but all attemtps fail with the following log info
Is there anything else that should be configured to make it work?
Make sure the filename you have entered into the <MonitorFileName></MonitorFileName> section allows for the DateTimeFormat that you have supplied. Based on your example, the section should be as such:
Note the wildcard between 'test' and '.csv'.
The reason why the file will not import, is because the 'test.csv' file has already been imported. If you wish to import a file with the same name as a previously imported file, you must set the <UniqueContents> value to 'false'.
Tim, thank you for your reply!
With <UniqueContents>false</UniqueContents> Blueprint tries to pick up the file with the same name but somehow this attempt fails with a result "Failed" and a messages
09/11/2015 10:21:31: This file has been imported before.
09/11/2015 10:21:31: Import finished.
Manual importing runs without that error however.
Would you please recommend how to address this issue?
Thank you in advance!
Assuming you have made the change to the <MonitorFileName> section to account for each import file having a unique time / date stamp, you will be OK when the actual daily import files are placed into the monitor folder. I think you are encountering difficulty during testing due to the use of the same import file over and over. Try changing the name of your import file so that it contains a unique date / time stamp each time.
Thank you Tim! I'll try that approach, but isn't it what <UniqueContents>false</UniqueContents> is for? To make File Import upload the same file over and over?
Tim, just recently I figured out what went unnoticed in my case. After any changes to importconfig file a new registration is necessary. As soon as the file is re-registered everything works as designed.
Thank you and a Happy New Year! )