matching data to a new session using an access database link

[Tonygets]

Hi,

Can we please have some assistance writing this basic automation.

Overview of what we are trying to achieve: we are going to write stock quantity values from a csv spreadsheet linked to an Access database (Datafeed Session) to the Stock Upload Session spreadsheet. Then 'hide' and 'disable purchase' for products that are less than 5 quantity in stock for the Stock Upload Session spreadsheet.

I have attached a zip file containing the 2 documents (datafeed document and stock upload document).

Can you please link the ‘datafeed.csv’ file to the Access database file. Then create a task that matches Column A ‘Sku’ from stock_upload.csv (starting at row 2) to Column A ‘code‘ in the Datafeed.csv document (I think this will need to be written using an SQL query). If the value matches for the active row then copy the data from Column K ‘stock level’ of the Datafeed session to Column C ‘InStock’ of the Stock_Upload Session.

Loop through the Stock_Upload session until all rows have been matched. If a row in Column A of stock_upload session does not match a value in Column A of datafeed session then move to the next row of stock upload session. Once all rows have been matched then close Datafeed session (no need to save).

Then in Stock_update session:

Start at row 2
- For active row, IF value in Column C ‘InStock’ is greater or equal to 5 THEN set value of Column E ‘DisablePurchase’ to ‘FALSE’. OR
- For active row, IF value in Column C ‘InStock’ is less than 5 THEN set value of Column E ‘DisablePurchase’ to ‘TRUE’ AND
- For active row, IF value in Column C ‘InStock’ is greater or equal to 5 THEN set value of Column F ‘VisibilityId’ to ‘0’. OR
- For active row, IF value in Column C ‘InStock’ is less than 5 THEN set value of Column E ‘VisibilityId’ to ‘1’.

Then Save and Close the stock upload session.

Help with this automation is really appreciated.

Kind regards,

Anthony

[forumsupport]

Hello,

We have created the sample task as per the requirement. Please follow below mentioned steps to run the task,

. Please copy .atmn under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
.Copy .csv files under c:\.

Hope that helps.

[Tonygets]

Hi,

Thank you for the task. I have tested the task and it works well however I have found that the way the task is written is not suited to my needs because in the current format, it would take a very long time to work its way through 30,000 rows of data.

One way I can think to improve the speed of the task is to write the values for columns E and F just after the value for column c is written in session1. That way the automation will not need to cycle through the rows twice. Do you think that will help?

Can you think of any other ways we can write this automation to speed up the process?

Thanks and regards,

Tony

[forumsupport]

Hello,

The task we uploaded exits loop after writting column c value and right away jumps to the command that writes Column E and Column F value.

Alternatively, we can read datafeed.csv using 'Read from CSV/Text file' command that would increase the speed of task considerably.

We have amended the task for your convenience. Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.

Hope that helps.