Datapage Question

[randy z]

Datapage
Here goes
operator ran 200 parts for cap study they should of been in order
but he forgot 3 parts about in the middle so we had to run them at
the end. Now my question is there a way to move the last two parts
ran in datapage back to were they should be. in order so that this
would make it easier in the spreadsheet.

Thanks in advance for any help

[\v/inston]

ascii dump in the editor, then cut and paste them in the order you want.

[BSchwark]

I believe it can also be done in your datapage editor by changing the time stamp to fit it the location or time you what them to be. Using trace fields would make this job easier.

Sorry. I have done this in Excel after dump it from Datapage


BS

[Matthew D. Hoedeman]

I don't think you can change the transaction date IN Datapage, but you can do the ASCII dump, then open and SEARCH AND REPLACE the transaction date for the mis-ordered parts so that their dates are between the proper transactions (see below, the seconds is the only thing different to make it easier in this example)

06-03-17-10-47-10
06-03-17-10-47-20
06-03-17-10-47-30
06-03-17-10-47-40
06-03-17-10-47-50

Trans 06-03-17-10-47-50 should be the third part, so search and replace all with 06-03-17-10-47-31 then save the file and do an ASCII load. It will add the transaction in the right order, but it will NOT remove the one that is out of order, it will still be there. You do not have to dump only the 'bad' ordered transactions, you can dump them all and you can load them all. If the date already exists, then it will not load that trans back into the database, it will only load the new ones.

[Mr.Natural]

AscII dump the 3 parts you missed

Open in Excel & change the date/time stamp to fit where you need em, DataPage/DataView arranges the parts by the date/time stamp & will install them as so. You cannot do a "SaveAs" when you exit Excel, you need to click on the "X" it will ask you if you want to save your changes to the "filename.DMP" answer yes, then you will get another warning window telling you that the features are not compatable with the Text format & if you still want to save as a .DMP file, answer yes.

Reload the AscII file you made the changes to & make sure everything is the way you want it before you delete the last 3 transactions.

Seem sorta confusing at 1st but it ain't too bad once you do it a couple of times.

P.S. you might want to AscII dump the entire run of parts before you start playing around cuz once you delete the transactions in the Editor, they are gone for GOOD.

[randy z]

Thanks alot for the help guys