[SAGE] .pnm file import
OFO
-
aleuredelinformatique Posted messages 2 Status Membre -
aleuredelinformatique Posted messages 2 Status Membre -
Hello,
I'm looking to convert a .txt file into a .pnm file for import into SAGE line 100. How can I do that? Do you have an example of a script that does this? Can we directly import a .txt file into SAGE line 100 (I believe we can do that in line 500). How do we retrieve the correct format for the .pnm file (depending on the fog parameter settings)?
Thank you in advance for your responses.
Best regards,
Ofo
I'm looking to convert a .txt file into a .pnm file for import into SAGE line 100. How can I do that? Do you have an example of a script that does this? Can we directly import a .txt file into SAGE line 100 (I believe we can do that in line 500). How do we retrieve the correct format for the .pnm file (depending on the fog parameter settings)?
Thank you in advance for your responses.
Best regards,
Ofo
14 réponses
Hi OFO, hi to the Forumers,
Your txt file, where does it come from?
If it's an export from Sage L100, it is formatted with one zone per line, with a specific format and a file start flag followed by a record identification flag "#xxxx".
This file can be directly imported in the File -> Import -> Sage Line 30 and 100 option.
The PNM file is a file that presents one record per line of writing.
Give us this answer and I will forward the formats of the TXT and PNM files.
Phil
Your txt file, where does it come from?
If it's an export from Sage L100, it is formatted with one zone per line, with a specific format and a file start flag followed by a record identification flag "#xxxx".
This file can be directly imported in the File -> Import -> Sage Line 30 and 100 option.
The PNM file is a file that presents one record per line of writing.
Give us this answer and I will forward the formats of the TXT and PNM files.
Phil
mihaela,
If the PDF file is a table, it means it is a GSI payroll statement. This means that this table can be exported by the external firm in the form of a text file or an Excel sheet. Therefore, it is unnecessary to ask them for a PNM file, because they are unaware of a format that is not native to GSI (we are not from the same world!!!).
This is where the file format description comes in. I’m giving you a link where you can download a ZIP file containing the format description and a sample file.
( http://segs.free.fr/Pages/segs-documentation.html )
Now, you just need to write a script to handle the conversion. If you can do that, you should have what you need; otherwise, get in touch via private email (the little envelope on the post) to see what we can do for you.
Phil
Thank you for this response; in fact, I am the one generating the data file from a JAVA application. I managed to write directly in .PNM format (indeed with one line per write); I am currently testing it and it should work.
I will keep you updated...
See you later
OFO
I will keep you updated...
See you later
OFO
Hi Ofo,
I'm looking, like you, to integrate a JAVA application with the SAGE 100 accounting software (version 13.0.1). My first choice would be to import a file in XML format.
Is this a format supported by SAGE? Would SAGE have a library/API in JAVA or others, regardless, to automate the import of such a file?
Otherwise, what would be the best format choice in your opinion? I see that you chose the pnm format? It's a text format, I imagine?
Thank you.
I'm looking, like you, to integrate a JAVA application with the SAGE 100 accounting software (version 13.0.1). My first choice would be to import a file in XML format.
Is this a format supported by SAGE? Would SAGE have a library/API in JAVA or others, regardless, to automate the import of such a file?
Otherwise, what would be the best format choice in your opinion? I see that you chose the pnm format? It's a text format, I imagine?
Thank you.
Hi Yann,
Charges from this link:
http://rapidshare.de/files/30730378/Format_PNM.pdf.html
See you later
Phil
Charges from this link:
http://rapidshare.de/files/30730378/Format_PNM.pdf.html
See you later
Phil
Hello ppa,
You seem to know a lot about SAGE...allow me to ask for your opinion.
I'm looking to integrate a JAVA application into the SAGE 100 accounting software (version 13.0.1). My first choice would be to import forms into SAGE in XML format.
Is this a format supported by SAGE?
If not, what would be the best choice in your opinion?
Unfortunately, we've lost the software user manual...could you tell me where I could find it?
I found this http://segs.free.fr/Fichiers/sommairc.pdf online...but it's not very detailed.
Thank you.
You seem to know a lot about SAGE...allow me to ask for your opinion.
I'm looking to integrate a JAVA application into the SAGE 100 accounting software (version 13.0.1). My first choice would be to import forms into SAGE in XML format.
Is this a format supported by SAGE?
If not, what would be the best choice in your opinion?
Unfortunately, we've lost the software user manual...could you tell me where I could find it?
I found this http://segs.free.fr/Fichiers/sommairc.pdf online...but it's not very detailed.
Thank you.
Good evening,
The management of XML files appeared in version 14 for Export, I don't think we can import them.
3 possible incorporation solutions:
- Import txt Sage Format (Flag format): the definitions can be found in the PDF manual.
- Import txt Configurable format (Manages fixed width and length as well as delimited): But can only import General accounts, Third parties, Analytical accounts, and entries.
- ODBC Link: Equipped with the ODBC Driver for your version of accounting makes it available in Open Data Source. Create a source by pointing to the accounting file(s) (PDF manual: Line structure 100 for table correspondence. Note: Take the PDF for the correct Version)
The management of XML files appeared in version 14 for Export, I don't think we can import them.
3 possible incorporation solutions:
- Import txt Sage Format (Flag format): the definitions can be found in the PDF manual.
- Import txt Configurable format (Manages fixed width and length as well as delimited): But can only import General accounts, Third parties, Analytical accounts, and entries.
- ODBC Link: Equipped with the ODBC Driver for your version of accounting makes it available in Open Data Source. Create a source by pointing to the accounting file(s) (PDF manual: Line structure 100 for table correspondence. Note: Take the PDF for the correct Version)
Hello,
My problem concerns converting a .pdf file to .pnm to then integrate it into Sage.
The original file (in .pdf) contains payroll entries.
Do you know a way to perform this conversion?
Thank you in advance.
My problem concerns converting a .pdf file to .pnm to then integrate it into Sage.
The original file (in .pdf) contains payroll entries.
Do you know a way to perform this conversion?
Thank you in advance.
Good evening Mihaela,
1st question:
- Is the PDF file a spreadsheet or does it conform to the specific .PNM format?
2nd question:
- Is the payroll a Sage payroll?
3rd question:
- If the payroll is indeed in Sage, why not directly retrieve the file provided by payroll in .PNM?
And finally:
- Do you have the file format description or would you like me to send it to you?
Phil
1st question:
- Is the PDF file a spreadsheet or does it conform to the specific .PNM format?
2nd question:
- Is the payroll a Sage payroll?
3rd question:
- If the payroll is indeed in Sage, why not directly retrieve the file provided by payroll in .PNM?
And finally:
- Do you have the file format description or would you like me to send it to you?
Phil
Good evening Phil,
Thank you for your response.
1) The PDF file is a normal PDF file (I think it’s a table);
2) Payroll is outsourced (5ADPGSI -ZADIG) and I don’t know what software they use;
3) I asked to have the file directly in PNM but they always sent it in this format because apparently it was processed internally... except that the person who did it is no longer there and no one knows how to do the conversion!
4) The description of the file?
Thank you.
M
Thank you for your response.
1) The PDF file is a normal PDF file (I think it’s a table);
2) Payroll is outsourced (5ADPGSI -ZADIG) and I don’t know what software they use;
3) I asked to have the file directly in PNM but they always sent it in this format because apparently it was processed internally... except that the person who did it is no longer there and no one knows how to do the conversion!
4) The description of the file?
Thank you.
M
Hello Mihaela,
We are going to implement the hypervision tool from adp-gsi.
I wanted to know if you have set up the process between hypervision and sage accounting for the conversion?
If so, could you share your expertise with me? :)
Thank you for your response.
Houda
We are going to implement the hypervision tool from adp-gsi.
I wanted to know if you have set up the process between hypervision and sage accounting for the conversion?
If so, could you share your expertise with me? :)
Thank you for your response.
Houda
Yes, there was already software that we had purchased but that I wasn't aware of. So now everything is fine.
How could I talk to you?
M
How could I talk to you?
M
Hello,
I also have a problem with Sage.
I'm using Sage Intégrale 5.00.0.50 at work and I was asked to send the data from a work order in Excel to this database to avoid double data entry.
In my research, I found that this is possible through an ODBC bridge in a specific format.
Could someone provide me with more details?
Thank you in advance.
I also have a problem with Sage.
I'm using Sage Intégrale 5.00.0.50 at work and I was asked to send the data from a work order in Excel to this database to avoid double data entry.
In my research, I found that this is possible through an ODBC bridge in a specific format.
Could someone provide me with more details?
Thank you in advance.
Hello chris67240,
I just discovered your request.
A specific ODBC driver from Sage indeed allows reading information from the proprietary database of Intégrale V5.
However, on an Intégrale using MsSQL or Oracle, it is the drivers for those databases that enable writing.
See you later
Phil
--
Wisdom is not a gift. It is learned, patiently, by listening to those around us and
doing, retrospectively, through things. So let us be Wise.
I just discovered your request.
A specific ODBC driver from Sage indeed allows reading information from the proprietary database of Intégrale V5.
However, on an Intégrale using MsSQL or Oracle, it is the drivers for those databases that enable writing.
See you later
Phil
--
Wisdom is not a gift. It is learned, patiently, by listening to those around us and
doing, retrospectively, through things. So let us be Wise.
In the latest versions I had to use,
I was forced to create scripts to pass the data in a specific format (fields of a certain length in a particular order) by filling in with spaces to create a file that is then integrated into Sage.
I had created my script from a Windev program.
The problem is that the transition file has a format that can change from one evolution of Sage to another.
I was forced to create scripts to pass the data in a specific format (fields of a certain length in a particular order) by filling in with spaces to create a file that is then integrated into Sage.
I had created my script from a Windev program.
The problem is that the transition file has a format that can change from one evolution of Sage to another.
Can you help me convert my Excel file to Pnm format in Access? I’m told the file is read-only.
Help.
Thank you.
Who told you that your file is read-only? And which file?
What does your Excel file look like?
Phil
My procedure is as follows:
1. I create an .xls file in Excel with the columns corresponding to the entries that need to be processed in accounting according to the format below:
See attached file N° Excel format
2. I go to Access, and I create a table with the same columns.
3. I copy the data from the Excel file into the table.
4. In Access, I export the aforementioned data but formatting the file according to an export specification format to comply with the character count for each element of my table.
However, when I need to save, I change the file extension from .txt to .pnm so that Saari accepts it during import. But at that moment, I get a message refusing to rename the extension, saying "the file or object is read-only."
That's my problem.
Thank you for your help
doudou DIOP