ralphsauto
asked on
Simply Accounting import Transactions
Does anyone know the format of the import function for Simply accounting 2004 basic. It seems to be a XML format.
Please help asap
Please help asap
Hi: are you making any progress?
Mike
Mike
ASKER
I have already looked at this format at the site you mentioned before I posted this message. There is something wrong with this as the person using it couldn't get it to work either. The problem is what goes where, can you supply me with this information?
Thanks
John
Thanks
John
John,
Ugh this is one of the most unfrendly systems I've seen for importing info too.
Not much help but mabey gives an idea?
http://www.simplyaccounting.com/techsupport/kb/d_kbeditor.asp?xkbid=10252
Choose simply accounting (bottom Solution Set choice) and type in import and you can see all 8 suggestions there.
http://www.simplyaccounting.com/techsupport/kb/kbsrch.asp
If your withing the first 30 days of *any* purchase you might have a shot at their toll free phone support http://www.simplyaccounting.com/ce/support/default.asp
Their forum might have someone that has tried to do this before but it appears you need to sign up :-(.
http://www.simplyaccounting.com/_mem_bin/default.aspx?page=http://www.simplyaccounting.com/_mem_bin/CheckIfAuthenticated.aspx
According to this review the sales order import funcanality is limited.
http://www.accountingsoftwareanswers.com/asa/simply_full.htm
Doesn't look like fun at all.
What are you trying to do? Did you check that all the information required by the import already exists in the database?
Turn123
Ugh this is one of the most unfrendly systems I've seen for importing info too.
Not much help but mabey gives an idea?
http://www.simplyaccounting.com/techsupport/kb/d_kbeditor.asp?xkbid=10252
Choose simply accounting (bottom Solution Set choice) and type in import and you can see all 8 suggestions there.
http://www.simplyaccounting.com/techsupport/kb/kbsrch.asp
If your withing the first 30 days of *any* purchase you might have a shot at their toll free phone support http://www.simplyaccounting.com/ce/support/default.asp
Their forum might have someone that has tried to do this before but it appears you need to sign up :-(.
http://www.simplyaccounting.com/_mem_bin/default.aspx?page=http://www.simplyaccounting.com/_mem_bin/CheckIfAuthenticated.aspx
According to this review the sales order import funcanality is limited.
http://www.accountingsoftwareanswers.com/asa/simply_full.htm
Doesn't look like fun at all.
What are you trying to do? Did you check that all the information required by the import already exists in the database?
Turn123
ASKER
Hello Turn123,
Thanks for your answers, They are a little late. I have already found these pages and the one that helped teh most is the first one. There are a couple of things that people need to know in order to import into Simply Accounting.
1. You can only import directly into the General Journal, unless you have the email system setup (described above)
2. The file imported must be CSV format
3. The totals must balance exactly any discrepancy and you are toast.
4. The format for the xml import is hidden in secrecy so you can't import into sales or expenses, just the General Journal which doesn't apply the information to any other module.
ACCPAC's Simply Accounting is a good tool if you are not using any external programs to create data.
If you can find/decifer the format for the xml import I am extremely interested.
Thanks for your answers, They are a little late. I have already found these pages and the one that helped teh most is the first one. There are a couple of things that people need to know in order to import into Simply Accounting.
1. You can only import directly into the General Journal, unless you have the email system setup (described above)
2. The file imported must be CSV format
3. The totals must balance exactly any discrepancy and you are toast.
4. The format for the xml import is hidden in secrecy so you can't import into sales or expenses, just the General Journal which doesn't apply the information to any other module.
ACCPAC's Simply Accounting is a good tool if you are not using any external programs to create data.
If you can find/decifer the format for the xml import I am extremely interested.
ralphsauto,
I'm sorry I can't help more :-(.
It is usually a good idea to request that your question be PAQd and your points refunded as soon as you find your answer to prevent someone looking for the answer for you when you already have it as it is discouraging to look for an answer only to find that the asker has already found the answer and you wasted your time. :-)
If you want to PAQ this question, post a zero-point question in https://www.experts-exchange.com/Community_Support/
Subject: Moderator Please PAQ
Body: Please PAQ this question:
https://www.experts-exchange.com/questions/21365139/Simply-Accounting-import-Transactions.html
~~~Turn123
I'm sorry I can't help more :-(.
It is usually a good idea to request that your question be PAQd and your points refunded as soon as you find your answer to prevent someone looking for the answer for you when you already have it as it is discouraging to look for an answer only to find that the asker has already found the answer and you wasted your time. :-)
If you want to PAQ this question, post a zero-point question in https://www.experts-exchange.com/Community_Support/
Subject: Moderator Please PAQ
Body: Please PAQ this question:
https://www.experts-exchange.com/questions/21365139/Simply-Accounting-import-Transactions.html
~~~Turn123
ASKER
Sorry Turn123,
This question was online for about 2 months and was hoping for a quicker answer than that. I was also unaware I could do what you said, regarding the PAQ. I am still looking for the format of the XML import though and that is what the original questions is about.
Ralphsauto
This question was online for about 2 months and was hoping for a quicker answer than that. I was also unaware I could do what you said, regarding the PAQ. I am still looking for the format of the XML import though and that is what the original questions is about.
Ralphsauto
ASKER
The main problem with this import is I was looking for a way to import directly into two modules Sales and Payables. Simply Accounting simply does not do it unless you are using Simply to send an email and receive an email and it needs to have specific header information with a check digit.
The answer to an import using XML is that you can't. It has to be a Text file with the following format and follows the CSV (comma separated values) format
for expenses:
Date, "short des (9 char)", "Long Decription (39 Characters)"
Account number, Amount
Bank Number, neg Amount
for Sales:
Date, "short des (9 char)", "Long Decription (39 Characters)"
Account number, neg Amount
Bank Number, Amount
The last thing that you need to know is that the file being imported can only be imported into the General Journal
I wish to apologize to the two people who tried to answer the question I posted. I needed to have the answers right away, I didn't expect Simply Accounting to have such limitations for importing. The program is almost useless if you want to create a web-interface for it.
The answer to an import using XML is that you can't. It has to be a Text file with the following format and follows the CSV (comma separated values) format
for expenses:
Date, "short des (9 char)", "Long Decription (39 Characters)"
Account number, Amount
Bank Number, neg Amount
for Sales:
Date, "short des (9 char)", "Long Decription (39 Characters)"
Account number, neg Amount
Bank Number, Amount
The last thing that you need to know is that the file being imported can only be imported into the General Journal
I wish to apologize to the two people who tried to answer the question I posted. I needed to have the answers right away, I didn't expect Simply Accounting to have such limitations for importing. The program is almost useless if you want to create a web-interface for it.
ASKER
Sorry one last point the Totals for the amounts need to balance, no exceptions.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
For example, this is a sales order file (which I found at
http://www.accountingsoftware411.com/AS411Msgbrds.nsf/msgBoards_vw/00619BC9CBFFA56D85256CB7005FE79F?OpenDocument ):
<Version>
"9001","1"
</Version>
<SalOrder>
"Lawn Maintenance Company", , , ,"Ontario", , , , ,
"1","2","1-1-2003", ,"3789.25","0.00"
"1000","1.0000","3295.0000
</SalOrder>
If you have access to the program, and can create the required transaction, *and* email it to yourself, then you can see the format from the file, and work out what the fields represent.
Regards
Mike