MxLoader

Is it possible to delete individual records or rows via MxLoader?

------------------------------
Stevie Holloway
Tufts University
------------------------------

Hi Stevie,

Short answer is yes, you should just change the value in C1 to "Delete."

Do you get an error? If so can you please post that, a screenshot of your sheet, and whether or not you're using REST/OS?

Thanks,

------------------------------
Matt McGuire
Aquitas Solutions
https://www.aquitas-solutions.com/
------------------------------

I've tried that before and it seems wipe out everything, depending on what table you're hitting. I guess you reduce your results to what you want to delete, the put delete in C1?

Thanks

Stevie

------------------------------
StevieHollowayTufts University
------------------------------

Original Message:
Sent: 02-03-2022 11:30
From: Matt McGuire
Subject: Delete Individual Records Via MxLoader 8.3

Hi Stevie,

Short answer is yes, you should just change the value in C1 to "Delete."

Do you get an error? If so can you please post that, a screenshot of your sheet, and whether or not you're using REST/OS?

Thanks,

------------------------------
Matt McGuire
Aquitas Solutions
https://www.aquitas-solutions.com/
------------------------------

Hi Stevie,

That's correct. You can also insert a blank row to stop the file from executing all the rows. Say you only want to delete the first 10 records, add a blank row in after the 10th record and MxLoader will only action the records above the blank row.

Please let me know if that helps or if you have any other questions.

Thanks,

------------------------------
Matt McGuire
Aquitas Solutions
https://www.aquitas-solutions.com/
------------------------------

Original Message:
Sent: 02-03-2022 12:17
From: Stevie Holloway
Subject: Delete Individual Records Via MxLoader 8.3

I've tried that before and it seems wipe out everything, depending on what table you're hitting. I guess you reduce your results to what you want to delete, the put delete in C1?

Thanks

Stevie

------------------------------
StevieHollowayTufts University
------------------------------


Original Message:
Sent: 02-03-2022 11:30
From: Matt McGuire
Subject: Delete Individual Records Via MxLoader 8.3

Hi Stevie,

Short answer is yes, you should just change the value in C1 to "Delete."

Do you get an error? If so can you please post that, a screenshot of your sheet, and whether or not you're using REST/OS?

Thanks,

------------------------------
Matt McGuire
Aquitas Solutions
https://www.aquitas-solutions.com/

Thank you so much for that tip. 

Stevie

------------------------------
StevieHollowayTufts University
------------------------------

Original Message:
Sent: 02-03-2022 12:24
From: Matt McGuire
Subject: Delete Individual Records Via MxLoader 8.3

Hi Stevie,

That's correct. You can also insert a blank row to stop the file from executing all the rows. Say you only want to delete the first 10 records, add a blank row in after the 10th record and MxLoader will only action the records above the blank row.

Please let me know if that helps or if you have any other questions.

Thanks,

------------------------------
Matt McGuire
Aquitas Solutions
https://www.aquitas-solutions.com/
------------------------------


Original Message:
Sent: 02-03-2022 12:17
From: Stevie Holloway
Subject: Delete Individual Records Via MxLoader 8.3

I've tried that before and it seems wipe out everything, depending on what table you're hitting. I guess you reduce your results to what you want to delete, the put delete in C1?

Thanks

Stevie

------------------------------
StevieHollowayTufts University


Original Message:
Sent: 02-03-2022 11:30
From: Matt McGuire
Subject: Delete Individual Records Via MxLoader 8.3

Hi Stevie,

Short answer is yes, you should just change the value in C1 to "Delete."

Do you get an error? If so can you please post that, a screenshot of your sheet, and whether or not you're using REST/OS?

Thanks,

------------------------------
Matt McGuire
Aquitas Solutions
https://www.aquitas-solutions.com/