[Bots Open Source EDI Translator] Data Search

[Akhilesh Kumar]

Hello Mike, Henk,

We are able to do multiple translations, store values in database etc. Thanks for your guidance.With time we are realizing the power of Bots. We have studied the tables and found tables ta, filereport, report having most of the data.Also we were able to create our own table.

Query:

We need to search data within the file(s) - before and after translation and link them.
How and where do we store and search for the document information such as PO number, Invoice number etc that is other than the Envelop information (UNH, UNZ, ISA, GS).

This is a very often asked question from customers/vendors.  We wish to  provide a query page for such FAQs.

Option:
We created a separate table, stored the values in fields based on map specs, so that we can retrieve them later. We need to tie up this info with, say, the bots dashboard info that is displayed after running the translation (Last run->incoming)

Any idea / guidance on how to proceed with the above?

Thanks
Akhilesh Kumar

[henk-jan ebbers]

On 04/22/2017 12:37 AM, Akhilesh Kumar wrote:
> Hello Mike, Henk,
>
> We are able to do multiple translations, store values in database etc. Thanks for your guidance.With time we are realizing the power of Bots. We have studied the tables and found tables ta,
> filereport, report having most of the data.Also we were able to create our own table.
>

> _Query:
>
> _We need to search data within the file(s) - before and after translation and link them.

> How and where do we store and search for the document information such as PO number, Invoice number etc that is other than the Envelop information (UNH, UNZ, ISA, GS).

in translation do:
inn.ta_info['botskey'] = ponumber
out.ta_info['botskey'] = invoicenumber

these number can be used in searching via menu:select->document
(in the field reference number)

this works like this (for inbound x12 file):

one x12 file -> multiple documents (x12: transactions, eg 10 850's)
this searches on document level (per order)
you can set botskey for incoming document and/or outbound document (typically for ountbound invoice you wsant to search on po-number and invoice number)

hope that helps,
henk-jan

>
> This is a very often asked question from customers/vendors. We wish to provide a query page for such FAQs.
>

> _*Option:*_

> We created a separate table, stored the values in fields based on map specs, so that we can retrieve them later. We need to tie up this info with, say, the bots dashboard info that is displayed
> after running the translation (Last run->incoming)
>
> Any idea / guidance on how to proceed with the above?
>
> Thanks
> Akhilesh Kumar

> --
> You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+u...@googlegroups.com <mailto:botsmail+u...@googlegroups.com>.
> Visit this group at https://groups.google.com/group/botsmail.
> For more options, visit https://groups.google.com/d/optout.

[Akhilesh Kumar]

Hello Henk,

This looks a very short cut solution. Will work on it and let you know.

Thank you so much.

Regards,

Akhilesh

​ Kumar​

To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+unsubscribe@googlegroups.com <mailto:botsmail+unsubscribe@googlegroups.com>.

Visit this group at https://groups.google.com/group/botsmail.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.

To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+unsubscribe@googlegroups.com.

[Akhilesh Kumar]

Hello Henk,

That was an excellent short solution. More ideas coming to our mind now :)

Next Q: Where can I get the details about tables and fields. Looks like we can use the existing tables for our report.

Thanks once again.

Regards,

Akhilesh

​ Kumar​

[henk-jan ebbers]

in the file bots/models.py

though most of the time I just use a SQL browser to see what is in tables.


kind regards,

henk-jan

On 04/24/2017 08:04 PM, Akhilesh Kumar wrote:
> Hello Henk,
>
> That was an excellent short solution. More ideas coming to our mind now :)
> Next Q: Where can I get the details about tables and fields. Looks like we can use the existing tables for our report.
>
> Thanks once again.
>
> Regards,
> Akhilesh
> ​ Kumar​
>

> On Mon, Apr 24, 2017 at 7:29 PM, Akhilesh Kumar <k.akh...@gmail.com <mailto:k.akh...@gmail.com>> wrote:
>
> Hello Henk,
>
> This looks a very short cut solution. Will work on it and let you know.
> Thank you so much.
>
> Regards,
> Akhilesh
> ​ Kumar​
>

> To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+u...@googlegroups.com <mailto:botsmail%2Bunsu...@googlegroups.com>
> <mailto:botsmail+u...@googlegroups.com <mailto:botsmail%2Bunsu...@googlegroups.com>>.
> Visit this group at https://groups.google.com/group/botsmail <https://groups.google.com/group/botsmail>.
> For more options, visit https://groups.google.com/d/optout <https://groups.google.com/d/optout>.

>
>
> --
> You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.

> To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+u...@googlegroups.com <mailto:botsmail%2Bunsu...@googlegroups.com>.
> Visit this group at https://groups.google.com/group/botsmail <https://groups.google.com/group/botsmail>.
> For more options, visit https://groups.google.com/d/optout <https://groups.google.com/d/optout>.

>
>
>
> --
> You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.

> To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+u...@googlegroups.com <mailto:botsmail+u...@googlegroups.com>.

[Akhilesh Kumar]

That gives a good idea.

Using SQL will be better.

Thank you.

Regards,

Akhilesh

            To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+unsubscribe@googlegroups.com <mailto:botsmail%2Bunsubscribe@googlegroups.com>
            <mailto:botsmail+unsubscribe@googlegroups.com <mailto:botsmail%2Bunsubscribe@googlegroups.com>>.

            Visit this group at https://groups.google.com/group/botsmail <https://groups.google.com/group/botsmail>.
            For more options, visit https://groups.google.com/d/optout <https://groups.google.com/d/optout>.


        --         You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.

        To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+unsubscribe@googlegroups.com <mailto:botsmail%2Bunsubscribe@googlegroups.com>.

        Visit this group at https://groups.google.com/group/botsmail <https://groups.google.com/group/botsmail>.
        For more options, visit https://groups.google.com/d/optout <https://groups.google.com/d/optout>.

--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.

To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+unsubscribe@googlegroups.com <mailto:botsmail+unsubscribe@googlegroups.com>.

Visit this group at https://groups.google.com/group/botsmail.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.

To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+unsubscribe@googlegroups.com.