Macro that will import new files monthly

18 posts / 0 new
Log in or register to post comments
Last post
Fri, 11/04/2016 - 13:02
Breanna_28
Offline
Joined: 10/24/2016 - 15:02

Here is the history. Thanks again for your help! I really appreciate it.

Files: 
Plain text icon Import History.txt
Top
Fri, 11/04/2016 - 13:11
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Breanna,

Did you try running just that section of code to see if it works?  Also I adapted what you sent me to your script, do you want to try it out.

Brian

Client.RunAtServer True
dbName = "IDEA_Account_" & dateParm & ".IMD"
Client.ImportDelimFile "IDEA_Account_" & dateParm & ".csv", dbName, FALSE, "", "IDEA_Account_20161031.RDF", TRUE
Client.OpenDatabase (dbName)
Client.RunAtServer False

 

Top
Fri, 11/04/2016 - 13:39
Breanna_28
Offline
Joined: 10/24/2016 - 15:02

It only runs when I have already imported the file manually.  Once I delete the file from the Source Files and Import Definitions folders in the Library and try to start from scratch it cannot find the file.  I tried running the script you provided above and unfortunately I get the syntax error here.

Images: 
Top
Fri, 11/04/2016 - 13:55
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

The syntax error is because you didn't add a function line to the top of what I gave you.  You need to add

Function TextImport()

Top
Fri, 11/04/2016 - 14:20
Breanna_28
Offline
Joined: 10/24/2016 - 15:02

I still receive an error that the file cannot be found

Top
Fri, 11/04/2016 - 14:30
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Breanna,

Sorry I am at a loss right now.  I haven't used the server version of IDEA before so I don't know the tricks.  You might want to give the audimation (assuming your license is with them) help desk a call and they would hopefully be able to help you out.

Good luck.

Brian

Top
Fri, 11/04/2016 - 15:09
Breanna_28
Offline
Joined: 10/24/2016 - 15:02

That's alright.  I will give them a call.  Thank you so much for your help!
Breanna

Top

Pages