Easy Field Changer

Administrator
Administrator Member, Moderator, Administrator Posts: 2,506
edited 2008-10-24 in Download section
Easy Field Changer
Easy way to change and/or validate field data in any table, without need to write codeunits, reports, etc.
You can change field or just validate it. Also you can set filters to the used table.

http://www.mibuso.com/dlinfo.asp?FileID=900

Discuss this download here.

Comments

  • ara3n
    ara3n Member Posts: 9,258
    I hope this does not fall into any client hands.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • ajhvdb
    ajhvdb Member Posts: 672
    What does the "do not change" do?
    Create dynamic Excel or Word documents, ReportX
  • roko
    roko Member Posts: 16
    ajhvdb wrote:
    What does the "do not change" do?
    It just validates the field, without changing it.
  • ajhvdb
    ajhvdb Member Posts: 672
    :-k Could you give an example of this "do not change" in which situation you would use it?
    Create dynamic Excel or Word documents, ReportX
  • ara3n
    ara3n Member Posts: 9,258
    on sales order you can hit f2 on "Sell-to customer No." and it will validate the record. recreate the lines etc etc.

    People usually do it on sales Line "No." field to update the line to get the correct price etc etc.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • roko
    roko Member Posts: 16
    ara3n wrote:
    on sales order you can hit f2 on "Sell-to customer No." and it will validate the record. recreate the lines etc etc.

    People usually do it on sales Line "No." field to update the line to get the correct price etc etc.
    Exactly :wink:
  • ajhvdb
    ajhvdb Member Posts: 672
    Thx
    Create dynamic Excel or Word documents, ReportX
  • Savatage
    Savatage Member Posts: 7,142
    Mine crashes while compiling

    FieldFrm@1103100009 : Form 7702;

    What's form 7702?
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • ara3n
    ara3n Member Posts: 9,258
    It's a form that displays the field table.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • DeKirsten
    DeKirsten Member Posts: 2
    I was considering building a tool like this myself, but i thought i should check MiBuSo first. And indeed, someone already did :)

    It's a great tool.
    As an in-house developer i get a lot of data change requests from end-users.

    I did make a correction in your progress window though, for it has bad performance on big tables like item ledger entries.

    So i changed this line:
    RecCount := RecRef.COUNT;

    into:
    RecCount := RecRef.COUNTAPPROX;

    and this line:
    Window.UPDATE(1, ROUND(ProcessedRecords/RecCount*10000,1));

    into:
    IF (ProcessedRecords MOD 100) = 1 THEN
    Window.UPDATE(1, ROUND(ProcessedRecords/RecCount*10000,1));

    It saves performance!
    If you can't join them, beat them.
  • Bilal
    Bilal Member Posts: 0
    Hi,

    Am having problems with this object. When i compile it or run it i get the error ''TableData 370 does not exist''. I need this inorder to save time attending to client requests. Can someone help me please?
  • kapamarou
    kapamarou Member Posts: 1,152
    Which Version of Navision do you use? Does your database contain table 370 Excel Buffer??
  • Bilal
    Bilal Member Posts: 0
    Am using Navision.Incadea version 3.70.B. My Database does not contain ''table 370 Excel Buffer''
    Will this tool work with my version and without table 370? Do you need a developers license to use this tool?
    Please help and thank you.
  • kapamarou
    kapamarou Member Posts: 1,152
    This object uses table 370 as source table.

    You can:

    a) see if you have Escel Buffer table with a different ID and set the source table to that

    or

    b) find this table from standard Navision and see if you can import it and if you have a license to use it.
  • Bilal
    Bilal Member Posts: 0
    Thank you kapamarou. However, I dont have that table even in another ID. I will try check in Standard Navision but it will be hard for me to get a copy of Naivision Standard especially where I am. How else can i get it? Thank you.
  • kapamarou
    kapamarou Member Posts: 1,152
    Bilal wrote:
    it will be hard for me to get a copy of Naivision Standard especially where I am

    I hope you mean you are on a sunny beach enjoying some vacation...??? :D


    You'll need to find the Client installation CD that contains the All-Famous CRONUS Database. In there you will find that missing object.

    I think it's missing because most probably your version of incadea is based on an older version of Nav.
  • Bilal
    Bilal Member Posts: 0
    Lol! You have a very good sense of humour! I wish i was in a Sunny Beach in Mombasa but rather am in a very sunny, dry worst part of Africa, Olduvai Gorge East Africa! Slow Internet speeds, flies, all types of insects etc. Anyways i will struggle to get the object.Thank you for all you help!

Categories