+15Hi,
Does anyone have a copy of the Excel Input tool they could upload where you copy an object out of IFS - run a macro and then can paste the objects back into IFS?
This tool is very handy for adding in new records into an overview form
Thanks in advance
Best answer by CallumW
Thanks
I have since come across a different version which has been tidied up a little with helpful instructions inside.
I have attached it here as a ZIP file (as the excel file with the macro is blocked from being uploaded here) so others can use if the find it helpful.
Please note: As I don’t know the full origin of the spreadsheet, I cannot say whether its been validated/approved etc… by IFS. - But all in all it is purely just a copy and paste tool, so you would just need to perform a sense check on the pasted data before you save the record.
P.s. I have checked the macros in the file which are all safe to run
+15Thanks
I have since come across a different version which has been tidied up a little with helpful instructions inside.
I have attached it here as a ZIP file (as the excel file with the macro is blocked from being uploaded here) so others can use if the find it helpful.
Please note: As I don’t know the full origin of the spreadsheet, I cannot say whether its been validated/approved etc… by IFS. - But all in all it is purely just a copy and paste tool, so you would just need to perform a sense check on the pasted data before you save the record.
P.s. I have checked the macros in the file which are all safe to run
+21For what I know this is not an IFS supported tool. What it does, I know it as Simple Migration Tool, is to make handy use of the clipboard function in a windows environment.
If you’re a bit neerdy, you could even use in IFS copy object, paste in Notepad. Change some values and copy all. Head back to IFS and use RMB > Edit > Paste Object.
Example I open Service and Maintenance\Basic Data\Maintenance Basic Data. Select a row and use RMB > Edit > Copy Object. pasting gives:
!IFS.COPYOBJECT
$LU=MaintenanceCauseCode
$VIEW=MAINTENANCE_CAUSE_CODE
$RECORD=!
-$0:ERR_CAUSE=8
-$1:DESCRIPTION=Design error
-$2:BLOCK_LOV_USE=FALSE
-
Next I make the change:
!IFS.COPYOBJECT
$LU=MaintenanceCauseCode
$VIEW=MAINTENANCE_CAUSE_CODE
$RECORD=!
-$0:ERR_CAUSE=10
-$1:DESCRIPTION=Meter Reading Error
-$2:BLOCK_LOV_USE=FALSE
-
Copy all and paste as object in IFS:
Press Save (F12) and ready.
I’ve used this during the implementation of a module where there was a lot of basic data to prepare.
I know I could have used SQL to write records, but this is just another way if you don’t have SQL Developer or another IDE at hand.
+11I used Excel to construct the data this way so I could paste it into IFS, but that was before I was introduced to the “magic spreadsheet” as the consultant called it, which is much more convenient.
It might not be officially supported, but the resulting paste process still goes through API data validation so is as safe as any other method.
+8Why this tools cannot be used on IFS 10 ?
After I clicked Export buton, the Paste Object button still disabled
+11It does work with IFS 10, I used it yesterday!
+8Solved. After I click Export button, the object cannot be pasted if IFS 7 Application opened.
+8Update: Sometimes, if the Export-Paste Object doesn’t work, close File Explorer and/or old IFS Application (IFS7).
We use this input tool as well, but for some reason, after adding the records to the excel spreadsheet and do a RMB the Paste Object is not available. Did something change in UPD 11.
Thanks
Shelley
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
