Rocket U2 | UniVerse & UniData

 View Only

  • 1.  Accuterm FTD documentation - formula question

    Posted 05-09-2022 18:31
    Is the accuterm documentation available online here in the Rocket site?

    I am attempting to FTD data into a spreadsheet where a given column is a calculation.

    Example column a divided by column b placed into column c.

    I can put the expression into the data field I will download and the expression executes BUT the data filled in the excel sheet is the result. I want the formula to be loaded into that column, not the result. The display should look the same BUT with the expression in the field, where changing column a or b alters column c automatically.

    Does anyone know how this could be accomplished?

    ------------------------------
    Kathleen Hambrick
    Programmer at Colwell
    ------------------------------


  • 2.  RE: Accuterm FTD documentation - formula question

    ROCKETEER
    Posted 05-10-2022 04:25
    I checked the online access to the documentation and although accuterm (and jbase) appear on the search, when you go to the linked documentation page nothing is present. I will drop a note to the internal teams to see if they can get this sorted out so that you can download it.

    ------------------------------
    Jonathan Smith
    UniData ATS
    Rocket Support
    ------------------------------

    Original Message


  • 3.  RE: Accuterm FTD documentation - formula question

    ROCKETEER
    Posted 05-11-2022 09:47
    Kathleen,

    There is no separate documentation for AccuTerm FTD that I am aware of.

    All documentation is supplied with the product and is available via the AccuTerm "Help" menu – "Help -> Documentation -> User Manual" and therefore already downloadable.

    In the User Manual, there is a section called "MultiValue File Transfer" and a link to downloading files. From that section there are also links to "configuration" settings and "options".

    Hope that helps.

    If not, then an email to support@zumasys.com would currently be required for further support.

    Regards,

    Mike Street

    jBASE/QM/AccuTerm Support.



    ------------------------------
    Mike Street
    Technical Support Engineer
    Rocket Internal - All Brands
    ------------------------------

    Original Message


  • 4.  RE: Accuterm FTD documentation - formula question

    Posted 05-11-2022 10:08
    Thanks Mike for the information. I have already tried those two places and
    still have questions, it's in my nature :) I was hoping someone would step
    up who uses this feature extensively so that I could ask my q;s and learn
    some tricks. Doesn't seem like that's going to happen. Having used
    Wintegrate for so long, this is a REALLY great feature in Accuterm.

    Thanks again!

    On Wed, May 11, 2022 at 6:49 AM Mike Street via Rocket Forum <
    Mail@forum.rocketsoftware.com> wrote:

    > Kathleen, There is no separate documentation for AccuTerm FTD that I am
    > aware of. All documentation is supplied with the product and is... -posted
    > to the "Rocket U2 | UniVerse & UniData" forum
    > Invite your colleagues to join the Rocket Forum and grow our expert
    > network.
    > ------------------------------
    > [image: Rocket Software] <https: community.rocketsoftware.com="">
    > Rocket U2 | UniVerse & UniData
    > <https: community.rocketsoftware.com/forums/forum-home/digestviewer?communitykey="dd45d00d-59db-4884-b3eb-2b0647af231b">
    > Post New Message Online
    > <http: community.rocketsoftware.com/participate/postmessage?groupid="49">
    > Invite your colleagues to join the Rocket Forum and grow our expert
    > network. Share this link. <https: community.rocketsoftware.com/register="">
    > Re: Accuterm FTD documentation - formula question
    > <https: community.rocketsoftware.com/forums/forum-home/digestviewer/viewthread?messagekey="abc00c01-c704-464e-9f1a-bce59545dd4f&CommunityKey=dd45d00d-59db-4884-b3eb-2b0647af231b&bm=abc00c01-c704-464e-9f1a-bce59545dd4f">
    > Reply to Group Online
    > <https: community.rocketsoftware.com/forums/all-discussions/postreply?messagekey="abc00c01-c704-464e-9f1a-bce59545dd4f&ListKey=1daf02a1-f0f0-4a5c-a95d-a2b9f11dcf4b"> Reply
    > to Group
    > <rocket_universe_abc00c01-c704-464e-9f1a-bce59545dd4f@connectedcommunity.org?subject=re:+accuterm+ftd+documentation+-+formula+question>
    > [image: Mike Street]
    > <https: community.rocketsoftware.com/network/members/profile?userkey="2d9d2aab-c21f-45df-8d3f-31a5ef3e31c3">
    > May 11, 2022 9:47 AM
    > Mike Street
    > <https: community.rocketsoftware.com/network/members/profile?userkey="2d9d2aab-c21f-45df-8d3f-31a5ef3e31c3">
    > Kathleen,
    >
    > There is no separate documentation for AccuTerm FTD that I am aware of.
    >
    > All documentation is supplied with the product and is available via the
    > AccuTerm "Help" menu – "Help -> Documentation -> User Manual" and therefore
    > already downloadable.
    >
    > In the User Manual, there is a section called "MultiValue File Transfer"
    > and a link to downloading files. From that section there are also links to
    > "configuration" settings and "options".
    >
    > Hope that helps.
    >
    > If not, then an email to support@zumasys.com would currently be required
    > for further support.
    >
    > Regards,
    >
    > Mike Street
    >
    > jBASE/QM/AccuTerm Support.
    >
    >
    > ------------------------------
    > Mike Street
    > Technical Support Engineer
    > Rocket Internal - All Brands
    > ------------------------------
    > *Reply to Group Online
    > <https: community.rocketsoftware.com/forums/all-discussions/postreply?messagekey="abc00c01-c704-464e-9f1a-bce59545dd4f&ListKey=1daf02a1-f0f0-4a5c-a95d-a2b9f11dcf4b">*
    > *View Thread
    > <https: community.rocketsoftware.com/forums/forum-home/digestviewer/viewthread?messagekey="abc00c01-c704-464e-9f1a-bce59545dd4f&CommunityKey=dd45d00d-59db-4884-b3eb-2b0647af231b&bm=abc00c01-c704-464e-9f1a-bce59545dd4f">*
    > *Recommend
    > <https: community.rocketsoftware.com/forums/forum-home/digestviewer/viewthread?messagekey="abc00c01-c704-464e-9f1a-bce59545dd4f&CommunityKey=dd45d00d-59db-4884-b3eb-2b0647af231b&bm=abc00c01-c704-464e-9f1a-bce59545dd4f&cmd=rate&cmdarg=add">*
    > *Forward
    > <https: community.rocketsoftware.com/forums/all-discussions/forwardmessages?messagekey="abc00c01-c704-464e-9f1a-bce59545dd4f&ListKey=1daf02a1-f0f0-4a5c-a95d-a2b9f11dcf4b">*
    > *Flag as Inappropriate
    > <https: community.rocketsoftware.com/forums/forum-home/digestviewer/viewthread?messagekey="abc00c01-c704-464e-9f1a-bce59545dd4f&CommunityKey=dd45d00d-59db-4884-b3eb-2b0647af231b&bm=abc00c01-c704-464e-9f1a-bce59545dd4f&MarkAppropriate=abc00c01-c704-464e-9f1a-bce59545dd4f">*
    > *Post New Message Online
    > <http: community.rocketsoftware.com/participate/postmessage?groupid="49">*
    >
    > -------------------------------------------
    > Original Message:
    > Sent: 05-09-2022 18:31
    > From: Kathleen Hambrick
    > Subject: Accuterm FTD documentation - formula question
    >
    > Is the accuterm documentation available online here in the Rocket site?
    >
    > I am attempting to FTD data into a spreadsheet where a given column is a
    > calculation.
    >
    > Example column a divided by column b placed into column c.
    >
    > I can put the expression into the data field I will download and the
    > expression executes BUT the data filled in the excel sheet is the result. I
    > want the formula to be loaded into that column, not the result. The display
    > should look the same BUT with the expression in the field, where changing
    > column a or b alters column c automatically.
    >
    > Does anyone know how this could be accomplished?
    >
    > ------------------------------
    > Kathleen Hambrick
    > Programmer at Colwell
    > ------------------------------
    >
    >
    >
    >
    > You are receiving this message because you followed the 'Accuterm FTD
    > documentation - formula question' message thread. To unsubscribe from this
    > message thread, go to Unsubscribe
    > <https: community.rocketsoftware.com/higherlogic/common/unfollow.aspx?userkey="01dbcc41-45f2-48a9-a334-22af21aa990a&sKey=KeyRemoved&ItemKey=bfda1df5-23cc-4dc1-94a4-b2ccd8e4499d">.
    >
    >
    > Update your email preferences
    > <https: community.rocketsoftware.com/go.aspx?c="Preferences§ion=email">
    > to choose the types of email you receive
    >
    > Unsubscribe from all participation emails
    > <https: community.rocketsoftware.com/higherlogic/egroups/unsubscribe.aspx?userkey="01dbcc41-45f2-48a9-a334-22af21aa990a&sKey=KeyRemoved&mClass=Social">
    >


    Original Message


  • 5.  RE: Accuterm FTD documentation - formula question

    ROCKETEER
    Posted 05-11-2022 17:16
    This response was recently posted to the AccuTerm (Asent) forum by Pete Schellenbach and is replicated here :

    I was able to use FTD to create an Excel worksheet with a formula. Here's what I did, so you can try it.
    Using the PROD.SAMPLE sample data file in the ACCUTERM account, I added a new dictionary item named FORMULA with an Excel formula as a constant:
    :CT DICT PROD.SAMPLE FORMULA
    DICT PROD.SAMPLE FORMULA
    01: S
    02: 0
    03: OUNCES
    04:
    05:
    06:
    07:
    08: A;'=INDIRECT("C" & ROW())*16'
    09: R
    10: 12
    Here is the FTD command:
    :FTD

    AccuTerm Data Transfer Utility


    (S)end, (R)eceive, (C)onfigure, (O)ptions, (H)elp or (E)xit ? S

    File transfer protocol: (A)SCII or (K)ERMIT ? K

    Enter source (PICK) file name: PROD.SAMPLE

    Enter source (PICK) item list: *

    Enter target (DOS) file name (d:\directory\file.ext): C:\TMP\TEST.XLSX

    Attributes to transfer: UPC DESC GROSS.WGT FORMULA

    Generate Header Record (<Y>/N/C): Y

    Explode MultiValue Fields (Y/<N>): N

    Converting TEST.XLSX to Excel file format... done.

    Transfer status: Successful transfer.
    Transferred 4 items, 254 bytes.
    The Excel worksheet accepts the formula in column D, and changing the value in column C causes column D to recalculate.


    ------------------------------
    Mike Street
    Technical Support Engineer
    Rocket Internal - All Brands
    ------------------------------

    Original Message