8 Replies Latest reply on Dec 28, 2015 7:09 AM by Nikolay Karetnikov

    Automate File Import Task

    Nikolay Karetnikov Navigator

         Hello!

      Importing file is a good feature if you are running initial setup. When, on the other hand, you need to update employee info on daily, weekly basis manual import is quite a tedious task

      Is there a way to automate the procedure?

      Let's say I have employees.csv file prepared daily and stored on c:\employees.csv.

      How to get the data into the system?

      I found the GenericHR.importconfig file inside C:\Program Files (x86)\PharosSystems\Blueprint\bin and there are the following lines there

      Configuration>

          <Install>

            <ImportDescription>Human Resource Data</ImportDescription>

            <UniqueContents>false</UniqueContents>

            <MonitorDirectory></MonitorDirectory>

            <MonitorFileName></MonitorFileName>

            <ExpectedFrequency>0</ExpectedFrequency>

          </Install>

      Seems to me what I want, but it rises some questions:

       

      what does expectedFrequency count in? Minutes, hours, days?

      what <UniqueContents> is for?

      and finally - is that an undocumented feature? (I found no info on it)

       

      Thank you!

        • Re: Automate File Import Task
          Scott Olswold Guide

          Nikolay,

           

          • 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.

           

          Regards,

          Scott

            • Re: Automate File Import Task
              Nikolay Karetnikov Navigator

              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

              <Install>

                    <ImportDescription>LDAP-HR</ImportDescription>

                    <UniqueContents>false</UniqueContents>

                    <MonitorDirectory>c:\</MonitorDirectory>

                    <MonitorFileName>test.csv</MonitorFileName>

                    <ExpectedFrequency>0</ExpectedFrequency>

                  </Install>

              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?

              Thanks!

                • Re: Automate File Import Task
                  Nikolay Karetnikov Navigator

                  follow up:

                  the MustMatch parameter is setup as follows

                  <FileNameDateTimeFormat MustMatch="true">yyyyMMddHHmmss</FileNameDateTimeFormat>

                  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?

                    • Re: Automate File Import Task
                      tcampbell@pharos.com Navigator

                      Hello Nikolay,

                       

                      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:

                       

                      <MonitorFileName>test*.csv</MonitorFileName>

                       

                      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'.

                       

                      Regards,

                      Tim.