Skip to Content
author's profile photo Former Member
Former Member

how to define CSV to Document

Hello experts,

I'm looking for a scenario "how to define CSV to Document, etc:Order,Quatation..."

Can someone please send me a sample or a link?

I tried to use B1i Guide but the information is not enough

Best Regards

Nir

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2011 at 12:46 PM

    Hi Nir,

    Welcome you post on the forum.

    Which part is not enough for you? Please specify. Have you tried for XML file instead?

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2011 at 02:33 PM

    I'm having a lot of problems with the same scenario.

    I think that more documentation is needed.

    Regards,

    Cristian Rivero

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2011 at 06:10 AM

    Hi

    The guide does not explain how to build the CSV structure and how to read the date from the file,

    Where do I write the header of the document, where do I write the lines?

    I tried xml file and its works fine.

    Regards

    Nir

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2011 at 07:02 PM

    Hi Bastian

    when importing the csv file I receive an error : "Mapping from LocalObjectType CSV to ObjectType failed (please check File Inbound configuration"

    I don't have a clue where to fix it

    Nir

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Nir,

      did you set up the File Inbound configuration according to your object definition of the F.AnySystem?

      I suppose you created an F.AnySystem object for the incoming CSV file. The mapping into B1 object is easier, if you use the same local object ID as in B1 (e.g. 22 for puchase order).

      Please open your created scenario with the Graphical scenario Design (SAP B1iSN Tools -> Development Tools -> Graphical scenarion Design) , select your Bizpackage and the Bizstep.

      In the opening window B1iSN DesignTime-Diagramm check, that every element is displayed in "green", especially:

      - Sender ObjectType

      - FileInbound

      If there is any red or yellow color in it, it means that something of your configuration is missing.

      If the FileInbound is not set up correctly, the inbound file will not be recognized as your defined F.AnySystem SenderObjectType.

      Please focus on FileInbound and maintain:

      - ObjMap (Define own, generate own and save own in exact order)

      - Format : Here you need to specify with kind of file is sent towards B1iSN, e.g.:

      SysType = F.AnySystem

      Inbound Formats = DSV

      Character encoding = ISO-8859-1

      DSV Object Identifier = e.g FieldName, if name of File is equal to field Object Id as defined in SenderObjectType

      DSV Object identifier Parameter = this entry needs to fit, what you defined in ObjMap

      DSV Field Delimitter = ;

      DSV Field Wrapper = "

      As last step you need to map the column names of the CSV file into XML format as described in chapter Inbound Format conversion of B1iSNGuide 04 on page 44 for section DSV.

      Please have a look into the B1iSN guide again, you will find every information needed to tranform an CSV file into F.AnySystem object and into B1 object.

      Best regards

      Bastian

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2011 at 06:36 AM

    Hello Bastian,

    I manage to release the message from filtering but its running into failure,

    can i send my Bizpackage to your E-mail for you to have a look?

    Best Regards

    Nir

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2011 at 01:21 PM

    Hello Bastian,

    Sorry for the delay respond, I was sick.

    I still need your help for solving this issue

    Best Regards

    Nir

    Edited by: Nir Menashe on Sep 14, 2011 3:22 PM

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.