• RELEVANCY SCORE 2.81

    DB:2.81:Standardize A Flat File Format W.R.T Owb 7p




    Hi Pat,

    or anyone,

    Can u help me to standardize a flat file format with respect to OWB?

    I have 15 financial source systems. The client agreed in giving the data in csv format. Now I need to standardize the feed file so that it would be easy for me handle it in OWB. Please note depending on my standardization the client would give me the data and in turn it would be easy for me to handle it OWB External Tables. The records size for a single feed file is 1 million. So my questions are

    1.How should I standardize a date field in flat file?. Please note target date field is default date in Oracle.

    2.How should I standardize an address field? I.e. normally here I have 3 address fields. But I want the output in 1 field. What is the best possible methodology to do this? Or can I handle this issue in OWB front.

    3.How should I standardize a feed file name (generic)?

    4.How should I standardize a feed file folder (generic)? Please note the folder will reside in UNIX environment. The concept is, there would be respective folders in UNIX and the feed files would automatically fall into these respective folders in a fortnight basis. So what should I do to achieve this? I know I have to write a shell script for the automatic process. If so how will I do this and schedule it.

    5.And w.r.t above question, how will I tell OWB to go and fetch the files in those folders. I know it is done while mapping. But my question is Is that the only best way I can achieve it?

    6.If I left anything related to feed file, please tell me?

    Please note that based on my standardization, the client would extract the data and give it to me. So if I standardize the feed file which would be easy for me to handle it in OWB, then that would be a great success. And also note this is for a long run. Minimum 10 years.

    Regards,
    rem.

    DB:2.81:Standardize A Flat File Format W.R.T Owb 7p

    Hi Pat,

    thanks a heap for the answers.

    will get back to u soon with other set of questions.

    regards
    rem.

  • RELEVANCY SCORE 2.73

    DB:2.73:File To Idoc pc





    i face this scenario to upload customer information in XML format from a local flat file to sap r/3 system by using idoc in this scenario i didn't understand the XML format form a local flat file statement what is the meaning of local flat file please send any one solution for this problem

    DB:2.73:File To Idoc pc


    Hi.

    If you read a XML text, the format this file is the same the data type structure developed. Now, if you read a Flat file, in the communication channel type file, you have to use File Content Conversion option.

    Follow the link with a example this funcitionality:

    File Content Conversion:

    http://wiki.sdn.sap.com/wiki/display/XI/FileContentConversion

    Regards.

    Bruno

    Edited by: Bruno Aniceto de Arajo on Sep 10, 2010 9:45 AM

  • RELEVANCY SCORE 2.72

    DB:2.72:Need To Standardize File Names ax




    I have several thousand cdg files that i need to standardize due to my dodgy typing e.g
    should be boney m - brown girl in the ring
    currently is boney m- brown girl in the ring
    is there a quick way to standardize all files to the first layout or do i have to go through them all

    DB:2.72:Need To Standardize File Names ax

    Hi,

    - Copy all the content in a Microsoft Office word document.
    - Press the CTRL and F key (CTRL+F) together to open "find and replace".
    - click "replace" and type type in m- in find what text box.
    - In "replace with" text box type m - and click on "replace all".

    This should work

    Regards

  • RELEVANCY SCORE 2.68

    DB:2.68:Gui_Download Pdf File In Unicode System jf



    Hi Team.

    We are Upgrade to ECC 6.0 with Unicode.

    We are reading a PDF File from Unix directory and use the GUI_DOWNLOAD function to the user can download the file.

    Original we have a WS_DOWLOAD function and all right.

    But with this function the file is incorrect.

    This is the right File

    %PDF-1.3%1 0 obj/Producer(htmldoc 1.8.18 Copyright 1997-2002 Easy Software Products, All Rights Reserved.)/CreationDate(D:20080814090000-0600)endobj 2 0 Obj/Type/Encoding/Differences[ .......

    And in SAP the File Down with this format:

    % P D F - 1 . 3

    %

    1 0 o b j / P r o d u c e r ( h t m l d o c 1 . 8 . 1 8 C o p y r i g h t 1 9 9 7 - 2 0 0 2 E a s y S o f t w a r e P r o d u c t s , A l l R i g h t s R e s e r v e d . ) / C r e a t i o n D a t e ( D : 2 0 0 8 0 8 1 4 0 9 0 0 0 0 - 0 6 0 0 ) e n d o b j

    2 0 o b j / T y p e / E n c o d i n g / D i f f e r e n c e s [ 3 2 / s p a c e / e x c l a m / q u o t e d b l / n u m b e r s i g n / d o l l a r / p e r c e n t / a m p e r s a n d / q u o t e s i n g l e / p a r e n l e f t / p a r e n r i g h t / a s t e r i s k / p l u s / c o m m a / m i n u s / p e r i o d / s l a s h / z e r o / o n e / t w o / t h r e e / f o u r / f i v e / s i x / s e v e n / e i g h t / n i n e / c

    Any body have a Idea of this problem.

    Thanks

    We try change the table to Binary Mode, and the problem continue

    DB:2.68:Gui_Download Pdf File In Unicode System jf


    The problem continue. Our system is SAP ECC 6.0 with UNICODE.

    Ath the moment I'm test with character table and HEX table and the File download to the local PC with errors

    % P D F - 1 . 3

    %

    1 0 o b j / P r o d u c e r ( h t m l d o c 1 . 8 . 1 8 C o p y r i g h t 1 9 9 7 - 2 0 0 2 E a s y S o f t w a r e P r o d u c t s , A l l R i g h t s R e s e r v e d . ) / C r e a t i o n D a t e ( D : 2 0 0 8 0 8 1 4 0 9 0 0 0 0 - 0 6 0 0 ) e n d o b j

    2 0 o b j / T y p e / E n c o d i n g / D i f f e r e n c e s [ 3 2 / s p a c e / e x c l a m / q u o t e d b l / n u m b e r s i g n / d o l l a r / p e r c e n t / a m p e r s a n d / q u o t e s i n g l e / p a r e n l e f t / p a r e n r i g h t / a s t e r i s k / p l u s / c o m m a / m i n u s / p e r i o d / s l a s h / z e r o / o n e / t w o / t h r e e / f o u r / f i v e / s i x / s e v e n / e i g h t / n i n e / c o l o n / s e m i c o l o n / l e s s / e q u a l / g r

    The file download in Binary mode. But continue add a blank character before each character.

    Thanks team

  • RELEVANCY SCORE 2.67

    DB:2.67:Dt Format In Flat File ma



    Hi Friends..iam doing flat file extraction. The date format is like 30/04/2001 0:00

    I loaded up to PSA and to DSO active data table. From then iam getting error while acvtivation.

    Pls advise me what r the steps to correct my data.

    Cheers

    Ravi

    Edited by: Ravi kanth on Oct 28, 2008 6:49 AM

    DB:2.67:Dt Format In Flat File ma


    Hi,

    Instead of using Routines in the transformation to convert the Date format from PSA to ODS, try to convert the Date before you could send it to PSA i.e. in the Data source itself.

    In the Data source, go to the fields and in the field Attributes you can see Conversion routine and FORMAT. In the Conversion Give as PDATE (CONVERSION_EXIT_PDATE_INPUT)

    And in Format as External.

    This will convert the Date from DDMMYYYYto SAP Required Format YYYYMMDD.

    Hope it Helps.

    SVU123

    Edited by: svu123 on Oct 28, 2008 11:04 AM

  • RELEVANCY SCORE 2.61

    DB:2.61:Tv Tuner Card d3



    Any suggestions on buying a TV tuner card. Thinking about getting one and don't know what to look for yet.

    Dimension 8400
    1GB DDR2 SDRAM @ 400MHz
    19-in E193FP Flat Panel Display
    256MB Nvidia GeForce 6800 Graphics Card
    SB Audigy 2ZS, PCI w/Dolby Digital EX, 7.1 Channel
    250 GB Serial ATA Hard Drive
    Windows XP MCE 2005
    Message Edited by Hollis R. on 03-26-2005 08:05 AM

    DB:2.61:Tv Tuner Card d3


    Hauppauge 150MCE or 500MCE. The 150 is a single tuner, the 500 is a double tuner and both come with FM radio. I went with the 150MCE with plans on adding a second one if wanted at a later date. I'm getting very good quality TV with record/pause/playback on my 8400 which is almost exactly the same as yours. If HDTV is your bag then look at the cards from NVIDIA or ATI though I really don't think the HD setups are really worth the extra money at this time. Maybe in a couple more years they will be ready.

    Oh and one other note here is you will need a software DVD Decoder and I highly recommend the one from NVIDIA. You can get it for a 30 day free trial and prices start at $19 up to $50 for the Platinum version. I have the Platinum version myself. You can find the PVR tuner all over the place cheaper than the Hauppauge site, I got mine from amazon.com.

  • RELEVANCY SCORE 2.61

    DB:2.61:Pc 64 Bit Upgrade Kit m7


    Hi
    I have a 1.8ghz cpu.
    I have a 200gb hdd.
    I have a dvd-r/w.
    I havea dvd-rom.
    I have 512mb of ddr.
    I have a fdd

    I need to buy a pc 64 bit pc.
    I need a 15-klnch lcd flat panel monitor.

    I can onely spend total $500.00
    Message Edited by bob5731 on 11-25-2005 01:54 PM

    DB:2.61:Pc 64 Bit Upgrade Kit m7


    http://ecomm.dell.com/dellstore/basket.aspx?c=uscs=19l=ens=dhsitemtype=CFG

    Dimension B110Intel® Celeron® D Processor 325 (2.53 GHz, 533 FSB), Microsoft® Windows® XP Home EditionForget Something?Update Total$579.00Dell Home Customers: Save $100 off this Dell Dimension B110!
    -$100.00Limited Time Offer!View DetailsDell 720 Color PrinterFree Dell Color Printer 720Forget Something?1$0.00Free 720 printer with purchase of select Dell Systems.
    Limited Time Offer!View Details

    Additional Discounts and CouponsFREE GROUND SHIPPING! $24 Handling Charge Applies.Limited Time Offer!View Details

    Coupon EntrySign in to retrieve coupons from your accountOREnter coupon number
    Apply CouponNote: Coupon savings are only applied to items you have added to your cart.

    Sub-total$479.00Shipping Handling $99.00Estimate Shipping Handling and TaxShipping Handling Discount-$75.00Tax $38.34Total Price $541.34

  • RELEVANCY SCORE 2.59

    DB:2.59:Reading Native Format Flat Files ms



    I have a flat file source that was created from Microsoft SQLServer BCP out in a native format. Has anybody tried to read a BCP flat file in this format. If so I would like to know how you did it.Thanks,

    Roger Geiwitz

    DB:2.59:Reading Native Format Flat Files ms


    As i know powercenter won't support to read such file types.

    If you get any solution, please post here.

    Regards,

    Venkat

  • RELEVANCY SCORE 2.59

    DB:2.59:Error With The Data Format In The Txt File, Sending As An Email Attachment k9



    Hi all,

    I have an problem in the data formating in the TXT file while sending as an attachment via an email by using the FM "SO_DOCUMENT_SEND_API1".

    For eg:

    The data in the TXT file is looking like as follows:

    0 0 0 0 2 L O U D S P E A K R O T H E R 3 8 W h i t e 0 0

    0031 L O U D S P E A K R O T H E R 3 8 Black 0 000

    38 L O U D S P E A K R O T H E R 3 8 Brown 0 00040

    L O U D S P E A K R O T H E R 3 8 Brown 0 00042

    .

    .

    .

    and so on

    But it should come as :

    0 0 0 0 2 L O U D S P E A K R O T H E R 3 8 W h i t e

    0 0 0031 L O U D S P E A K R O T H E R 3 8 Black

    0 00038 L O U D S P E A K R O T H E R 3 8 Brown

    0 00040 L O U D S P E A K R O T H E R 3 8 Brown

    All the internal tables are correctly filled.

    The code is as follows:

    gwa_objtxt = 'Please find attached DATA EXTRACT Sheet'.

    append gwa_objtxt to git_objtxt.

    describe table git_objtxt lines gv_cnt.

    clear git_doc_data.

    read table git_objtxt index gv_cnt.

    git_doc_data-doc_size = ( gv_cnt - 1 ) * 255 + strlen( gwa_objtxt ).

    git_doc_data-obj_langu = sy-langu.

    git_doc_data-obj_descr = lv_mtitle.

    append git_doc_data.

    clear git_packing_list.

    refresh git_packing_list.

    git_packing_list-transf_bin = space.

    git_packing_list-head_start = 1.

    git_packing_list-head_num = 0.

    git_packing_list-body_start = 1.

    git_packing_list-body_num = gv_cnt.

    git_packing_list-doc_type = 'RAW'.

    append git_packing_list.

    Clear : gv_cnt.

    Describe table git_objbin lines gv_cnt.

    git_packing_list-transf_bin = 'X'.

    git_packing_list-head_start = 1.

    git_packing_list-head_num = 1.

    git_packing_list-body_start = 1.

    git_packing_list-body_num = gv_cnt.

    git_packing_list-doc_type = 'TXT'.

    git_packing_list-obj_descr = 'ATTACH.TXT'.

    git_packing_list-obj_name = 'book'.

    git_packing_list-doc_size = gv_cnt * 255.

    APPEND git_packing_list.

    clear git_receivers.

    refresh git_receivers.

    git_receivers-receiver = gv_eid.

    git_receivers-rec_type = 'U'.

    append git_receivers.

    *

    CALL FUNCTION 'SO_DOCUMENT_SEND_API1'

    EXPORTING

    DOCUMENT_DATA = git_doc_data

    PUT_IN_OUTBOX = 'X'

    COMMIT_WORK = 'X'

    TABLES

    PACKING_LIST = git_packing_list

    CONTENTS_BIN = git_objbin

    CONTENTS_TXT = git_objtxt

    RECEIVERS = git_receivers

    EXCEPTIONS

    TOO_MANY_RECEIVERS = 1

    DOCUMENT_NOT_SENT = 2

    DOCUMENT_TYPE_NOT_EXIST = 3

    OPERATION_NO_AUTHORIZATION = 4

    PARAMETER_ERROR = 5

    X_ERROR = 6

    ENQUEUE_ERROR = 7

    OTHERS = 8.

    DB:2.59:Error With The Data Format In The Txt File, Sending As An Email Attachment k9


    please give the code of

    contents bin = git_objbin " how this is getting populated.

    0 0 0 0 2 L O U D S P E A K R O T H E R 3 8 W h i t e b0 0/b

    0031 L O U D S P E A K R O T H E R 3 8 Black
    0 000

  • RELEVANCY SCORE 2.57

    DB:2.57:Rss Xml News Feeds (Multiple) - Standardize Date Format zs



    I am developing an application and would like to include a simple RSS news reader with various feeds. Works great except the pubDate from each feed is in a different format. How can I standardize? (ex: M/D/YYYY h:mm:ss)

    For example in each of these the pubDate is formatted differently
    http://feeds.reuters.com/reuters/technologyNews?format=xmlhttp://news.cnet.com/2547-1001_3-0-5.xml
    To build the script I use the File Wizard (Web File), specify URL, and then edit to just get what I need. I imagine it is some kind of date formatting...

    Ex:

    LOAD 'Reuters Technology News' as Source,title,description,link,pubDateFROM [http://feeds.reuters.com/reuters/technologyNews?format=xml] (XmlSimple, Table is [rss/channel/item]);CONCATENATELOAD 'CNET News' as Source,title,description,link,pubDateFROM [http://news.cnet.com/2547-1001_3-0-5.xml] (XmlSimple, Table is [rss/channel/item]);

    DB:2.57:Rss Xml News Feeds (Multiple) - Standardize Date Format zs


    You can go to: Edit script/Web files

    It will be more sample

  • RELEVANCY SCORE 2.56

    DB:2.56:Idoc To Flat File 88



    Hi,

    I want to post the data from SAP R/3 to Non-SAP system. Currently the IDOC will post the data in IDOC format. Is there any possibility to change the IDOC format into the required Non-SAP system format and post the data to Flat Files.

    Regards,

    Kiran

    DB:2.56:Idoc To Flat File 88


    Hi,

    Please visit the following threads

    Re: TCODE TO DOWNLOAD IDOC INTO A FLAT FILE

    Idoc data to flat file

    Hope it helps

    Regards,

    Manish

  • RELEVANCY SCORE 2.56

    DB:2.56:Flat File 88



    In lsmw what does file on PC an file on R/3 Application server means?

    how can wer bring a file on R/3 application server?

    DB:2.56:Flat File 88


    FILE On PC means, file from the ur system, might be c dirircotry or desk top..

    R/3 means. file is from application server(unix) server, AL11.

    using the CG3Y, CG3Z and SXDA_TOOLS, u can upload /download a file into /from applicationn server and presenttation servers.

  • RELEVANCY SCORE 2.55

    DB:2.55:How Join 2 Flat File xk



    Hi everybody,

    how can i join data of two flat file.

    I have flat file A with state name and state cod, the other flat file B has city, state cod, country, country cod.

    How can i join this two flat file on state cod to populate a flat file C?

    Thanks

    Rafael R

    DB:2.55:How Join 2 Flat File xk


    Merge join is the default method.
    If you want to go for pure set based approach you can transfer data onto staging tables and use a t-sql join between them. You can use data flow task and an execute sql task in your package for this.

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    I wanted use just flat fileRafael R

  • RELEVANCY SCORE 2.55

    DB:2.55:How To Download File Into Flat File On Sq01 In Background Process dc



    Hi Experts,

    I have already made a query and I would like to run it in background every night. is it posible for SAP R/3 to save the results after the background process into file format automatically?

    Kind Regards,

    M.

    DB:2.55:How To Download File Into Flat File On Sq01 In Background Process dc


    Hi Experts,

    I have already made a query and I would like to run it in background every night. is it posible for SAP R/3 to save the results after the background process into file format automatically?

    Kind Regards,

    M.

  • RELEVANCY SCORE 2.55

    DB:2.55:Os Me Missing Winspool.Drv fs


    After installing a R/W DVD.

  • RELEVANCY SCORE 2.55

    DB:2.55:Difference B/W Loading A Flat File Made From Excel And Notepad 3k



    Hi

    Is there any difference in Loading a flat file made from MS-Excel and Note Pad. Imean performance or errors etc....

    GSR

    DB:2.55:Difference B/W Loading A Flat File Made From Excel And Notepad 3k


    No different settings. Only u need to have made correct format of notepad file. Correct format can b had by viewing any CSV file as notepad....

  • RELEVANCY SCORE 2.54

    DB:2.54:Dvd Media Question fm



    I have been experimenting with recording my old VHS tapes to DVD. I have a Leadtek TV2000XP Deluxe card and a Panasonic 4523S VCR connected to my system. I am using a Sony DWU14ABK DVD burner and have a Sony DDU1612 DVD-ROM as a slave drive. My system specs are below

    My question is this; I know I have to burn to DVD-R disc to play them on my Panasonic DVD player. Can I copy from a DVD+RW disc to a DVD-R disc and not have any format issues on the DVD-R disc? I tried this once and had problem with a frozen frame at the end of the DVD-R disc. I have had successful DVD-R burns from an image file created on my HD but I would like to use my DVD+RW media to store the media files prior to burn so that I can make sure the file was transferred correctly.

    Thanks to anyone that can help.

    Dell Dimension 4400/ Windows XP Home SP1 with all updates
    1.6Ghz P4w/ int. sound mobo
    768 PC2100 ddr sdram
    15" E151fp flat panel monitor
    Ati Radeon 7500 64 Mb ddr agp card
    20 Gb W.D. master H.D.
    60Gb W.D. secondary H.D.
    Sony DWU 14ABK 4X/4X/8X DVD +/- RW
    Sony DDU 1621 16X DVD-ROM
    Leadtek Winfast TV2000Xp TV tuner card
    Soundblaster Live! 5.1 Digital
    4 port USB 1.1
    4 port firewire PCI adapter card
    Conextant V.92 data/fax modem
    Belkin 4 port powered USB 1.1 hub
    Harmon Kardon speakers
    H.P. 930c Deskjet printer
    H.P. 5400c Scanjet scanner
    Sony TRV 330 Digital 8 HandyCam
    Olympus Camedia D-390 digital camera
    Intel ProPac Web cam
    Palm IIIXE
    Realistic LAB-310 Turntable
    TEAC W-350 Dual Cassette Deck
    Panasonic PV-4523S VCR

  • RELEVANCY SCORE 2.51

    DB:2.51:Upload A File In Al11 Whose Format Is .Csv pd



    Hi,

    I need to create a program that will create a flat file. This flat file will be stored in the unix directory. But my problem is, the flat file should be in the .csv format when uploaded in AL11. How do i do this?

    Thanks,

    Jim

    DB:2.51:Upload A File In Al11 Whose Format Is .Csv pd


    Hi Jim,

    You can do this in 2 says:

    1. Either specify it in your selection screen, where you will be providing the path in the application server.

    Ex. /temp/sample.csv

    2. In the program itself, default the path along with the file name:

    lv_s TYPE rlgrap-filename VALUE '/usr/sap/R3I/DVEBMGS00/work/sample.csv'.

    The CSV file is created as you have given "SEPERATED BY ',' " in the concat stmt.

    This should solve the problem

    PLZ REWARD POINTS IF HELPFUL

  • RELEVANCY SCORE 2.51

    DB:2.51:Ssis 2012 - Using The Flat File Source With Different Number Of Columns In Rows pc


    Hi,
    In SSIS 2012, the 'Flat File Source' supports files that have different number of columns in different rows. That being said, it appears as though when creating the connection, the number of columns defined is obtained from the first row only. For example,
    the following flat file would process correctly:
    Peter,45,a,b,c,d,e
    Lois,f,h,i,j
    Brian,7,k,l,m,n,o
    Chris,q,r,s,t
    Meg,15,u,v,x,y
    Stewie,2,z,b,c
    because each of these rows have the same or less number of columns than the first row. However this file doesnt seem to process correctly:
    Peter,45,a,b,c,d,e
    Lois,40,f,g,h,i,j,dd
    Brian,7,k,l,m,n,o
    Chris,16,p,q,r,s,t,aa,ab
    Meg,15,u,v,w,x,y
    Stewie,2,z,a,b,c,d
    because lines 2 and 4 have more columns that the first row. The package does not error, its just the last column will contain 'jdd' for row 2 and 'taaab' for row 4.
    Is there a configuration setting that I missed that will handle this automatically or will I need to write a custom source component to handle this? I am able to determine the maximum number of columns in any row and add the columns in the Flat File Connection
    Manager manually.

    DB:2.51:Ssis 2012 - Using The Flat File Source With Different Number Of Columns In Rows pc

    Hi James,
    Please have a look into the following article. which explain the custom way to import the dynamic columns:

    http://www.timmitchell.net/post/2013/01/14/ragged-flat-file-processing-in-ssis/

    regards,
    Zaim Raza

  • RELEVANCY SCORE 2.51

    DB:2.51:Idoc To Flat File And Xml ( Need Both The Output) 7f



    Hi ,

    My Scenario is IDOC to File .

    I need o/p in 2 format . ie, 1) Flat File 2 ) XML file

    I have a plan to go with Interface determination , 2 IM and what shd be the condition ?

    or Else 2 Receiver detmination but condition ?

    How to slove this ?

    Need the Output from Idoc in 2 format ( Flat file and XML file )

    Any Blog , Thread ...Tips...etc

    Regards,

    Jude

    DB:2.51:Idoc To Flat File And Xml ( Need Both The Output) 7f


    Hi Jude,

    Do like this:

    1. Create two inbound Service Interface (with the same target Message Type)

    2. Create separate Operation mapping with the above service interfaces as target (with the same source service interface)

    3. Create Interface Determination and include these two operation mapping (without any condition)

    4. Create 2 receiver agreement (with two separate communication channel) for each of the target service Inetrface. In one channel use content conversion and the other one will give you normal XML output

    Regards

    Suraj

  • RELEVANCY SCORE 2.51

    DB:2.51:Diff B/W Joiner And Lookup T/R df



    Diff b/w joiner and lookup t/r

    DB:2.51:Diff B/W Joiner And Lookup T/R df


    The list is almost complete, just one other that I can com up with:

    99) joiner can only match on "=", lookup can use non-equi operators. example: do "between" on a timespan (we use that a lot)

  • RELEVANCY SCORE 2.50

    DB:2.50:Uploading Metadata Using A Flat File s7


    Dear All,

    Some one plz help me, how to upload the metadata using a flat file in hyperion planning.

    Thanks,
    Naresh R.

    DB:2.50:Uploading Metadata Using A Flat File s7

    John, I think you are just being modest. I used your blog for OLU and it helped me a lot.

    Naresh,

    In case you are interested, here is the link: http://john-goodwin.blogspot.com/2008/08/time-to-look-in-bin.html

    Cheers,
    A

  • RELEVANCY SCORE 2.50

    DB:2.50:How To Download Hierarchies Into Flat File From R/3 Itself mj



    Experts is there a way how we can download hierarchies directly from r/3 into flat file.

    DB:2.50:How To Download Hierarchies Into Flat File From R/3 Itself mj


    Hi Rao,

    What i know is that there isn't a standard way to download hierarchies, because each one of them works in a different way (different tables). What you can do is to write an abap program to download the hierarchy into a text file with the required format to upload it to BW.

    Regards,

    Diego

  • RELEVANCY SCORE 2.50

    DB:2.50:Selecting A Router/Setting Up A Network B/W Dell Inspiron I1150 & Dell Intel(R) Pentium(R) fk


  • RELEVANCY SCORE 2.50

    DB:2.50:Flat File Format dx



    hi gurus......

    Basically there r 3 types of flat file format

    ASC

    DAT

    BIN

    am I rite???

    what is the difference between these formats?

    DB:2.50:Flat File Format dx


    Hi,

    This is from the documentation available in GUI_UPLOAD func.module:

    'BIN'.

    The system reads a binary representation of the internal table from the

    file. The data is neither converted nor interpreted in this case.

    Usually, reasonable results are obtained only if the internal table

    consists of a single column of type 'X'.

    'DAT'

    The components of the internal table are filled from the file. If the

    table contains several columns, the entries in the file must be

    separated by tabs. No conversion exits are performed. [ eg: .TXT with tab delimited ]

    The following applies for the different data types:

    I or N or P or F

    The numbers must be formatted according to the decimal representation

    defined in the user settings.

    D

    The date must be formatted according to the date format defined in the

    user settings.

    T

    The time must be formatted as hh:mm:ss.

    'ASC'.

    The components of the internal table are filled from the file. Only

    data types with fixed length are allowed. The data must be contained

    in the file in its full length. [ eg: Like .TXT or .CSV files ]

    Regards,

    Subramanian

  • RELEVANCY SCORE 2.50

    DB:2.50:Need Help In Importing Flat File k7


    Hi All,
    I have to import flat file. Can someone help me with a query [t-sql]which can import the file - which could be in either UNIX / WINDOWS format
    when i say UNIX format - row delimiter ll be just {LF}
    and WINDOWS format - {CR}{LF}

    thanks
    R.Manjunathan

    DB:2.50:Need Help In Importing Flat File k7

    Although you cannot specify column names in BULK INSERT you can create a view containing only those columns you want to insert from the table, and BULK INSERT into that view.

  • RELEVANCY SCORE 2.49

    DB:2.49:Problems Importing A Datetime From A Flat File mk


    I have a flat file with a datetime field as follows
     
    12419,1,'T','P',229.72,2,'N',2004/may/05 19:47:42.54600112419,1,'T','R',605.38,76,'N',2004/may/05 19:47:42.54600012419,2,'T','P',110.49,2,'N',2004/may/05 19:47:42.54600312419,2,'T','R',215.53,11,'N',2004/may/05 19:47:42.54600212419,3,'T','F',9.29,1,'N',2004/may/05 19:47:42.54600512419,3,'T','R',696,38,'N',2004/may/05 19:47:42.546004
     
    I can NOT get last field i.e. the date time field to import into SQL werver 2005 using import wizard.
    I can manually enter the value in the table so I know it can handle data in the format it is in.. (table field is date time) but I cant get import wizard to read the file and bring in the data.. It bombs at coloumn 7... which is the date field.. It works fine if I delete the milisecond portion i.e. anything after the dot but I need to keep that information.
     
    Any help will be greatly appreciated.

    DB:2.49:Problems Importing A Datetime From A Flat File mk

    Add to that that it's potentially incorrect, because he's using an ambiguous date format that's highly dependent on the regional settings of the machine.
    But thanks for trying to help - brush up a little on SSIS, and keep coming back!

    Talk to me now on

  • RELEVANCY SCORE 2.49

    DB:2.49:Creating A Flat File In The Idoc Format 73



    Hi everybody,

    Need help.....urgently. Can somebody please tell me how to create a flat file in the IDOC format? I am creating a bill of lading/Documentary payments (EDI 858) and can't figure out a way to write the data generate through the report in a flat file in IDOC format. My deadline is right around the corner and I need help.

    Thanks,

    M

    DB:2.49:Creating A Flat File In The Idoc Format 73


    Hi Minal

    I've just given a short look on the discussion. But why do not use an XML port to convert the IDoc to an XML file stored at the application server. You can then read it and store at some frontend or send it directly. I guess this may be more appropriate for your partner to parse for the web use.

    Regards

    *--Serdar a href="https://www.sdn.sap.com:443http://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.sdn.businesscard.sdnbusinesscard?u=qbk%2bsag%2bjiw%3d"[ BC ]/a

  • RELEVANCY SCORE 2.48

    DB:2.48:Translating Excel Query Into Flat File(.Csv) pz


    Hi,I have a requirement where i need the Excel Queries to be displayed in Flat file(.CSV) format. To be more clear i have an excel query but my client requires this query to be displayed in a Flat file format. Can someone explain me how i can acheive this.Thanks

    DB:2.48:Translating Excel Query Into Flat File(.Csv) pz

    Actually, transaction RSCRM_BAPI will do exactly this, it will dump query results into a table or CSV file.

  • RELEVANCY SCORE 2.48

    DB:2.48:Date Format In Flat File Of Bdc m1



    Hi Folks,

    In BDC I have a flat file which has to be uploaded from a flat file and 4 users are using each of one has their date format.

    so inorder to get their required date format what i need to do .

    DB:2.48:Date Format In Flat File Of Bdc m1


    Hi

    You before moving the field to table use conversion_exit_input.

    this will convert accordingly the user settings

    Regards

    Shiva

  • RELEVANCY SCORE 2.48

    DB:2.48:Date Format In Flat Files 8s



    Hello Experts,

    I have a flat while with date format as

    9/26/2005, will it create any problem while loading this flat file data.

    Bw takes the data format as yyyymmdd, if so how do i conver the mm/dd/yyyy to the bw format before loading the data from flat files.

    Thank You,

    John

    DB:2.48:Date Format In Flat Files 8s


    Hi

    U can go in the transfer routine, click on function, choose date functions, then select function 0DATE, give the date format u desire, and then load data.

    hope this helps.

    assign the points, if it helps.

  • RELEVANCY SCORE 2.48

    DB:2.48:How Do We Write Header And Item Data To A File From Program? mx



    I need to write data from R/3 to flat file.It is in format of level1 - header

    level2 - items

    DB:2.48:How Do We Write Header And Item Data To A File From Program? mx


    It depends on how you wish to transfer the data...lets say want header data and than the corresponding item data.

    loop at iheader.

    move iheader data to itext.

    append itext.

    clear idetail.

    loop at idetail where key = iheader-key.

    move idetail data to itext.

    append itext.

    endloop.

    endloop.

    call function 'gui_download'

    exporting

    filename = 'C:\test.txt'

    tables

    data_tab = itext.

  • RELEVANCY SCORE 2.48

    DB:2.48:Sql Server 2005 Bcp And The X Option 13


    Hi,Please tell me if I am missing something.  I am tryin to use bcp to output a format file in XML format for a table.  Here is my syntax:
    declare @Query varchar(800)
    set @Query = 'bcp dbname..NameAndAddress format nul -c -f c:\bcp_test\testbcp.xml -x -t -T -Sservername'
    exec master..xp_cmdshell @QueryAnd here is the error that I am receiving:bcp:  unknown option xusage: bcp {dbtable | query} {in | out | queryout | format} datafile  [-m maxerrors]            [-f formatfile]          [-e errfile]  [-F firstrow]             [-L lastrow]             [-b batchsize]  [-n native type]          [-c character type]      [-w wide character type]  [-N keep non-text native] [-V file format version] [-q quoted identifier]  [-C code page specifier]  [-t field terminator]    [-r row terminator]  [-i inputfile]            [-o outfile]             [-a packetsize]  [-S server name]          [-U username]            [-P password]  [-T trusted connection]   [-v version]             [-R regional enable]  [-k keep null values]     [-E keep identity values]  [-h load hints]NULLThe documentation says that -x is an option, but I don't see it in the above list.  So, my question is how do I get the XML format file output?TIA

    DB:2.48:Sql Server 2005 Bcp And The X Option 13

    You're very welcome!  Glad to help.Aaron Alton | thehobt.blogspot.com

  • RELEVANCY SCORE 2.48

    DB:2.48:Help!!! How Do I Print Out A 2d Array? xk


    Say, I have
    static int[][] board = { {p,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r},
    {n,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r},
    {n,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r},
    {n,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r},
    {n,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r},
    {n,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r},
    {n,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r},
    {n,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r},
    {n,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r},
    {n,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r},
    {n,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r},
    {n,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r},
    {n,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r},
    {n,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r} };

    where,

    private static int w = 0; //Block
    private static int f = 1; //Movable Block
    private static int c = 2; //bomb
    private static int n = 3; //nothing
    private static int p = 4;
    private static int r =(int) Math.random()%4;

    How do I print out this 2 d array so it looks like

    * * * * * * * * * * * * * * * * * *
    * * * * * * * * * * * * * * * * * *
    * * * * * * * * * * * * * * * * * *
    * * * * * * * * * * * * * * * * * *
    * * * * * * * * * * * * * * * * * *
    * * * * * * * * * * * * * * * * * *
    * * * * * * * * * * * * * * * * * *
    * * * * * * * * * * * * * * * * * *
    * * * * * * * * * * * * * * * * * *
    * * * * * * * * * * * * * * * * * *
    * * * * * * * * * * * * * * * * * *
    * * * * * * * * * * * * * * * * * *
    * * * * * * * * * * * * * * * * * *
    * * * * * * * * * * * * * * * * * *

    Where all these stars are numbers...

    DB:2.48:Help!!! How Do I Print Out A 2d Array? xk

    for (int i = 0; i board.length; i ++)
    {
    for (int j = 0; j board.length; j ++)
    {
    System.out.print (((j == 0) ? "" : ", ") + board[i][j]);
    }
    System.out.println ();
    }

    I think your random generator is not quite correct as the seed will always be the same causing you to have same random number. try to work that out...

  • RELEVANCY SCORE 2.47

    DB:2.47:Bdc For Me21n (Flat File Format) p1



    Hello,

    I have to write a BDC for ME21N(stock transfer).... Someone pls give me the format of flat file... we need separate files for header and items or only one file is enough??? pls someone send me the format and code......

    my email id is juztmaya@yahoo.com

    Thanks in advance...

    Regards,

    Maya.

    DB:2.47:Bdc For Me21n (Flat File Format) p1


    Thank you Anji for ur reply...

    It wud b great if u send me the flat file format.....pls send it to my email id - juztmaya@yahoo.com..

    Regards,

    Maya.

  • RELEVANCY SCORE 2.47

    DB:2.47:Flat File Schema Issue mc


    Below is my sample format for my flat file.For example if you consider that as a flat file.Its just a sample format.H,B,D,T are tag identifers and the flat file is positional that is just the format of one transcation i will be having multiple transactions
    of that kind in the flat file.how can i create a schema for the flat file which look likes the below one
    HRecord1Record2
    BRecord1Record2Record3
    DRecord1Record2Record3Record4
    DRecord1Record2Record3Record4
    DRecord1Record2Record3Record4
    BRecord1Record2Record3
    DRecord1Record2Record3Record4
    DRecord1Record2Record3Record4
    DRecord1Record2Record3Record4
    TRecord1
    Thankssri

    DB:2.47:Flat File Schema Issue mc

    Sri sent the sample data to my MSDN email and I provided a basic solution (snapshot below). The data included an interchange of his description above, so the Root element Group Max Occurs is set to unbounded. The RepeatingRecord element
    is unbounded with BRecord min/max of 1 and DRecord min = 1, max=unbounded. The tags were set to 'H', 'B', 'D' and 'T', and I only included a single field element under each record which parsed the entire contents of each record into the corresponding
    field. The field contents also included the tag.

    David Downing... If this answers your question, please Mark as the Answer. If this post is helpful, please vote as helpful.

  • RELEVANCY SCORE 2.47

    DB:2.47:Re: Flat Pattern Error W/ Thicken 7k



    I'm trying to thicken a surface, I'm able to get it to thicken but it errors when I try to flat pattern it. Can somebody look at my file and maybe let me know what I'm doing wrong? In the pic below circled in blue is the part I can thicken and flat pattern, in red I can thicken but not flat pattern.

    And yes, I do know I can't flat pattern and thicken both at once, this is just my skeleton model thats easiest to attach and have a working and nonworking example.




    Thanks,Aaron Schlaack---------------------------------------------------------------------------------Autodesk Inventor 2015Dell Windows 8.1 64 bit Intel(R) Xeon(R) @ 3.50GHz 32GB RamMSI Windows 8.1 64 bit Core i7-4700HQ @ 2.40GHz 16GB Ram

    DB:2.47:Re: Flat Pattern Error W/ Thicken 7k


    Hi!

    If the method resulted at the first time, why not repeat it??!!




    Regards.CarlosCAutodesk Inventor 2014 Certified ProfessionalAutodesk Factory Design Suite Ultimate 2015Windows 7 64Bit

  • RELEVANCY SCORE 2.47

    DB:2.47:Blue Screen Error Bccode Fe In Windows 7..Os Version_6.1.7600.2.0.0.256.1__Bugcode_Usb_Driver Error m8


    Original title:Blue screen error in windows 7..OS Version:_6.1.7600.2.0.0.256.1__BUGCODE_USB_DRIVER error

    The below are the error message about the problem and i am getting the blue screen while system is shutting down...
    I am getting BUGCODE_USB_DRIVER error message when the system shutdown and not able to properly shutdown my laptop...
    Problem signature:
    Problem Event Name:BlueScreen
    OS Version:6.1.7600.2.0.0.256.1
    Locale ID:16393
    Additional information about the problem:
    BCCode:fe
    BCP1:0000000000000004
    BCP2:FFFFFA800429C170
    BCP3:FFFFFA800A7B70C0
    BCP4:FFFFFA8006E62C00
    OS Version:6_1_7600
    Service Pack:0_0
    Product:256_1
    Files that help describe the problem:
    C:\Windows\Minidump\020411-53102-01.dmp
    C:\Users\fairose\AppData\Local\Temp\WER-72509-0.sysdata.xml
    Read our privacy statement online:

    http://go.microsoft.com/fwlink/?linkid=104288clcid=0x0409
    If the online privacy statement is not available, please read our privacy statement offline:
    C:\Windows\system32\en-US\erofflps.txt

    The minidump file shows the following:-

    Êb úË[J Ø 0É€øÿÿ 3¯ ‘Ê[J ! \ S y s t e m R o o t \ s y s t e m 3 2 \ n t
    o s k r n l . e x e \ S y s t e m R o o t \ s y s t e m 3 2 \ h a l . d l l \ S y s t e m R o o t \ s y s t e m 3 2 \ k d c o m . d l l . \ S y s t e m R o o t \ s y s t e m 3 2 \ m c u p d a t e _ G e n u i n e I n t e l . d l l
    \ S y s t e m R o o t \ s y s t e m 3 2 \ P S H E D . d l l \ S y s t e m R o o t \ s y s t e m 3 2 \ C L F S . S Y S \ S y s t e m R o o t \ s y s t e m 3 2 \ C I . d l l ) \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s
    \ W d f 0 1 0 0 0 . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ W D F L D R . S Y S % \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ A C P I . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S
    \ W M I L I B . S Y S ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ m s i s a d r v . s y s $ \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ p c i . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S
    \ v d r v r o o t . s y s ( \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ p a r t m g r . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ c o m p b a t t . s y s \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I
    V E R S \ B A T T C . S Y S ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ v o l m g r . s y s ( \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ v o l m g r x . s y s ) \ S y s t e m R o o t \ S y s t e m 3 2
    \ d r i v e r s \ m o u n t m g r . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ i a S t o r . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ a m d x a t a . s y s ' \ S y s t e m R o o t \ s y s t
    e m 3 2 \ d r i v e r s \ f l t m g r . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ f i l e i n f o . s y s ) \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ P x H l p a 6 4 . s y s % \ S y s t e m R o o t \
    S y s t e m 3 2 \ D r i v e r s \ N t f s . s y s \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ m s r p c . s y s ' \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ k s e c d d . s y s $ \ S y s t e m R o o t \
    S y s t e m 3 2 \ D r i v e r s \ c n g . s y s $ \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ p c w . s y s ' \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ F s _ R e c . s y s % \ S y s t e m R o o t \ s y s t
    e m 3 2 \ d r i v e r s \ n d i s . s y s \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ N E T I O . S Y S ( \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ k s e c p k g . s y s \ S y s t e m R o o t \ S y s t
    e m 3 2 \ d r i v e r s \ t c p i p . s y s ) \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ f w p k c l n t . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ v o l s n a p . s y s \ S y s t e m R o o t \
    S y s t e m 3 2 \ D r i v e r s \ s p l d r . s y s ) \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ r d y b o o s t . s y s $ \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ m u p . s y s ) \ S y s t e m R o o t \
    S y s t e m 3 2 \ d r i v e r s \ h w p o l i c y . s y s ' \ S y s t e m R o o t \ S y s t e m 3 2 \ D R I V E R S \ f v e v o l . s y s % \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ d i s k . s y s ) \ S y s t e m R o o t \
    s y s t e m 3 2 \ D R I V E R S \ C L A S S P N P . S Y S \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ c d r o m . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ M p F i l t e r . s y s % \ S y s t e m R
    o o t \ S y s t e m 3 2 \ D r i v e r s \ N u l l . S Y S % \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ B e e p . S Y S $ \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ v g a . s y s ) \ S y s t e m R o o t \ S y s t
    e m 3 2 \ d r i v e r s \ V I D E O P R T . S Y S ) \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ w a t c h d o g . s y s ' \ S y s t e m R o o t \ S y s t e m 3 2 \ D R I V E R S \ R D P C D D . s y s ) \ S y s t e m R o o t \
    s y s t e m 3 2 \ d r i v e r s \ r d p e n c d d . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ r d p r e f m p . s y s % \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ M s f s . S Y S % \ S y s t e m R o o t \
    S y s t e m 3 2 \ D r i v e r s \ N p f s . S Y S $ \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ t d x . s y s $ \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ T D I . S Y S \ S y s t e m R o o t \ S y s t e m 3 2
    \ D R I V E R S \ n e t b t . s y s $ \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ a f d . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ w f p l w f . s y s \ S y s t e m R o o t \ s y s t e m 3 2
    \ D R I V E R S \ p a c e r . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ v w i f i f l t . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ n e t b i o s . s y s ' \ S y s t e m R o o t \ s y s t
    e m 3 2 \ D R I V E R S \ w a n a r p . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ t e r m d d . s y s \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ r d b s s . s y s ) \ S y s t e m R o o t \
    s y s t e m 3 2 \ d r i v e r s \ n s i p r o x y . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ m s s m b i o s . s y s ) \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ d i s c a c h e . s y s % \ S y s t e m R
    o o t \ S y s t e m 3 2 \ D r i v e r s \ d f s c . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ b l b d r i v e . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ t u n n e l . s y s ) \ S y s t e m R
    o o t \ s y s t e m 3 2 \ D R I V E R S \ i g d k m d 6 4 . s y s ( \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ d x g k r n l . s y s ( \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ d x g m m s 1 . s y s ( \ S y s
    t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ H E C I x 6 4 . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ u s b e h c i . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ U S B P O R T . S Y S )
    \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ H D A u d B u s . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ N E T w 5 s 6 4 . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ v w i f i b u s . s y
    s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ L 1 C 6 2 x 6 4 . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ i 8 0 4 2 p r t . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ k b d c l a s
    s . s y s \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ S y n T P . s y s % \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ U S B D . S Y S ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ m o u c l a s
    s . s y s \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ I m p c d . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ i n t e l p p m . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ w m i
    a c p i . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ C m B a t t . s y s - \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ C o m p o s i t e B u s . s y s # \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I
    V E R S \ k s . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ C t C l s F l t . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ k s t h u n k . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I
    V E R S \ A g i l e V p n . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ r a s l 2 t p . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ n d i s t a p i . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2
    \ D R I V E R S \ n d i s w a n . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ r a s p p p o e . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ r a s p p t p . s y s ( \ S y s t e m R o o t \ s y s t
    e m 3 2 \ D R I V E R S \ r a s s s t p . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ r d p b u s . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ s w e n u m . s y s \ S y s t e m R o o t \
    s y s t e m 3 2 \ D R I V E R S \ u m b u s . s y s \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ W D K M D . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ u s b h u b . s y s ( \ S y s t e m R
    o o t \ S y s t e m 3 2 \ D r i v e r s \ N D P r o x y . S Y S ) \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ R T K V H D 6 4 . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ p o r t c l s . s y s % \ S y s
    t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ d r m k . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ I n t c D A u d . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ u s b c c g p . s y s \ S y s t
    e m R o o t \ S y s t e m 3 2 \ w i n 3 2 k . s y s \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ D x a p i . s y s ) \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ u s b v i d e o . s y s ' \ S y s t e m R o
    o t \ s y s t e m 3 2 \ D R I V E R S \ h i d u s b . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ H I D C L A S S . S Y S ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ H I D P A R S E . S Y S ' \ S y s t
    e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ k b d h i d . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ m o u h i d . s y s ) \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ c r a s h d m p . s y s , \
    S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ d u m p _ i a S t o r . s y s - \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ d u m p _ d u m p f v e . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ m o n i
    t o r . s y s \ S y s t e m R o o t \ S y s t e m 3 2 \ T S D D D . d l l \ S y s t e m R o o t \ S y s t e m 3 2 \ c d d . d l l \ S y s t e m R o o t \ S y s t e m 3 2 \ A T M F D . D L L \ S y s t e m R o o t \ s y s
    t e m 3 2 \ d r i v e r s \ l u a f v . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ W u d f P f . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ l l t d i o . s y s \ S y s t e m R o o t
    \ s y s t e m 3 2 \ D R I V E R S \ n w i f i . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ n d i s u i o . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ r s p n d r . s y s % \ S y s t e m
    R o o t \ s y s t e m 3 2 \ d r i v e r s \ H T T P . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ b o w s e r . s y s ' \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ m p s d r v . s y s ' \ S y s t e m
    R o o t \ s y s t e m 3 2 \ D R I V E R S \ m r x s m b . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ m r x s m b 1 0 . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ m r x s m b 2 0 . s y s ( \ S y
    s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ v w i f i m p . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ p e a u t h . s y s ' \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ s e c d r v . S Y S '
    \ S y s t e m R o o t \ S y s t e m 3 2 \ D R I V E R S \ s r v n e t . s y s ) \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ t c p i p r e g . s y s % \ S y s t e m R o o t \ S y s t e m 3 2 \ D R I V E R S \ s r v 2 . s y s $
    \ S y s t e m R o o t \ S y s t e m 3 2 \ D R I V E R S \ s r v . s y s ( \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ f a s t f a t . S Y S ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ M p N W M o n . s y s *
    \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ N i s D r v W F P . s y s , \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ p c c s m c f d x 6 4 . s y s * \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ c c d
    c m b x 6 4 . s y s + \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ c c d c m b o x 6 4 . s y s 4 \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ u s b s e r _ l o w e r f l t j x 6 4 . s y s ' \ S y s t e m R
    o o t \ s y s t e m 3 2 \ d r i v e r s \ u s b s e r . s y s 3 \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ u s b s e r _ l o w e r f l t x 6 4 . s y s \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ m o d e m . s
    y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ a s y n c m a c . s y s \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ M S P Q M . s y s \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ f a c
    a p . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ S T R E A M . S Y S ) \ S y s t e m R o o t \ s y s t e m 3 2 \ d r i v e r s \ M S P C L O C K . s y s à’ øÿÿ€ œ ì øÿÿ! è øÿÿ ! €¨ÿ øÿÿ$! À)€úÿÿ$"
    p{
    €úÿÿ$2 æ€úÿÿ$B `ü øÿÿ$R `ø øÿÿ(R t0 øÿÿÈR h0 øÿÿÌR °‹€úÿÿÐR è ¼‹€úÿÿ¸T è ÈO
    €úÿÿV ¨Å øÿÿv

    Please help me on this...
    Thanks in advance....

    DB:2.47:Blue Screen Error Bccode Fe In Windows 7..Os Version_6.1.7600.2.0.0.256.1__Bugcode_Usb_Driver Error m8

    Also, it may help to look at the minidump files from the crashes with a debugger.
    Can you zip up the minidump files in the C:\Windows\Minidump folder and make available (provide link) via Windows Live SkyDrive or similar site?
    The following link has information on using Windows Live SkyDrive:
    http://social.technet.microsoft.com/Forums/en-US/w7itproui/thread/4fc10639-02db-4665-993a-08d865088d65
    If you have problems zipping the minidump files copy the minidump files to another location such as a folder on the Desktop

  • RELEVANCY SCORE 2.46

    DB:2.46:Bcp 8k


    exec

    xp_cmdshell'bcp
    select top 5 * from sw_tokenDeletionc:\TestMail\filename.txt -c -U sa -P temp123 -S (172.25.11.20)'

    Sir It is showing result

    usage: bcp {dbtable | query} {in | out | queryout | format} datafile
    [-m maxerrors] [-f formatfile] [-e errfile]
    [-F firstrow] [-L lastrow] [-b batchsize]
    [-n native type] [-c character type] [-w wide character type]
    [-N keep non-text native] [-V file format version] [-q quoted identifier]
    [-C code page specifier] [-t field terminator] [-r row terminator]
    [-i inputfile] [-o outfile] [-a packetsize]
    [-S server name] [-U username] [-P password]
    [-T trusted connection] [-v version] [-R regional enable]
    [-k keep null values] [-E keep identity values]
    [-h load hints] [-x generate xml format file]
    NULL
    (12 row(s) affected)
    Sir pls reply soon .........................(`_`)

    DB:2.46:Bcp 8k

    Hi,
    this may work
    exec xp_cmdshell 'bcp select top 5 * from sw_tokenDeletion queryout c:\TestMail\filename.txt -c -U sa -P temp123 -S 172.25.11.20'

  • RELEVANCY SCORE 2.46

    DB:2.46:Dell Flat Screen Monitor j3


    I have a dell dimenion 2400 w flat panal vidio image on screen slants

    DB:2.46:Dell Flat Screen Monitor j3

    I have a dell dimenion 2400 w flat panal vidio image on screen slants

  • RELEVANCY SCORE 2.46

    DB:2.46:Invoke Msiexec On Remote Machine And Get 0x80070005 Error pk


    Hi everyone,
    I'm trying to do a script in powershell that install msi files on remote machines in the same
    domain. When i use Invoke-Command to run simple cmdlets on remote machine everything works fine, but when i try to invoke msiexec i've got this error from msi log
    MSI
    (c) (50:C4) [10:50:30:962]: Failed to connect to server. Error: 0x80070005
    function in InstallFunction.ps1 file

    function ManageMsi {
    Param (
    [Parameter(Mandatory=$true)]
    [string] $msiFile,

    [Parameter(Mandatory=$true)]
    [MsiOperation] $operation,

    [string] $TARGETVDIR,
    [string] $TARGETAPPPOOL = DefaultAppPoll ,
    [string] $logPath = $msiFile .txt

    )
    begin {}

    process {
    try {
    if($operation -eq [MsiOperation]::Install)
    {
    Start-Process -FilePath $env:systemroot\system32\msiexec.exe `
    -ArgumentList /i `$msifile` /qn /L* `$logPath` -Wait
    }
    if($operation -eq [MsiOperation]::Uninstall)
    {
    Start-Process -FilePath $env:systemroot\system32\msiexec.exe `
    -ArgumentList /x `$msifile` /qn /L* `$logPath` -Wait
    }
    if($operation -eq [MsiOperation]::InstallService)
    {
    Start-Process -FilePath $env:systemroot\system32\msiexec.exe `
    -ArgumentList /i `$msifile` TARGETVDIR=`$TARGETVDIR` TARGETAPPPOOL=`$TARGETAPPPOOL` /qn /L* `$logPath` -Wait
    }
    }
    catch {
    Write-Error $_.Exception.Message.ToString()
    }
    }
    end {}

    And code in main script
    Invoke-Command -ScriptBlock {
    . InstallFunctions.ps1
    ManageMsi -msiFile $msiFile -operation InstallService -TARGETVDIR $vdir } -ComputerName $servName
    Function
    ManageMsi work fine on local machine.
    When
    i use
    $session = New-PSSession -ComputerName $servName
    Enter-PSSession $sesion

    then in remote machine
    msiexec /i SomeSetup.msi TARGETVDIR=SomeVDir TARGETAPPPOOL=DefaultAppPoll /qn /L* logMsiTest.txt

    I've got this error (sorry about format above)

    T h e W i n d o w s I n s t a l l e r S e r v i c e c o u l d n o t b e a c c e s s e d . T h i s c a n o c c u r i f t h e W i n d o w s I n s t a l l e r i s n o t c o r r e c t l y i n s t a l l e d . C o n t a c t y o u r s u p p o r t p e r s o n n e l
    f o r a s s i s t a n c e .

    DB:2.46:Invoke Msiexec On Remote Machine And Get 0x80070005 Error pk

    Everything work ok on machines with win2k8. Including invoking the msiexec.exe command.

  • RELEVANCY SCORE 2.46

    DB:2.46:Bpel - Reading Xml And Writing To Edi Format Flat File k3


    Hi,I need to read an XML file transaction data and write into the EDI format flat file. Could you please suggest any best practice for the same. Is that is possible simply using FTP adapter?I got some inputs regarding B2B but looks to be complex. Can I get a simple example for reading xml file and writing into the EDI format flat file.Kind Regards,

    DB:2.46:Bpel - Reading Xml And Writing To Edi Format Flat File k3

    This can be done via File Adapter.. If you have a input XML file, that means, you can also generate the input XSD schema for that and read the file data.. In order to convert that input data into the EDI format, you must have EDI Native XSD schema to output... or you'll have make one, if it is not available OOTB.

  • RELEVANCY SCORE 2.46

    DB:2.46:Create Xml Using Stored Procedure Or Sql Jobs kf



    Hi,
    I need to create XML using Stored Procedure or SQL Jobs
    I have a query which returns us a scalar value which is in XML Format i need to save this file in XML format at any local path
    EXEC xp_cmdshell
    'bcp select top 1 1 from spt_values
    queryout authors.txt'

    output
    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    usage: bcp {dbtable | query} {in | out | queryout | format} datafile
    [-m maxerrors] [-f formatfile] [-e errfile]
    [-F firstrow] [-L lastrow] [-b batchsize]
    [-n native type] [-c character type] [-w wide character type]
    [-N keep non-text native] [-V file format version] [-q quoted identifier]
    [-C code page specifier] [-t field terminator] [-r row terminator]
    [-i inputfile] [-o outfile] [-a packetsize]
    [-S server name] [-U username] [-P password]
    [-T trusted connection] [-v version] [-R regional enable]
    [-k keep null values] [-E keep identity values]
    [-h load hints] [-x generate xml format file]
    NULL

    Thanks.

    DB:2.46:Create Xml Using Stored Procedure Or Sql Jobs kf

    I forgot to mention earlier, for this task you are doing it would be better to use a client application or SSIS package. The query you are using would be source to application or SSIS which would save the XML to file.
    Hi Dean Savović,
    You are right i create a application for saving XML file, I find that this way is secure, if we create the XML file using SQL it would be risk for us because we disable some security features with our database as listed below
    --GO
    --RECONFIGURE;
    --GO
    --sp_configure 'Ole Automation Procedures', 1
    --GO
    --RECONFIGURE;
    --GO
    --sp_configure 'show advanced options', 1
    --GO
    --RECONFIGURE;

    Thanks
    طحہ زبیر احمد Taha Zubair Ahmed
    http://www.tahazubair.blogspot.com

  • RELEVANCY SCORE 2.46

    DB:2.46:File Dialog Box?? Please Help! xd


    button1 is to generate a text file to extract the data. however, i want it to prompt me a file dialog box to allow me to choose the location i want to save it. i tried " javascript:document.execCommand('SaveAs','true','test.txt'); " but it only saves the html format. any idea how could i save the extracted data? kindly advise!!

    SCRIPT LANGUAGE="JavaScript"

    %
    java.text.DateFormat ais = new java.text.SimpleDateFormat("dd-MM-yyyy hh.mm.ss");
    String formattedNowTime = ais.format(now);
    int count = 1;
    %

    function button1()
    {
    %

    ResultSet rs3 = stmt3.executeQuery("SELECT W.Grp, W.Adm_No,SSN.Repeat_Cnt, S.Name, [Absent%], WarnNo, Issue_Date, Issue_By, FromDate, ToDate, S.TutGrp, T.TutorName FROM Warning_Letters W, Students S, Student_Study_Modules SSN, Tutors AS T "+
    "WHERE SSN.Adm_No=S.Adm_No AND SSN.Module_Code=W.Module_Code AND S.Adm_No=W.Adm_No AND W.Module_Code='"+moduleRQ+"' AND S.TutGrp=T.TutGrp AND W.Issue_Date between #"+date1+"# AND #"+date2+"# ORDER BY Grp, S.Name, W.WarnNo");

    //count++;

    String path = ("C:\\\\temp\\\\" +moduleRQ+ " ("+modAbbr+") " +formattedNowTime+ ".txt");
    File strFile = new File(path);

    Writer objWriter = new BufferedWriter(new FileWriter(strFile));
    objWriter.write(moduleRQ+ " / " +descRQ+ "("+modAbbr+")");
    objWriter.write("" +formattedNowTime);
    objWriter.write("\r\n"+"Name"+"\r\t"+"\r\t"+"AdmNo"+"\r\t"+"W.No"+"\r\t"+"Issue"+"\r\t"+"By"+"\r\t"+"From"+"\r\t"+"To"+"\r\t"+"PEM");

    while(rs3.next()){

    String issuedname = rs3.getString("Name");
    String admnumber = rs3.getString("Adm_No");
    String warnNumber = rs3.getString("WarnNo");
    String IssueBy = rs3.getString("Issue_By");
    String IssueDate = rs3.getString("Issue_Date");
    String fromDate=rs3.getString("FromDate");
    String toDate=rs3.getString("ToDate");
    String tName=rs3.getString("TutorName");

    String[] monthArray={"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"};

    /*Converting Dates to "dd/mm/yyyy" format*/
    String day = IssueDate.substring(8,10);
    String month = IssueDate.substring(5,7);
    IssueDate= day+" "+monthArray[Integer.parseInt(month)-1];
    day = fromDate.substring(8,10);
    month = fromDate.substring(5,7);
    fromDate= day+" "+monthArray[Integer.parseInt(month)-1];
    day = toDate.substring(8,10);
    month = toDate.substring(5,7);
    toDate= day+" "+monthArray[Integer.parseInt(month)-1];

    objWriter.write("\r\n"+issuedname+"\r\t"+admnumber+"\r\t"+warnNumber+"\r\t"+IssueBy+"\r\t"+IssueDate+"\r\t"+fromDate+"\r\t"+toDate+"\r\t"+tName);
    }
    objWriter.flush();

    objWriter.close();

    %
    }

    /SCRIPT

    DB:2.46:File Dialog Box?? Please Help! xd

    Do not use JSP for that. Use a servlet. You can find here an example: http://balusc.blogspot.com/2007/07/fileservlet.html

  • RELEVANCY SCORE 2.46

    DB:2.46:Random Reboots Sbs2003 After Bsod 9j


    Hi there
    I have a newly installed SBS2003, that reboots approx once a week.
    I can't seem to find any similarities in the days where it happens.
    I've tried to locate the error, but can't find any info on it anywhere.
    All the drivers are the newest from either Microsoft or DELL. Event though it seems to be a driver fault. I cant locate it.
    Hardware: DELL POWEREDGE 2950 with PERC6i raid controller.
    Here's the event log entry:
    Event Type: Warning
    Event Source: USER32
    Event Category: None
    Event ID: 1076
    Date: 11/12/2013
    Time: 8:23:52 AM
    User: ULFCAR\administrator
    Computer: UCSERVER1
    Description:
    The reason supplied by user ULFCAR\Administrator for the last unexpected shutdown of this computer is: System Failure: Stop error
    Reason Code: 0x805000f
    Bug ID:
    Bugcheck String: 0x0000009c (0x00000005, 0xf77552d0, 0xb2000010, 0x80200e0f)
    Comment: 0x0000009c (0x00000005, 0xf77552d0, 0xb2000010, 0x80200e0f)

    And here's the dump file (Due to the limit of allowed characters, I've had to paste the readable parts only.):
    PAGEDUMP
    ?C? U S B S T O R . S Y S ÿÿ ph÷ 0i÷ U S B S T O R . S Y S ÿÿ %¶ À%¶ U S B S T O R . S Y S ÿÿ p»¸ 0¼¸ U S B S T O R . S Y S
    ÿÿ 𸠰#¸ U S B S T O R . S Y S ÿÿ p*¸ 0¸ U S B S T O R . S Y S ÿÿ ph÷ 0i÷ i q v w 3 2 . s y s ÿÿÿÿ T¸ P¸ i m a p i . s y s ÿÿÿÿ
    p_÷ P`÷ v g a . s y s ÿÿ ÿÿÿÿ ph÷ 0i÷ k b d h i d . s y s ÿÿÿÿ êº 0ëº i 8 0 4 2 p r t . S Y S À¦º 𧺠F l p y d i s k . S Y S
    \ W I N D O W S \ s y s t e m 3 2 \ n t k r n l p a . e x e \ W I N D O W S \ s y s t e m 3 2 \ h a l . d l l \ W I N D O W S \ s y s t e m 3 2 \ K D C O M . D L L
    \ W I N D O W S \ s y s t e m 3 2 \ B O O T V I D . d l l A C P I . s y s $ \ W I N D O W S \ s y s t e m 3 2 \ D R I V E R S \ W M I L I B . S Y S p c i . s y s

    i s a p n p . s y s w d f 0 1 0 0 0 . s y s $ \ W I N D O W S \ S y s t e m 3 2 \ D r i v e r s \ W D F L D R . S Y S
    p c i i d e . s y s % \ W I N D O W S \ s y s t e m 3 2 \ D R I V E R S \ P C I I D E X . S Y S M o u n t M g r . s y s
    f t d i s k . s y s
    d m l o a d . s y s d m i o . s y s v o l s n a p . s y s P a r t M g r . s y s
    b x v b d x . s y s
    a t a p i . s y s m e g a s a s . s y s \ W I N D O W S \ s y s t e m 3 2 \ d r i v e r s \ S C S I P O R T . S Y S
    s y m m p i . s y s d i s k . s y s \ W I N D O W S \ s y s t e m 3 2 \ D R I V E R S \ C L A S S P N P . S Y S
    f l t M g r . s y s
    S S R F s F . s y s D f s . s y s
    K S e c D D . s y s N t f s . s y s N D I S . s y s
    V T r a c k . s y s M u p . s y s c r c d i s k . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ i n t e l p p m . s y s (
    \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ b x n d 5 2 x . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ u s b u h c i . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D
    R I V E R S \ U S B P O R T . S Y S ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ u s b e h c i . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ v g a p n p . s y s
    ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ V I D E O P R T . S Y S ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ w a t c h d o g . s y s $ \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E
    R S \ f d c . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ s e r i a l . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ s e r e n u m . s y s
    \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ c d r o m . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ r e d b o o k . s y s # \ S y s t e m R o o t \ s y s t e m 3 2
    \ D R I V E R S \ k s . s y s , \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ G E A R A s p i W D M . s y s - \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ G e n e r i c M o u n t . s
    y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ a u d s t u b . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ r a s l 2 t p . s y s ) \ S y s t e m R o o t \ s y s
    t e m 3 2 \ D R I V E R S \ n d i s t a p i . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ n d i s w a n . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ r a s p p p o e . s y s
    ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ r a s p p t p . s y s $ \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ T D I . S Y S ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V
    E R S \ p t i l i n k . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ r a s p t i . s y s \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ r d p d r . s y s
    ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ t e r m d d . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ k b d c l a s s . s y s ) \ S y s t e m R o o t \ s y s t e
    m 3 2 \ D R I V E R S \ m o u c l a s s . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ s w e n u m . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ u p d a t e . s y s
    ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ m s s m b i o s . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ d c d b a s 3 2 . s y s ( \ S y s t e m R o o t \ S y s t e m 3
    2 \ D r i v e r s \ N D P r o x y . S Y S ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ u s b h u b . s y s % \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ U S B D . S Y S '
    \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ F s _ R e c . S Y S % \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ N u l l . S Y S % \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e
    r s \ B e e p . S Y S ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ H I D P A R S E . S Y S \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ m n m d d . S Y S ' \ S
    y s t e m R o o t \ S y s t e m 3 2 \ D R I V E R S \ R D P C D D . s y s % \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ M s f s . S Y S % \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ N p
    f s . S Y S ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ r a s a c d . s y s \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ i p s e c . s y s
    \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ m s g p c . s y s \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ t c p i p . s y s \ S y s t e m R o o t
    \ s y s t e m 3 2 \ D R I V E R S \ n e t b t . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ w a n a r p . s y s $ \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \
    a f d . s y s ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ n e t b i o s . s y s \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ r d b s s . s y s '
    \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ m r x s m b . s y s % \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ F i p s . S Y S % \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \
    C d f s . S Y S . \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ d u m p _ d i s k d u m p . s y s - \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ d u m p _ m e g a s a s . s y s
    ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ h i d u s b . s y s ) \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ H I D C L A S S . S Y S ' \ S y s t e m R o o t \ s y s t e m 3 2 \
    D R I V E R S \ m o u h i d . s y s ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ k b d h i d . s y s \ S y s t e m R o o t \ S y s t e m 3 2 \ w i n 3 2 k . s y s
    \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ D x a p i . s y s $ \ S y s t e m R o o t \ S y s t e m 3 2 \ d r i v e r s \ d x g . s y s ' \ S y s t e m R o o t \ S y s t e m
    3 2 \ d r i v e r s \ d x g t h k . s y s \ S y s t e m R o o t \ S y s t e m 3 2 \ A T M F D . D L L ) \ ? ? \ C : \ W I N D O W S \ s y s t e m 3 2 \ d r i v e r s \ e x i f s . s y s
    ' \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ m r x d a v . s y s $ \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ s r v . s y s % \ S y s t e m R o o t \ S y s t e m 3 2 \ D
    r i v e r s \ H T T P . s y s \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ T D T C P . S Y S \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ R D P W D . S Y S
    % \ S y s t e m R o o t \ S y s t e m 3 2 \ D r i v e r s \ U d f s . S Y S ( \ S y s t e m R o o t \ s y s t e m 3 2 \ D R I V E R S \ U S B S T O R . S Y S \ S y s t e m R o o t \ S y s t e m
    3 2 \ R D P D D . d l l ! \ S y s t e m R o o t \ S y s t e m 3 2 \ f r a m e b u f . d l l

    *** STOP: 0x%08lX (0x%p,0x%p,0x%p,0x%p)

    *** Fatal System Error: 0x%08lx
    (0x%p,0x%p,0x%p,0x%p)

    Driver at fault: %s.


    TRGD

    DB:2.46:Random Reboots Sbs2003 After Bsod 9j

    Hi,
    I would like to confirm what is the current situation?
    If there is anything other questionsthat I can do for you, please do not hesitate to let me know, and I will be happy to help.

    Best Regards,
    Justin Gu

  • RELEVANCY SCORE 2.46

    DB:2.46:Fcc Conversion Fields Without Any Seperator And Structure Seperated By Spac zd



    HI all,

    I am doing an idoc to file scenario with simple mapping involved,now i have to send a flat file to XI integration engine in xml format so i have to perform content conversion my problem is that fields r not seperated by any seperator and structure is seperated by space so i am confused ho to convert it. plz do the need ful help i am showing my flat file structre below.

    00OFTESE005000300004400881698040971037506 01103750620070601163304 02GLOBE 0015 03USRAMIREN 04200723200731 050050000003853 060000010002800055031800 072007233000000000000252 060000020002800059950800 072007263000000000000118

    DB:2.46:Fcc Conversion Fields Without Any Seperator And Structure Seperated By Spac zd


    Hi Saurabh,

    Do the file content conversion the way we normally do.

    The only change would be when you write ..try the below it just might work..

    detail.fieldSeparator = just type here space

    Regards,

    Sumit

  • RELEVANCY SCORE 2.46

    DB:2.46:How To Find Row Terminator In Csv File? ca


    Hi All,
    I’ve one flat file it is in CSV format. To load this file I am using .fmt file.I unable to load the file using format file. I am guessing I gave wrong row terminator! This file generated from Python. Usually windows system file have “\r\n” Row terminator,
    I think Python system flat file have “CHAR(13)” . Can any please tell how to specify the CHAR(13) in format file.
    Thanks
    Bala

    DB:2.46:How To Find Row Terminator In Csv File? ca

    Hi,
    I assume you're importing the file via bcp and your fmt file.
    On the bcp command, you have to specify the -r parameter (row terminator) as being
    /r Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

  • RELEVANCY SCORE 2.46

    DB:2.46:Question About Excel File - Flat File Connection Setup xs



    I have a OLE db connection pointing to an excel file and that works fine. But I was trying to create a new connection - flat file connection as this is an excel file and wanted to see if I could get this to work.
    Only problem is that when I open the file in Notepad you see the following: which is what I see when I click on Columns in the flat file connection. I have CR LF for the delimiter and tried other settings but the columns do not appear correctly.
    Is this an issue with the file itself? I am not sure what process created these files, but this is what I have to work with - I can't modify these files. I just want to make sure there is no way I could use the Flat File connection manager ..
    Thoughts?

    R
    o o t E n t r y
    F pK
    W o r k b o o k


    S u m m a r y I n f o r m a t i o n (

    D o c u m e n t S u m m a r y I n f o r m a t i o n 8



    ! #







    ) , *


    ` SQLwithoutwins (
    SQLwithoutwins; 8 s

    ArchivePolicy ArchiveEffectiveDate ArchiveBilldate ArchivebillAmount POLICY EFFDATE BILLDATE

    c c
    ]

    d MbP?_ * % A

    DB:2.46:Question About Excel File - Flat File Connection Setup xs

    I got it now. I was brain dead for a very busy week.. I will use expressions so the parameter will be set up once and used for my connection manager setup.

    Duh.. thanks

  • RELEVANCY SCORE 2.45

    DB:2.45:Should I Replace A Cd-R/W With A Dvd-R/W? mz


    Dims.8400; oper sys isXP Pro. came with a Samsung CD-R/W drive.  Just being able to burn CDs is getting in-convient a pain.  Is it possible to swich this drive out and instal a DVD R/W?  Should it be a + or - R/W? Does it matter?

    DB:2.45:Should I Replace A Cd-R/W With A Dvd-R/W? mz

    That is a nice drive.  It should do well for you.

  • RELEVANCY SCORE 2.45

    DB:2.45:Hide Repeating Values In A Column In An .Rtf File? 17


    Hello!
    I have a phone tree that was built in APEX and am using an .rtf file/report to display the results. The first column is the manager's name, the second column is the name(s) of people who the manager calls. The manager's name prints on every line, but I would like for it to print once:

    Manager Calls
    John W. Terry V.
    John W. Alex P.
    John W. Theresa T.
    Paul R. Amy N.
    Paul R. William S.
    Paul R. Oscar Y.

    Does anyone know how to go about doing this?
    Thank you!
    T

    DB:2.45:Hide Repeating Values In A Column In An .Rtf File? 17

    Thanks for editing that...I was totally confused as to what you were trying to tell me! :)

    And thank you very much for replying...IT WORKED!! Where can I find more information along the lines of the solution you posted? I haven't come across that in the BIP User Guide (but I honestly haven't looked at every single page in the guide either).

  • RELEVANCY SCORE 2.45

    DB:2.45:How To Load Flat File In Ascii Format. 7a



    Hi all,

    1.how to load flat file in ASCII format.

    2.I have a folder of flat files comes every monday 10pm.How to load them?

    3. when loading data " error is coming " RFC failed.How to Rectify it?

    Thanks,

    madhu.

    DB:2.45:How To Load Flat File In Ascii Format. 7a


    Hi Madhu,

    A flat file is an ASCII file. So there is no conversion. If you can open your flat file in Notepad or excel then its an ASCII File. So I do not understand what more you need. Now as far as your next question: how to do it ... just create an info package or refer the web log above. Hope this helps.

    Best regards,

    Kazmi

  • RELEVANCY SCORE 2.45

    DB:2.45:Uploading File - Unicode File Type Gives Error 3d


    Hello,
    I am trying to upload an xml file.
    If the file is of ASCii format I can import this file ,but if the file format is changed to unicode or utf-16 I get sax parser error.
    I noticed one thing though,ascii file seems to appear in this format
    ?xml version="1.0" encoding="UTF-8"?
    addresses
    address
    street-name22 11th ave SW/street-name
    cityDynotopia/city
    /address
    /addresses

    Where as when I change the file format to unicode it appears like this

    ? ? x m l v e r s i o n = " 1 . 0 " e n c o d i n g = " U T F - 8 " ?

    a d d r e s s e s

    a d d r e s s

    s t r e e t - n a m e 2 2 1 1 t h a v e S W / s t r e e t - n a m e

    c i t y D y n o t o p i a / c i t y

    / a d d r e s s

    / a d d r e s s e s
    ? ? x m l v e r s i o n = " 1 . 0 " e n c o d i n g = " U T F - 8 " ?

    a d d r e s s e s

    a d d r e s s

    s t r e e t - n a m e 2 2 1 1 t h a v e S W / s t r e e t - n a m e

    c i t y D y n o t o p i a / c i t y

    / a d d r e s s

    / a d d r e s s e s

    Can some one guide me to automate this process so that my sax processor automatically set itself to the appropriate file format?
    or is it possible at all?

    DB:2.45:Uploading File - Unicode File Type Gives Error 3d

    Thanks,,,but there lies my problem,I do not want to isolate my code for a specific encoding?
    I take it its almost not possible to write a method that will get the encoding of the underlying file using java(too freaking bad).
    I know some c/c++ is there a way using those langs to find out the encoding of a file for sure....??? there has to be a way.Becaus if I open a file in UltraEdit,in the status bar it always tells which enoding of the opened file ?????????????????

  • RELEVANCY SCORE 2.45

    DB:2.45:Ms Publisher Imagesetter And .Spl File 9k


    In our company we use MS Publisher Imagesetter printer for internal use. We print a file at this printer, we get the .spl file, analyze it, get the original text, add some new text, and then send the new file to another printer Our OS are XP, 7 and 8.
    At XP and 7 the .spl file has this format. EMF „• = l D
    Ÿ Ζ ! ? φf P r i n t t e s t % €% €% € b d €! b $ $ €? €? K
    R p µ Ό ΅ A r i a l ¨.ηώ Π†- °.ηώ Πˆ- π- Π i 0.ζώ p ώ ™!ζώ T€w P - ΰ† H Θ- ˆ4tw
    βηϋώ ‰ ' ΐŠ- l‚ w2 ‚ ζώ `Τ `έ1 φ$ζώ l Γdv % m MΈΏY T ά n z X Ρ €‡@^³‡@n ΐ L |
    ω ω ό ό : ? 6 2 : 2 - : 2 2 5 6 - 5 2 2 % €% T Π n Ϊ L 1 €‡@^³‡@n L x ϋω όώ
    όϋ ό 6 5 2 2 2 - 6 0 2 6 : 6 : 2 2 % €% T n : « ‘ €‡@^³‡@n € L h ϋ ϊόω6 :
    2 6 2 2 : 5 % €% T ¬ Ί : 3 ‘ €‡@^³‡@Ί € L l ω - 5 : ? * * * * * * * * %
    €% T | t σ χ €‡@^³‡@t ζ L \ ό 6 2 6 . 2 6 % €% T ¨ z ϊ 7 Q €‡@^³‡@z @ L l
    ω ω,ω ώω,ω 5 - 6 5 : 5 6 ? 5 : 5 % €% T l z Z ± €‡@^³‡@z L X * * * * % €%
    T p T Z q ± €‡@^³‡@T L X ό ώ? 2 2 6 % €' ΐΐΐ % % €L d b € ί b € ` ! π €? €?
    % €% €% T $ n € Χ €‡@^³‡@n Ζ $ L ” ) 1 ϋ02 ωŒ 12 . . . ) . ) . 6 ) . 3 .
    ' 6 $ ) ! . 5 9 . 3 ! . ) . % €% T p € ° Χ €‡@^³‡@ Ζ L X όϋω- 2 2 6 % €( R p
    µ ΅ A r i a l Ό ΅Xƒ i a l 0ƒ - °Ώt - ’†ύώ ΄ °Ώt @Π ώ βηϋώ °Ώt
    Όγώ °Ώt - ώ ώ «}ώ eώ - dv % m Α l ( δ Δ €‡@^³‡@ % €% l ( Θ Δ €‡@^³‡@ %
    €% l ( Δ €‡@^³‡@ % €( R p µ Ό ΅ A r i a l ΅ A r i a l
    . °Ώt . ’†ύώ $ °Ώt @Π - βηϋώ °Ώt Όγώ °Ώt . ώ ώ «}ώ eώ . dv % m MΈΏY T l z ΰ T 7
    €‡@^³‡@z L X όω - 2 2 % €( R p µ ΅ A r i a l Ό ΅ A r i a l
    / °Ώt / ’†ύώ @ °Ώt @Π ώ βηϋώ °Ώt Όγώ °Ώt / ώ ώ «}ώ eώ / dv % m Α T d š
    α J 3 €‡@^³‡@š $ L T 6 * * % €( R p µ Ό ΅ A r i a l ΅ A r i a l
    0 °Ώt 0 ’†ύώ T °Ώt @Π ώ βηϋώ °Ώt Όγώ °Ώt 0 ώ ώ «}ώ eώ 0 dv % m MΈΏY T x Τ
    ΰ , 7 €‡@^³‡@Τ L \ ω, 5 2 : ? : % €( R p µ ΅ A r i a l Ό ΅ A r i
    a l 1 °Ώt 1 ’†ύώ | °Ώt @Π ώ βηϋώ °Ώt Όγώ °Ώt 1 ώ ώ «}ώ eώ 1 dv %
    m Α l ( ¨ $ €‡@^³‡@ % €( R p µ Ό ΅ A r i a l ΅Xƒ i a l 0ƒ
    2 °Ώt 2 ’†ύώ T °Ώt @Π 1 βηϋώ °Ώt Όγώ °Ώt 2 ώ ώ «}ώ eώ 2 dv % m MΈΏY T ˆ d ΰ k 7
    €‡@^³‡@d L ` ώόώω6 ? 2 2 : ? 6 6 % €( R p µ ΅ A r i a l Ό ΅ A
    r i a l 3 °Ώt 3 ’†ύώ Œ °Ώt @Π ώ βηϋώ °Ώt Όγώ °Ώt 3 ώ ώ «}ώ eώ 3 dv %
    m Α T „ ° α ό 3 €‡@^³‡@° $ L ` * *
    but in winows 8 the .spl's format is like this
    EMF Έ] ½ l µ ΐ §ν % P r i n t t e s t % €% €% € b d €! b
    $ $ €? €? K j ” „ ‚save initclip /p2e {/languagelevel where {pop languagelevel} {1} ifelse 2 ge {currentfile read pop pop} if} def /im {/hofs exch def /vofs exch def /wid exch def /hei exch def /datasize
    exch def /ds exch def gsave hofs vofs translate wid hei scale wid hei true [wid 0 0 hei neg 0 hei] ds 0 () /SubFileDecode filter /LZWDecode filter datasize dup 0 eq {pop pop pop pop pop pop} {string readstring pop imagemask} ifelse grestore} bind def 0 0 0
    setrgbcolor p2e %~J,g]g3$]7K#DEP:q1$o*=mro@So\\5,H7Uo*jE[.O@Wn[3@'nb-^757;RpHq_R=AlC^cenm@9 :1mM9jS!dTLf-%l!4c5RO8,!-IO\1:).C#=Q3WE$1dN06`%JG(Ucp;oCD7m$s*e)/[X1`;d;D? Z=Wm;S*:I6A,#7`E]O)lWlWso-B=M2RoR'ru%XBo1C*)9MSci9p*9^1IhFahr3C/)_X#,VXj
    !.-7=01r84o(dDkglN@?n8\!)k!5?.O2^tS-pI#TZls31Obl[-DOp]8/p\6nu:HNtA-g1b7D r5US]B7JLJ'T7HXk7^d^_q@nO2E\FBBSP#6L]Q]Sh7oI,cAI^'FHH_*JcLRO%g4_hV$r]ebm#i.RU 'EZ7hcFa_OW@q]S#JUW[rpdY1X^l9nHh(_up3(lpM'\d1!l!qNDa5%KarKE7K;!(.3RHNUc4!T! 0SFoR8!3FEJ\I.jPWte`3Ir'cj9sE,9@@WL!QB'6G-NUcCa0k.-c7SV8FZ882M(@F`ApXJK[/kmBIt
    .s!8.34fPhIXFnr,jsSQM\;3/*#)r[J\6^?FJb,k)lk4plP11d;'I8rDFmbCTo'8G5foSP]$@Z* #LrDjY2BETWWp75XTN3;;`00U=\Nt\dmr!]olV(QULk*u4pdhbc9Wj^UMPC#InSkIUmbfnr-C?dOm% V_#.i[CL3[028rrg[A6aA[6`Rbgj5%#K47[bAYAhhW;)lCZ\'I=5(/UD2=9=;SO66E=i4d8Zp^b; 16J]O(-uP,/fJ,W=YjZDQk)hE\38!mhWOO3I1Q-C8!;sC';9Od#9iAjmnG(?!-C;o?22u'@
    /1,dkkWR(kMJf/R?X.;kcNJF]l`@p%`Hp1h2$\F1$mj,?hYL3`]l8VFXUZtTc@45Rl]ao)Lbsd c:kGbLAW,JZE].8?s.qsDfkSs]0WEGXB4Nk5s41k[cepBZlgL@!EaYCHVS6)'hYl1jr0T2Je!P ^=iua''re=aLl7gE8MTAFoS7OU;ciq76IrS-=O4pV$T8N2V=(Zde`0]OG6L(L6b`SolM: $fK`XF]_790%=_%\iWacDJW#qT9q2^5OTubG**P6o_?',%K\BrG\\UT#c29f(ppcmlZ=g/ZbRaB
    MdjW7B(NV'_)*c8,O?JLL'hmZB/nKH*)E'eQ4UlnK9CqA'YgK95NqCW$r)LH$LTn-:;$;,2 Z#DdqM8*?[APCijDPNQpGqMIWf'uJmt2d3htV_`,Yei3:nWF]WdH;4h$1TjSe.=HDlV[uB$ 3%uQEfbd;l4N*V(t:7:,OBIEQI@`/d!(;F*`h_2'?mZA)PQNfS.A!QPsJFBL-n3el_g)TLo;NTqh L)t_oZ1NR/*^OoO[hu`%f`(ME_;%_:FioWO:JA%D5sAb2Ni-EgVOD8,i_V5,`**6$MfXe0D8MZK,
    I)NmA(5j1fU/?1@nn77Z9PT%pn%o6Ou0]lW/'\8eMLsJgdSc3\gf6ms$-k4@i5D5;k92*'`[ As a result, we cannot analyze correct this
    .spl file and get the whole text. Why is this happening? p.s. sorry for the big copy paste, but I didn't find a button for attaching a file.

    DB:2.45:Ms Publisher Imagesetter And .Spl File 9k

    I uploaded two spl files. win8.spl and win7.spl.
    https://skydrive.live.com/?cid=ba664f5da41fe974#cid=BA664F5DA41FE974id=BA664F5DA41FE974!120

  • RELEVANCY SCORE 2.45

    DB:2.45:Generate Multiple Xml Files From A Single Input File With Multiple Orders 1z


    Hi ,

    I have a flat file which is having multiple orders in it. Every Order will have information like shipping , Billing details etc. Now i need to create an XML for each and every order comes with the flat file.

    Could you please let me know the approaches we can follow for this? The flat file format is a tab delimited file.

    it is like this

    s 100 200
    B adc xyz
    p 123 500
    R 345 789
    S
    B
    P
    R
    t 100 300

    The last t record indicates the Trailer which means it is the end of the file. So if we have multiple records there would be once trailer record for the multiple orders.

    Here i need to create an XML for each Order that is till R Record it is one order.

    On top of this every record type S - shipping have multiple fields in it. Shipping id Shipment name etc.

    Please let me know the best way to achieve this.

    Thanks,
    Mansur

    DB:2.45:Generate Multiple Xml Files From A Single Input File With Multiple Orders 1z

    Hi ,

    I have a flat file which is having multiple orders in it. Every Order will have information like shipping , Billing details etc. Now i need to create an XML for each and every order comes with the flat file.

    Could you please let me know the approaches we can follow for this? The flat file format is a tab delimited file.

    it is like this

    s 100 200
    B adc xyz
    p 123 500
    R 345 789
    S
    B
    P
    R
    t 100 300

    The last t record indicates the Trailer which means it is the end of the file. So if we have multiple records there would be once trailer record for the multiple orders.

    Here i need to create an XML for each Order that is till R Record it is one order.

    On top of this every record type S - shipping have multiple fields in it. Shipping id Shipment name etc.

    Please let me know the best way to achieve this.

    Thanks,
    Mansur

  • RELEVANCY SCORE 2.45

    DB:2.45:Jerky Playback Of M2t Hdv Files. 1f


    I have a Dell Dimension 8250, Pentium(R) 4 CPU 3.06GHz1 gig ram, 128 DDR ATI Radeon 9700 Pro w/TV-Out Sec display card, Dell UntraSharp 20” LCD. I’m about to purchase a new Sony HD camcorder. I have downloaded the native files from this camera, m2t format, an mpeg file format, and my more or less state of the art computer is barely able to play these files. What do I need to do, get a new display card? If so, which card do you recommend?

    Thanks

    John

    DB:2.45:Jerky Playback Of M2t Hdv Files. 1f

    I have a Dell Dimension 8250, Pentium(R) 4 CPU 3.06GHz1 gig ram, 128 DDR ATI Radeon 9700 Pro w/TV-Out Sec display card, Dell UntraSharp 20” LCD. I’m about to purchase a new Sony HD camcorder. I have downloaded the native files from this camera, m2t format, an mpeg file format, and my more or less state of the art computer is barely able to play these files. What do I need to do, get a new display card? If so, which card do you recommend?

    Thanks

    John

  • RELEVANCY SCORE 2.45

    DB:2.45:Help Adding A M4r Ringtone In Dreamweaver Cs5 cc



    I'm trying to add an iPhone ringtone (m4r format) to a site page. I've tried a variety of methods, but each time I do so, and click the file (using Safari) the file does not download -- it starts displaying code:

    ftypM4A M4A mp42isom tmoovlmvhdrsD @ trak\tkhd rs @ 5mdia mdhdrsD U"hdlrsoun minf smhd$dinf dref url stblgstsd Wmp4a D3esds " @ stts (stsc : stsz 7 Ž x S A : W # 6 * $ 8 * 5 K % n w x m w v j m n P ` #127; z { q o W 2 ` " ( #141; p s
    | T B / N p r * @ = E d a p x T q \ + p U f f I x ~ ž Ž d X e p y S " h u R ^ d # { T ! 5 A p M y a F u R . / I e #141; 9 B g X 5 5 $ H S - I A 5 ^ G $ N 7 F M I c m d T a r E
    G % : _ #157; s 3 $ 4 5 X u h - 4 j s j n Q O ) r X G K
    F + ` #141; l A 2 #127; l r { f | Ž u h \ i c #143; w } k r l 3 w ž g #157; w r ] x r n ~ ž H n s #157; f ž I #141; #127; d l - #144; j Ž [ a , #143; } #129; } u i a r P w k u q x h x #141; #143; s t z F { t G j [ m #157; #157; x o a #144; h #143; s ~ #129; [ A A / L ( -
    ! (
    `
    "
    e o
    1 $ m = +
    #

    Can anyone help me correct what I'm doing wrong? I just want users to be able to automatically download the m4r files to their desktop.

    Many thanks!

    gb

    DB:2.45:Help Adding A M4r Ringtone In Dreamweaver Cs5 cc


    Compress it into a .zip file or a .rar file. Then anyone should be able to download it no problem.

    Brad Lawryk

    Adobe Community Professional: Dreamweaver

    Northern British Columbia Adobe Usergroup: Manager

    Thompson Rivers University: Dreamweaver Instructor

    My Adobe Blog: http://blog.lawryk.com

  • RELEVANCY SCORE 2.45

    DB:2.45:Check The Flat File Going To Load Is A Valid Format Or Not xd


    Hi All,

    I am very new to SSIS mean couple of days old . How can i check the flat file loading into destination is a valid flat file format or not ?

    Thanks in advance

    Thanks
    SS

    DB:2.45:Check The Flat File Going To Load Is A Valid Format Or Not xd

    Does your flat file has a fixed length? If you know the first row length at least you can try this:
    SSIS: How to validate Flat File Row Length?Vikash Kumar Singh || www.singhvikash.in

  • RELEVANCY SCORE 2.45

    DB:2.45:Nec Dvd R/W Won't Format mm



    Using Roxio. Dell installed a new Nec and it wouldn't format discs either.
    I installed Nero, uninstalled Roxio and installed a Memorex, which is supposed to r/w cd and dvd of all sizes. It will format regular 4.7g but not the mini or pocket size (50mb). Dell support says it's because my computer will not format that size, just the 4.7 or 8. Can anyone tell me if this is a hardware, firmware,software problem? And what can I do about it?
    Thank you
    WendSong
    Message Edited by WendSong on 05-09-2005 02:41 AM

    DB:2.45:Nec Dvd R/W Won't Format mm

    Hello,

    I uninstalled Roxio before installing Nero.

    Memorex claims that this drive will format and burn mini discs and it will recognize a previously burned or formatted mini.

    When I attempt to update Memorex drivers, I get an error message, labeled NEC DRIVE FIRMWARE FLASH UTILITY: "Target NEC ND-3520A is not found correctly." This appears to be something left over from the NEC drive, but I can't find it. Device manager only shows the Memorex (which has 3520 as part of the serial #). I can format larger CD and DVD discs.

    I like the drag and drop features. The CD writing wizard is a real pain.

    Thank you for your interest. I hope we can get to the bottom of this.

  • RELEVANCY SCORE 2.44

    DB:2.44:Error In Using Bcp Query 87


    I am using the BCP query as said in the following link,
    http://www.sqlmusings.com/2009/03/21/sqlxml-how-to-save-xml-query-results-to-a-file-using-bcp/
    but i get the error as below. Any idea??

    output
    usage: bcp {dbtable | query} {in | out | queryout | format} datafile
    [-m maxerrors] [-f formatfile] [-e errfile]
    [-F firstrow] [-L lastrow] [-b batchsize]
    [-n native type] [-c character type] [-w wide character type]
    [-N keep non-text native] [-V file format version] [-q quoted identifier]
    [-C code page specifier] [-t field terminator] [-r row terminator]
    [-i inputfile] [-o outfile] [-a packetsize]
    [-S server name] [-U username] [-P password]
    [-T trusted connection] [-v version] [-R regional enable]
    [-k keep null values] [-E keep identity values]
    [-h load hints] [-x generate xml format file]
    [-d database name]
    NULL

    --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

    DB:2.44:Error In Using Bcp Query 87

    How about keeping it a bit easy to read...
    Declare @FileName varchar(100)
    Declare @SQLCommand varchar(1000)

    ---Command
    Select @FileName = 'C:\Input\FirstTestXML_' replace(convert(varchar(20),Getdate(),111),'/','_') '.xml'
    Select @SQLCommand = 'SELECT
    Category @Name,
    (
    SELECT
    Subcategory @Name,
    (
    SELECT
    Item_Name Item/@Name,
    Item_description Item/@displayname
    FROM @ItemMaster t1 WHERE t1.Subcategory = t2.Subcategory
    FOR XML PATH(''),TYPE
    )
    FROM @ItemMaster t2
    GROUP BY t2.Subcategory
    FOR XML PATH(''SubCategory''),TYPE
    )
    FROM @ItemMaster t3
    GROUP BY t3.Category
    FOR XML PATH(''Category''),ROOT(''Stocks'')'

    SET @SQLCommand = 'bcp ' @SQLCommand '' ' queryout ' @FileName ' -w -T -S' @@SERVERNAME



    PRINT(@SQlCommand)--you can always use Print to see the real sql query generated before executing it....

    Thanks and regards, Rishabh K

  • RELEVANCY SCORE 2.44

    DB:2.44:How To Combine All The Fixed Width Files In The Folder Into Single Flat File Using Ssis 91


    how to combine all the flat files with headersin the folder into a single flat file so that i can get HEADER-DETAIL/HEADER-DETAIL format in single file.
    Thanks

    DB:2.44:How To Combine All The Fixed Width Files In The Folder Into Single Flat File Using Ssis 91

    You could also use a Foreach Loop with a File enumerator to loop through all files within a folder and then append data to a flat file within the Data Flow Task. More info:

    http://microsoft-ssis.blogspot.com/2011/02/how-to-configure-foreach-loop-file.html
    Please mark the post as answered if it answers your question | My SSIS Blog:
    http://microsoft-ssis.blogspot.com |
    Twitter

  • RELEVANCY SCORE 2.44

    DB:2.44:Flat File Data Loads In Ods 33



    Hi All

    In my current project i need to load the data for 10 years.

    source is legacy flatfiles...i need to load data for those 10 years into bw...

    no new data will not comes in bw rather than 10 yeras.

    So can i load the flat files data into 5 ods w r t to 2 years daata inrto one ods..

    Later through multiprovider i will run the reports...Is it ok...

    If any body can give me more suggestions please

  • RELEVANCY SCORE 2.44

    DB:2.44:Flat File To Idoc Scenario 3c


    Hi,I need to post an flat file as an IDOC to a SAP R/3 system using PI 7.0.The flat file is on file server [Which is on client space].Query-1]I can use FLAT TO IDOC FM - PI - ABAP stack to convert PI-Application Server based file into IDOC and post it however how can i access FLAT file from file server to a PI and call FLAT TO IDOC FM in PI.2] Is there any other approach to do flat to idoc posting [i.e. using some standard mappings]Regards,Rakesh Bhagat

    DB:2.44:Flat File To Idoc Scenario 3c

    Hi friends,here is new document for IDOC TO FILE scenario..http://jskcomput.blogspot.com/2013/08/idoc-to-file-scenario.html

  • RELEVANCY SCORE 2.44

    DB:2.44:Date Format 9f



    Hi,

    Plz tell me the procedure for changing date format...

    i have a format DDMMYYYY in my flat file...

    Thanks

    DB:2.44:Date Format 9f


    Hi,

    Try this FM 'PERIOD_AND_DATE_CONVERT_OUTPUT'

    It will give you date separated by period symbol.

    Reward if helpfull.

  • RELEVANCY SCORE 2.44

    DB:2.44:Unzipping A Shnf.Zip File 3c


    I downloaded a show from archive.org in a format I've never used before. The format is shnf.zip. Stuffit expander only yields a folder w/ no content. I did see instructions at archive.org for opening the file using the terminal utility, but that technique failed as well. If anyone can be of help, I would really appreciate it.

    imac flat screen Mac OS X (10.3.9)

    DB:2.44:Unzipping A Shnf.Zip File 3c

    It's called a learning curve - lol.
    Hope you get it fixed and don't let Mr. Murphy mess up again.

    M

  • RELEVANCY SCORE 2.44

    DB:2.44:Formating Text Using Regex zs


    Hello Everyone,

    I have extracted some text from HTML pages writing it to a Text file. Text is scrambled everywhere in the file after saving.

    in the output text there some new line , tabs etc ... is there any way to remove them ? using Regex ??
    text i am getting after extraction :- ( checked using Debug )
    Pradeep \r\n\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t G\r\n
    \r\n

    \r\n \r\n
    State College \r\n

    \r\n \r\n
    \r\n Welcome

    Society\r\n \r\n
    \r\n

    \r\n Library-Dept\r\n
    \r\n

    \r\n \r\n
    \r\n Mailing

    Address: \r\n \r\n\t\t\t\t\t\t\t\t\t \r\n
    \r\n

    \r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\tWelcome Society\r\n\t\t\t\t\t\t\t\t\t

    \r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\tLibrary Dept\r\n\t\t\t\t\t\t\t\t\t

    \r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t6th Street No 42\r\n\t\t\t\t\t\t\t\t\t

    \r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\tMail road\r\n\t\t\t\t\t\t\t\t\t,

    \r\n\t\t\t\t\t\t\t\t\tKAR\r\n\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t10700-1008\r\n\t\t\t\t\t\t\t\t\t

    \r\n\t\t\t\t\t\t\t\t\tIND\r\n \r\n\t\t\t\t\t\t\t
    \r\n \r\n

    Phone: (91) 044-4446480 \r\n
    \r\n

    \r\n\t\t\t\t\t\t\t\t Fax: (91) 044-4446486 \r\n
    \r\n \r\n\r\n

    \r\n
    \r\n Email: \r\n

    \r\n

    I tried using
    string Correct = null;
    Correct = Regex.Replace(strOutput, \r\n\t, );
    File.WriteAllText(C:\\Text.txt, Correct());

    but still the text in the output file is scrambled ...please can anyone help me with removing this escape sequence in Regex

    Thanking you,
    Naveen Hs

    DB:2.44:Formating Text Using Regex zs

    On Mon, 23 Aug 2010 11:16:58 0000, Naveen HS wrote:

    It worked Thanks a lot .. :)

    Glad to help. Thanks for the feedback.

  • RELEVANCY SCORE 2.43

    DB:2.43:Bulk Insert/Bcp Command Unexpected End Of File Issue 9a


    Hi, I have question on Bulk Insert or BCP commands in SQL Server. I am currently using SQL Server 2008 R2
    Enterprise Edition. When the input flat file has NULL or Blank values in the very last column.How do we import these files. I used a format file that did not help either. Is there a work around ?
    --BCP command
    bcp dbo.ImportFlatFile in Z:\Test\Test.txt -t , -f ImportFlatFile.fmt -T -c
    --Format file
    9.0
    4
    1 SQLSMALLINT 0 2 1 ID
    2 SQLNCHAR 2 5 2 Code SQL_Latin1_General_CP1_CI_AS
    3 SQLNCHAR 2 25 3 Group SQL_Latin1_General_CP1_CI_AS
    4 SQLDATETIME 0 8 \r\n 4 RegDate
    --Data
    ID Code Group RegDate
    1 837VT Cor748
    2 837VT Cor748
    3 849VT
    4 849VT
    5 849VT
    Error: SQLState = S1000, NativeError = 0 Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file
    Thanks in advance.................

    Ione

    DB:2.43:Bulk Insert/Bcp Command Unexpected End Of File Issue 9a

    Thanks for your response @Saeid Hasani, I tried the below code and still get error.
    BULK INSERT TestDB..ImportFlatFile
    FROM 'Z:\Test\Test.txt'
    WITH (
    FORMATFILE='F:\TestDefault.Fmt',
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = '\r\n',
    KEEPNULLS
    );

    ERROR: The bulk load failed. The column is too long in the data file for row 1, column 4. Verify that the field terminator and row terminator are specified correctly.
    Well I guess there should be a work around for this issue other than using SSIS package.
    Regards...................

    Ione

  • RELEVANCY SCORE 2.43

    DB:2.43:Virtual Machine Config File Is Invalid xa



    I had a USB drive go offline due to a power outage. It contained a nice VM that when I start it now I get "Virtual Machine Config File is Invalid"

    Looking at the config file, it is toast:

    INDX( @d ( i a v W x d + J: J: n [LT |^

    [LT x x b r i c k w a l l 0 3 4 f . v m t X x d + J: J: j [LT .[LT x b r i c k w a l l 0 3 4 f . v t f Y x d + J: J: [LT A[LT b r i c k w a l l 0 3 7 d . v m t Z x d + J: J: NT[LT ve[LT x b r c k w a l l 0 3 7 d . v t f [ x d + J: J: )s[LT 7x[LT b r i c k w a l l 0 3 8 c . v m t \ x d + J: J: o[LT \[LT x b r i c k w a l l 0 3 8 c . v t f ] x d + J: J: ![LT [LT b r i c k w a l l 0 4 0 b . v m t ^ x d + J: J: [LT 3:\[LT x b r i c k w a l l 0 4 0 b . v t f _ x d + J: J: ][LT kF[LT b r i c k w a l l 0 4 0 c . v m t ` x d + J: J: *[LT T \LT x b r i c k w a l l 0 4 0 c . v t f

    How do I recreate a VMX file for this, or is it most likely other files will be corrupted as well?

    DB:2.43:Virtual Machine Config File Is Invalid xa


    You can try creating a new virtual machine and use the "Custom" option in the new virtual machine wizard. This will allow you to select "Use an existing virtual disk" when prompted to create a virtual disk. Here you can use the browse button and select your original virtual disk to use in this new virtual machine.

    Of course, your virtual disk must not be damaged for this to work.

  • RELEVANCY SCORE 2.43

    DB:2.43:Ssis - Flat File Getting Locked 7f


    Hi,

    I have a data flow task and within the DFT, I have a flat file source connection. If there is an error in the source file/format, the task should fail and OnError event should execute and delete the file from the folder using File System Task setup within
    the event handler. The flat file connection mngr is setup dynamically through variables.
    Whenever, there is an issue within the flat file (format, data, and et al), the OnError event executes but the file system task to delete the file fails due to the file being used by another process. I see that OnError even doesn't execute AFTER the DFT
    fails. It executes DURING the DFT is processing that Flat file source (Orange circle while OnError is executing). So obviously, the Flat File Source is using/locking the .csv and OnError is trying to delete the file. How to get around this w/o any .net scripting?

    DB:2.43:Ssis - Flat File Getting Locked 7f

    @Harry Bal: This pkg I am working on is processing only a single file with specific name (e.g. Names.csv). I am OK if the file gets deleted when ETL fails at any step, in fact. I had originally used failure constraint for the DFT but then we needed to delete
    the file if the pkg fails...anywhere. Also, if I am loading this file and it has 1000 rows and 999 rows are good and one is bad, I still want to delete the file @ the 1000th row failure. Hope this info helps.

    I hope there is a way to do what I am trying to do..hehe

  • RELEVANCY SCORE 2.43

    DB:2.43:Validation Of Flat File j1



    Hi all,

    I am using a flat file containing a date format DDMMYYYY when I wrongly give a date format For eg. YYYYMMDD instead of DDMMYYYY , my query is to :

    -Throw a error message when it is a wrong format

    DB:2.43:Validation Of Flat File j1


    Hi Paul,

    You can use this FM to validate date format.

    bDATE_CHECK_PLAUSIBILITY/b

    bCONVERT_DATE_TO_INTERNAL/b

    CALL FUNCTION 'DATE_CHECK_PLAUSIBILITY'
    EXPORTING
    DATE = I_INPUT-DATE
    EXCEPTIONS
    PLAUSIBILITY_CHECK_FAILED = 1
    OTHERS = 2.

    IF SY-SUBRC 0.
    MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
    WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
    ENDIF.

    CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'
    EXPORTING
    date_external = I_INPUT-DATE
    IMPORTING
    DATE_INTERNAL = WA_DATE
    EXCEPTIONS
    DATE_EXTERNAL_IS_INVALID = 1
    OTHERS = 2.

    IF SY-SUBRC 0.
    MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
    WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
    ENDIF.

  • RELEVANCY SCORE 2.43

    DB:2.43:Edi_Dc40 To Edi_Dc pk



    Hi,

    We're currently developing a mapping to translate an idoc comming from R/3 into a flat file with no XML structure.

    Problem is that the structure of the idoc in plain file format should be the EDI_DC format of SAP release 3.0 and not 4.0. Does anyone has a clue how to establish this?

    At present we use the xml_to_idoc function module to create the output.

    Thanks in advance,

    Peter

    DB:2.43:Edi_Dc40 To Edi_Dc pk


    Hi,

    We're currently developing a mapping to translate an idoc comming from R/3 into a flat file with no XML structure.

    Problem is that the structure of the idoc in plain file format should be the EDI_DC format of SAP release 3.0 and not 4.0. Does anyone has a clue how to establish this?

    At present we use the xml_to_idoc function module to create the output.

    Thanks in advance,

    Peter

  • RELEVANCY SCORE 2.43

    DB:2.43:Load Hierachy To Infoobject With Flat File (Bi 7.0) df



    Hi

    I have a Dept Info Object with hierarchy.

    I want to load the hierarchy (Parent Dept, Child Dept) from a flat file.

    May I know the steps on loading the hierarchy ?

    My flat file format is :

    Parent_Dept;Child_Dept

    123;456

    122;455

    ..... etc

    Btw I am using BI 7.0.

    Thanks in advance !

    DB:2.43:Load Hierachy To Infoobject With Flat File (Bi 7.0) df


    In BI 7.0, RSDS doesnt support hierarchy datasources. So you cannot use transformations and DTP with hierarchy. So it isnt any different from the way we used to load it in 3.x.

  • RELEVANCY SCORE 2.43

    DB:2.43:Carriage Return As Flat-File Delimiter For File Adapter? m9


    I need to process some flat files that include records delimited by carriage returns. This contrasts to the examples in the docs which assume each row of the flat file is a record.

    Is there some way of getting the Native Format Builder to parse the carriage-return delimited flat files like this?

    I've thought about pre-processing the files to translate the CRs into another character, but that is potentially messy (e.g. each line/record of the file can include, say, tab characters, so I can't map '\r' to '\t').

    DB:2.43:Carriage Return As Flat-File Delimiter For File Adapter? m9

    AFAIK the file adapter already supports a CR as a delimiter.

    I've done a lot of work with the file adapter and it works just fine with CSV files with a CR as record delimiter.

  • RELEVANCY SCORE 2.43

    DB:2.43:Reading File In Uft-8 Format Using Owb 7x


    Is it possible to read a flat file having data in UFT-8 format with OWB?

    DB:2.43:Reading File In Uft-8 Format Using Owb 7x

    Hi

    This should be fine, the character set can be defined for files, OWB can load a wide range of file based data from ascii, to binary, to single record to multi record etc..

    The ascii based handling is simple, there is a post on the blog illustrating more complex cases;
    http://blogs.oracle.com/warehousebuilder/newsItems/viewFullItem$470

    Cheers
    David

  • RELEVANCY SCORE 2.42

    DB:2.42:Shipping -- Format For Csv Or Tab Flat File Import? 8m



    Can anyone direct me to where I can find a nicely definite format for the csv tab flat file import for creating multiple entries for shipping? The directions are vague at best, and I'd rather not have to guess by trial and error.

    Thanks in advance.

    DB:2.42:Shipping -- Format For Csv Or Tab Flat File Import? 8m


    When importing CSV (Comma Separated Values) and TSV (Tab Separated Values) files, you need to map content from your file with corresponding columns in the MultiOrder Shipping tool. After selecting a CSV or TSV file on the PayPal MultiOrder Shipping "Import" screen, click on the "Import" button.The following screen will allow you to map your CSV or TSV file fields (name, address, etc) to the PayPal shipping fields... it will also allow you to save the mapping definition.The available PayPal Shipping fields are...First NameLast NameCompanyStreet Address 1Street Address 2CityStateZip CodeCountryPhone NumberOrder IDItem NumberTitleQuantityPayment DateCustom MessageShipping CarrierInsurance Value

  • RELEVANCY SCORE 2.42

    DB:2.42:One Row Into Multiple Rows ac


    Hello,

    In a table , there is a row like this:

    NM POLICIES
    ---- --------------
    Web Report SirketKullanicilari: x-r-t
    TramerKullanicilari: x-r-t
    TramerCognosAdmins: x-r-p-t-w
    TramerReportAdmins: x-r-t-w

    it is one row record and I need to insert this record as 4 rows like below statement. In the policy column, there are 4 lines and seperated by chr(10).

    NM POLICIES
    ---- --------------
    Web Report SirketKullanicilari: x-r-t
    Web Report TramerKullanicilari: x-r-t
    Web Report TramerCognosAdmins: x-r-p-t-w
    Web Report TramerReportAdmins: x-r-t-w

    DB:2.42:One Row Into Multiple Rows ac

    It would be more easier if your table has an addition column to flag the old and new rows. Something like this.

    select * from t;

    NM POLICIES FLAG
    ------------------------------ ---------------------------------------------------------------------------------------------------- ----------
    Web Report SirketKullanicilari: x-r-t
    TramerKullanicilari: x-r-t
    TramerCognosAdmins: x-r-p-t-w
    TramerReportAdmins: x-r-t-w

    merge into t
    using (
    with cross_join_table
    as
    (
    select level rno
    from dual
    connect by level = (
    select length(policies) - length(replace(policies, chr(10))) + 1
    from t
    )
    )
    select nm, regexp_substr(policies, '[^'||chr(10)||']+', 1, rno) policies
    from t
    cross
    join cross_join_table
    UNION ALL
    select nm, policies
    from t
    ) t1
    on (
    t.nm = t1.nm and t.policies = t1.policies
    )
    when matched then update set flag = 'OLD' delete where flag = 'OLD'
    when not matched then insert (t.nm, t.policies) values (t1.nm, t1.policies);


    select * from t;

    NM POLICIES FLAG
    ------------------------------ ---------------------------------------------------------------------------------------------------- ----------
    Web Report TramerReportAdmins: x-r-t-w
    Web Report TramerCognosAdmins: x-r-p-t-w
    Web Report TramerKullanicilari: x-r-t
    Web Report SirketKullanicilari: x-r-t

  • RELEVANCY SCORE 2.42

    DB:2.42:Retrieve One Picture File fd


    Hi,
    Why do I get these below

    Copy direction must be either 'in', 'out' or 'format'.
    usage: bcp {dbtable | query} {in | out | queryout | format} datafile
    [-m maxerrors] [-f formatfile] [-e errfile]
    [-F firstrow] [-L lastrow] [-b batchsize]
    [-n native type] [-c character type] [-w wide character type]
    [-N keep non-text native] [-V file format version] [-q quoted identifier]
    [-C code page specifier] [-t field terminator] [-r row terminator]
    [-i inputfile] [-o outfile] [-a packetsize]
    [-S server name] [-U username] [-P password]
    [-T trusted connection] [-v version] [-R regional enable]
    [-k keep null values] [-E keep identity values]
    [-h load hints] [-x generate xml format file]
    NULL

    when trying to retrieve one picture file from the DB?

    declare @bcpCommand varchar(500)
    SET @bcpCommand = 'bcp SELECT photo_file FROM tab2 WHERE user_ID = 1 -T -c'
    EXEC master..xp_cmdshell @bcpCommand

    Many Thanks Best Regards, Hua Min

    DB:2.42:Retrieve One Picture File fd

    Where the database files are located = subfolder DATA; for your SQL Server:
    C:\Program Files\Microsoft SQL Server\MSSQL11.SS2012\MSSQL\DATA\Olaf Helper

    Blog
    Xing

  • RELEVANCY SCORE 2.42

    DB:2.42:Bapi Sample Code With Flat File. jf



    Hi everyone,

    I need BAPI sample code to upload data using a flat file which has header and

    item format..

    Its very urgent,

    thanks in advance,

    regards

    stanley

    DB:2.42:Bapi Sample Code With Flat File. jf


    hi,

    REPORT ZBAPI_SALES.

    DATA: order_header_in type bapisdhd1.

    DATA: order_partners type table of BAPIPARNR.

    data: return type table of BAPIRET2.

    data: errmsg type BAPIRET2.

    PARAMETER: p_vbeln LIKE vbrk-vbeln OBLIGATORY,

    p_kunnr LIKE kuagv-kunnr OBLIGATORY.

    START-OF-SELECTION.

    order_header_in-doc_type = 'OR'.

    order_header_in-sales_org = '1000'.

    order_header_in-distr_chan = '30'.

    order_header_in-division = '00'.

    order_header_in-ref_doc = p_vbeln.

    ORDER_HEADER_IN-REFDOCTYPE = 'ZQSR'.

    ORDER_HEADER_IN-SD_DOC_CAT = 'C'.

    CLEAR order_partners.

    order_partners-partn_numb = p_kunnr.

    order_partners-partn_role = 'SP'.

    APPEND order_partners.

    CALL FUNCTION 'BAPI_SALESORDER_CREATEFROMDAT2'

    EXPORTING

    SALESDOCUMENTIN =

    order_header_in = order_header_in

    ORDER_HEADER_INX =

    SENDER =

    BINARY_RELATIONSHIPTYPE =

    INT_NUMBER_ASSIGNMENT =

    BEHAVE_WHEN_ERROR =

    LOGIC_SWITCH =

    TESTRUN =

    CONVERT = ' '

    IMPORTING

    salesdocument = sd_vbeln

    TABLES

    RETURN = return

    ORDER_ITEMS_IN =

    ORDER_ITEMS_INX =

    order_partners = order_partners

    ORDER_SCHEDULES_IN =

    ORDER_SCHEDULES_INX =

    ORDER_CONDITIONS_IN =

    ORDER_CONDITIONS_INX =

    ORDER_CFGS_REF =

    ORDER_CFGS_INST =

    ORDER_CFGS_PART_OF =

    ORDER_CFGS_VALUE =

    ORDER_CFGS_BLOB =

    ORDER_CFGS_VK =

    ORDER_CFGS_REFINST =

    ORDER_CCARD =

    ORDER_TEXT =

    ORDER_KEYS =

    EXTENSIONIN =

    PARTNERADDRESSES =

    .

    CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'.

  • RELEVANCY SCORE 2.42

    DB:2.42:Target Flat File With Pipe Seperated am


    Hi

    I want to load the data in flat file , i don't see pipe "|" seperation values to create a flat file in this format. how can i achive and how can i also how can i create file name dynamically

    Thanks

    DB:2.42:Target Flat File With Pipe Seperated am

    Just type in your desired character.

    Cheers
    David

  • RELEVANCY SCORE 2.42

    DB:2.42:Cod 5: W.A.W Scans!!! 9c


    HERE!!!



    PSN-IITriXIIXBL-I T r i X II

    DB:2.42:Cod 5: W.A.W Scans!!! 9c

    looks ace, can't wait for gameplay vids.COD4 beater!! - Go one, FLAME ME!!



    Playing: Call of Duty: World at War ; Fallout 3Pro Rege Et Grege!

  • RELEVANCY SCORE 2.42

    DB:2.42:Fixed Format Flat File!!! ja



    Hi experts,

    i am doing a IDoc to File scenario

    structure of the file is like

    MT_****

    ele1

    ele2

    ele3

    ele4

    ....

    ....

    .....

    e30

    /MT_*******

    in the FS it was written that the file should be Fixed Format Flat File (AS400-legacy system)...and they have given lenght of each field.....

    can any one tell me wats the* Fixed Format Flat File * means??

    also how the structure should look like????

    do i need to use FCC??

    thnx

    DB:2.42:Fixed Format Flat File!!! ja


    Hi,

    Hope these links are useful :

    FCC

    FCC

    Thanks,

    satya Kumar

  • RELEVANCY SCORE 2.42

    DB:2.42:Ssis Package To Transform The Horizontal Row In To Vertical Row ka


    Hi,
    I have flat file source which is having horizontal data row like in the below format

    Source data from flat file

    Column 1
    Column 2
    Column 3
    Column 4
    Column 5
    Column 6
    Column 7
    Column 8
    Column 9
    Column 10

    Record1
    X
    Y
    Z
    P
    Q
    R
    A
    B
    C

    Record2
    X
    Y
    Z
    P
    Q
    R
    A
    B
    C

    Record3
    X
    Y
    Z
    P
    Q
    R
    A
    B
    C

    Ineed to convert that in to the below format and insert in to my new table

    Destination Table Structure

    Column 1
    Column 2
    Column 3

    Record 1
    XPA
    Category1

    Record 1
    YQB
    Category2

    Record 1
    ZRC
    Category3

    Record 2
    XPA
    Category1

    Record 2
    YQB
    Category2

    Record2
    ZRC
    Category3

    I appreciate you help!

    Thank you,
    Malarvannan M

    DB:2.42:Ssis Package To Transform The Horizontal Row In To Vertical Row ka

    Hi Reza,
    Thank you very much for your input. I was tried withseparate derived column for each category and instead of UNPIVOT I did UNIONALL and I got my output.
    Thank you,
    Malarvannan M
    Malarvannan M

  • RELEVANCY SCORE 2.41

    DB:2.41:Ordered My Dimension 9100 km


    Hi Guys!

    Well, after much debate on what pc to get I decided to get a Dimension 9100. I placed my order online Monday and according to the online status it shipped out today. I can't believe how quickly this whole process took. I'm just a little concerned with the burn-in and testing happened so quickly. Hopefully nothing breaks, lol. Here are the specs:

    Dell Dimension 9100
    Pentium(r) D Processor 840 with Dual Core Technology (3.20GHz, 800FSB)

    Memory
    2GB Dual Channel DDR2 SDRAM at 533MHz- 4DIMMs

    Keyboard
    Dell USB Keyboard

    Monitors
    20 inch UltraSharp 2005FPW Widescreen Digital Flat Panel

    Video Cards
    256MB PCI ExpressTM x16 (DVI/VGA/TV-out) ATI RadeonTM X850 XT

    Hard Drives
    250GB Serial ATA Hard Drive (7200RPM) w/DataBurst CacheTM

    Floppy Drive and Media Reader
    3.5 in Floppy Drive

    Operating System
    Microsoft(r) Windows(r) XP Home Edition

    Mouse
    Dell(r) 2-button USB mouse

    Network Interface
    Integrated 10/100 Ethernet

    Modem
    56K PCI Data Fax Modem

    CD or DVD Drive
    Dual Drives: 48x CD-RW Drive + 16x DVD+/-RW w/ double layer write capable
    CDR6DVR

    Sound Card
    Sound Blaster AudigyTM2 ZS (D) Card w/Dolby 5.1, and IEEE 1394
    SBA2

    Speakers
    Dell AS501 10W Flat Panel Attached Spkrs for UltraSharpTM Flat Panels
    AS501

    I can't wait!!!

    Steve

    DB:2.41:Ordered My Dimension 9100 km

    I purchased a Dell 9100 three weeks ago and its been an unsatisfying experience. The CD Rom drives ran and sounded like airplanes when playing CD's, and when not playing music there was a hum and sporadic static from the external speakers and through the headphone jack. The only good thing was the hard drive (250 G) which ran very quiet. Dell sent me a new CPU under warranty to replace the old one.This basically solved some problems and created another. While the CD Rom drives definitely run quieter, and the hum and static are no longer an issue, the 2nd if of the 2 driveswill not play a DVD and worse than that, the hard drive is a combination of snap, crackle and grind, even with the easiest of tasks. It is much noiser than the first. This is completely unacceptable in my mind. Dell finally agreed to send over a tech, who am waiting to hear from, but I suspect the conclusion will be that the hard drive should be replaced. If that is the case, I'll pretty much be done with Dell.

  • RELEVANCY SCORE 2.41

    DB:2.41:Flat File And Idoc ds



    Hi,

    Is it possible to read a flat file and create the sale order through IDoc. Can i do this by DOC_INBOUND_FROM_FILE without XI?? What file format should i pass??

    Regards,

    Kit

    DB:2.41:Flat File And Idoc ds


    Hi Kit, u can do this.

    Setting in ur System

    1.Define Logical System

    2.RFC connection

    3.Defining Port

    4.Created Parner Profile.

    5.Mapping done for

    a. SD EDI Customer/Vendor(VOE2)

    b. SD EDI Conversion(VOE4)

    c. Maintain Customer-Material Info(VD51).

    Inbound IDOC is created.

    kindly reward if found helpful.

    cheers,

    Hema.

  • RELEVANCY SCORE 2.41

    DB:2.41:Target Flat File Two Instances jd



    Hi Guys,

    We have a requirement in project we need to send reports in flat file format, and we need to send two instances in a single flat file.

    please help on this.

    DB:2.41:Target Flat File Two Instances jd


    IMO you can't write output of two files in a single one but I may be wrong.

    You'll need to write the output to 2 seperate files, then in the post session command maybe the 2 files can be combined and their output written to one common file.

  • RELEVANCY SCORE 2.41

    DB:2.41:Oracle To Text sd


    I want to export an oracle table of one-column type to a flat file format .txt or excel ....
    Thank you.

    DB:2.41:Oracle To Text sd

    Hi,
    Where could I find the details or help about UTL_FILE pacage.
    I will appreciate any help.
    Thanks
    Mustafa

  • RELEVANCY SCORE 2.41

    DB:2.41:Best Practice For Ragged Delimited Text Import fc


    I have tab delimited text files which may have optional fields (meaning they can be not present at all) to the right of the required fields that I care about.  It would appear that using a Flat File Connection with Delimited Format (tab) set will choke if it is initially configured with a file that has something like:
     
    data\tdata\tdata\r\n
     
    and it then encounters
     
    data\tdata\tdata\toptionaldata\r\n
     
    It chokes.  I know this could be parsed line by line, but that seems silly.  It seems like there should be a way to ignore columns beyond a certain point (e.g. Format Delimited Ragged Right).
     
    Is there some way to do this with a directly with a flat file connection?
     
    Thanks,
     
    --Andrew

    DB:2.41:Best Practice For Ragged Delimited Text Import fc

    If you are guaranteed to have at least one more column than the required ones, you can configure the columns you care about with the tab delimiter, and then a final column with the CR/LF delimiter that will get the rest of the row.
     
    If not (and it looks like you can't, from your example), then you'll have to configure the last required column with the CR/LF delimiter. That way the last column will hold the last value that you want, and the rest of the row, if it exists. Then use a Derived Column transform with the FINDSTRING and SUBSTRING functions to get everything up to the tab.
     
    Sorry, but I don't think there is an easier solution.

  • RELEVANCY SCORE 2.41

    DB:2.41:Flat File Schema For Jason Format zp


    Hi All,
    Has someone build a Flat file for the Jason Format.I am trying to build a flat file for the following format:

    [
    {
    Key1 : Value
    Key2 : Value
    }
    {
    Key1 : Value
    Key2 : Value


    }
    ]cas1980

    DB:2.41:Flat File Schema For Jason Format zp

    I think I'd be inclined to write a custom pipeline decoder to convert this into XML.
    Here is some information on how to
    convert JSON to XML in .NETIf this is helpful or
    answers your question - please mark accordingly.
    Because I get points for it and gives my life purpose (also helps other people find answers quickly)

  • RELEVANCY SCORE 2.41

    DB:2.41:Converting Custom Flat File To Flat File Of Idoc Type Wmmbid02 p3



    Hi All,

    We have a flat file in some custom format which we need to convert to a standard IDOC format WMMBID02 without creating the IDOC in the system.

    What is the best method to achieve the same?

    What are the possible methods to do this?

    Thanks Regards,

    Shreyas

    DB:2.41:Converting Custom Flat File To Flat File Of Idoc Type Wmmbid02 p3


    This will only work if you have a idoc downloaded as a flatfile in the aplication server. In all other cases you have to write a cuctom program. You need to read the flat file into an internal table and populate the EDID4 and the EDIDC internal tables. For all other cases where you have an existing idoc this will work.

    Go to a server and find yourself an idoc that you want to use as a template.

    Display the idoc using WE19.

    Click Inbound file

    Type in a file name - for example /tmp/test (you need to use an AL11 directory).

    Make sure the option 'Start inbound idoc processing of the file immediately' is unchecked.

    Choose overwrite file

    Then click the tick.

    This will write you an idoc into the AL11 directory structure in the system you are operating in.

    Using the download and upload functions (CG3Z CG3Y), get the file transferred to the production AL11 directories.

    Use WE19 to process your downloaded idoc.

    Use the option 'File as template' to pick up your file.

    You should now be able to process your idoc as you wish

    regards

    Aveek

  • RELEVANCY SCORE 2.40

    DB:2.40:Hey Dogbert.... mj


    ...where is my last post?

    W E W A N T S U P P O R T !!!

    DB:2.40:Hey Dogbert.... mj

    It seemed that you have close contact to Netgear. My hope was, that somebody could tell them, that here are some customers with a Beta-Product. I also own a ReadyNas Device. There I get very good support from the Netgear guys. So why nobody cares about EVA??

  • RELEVANCY SCORE 2.40

    DB:2.40:Standardize Color Across Slides j7


    I have several thousand text slides in which I've marked inidvidual words in either red, green, or blue. Is there someway I can standardize these colors on a file-by-file basis (each file containing over a hunder slides) in a sort of search and replace
    manner? From what I can tell, Powerpoint doesn't recognize RGB color codes.
    Thanks,
    Oliphant

    DB:2.40:Standardize Color Across Slides j7

    Hi,
    If these are hard coded RGB values which don't follow the theme colors then you may need to use some vba code to achieve this. This example shows how:http://skp.mvps.org/pptxp006.htm.

    Regards, Shyam Pillai. http://skp.mvps.org

  • RELEVANCY SCORE 2.40

    DB:2.40:Bcp Command Not Working.. xk


    Hi Guys,
    BCP Command below is not working...please help on it..thanks

    SET @SQLString = 'bcp Exec Automation..[test] '''
    @ID
    ''','''
    @ID2
    ''','''
    @ID3
    ''','''
    @ID4
    ''','''
    @ID5
    ''','''
    @ID6
    ''','''
    @ID7
    ''','''
    @ID8
    ''','''
    @ID9
    '''
    queryout C:\SupportCase_'@Number'.txt -c -T -t 0x7C'

    Error which i am getting is..
    output
    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    usage: bcp {dbtable | query} {in | out | queryout | format} datafile
    [-m maxerrors] [-f formatfile] [-e errfile]
    [-F firstrow] [-L lastrow] [-b batchsize]
    [-n native type] [-c character type] [-w wide character type]
    [-N keep non-text native] [-V file format version] [-q quoted identifier]
    [-C code page specifier] [-t field terminator] [-r row terminator]
    [-i inputfile] [-o outfile] [-a packetsize]
    [-S server name] [-U username] [-P password]
    [-T trusted connection] [-v version] [-R regional enable]
    [-k keep null values] [-E keep identity values]
    [-h load hints] [-x generate xml format file]
    [-d database name]
    NULL

  • RELEVANCY SCORE 2.40

    DB:2.40:Converting Video To Run In Ipad2 Completely Loseless 38



    Hello Everyone,

    I am attemping to make a video to be played on the IPad 2. The video is the EXACT screen resolution of the IPad 2, and my problems is finding a format that will loselessly encode my video. To check this I am using a test pattern video that is one image repeated over and over. the pattern is a repeat of these pixels:

    w=white

    b=blue

    r=red

    w w w w w w

    w b b b b w

    w b r r b w

    w b r r b w

    w b b b b w

    w w w w w w

    this 6x6 grid ia repeated out to the edge of the Ipad's screen. After much testing I cannot find ANY codec in Adobe After Effects CS5 that will give me lossless playback on the IPad. usually the red center gets averaged out to a purple color (and those are the best results I have achieved). I have found numerous encodings that will play back flawlessly on my computer, but those will not play back on the Ipad (of course). I have installed quicktime for windows and therefore got all the quicktime codecs (or at least the ones that come with quicktime), but none of them have been able to do it.

    Does anyone have any thoughts on a way to get lossless video playback on an Ipad? Is there a different program I should use?

    As an aside I am using a compiled RAW AVI file of that same frame repeated as my basis. If you think this could be part of the problem I do have the original image to use as well if you think that will work better.

    Thanks for your help

    Ben

    DB:2.40:Converting Video To Run In Ipad2 Completely Loseless 38


    BBleiman wrote:

    would quicktime Pro do a good job if I wanted

    lossless 720P encoding? Any reccomendation would be helpful.

    Yes, you could use QT Pro, but that's not the point: there is no such thing as a LOSSLESS file that can be played back on an iPad 2. You can have good-looking files, but not lossless files.

    I recommend re-reading Bob Currier's response very carefully: he gave you all the information necessary.

  • RELEVANCY SCORE 2.40

    DB:2.40:Xml To Flat File 8p



    Hi all,

    Scenario:

    R/3 - Proxy - XI - JMS - MQ

    Is it possible to deliver a FLAT FILE to MQ via the JMS adaptor?

    I need to get reed of all the XML tags, since the receiving system is expecting a flat structure.

    Thanks - /Thomas

  • RELEVANCY SCORE 2.40

    DB:2.40:Rate This Dell On A Scale Of 1-10 m7



    Might get this PC:

    Dell 8300 series, Pentium 4- 2.8 GHZ/800FSB INT AUD

    512MB DDR SDRam at 400mhz

    Flat Panel17inch monitor

    128 DDR ATI RDN 9800 W/T

    60GB 7200RPM Ultra, DIM 01

    Win XP Pro

    16X DVD Rom

    SB audigy 2

    Harmon Kardon 395 speakers

    4X DVD+R/RW CDRW combo

    And all the other stuff dell offers...

    Opinions?

    DB:2.40:Rate This Dell On A Scale Of 1-10 m7


    Not bad at all!

    I bought my 8300 with a 3.00GHz 800MHz FSB processor, onboard 5.1 audio (not bad at all!) and the most basic videocard. Ireplaced the videocard fora ATI Radion 9000 AIW (i don't play many games but like to watch tv on my PC) and i added a S-ATA Harddisk as systemdisk (WD Raptor 36.7Gb 10.000rpm 5.2ms 8Mb cache) and i think i replace the shipped EIDE dive as well (seagate 120Gb 2Mb cache). The system is VERY, VERYfast and now mainly used for video-editing.

  • RELEVANCY SCORE 2.40

    DB:2.40:Idoc Flat File To R/3 dx



    Hi,

    I have a scenario where Idoc is generated from EDI mapping tool in plain text format. I want to post this Idoc to R/3 without using any third party tool. Is there any configuration required on R/3 side?

    I am planning to write ABAP but not sure if it can be done directly in SAP R/3/ERP.

    Regards,

    Gourav

    DB:2.40:Idoc Flat File To R/3 dx


    Thanks Kohn,

    I'll work out this and will post the outcome.

    Regards,

    Gourav

  • RELEVANCY SCORE 2.40

    DB:2.40:Open Menu Is Not Trigging 78


    Hi,
    One of my site, the second Open Menu is not triggering.
    While debug the script via developer tool, In core.js file throwing Parse error like below.

    \r\n!DOCTYPE html PUBLIC \-//W3C//DTD XHTML 1.0 Strict//EN\\r\n\http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\\r\n
    html xmlns:o=\urn:schemas-microsoft-com:office:office\ lang=\en-us\ dir=\ltr\\r\nheadmeta name=\GENERATOR\ content=\Microsoft SharePoint\ /meta http-equiv=\Content-Type\
    content=\text/html; charset=utf-8\ /meta http-equiv=\Expires\ content=\0\ /meta http-equiv=\X-UA-Compatible\ content=\IE=8\/meta name=\ROBOTS\ content=\NOHTMLINDEX\
    /title\r\n\t\r\n\tError\r\n\r\n/titlelink rel=\stylesheet\ type=\text/css\ href=\/_layouts/15/1033/styles/corev15.css?rev=5vnvqGmlkKiZE7lIH7ENng%3D%3D\/\nlink rel=\stylesheet\
    type=\text/css\ href=\/_layouts/15/1033/styles/error.css?rev=nc1850SZNy60qTAeQIRxsA%3D%3D\/\nscript type=\text/javascript\ src=\/_layouts/15/init.js?rev=ZCyl%2Bj%2B4NZLoeodWTEXQ0Q%3D%3D\/script\nscript
    type=\text/javascript\ src=\/ScriptResource.axd?d=qvRpxaVLaaFid92KEUuOTmg8XGazP-pVJyY2te1s5C8ywj7lZ8Nyait_RiuIIZWOGiVdg-od6nk9AZKtgfpVBEXNRqEQoH56OtDKRkkpqizmHOZFRlUtnSGYKEnt0-lxPg0ddbTumBYU_lVUWuUrHYlp_9eXISceY9dye8FRlrf4oIAXgNAxnlc3cBvJA2-J0amp;t=6119e399\/script\nscript
    type=\text/javascript\ src=\/_layouts/15/blank.js?rev=ZaOXZEobVwykPO9g8hq%2F8A%3D%3D\/script\nscript type=\text/javascript\ src=\/ScriptResource.axd?d=I-b0o2hi8Z-5MncdGXGUy-U2u3SJ1NDR10gKQs71mb952-Eahz9thb-JIoSEuPLZMe7U9VqCW3AJLGcGmuOYDAh9dbcGGzfPIzKs4LapQITf9fbP9KuhxdYv0nrBl-xIc4tZtN29pNN-JqTWx2LgBjzookeASKw4Z8j7xGfQJ_v90eT-GmQcwok3MKFXMWVs0amp;t=6119e399\/script\nscript
    type=\text/javascript\RegisterSod(\initstrings.js\, \\\u002f_layouts\\u002f15\\u002f1033\\u002finitstrings.js?rev=uNmvBiHdrBzcPQzXRpm\\u00252FnQ\\u00253D\\u00253D\);/script\nscript type=\text/javascript\RegisterSod(\strings.js\,
    \\\u002f_layouts\\u002f15\\u002f1033\\u002fstrings.js?rev=DY9A0USYODVw86N0trJTSw\\u00253D\\u00253D\);RegisterSodDep(\strings.js\, \initstrings.js\);/script\nscript type=\text/javascript\RegisterSod(\sp.init.js\,
    \\\u002f_layouts\\u002f15\\u002fsp.init.js?rev=QI1yUCfCoUkadL93jNZLOg\\u00253D\\u00253D\);/script\nscript type=\text/javascript\RegisterSod(\sp.res.resx\, \\\u002f_layouts\\u002f15\\u002fScriptResx.ashx?culture=en\\u00252Dus\\u0026name=SP\\u00252ERes\\u0026rev=yNk\\u00252FhRzgBn40LJVP\\u00252BqfgdQ\\u00253D\\u00253D\);/script\nscript
    type=\text/javascript\RegisterSod(\sp.ui.dialog.js\, \\\u002f_layouts\\u002f15\\u002fsp.ui.dialog.js?rev=0xf6wCIW4E1pN83I9nSIJQ\\u00253D\\u00253D\);RegisterSodDep(\sp.ui.dialog.js\, \sp.init.js\);RegisterSodDep(\sp.ui.dialog.js\,
    \sp.res.resx\);/script\nscript type=\text/javascript\RegisterSod(\core.js\, \\\u002f_layouts\\u002f15\\u002fcore.js?rev=\\u00252FmcwmyWAFSbQRHlXU4BIBg\\u00253D\\u00253D\);RegisterSodDep(\core.js\,
    \strings.js\);/script\nscript type=\text/javascript\RegisterSod(\foldhyperlink.js\, \\\u002f_layouts\\u002f15\\u002ffoldhyperlink.js?rev=JnjM4kpe0i1y9awK3p5UJw\\u00253D\\u00253D\);/script\n\r\n\tmeta
    name=\Robots\ content=\NOINDEX \ /\r\n\tmeta name=\SharePointError\ content=\0\ /\r\nlink rel=\shortcut icon\ href=\/_layouts/15/images/favicon.ico?rev=23\ type=\image/vnd.microsoft.icon\
    //head\r\nbody id=\ms-error-body\ onload=\if (typeof(_spBodyOnLoadWrapper) != 'undefined') _spBodyOnLoadWrapper();\\r\n\tform method=\post\ action=\error.aspx?Cmd=Ctxamp;List=%7b16E6B8C8-4701-4E26-B01B-4849F5312D38%7damp;View=%7b21FE5743-7F84-478A-AE43-4BC312322FB7%7damp;ViewCount=57amp;IsXslView=TRUEamp;Field=LinkFilenameamp;IsCSR=TRUEamp;CustomAction=TRUEamp;ID=25amp;ListViewPageUrl=https%3a%2f%2fpww.icop.petronas.com.my%2fcommon%2fktube%2fcop_drillingKtube%2fForms%2fAllItems.aspxamp;sourceurl=https%3a%2f%2fpww.icop.petronas.com.my%2fcop%2fcop_drillingamp;mstIndex=O\
    id=\aspnetForm\ onsubmit=\if (typeof(_spFormOnSubmitWrapper) != #39;undefined#39;) {return _spFormOnSubmitWrapper();} else {return true;}\\r\ndiv class=\aspNetHidden\\r\ninput type=\hidden\
    name=\__EVENTTARGET\ id=\__EVENTTARGET\ value=\\ /\r\ninput type=\hidden\ name=\__EVENTARGUMENT\ id=\__EVENTARGUMENT\ value=\\ /\r\ninput type=\hidden\
    name=\__VIEWSTATE\ id=\__VIEWSTATE\ value=\/wEPBSpWU0tleTo1NjJiMDc0MS0xMmViLTRhZTktODA1ZS05N2JhOTg0YWZkM2RkwpX8Q4tiJyTcvphoR7NAxNyqIf/8DlQuelokfMSCE=\ /\r\n/div\r\n\r\nscript type=\text/javascript\\r\n//![CDATA[\r\nvar
    theForm = document.forms['aspnetForm'];\r\nif (!theForm) {\r\n theForm = document.aspnetForm;\r\n}\r\nfunction __doPostBack(eventTarget, eventArgument) {\r\n if (!theForm.onsubmit || (theForm.onsubmit() != false)) {\r\n
    theForm.__EVENTTARGET.value = eventTarget;\r\n theForm.__EVENTARGUMENT.value = eventArgument;\r\n theForm.submit();\r\n }\r\n}\r\n//]]\r\n/script\r\n\r\n\r\nscript
    src=\/WebResource.axd?d=vA9K_GFncL0hedB8j9wu3b_y4Hk8RCEosCHo6ZwH7RiNm6fZ9L-D44-l1AOXl_EoOvLgPdbyoWzbF5ug_3dwPuT73j0xGPcjLXfLP_xtZZU1amp;t=635091197518590119\ type=\text/javascript\/script\r\n\r\n\r\nscript type=\text/javascript\\r\n//![CDATA[\r\nvar
    g_presenceEnabled = true;\nvar g_wsaEnabled = false;\nvar g_wsaQoSEnabled = false;\nvar g_wsaQoSDataPoints = [];\nvar g_wsaLCID = 1033;\nvar g_wsaListTemplateId = null;\nvar g_wsaSiteTemplateId = 'BLANKINTERNET#0';\nvar _fV4UI=true;var _spPageContextInfo =
    {webServerRelativeUrl: \\\u002f\, webAbsoluteUrl: \https:\\u002f\\u002fpww.icop.petronas.com.my\, siteAbsoluteUrl: \https:\\u002f\\u002fpww.icop.petronas.com.my\, serverRequestPath: \\\u002f_layouts\\u002f15\\u002finplview.aspx\,
    layoutsUrl: \_layouts\\u002f15\, webTitle: \iCOP\, webTemplate: \53\, tenantAppVersion: \0\, webLogoUrl: \_layouts\\u002f15\\u002fimages\\u002fsiteicon.png\, webLanguage: 1033, currentLanguage: 1033,
    currentUICultureName: \en-US\, currentCultureName: \en-US\, clientServerTimeDelta: new Date(\2014-09-30T10:32:49.4164719Z\) - new Date(), siteClientTag: \1111$$15.0.4535.1000\, crossDomainPhotosEnabled:false,
    webUIVersion:15, webPermMasks:{High:2147483647,Low:4294967295},pageListId:\{16e6b8c8-4701-4e26-b01b-4849f5312d38}\, pagePersonalizationScope:1,userId:113, systemUserKey:\i:0\\u0029.w|s-1-5-21-1879313195-520974944-4223779719-341431\,
    alertsEnabled:true, siteServerRelativeUrl: \\\u002f\, allowSilverlightPrompt:'True'};//]]\r\n/script\r\n\r\nscript src=\/_layouts/15/blank.js?rev=ZaOXZEobVwykPO9g8hq%2F8A%3D%3D\ type=\text/javascript\/script\r\nscript
    type=\text/javascript\\r\n//![CDATA[\r\nif (typeof(DeferWebFormInitCallback) == 'function') DeferWebFormInitCallback();//]]\r\n/script\r\n\r\n\tscript type=\text/javascript\\r\n//![CDATA[\r\nSys.WebForms.PageRequestManager._initialize('ctl00$ScriptManager',
    'aspnetForm', [], [], [], 90, 'ctl00');\r\n//]]\r\n/script\r\n\r\n\tdiv id=\ms-error-header\ class=\ms-pr\\r\n\t\th1 class=\ms-core-pageTitle\\r\n\t\t\t\r\n\tdiv id=\ctl00_PlaceHolderPageTitleInTitleArea_ErrorPageTitlePanel\\r\n\t\r\n\tSorry,
    something went wrong\r\n/div\r\n\r\n\t\t/h1\r\n\t\tdiv\r\n\t\t\t\r\n\t\t/div\r\n\t/div\r\n\tdiv id=\ms-error\\r\n\t\tdiv id=\ms-error-top\\r\n\t\t\t\r\n\t\t/div\r\n\t\tdiv
    id=\ms-error-content\\r\n\t\t\tdiv id=\ms-error-error-content\\r\n\t\t\t\tdiv id=\DeltaPlaceHolderMain\\r\n\t\r\n\t\t\t\t\t\r\n\t\r\n\t\r\n\tdiv\r\n\t\tspan id=\ctl00_PlaceHolderMain_LabelMessage\File
    Not Found./span\r\n\t/div\r\n\tdiv id=\ctl00_PlaceHolderMain_FoldPanel\ class=\ms-error-detailsFold\\r\n\t\t\r\n\t\tdiv id=\ctl00_PlaceHolderMain_FoldLink_foldLinkWrapper\\r\n\t\t\t\r\n\tdiv
    id=\ctl00_PlaceHolderMain_FoldLink_foldLinkPanel\ class=\ms-foldHyperLink-panel\ onclick=\EnsureScriptParams(#39;foldhyperlink.js#39;, #39;ToggleFoldText#39;, #39;ef0ddef0d20e46a8bfacc946b4644ad0#39;,
    #39;ctl00_PlaceHolderMain_FoldLink__moreDetailsLink#39;, #39;Technical Details#39;, #39;Technical Details#39;);;return false;\\r\n\t\t\t\t\r\n\t\ta id=\ctl00_PlaceHolderMain_FoldLink__moreDetailsLink\
    class=\ms-commandLink ms-floatLeft\ href=\#\ onclick=\PreventDefaultNavigation();\Technical Details/a\r\n\t\tdiv class=\ms-clear\/div\r\n\t\r\n\t\t\t/div\r\n\r\n\t\t/divdiv
    class=\ms-hide\ id=\ef0ddef0d20e46a8bfacc946b4644ad0\\r\n\r\n\t\t\tdiv\r\n\t\t\t\tp\r\n\t\t\t\t\tspan class=\ms-descriptiontext\\r\n\t\t\t\t\t\r\n\t\t\t\t\t/span\r\n\t\t\t\t/p\r\n\t\t\t\tp\r\n\t\t\t\t\tspan
    class=\ms-descriptiontext\\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\tdiv id=\ctl00_PlaceHolderMain_FoldLink_WSSEndUser_troubleshootingPanel\\r\n\t\t\t\r\n\t\t\t\t\t\t\tspan id=\ctl00_PlaceHolderMain_FoldLink_helptopic_WSSEndUser_troubleshooting\a
    title=\Troubleshoot issues with Microsoft SharePoint Foundation. - Opens in new window\ href=\javascript:HelpWindowKey('WSSEndUser_troubleshooting')\Troubleshoot issues with Microsoft SharePoint Foundation./a/span\r\n\t\t\t\t\t\t\r\n\t\t/div\r\n\t\t\t\t\t/span\r\n\t\t\t\t/p\r\n\t\t\t\tp\r\n\t\t\t\t\tspan
    id=\ctl00_PlaceHolderMain_FoldLink_RequestGuidText\ class=\ms-metadata\Correlation ID: b784bd9c-ae9a-503f-5817-c8f0536a4ef2/span\r\n\t\t\t\t/p\r\n\t\t\t\tp\r\n\t\t\t\t\tspan id=\ctl00_PlaceHolderMain_FoldLink_DateTimeText\
    class=\ms-metadata\Date and Time: 9/30/2014 6:32:49 PM/span\r\n\t\t\t\t/p\r\n\t\t\t/div\r\n\t\t/div\r\n\t\r\n\t/div\r\n\tdiv class=\ms-error-techMsg\\r\n\t\thr /\r\n\t/div\r\n\tscript
    type=\text/javascript\// ![CDATA[ \n\r\n\r\n\t\tvar gearPage = document.getElementById('ms-loading-box');\r\n\t\tif(null != gearPage)\r\n\t\t{\r\n\t\t\tgearPage.parentNode.removeChild(gearPage);\r\n\t\t\tdocument.title = \Error\;\r\n\t\t}\r\n\t\tfunction
    _spBodyOnLoad()\r\n\t\t{\r\n\t\t\tvar intialFocus = (document.getElementById(\ctl00_PlaceHolderMain_FoldLink__moreDetailsLink\));\r\n\t\t\ttry\r\n\t\t\t{\r\n\t\t\t\tintialFocus.focus();\r\n\t\t\t}\r\n\t\t\tcatch(ex)\r\n\t\t\t{\r\n\t\t\t}\r\n\t\t}\r\n\t//
    ]]\r\n/script\r\n\r\n\t\t\t\t\r\n/div\r\n\t\t\t/div\r\n\t\t\t\r\n\t\t\t\tdiv id=\ms-error-gobackcont\ class=\ms-calloutLink\\r\n\t\t\t\t\ta href=\/\ class='ms-calloutLink' id=\ctl00_PlaceHolderGoBackLink_idSimpleGoBackToHome\Go
    back to site/a\r\n\t\t\t\t/div\r\n\t\t\t\r\n\t\t/div\r\n\t/div\r\n/form\r\n/body\r\n/html\r\n

    but I am using one handler to change the master page based on the library name.
    Please share your ideas

    DB:2.40:Open Menu Is Not Trigging 78

    Hi Victoria,
    I believe the below info is some what clear.
    1. Root site [iRSite] - (Publishing Site ) - Custom Master Page
    - Pages, Library and List
    2. SiteCollection - [RSite]- (Team Site ), have 50 SiteCollection, 45 site have - Orange Template (MasterPage), 3 site have - Blue Template (MasterPage), and 2 site have - Gray Template (MasterPage).
    - Pages, Library and List
    3. SiteCollection - [RcomSite] - (Team Site)- Custom Master Page (Same iRSite MasterPage), Have 3 site collections.
    1. Site collection - Only for Videos
    2. Site Collection - Only for Discussion
    3. Site Collection - Only for Wiki Pages.
    Which are all comes under RSite mapped path sitecollection, those sitecollections related videos, discussion, and Wiki page libraries are Maintaining in the [RComSite] mapped path sitecollections respectively.
    and the library name is like :
    RSite sitecollection name is ABCSite na,
    the Video library name is ABCSiteTube
    the Discussion board name is ABCSiteDiscuss
    the Wiki folder name is ABCSiteWiki.

    Scenario 1:
    Lets say , IfABCSite template is ORANGE
    I am going from ABCSite to Video site to the corresponding libraryABCSiteVideo, I am passing one Querystring values = O, based on the QueryString value i am overriding the master page for the particular page. applying Orange Master page
    If am going for any gray template site to [RCSite] site collection, I need to change the master page based on the query string value = G, applying Gray master page.
    Same for Blue template site.

    Scenario 2:
    If admin gose to directly to RCSite [let say Tube site, Discussion site, Wiki Site] the default custom master page will display.
    But, If he select ABCSiteTube , we are displaying theABCSite master page [Orange Master Page].
    If he selectABCSiteWiki libarary, we are displayinbg Oranage Master page.
    if he selectABCSiteDiscussion, we are displaying Oranger master page

    By Handler.
    If he select any Blue Template related Video, Wiki and Discussion libraries , we need to display Blue template master page instead of default master page.
    similar for Gray template.

    All master page changes are done by handler using query string value.

    This is my functionality.

    Please share your ideas.

  • RELEVANCY SCORE 2.40

    DB:2.40:Loading Flat File For Budget Value In Sap Bi -Need Format fj



    Dear all,

    we have a report in which we have a key figure Budget Price which we have to load from flat file for material.

    we have pulled all required data from r/3 the layout of report is like this (except budget price which we have to upload from Flat file)

    the report fields are like this

    Material code

    Vendor code Vendor name

    Plant

    Purchase Org

    Purchase Order

    Purchase order date

    landed price

    Budget price

    Variance (budget price-landed price)

    (we pulled all the fields data above ...except budget price above)

    so please suggest me FLAT FILE structure , what all the fields i have to include in the flat file

    and i am thinking to upload this flat file to a infocube and create a multiprovider over 0pur_c01 and this infocube (zinfocube)

    Also help me with the step by step process of loading a flat file from application server

    regards

    DB:2.40:Loading Flat File For Budget Value In Sap Bi -Need Format fj


    variance is calculated based on budget price which has to be uploaded from flat file.

    and also

    if I Use only material code and budget price to create my IC and then multiprovider.

    then in my report when i join multiprovider using only material...and my report has plant, purchorg,Purchase order number .PO Date and then these kf's if i join only using material ..in my report i cant see the kf's against other characeteristics right?

    can you suggest me file format....based on the fields i have mentioned above..

  • RELEVANCY SCORE 2.40

    DB:2.40:How To Upload A Flat File Which Is Saved As .Html Format. z3



    hi techies,

    I have to upload a flat file which is saved in .HTML format. Is there any function moudles seperately to

    upload html flat file or using GUI_UPLOAD.. can we upload it ???

    Please need a suggestion...

    Rgds.,

    subash

    DB:2.40:How To Upload A Flat File Which Is Saved As .Html Format. z3


    hi gautam,

    this FM is taking html string as input and giving the output, not the file...

    any more suggesstions dude..

    Rgds.,

    subash

  • RELEVANCY SCORE 2.40

    DB:2.40:Bdc fp



    Hi,

    Suppose i have a flat file data with fields:

    Empno name dept date

    Now i want to migrate this data into SAP R/3 database. But the date field

    format is in german mode. How can it will be converted to our SAP R/3

    date format, while uploading to internal table, without changing the settings?

    DB:2.40:Bdc fp


    Hi,

    Set sy-langu to 'en' or set system language to english and by the way there's no effect of german mode on data uploading may be data may be uploaded in english or in german format u can change it later on to any language.

    Regards,

    Ameet

  • RELEVANCY SCORE 2.40

    DB:2.40:Flat File With Different Date Format d3



    Hi,

    I have create a flat file with different date format.

    Eg :

    ID Name Pur_Date Location Exp_Date

    01 Gan 01-1-2012 UK 20-12-2013 05:22:10

    How to change the flat file and load to target file in database.

    plz help

    Thanks

    Ganesh

    DB:2.40:Flat File With Different Date Format d3


    Hi Ganesh,

    Date is very tuff data type to Handel.

    try to read date as string column and as you claming that formats are different

    use a decode function to identify the format and convert that date into one standard date format which is easily loaded into data base.

    informatica can support date upto nano seconds.

    but coming to date with formats like cyymmdd then you have make your won transformation logic.

    Regards,

    Sanjeevi

  • RELEVANCY SCORE 2.40

    DB:2.40:Weird Random Websites In My Memory.Dmp 3z


    So my PC bluescreened for the first time ever (which isn't the point of this thread) tonight and I hadn't the slightest clue on how to read my MEMORY.DMP, so I decided to start with Notepad, eventually getting to opening it with specifically the UTF-8 encoding
    option selected. At the bottom, it has this random string of what seems to be garbled HTML and websites that I have never visited before, but with a space in between each character.
    e t / m r s k i n . p h p " ]
    a c t i v i s t p o s t . c o m # # a \ [ h r e f = " h t t p : / / w w w . b l o g g e r s e c r e t . c o m / " ]
    h s c r i p t s . c o m # # a \ [ h r e f = " h t t p : / / w w w . b u i l d m y l i n k . c o m " ]
    d e s i v i d e o n e t w o r k . c o m # # a \ [ h r e f = " h t t p : / / w w w . d e s i a c t i o n . c o m " ]
    d i a b l o 3 b u i l d s . c o m # # a \ [ h r e f = " h t t p : / / w w w . d i a b l o 3 b u i l d s . c o m / b c " ]
    d i r w e l l . c o m # # a \ [ h r e f = " h t t p : / / w w w . d i r w e l l . c o m / s u b m i t . p h p " ]
    d l l e r r o r s - f i x . c o m # # a \ [ h r e f = " h t t p : / / w w w . d l l e r r o r s - f i x . c o m / D o w n l o a d . p h p " ]
    d l 4 a l l . c o m # # a \ [ h r e f = " h t t p : / / w w w . e n g i n e s o n g . c o m " ]
    i p h o n e c a k e . c o m # # a \ [ h r e f = " h t t p : / / w w w . f i l e p u p . n e t / g e t - p r e m i u m . p h p " ]
    i n t e r u p l o a d . c o m # # a \ [ h r e f = " h t t p : / / w w w . f i l e s e r v i n g . c o m / " ]
    f i n a n c i a l s u r v i v a l n e t w o r k . c o m # # a \ [ h r e f = " h t t p : / / w w w . h a r d a s s e t s c h i . c o m / " ]
    s c a m . c o m # # a \ [ h r e f = " h t t p : / / w w w . i p - a d r e s s . c o m / t r a c e _ e m a i l / " ]
    n i c h e p u r s u i t s . c o m # # a \ [ h r e f = " h t t p : / / w w w . l o n g t a i l p r o . c o m " ]
    m a k e u s e o f . c o m # # a \ [ h r e f = " h t t p : / / w w w . m a k e u s e o f . c o m / a d v e r t i s e / " ]
    n i c h e p u r s u i t s . c o m # # a \ [ h r e f = " h t t p : / / w w w . n i c h e p u r s u i t s . c o m / w h p " ]
    n i c h e p u r s u i t s . c o m # # a \ [ h r e f = " h t t p : / / w w w . n i c h e w e b s i t e t h e m e . c o m " ]
    n a i j a b o r n . c o m # # a \ [ h r e f = " h t t p : / / w w w . n j o r k u . c o m / n i g e r i a " ] i m g
    t h e t r u t h a b o u t g u n s . c o m # # a \ [ h r e f = " h t t p : / / w w w . s h o o t e r s u s a . n e t " ] i m g
    l e t m e s i n g t h i s . c o m # # a \ [ h r e f = " h t t p : / / w w w . s i n g o r a m a . m e " ]
    t e l e p i s o d e s . n e t # # a \ [ h r e f = " h t t p : / / w w w . t e l e p i s o d e s . n e t / d o w n l o a d t v s e r i e s . p h p " ]
    f r e e - w a l l p a p e r - d o w n l o a d . c o m # # a \ [ h r e f = " h t t p : / / w w w . t h o o s j e . c o m / t o o l b a r . h t m l " ]
    s i t e v a l u e c a l c u l a t o r . c o m # # a \ [ h r e f = " h t t p : / / w w w . t o p - s i t e - l i s t . c o m " ]
    q u i c k s i l v e r s c r e e n . c o m # # a \ [ h r e f = " h t t p : / / w w w . t u b e p l u s . c o m " ]
    v i d b u x . c o m # # a \ [ h r e f = " h t t p : / / w w w . v i d b u x . c o m / c c o u n t / c l i c k . p h p ? i d = 4 " ]
    v i v a p r o g r a m s . c o m # # a \ [ h r e f = " h t t p : / / w w w . v i v a u s b . c o m " ]
    w a t c h o p . c o m # # a \ [ h r e f = " h t t p : / / w w w . w a t c h o p . c o m / d o w n l o a d . p h p " ]
    l i n d a i k e j i . b l o g s p o t . c o m # # a \ [ h r e f = " h t t p : / / w w w . y o u w i n . o r g . n g / " ] i m g
    z i d d u . c o m # # a \ [ h r e f = " h t t p : / / w x d o w n l o a d m a n a g e r . c o m / z d d / " ]
    z m e a - l o g . b l o g s p o t . c o m # # a \ [ h r e f = " h t t p : / / z m e a - l o g . b l o g s p o t . c o m / p / r a p i d s - f o r - s a l e . h t m l " ]
    w e m i n e a l l . c o m , w e m i n e l t c . c o m # # a \ [ h r e f = " h t t p s : / / d i c e l i t e c o . i n " ]
    u g o t f i l e . c o m # # a \ [ h r e f = " h t t p s : / / w w w . a s t r i v

    Here's the full file: http://1drv.ms/TQktIE

    This is weird, because I just visited some of these websites (some of them are blank, others are scams) and I haven't visited one that I've seen on that list since the check in Notepad.

    I'd just like to show everyone this weird thing that I have noticed. Anyone know what its purpose is?

    DB:2.40:Weird Random Websites In My Memory.Dmp 3z

    You may have a wrong dump file. This issue occurs because the dump generation logic saves the processor context to the dump file incorrectly on a computer that has the XState feature enabled.

    Loading Dump File [C:\Users\eigenaar\Desktop\Mini120511-02.dmp]
    Mini Kernel Dump File: Only registers and stack trace are available

    Symbol search path is: *** Invalid ***
    ****************************************************************************
    * Symbol loading may be unreliable without a symbol search path. *
    * Use .symfix to have the debugger choose a symbol path. *
    * After setting your symbol path, use .reload to refresh symbol locations. *
    ****************************************************************************
    Executable search path is:
    *********************************************************************
    * Symbols can not be loaded because symbol path is not initialized. *
    * *
    * The Symbol Path can be set by: *
    * using the _NT_SYMBOL_PATH environment variable. *
    * using the -y symbol_path argument when starting the debugger. *
    * using .sympath and .sympath+ *
    *********************************************************************
    Unable to load image ntoskrnl.exe, Win32 error 0n2
    *** WARNING: Unable to verify timestamp for ntoskrnl.exe
    *** ERROR: Module load completed but symbols could not be loaded for ntoskrnl.exe
    Windows XP Kernel Version 2600 (Service Pack 3) MP (2 procs) Free x86 compatible
    Product: WinNt, suite: TerminalServer SingleUserTS
    Machine Name:
    Kernel base = 0x804d7000 PsLoadedModuleList = 0x8055d720
    Debug session time: Mon Dec 5 11:20:53.155 2011 (UTC + 1:00)
    System Uptime: 0 days 1:12:14.924
    *********************************************************************
    * Symbols can not be loaded because symbol path is not initialized. *
    * *
    * The Symbol Path can be set by: *
    * using the _NT_SYMBOL_PATH environment variable. *
    * using the -y symbol_path argument when starting the debugger. *
    * using .sympath and .sympath+ *
    *********************************************************************
    Unable to load image ntoskrnl.exe, Win32 error 0n2
    *** WARNING: Unable to verify timestamp for ntoskrnl.exe
    *** ERROR: Module load completed but symbols could not be loaded for ntoskrnl.exe
    Loading Kernel Symbols
    ...............................................................
    ............................................
    Loading User Symbols
    Loading unloaded module list
    .......
    Unable to load image win32k.sys, Win32 error 0n2
    *** WARNING: Unable to verify timestamp for win32k.sys
    *** ERROR: Module load completed but symbols could not be loaded for win32k.sys
    *******************************************************************************
    * *
    * Bugcheck Analysis *
    * *
    *******************************************************************************

    Use !analyze -v to get detailed debugging information.

    BugCheck 10000050, {f000e2c3, 8, f000e2c3, 0}

    ***** Kernel symbols are WRONG. Please fix symbols to do analysis.

    *************************************************************************
    *** ***
    *** ***
    *** Your debugger is not using the correct symbols ***
    *** ***
    *** In order for this command to work properly, your symbol path ***
    *** must point to .pdb files that have full type information. ***
    *** ***
    *** Certain .pdb files (such as the public OS symbols) do not ***
    *** contain the required information. Contact the group that ***
    *** provided you with these symbols if you need this command to ***
    *** work. ***
    *** ***
    *** Type referenced: nt!_KPRCB ***
    *** ***
    *************************************************************************
    *************************************************************************
    *** ***
    *** ***
    *** Your debugger is not using the correct symbols ***
    *** ***
    *** In order for this command to work properly, your symbol path ***
    *** must point to .pdb files that have full type information. ***
    *** ***
    *** Certain .pdb files (such as the public OS symbols) do not ***
    *** contain the required information. Contact the group that ***
    *** provided you with these symbols if you need this command to ***
    *** work. ***
    *** ***
    *** Type referenced: nt!KPRCB ***
    *** ***
    *************************************************************************
    *************************************************************************
    *** ***
    *** ***
    *** Your debugger is not using the correct symbols ***
    *** ***
    *** In order for this command to work properly, your symbol path ***
    *** must point to .pdb files that have full type information. ***
    *** ***
    *** Certain .pdb files (such as the public OS symbols) do not ***
    *** contain the required information. Contact the group that ***
    *** provided you with these symbols if you need this command to ***
    *** work. ***
    *** ***
    *** Type referenced: nt!_KPRCB ***
    *** ***
    *************************************************************************
    *************************************************************************
    *** ***
    *** ***
    *** Your debugger is not using the correct symbols ***
    *** ***
    *** In order for this command to work properly, your symbol path ***
    *** must point to .pdb files that have full type information. ***
    *** ***
    *** Certain .pdb files (such as the public OS symbols) do not ***
    *** contain the required information. Contact the group that ***
    *** provided you with these symbols if you need this command to ***
    *** work. ***
    *** ***
    *** Type referenced: nt!KPRCB ***
    *** ***
    *************************************************************************
    *************************************************************************
    *** ***
    *** ***
    *** Your debugger is not using the correct symbols ***
    *** ***
    *** In order for this command to work properly, your symbol path ***
    *** must point to .pdb files that have full type information. ***
    *** ***
    *** Certain .pdb files (such as the public OS symbols) do not ***
    *** contain the required information. Contact the group that ***
    *** provided you with these symbols if you need this command to ***
    *** work. ***
    *** ***
    *** Type referenced: nt!_KPRCB ***
    *** ***
    *************************************************************************
    *************************************************************************
    *** ***
    *** ***
    *** Your debugger is not using the correct symbols ***

  • RELEVANCY SCORE 2.40

    DB:2.40:Determine A Excel File Exists Or Not By Active X pm


    I w a n t t o a d d t h e d i f f e r e n t d a t a a b o u t a s p e c i f i e d U U T t o d i f f e r n t w o r k s h e e t o f a s p e c i f i e d w o r k b o o k s . I f t h i s w o r k b o o k d o e s ' t e x i s t , t h e n c r e a t i t a n d s t o r e t h e d a t a . I f t h i s w o r k b o o k a l r e a d y e x i s t , t h e n o p e n i t a n d s t o r e t h e d a t e i n a n e w w o r k s h e e t . B u t h o w c a n t h e p r o g r a m k n o w w h e t h e r t h e e x c e l 9 7 f i l e e x i s t a u t o m a t i c a l l y ? T h e q u e s t i o n a b o v e i s b a s e d o n l a b v i e w 5 . 1 a c t i v e x a n d e x c e l 9 7 .

    DB:2.40:Determine A Excel File Exists Or Not By Active X pm

    Use Workbooks.Open(...) method which takes the XLS file pathto open. It returns a reference to the Workbook object if succeeded.Otherwise this action raises a COM exception. Sorry but I don'tknow how to handle COM exceptions in a general way. (I thinkthe Error Out control may report an error if failed.)Makoto"east" wrote in messagenews:50650000000800000009160000-983677784000@quiq.​com... I w a n t t o a d d t h e d i f f e r e n t d a t a a b o u t a s p e c i f i e d U U T t o d i f f e r n t w o r k s h e e t o f a s p e c i f i e d w o r k b o o k s . I f t h i s w o r k b o o k d o e s ' t e x i s t , t h e n c r e a t i t a n d s t o r e t h e d a t a . I f t h i s w o r k b o o k a l r e a d y e x i s t , t h e n o p e n i t a n d s t o r e t h e d a t e i n a n e w w o r k s h e e t . B u t h o w c a n t h e p r o g r a m k n o w w h e t h e r t h e e x c e l 9 7 f i l e e x i s t a u t o m a t i c a l l y ? T h e q u e s t i o n a b o v e i s b a s e d o n l a b v i e w 5 . 1 a c t i v e x a n d e x c e l 9 7