Question

Import scenario on "search in files" screen


Userlevel 6
Badge +5

I am trying to write an import scenario to clean files which are 1 year ago and no longer needed.
 

The datasource is from a GI which is wrote to search the obsoleted files out.

 

However, my scenario is run with errors which is saying “object not set to an instance”.
So probably, I am lacking 1 step in import scenrio which is to set the focus on the line to be deleted.

Can anyone give me some help on how to write this kind of import scenario.
Thank you.


10 replies

Userlevel 7
Badge +11

Hi @ray20 

Please make following change and try again. Move Dialog answer line above Delete action. 

Regards,

 

Userlevel 6
Badge +5

Hi @ray20 

Please make following change and try again. Move Dialog answer line above Delete action. 

Regards,

 

@vkumar 
Thank you, I tried your method, but still end with errors

 

Userlevel 7
Badge +17

Hi, @ray20  Even I tried in multiple ways and got the errors.

@vkumar  Is this Acumatica bug? 

Userlevel 6
Badge +5

@Naveen Boga 
 

 

Hi, in the above post, this user said he can clean the filed by import scenario, so ,there should be a way.
 

 

Userlevel 7
Badge +11

Hi @ray20, @Naveen Boga 

Let me check the scenario on my demo. Will let you know the result. 

Regards,

Userlevel 5
Badge +3

The below configurations works for me. However, over a larger set, it becomes extremely slow. It would be great if Acumatica could make this a feature. Otherwise, a customization might be the most efficient way.

 

 

I hope this help!

Userlevel 6
Badge +5

@yhartman 
Hello, Your method works. Many thanks.
However, it works with limitations.

I am still using 2020R2, I don’t konw whether this issue happens only in 2020R2, but I did meet it.

The issue is:
I can only delete the files without “show unassigned files ” check on

 

if a file needs to be selected out by selecting this checkbox first, my code does not work above.

 

do you know how to solve this issue?

 

by the way, another issue I solved is that we have to remember checking on the “commit” checkbox for delete action. otherwise, only the first line would be deleted every time.

Userlevel 7
Badge

Hi @ray20 were you able to resolve your issue? Thank you!

Userlevel 6
Badge +5

@Chris Hackett 
Hello, Thank you for asking,unfortunately, no. but I have to delete a little few files with   “show unassigned files ” checked on. So I did these manually. 
Normally, I just have to clean files without “show unassigned files” checked.

But if someone can point out how to solve my issue above. it might be helpful in the future.

Userlevel 4
Badge

Is there any way to utilize the “Get File” action from the Search In Files screen in an import/export scenario? 

I am trying to figure out how to get file downloaded to computer, and then delete the file in one step. 

Any advice is appreciated!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved