Welcome, Guest. Please Login.
05/16/25 at 15:28:54
News:
Home Help Search Login


Pages: 1
Send Topic Print
MR-A Import (Read 1219 times)
ahammond
Browser
*




Posts: 8
MR-A Import
05/30/06 at 09:34:15
 
In the MR-A Enter Forecast, I have a user that would like to use the import feature.  As described in the help files we have created a comma delimited text file with one line as follows:
 
A-40101,20060601,10  
 
Which are Item number, Date, Quantity.  
When I click Import Data I am prompted with the file name and location, Comma Delimited or Fixed Length and six more fields which are not mentioned in the help files.  I enter C for comma delimited and the left three fields appear to me to be field location or order in the file and the right three appear to fixed field length which should not aply to my Comma Delimited file.  I have tried 0,1,2 and 1,2,3 in the left column fields.  This is followed by a confirmation message box abnout the ISO date format required. Upon YES to this message screen falls back to MR-A screen and my new forecast item is nopt in list.  What am I missing?  What are the six fields supposed to be?
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: MR-A Import
Reply #1 - 05/30/06 at 12:59:31
 
Comma Delimited should be the 1,2,3 in the left column and nothing on teh right side.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
ahammond
Browser
*




Posts: 8
Re: MR-A Import
Reply #2 - 06/02/06 at 10:12:21
 
I supply a comma delimited file with only one line.
 
A-40102,20060631,10
 
I enter "C" for Comma Delimited and then enter 1,2,3 in the left fields and 0,0,0 in the right fields, then answer YES to the ISO Date warning message and nothing happens. I am returned to the MR-A main screen and the forecast from the import file is not in the list.  How can I make this work?
Back to top
 
 
  IP Logged
Cyndee Pappas
Senior Member
****


EVO~ERP 2006.1
02/28/06 update

Posts: 258
Gender: female
Re: MR-A Import
Reply #3 - 06/02/06 at 11:32:02
 
Your first post has a date of 20060601, but the second is 20060631. Maybe it validates the date?
Back to top
 
 

Cyndee Pappas
Industrial Data Systems
EVO~ERP 2006.1 with 02/28/06 update
Client/Server Win2000 Server
Pervasive SQL 2000i

WWW   IP Logged
JEMM
Administrator
*****


In two days from
now, tomorrow will
be yesterday.

Posts: 225
Gender: male
Re: MR-A Import
Reply #4 - 06/05/06 at 08:34:47
 
The imported dates must be greater than or equal to the current date and must also be a valid date.  June 31 is not a valid date.
 
Mike
Back to top
 
 

Mike
ISTechSupport
Email   IP Logged
ahammond
Browser
*




Posts: 8
Re: MR-A Import
Reply #5 - 06/05/06 at 11:02:09
 
OK I had an invalid date the seccond time. Now I am supplying this one line txt file.
 
A-40102,20060701,10
 
All fields are valid.  I enter "C" for Comma Delimited and then enter 1,2,3 in the left fields and 0,0,0 in the right fields, then answer YES to the ISO Date warning message and nothing happens. I am returned to the MR-A main screen and the forecast from the import file is not in the list.  No errors or messages of any kind.
 
Has this worked for anyone else?
Back to top
 
 
  IP Logged
JEMM
Administrator
*****


In two days from
now, tomorrow will
be yesterday.

Posts: 225
Gender: male
Re: MR-A Import
Reply #6 - 06/05/06 at 11:25:23
 
The part must be a vaild part (i.e. exist in BKICMSTR) and not be a type K or type B.
 
Mike
Back to top
 
 

Mike
ISTechSupport
Email   IP Logged
ahammond
Browser
*




Posts: 8
Re: MR-A Import
Reply #7 - 06/14/06 at 06:30:05
 
The item is listed in IN-A and is a Type R, what else?
Back to top
 
 
  IP Logged
ahammond
Browser
*




Posts: 8
Re: MR-A Import
Reply #8 - 06/29/06 at 06:50:32
 
Any suggestions to solve this problem or will it just never work?
Back to top
 
 
  IP Logged
Tim Keating
Senior Member
****


DBA CLASSIC WIN 2000
C/S

Posts: 298
Re: MR-A Import
Reply #9 - 06/29/06 at 07:52:26
 
Sounds pretty frustrating.  I have imported CSV files at least 200 times so I know it works.
 
I don't see anything wrong on your 6/5 post as long as your system date is correct and the part is valid.
 
Does your file have a CSV extension?
 
The only thing that ever trips me up is typing the path correctly.  If I type the path wrong, I get the same results you describe.
 
Here is a screenshot of my path:
 

 
Back to top
 
 

Tim Keating
Motor Guard Corporation
Email WWW   IP Logged
ahammond
Browser
*




Posts: 8
Re: MR-A Import
Reply #10 - 07/10/06 at 10:33:05
 
I am using a file name of MRA.TXT and it was in my local c: so I was supplying a path of C:\MRA.TXT.  After seeing your path I copied this file to the network share so now my path is P:\Default\MRA.TXT and the import worked.  I added several more lines and imported a second time just to test and it now works correctly.
 
Thanks!
Back to top
 
 
  IP Logged
shadowcaster
Active Member
*****


I'm not here because
I know what to do.

Posts: 678
Gender: male
Re: MR-A Import
Reply #11 - 07/10/06 at 13:27:13
 
It depends on where your csv file is located.
 
j Dub
 
Back to top
 
 
WWW   IP Logged
Pages: 1
Send Topic Print