Schedule import data

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • enricorossa
    Senior Member
    • Jul 2018
    • 125

    Schedule import data


    Hello, you can schedule an import from csv to synchronize the data exported from my documents management
    thank you
  • tanya
    Senior Member
    • Jun 2014
    • 4308

    #2
    If I understand you well, it is possible only with development

    Comment

    • enricorossa
      Senior Member
      • Jul 2018
      • 125

      #3

      Excuse me for my English, you can schedule the import of a csv file every day
      thank you

      Comment

      • tanya
        Senior Member
        • Jun 2014
        • 4308

        #4
        if any developer make this customization for you, you can schedule the import of a csv file every day.
        But you can't find this functionality in basic EspoCRM

        Comment

        • enricorossa
          Senior Member
          • Jul 2018
          • 125

          #5

          Ok then I write a few lines, can I use crom and a script using API?

          Comment

          • enricorossa
            Senior Member
            • Jul 2018
            • 125

            #6

            where can I find the list of fields with the names to use? I have to get them from the entity manager

            Comment

            • enricorossa
              Senior Member
              • Jul 2018
              • 125

              #7

              I managed with a simple script to do what I wanted and insert the records from csv in Expo with API But I can not create a relationship with the account, what should I do not just enter the id of the account to be related in the related field?
              $arrayEPF['account']='5b5897ce7e18eb734'; ??????? this is field link
              $arrayEPF['dataDocumento']=date('Y-m-d');
              $arrayEPF['importo']='1500';
              $arrayEPF['name']='Prova API';
              $arrayEPF['numeroDocumento']='111';
              $arrayEPF['stato']='CARICATO';

              thank you

              Comment

              • enricorossa
                Senior Member
                • Jul 2018
                • 125

                #8

                sorry I was wrong to indicate the name of the account field -> accountId

                Comment

                Working...