How to know whether the CSV extraction to PF happened today
I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the [...]
Answer Question
| January 10, 2013 6:31 AM
AS/400, CSV, Physical File
I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the [...]
Answer Question
| January 10, 2013 6:31 AM
AS/400, CSV, Physical File
Take .csv files and show that on a subfile
Hi all, I am pretty new to this type of requirement. There are some .csv fiels in AS400 IFS follder. When user choose to the option – upload from the IFS folder from the menu, I need to show those .csv files as a subfile. From that subfile, user can select the csv file with [...]
Answer Question
| September 11, 2012 12:35 PM
CSV
Hi all, I am pretty new to this type of requirement. There are some .csv fiels in AS400 IFS follder. When user choose to the option – upload from the IFS folder from the menu, I need to show those .csv files as a subfile. From that subfile, user can select the csv file with [...]
Answer Question
| September 11, 2012 12:35 PM
CSV
Crystal Reports CSV with quotes inside string
I need to export a CR XI report to csv. Some of the fields allow users to use double quotes to indicate inches. When exported to CSV I get something like this: “Andy”, 4685, “requires 5″ by 2″ silver plate”, 1132 According to CSV standard it should be: “Andy”, 4685, “requires 5″” by 2″” silver [...]
Answer Question
| May 24, 2012 4:26 PM
Crystal Report formula, Crystal Report XI, CSV
I need to export a CR XI report to csv. Some of the fields allow users to use double quotes to indicate inches. When exported to CSV I get something like this: “Andy”, 4685, “requires 5″ by 2″ silver plate”, 1132 According to CSV standard it should be: “Andy”, 4685, “requires 5″” by 2″” silver [...]
Answer Question
| May 24, 2012 4:26 PM
Crystal Report formula, Crystal Report XI, CSV
QEXECSQL command source
Hello, I am trying to implement a command ZCPYTOCSV. THis command uses ZFFDTOCSV and ZEXECSQL commands. I have the source of ZFFDTOCSV but cannot find the source for command ZEXECSQL. If anyone has access to this – could you please let me know. Alternatively is there is another better utility for copying Database file to [...]
Answer Question
| May 27, 2012 9:37 AM
CSV, OS/400
Hello, I am trying to implement a command ZCPYTOCSV. THis command uses ZFFDTOCSV and ZEXECSQL commands. I have the source of ZFFDTOCSV but cannot find the source for command ZEXECSQL. If anyone has access to this – could you please let me know. Alternatively is there is another better utility for copying Database file to [...]
Answer Question
| May 27, 2012 9:37 AM
CSV, OS/400
Schedule SQL job to run and export to CSV file
Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!
Answer Question
| May 8, 2013 11:45 PM
CSV, SQL Jobs, SSMS 2008
Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!
Answer Question
| May 8, 2013 11:45 PM
CSV, SQL Jobs, SSMS 2008
Exporting a (.csv) file from SQL 2005
Hi, I’m trying to export date to a (.csv) file from SQL 2005 and I keep getting a carriage return and line feed after each record. I have been told that this may be because it is getting exported in Unicode rather than ASCII. I do not have reporting services on my box. I have [...]
Answer Question
| February 28, 2012 5:57 PM
CSV, SQL
Hi, I’m trying to export date to a (.csv) file from SQL 2005 and I keep getting a carriage return and line feed after each record. I have been told that this may be because it is getting exported in Unicode rather than ASCII. I do not have reporting services on my box. I have [...]
Answer Question
| February 28, 2012 5:57 PM
CSV, SQL
AS400 Shell command
Hi Iam using jar command to comprees the csv file to Zip file.in my program.iam submitting the job,usually it oftens fails for few files to zip.it gives me the error like qsh: 001-0012 Error found starting child process. System resources not available to complete request. So how can i solve this issue within in my [...]
Answer Question
| May 24, 2011 11:54 AM
AS/400 CSV, AS400 - STRQSH, AS400 Shell command, CSV, Shell commands
Hi Iam using jar command to comprees the csv file to Zip file.in my program.iam submitting the job,usually it oftens fails for few files to zip.it gives me the error like qsh: 001-0012 Error found starting child process. System resources not available to complete request. So how can i solve this issue within in my [...]
Answer Question
| May 24, 2011 11:54 AM
AS/400 CSV, AS400 - STRQSH, AS400 Shell command, CSV, Shell commands
Can we change length of CSV File
Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the [...]
Answer Question
| May 11, 2011 11:22 AM
AS/400, AS/400 DB2, CHGPF, CSV, CSV file format
Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the [...]
Answer Question
| May 11, 2011 11:22 AM
AS/400, AS/400 DB2, CHGPF, CSV, CSV file format
Finding a stream file CSV
i have a stream file in CSV format, we are not sure wheere this file is I have find out where this available in AS/400. I tryed wrklnk command and other options but i am not able to find this file. could you tell me the best way to find out this CSV stream file. [...]
Answer Question
| May 2, 2011 12:50 PM
AS/400, CSV, CSV format, Stream files
i have a stream file in CSV format, we are not sure wheere this file is I have find out where this available in AS/400. I tryed wrklnk command and other options but i am not able to find this file. could you tell me the best way to find out this CSV stream file. [...]
Answer Question
| May 2, 2011 12:50 PM
AS/400, CSV, CSV format, Stream files
Accessing abc.csv AS/400 files
how to access abc.csv files in as400.i have a abc.csv file,in this file have contain some data but i want to access into my physical file,with out using 3rd party tool.pls give advice
Answer Question
| April 6, 2011 4:49 PM
AS/400, AS/400 CSV, CSV, CSV file format
how to access abc.csv files in as400.i have a abc.csv file,in this file have contain some data but i want to access into my physical file,with out using 3rd party tool.pls give advice
Answer Question
| April 6, 2011 4:49 PM
AS/400, AS/400 CSV, CSV, CSV file format
Junk characters in CSV conversion through CPYTOIMPF
Hi, I am sending data from iseries to excel through CPYTOIMPF i’ve used this command in CLLE, in query output there is a char field value is ’01.03.2011′ but when i see in output by wrklnk temp it shows some junk data in this field . RUNQRY QRY(ADO150Q) CPYTOIMPF FROMFILE(ADO150F) TOSTMF(/temp/tst.csv) + MBROPT(*REPLACE) STMFCODPAG(*PCASCII) [...]
Answer Question
| March 15, 2011 10:05 AM
AS/400, CLLE, CPYTOIMPF, CSV, CSV file format, RUNQRY
Hi, I am sending data from iseries to excel through CPYTOIMPF i’ve used this command in CLLE, in query output there is a char field value is ’01.03.2011′ but when i see in output by wrklnk temp it shows some junk data in this field . RUNQRY QRY(ADO150Q) CPYTOIMPF FROMFILE(ADO150F) TOSTMF(/temp/tst.csv) + MBROPT(*REPLACE) STMFCODPAG(*PCASCII) [...]
Answer Question
| March 15, 2011 10:05 AM
AS/400, CLLE, CPYTOIMPF, CSV, CSV file format, RUNQRY
PM400 screen to print
PM400 option Print performance report displays the screen (below) to allow the user to drill down. This screen is a summary with interval of 15 minutes for a 24 hour period. I would like to copy the data lines (all entries for 24 hour period) data down to an Excel file (or .csv). Unfortunaltely, [...]
Answer Question
| February 11, 2011 2:04 PM
CSV, iSeries, iSeries printing, PM/400, V5R4M0
PM400 option Print performance report displays the screen (below) to allow the user to drill down. This screen is a summary with interval of 15 minutes for a 24 hour period. I would like to copy the data lines (all entries for 24 hour period) data down to an Excel file (or .csv). Unfortunaltely, [...]
Answer Question
| February 11, 2011 2:04 PM
CSV, iSeries, iSeries printing, PM/400, V5R4M0
Data report from iSeries to a CSV format need page breaks and colors
Hi, I have to send report to our clients in CSV format using data from iSeries. In iSeries I used a text file having one field of 1000 char and used commas as field separators. Is there any way I can send a code for page break once required? Can I do some thing to [...]
Answer Question
| February 10, 2011 2:39 PM
CSV, CSV file format, iSeries
Hi, I have to send report to our clients in CSV format using data from iSeries. In iSeries I used a text file having one field of 1000 char and used commas as field separators. Is there any way I can send a code for page break once required? Can I do some thing to [...]
Answer Question
| February 10, 2011 2:39 PM
CSV, CSV file format, iSeries
Excel 2007 – creating a graph from CSV data with a macro
I want to create a macro that will take a CSV file and remove the same columns each time. BUT the number of rows can vary. Can I create a macro that will create a grapgh ? The problem is, like i said before, the number of rows can vary each time but the number [...]
Answer Question
| January 26, 2011 4:31 PM
CSV, Excel 2007, Excel 2007 macros, Windows XP
I want to create a macro that will take a CSV file and remove the same columns each time. BUT the number of rows can vary. Can I create a macro that will create a grapgh ? The problem is, like i said before, the number of rows can vary each time but the number [...]
Answer Question
| January 26, 2011 4:31 PM
CSV, Excel 2007, Excel 2007 macros, Windows XP
Report / File repository for AS/400 V5R4
Currently we have a home grown web application where we send our reports from the AS400 so our clients can view them. They are converted into a Monarch format. We would like to replace this with something else. We need to be able to put out .csv files, .pbf files and other types in addition [...]
Answer Question
| December 20, 2010 9:33 PM
AS/400, CSV, CSV file format, Repository, V5R4
Currently we have a home grown web application where we send our reports from the AS400 so our clients can view them. They are converted into a Monarch format. We would like to replace this with something else. We need to be able to put out .csv files, .pbf files and other types in addition [...]
Answer Question
| December 20, 2010 9:33 PM
AS/400, CSV, CSV file format, Repository, V5R4
How to remove the double quotes in CSV file in iSeries
Hi The command is to remove the double quotes present in CSV file. I have used one shell command. Strqsh cmd(Sed -e ‘s/”"//g’ file name > new file name) I have to write this command in CLLE program. CHGVAR VAR(&RPLC) VALUE(‘Sed’ *BCAT ‘-e’ *BCAT + ‘s/”"//g’ *BCAT ‘/’ *TCAT &USER + *TCAT &WOUTFN [...]
Answer Question
| December 13, 2010 11:59 AM
AS400 program, CLLE, CSV, CSV file format, iSeries, Shell commands
Hi The command is to remove the double quotes present in CSV file. I have used one shell command. Strqsh cmd(Sed -e ‘s/”"//g’ file name > new file name) I have to write this command in CLLE program. CHGVAR VAR(&RPLC) VALUE(‘Sed’ *BCAT ‘-e’ *BCAT + ‘s/”"//g’ *BCAT ‘/’ *TCAT &USER + *TCAT &WOUTFN [...]
Answer Question
| December 13, 2010 11:59 AM
AS400 program, CLLE, CSV, CSV file format, iSeries, Shell commands
Exporting Active Directory user info to CSV
Can we export all of our AD data to a CSV file for backup purposes? Can we export the passwords as well? Will they be encrypted? Where can we find the encryption key so we can make heads or tales of them.
Answer Question
| September 28, 2010 4:15 PM
Active Directory User Profiles, CSV, Security in 2010, Windows, Windows Server 2008 R2, Windows Server Security, Windows Server User Profiles
Can we export all of our AD data to a CSV file for backup purposes? Can we export the passwords as well? Will they be encrypted? Where can we find the encryption key so we can make heads or tales of them.
Answer Question
| September 28, 2010 4:15 PM
Active Directory User Profiles, CSV, Security in 2010, Windows, Windows Server 2008 R2, Windows Server Security, Windows Server User Profiles
Import AD data from CSV file to 2003 ad
We have 3500 new ad users. How can we import their usernames, full names, phone numbers, email addresses from a CSV file.
Answer Question
| September 28, 2010 4:14 PM
Active Directory, Active Directory 2003, Active Directory Users, AD, CSV, Windows, Windows Server 2003
We have 3500 new ad users. How can we import their usernames, full names, phone numbers, email addresses from a CSV file.
Answer Question
| September 28, 2010 4:14 PM
Active Directory, Active Directory 2003, Active Directory Users, AD, CSV, Windows, Windows Server 2003
Zipping CSV to AS/400
Hi I have one doubt in zipping the CSV files… Iam keeping the daily running reports in My IFS called ABC folder. wrklnk ABC.This folder contains 10 csv files with date extension. Now i want to zip all this CSV files and FTP to another system. how to do this in AS400.? please help me [...]
Answer Question
| January 3, 2011 10:39 AM
AS/400 CSV, AS/400 FTP, CSV, Zip Files
Hi I have one doubt in zipping the CSV files… Iam keeping the daily running reports in My IFS called ABC folder. wrklnk ABC.This folder contains 10 csv files with date extension. Now i want to zip all this CSV files and FTP to another system. how to do this in AS400.? please help me [...]
Answer Question
| January 3, 2011 10:39 AM
AS/400 CSV, AS/400 FTP, CSV, Zip Files
Merging Excel or CSV file to Active Directory
How can I automatically add users email addresses to their active directory profile? Their email address is their first initial followed by their last name at our domain dot com. I can create an excel or csv file with the data necessary but how can I merge it into AD?
Answer Question
| September 8, 2010 1:32 PM
Active Directory, Active Directory migration, CSV, CSV file format, Excel functions
How can I automatically add users email addresses to their active directory profile? Their email address is their first initial followed by their last name at our domain dot com. I can create an excel or csv file with the data necessary but how can I merge it into AD?
Answer Question
| September 8, 2010 1:32 PM
Active Directory, Active Directory migration, CSV, CSV file format, Excel functions
