Title: Looking To Upload Information For Gl08-gl09
Description: upload programs for gl08-gl09
Linda - January 16, 2006 06:17 PM (GMT)
Hi All!
We are 8.03, msp10, ser.pk 4.
Can anyone tell me the programs I will need to run to bring in a csv file for both gl08 and glo9.
I have the information to create the csv files but not sure of the programs to do the uploads. This process was done over 6 yrs ago and the person or persons that ran it are no longer here. If anyone can share this information with me I would greatly appreciate it.
jkerry - January 17, 2006 03:21 AM (GMT)
Well there are a couple of ways to upload into these screens.
1) Use the Addins Tool
2) Use importdb to upload a CSV file to the underlying tables. I don't remember what they are off the top of my head but you can do a dburf to find that out:
dburf <productline> <systemcode> <program name> | lashow
This should tell you what the primary tables are and then you can just upload a correctly formatted CSV file into them. I can't believe I have forgotten the names of these tables. :banghead:
Linda - January 17, 2006 06:08 PM (GMT)
The files I hope are glacctrel and glcompril. I will try this in test by using importdb and see if it works.
lawson - January 17, 2006 06:18 PM (GMT)
yes those are the files and it should work great as long as you format your CSV file correctly before you import. I would create a backup of those two tables before starting just in case. In the future post questions like this to the Financial/GL forum.
Linda - January 18, 2006 03:32 PM (GMT)
thanks for the answer, and I'm sorry for posting in this section, however I must have overlooked the section for gl I did not see it listed.